Jul 2017 – Dec 2021 · 4 yrs 5 mos · Noida Area, India

•  Leading the advance analytics practice as well as managing Reporting & Data Enablement team for one of the major pharma players in the US market
•  Managing a suite of in-house developed dashboards in Tableau and SQL to oversee the operational metrics and KPIs across the pharma business
•  Designed the Data Engineering architecture of US REMS datasets single handedly by processing multifarious raw datasets using SQL & Alteryx for Myeloma brands.
•  Created data pipeline and dashboard to measure effective sales reach-outs.
•  Manage Sales Support team which provides tech support to Field REPs with their inquiries related to various Field Reports, data inquiry with vendors, data gap analyses, customer master maintenance, etc.
•  Working closely with client’s brand team on product optimization of various brands by comparing sales, market share, tracking launch, prices, etc. including a formulation switching analysis to understand how a new product/formulation when introduced in market drives the patient switching
•  Collaborating with multiple stakeholders across the client organization to stitch tailor-made solutions and collaborate with data vendors to provide BI support to client

Jan 2015 – May 2017 · 2 yrs 4 mos · Noida Area, India

•  Worked as a Business Analyst and Tech Lead for multiple clients for client requirement gathering and analysis, implementing change orders, reporting and defect Management.
•  Experience in requirement gathering and analyzing the client requirements to map with the current system.
•  Involved in client interactions for better understanding of requirements and weekly updating the client managers regarding the process made in the project.
•  Experience in working on Dev-Ops / Agile operation process and tools area (code review, unit test automation, build & release automation, Environment service, incident and change management).
•  Roadmap development – analyze gaps, impact analysis after understanding customer requirement & input to strategic plan for BI tools, plus cross team collaboration on long-term solutions viability.
•  Prepare the Analysis document as per the requirements and provide handoff to other teams.
•  In depth review of BRD to identify gaps in the system and requirements and was extensively involved with QA team in preparing test strategy and test cases at different levels

Oct 2013 – Jan 2015 · 1 yr 3 mos · Noida Area, India

•  Configuring and testing Aon Hewitt's proprietary Total Benefit Administration (TBA) System based on analysis document and client requirements.
•  Provided full administrative support in respect of Employee Benefits by reviewing the analysis documents prepared by the Systems Analyst and configures (using graphic user interface tools) the TBA System to fix a system defect or complete a client request/change. Completes high level testing to ensure no major defects are in the code.
•  Performed analysis on large data and executing test plan (including regression testing) by identifying/creating test participants and performing calculations for expected results. Determine if configuration performs accurately, reflects requirements, and has zero negative impact to existing provisions.
•  Validate data from database using SQL and performed back-end testing by running SQL queries

Jan 2013 – Jul 2013 · 6 mos · Gurgaon, India