HIMANSHI GOEL profile photo 1 on Tal

HIMANSHI GOEL

Data Analyst Specializing in Power BI and SQL | Transforming Data into Insightful KPI Dashboards

India

2+ years of work experience

HCLTech
Mar 20256 mosAug 2025

On-site

-Engineered 6 interactive Power BI KPI dashboards adopted by 20+ stakeholders, improving reporting efficiency by 33% by designing dynamic slicers, DAX measures, and drill-through pages tailored to business requirements. -Reduced reporting turnaround time by 25% across 3 cross-functional teams by leading requirements-gathering workshops and translating business needs directly into Power BI dashboard specifications. -Improved data accuracy by 23% and dashboard load performance measured by reduction in data validation errors by refactoring SQL queries using indexed views, CTEs, and optimized data model relationships in Power BI. -Eliminated manual reporting dependency for senior leadership saving ~8 hrs/week of management time by delivering self-serve Power BI dashboards with automated data refresh and role-level access controls.
HCLTech
Dec 20231 yr 5 mosApr 2025

Noida, Uttar Pradesh, India

-Designed and deployed 8+ Power BI dashboards for operational and management reporting used by 15+ stakeholders across 4 business units by gathering KPI requirements, building star schema data models, and iterating on feedback. -Accelerated data extraction time by 27% cutting weekly reporting prep from ~4 hrs to ~3 hrs by rewriting legacy SQL using CTEs, Window Functions, and optimized joins to replace nested subqueries. -Saved 8–10 hrs/week of manual effort across the team equivalent to 1.5 FTE days per week by automating recurring Excel trackers with dynamic Pivot Tables, VLOOKUP, and structured data validation rules. -Served as the primary analytics contact for 3+ cross-functional teams resolving 15–20 ad-hoc data requests per month with a <48 hr turnaround by building a self-serve SQL query library and reusable Power BI report templates.
HCLTech
Feb 202311 mosDec 2023

On-site

-Contributed to development of 3+ Power BI dashboards used in weekly management reviews reducing report prep time by ~20% by building DAX measures, calculated columns, and standardized visualizations under senior guidance. -Improved dataset reliability for downstream reporting reducing data errors flagged in QA reviews by ~30% by performing systematic data cleaning and validation using SQL queries and Excel-based transformation checklists. -Automated 4 recurring manual reporting tasks cutting reporting errors by ~25% by scripting Excel macros and creating standardized Power Query transformation steps to replace ad-hoc manual workflows.
Motherson Technology Services
Jan 20226 mosJun 2022

Noida, Uttar Pradesh, India

▪ Supported ETL processes, data transformation, and reporting automation tasks. ▪ Improved reporting efficiency by 30% through process optimization and data validation techniques. ▪ Created basic reports using Excel and SQL to help stakeholders monitor performance and make informed decisions.

Education

Greater Noida Institute of Technology(GNIOT)

Bachelor of Technology - BTech, Computer science engineering

Greater Noida Institute of Technology(GNIOT)

20184 yrs2022

Senior secondary, Science medical

Sri Guru Nanak Public school

20171 yr2018

Join HIMANSHI and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

HIMANSHI GOEL on Tal

Headline

Data Analyst Specializing in Power BI and SQL | Transforming Data into Insightful KPI Dashboards

About

I've always been more curious about the "why" than the "what." Why did this metric shift? Why does this pattern keep appearing? Why doesn't this number make sense? That line of questioning is what drew me to data analytics — and it's what keeps me engaged with it every day. I'm a Data Analyst and Power BI Developer with 3 years of experience turning messy, complex data into clear, reliable insights. My approach is rooted in structure and validation — I don't move forward until what I'm seeing actually makes sense. That habit of questioning the data, sitting with uncertainty, and working through it methodically is something I've built into how I work. I notice patterns — in numbers, in trends, in the small details that are easy to overlook — and I enjoy making those patterns visible and meaningful for the people who need them. Beyond the analysis itself, I naturally document and share what I learn. Whether it's simplifying a complex concept, breaking down a DAX formula, or creating content for my LinkedIn and Instagram audience, I find that explaining ideas clearly is just as important as finding them. Currently open to Data Analyst, BI Analyst, and Reporting Analyst roles in Delhi NCR.

Location

India

Work experience

Senior Analyst at HCLTech, Mar 2025 - Aug 2025 · 6 mos, On-site, -Engineered 6 interactive Power BI KPI dashboards adopted by 20+ stakeholders, improving reporting efficiency by 33% by designing dynamic slicers, DAX measures, and drill-through pages tailored to business requirements. -Reduced reporting turnaround time by 25% across 3 cross-functional teams by leading requirements-gathering workshops and translating business needs directly into Power BI dashboard specifications. -Improved data accuracy by 23% and dashboard load performance measured by reduction in data validation errors by refactoring SQL queries using indexed views, CTEs, and optimized data model relationships in Power BI. -Eliminated manual reporting dependency for senior leadership saving ~8 hrs/week of management time by delivering self-serve Power BI dashboards with automated data refresh and role-level access controls.

Analyst at HCLTech, Dec 2023 - Apr 2025 · 1 yr 5 mos, Noida, Uttar Pradesh, India, -Designed and deployed 8+ Power BI dashboards for operational and management reporting used by 15+ stakeholders across 4 business units by gathering KPI requirements, building star schema data models, and iterating on feedback. -Accelerated data extraction time by 27% cutting weekly reporting prep from ~4 hrs to ~3 hrs by rewriting legacy SQL using CTEs, Window Functions, and optimized joins to replace nested subqueries. -Saved 8–10 hrs/week of manual effort across the team equivalent to 1.5 FTE days per week by automating recurring Excel trackers with dynamic Pivot Tables, VLOOKUP, and structured data validation rules. -Served as the primary analytics contact for 3+ cross-functional teams resolving 15–20 ad-hoc data requests per month with a <48 hr turnaround by building a self-serve SQL query library and reusable Power BI report templates.

Trainee Analyst at HCLTech, Feb 2023 - Dec 2023 · 11 mos, On-site, -Contributed to development of 3+ Power BI dashboards used in weekly management reviews reducing report prep time by ~20% by building DAX measures, calculated columns, and standardized visualizations under senior guidance. -Improved dataset reliability for downstream reporting reducing data errors flagged in QA reviews by ~30% by performing systematic data cleaning and validation using SQL queries and Excel-based transformation checklists. -Automated 4 recurring manual reporting tasks cutting reporting errors by ~25% by scripting Excel macros and creating standardized Power Query transformation steps to replace ad-hoc manual workflows.

Data Analyst Trainee at Motherson Technology Services, Jan 2022 - Jun 2022 · 6 mos, Noida, Uttar Pradesh, India, ▪ Supported ETL processes, data transformation, and reporting automation tasks. ▪ Improved reporting efficiency by 30% through process optimization and data validation techniques. ▪ Created basic reports using Excel and SQL to help stakeholders monitor performance and make informed decisions.

Education

Bachelor of Technology - BTech, Computer science engineering, Greater Noida Institute of Technology(GNIOT)

Senior secondary, Science medical, Sri Guru Nanak Public school