Swapnil Srivastava

Operations Associate

Pune, Maharashtra, India4 yrs 9 mos experience

AI EnabledAI ML Practitioner

Key Highlights

Led collaboration across 12+ markets for a $30M HPV market.
Automated campaign analytics, reducing reporting time by 50%.
Developed a global financial insights platform for 50+ leaders.

Stackforce AI infers this person is a Data Analytics and Business Intelligence professional in the Healthcare and Supply Chain sectors.

Contact

Skills

Core Skills

Business Intelligence (bi)Data Analytics

Other Skills

Amazon RedshiftAnalytical SkillsBenchmarkingCampaign AnalyticsCategory ManagementCustomer EngagementDAXDBeaverData AnalysisData CleaningData Intelligence PlatformData Management PlatformsData MiningData ModelingData Security

About

Data Science & Business Intelligence professional with 4+ years of experience in Pharmaceutical & Supply Chain Analytics. Skilled in Power BI, SQL, and Data Storytelling, with a strong focus on automating workflows, building insightful dashboards, and driving data-driven decision-making. Currently working at MSD Pharmaceuticals, where I design BI solutions, streamline data pipelines, and collaborate with global stakeholders to enhance marketing & financial insights. Passionate about leveraging analytics for strategic impact and solving business problems through data. 📩 Open to exploring Data Analytics, Business Intelligence & Consulting roles On the other front, I love backpacking across terrains and pique my interest with some cerebral art.

Experience

Msd

2 roles

Associate Manager II - Commercial AI Capabilities

Nov 2025 – Present · 4 mos

Associate Manager - Commercial AI Capabilities

Nov 2023 – Nov 2025 · 2 yrs

Leadership & ROI Growth: Led stakeholder collaboration across 12+ EEMEA markets for the HPV market of $30M, aligning marketing and finance strategies, driving a 20% increase in ROI and contributing to a $10M revenue uplift.
Operational Efficiency: Automated the campaign analytics pipeline by integrating SQL, Power BI, and Python, reducing manual effort by 50%, cutting reporting time from 5 days to 3.25 days, and improving data-driven decision-making, accelerating campaign optimizations by 30%.
Market Penetration: Designed and launched the HCP and HCC Engagement View for the Winrevair launch in Germany, enabling real-time tracking for 5,00+ HCPs, reducing manual efforts by 60%, and delivering insights 3x faster for sales and marketing teams
Global Platform Development: Spearheaded the development of a global financial insights platform, empowering 50+ senior leaders to track Sales, ROI, and P&L metrics across 3 franchises (Oncology, Vaccines, and Pharma), leading to a 15% faster decision-making cycle and optimizing $500M+ in budget allocation.
Data Security: Strengthened data security by implementing Role-Based Access Control (RBAC) and enhancing compliance measures, reducing data breach risks by 40% and ensuring 100% audit compliance across financial reporting systems.

Stakeholder ManagementSQLPower BIPythonData-Driven Decision MakingCampaign Analytics+4

Gep worldwide

2 roles

Analyst - Knowledge Management

Promoted

Sep 2022 – Nov 2023 · 1 yr 2 mos · India

Co-led and mentored 6 team members and 4 interns, driving data capture, analytics, and Power BI concepts in Price Benchmarking.
Initiated and co-executed the replacement of the internal Vision platform with a Power BI-integrated SharePoint portal, optimizing internal price benchmarks.
Acted as SPOC for functional communication, requirement and project escalation with stakeholders.
Designed and deployed 28+ Power BI online service dashboards, statistically and visually analyzing supplier engagement & market trends for informed decision-making by utilizing DAX functions like CALCULATE(), FILTER(), PERCENTILEX.INC(), and features like What-if Parameter, Power Query, and M Query.
Successfully created Golden Records and Dashboards for 5 new categories under Price Benchmarking, identifying key attributes from project files.

Power BIData AnalysisStakeholder CommunicationDAXData VisualizationData Analytics

Associate Analyst - Knowledge Management

Jun 2021 – Sep 2022 · 1 yr 3 mos · India

Interacted with stakeholders and implemented Category knowledge to prepare data pipeline & update Golden Records across 50 + categories.
Spearheaded data analysis efforts, transforming raw data into a structured format for downstream processing and statistical reporting, resulting in a data quality rate consistently above 90%.
Collaborated with senior leadership to create a new Holistic Supplier Rationalization tool using PBI Service features, such as navigations, trend forecasting, and presenting it for client acquisition.
Managed 58 databases and 52 dashboards using MS Azure & SSMS. Modeled, built, and migrated Power BI Dashboards for 4 New Categories to the internal analytics platform using Visual Studio.
Strengthened the project pipeline by assessing and extracting project files across 56 categories. Assisted consultants, stakeholders, and leaders with benchmark requests.
Active CAG (Category Advisory Group) member at GEP, leveraging Category Understanding for IT/Telecom, Logistics, and REFM.

Data AnalysisPower BIDatabase ManagementStakeholder EngagementData Analytics

Self

Freelance Reporting Analyst

Aug 2020 – Jun 2021 · 10 mos · Pune, Maharashtra, India · Remote

Built custom Power BI dashboards for 4+ small business clients across marketing, sales and finance.
Cleaned and structured raw data using Excel for accurate, scalable reporting.
Presented insights via clear data storytelling, improving client decision-making.

Power BIData CleaningData StorytellingData Analytics