Bhawna Gupta
Bangalore
Summary
Explores Data for Insights and Story Telling 14+ years of experience in Data Analytics across US Healthcare, Banking, and Oil and Gas domain Orchestrated a team of data analyst, and data engineering providing guidance, mentorship and technical expertise; optimized data models Collaborative sessions with business stakeholders to capture requirements and align project deliverables with business objectives; Quality Assurance and Project Management experience
Overview
2025
2025
years of professional experience
Work History
Manager Data Analytics
United Health Group - Optum Global Solutions
07.2020 - Current
- Data science and BI products for Providers and payers to understand the potential savings derived from use of the
- Optum Products
- New metrics designed increased flexibility to showcase findings & revenue increase ~20%, enhanced overall project efficiency by 30% and reduced time-to-market by 25%
- Help providers with effective coding and impact analysis on claims
- Peer to peer analysis using benchmarking on KPI’s to compare organizations in the same cohort
- Implementation:
- Delivered BI product in Power BI for Providers to understand the potential savings derived from use of the Claims editing system
- New metrics designed increased flexibility to showcase findings & revenue increase ~20%
- Designed solution for Peer-to-peer analysis using benchmarking on KPI’s to compare organizations in the same cohort
- Helped Product Sales team with targeted audience for cross sell and up sell products with Quarter-on-
- Quarter Sales Pipeline
- Impact and Opportunity Analysis of claim submissions for improved denial/downgrade rates
- Used: SQL, Power BI - DAX language, Tableau, Python
Tech
Mahindra, GSK
- Advance Analytics: Analyze the factors fueling to the growth of the Market of drugs for HIV, providing Competitor analysis and help business with Key data driven decision making to develop Marketing strategies for the Organization
- Improved Return on Investment with effective campaigns and targeted segments
- Implementation:
- Marketing Mix Modelling: Data preparation for Marketing Mix Model to provide optimal spend recommendations and analyze Rx Impact for the Direct-to-consume promotions such as TV, Radio, Print and Online activity
- Worked closely with various vendors to provide data needed to measure CRM programs
- Consumer analytics: Created dashboard to visualize Marketing data, persistency rates for GSK products and it’s competitors using patient level data
- Analysis of Tests for Prescription of Medicines for HIV: Used healthcare professional data based on the RX for multiple competitive products and did analysis for the one newly launched product
- Trend analysis of HLA screening tests: Impact of ViiV funded HLA tests on Total tests
- Conducted test and control for ZIP’s that have significant increase in 3-month pre period vs 3-month post period
- Vendors Management: Played a key role in the outsourcing vendor selection project providing insights into the current operating model with areas for improvement
- Developed case studies to include in the RFP to ensure vendor’s ability to perform advanced analytics and provide recommendations that will increase growth
- Used: Teradata, SAS, R Studio, Tableau
Data Analyst II
Epsilon
03.2018 - 12.2019
- Oil and Gas US Client – ExxonMobil: Equip Program Managers, Area Managers and Business Warehouse Managers to know effectiveness of the loyalty program and other initiatives on the business growth
- Implementation:
- Segmentation of consumer base using Value Attrition and Potential Models (RFM) Analyzing impact of customized design offers on consumer behavior
- Analyzing migration of consumers across VAP segments from prior period
- Longitudinal analysis for non- transacting consumer base
- Redemption analysis
- Created a data product that provides 360 view of consumers
- KPI's includes program penetration, growth, enrolments, Quarter on Quarter attrition
- Used: SAS/BASE, SAS/SQL, SAS/ODS, SAS/ACCESS, SAS/STAT AND SAS/MACRO, Tableau
Module Lead
Advance Analytics
01.2017 - 03.2018
Sr. Consultant
Linkedin
09.2016 - 12.2016
- Empower sales representatives, and their managers, to know sales representative’s capabilities and areas of improvements with data driven sales coaching at Linkedin
- Assist bringing comprehensive approach to increase productivity for sales reps, relating manager observations, sales metrics, sales behaviors and learning activities
- Improved Month on Month Sales quota by 5% with improved ways of tracking Goals vs Actual of Sales
- Implementation:
- Designed data visualization to provide a 360 view of sales representative’s capabilities and optimal capability-building interventions
- Thereby, improving QoQ growth of business and reduce QoQ attrition within sales team
- Used: R Studio, Power BI, Advanced Excel
Sr. Business Analyst
Decision Analytics, EXL Services
01.2013 - 11.2014
- Clients – DBS, CITI Bank - Credit Card portfolio Risk Management
- Have Support strategy building in different risk concepts within card and customer assets viz, Customer Acquisition
- Approve/Decline, Limit Table (Credit line increase, credit line decrease), Line Management and Portfolio
- Performance Analysis
- Improved Booked Accounts for Pre-approved customer acquisition channel QoQ by ~ 2%
- Implementation:
- Created Reports and Dashboards using SAS EG for Cards and Unsecured Loans portfolio
- Have Support strategy building in different risk concepts within card and customer assets viz, Customer
- Acquisition, Approve/Decline, Limit Table (Credit line increase, credit line decrease), Line Management and Portfolio Performance Analysis
- Used: SAS/ Base, SAS/ Macros, SAS/ Stat, SAS/ EG, SAS/ SQL, SAS/ ODS, Teradata as Database (Unix)
Sr. Programmer
Accenture, BFSI
01.2010 - 08.2011
- Bank of America: Created Reports for Cross sell/ Upsell of products across different lines of businesses
- Designed solution for referral program analysis, insights and recommendations helped bringing in CPA(cost per acquisition) lower by 60%
- Implementation:
- Developed Dashboards for cross sell and upsell for LOB’s using SAS Base, SAS SQL and SAS Macros to extract, clean and validate data from oracle tables, perform sorting, merging, updating data and generate customized reports using SAS/Base
- Used: SAS/ Base, SAS/ Macros, SAS/ Stat, SAS/ EG, SAS/ SQL, SAS/ ODS, Oracle as Database (Unix)
Software Engineer
Tata Consultancy Services
04.2007 - 12.2009
- Retail - Carphone Warehouse: Access new market for mobile retailer and maximize profitability on overall market share by evaluating promotion offers and pricing strategy
- Also help retailer with identifying possible fraudulent claims for insurance policy in products
- Implementation:
- Pricing Strategy: Developed solution using Logistic regression model using weekly sales data – mobile.co.uk – comparing mobile phone deals made easy
- Built BI Solution evaluating various promotion offers extended to customers for prepaid or post pay handsets and AOL Broadband connections
- Fraud Detection: Deployed statistical model for Insurance fraud detection, to assess and label the claims as normal or possibly fraudulent claims based on the information provided by the customer at the time of reporting claim
- Used: Oracle, Base SAS, Excel Pivot tables, Hlookup, Vlookup, Excel charts
Operations Engineer
Ozone Electronics Private Limited
06.2006 - 03.2007
- Increase revenue and reduce costs for manufacturer of Pollution Checking Machines by managing inventory for
- Incoming goods and Finished products in stores with accurate forecasting and right vendor selection for timely & quality deliveries
- Also provide maintenance for products under warranty to avoid failure costs
- Improved Quality management, hence reduced failure rate
- Implementation:
- Sell Analytics: Build Time series Forecasting model to optimize inventory planning in stores
- Gathered data from external and internal ERP system for analysis
- Production Analytics: Developed model for predictive maintenance based on the previous
- Complaints handled by service teams and complaints registered
- Move Analytics: Developed Supplier Performance Management dashboard for transportation management by selection of vendors and Quality model development for Incoming goods inspection using stratified random sampling for low defect rate for the lot
Education
Post Graduate Diploma - Operations Management
Indira Gandhi National Open University
Bachelor of Technology - Electronics and Communication Engineering
Punjab Technical University
Skills
- SKILLS AND STRENGTH
- Data Analysis and Visualization Tools:
- Power BI, Tableau, Scripting - Python, R, SAS Base / SAS Enterprise Guide
- Create dashboards for business, develop visualizations using advance Data analysis expression (DAX) in Power BI
- Relational Databases: Oracle, SQL, Teradata Advance queries to extract, transform and summarize large data in TB’s
- Strength, other participations:
- Problem Solving, Quality Assurance and Situational Leadership, Technical trainer at organizational level
- Mentor, participate in data challenges and MIT hackathons
- Mentor Women Entrepreneurs IIMB Batch 2023, business plan preparation phase of the Gov of Karnataka sponsored
- Team leadership
- Team collaboration
- Technical problem solving
- Strategic planning
- Documentation and reporting
Accomplishments
- The Essence of Leadership: Explorations from Literature | IIM Bangalore through IIMBx online | Jan 2024 – Mar 2024
- Executive Program: Business Analytics and Intelligence | Indian Institute of Management Bangalore | Jul 2011 – Jul 2012
Timeline
Manager Data Analytics
United Health Group - Optum Global Solutions
07.2020 - Current
Data Analyst II
Epsilon
03.2018 - 12.2019
Module Lead
Advance Analytics
01.2017 - 03.2018
Sr. Consultant
Linkedin
09.2016 - 12.2016
Sr. Business Analyst
Decision Analytics, EXL Services
01.2013 - 11.2014
Sr. Programmer
Accenture, BFSI
01.2010 - 08.2011
Software Engineer
Tata Consultancy Services
04.2007 - 12.2009
Operations Engineer
Ozone Electronics Private Limited
06.2006 - 03.2007
Bachelor of Technology - Electronics and Communication Engineering
Punjab Technical University
Tech
Mahindra, GSK
Post Graduate Diploma - Operations Management
Indira Gandhi National Open University
Similar Profiles
Archit BhattArchit Bhatt
Technical Product Manager at Optum Global Solutions (United Health Group)Technical Product Manager at Optum Global Solutions (United Health Group)
Sairam GantiSairam Ganti
Software Engineer at Optum Global Solutions Pvt.Ltd.(United Health Group-UHG)Software Engineer at Optum Global Solutions Pvt.Ltd.(United Health Group-UHG)
JENNIFER SAN DIEGOJENNIFER SAN DIEGO
Clinical Hiring Talent Acquisition Assistant Manager / Clinical Sourcing Lead /Senior Recruitment Analyst at Optum Global Solutions (United Health Group)Clinical Hiring Talent Acquisition Assistant Manager / Clinical Sourcing Lead /Senior Recruitment Analyst at Optum Global Solutions (United Health Group)
SHANMUGAM RSHANMUGAM R
Technical Lead -IT at Intimetec Vision soft Pvt LtdTechnical Lead -IT at Intimetec Vision soft Pvt Ltd
Pooja MukundanPooja Mukundan
Associate - RMC Governance Officer at J P Morgan Chase & CoAssociate - RMC Governance Officer at J P Morgan Chase & Co