Divya Aloney
Pune
Contact details — on requestProof of Work — on request
Experience
K
Reporting & Analytics Consultant
Kaiser Permanente · Oct 2025 – Present
K
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%.
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.
D
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%.
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.
D
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).
Skills 0 proven through work
Also works with
SharePoint UsageCSSHTMLRapid LearningWork Planning and PrioritizationProblem SolvingTaking OwnershipDAX Expression DevelopmentTime Series Trend AnalysisFinancial AnalysisResume Parsing and Keyword MatchingData TransformationSalesforce CRMData VisualizationStakeholder ManagementTableauProcess ImprovementRequirements AnalysisVBA ScriptingMicrosoft ExcelData ModelingAutomated Report GenerationDashboard UI DesignPower BI
Proof of Work
Proof of Work
Divya shares this with people who ask. You'll hear back either way.
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
Contact details
Contact details
Divya shares this with people who ask. You'll hear back either way.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal