• Technical lead on team that developed python-based web application to produce hospital rotas using linear optimisation• Created and managed cloud-based Azure SQL data models for multiple hospitals. Transformed raw databases using SQL, PowerQuery into multi-dimensional tabular models and results-driven Power BI reports for hospital management, that allowed tracking of patients across their entire healthcare journey, enabling efficient tracking of critical KPIs• Set up Daily Situation reports using SSRS for hospital management, giving them immediate access to critical hospital care information, allowing for quick responses to fast changing scenarios• Regular interaction with hospital management and decision makers. Proven skill in presenting complex information in an understandable format to non-technical stakeholders• Skilled in creating advanced DAX measures using internal tabular logic and filter contexts that maximise model performance and measuring critical KPIs• Specialize in creating interactive Power BI dashboards, utilizing advanced techniques such as dynamic formatting and bookmarking to deliver insightful and user-friendly data visualizations that drive strategic decision-making• Data manipulation: skilled in creating advanced level queries using SQL, Pandas and Power Query with particular focus on speed and efficiency of queries. Experienced working with joins, CTEs, indexing, creating functions/views, subqueries