Business Intelligence Developer

• May 2023 - Present

BI Reporting Business Partner

• Jul 2022 - Dec 2022

- Re-modelled the entire reporting architecture in Power BI to enable “single source of truth” framework, which minimised maintenance, increased dataset refresh time performance 15x and eliminated source refresh failures by implementing a dataflow-dataset-based ETL solution in Power BI Service. - Built multiple company-wide BI reporting solutions from scratch around financial data, employee performance, L&D and HR. - Improved SQL query performance in several key source scripts and stored procedures, e.g. indexing and window functions. - Directly co-ordinated data source migration into Salesforce with no disruption to day-to-day reporting. - Implemented Power Automate to reduce report maintenance by 70%. Show less

Data & BI Consultant

• Sep 2021 - Dec 2022

- Identified a critical gap within in-house ERP system helped unblock a large cost automation project. - Led an organisational modelling & reporting transformation from MS Excel to Power BI. - Built a company-wide data visualisation tool to monitor operational performance and sales data, working closely with senior management and directors as key audience & stakeholders. - Built several BI reporting solutions for C-suite executives & senior managers. - Data engineering in SSMS using T-SQL: stored procedures, indexing, window functions, views, etc. Show less

Data Analyst

• May 2017 - Sep 2021

- Generated over £150,000 in cost-saving through in-house takeover of 2 key data visualisation projects from external contractors - Built multiple BI reporting solutions in Excel, Power BI and IBM Cognos. - Implemented several Excel VBA scripts to automate recurring data tasks, saving over 150 person-hours per month. - Implemented multiple SQL stored procedures in SDM Maximo to extract key product performance information. - Generated over £150,000 in cost-saving through in-house takeover of 2 key data visualisation projects from external contractors - Built multiple BI reporting solutions in Excel, Power BI and IBM Cognos. - Implemented several Excel VBA scripts to automate recurring data tasks, saving over 150 person-hours per month. - Implemented multiple SQL stored procedures in SDM Maximo to extract key product performance information.

Business Analyst

• Jun 2015 - May 2017

The Business Analyst role at Vermillion Group SME allowed me to discover my natural talent for valuable and creative data analysis and trend recognition. Being the only business analyst in the company allowed me to introduce new methodologies and systems, such as Agile working SixSigma principles, implement Microsoft PowerBI with DAX and Power Apps to the business, learn basics of Python & SQL to streamline data flows for improved analysis and security and get hands-on experience of various business areas: logistics, operations, customer satisfaction, marketing and web analytics through Google Analytics. Working with various stakeholders up to senior executives, I can confidently and clearly relay my findings and solutions towards best possible business decision-making. Show less