Ankit Haldar Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

• 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.
• 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.
• 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.

Bengaluru, Karnataka, India

• 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.
• 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.
• Natural Working Team (NWT): Heading the CE team to help up-skill Enterprise Analytics team by conducting various sessions and helping them with project roadblocksTools: Tableau | SQL (Hadoop | Hive | Spark) | Python.

Bengaluru, Karnataka, India

• 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.
• 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.
• 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) |.

Bengaluru Area, India

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.

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)

Bengaluru, Karnataka, India

• 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.
• 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

Kolkata Area, India

Master Of Business Administration (M.B.A.), Business Analytics (Conc.), Finance (Spl.)

Activities and Societies: 1. Thinkalytics Club (Analytics Club) President 2. BizFin Club ( Finance Club) Committee member Was the Head.

Bachelor Of Science - Bs, Information Technology

Bachelor'S Degree, Information Technology

Learnt the basics of professional computing Design of Relational Databases Team based software production