Ankit Vohra Email & Phone Number

Bengaluru, Karnataka, India

• Assisted retailers and Consumer Packaged Goods (CPG) companies in expanding their customer understanding, including shopper profiles, promotions, and the target audience for influencer marketing. Conducted basic analytics for campaign measurement to support marketing budget optimization.• Responsible for conducting exploratory data analysis to gain insights from clickstream data, facilitating a better understanding and utilization of customer journeys, paths to purchase, and promotion performance for CPG clients.• Conducted in-depth analysis to comprehend customer behavior across various devices in the online channel. Extracted insights about customer behaviors regarding the impact of the core site v/s the mobile app.• Performed detailed analyses of the homepage, search page, product page, and checkout page to gain a comprehensive understanding of customer behavior across different devices.• Assisted teams working on product analytics, category management, and brand tracking as SQL SME.

Bengaluru, Karnataka, India

• Conducted comprehensive testing of the eCommerce website using clickstream data to inform product development.• Formulated recommendations and generated concise reports to offer solutions, considering business requirements and constraints.• Executed end-to-end ETL processes for Business Intelligence, populating for data visualization and analysis in Power BI.• Developed automated data pipelines for processing of various file types using Python APIs and implemented those workflow scheduling with Apache Airflow to efficiently manage and automate tasks.

New Delhi Area, India

• Collaborated cross-functionally, provided data quality assessment to help in strategizing business decisions based on consumer segmentation, sales growth drivers, and brand tracking.• Developed an in-house tool for optimizing data processing for 20+ language translations using databases through Python which reduced time and resources spent on translation of multi-lingual surveys significantly by 70%.• Performed data validation for market research data using SQL, employing matrix transformations, procedures, and scripts.

Pune, Maharashtra, India

1. Extensive training on Embedded and Robotics.2. Performed interfacing of Atmega-16 with LED, LCD,MOTOR,RF Module(Wireless Controlling),PIR Sensor(Motion Detector), Accelerometer.3. Successfully build computer controlled street lights andhurdle game using Atmega-16 micro-controller.

Msc In Business Analytics, 2.1

Capstone Project: Consulted with a cross-functional project team from a Spanish financial services company. Analysed the customer.

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering, First Class With Distinction

Activities and Societies: Editorial Head and Publicity Team member

High School, Science