Jan 2023 – Apr 2024 · 1 yr 3 mos · Bengaluru, Karnataka, India · Remote

• Lead and mentor a team of 4 senior analysts and analysts.
• Designed, executed, monitored and statistically analyzed multiple split and multivariate A/B Tests increasing Product Qualified Leads (PQLs) by 17%.
• Collaborate with global leadership for design and implementation of comprehensive pipeline generation dashboard. This interactive tool tracks individual and team performance, increasing 13% pipeline revenue, by assisting stakeholders with near real-time insights to optimize sales strategies.
• Developed user driven, self-service platform to track metrics for Quarterly Business Reporting to tracking progress in metrics daily over longer time-frames (daily, weekly, monthly) with removal of all manual interventions.
• Partnered with the data engineering team to design and maintain new data pipelines in Apache Airflow to fetch previously missing or newly added attributes to Salesforce. Maintained git repository to enhance created data pipelines for seamless reporting resulting in runtime reduction by 8%.
• Tools: Tableau | Python | SQL(BigQuery) | Apache-Airflow | Salesforce | Git | CRM Analytics

Aug 2022 – Jan 2023 · 5 mos

• Led a team of 4 analysts to unveil previously unidentified profit leakages through a comprehensive driver model analysis. This data-driven approach pinpointed hidden loss factors within retail operations, enabling implementation of targeted mitigation strategies. The resulting improvements yielded a combined profit increase of £2 million (GBP) across Central European stores.
• Spearheaded a new initiative focused on demand forecasting and demand sensing through ARIMA/SARIMA across SKU x Channel x Location combinations, factoring in promotions, weather patterns and industry events to predict future demand, improving Merchandise procurement by 6%.
• Natural Working Team (NWT) : Heading the CE team to help up-skill Enterprise Analytics team by conducting various sessions and helping them with project roadblocks
• Tools: Tableau | SQL (Hadoop | Hive | Spark) | Python (Pandas | Numpy | statmodels | scikit-learn | seaborn)

Dec 2020 – Jul 2022 · 1 yr 7 mos

• Led team of analysts and category planners in collecting data and improving ways to measure KPIs to capture the most relevant and updated information.
• Developed an End-2-End automated Decision Cockpit for Central Europe execs and Category planners. This cockpit keeps track of various crucial metrics to understand the health of the categories along with devising new strategies to improve the CPS (Customer Priority Score) of each category.
• Analyzed the Hypermarket de-growth in CE region to reduce the loss due to Customer switching and increase of competition in various demographics. The analysis is projected to reduce Customer switching by 2% in Czech Republic market.
• Create multiple automation in Python and VBA to enable automated reporting so as the decrease man hours. Benefits of weekly 30+ man hours were observed by the change.
• Tools: Tableau | SQL (Hadoop | Hive | Spark) | Python | Excel | VBA

Jul 2019 – Dec 2020 · 1 yr 5 mos · Bengaluru Area, India · On-site

• Client: Mobile Game developer (May 2020 - Dec 2020)
• ∗ Develop Apache-Airflow based ETL process in Google Cloud Platform (GCP) for tracking in-game metrics. Analysed GCP usage and modified ETL process to reduce GCP costs by almost 50%.
• ∗ Built highly customised Periscope dashboards for stakeholders to understand game performance.
• ∗ Conceptualize new in-game features and run A/B Tests. Analyse A/B Test impact and suggest implementation of feature.
• ∗ Undertake ad-hoc investigations to understand player behaviour. Discover new customer segments (player clusters) with monetization potential.
• ∗ Implement new algorithm to track and eliminate/block cheaters from the game.
• Tools: SQL (BigQuery) | Apache-Airflow | Python | Periscope | Google Docs Suite | Google Apps Script
• Client: Gaming Console Manufacturer (Jul 2019 - May 2020)
• ∗ Implemented a regression model for forecasting of sales for upcoming major games with MAPE less than 15% and used Time series in forecasting sales of franchise games which further helped in deciding partnership with major game studios.
• ∗ Apply regression modeling techniques to prioritize advertisement banners on store website to capture consumer attention boosting sales.
• ∗ Implement model into product to simulate revenue based on advertisement priority.
• ∗ Create reports on requests like used console and disk analysis, product churn and analyse performance and impact of promotions.
• ∗ Analyse potential customer targeting strategies for upcoming titles by defining and quantifying different segments of potential audience.
• ∗ Create Tableau dashboards for various business verticals that enabled clients to analyse business
• Tools: SQL (Snowflake) | Python | VBA | Excel | Tableau

Dec 2018 – Jun 2019 · 6 mos · Bengaluru Area, India

• Offshore delivery & analytical lead (4+ members)
• Extensively used SQL/Python to mine and structure data from multiple loyalty & transactional tables to automate & derive KPIs for a 5M+ loyalty customer base.
• Developed Tableau & Excel-based dashboards to report Customer-Beverage Affinity & Basket preferences, Store performance analysis, Loyalty Metrics Dashboard, Collaboration with third-party services, etc.
• Evaluated potential drawbacks of Loyalty team’s collaboration with an insurance- based third-party service, which set up the grounds for renegotiating their deal, saving up to £2.5M annually
• Performed Look-alike customer profiling and segmentation using RFM metrics and K means clustering, setting up a framework for Test vs Control Post Campaign/Event Analysis
• Used ARIMA and Exponential Smoothing models to determine baseline sales & assess incremental impact of the launch of Red cups during the Holiday season (UK market)
• Create fully automated data extractor & feeder by scraping data for franchises from multiple websites using python selenium.
• Tools: SQL (Oracle) | Python | Tableau | Excel | VBA

Jun 2016 – Nov 2018 · 2 yrs 5 mos · Bengaluru, Karnataka, India · On-site

• Data Validation, Data Analysis – Ensuring reasonableness of data. Deciding and transforming raw data into model data.
• Market Mix Modelling – Multivariate time series Modelling for better understanding of revenue derived by different marketing components.
• Pricing Analysis – Log-Linear Models are generally constructed for Pharmaceutical clients to deep dive into the market scenario regarding what should be the optimal price for the newly launched medicine or post launch analysis and how the sales can be pushed up.
• Effectiveness Analysis - Fragmenting effects of the marketing drivers to a more granular level (eg: Market/DMA level insights)
• ROI Analysis & Optimization – Based on ROI, MROI, Optimization of Advertisement tactic suggesting client to decide their adverting spending pattern to maximize profit.
• Implement client deliverable products based on pricing models for simulation of price change leading to changes in units and revenue.
• Tools: SQL (MS-SQL) | Python | Tableau | VBA | Advanced Excel | SAS | R

Aug 2011 – May 2014 · 2 yrs 9 mos · Kolkata Area, India