Kavya Gupta Email & Phone Number

United States

Mountain View, Ca, Us

Lead analytical consultant for commerce advertising solutions and measurement strategies to optimize advertiser investment- Proving the value of AI-driven solutions by testing and measuring advertiser campaign performance- Accelerating full-funnel commerce revenue by recommending media strategies to optimize advertiser KPIs- Activating sales narratives and go-to-market strategies through thought leadership insights

Chicago, Il, Us

Design and recommend analytical solutions to help clients build efficient marketing mix, pricing, and assortment strategies using demand forecasting, competitor trends and market analysis leveraging Big Data• Reduced coupon spend by 5% and created margin lift of $370K by conducting market research and performing promotional lift analysis on key measurement metrics for snack category of a major CPG client• Led a 3-member team to help client launch new flavors for existing product line in food category by analyzing shopper insights, ranking product attributes, modeling sales incrementality, and mitigating product cannibalization risk, resulting in 11% sales growth• Analyzed customer purchasing pattern and forecasted demand for post Covid-19 period by comparing market trend vs Covid-19 outliers and adding stock piling and google mobility data to existing marketing mix models, reducing client’s inventory cost by 8%• Optimized prices for a Paper client using historical volume vs. price trend, competitive landscape, seasonality, and cross-price and promoted price elasticities to drive revenue while staying competitive; Improved sales by $1.4M• Mentored an intern for 6 weeks and conducted best practice training sessions for the team

Worldwide, Oo

Account Lead for auditing internal controls and automating systems for large accounts - Walgreens and Kimberly Clark• Streamlined client’s Inventory Management process by automatically triggering expiry date, generating purchase orders, and executing inventory replenishment; improving efficiency by 5% and reducing loss due to negligence• Developed a process to identify high risk debtors worth $1.5bn by extracting transactional data using sophisticated SQL query and segmenting accounts based on age of transaction and probability of recovery• Collaborated with cross-functional teams across 3 countries to standardize Revenue Recognition process across 12 subsidiaries by analyzing KPIs, mapping industry trends, and benchmarking against market practices• Facilitated the PCAOB’s Enhanced Audit Data Quality Management Initiative by collaborating with data scientists to develop audit analytics guidelines • Expanded scope of work by identifying areas of process improvement in client’s existing workflow across diverse functional areas

Worldwide, Oo

Performed data cleaning and data manipulation to conduct in-depth financial analysis across industries including retail, healthcare, pharmaceuticals, and energy• Designed process flowcharts using Tableau and Visio to visualize complex audit procedures and client’s internal controls to enable internal and external stakeholders get actionable insights• Developed and maintained an automated multi-currency matrix to update monthly currency exchange rates to be leveraged in each multinational project throughout the practice to standardize loss attributed to exchange rate• Received highest project ratings awarded to top 5% of all employees and fast-tracked for promotion to Senior Analyst

Master Of Science, Business Analytics (Stem Certified)

Bachelor Of Commerce (B.Com.), Business/Commerce, General

Business/Commerce, General