Sumit Gupta

Specialist

Mastercard•  June 2022 - Present•  Gurgaon

Expertly managing multiple projects, with a track record of handling five concurrent projects covering all stages of product cycles, generating over 40 million in annual revenue. Lead the development and launch of 3 innovative products, generating over $21 million in annual revenue. Leveraged advanced data analysis tools like SSMS, SSRS, Python, and SQL to analyse complex datasets and craft custom account manager dashboards. Collaborated with data engineering teams to identify and rectify process bottlenecks, trimming project timelines from 24 to 14 days.

Consultant (Data Scientist)

Capgemini•  October 2021 - June 2022•  Noida

Developed an automated report generation process using Python, saving 26 man-hours weekly. Developed a regression model for lead segmentation to predict revenue per lead. Built a predictive capacity model for the Citi group to help them achieve efficiency targets. Built dashboards and KPIs for the Citi group and later wrote Python scripts to eliminate human intervention.

Data Analyst

Cars24•  July 2021 - September 2021•  Gurgaon

Collaborated with the BI team to create dashboards and KPIs, enhancing finance team decision-making efficiency by 25%. Wrote Python scripts to automate manual tasks, saving 18 man-hours weekly. Worked on Google Sheets with the LMS team to help them migrate the data on the Simpler platform.

Clinical Data Analyst Trainee

Inventhealth•  September 2020 - June 2021•  Remote

Collaborated with the research team to enhance data collection and recording accuracy, leading to improved data integrity for analysis. Calculating RAF (Risk Adjustment Factor) Scores for the claim settlement process. Performing data validation, reconciliation, and retrieving missing data when required with 97 % accuracy.

Analyst

Ericsson•  April 2018 - September 2020•  Noida

Carried out predictive analysis on the network KPI historical data to recommend optimisation techniques for the faults arriving on the sites. Created data visualisation graphics using Tableau to translate complex data sets into comprehensive visual representations. We held regular audits using Excel for the market, as per customer requests, which were appreciated by the project director.