GAURAV PATEL

• Designed, developed, and maintained Power BI dashboards used by risk, operations, and business teams to track performance and trends across large datasets.
• Built robust data models using star schema principles to improve report performance and usability.
• Wrote and optimised SQL queries (joins, CTEs, window functions) to extract and transform data from enterprise data warehouses.
• Partnered with stakeholders to gather requirements, clarify metrics, and deliver fit-for-purpose analytics solutions.
• Ensured data quality and integrity through validation checks, reconciliation, and documentation.
• Supported report adoption by providing user guidance and responding to business queries.

Key impact: Improved reporting consistency and reduced manual analysis through standardised BI solutions.

• Supported BI and analytics delivery for large enterprise clients in the financial services sector.
• Developed Power BI reports and assisted with DAX measures and Power Query transformations.
• Built SQL-based datasets and supported ETL processes feeding reporting layers.
• Assisted in data model design and performance troubleshooting under guidance from senior analysts.
• Maintained technical documentation and tracked work using Azure DevOps / JIRA in an agile environment.

Key impact: Helped improve report performance and data reliability across multiple reporting solutions.