Azure SQL DW
Hive
ADLS Gen2
Power BI
Azure Data Factory
Azure Databricks
DAX
JIRA (Agile)
- Collaborated with cross-functional business teams to anticipate upstream data changes and plan reporting logic across base, distillation, and consumption layers for Integrated Install Base application of all HP products.
- Designed, developed, and maintained enterprise-level Power BI dashboards for Warranty Install Base, Service Install Base, and Financial Install Base using Direct Query-mode data models.
- Led end-to-end dashboard lifecycle: requirement gathering, data modeling, visualization design, performance tuning, and deployment across DEV, ITG, and Production environments.
- Conducted root cause analysis of data discrepancies by writing complex SQL queries and reconciling data across multiple layers and sources.
- Delivered actionable insights through KPIs tracking SKUs under Carepack, Warranty Extensions, Standard Warranty, and Base Warranty, enabling better customer service and revenue analysis.
- Enabled business users to identify patterns in failure rates, return trends, and sales opportunities via intuitive and interactive visual reports.
- Created detailed testing documentation and led validation of KPIs and aggregates during the migration from Hadoop to Azure Cloud.
- Acted as reporting SME during Hadoop-to-Azure transition, providing sign-off on transformed data across bronze, silver, and golden layers leading a team of developers and data engineers.
- Designed and maintained Logical and Low-Level Design documentation (LDMs and LLDs) for reporting assets and tracked changes across releases.
- Managed report UAT cycles, facilitated stakeholder feedback sessions, and ensured successful sign-offs for production deployment.
- Worked with analysts and business users to redesign reports and data logic in response to upstream source replacements (Contract and Carepack domains).
- Led the planning and execution of historical data loads into analytical models, ensuring high data accuracy and completeness.
- Applied Agile methodology using JIRA to manage backlog items, sprint planning, and team collaboration for reporting deliverables.