Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic
Himanshu Chaurasia

Himanshu Chaurasia

Bengaluru

Summary

Data analytics professional with 8 years of experience in marketing and digital analytics across retail, finance, and healthcare. Expert in SQL, Python, BI tools, and cloud platforms. Recognized for solving complex business problems, developing KPI frameworks, automating reporting, and delivering actionable insights to drive business performance.

Overview

9
9
years of professional experience

Work History

Senior Data Analyst

Target Inc
Bengaluru
09.2023 - Current
  • Developed a data pipeline for a dashboard analyzing marketing channel performance at different merch and assortment levels, leading to a 2-3% increase in conversion rates over 4-6 months through A/B testing. The dashboard tracks key metrics, like co-purchase rates, refining models via ongoing tests.
  • Researched and compiled tailored Weekly Business Review (WBR) scorecards and quarterly reports for CGO/CXO in accordance with making key business decisions.
  • Recognized and rewarded with the Target Directors' Award for building the Competitor Price Index Dashboard, which supported saving $12 million in media campaigns.
  • Led data analytics learning sessions for functional teams and new joiners, educating them on effectively using SQL, Adobe Analytics, DOMO, and in-house tools to enhance team capabilities.

Senior Consultant

Fractal Analytics
Bengaluru
07.2021 - 09.2023
  • Served as the single point of contact for all web analytics requirements, ensuring seamless communication and project success, leading to a 30% increase in stakeholder satisfaction.
  • Researched and compiled tailored monthly analytics and reports for senior management using Adobe Analytics and Power BI.
  • Build and maintain high-quality data pipelines from various data sources (AWS, GCP) to media buying platforms.
  • Received the Fractal Star Award for FY 2018 (Top 10% in the organization).

Senior Consultant

Merkle Inc. (Dentsu Aegis Network)
Pune
03.2019 - 06.2021
  • Lead a team of two analysts and scaled it to a team of four. Acting as the Single Point of Contact (SPOC) for any client queries or issues, handling two accounts with end-to-end ETL and analytics.
  • Designed automated solutions for different processes through SQL macros and Tableau dashboards, enabling quicker insight generation and data-driven decision-making in executive meetings.
  • Technical Expertise: Gained technical expertise in ETL tools, data processing, advanced SQL, and business analysis.

Associate Process Manager

eClerx
Pune
11.2017 - 02.2019
  • Developed an end-to-end BI solution in Tableau to track product performance across regions and LOBs, analyzing KPIs (Sales, Revenue, Profit), and forecasting trends over 12 quarters, enabling faster insights and data-driven decisions.
  • Acknowledged for the statistical model implemented for the campaign's revenue forecasting; collaborated with the client to understand end-to-end campaign development.

Data Analyst

iQuanti Pvt. Ltd.
Bengaluru
07.2016 - 10.2017
  • Took responsibility for structuring, analyzing, and reporting on web performances and product campaigns.
  • Recognition: Awarded 'Best Fresher' for three consecutive months for delivering actionable business insights in dashboards, maintaining 100% error-free deliverables, and ensuring timely report submissions to clients.

Education

Bachelor of Technology - Mechanical Engineering

Indian Institute of Technology
Kanpur
07-2016

Higher Secondary School Certificate -

Emmanuel Mission School
Kota
07-2012

Secondary School Certificate -

St. Anslem's Sr. Sec. School
Abu Road
07-2010

Skills

  • Technology: SQL, Hive (Hadoop), GenAI, Python, Shell Scripting, BigQuery (GCP), ETL
  • Digital Analytics Tools: Adobe Analytics, Google Analytics, Google 360
  • Statistics: A/B Testing, Product Data Analytics, Click-Stream Data Analytics
  • BI Tools: DOMO, Tableau, Looker, Power BI, Data Studio, MS Excel

Timeline

Senior Data Analyst

Target Inc
09.2023 - Current

Senior Consultant

Fractal Analytics
07.2021 - 09.2023

Senior Consultant

Merkle Inc. (Dentsu Aegis Network)
03.2019 - 06.2021

Associate Process Manager

eClerx
11.2017 - 02.2019

Data Analyst

iQuanti Pvt. Ltd.
07.2016 - 10.2017

Bachelor of Technology - Mechanical Engineering

Indian Institute of Technology

Higher Secondary School Certificate -

Emmanuel Mission School

Secondary School Certificate -

St. Anslem's Sr. Sec. School
Himanshu Chaurasia