Divya Aloney

Divya Aloney

+•• ••••• •••••••••••@•••••.com

Reporting & Analytics Consultant · Kaiser Permanente · 5.4 yrs

  • Pune
  • Open to Pune
  • Remote
  • In 90 days

Ask about Divya

Skills

Claimed

SharePoint UsageCSSHTMLRapid LearningWork Planning and PrioritizationProblem SolvingTaking OwnershipDAX Expression DevelopmentTime Series Trend AnalysisFinancial AnalysisResume Parsing and Keyword MatchingData Transformation

Proof of Experience

Reporting & Analytics Consultant

Kaiser Permanente · Oct 2025 – Present

Power BI Developer

Kaiser Permanente · Oct 2025 – Present

  • Designed and deployed 15+ enterprise Power BI dashboards supporting healthcare operations, finance, and business reporting.
  • Developed 250+ DAX measures and calculated columns using variables, iterator functions, CALCULATE, and time intelligence, improving KPI accuracy by 99%.
  • Built and optimized 20+ Power Query ETL pipelines, reducing manual data preparation effort by 70%.
  • Integrated data from 10+ enterprise sources, including SQL Server, Azure SQL, SharePoint, Excel, APIs, Dataflows, and cloud platforms.
  • Optimized star schema data models and report design, improving dashboard performance and refresh time by 40%.
  • Configured Row-Level Security (RLS) across 12+ business functions, providing secure access to over 400 end users.
  • Published and maintained 25+ datasets and reports within Power BI Service while achieving 99.9% refresh reliability.
  • Collaborated with 20+ stakeholders to gather business requirements, design dashboards, and deliver analytics solutions aligned with strategic objectives.
  • Resolved 95% of production issues within SLA while ensuring uninterrupted report availability.
  • Established reusable report templates and best practices that reduced dashboard development time by 30%.
Deloitte

Data Analyst

Deloitte · Sep 2024 – Oct 2025

  • o Automated 60+ legacy Excel reports into dynamic Power BI dashboards, cutting reporting time by 80%.
  • o Designed enterprise-grade dashboards using DAX, DirectQuery & Import modes with 15+ deployments across departments.
  • o Integrated data from SharePoint, Snowflake, Google Cloud platform, SQL server and Excel into centralized pipelines for unified BI reporting.
  • o Developed and tested 2000+ SQL scripts for backend data validation and Snowflake-based automation suites.
  • o Championed the rollout of Row-Level Security in Power BI, enabling secure, role-based reporting across teams.

Data Analyst

Deloitte Consulting · Sep 2024 – Oct 2025

  • Automated 60+ recurring business reports, reducing manual effort by 80% and saving over 25 hours per week.
  • Developed 15+ interactive Power BI dashboards enabling real-time business performance tracking across multiple teams.
  • Authored 180+ DAX measures using advanced calculations, improving reporting flexibility and reducing dependency on manual Excel analysis.
  • Built robust Power Query transformations that reduced report preparation time by 35%.
  • Developed and maintained SQL queries for data extraction, reconciliation, and validation, ensuring 99.8% reporting accuracy.
  • Managed 20+ Power BI Service workspaces, implementing governance, scheduled refreshes, and deployment processes.
  • Implemented Row-Level Security (RLS) across multiple business units, eliminating unauthorized data access.
  • Completed report enhancements and stakeholder change requests within 24-hour SLAs, improving customer satisfaction by 30%.
  • Performed cross-system SQL validation to maintain 100% KPI consistency across enterprise dashboards.
  • Created reusable reporting frameworks that accelerated future dashboard development by 40%.
Deloitte

Data Analyst

Deloitte · Jun 2021 – Aug 2024

  • o Analyzed ETL workflows developed and performed DATA validation using SQL queries and back-end testing.
  • o Contributed to functional and automation testing of ~2000 SQL test scripts in automation suites for 16 initiative.
  • o Refactored and Tested SQLs & Stored Procedures in Snowflake Cloud and loaded benchmark data through SIP in Snowflake Cloud.
  • o Developed and deployed DDLs for different applications in Snowflake.
  • o Created New Calculated Column and Measure using DAX Expression.
  • o Worked on creating bookmarks, Drilldowns and Drill through.
  • o Published reports in Power BI Service.

Knowledge Analyst

Deloitte Support Services · Jun 2021 – Aug 2024

  • Developed 8+ Power BI dashboards and proof-of-concept reports integrating SharePoint, Excel, and SQL data sources, supporting business reporting initiatives.
  • Built 80+ DAX measures and customized visualizations for KPI reporting and operational analytics.
  • Assisted in designing efficient data models and Power Query transformations that improved reporting efficiency by 30%.
  • Wrote and optimized 120+ SQL queries involving joins, aggregations, subqueries, and window functions for reporting, validation, and data analysis.
  • Validated datasets containing 100,000+ records, maintaining 99.5% data accuracy through reconciliation and quality checks.
  • Performed root-cause analysis on reporting discrepancies, reducing recurring data issues by 35%.
  • Built 30+ Excel dashboards using Pivot Tables, Power Query, XLOOKUP, INDEX-MATCH, conditional formatting, and dynamic formulas.
  • Automated 25+ manual reporting processes using Excel VBA and Macros, saving over 15 hours per week.
  • Developed reusable Excel templates that standardized reporting across business teams and reduced report preparation time by 40%.
  • Improved reporting accuracy by 25% through automated validations and formula-driven quality checks.
  • Designed and maintained 100+ SharePoint Online pages using HTML, CSS, and JavaScript.
  • Developed responsive web components that increased user engagement by 25%.
  • Managed content publishing, metadata, taxonomy, and governance across enterprise knowledge repositories.
  • Developed diverse Power BI dashboards integrating data from (source types like Excel, APIs, Google Cloud Platform, Web scraping, Dataflows, Amazon Athena, SharePoint folder, MySQL Database 7 SQL server, Azure SQL Database, Star Schema).

Proof-of-Work

No completed sessions yet. Anything Divya finishes shows up here with the evidence behind it.

Proof of Education

MBA, Marketing

Indira College of Engineering & Management, Pune · 2019 — 2021

BTech, Mechanical Engineering

Shri Guru Gobind Singhji Institute of Engineering & Technology, Nanded · 2014 — 2018

A Proof CV — one profile, kept current, with the proof attached. Back to the portal