Headline

Data Analyst | Business Intelligence | Azure Data Engineer | SQL · Power BI · Python · dbt | ETL · Data Modeling · Dashboard Automation

About

Most companies drown in data. I build the pipelines, dashboards, and models that make it useful. I'm a Data Analyst and BI Engineer with 1.4 years of experience across HR tech (UKG), ed-tech (Trivium), and cross-functional analytics. I work across the full data stack — from raw ETL and SQL transformation to interactive Power BI dashboards and Python automation — and I focus on one thing: giving decision-makers answers they can act on the same day. What I actually do: → Design and automate ETL pipelines (SQL + Python) that eliminate manual reporting cycles → Build Power BI dashboards from scratch — KPIs, funnel analysis, operational metrics → Model complex HR and payroll datasets for analytics-ready reporting layers → Analyze CRM and sales funnels to surface conversion drop-offs and revenue opportunities → Translate ambiguous business requirements into clean, reusable data solutions My edge: I bridge the gap between data engineering and business intelligence. I can write the pipeline AND explain the insight to a non-technical stakeholder in the same conversation. Certifications: AWS Solutions Architecture Currently open to: Data Analyst · Business Intelligence Analyst · Product Analyst · Azure Data Engineer · Insights Analyst roles. 📩 kamlesh.dhankar24@gmail.com

Location

Gurugram

Work experience

Data Service Consultant I at UKG, Feb 2026 - Present · 5 mos, Noida, Working in a contractual role at UKG, focused on data transformation, ETL automation, and reporting support for HR and payroll datasets. • Managed end-to-end data processing and transformation workflows, taking ownership of multiple concurrent tickets and projects from requirement gathering to final delivery. • Performed ETL (Extract, Transform, Load) operations using SQL and Python, ensuring accurate data migration, validation, and consistency across systems. • Interpreted complex business requirements and translated them into structured datasets, data models, and reporting solutions. • Extracted data from multiple source systems, applied transformations, and loaded into reporting layers for analytics and dashboarding. • Collaborated with cross-functional stakeholders to understand data needs and deliver actionable insights and business-ready datasets. • Built reusable SQL queries, templates, and automated pipelines to improve efficiency and reduce turnaround time. • Designed and maintained Power BI dashboards to visualize KPIs and support data-driven decision-making. • Identified and resolved data discrepancies and transformation issues, ensuring smooth project execution

Data Analyst at Trivium Education, Jan 2025 - Dec 2025 · 1 yr, Delhi, India, - Built interactive Power BI dashboards for sales, marketing, and operations, improving management visibility and data-driven decision-making. - Automated recurring MIS and performance reports using SQL, Excel, and Python, reducing manual effort and report turnaround time. - Performed data cleaning, validation, transformation, and data modelling using Power Query and Python to improve reporting accuracy and reliability. - Analyzed CRM and marketing datasets to identify trends, funnel drop-offs, and conversion issues, enabling monthly and quarterly KPI tracking. - Collaborated with stakeholders to gather requirements and deliver ad-hoc analysis, dashboards, and insights.

Education

Bachelor of Technology - BTech, Computer Science, J.C. Bose University of Science and Technology, YMCA