Back to Developers
Hitanshu

Hitanshu

Data Analyst

Pune, Maharashtra 1+ yrs exp 84 · Excellent

About

Results-oriented Data Analyst with hands-on experience in data pipeline engineering, advanced SQL querying, and business intelligence (BI) reporting across marketing and sales domains. Skilled in Power BI, Python, SQL, and GA4 — designing end-to-end ETL/ELT data pipelines, automating reporting workflows, and translating complex datasets into actionable business insights. Experienced in data wrangling, data modelling, A/B testing analysis, and predictive analytics. Familiar with data warehouse concepts, cloud-based analytics, and stakeholder-facing dashboard development. Strong foundation in data quality, data lineage investigation, and cross-functional collaboration to support data-driven strategic and operational decision making.

Skills & Expertise (40)

Power BI Intermediate
7.5/10
2
Years Exp
Python Intermediate
7.5/10
2
Years Exp
Advanced SQL Intermediate
7.2/10
2
Years Exp
Data Pipelines Intermediate
7.0/10
2
Years Exp
Data Wrangling Intermediate
7.0/10
2
Years Exp
ETL Intermediate
6.8/10
2
Years Exp
Data Warehousing Intermediate
6.5/10
2
Years Exp
Statistical Analysis Intermediate
6.5/10
2
Years Exp
Predictive Analytics Intermediate
6.0/10
2
Years Exp
Data Governance Intermediate
5.5/10
2
Years Exp
Matplotlib Databricks NumPy Pandas Dimensional Modelling Hadoop Requirements Gathering Scripting API Integration Workflow Automation ETL Pipeline Design Jupyter Notebooks stakeholder communication Cross-Functional Collaboration AWS Snowflake Data Storytelling DAX Google Search Console GA4 Excel Automated Reporting Interactive Dashboards Exploratory data analysis Pattern Recognition A/B testing KPI Tracking Data Lineage Data Quality ELT

Work Experience

Analyst

SnaccMate

Apr 2026 - Present

Performed end-to-end data analysis including collecting, cleaning, transforming, and visualising data to support pricing and inventory decisions. Built Python (Pandas) scripts to automate data wrangling tasks — merging multi-source datasets, handling missing values, and standardising schemas — reducing manual processing time by ~35%. Developed descriptive and diagnostic analytics reports using Excel and Power BI, delivering insights on sales trends, customer segmentation, and demand forecasting for client stakeholders. Implemented KPI tracking frameworks and defined metric hierarchies aligned with each client’s business objectives, establishing a repeatable reporting workflow from raw data to insight. Conducted correlation analysis and statistical summaries to identify key revenue drivers, communicating findings through clear data narratives and stakeholder presentations.

Data & SEO Analyst

Botpresso

Nov 2025 - Mar 2026

Engineered automated data pipelines using Python and GA4 API, reducing weekly manual reporting effort by ~40% and enabling near real-time insight delivery to stakeholders. Built and maintained Power BI dashboards tracking 10+ KPIs across organic traffic, keyword rankings, and campaign performance; applied advanced SQL to extract and optimise large datasets for reporting. Conducted structured data quality audits and source analysis across 3+ client websites, identifying data lineage gaps and implementing fixes that improved crawl efficiency and indexing rates. Collaborated with cross-functional teams to translate business requirements into measurable metrics, ensuring consistent reporting standards and actionable insights across 5+ active client accounts. Designed and automated regular and ad-hoc reporting processes, reducing stakeholder data requests through self-serve dashboard solutions aligned with governance standards.

Marketing & Sales Analyst

Decathlon India

Jul 2024 - Oct 2025

Designed and owned regional sales dashboards in Excel and Power BI, tracking revenue, footfall, and product performance KPIs for daily operational decision making by store management. Translated analytical findings into actionable business recommendations, identifying opportunities for operational and process improvements across product categories. Generated weekly performance reports synthesising sales, inventory, and customer engagement data; standardised key reporting views, significantly reducing ad-hoc data requests from managers.

Education

Bachelor of Engineering, Mechanical - Army Institute of Technology

2021 - 2025 · Afghanistan

Class 12, CBSE - Army Public School

2019 - 2020 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 9/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 84/100

Profile Overview

Member sinceJun 2026