• BI professional with deep expertise in Power BI, Power Query, DAX, and SQL, and a strong track record of building scalable reporting solutions. Proficient in creating and maintaining Power BI reportsSkilled in connecting to diverse data sources—including Azure DevOps APIs, Salesforce, SharePoint, Excel, and SQL Server—to deliver unified, real-time dashboards that drive business insights.. 

Key Projects:

• Expertise in connecting Power BI to multiple data platforms (REST APIs, cloud services, databases, flat files), transforming raw data into clean, analytics-ready models using Power Query and DAX.

• 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.

• Designed visualizations, created calculated fields, and managed data sources. 

• 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%.

• Worked closely with the business users to collect requirements, analyze data sources, and convert business needs into effective technical solutions.

• 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 enabling leadership to track team productivity, sprint performance, and workforce efficiency.

• Applied Power Query transformations (merging queries, creating custom columns, creating functions, dynamic parameters) to standardize data and improve processing efficiency.

• Designed and delivered a strategic executive dashboard showcasing story point aggregation across hierarchy, sprint progress tracking, and team allocation — which improved sprint predictability and reduced planning deviations by 25%.

• Ensured 100% data accuracy and consistency in Power BI, minimizing data discrepancies and ensuring reports align with business expectations.

• Collaborated with product managers and engineering leads to define and refine KPIs and reporting metrics, ensuring analytics aligned with business goals and enabled data-driven decision-making across teams.

• Skilled in writing complex SQL queries and scripts for data analysis and manipulation, including developing efficient queries for data extraction, transformation, and loading (ETL), as well as conducting advanced data analysis using SQL functions and techniques.

• 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.

• Engineered end-to-end reporting solutions by extracting data from Azure DevOps using REST API calls, transforming complex JSON structures in Power Query, and building interactive Power BI dashboards to analyze work item trends and team performance.

• Additionally, I have hands-on experience with Tableau and have developed interactive dashboards for data visualization and business insights.