Ritika Kakkar
Toronto,ON
Summary
Accomplished Senior Data Analyst with a proven track record at Optum Global Solutions, enhancing data-driven decision-making and operational efficiency. Expert in SQL and adept at stakeholder management, I've led projects that resulted in significant savings and process improvements. Recognized for transforming complex data into actionable insights, driving business success.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Optum Global Solutions
04.2021 - 09.2024
- Company Overview: Optum is a leading health services and company which focuses on improving affordability, quality, and efficiency of care
- It has teams supporting healthcare operations, product development, automation, analytics, and data solutions
- Part of Revenue Cycle Management team which focuses on streamlining the process and bringing in efficiency
- Developing Denial Comprehensive Solution for a leading Provider in the US
- Understanding the data, developing KPIs and providing an end-to-end solution in Power BI
- Presenting the insights and the value add to business stakeholders
- Turning insights into narratives and executive presentations using multiple channels including dashboards, PowerPoint, and infographics
- Providing analysis and insights on the Front-end stage (PAI) of the Revenue Cycle, which includes data understanding using SQL, Azure Databricks and insights generation and creating a dashboard in Tableau
- Leading a project on understanding the Payer’s Behavior
- This includes research and analysis of the KPIs to benchmark Payer’s performance
- Dashboarding the trends and coming up with dynamic insights
- Perform Clustering and segmentation to devise targeted strategy
- Devise rule-based scorecard for different Payers to understand the historic and relative trend of Payers over the years
- Optum is a leading health services and company which focuses on improving affordability, quality, and efficiency of care
- It has teams supporting healthcare operations, product development, automation, analytics, and data solutions
- Key Services & Capabilities Uplift Delivered (till date):
- Created end to end automated pipeline of Denials dashboard for various Providers
- Conceptualized savings using the insights generated which led to significant impact on Denials management ($5M)
- Awarded with various recognitions for the impact created
Senior Analyst Analytics Advisory
Accenture Operations
04.2020 - 04.2021
- Company Overview: Accenture is an IT Consulting and Business Advisory firm that helps translate customer’s vision and ideas into practice and delivers them through people, projects and technology
- Managing BI and reporting activities for Europe’s leading Automobile manufacturer and a well-established E-Commerce client
- Working with stakeholders to understand business objectives, translate objectives to define KPIs and goals at the business level
- Working with SMEs in the business to gather requirements for new metrics reporting
- Providing support for ad hoc data analysis requests/recommendations using R and SQL from the Operations team and Upper management
- Analyzing warranty claims to improve claim risk evaluation, shift manual effort towards high-risk claims and move checks from people to machine
- Creating and maintaining Interactive dashboard and scorecards to bring deeper visibility into Claim management and Dealer Analysis process
- Partnering with Sales & Marketing team to support initiatives by providing quality insights and recommendations using R and Power BI to achieve maximum value creation
- Product clustering and segmentation to devise targeted strategy
- Accenture is an IT Consulting and Business Advisory firm that helps translate customer’s vision and ideas into practice and delivers them through people, projects and technology
- Key Services & Capabilities Uplift Delivered (till date):
- Acquired the understanding of existing reporting activities and enabled man- power savings of ~100 hours (per month) by identifying areas for process improvement and automation
- Conceptualized logics (in conjunction with Operations team) which were implemented (in claim assessment backend) and translated to total saving of $50K (in Nov’ 2020)
- Increased bottom line by redefining the pricing strategy for SKUs leading to an additional revenue of ~$25K
Live Project
Peritos Solutions
07.2019 - 08.2019
- Company Overview: Peritos Solutions is an IT consulting firm which is helping small to medium business owners to use IT as a powerful means to solve business problems
- Created Power BI Dashboards with interactive views to derive actionable insights
- Implemented row-level security in Power BI across projects
- Peritos Solutions is an IT consulting firm which is helping small to medium business owners to use IT as a powerful means to solve business problems
- Automated end-to-end internal Project Management activities
Summer Internship
Optum Global Solutions
04.2019 - 05.2019
- Company Overview: Optum is a leading health services and company which focuses on improving affordability, quality, and efficiency of care
- It has teams supporting healthcare operations, product development, automation, analytics, and data solutions
- Strategizing Personalization framework for health insurance plan
- Strategized methodologies to enhance personalization in health insurance as a part of to Consumer Analytics team
- Identified latest trends in healthcare and executed competitive benchmarking for best practices across the industry
- Performed Need-Gap Analysis and conceptualized recommendation framework for health insurance plans
- Created Product design encompassing process flows and wireframes to effectively communicate high-level design strategies
- Forecasted annual savings of approximate $9 million through this project
- Optum is a leading health services and company which focuses on improving affordability, quality, and efficiency of care
- It has teams supporting healthcare operations, product development, automation, analytics, and data solutions
- Awarded for showcasing ‘Collaboration’ in UHG, for helping conduct an event (which included top leaders from UHG) while coordinating with different teams
Executive, Market Research and Consulting
NEC Technologies India
11.2015 - 05.2018
- Company Overview: NEC Group is a USD 30 billion dollars conglomerate with operations spread across multiple verticals around the globe
- In India, NECTI provides reliable, customized, IT & network technologies to governments and businesses
- Conducted diagnostic analysis and created comparative performance metrics to interpret trends and patterns
- Provided deeper insights and highlighted bottlenecks existing in the supply chain
- Carried out comprehensive analysis for providing Recommendation reports to the various government authorities (Ports, NHAI, Railways)
- Organized workshops for feasibility analysis of NEC products and provided business consulting to clients in areas of technology, automation, and innovation
- Involved in developing and implementing automation design under Agile environment
- NEC Group is a USD 30 billion dollars conglomerate with operations spread across multiple verticals around the globe
- In India, NECTI provides reliable, customized, IT & network technologies to governments and businesses
- Appreciation from management for bagging a JPY 5 million billing project
- Won Team Oscar (awarded to the highest performing teams in a quarter) for OND’17 quarter, NEC Technologies
- Appreciation from Indian Ports Association (IPA) and government authorities (Office of Secretary, PMO office) for creating informative reports
Education
MBA - Business Analytics
Symbiosis Centre for Management and Human Resource Development
Pune12.2020
B. Tech - Computer Science
G.B Pant Government Engineering College
Delhi12.2015
XII -
Bhatnagar International School
Delhi12.2011
X -
Bhatnagar International School
Delhi12.2009
Skills
- Business Intelligence and Reporting
- Analytical thinking
- Strong presentation and communication skills
- Data Analysis
- Market and competitor research
- Data wrangling
- Stakeholder Management (Technical and Business)
- Problem solving
- Data visualization
- Advanced Excel
- Business intelligence
- Dashboard creation
- SQL expertise
Certification
- Six Sigma Green Belt, KPMG
- SQL Bootcamp
Hobbies and Interests
- Badminton
- Table Tennis
- Drawing Mandala
References
References available upon request.
Timeline
Senior Data Analyst
Optum Global Solutions
04.2021 - 09.2024
Senior Analyst Analytics Advisory
Accenture Operations
04.2020 - 04.2021
Live Project
Peritos Solutions
07.2019 - 08.2019
Summer Internship
Optum Global Solutions
04.2019 - 05.2019
Executive, Market Research and Consulting
NEC Technologies India
11.2015 - 05.2018
MBA - Business Analytics
Symbiosis Centre for Management and Human Resource Development
B. Tech - Computer Science
G.B Pant Government Engineering College
XII -
Bhatnagar International School
X -
Bhatnagar International School
Similar Profiles
Nupur ShuklaNupur Shukla
Senior Product Analyst at Optum Global SolutionsSenior Product Analyst at Optum Global Solutions
Robertson CastanoRobertson Castano
Associate Business Analyst at Optum Global Solutions (Philippines) Inc.Associate Business Analyst at Optum Global Solutions (Philippines) Inc.
Sudha JhaSudha Jha
Assistant Manager of Operations at Optum Global SolutionsAssistant Manager of Operations at Optum Global Solutions