Key Projects:
Designed and developed an automated ticket performance dashboard by integrating data from Azure Boards, Salesforce, Excel, and SharePoint, providing leadership with real-time visibility into ticket trends.
Utilized Power Query for data transformation, ensuring clean, structured datasets for accurate reporting.
Automated dataset refresh using Power Automate, eliminating manual intervention and reducing reporting turnaround time by 90%.
Optimized DAX measures and data models, improving dashboard responsiveness by 30%.
Enabled data-driven decision-making for stakeholders by providing actionable insights on New, Resolved, and End-of-Month Open tickets, allowing teams to optimize workload distribution and improve SLA compliance.
Developed a strategic performance analytics report by transforming and modeling data from Azure DevOps, Excel, and SQL, enabling leadership to track team productivity, sprint performance, and workforce efficiency.
Applied Power Query transformations (merging queries, creating custom columns, dynamic parameters) to standardize data and improve processing efficiency.
Built a high-impact executive dashboard with key visualizations on feature quality, defect resolution, sprint execution, and workforce allocation, providing insights that enhanced project planning and reduced sprint deviations.
Ensured 100% data accuracy and consistency through robust ETL pipelines in Power BI, minimizing data discrepancies and ensuring reports align with business expectations.
Partnered with cross-functional teams, including product managers and engineering leads, to refine KPIs and reporting metrics, ensuring alignment with business objectives.
Engineered a critical escalated tickets monitoring system, leveraging Azure Boards, SharePoint, and Excel data to track resolution bottlenecks and highlight recurring issue patterns.
Applied advanced Power Query techniques (conditional transformations, pivot/unpivot, dynamic grouping) to clean and model data efficiently.
Implemented Power BI Row-Level Security (RLS) to ensure role-based access control, protecting sensitive ticketing data while maintaining user-specific insights.
Provided real-time business intelligence, allowing leadership to streamline resolution workflows, optimize resource allocation, and improve overall service efficiency.