Ayush Kaushik profile photo 1 on Tal

Ayush Kaushik

Power BI Developer | BI Analyst | Data Analyst | Business Analyst | Power BI | SQL | Python | Business Intelligence | Data Visualization | Dashboarding & Reporting

Noida

5+ years of work experience

HCL Healthcare
Nov 20241 yr 8 mosPresent

Noida, Uttar Pradesh, India

• Designed and deployed 10+ interactive Power BI dashboards tracking clinical and operational KPIs including patient throughput, bed occupancy, and treatment outcomes for C-suite reporting. • Built advanced DAX measures — YTD, MTD, Rolling 7-Day averages, and Conversion % — enabling real-time executive performance monitoring across 5+ departments. • Automated SQL-based reporting workflows using stored procedures and scheduled jobs, reducing manual reporting effort by 35% and cutting report turnaround from 2 days to 4 hours. • Optimized ETL pipelines and Power Query transformations, improving data refresh time by 30% across 3 high-volume datasets. • Collaborated with clinical and operations stakeholders to gather requirements and define KPI frameworks aligned to business goals.
Jul 20222 yrs 4 mosOct 2024

Noida, Uttar Pradesh, India

• Analyzed retail sales and supply chain data for major U.S. accounts including Amazon, Walmart, and Kroger — driving insights across revenue, gross margin, and product performance. • Designed and implemented star schema data models in Power BI, improving query performance and enabling scalable, self-service reporting for business stakeholders. • Improved data accuracy by 27–32% through SQL stored procedures, validation logic, and automated reconciliation workflows that replaced error-prone manual checks. • Built KPI dashboards tracking revenue trends, inventory turnover, and campaign ROI — directly informing merchandising and pricing decisions. • Performed root cause analysis on recurring data inconsistencies, identifying upstream pipeline issues and reducing data quality incidents by ~40%. • Worked cross-functionally with U.S.-based client teams to align reporting standards and deliver insights within weekly sprint cycles.
Banbros Engineering Pvt. Ltd. - India
Aug 20211 yrJul 2022

India

• Automated Excel-based reporting workflows using SQL queries, eliminating 10+ hours/week of manual data processing. • Standardized raw calibration data into structured reporting formats, improving consistency across monthly compliance reports. • Designed reporting workflows that reduced data turnaround time and improved traceability for audit purposes.
Dec 20204 mosMar 2021

• Proficient in analyzing operational workflows during specific data processing cycles, from data ingestion to transformation, ensuring seamless transfer to designated repositories.

Education

Bachelor of Technology - BTech, Mechanical Engineering

amity university noida

20164 yrs2020
Amity University Lucknow Campus

Bachelor of Technology

Amity University Lucknow Campus

Join Ayush and 10k+ other professionals on

Tal Boss

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

Download Tal Boss

Ayush Kaushik on Tal

Headline

Power BI Developer | BI Analyst | Data Analyst | Business Analyst | Power BI | SQL | Python | Business Intelligence | Data Visualization | Dashboarding & Reporting

About

An Dedicated Business Analyst, trained in principles of Analytics and having knowledge of SQL, Python Programming, Statistics and Data Visualization with Power BI and Tableau. Self-motivated and hard working person with ability to learn and adapt in every situation Seeking for an opportunity to work in a challenging environment to prove my skills and utilize my knowledge & intelligence in the growth of the organization along with the growth of mine.

Location

Noida

Work experience

Business Analyst at HCL Healthcare, Nov 2024 - Present · 1 yr 8 mos, Noida, Uttar Pradesh, India, • Designed and deployed 10+ interactive Power BI dashboards tracking clinical and operational KPIs including patient throughput, bed occupancy, and treatment outcomes for C-suite reporting. • Built advanced DAX measures — YTD, MTD, Rolling 7-Day averages, and Conversion % — enabling real-time executive performance monitoring across 5+ departments. • Automated SQL-based reporting workflows using stored procedures and scheduled jobs, reducing manual reporting effort by 35% and cutting report turnaround from 2 days to 4 hours. • Optimized ETL pipelines and Power Query transformations, improving data refresh time by 30% across 3 high-volume datasets. • Collaborated with clinical and operations stakeholders to gather requirements and define KPI frameworks aligned to business goals.

Associate Data Analyst at Intrics, Jul 2022 - Oct 2024 · 2 yrs 4 mos, Noida, Uttar Pradesh, India, • Analyzed retail sales and supply chain data for major U.S. accounts including Amazon, Walmart, and Kroger — driving insights across revenue, gross margin, and product performance. • Designed and implemented star schema data models in Power BI, improving query performance and enabling scalable, self-service reporting for business stakeholders. • Improved data accuracy by 27–32% through SQL stored procedures, validation logic, and automated reconciliation workflows that replaced error-prone manual checks. • Built KPI dashboards tracking revenue trends, inventory turnover, and campaign ROI — directly informing merchandising and pricing decisions. • Performed root cause analysis on recurring data inconsistencies, identifying upstream pipeline issues and reducing data quality incidents by ~40%. • Worked cross-functionally with U.S.-based client teams to align reporting standards and deliver insights within weekly sprint cycles.

Analyst at Banbros Engineering Pvt. Ltd. - India, Aug 2021 - Jul 2022 · 1 yr, India, • Automated Excel-based reporting workflows using SQL queries, eliminating 10+ hours/week of manual data processing. • Standardized raw calibration data into structured reporting formats, improving consistency across monthly compliance reports. • Designed reporting workflows that reduced data turnaround time and improved traceability for audit purposes.

Intern at SHARDA FORGING AND STAMPING PVT LTD, Dec 2020 - Mar 2021 · 4 mos, • Proficient in analyzing operational workflows during specific data processing cycles, from data ingestion to transformation, ensuring seamless transfer to designated repositories.

Education

Bachelor of Technology - BTech, Mechanical Engineering, amity university noida

Bachelor of Technology, Amity University Lucknow Campus