Jul 2022 – Sep 2023 · 1 yr 2 mos

Mar 2021 – Jul 2022 · 1 yr 4 mos

• Make Ocrolus data driven

Oct 2020 – Feb 2021 · 4 mos · Gurugram, Haryana, India

• As a freelance consultant of data analytics, I helped the firm create data and analytical process

Jul 2018 – Oct 2020 · 2 yrs 3 mos

• As an analytics expert in Recovery and Transformation Services, I help clients (across finance, insurance, etc.) in managing large scale transformation by analyzing large data set across various divisions. Create visually appealing reports, dashboards and power point presentations for Board members and C-level executives that help in large scale decision making. Extensive experience in working on-site with clients in US, Europe and Asia
• Apart from this help with internal initiatives of the firm in training and mentoring new folks
• Primary skills: Advance excel, VBA, Alteryx, Tableau, Power Point, SQL
• Key responsibility:
• Manage stakeholders including EVP, SVP, CEO, CFO senior associates, and help them with reports, dashboards and presentations
• Be the "Go to guy" for all the analytics related queries, business rules in any metrics/KPI
• Lead various meetings with clients on requirements and problem solving
• Guide clients on how to create data pipeline, best industry solutions
• Proactively report any inconsistency in data and highlight major factors causing discrepancy in any business metrics
• Help create new ideas and redesign process to improve operational cost or improve performance
• Lead the functional and reporting team of 5 plus members with daily status tracking, monitoring the scope of work, do sign offs on milestone deliverables
• Responsible for data quality, accuracy of numbers, work distribution in team, day to day team management tasks

Aug 2016 – Jun 2018 · 1 yr 10 mos

Apr 2014 – Jul 2016 · 2 yrs 3 mos · Gurgaon, India

• As a Team Lead of analytical reporting and data visualization, I have implemented analytical model for many fortune 500 pharmaceutical companies which help them make decision on sales and marketing of products, managed markets, insurance, patient life-cycle, compliance monitoring, financial management using Alteryx, Tableau, Excel/VBA.
• Primary Skills: Tableau, Excel, VBA, Alteryx
• Interact with Clients and stake holders to get problem/design requirements and design mock dashboards using Tableau/Excel/VBA
• Design and implement visually appealing dashboards in Tableau and Excel for easy communication of the results
• Help various clients to do analysis for launching a drug and decide the business rules for any metric
• Worked on Specialty Pharmacy data and helped the clients for their day to day analysis in the project
• Optimize different reports depending on the requirements.
• Work distribution, timeline management & status reporting to the client.
• On demand (Adhoc) business analysis
• Create custom tools as per requirement using VBA
• Lead the Tableau Center of Excellence division of the firm for India office.
• Deal with data set relevant to Payer, Specialty Pharmacy, Managed Markets, Compliance Monitoring, Speakers Program, Federal Reporting

Aug 2013 – Mar 2014 · 7 mos · Bangalore

• As an analyst from Bangalore office, I worked for an e-retail client and helped them increase their online sales by analyzing past sales data using Excel. Along with this, my role was to maintain overall quality of the development of their e-commerce website by analyzing the defect and progress of project.
• Primary Skills: Excel, VBA
• Key Responsibilities:
• Interact with client and key stakeholders to understand their requirements.
• Design dashboards using Excel representing metrics related to sales and issues
• Find out the products which are often bought together
• Handle all the quality checks applied and their progress to the client.
• Create excel reports describing the test analysis and management report for the users