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 Ops● 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%● Played a key role in establishing quarterly sales goals for US Pharma sales representatives and determining their incentive payouts based on targets achieved at the end of the quarter

● 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