About Me
Dedicated and results-driven Power BI Specialist / Data Engineer with proven track record of leading high-performance teams and delivering data-driven solutions that optimise operations and enhance decision-making. Adept…
Dedicated and results-driven Power BI Specialist / Data Engineer with proven track record of leading high-performance teams and delivering data-driven solutions that optimise operations and enhance decision-making. Adept at data migration, ETL pipeline development, machine learning, and data visualisation. Skilled in leveraging Azure Synapse, SQL Server, and variety of data sources to create actionable insights and drive business success. Strong communicator and mentor, consistently exceeding expectations of senior stakeholders. Seeking to apply my expertise and leadership in dynamic organisation to drive data-driven excellence.
Experience
Data Engineer
Lead team of analysts, reporting directly to CTO and CFO. Mentor and guide junior team members for their professional growth. Spearhead successful data migration project, facilitating seamless transition to £500,000 new system for corporate through meticulous data validation and management. Orchestrate data ingestion from diverse sources, including SharePoint, MariaDB, Dynamics, and SQL Server, into Azure Synapse, optimising table structures for enhanced query performance. Develop 15 performance-oriented reports employing MAPE as primary key performance indicator, streamlining evaluation processes. Contributed to redefining business logic for new data warehouse, aligning with evolving organisational needs. Communicated and managed expectations of senior stakeholders, including CTO, CFO, and various MDs.
Power BI Specialist / Data Engineer
Lead team of analysts, reporting directly to CTO and CFO.
Mentor and guide junior team members for their professional growth.
Spearhead successful data migration project, facilitating seamless transition to £500,000 new system for corporate through meticulous data validation and management.
Orchestrate data ingestion from diverse sources, including SharePoint, MariaDB, Dynamics, and SQL Server, into Azure Synapse, optimising table structures for enhanced query performance.
Develop 15 performance-oriented reports employing MAPE as primary key performance indicator, streamlining evaluation processes.
Contributed to redefining business logic for new data warehouse, aligning with evolving organisational needs.
Communicated and managed expectations of senior stakeholders, including CTO, CFO, and various MDs.
Revamped 10 Power BI reports, leveraging existing Excel and SSRS templates to harness potential of new database, ensuring consistency with legacy reports.
Translated and streamlined complex business logic from old system to new one, condensing years of intricate SQL scripts into simplified versions, first in MySQL and later in Azure SQL.
Proposed and executed migration of SQL Server and MySQL databases to Azure, eliminating reliance on on-premises gateways and introducing CDC for movement reports.
Implemented version control for Power BI reports using SharePoint as central repository.
Introduced an effective ticketing system in Jira to prioritise and manage team tasks.
Promoted Power BI best practices to prevent data duplication and improve efficiency.
Revamped poorly modelled reports to optimise file sizes, user experience, and data refresh times.
Lead BI Analyst
Led and mentored compact team of analysts, fostering professional growth.
Utilised machine learning techniques, including ANN's, Linear Regressions, and XGBoost Regressions, to forecast resource requirements for both on-road and contact centre operations, managing £200 million in resources.
Led design, debugging, maintenance, and optimisation of ETL pipelines across Azure Data Factory, SSIS, and Alteryx, substantially reducing pipeline runtime.
Provided expert guidance on strategic application of machine learning and recommended suitable models based on extensive research and participation in Kaggle competitions.
Performed in-depth data analysis to identify risks, validated hypotheses, and created essential Tableau sign-off charts.
Crafted and maintained interactive Power BI and Excel Dashboards.
Prepared thorough handover documentation for Business-As-Usual (BAU) reports.
Achieved 7% to 3% reduction in daily average percentage error, improving cost-efficiency and service quality.
Developed comprehensive model validation documentation rigorously tested Python-based Fb profit, ANN, XGB, and ARIMA models using Numpy, Pandas, Tensorflow, Scikit-Learn, and Scipy libraries.
Conducted rigorous statistical validation of external company-generated models and roster builds, preventing potential £500,000 loss.
Directed automation initiatives for reports and emails, resulting in time savings and cost avoidance.
Developed Marts and Dimension tables for diverse schemas using SSMS and Azure Data Factory.
Created and maintained stored procedures to support data operations.
Developed and optimised Power BI reports, including notable £40,000 cost-saving mid-term planning report.
Facilitated data modelling, contributed to Row Level Security implementation, and oversaw Data Gateway management in Power BI.
BI Analyst
Spearheaded creating and maintenance of Power BI reports and dashboards, optimising data visualisation.
Addressed ad-hoc requests as they arose, ensuring timely support.
Provided valuable insights by recommending and constructing various machine learning models, specialising in regression, classification, and clustering models.
Managed Data Gateways and implemented Row Level Security protocols for data protection.
Performed statistical analysis on machine learning model outputs to extract actionable insights.
Prepared handover documentation for Business-As-Usual (BAU) reports to ensure seamless transitions.
Conducted in-depth research into diverse machine learning models to stay at forefront of industry advancements.
Engineered data models within Power BI to enhance data analysis capabilities.
Streamlined data integration processes by supporting and constructing pipelines in SSIS.
Successfully deployed and maintained Page Level Security solution for enhanced data security.
Created Dimension Tables within Azure Data Factory to bolster Data Warehouse functionality.
Translated business requirements into precise technical specifications to drive effective data solutions.
Developed and managed OLAP cubes for efficient data storage and analysis.
Evaluated and enhanced existing reports to ensure accuracy and relevance.
Created and updated technical documentation to facilitate knowledge sharing and future development.
Teacher of Mathematics
Prepared engaging and effective mathematics lessons for students aged 13-15 and 16-18.
Delivered clear and informative lessons, ensuring student understanding and engagement.
Wrote thorough reports on student progress and performance.
Developed detailed lesson plans for observers and incorporated innovative teaching methods.
Designed and implemented customised VBA exam generator, enhancing departmental efficiency and assessment processes.
Established positive, inclusive learning environment fostering respect, diversity, and creativity.
Complied with ethical and legal standards in education and upheld professional code of conduct.