Business Intelligence and Reporting Developer

• Feb 2021 - Present

Business Intelligence Developer

• Jul 2019 - Mar 2020

Developed advanced SQL scripts and ETL procedures implementing complex business logic with Redshift 1.0 on AWS infrastructure using Aginity Workbench. Provided analytics, reporting, dashboards and bursted email distribution solutions using MicroStrategy 10.4 and Domo against terabyte data sources. Developed advanced SQL scripts and ETL procedures implementing complex business logic with Redshift 1.0 on AWS infrastructure using Aginity Workbench. Provided analytics, reporting, dashboards and bursted email distribution solutions using MicroStrategy 10.4 and Domo against terabyte data sources.

Senior BI Engineer

• Feb 2018 - Apr 2019

Joined a small team formed to implement BI for a new global system to replace legacy UK centric system. Installed, configured and upgraded platform, developed project schema, security model, reporting layer and automated administrative workflows using MicroStrategy 10.9/11.1 and Power BI against SQL Server 2018 in an Azure infrastructure. Assisted other development teams in leading and mentoring junior members as cutover phase approached. Joined a small team formed to implement BI for a new global system to replace legacy UK centric system. Installed, configured and upgraded platform, developed project schema, security model, reporting layer and automated administrative workflows using MicroStrategy 10.9/11.1 and Power BI against SQL Server 2018 in an Azure infrastructure. Assisted other development teams in leading and mentoring junior members as cutover phase approached.

BI Analyst

• May 2017 - Feb 2018

Worked closely with the finance team to provide diamond inscription, grading, sales and revenue data on a new project to produce analytical dashboards and enterprise reports using MicroStrategy 10.4, Tableau Online, Power BI and SSIS against SQL Server 2014. Worked closely with the finance team to provide diamond inscription, grading, sales and revenue data on a new project to produce analytical dashboards and enterprise reports using MicroStrategy 10.4, Tableau Online, Power BI and SSIS against SQL Server 2014.

BI Analyst/Developer

• Feb 2016 - Sep 2016

Provided business and data analysis on a Greenfield project aimed at providing resource utilization and productivity data to all levels of management within the DWP partnered Health Assessment Advisory Service. Produced analytical dashboards and enterprise reports using Power BI, MicroStrategy 10.2 and SSIS against SQL Server 2014 and SQL Azure data sources. Provided business and data analysis on a Greenfield project aimed at providing resource utilization and productivity data to all levels of management within the DWP partnered Health Assessment Advisory Service. Produced analytical dashboards and enterprise reports using Power BI, MicroStrategy 10.2 and SSIS against SQL Server 2014 and SQL Azure data sources.

BI Architect

• Sep 2015 - Dec 2015

Hired to join specialist group of subject matter experts providing guidance for a large offshore development team. Designed BI solutions integrating SAP, SSAS and SQL Azure sources delivered via dashboards and mobile using MicroStrategy 9.4.1 Intelligent Cubes. Produced dashboard visualisations in Qlik Sense 2.1, Tableau 9.1, SSRS, Power BI and MicroStrategy 10.1 proof of concepts for the analytics department of a global drinks company. Hired to join specialist group of subject matter experts providing guidance for a large offshore development team. Designed BI solutions integrating SAP, SSAS and SQL Azure sources delivered via dashboards and mobile using MicroStrategy 9.4.1 Intelligent Cubes. Produced dashboard visualisations in Qlik Sense 2.1, Tableau 9.1, SSRS, Power BI and MicroStrategy 10.1 proof of concepts for the analytics department of a global drinks company.

Business Intelligence Specialist/Senior Information Analyst

• Dec 2009 - May 2015

As sole MicroStrategy resource at the organisation, worked with all levels of the business from Operations and Support teams to Risk Managers and Chief Executives. Responsibilities included designing and implementing multiple projects and initiatives using MicroStrategy 9.x against transactional and analytical systems on DB2 and SQL Server sources. Due to legacy systems, architecture restrictions and departmental preferences, other tools were leveraged such as SSAS, Excel VBA, Power Query, PowerPivot, MDS, DQS, SSIS and SSRS for internally hosted data; Crystal Reports and Crystal Enterprise 10 for live operational reporting; QlikView Version 10 for the Quantitative Analysis team. As BI specialist, conducted multiple competitor evaluations of BOXI, SSRS, QlikView, Tableau and OBI against MicroStrategy. Show less

BI Consultant

• Jun 2009 - Aug 2009

Gathered business requirements and implemented dashboard and reporting project against loan, borrower and investor information from an Oracle transactional system using Hyperion System 9 and SQL Server 2008 and SSIS. Gathered business requirements and implemented dashboard and reporting project against loan, borrower and investor information from an Oracle transactional system using Hyperion System 9 and SQL Server 2008 and SSIS.

BI Consultant

• May 2008 - Feb 2009

Designed and implemented logical data model and reporting solution against SQL Server data for Trade Fund management department using MicroStrategy 8.1. Designed and implemented logical data model and reporting solution against SQL Server data for Trade Fund management department using MicroStrategy 8.1.

BI Consultant

• Dec 2007 - May 2008

Worked directly with the Operational Risk Manager at Europe Arab Bank to analyse business requirements. Developed ETL, metadata, queries, reports and dashboards for Operational Risk Management department using Hyperion Interactive Reporting, SQL Server and SSIS 2008. Worked directly with the Operational Risk Manager at Europe Arab Bank to analyse business requirements. Developed ETL, metadata, queries, reports and dashboards for Operational Risk Management department using Hyperion Interactive Reporting, SQL Server and SSIS 2008.

BI Analyst

• Aug 2007 - Nov 2007

Used the MicroStrategy v8 platform to deliver volume and pricing information for daily trading. Developed and maintained ETL processes using T-SQL stored procedures, DTS and SSIS packages in SQL Server 2005. Used the MicroStrategy v8 platform to deliver volume and pricing information for daily trading. Developed and maintained ETL processes using T-SQL stored procedures, DTS and SSIS packages in SQL Server 2005.

Production Consultant

• Sep 2005 - Aug 2007

Designed and implemented BI solutions using full MicroStrategy platform, involving Data Warehouse design, ETL, creation of physical schema and logical data models, report and dashboard development, web/application server administration and tuning. Designed and implemented BI solutions using full MicroStrategy platform, involving Data Warehouse design, ETL, creation of physical schema and logical data models, report and dashboard development, web/application server administration and tuning.

BI Consultant

• Aug 2003 - Aug 2005

Worked across the entire DW/BI project life cycle, scoped projects and involved with the pre and after sales processes. Implemented reporting and analytical solutions, dashboards and scorecards, data extraction, modelling and cleansing for clients in the Financial, Retail, Pharmaceutical, Technology and Manufacturing sectors that included HBOS, Atos and Toyota. Worked across the entire DW/BI project life cycle, scoped projects and involved with the pre and after sales processes. Implemented reporting and analytical solutions, dashboards and scorecards, data extraction, modelling and cleansing for clients in the Financial, Retail, Pharmaceutical, Technology and Manufacturing sectors that included HBOS, Atos and Toyota.

BI Trainer and Consultant

• Sep 1999 - Aug 2003

Worked across the entire DW/BI project life cycle, scoped projects and involved with the pre and after sales processes. Implemented reporting and analytical solutions, dashboards and scorecards, data extraction, modelling and cleansing for clients across multiple sectors that included Capital One, Sainsbury’s, GlaxoSmithKline, Motorola and Inmarsat. Worked across the entire DW/BI project life cycle, scoped projects and involved with the pre and after sales processes. Implemented reporting and analytical solutions, dashboards and scorecards, data extraction, modelling and cleansing for clients across multiple sectors that included Capital One, Sainsbury’s, GlaxoSmithKline, Motorola and Inmarsat.

Trainer

• Sep 1994 - Aug 1999

Provided training and consulting in IT, database development and programming to clients in the central London area. Provided training and consulting in IT, database development and programming to clients in the central London area.