MADHUR GUPTA
Ghaziabad
Summary
Dedicated Professional with diversified experience of working with Internal and External stakeholders from Life Insurance, Litigation and various other sectors.
Overview
2
2
years of professional experience
Work History
Associate Data Analyst
Gartner
Gurugram
09.2023 - Current
- Engagement Life Cycle
- Performed univariate and multi-variate analysis to identify impactful engagements leading to better retention.
- Extracted client engagement information using PBI and SQL for each month in contract to create the visualization for an ideal client journey.
- This project also won accolades during Operating Committee's Quarterly meeting.
- High-Risk Clients Tracking
- Built automated script that streamlined weekly reporting to track progress of key plays for high risk clients.
- Collaborated with the operations team to provide actionable insights on these clients based upon relevant problem statements.
- Acknowledged by the primary stakeholder for exceptional efforts.
- Other Analysis
- Top Bottom Quartile Analysis: SDA classification based upon various performance parameters.
- Price Effect Change Analysis: Analyzed the change in pricing of products over the time.
ASSOCIATE
PwC India
Gurugram
07.2022 - 09.2023
- Fraud Detection in Employee Expenses
- Analyzed Employee expenses for multiple organizations and identified cases of duplicate bills raised against different expense Id's
- Performed image analytics on 1,00,000+ images, further wrote SQL queries to detect contraband items in the obtained results and also flagged cases based upon other Policy Violations
- Collusion Detection
- Wrote SQL queries on 14,00,000+ Policies data and Claims data from to find collusion based upon different fraud scenarios
- Detected cases where Agents and Employees were acting against the company's policy
- Litigation Tracker
- Single-handedly collaborated with 7 law firms across India to streamline the case tracking process for one of the largest E Commerce company.
- Worked on Partial Secondment for 8 months and weekly briefed the client about the performance of law firms and various other parameters on ad-hoc basis.
Education
B. Tech (Electrical Engineering) -
Delhi Technological University
New Delhi, India01.2022
AISSCE, CBSE (Class XII) -
Delhi Public School Ghaziabad
Ghaziabad, UP, India01.2018
AISCE, CBSE (Class X) -
Silver Line Prestige School
Ghaziabad, UP, India01.2016
Skills
- Retention Analysis
- Fraud Analysis
- Stakeholder Management
- SQL (Joins, Window Functions)
- Python (Basic)
- Power BI
- Advanced Excel
- Tableau (Basic)
- C (Basic)
Accomplishments
- Above and Beyond Award Team (PwC India): Member of team, that was conferred with the Above and Beyond Award.[2022]
- Secured 7th rank in Indian Rover Challenge among 35+ international teams as a member of Team Inferno DTU.[2019]
- Among Top 2.26 % for securing All India Rank 22,650 in JEE MAINS among more than 10,00,000 aspirants.[2018]
Timeline
Associate Data Analyst
Gartner
09.2023 - Current
ASSOCIATE
PwC India
07.2022 - 09.2023
B. Tech (Electrical Engineering) -
Delhi Technological University
AISSCE, CBSE (Class XII) -
Delhi Public School Ghaziabad
AISCE, CBSE (Class X) -
Silver Line Prestige School