Goal-oriented and data-driven healthcare analytics expert with over nine years of diverse experience within the U.S. Pharmaceutical industry. Adept at analyzing customer requirements, driving technology roadmaps, and managing stakeholder expectations. Other skills include data analysis, insight generation, and reporting.
Industry and Project Experience
IT & Services provider Dec 2010 – Present
IT & Services provider, Chicago, USA Lead Analyst Nov 2016 – Present
⦿ Led implementation of Asembia-7, a workflow management platform for tracking pharmacy operations and patient management.
⦿ Responsible for fit-gap analysis of features, data mapping, and development of Bl reports/ETL jobs.
⦿ SAS to Ta lend Migration: Re-engineered ETL processes and optimized data transformations and built Data Marts to streamline access and consumption.
⦿ Integrated payer, provider, and 3rd party data such as IQVIA/IMS, Medicare, Medicaid to reduce the cost of data management.
⦿ Sales Analytics: Automated incentive-based compensation process in SAS to reduce risk of over- & under-payment to Sales team; resulted in saving USD 7.2 Mn in overpayments in the first quarter after implementation.
⦿ Federated pharmacy operations (Script Med) and clinical data to build Cog nos Bl dashboards for generating insights into referrals and dispense of specialty drugs.
⦿ Transformed team’s role from descriptive to prescriptive analytics support by automating weekly Business Intelligence reports using SQL and Tableau, which led to a 40% reduction in man-hours per week.
⦿ Developed Cog nos framework models, recommended alternatives to improve performance of Cognos list & drill through reports.
⦿ Involved in gathering business requirements, interpretation of the data, and generating insights to implement scalable solutions.
IT & Services provider, Noida, India Senior Analyst Dec 2010 – Oct 2016
⦿ Led the implementation of Script Med Specialty Pharmacy platform for client’s retail vertical to efficiently manage services across multiple dispensing venues.
⦿ Automated reporting process by creating dashboards in Cognos Report Studio and Cog nos Query Studio; Mapped different data sources to track business KPIs and derive actionable insights; reduced reporting time by 66%.
⦿ Created interactive Tableau dashboards to analyze territorial, disease, and payer level data; used SAS Enterprise guide and Proc SQLs for ETLjobs and data transformation.
⦿ Developed statistical routines using SAS macros to track performance KPIs, enabling data-driven decision making and reduced reporting time by ~30%.
⦿ Enhanced pharmacy application using ProC and implemented EPCS (Electronic Prescription for Controlled Substance) for mail order pharmacy and MCA (Mandatory Consultation application) guidelines.