Akanksha Nandgaonkar profile photo 1 on Tal

Akanksha Nandgaonkar

Senior Power BI Developer | DAX · Power Query · SQL · Data Modelling | BFSI & Healthcare | Building dashboards that drive decisions

Pune District

3+ years of work experience

Web Crypt Technology
Feb 20233 yrs 5 mosPresent

India

1. Smart Banking System · Client: Hexaware Technologies (BFSI) · Cut manual reporting time by building 7+ interactive Power BI dashboards tracking customer transactions, account balances, and deposits — replacing weekly Excel extracts used by many banking stakeholders. · Reduced data preparation time by designing end-to-end ETL pipelines in MySQL (complex joins, CTEs, aggregations) that unified 3 data sources into a single star-schema model. · Delivered 12 KPIs and trend reports enabling the ops team to detect transaction anomalies within hours — collaborating directly with stakeholders to gather and translate reporting requirements. · Reduced ad-hoc BI requests by implementing dynamic slicers, cross-report filters, and drill-downs that empowered non-technical users with self-service analytics. · Achieved 100% pre-release accuracy by validating every Power BI metric against MySQL source data — zero post-launch discrepancies across all reports. 2. Pharmacy Management CRM · Client: Med+ (Healthcare) · Eliminated stock-out risk by building a real-time inventory dashboard monitoring drug levels across the full catalogue, flagging low-stock alerts and fast-moving medicines for proactive reordering. · Cut report publication cycle by migrating from manual Excel ad-hoc reporting to automated, scheduled Power BI dashboards published to Power BI Service. · Built 5 procurement & sales KPIs (total sales, units moved, reorder rate, stock-turn ratio, supplier lead time) using optimised DAX measures — single source of truth for inventory performance. · Collaborated with the procurement team to gather reporting requirements, optimise dashboard usability, and ensure reports were adopted by non-technical staff from day one. · Zero data discrepancies at go-live by reconciling all metrics against MySQL source across 4 joined tables — validation method adopted as a team standard.

Education

Mksss Cummins College of Engineering for Women

Bachelor of Engineering - BE, Mechanical Engineering

Mksss Cummins College of Engineering for Women

Maharashtra State Board of Secondary and Higher Secondary Education (MSBSHSE)

Maharashtra State Board of Secondary and Higher Secondary Education (MSBSHSE)

Join Akanksha and 10k+ other professionals on

Tal Boss

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

Download Tal Boss

Akanksha Nandgaonkar on Tal

Headline

Senior Power BI Developer | DAX · Power Query · SQL · Data Modelling | BFSI & Healthcare | Building dashboards that drive decisions

About

I build Power BI solutions that turn complex operational data into decisions stakeholders act on. Over 3+ years, I've collaborated with business teams across banking, insurance, and healthcare to gather reporting requirements, design self-service dashboards, and deliver ETL pipelines that cut manual reporting cycles by up to 60% — freeing stakeholders from spreadsheets and into real-time insight. Core stack: Power BI Desktop & Service · DAX (advanced) · Power Query (M) · MySQL · Relational databases · Data modelling (star schema) · Row-Level Security · Performance optimization · ETL Where I add value: → Collaborating with cross-functional teams to translate ambiguous requirements into dashboards non-technical users actually adopt → Writing optimised DAX measures and star-schema models that keep reports fast and reliable at scale → Connecting to multiple data sources, cleaning and transforming data, ensuring zero discrepancies at release → Strong analytical and problem-solving approach — every metric validated against source before go-live Domain depth: BFSI (transaction monitoring, account analytics) · Healthcare (pharmacy CRM, inventory) · Insurance Open to Senior Power BI Developer and BI Analyst roles at tech companies where data quality and rigour matter.

Location

Pune District

Work experience

Power BI Developer at Web Crypt Technology, Feb 2023 - Present · 3 yrs 5 mos, India, 1. Smart Banking System · Client: Hexaware Technologies (BFSI) · Cut manual reporting time by building 7+ interactive Power BI dashboards tracking customer transactions, account balances, and deposits — replacing weekly Excel extracts used by many banking stakeholders. · Reduced data preparation time by designing end-to-end ETL pipelines in MySQL (complex joins, CTEs, aggregations) that unified 3 data sources into a single star-schema model. · Delivered 12 KPIs and trend reports enabling the ops team to detect transaction anomalies within hours — collaborating directly with stakeholders to gather and translate reporting requirements. · Reduced ad-hoc BI requests by implementing dynamic slicers, cross-report filters, and drill-downs that empowered non-technical users with self-service analytics. · Achieved 100% pre-release accuracy by validating every Power BI metric against MySQL source data — zero post-launch discrepancies across all reports. 2. Pharmacy Management CRM · Client: Med+ (Healthcare) · Eliminated stock-out risk by building a real-time inventory dashboard monitoring drug levels across the full catalogue, flagging low-stock alerts and fast-moving medicines for proactive reordering. · Cut report publication cycle by migrating from manual Excel ad-hoc reporting to automated, scheduled Power BI dashboards published to Power BI Service. · Built 5 procurement & sales KPIs (total sales, units moved, reorder rate, stock-turn ratio, supplier lead time) using optimised DAX measures — single source of truth for inventory performance. · Collaborated with the procurement team to gather reporting requirements, optimise dashboard usability, and ensure reports were adopted by non-technical staff from day one. · Zero data discrepancies at go-live by reconciling all metrics against MySQL source across 4 joined tables — validation method adopted as a team standard.

Education

Bachelor of Engineering - BE, Mechanical Engineering, Mksss Cummins College of Engineering for Women

Maharashtra State Board of Secondary and Higher Secondary Education (MSBSHSE)

Akanksha Nandgaonkar - Power BI Developer in Pune District | Tal