Devanshi Gupta Email & Phone Number

Pune, MH, IN

Pune, Maharashtra, India

• 1. Marketing Analytics
• Designed Targeting and Segmentation Model based on various KPIs, enabling targeted retention efforts for high value customers, and driving a 4% increase in market share
• Developed and assessed three forecasting models (ARIMA, Holt's, and Prophet) with Python's Statsmodels. Chose ARIMA for implementation, resulting in a 10% accuracy improvement over the previous SMA model
• Created a comprehensive Power BI dashboard for sales leadership, providing real-time insights on product, market, competitor, and field performance. Enabled informed business planning and data-driven decisions2. Sales.
• Utilize SQL queries to extract data from Amazon Redshift/DBeaver, performing 20+ crucial Ad-Hoc analyses on the data using Excel, which were used to derive important business insights
• Automated Weekly Product Performance report using SQL and Python leading to reduced manual efforts by 80%

Pune, Maharashtra, India

• Utilized Hive, Bash, GitHub, and internal tools to develop business logic for generating a database of 75+ million eligible Amex US customers for monthly credit bureau inquiries, resulting in a $30 million benefit
• Developed and delivered 14 commercial and consumer inquiries tailored to diverse global markets to fetch credit scores from credit bureaus, resulting in a benefit of approximately $136 million
• Created performance-improving utilities including email alerts for data volume thresholds, and optimized hive variable usage for over 200 SQL codes, reducing TAT from 5+ hours to 2 seconds
• Performed Ad-Hoc impact analyses, troubleshot data quality issues and managed Jira tickets

Pune, Maharashtra, India

Bachelor Of Engineering - Be, Electronics And Communications Engineering, 9.17 Cgpa

Hsc, Science, 84.5%

Ssc, 9.6 Cgpa