Shivam Awasthi

Data Ana

Noida, India 4+ yrs exp 88 · Excellent

About

Data Analyst with years of experience driving business impact through advanced analytics, machine learning, and data visualization. Proven track record of delivering 85% improvement in billing predictions and 40% reduction in reporting time through automated solutions. Expert in Python, SQL, Excel, and Power BI with strong focus on scalable analytics engineering and cross-functional collaboration.

Skills & Expertise (14)

Microsoft Power BI Intermediate

7.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Data Automation Intermediate

6.5/10

Years Exp

ETL Pipelines Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Data Transformation Intermediate

6.5/10

Years Exp

Python Intermediate

5.5/10

Years Exp

Pandas Intermediate

5.5/10

Years Exp

NumPy Intermediate

5.5/10

Years Exp

Data Engineering Intermediate

5.5/10

Years Exp

Statistical Analysis Intermediate

5.5/10

Years Exp

QGIS Beginner

4.5/10

Years Exp

Work Experience

Analyst

HCL Tech

Sep 2022 - Present

Built and maintained 5+ Power BI dashboards tracking 10+ supply chain KPIs, including inbound and outbound warehouse performance metrics. Optimized complex SQL queries, views, and stored procedures across multi-million record datasets, reducing data model refresh latency by 35%. Reduced manual reporting time by 40% by designing and deploying automated Power BI dashboards tracking critical business KPIs across multiple business units. Increased targeted campaign effectiveness by 28% through comprehensive customer behavior analysis, identifying high-value segments and optimizing marketing spend allocation. Architected end-to-end data solutions from ingestion to real-time visualization, implementing ETL pipelines that process millions of records daily. Analyzed user engagement metrics to identify product improvement opportunities, collaborating with engineering teams to validate new data sources and implement data-driven feature enhancements. Extracted and transformed data from relational databases to support strategic business decisions, creating reusable SQL scripts and documentation for team knowledge sharing.

Full-Stack Developer

Whitetag Technologies

Sep 2021 - Nov 2021

Developed full-stack web applications with integrated data pipelines, developed cross-functional technical expertise in software development and data architecture. Engineered responsive backend APIs and database schemas using MySQL to streamline application workflows and accelerate data query response times by 25%. Collaborated with cross-functional teams to deliver client projects, building foundation for effective stake-holder communication and technical requirement translation.