Headline

Data Analyst | 2+ years in Automotive & Manufacturing sector with focus on KPI-driven analytics and reporting | Reduced manual reporting by 180–240 hrs/year | SQL, Power BI, Python

About

I am a Data Analyst with 3 years of experience translating business requirements into data-driven insights through analytics, dashboard development, and ETL integration. Key areas of expertise include: - Business data analysis and requirement gathering - Power BI dashboard development and KPI tracking - Advanced SQL data analysis and reporting - ETL workflows and data integration - Python-based exploratory data analysis - Business process modelling and analytics documentation - Stakeholder collaboration across technical and business teams Throughout my experience, I have delivered measurable business impact, including: - Building 5+ interactive Power BI dashboards used by 100+ stakeholders - Reducing manual reporting effort by 15–20 hours per month - Analysing 1M+ row datasets using advanced SQL queries - Improving data availability by 40% through ETL integration workflows - Maintaining 95% on-time analytics delivery across Agile sprint cycles My analytics toolkit includes: - Power BI (Desktop & Service) with advanced DAX calculations - SQL data analysis using joins, CTEs, and aggregations - Python data analysis using Pandas and NumPy - Oracle Data Integrator (ODI) for ETL workflows - Excel for advanced analytics and reporting I also support analytics projects by creating UML diagrams, wireframes, and process diagrams documentation to ensure alignment between business teams and engineering teams.

Location

New Delhi

Work experience

Associate Consultant at Cubastion Consulting, Oct 2021 - Sep 2024 · 3 yrs, Gurugram, Haryana, India, • Collaborated with business stakeholders to gather requirements and documented 20+ Change Request Documents (CRDs) for reporting and analytics enhancements. • Designed and delivered analytical solutions, including SQL queries, data models, and Power BI dashboards to support operational reporting and strategic decision-making. • Enhanced 5+ interactive Power BI dashboards tracking 10+ KPIs across business operations, used by 100+ stakeholders for performance monitoring. • Wrote complex SQL queries using joins, aggregations, and subqueries to analyze large operational datasets and generate actionable insights. • Designed ETL workflows using Oracle Data Integrator (ODI) to integrate data from 3+ data sources, including relational databases and flat files, into centralized reporting systems. • Refined reporting efficiency by building automated dashboards that decreased manual reporting effort by 15–20 hours per month.

Digital Marketing at Marksman Technologies Pvt. Ltd., Apr 2020 - May 2020 · 2 mos, Noida, Uttar Pradesh, India

Education

Bachelor of Technology - B.Tech, Electronics and Communications Engineering, amity University

kendriya vidyalaya

Public links

github: https://github.com/adarsh-ankur