Anushka Gupta Email & Phone Number

New York, New York, United States

o Automated the manual process of storing and analyzing mobility and pricing data for underwriters by developing an Excel-based tool called Mobility Underwriting and Pricing Tool (MPUT) using IF, VLOOKUP, XLOOKUP, index matching, and conditional formatting,enabling data-driven decisions, improving data submission efficiency by 15%o Recognized a gap in understanding key risk factors for underwriting Autonomous Vehicle (AV) policies and led a collaborative effort with4 subject matter experts to identify 17 essential data points and 6 critical risk factors, resulting in a 20% improvement in the team’s abilityto assess and price AV riskso Analyzed 4 Power BI dashboards with incorrect facts and dimensions, collaborated with business stakeholders to identify gaps, authoreda gap analysis document outlining current vs. target state, and worked with Data Visualization experts to correct the dashboards, reducingdata analysis time by 10 hours per weeko Developed and conducted Excel training for the Mobility team, covering topics from basic functions to advanced techniques (Pivot Tables,VBA, Macros), resulting in a 30% reduction in MPUT filling time and improved data analysis efficiencyo Created comprehensive documentation for MPUT usage, including best practices and step-by-step guides, which facilitated smoother tooladoption, reduced onboarding time for new users by 30%

Hoboken, New Jersey, United States

Developed and delivered comprehensive Excel and Tableau curriculum, focusing on advanced data visualization techniques including geospatial mapping, custom calculated fields, and dynamic parameters. Guided students in creating interactive dashboards with actions, tooltips, and story points, emphasizing best practices in data relationships, hierarchies, and complex joins for effective visual analytics

Gurugram, Haryana, India

o Analyzed client’s financial transactions from SAP in Excel, employing pivot tables, and utilized Power BI for revenue forecasting anddebt recovery. Standardized processes achieved a 95% match to revenue forecasting targets, reducing client intervention by 30%o Developed a revenue forecasting dashboard through regression analysis which was successfully productionized and globally adopted,optimizing forecasting strategies across all marketso Initiated and oversaw the UAT process for a new AI-based software High Radius Cloud, outlining detailed test scripts, forming, andcoordinating the testing team, and closely monitoring the results throughout the testing phase. This resulted in a successful go live andautomation of cash application process by 80%o Led training sessions for 35-member cash application team by creating SOPs for AI software implementation to ensure their proficiencywith the software, enabling them to effectively utilize the AI software in their daily tasks

Gurugram, Haryana, India

Gurugram, Haryana, India

Noida

• Created a database for Apprentice dropouts over the past 3 years through excel for the organization. PRADAN is working with marginalized groups, especially women, to help them out of poverty and live a life of dignity, they have worked with over 834000 families in 8500 villages, across 7 states• Analyzed the database and created visualizations to report on measures to be taken to decrease the dropout rate and presented recommendations to leaders on how to improve the apprenticeship program. Recommendations were implemented to help reduce the dropout rate from 18% to 13%

New Delhi, Delhi, India

Master Of Science - Ms, Management Information Systems And Services

Bachelor Of Commerce - Bcom, Business, Management, Marketing, And Related Support Services

High School Diploma