Data Architect

• Jul 2021 - Present

Business Intelligence Team Lead

• Sep 2016 - Jun 2021

Build, lead and manage an EDW development team. Scheduling and facilitating check-in and feedback meetings with the team. Mentoring and coaching team members. Task prioritisation and allocation to team members. Organise and lead projects end to end. Identifying training requirements of team members. Provide feedback to senior management up to EXCO level on current tasks. Liaise with business users and analysts to gather requirements. Data modelling using mostly Kimball methodologies. ETL development. ETL Framework development and improvement. Innovate new ideas to increase the efficiency and accuracy of the EDW. Develop dashboards to display the current status of the EDW. Implement push notifications to notify the team of EDW failures. Test disaster recovery processes and procedures to ensure business continuity. Show less

Business Intelligence Consultant

• Aug 2015 - Aug 2016

Develop, maintain and improve the data warehouse on a Greenplum database appliance. Write PostgreSQL functions to build aggregates and data marts. Configure ETL in a custom built tool to orchestrate tasks and set dependencies. Develop and maintain reporting services reports. Develop, maintain and improve the data warehouse on a Greenplum database appliance. Write PostgreSQL functions to build aggregates and data marts. Configure ETL in a custom built tool to orchestrate tasks and set dependencies. Develop and maintain reporting services reports.

Data Warehouse Developer

• Jun 2015 - Jul 2015

Design and develop a new Microsoft SQL Server 2012 data warehouse for the cards division that was hosted in the cloud with Amazon AWS. Implement an ETL framework to validate source data and to log processing metadata and data errors for auditing and reporting purposes. Migrate existing solution to a new data source for the cards data. Load data to an Amazon Redshift instance enable big data analysis. Design and develop a new Microsoft SQL Server 2012 data warehouse for the cards division that was hosted in the cloud with Amazon AWS. Implement an ETL framework to validate source data and to log processing metadata and data errors for auditing and reporting purposes. Migrate existing solution to a new data source for the cards data. Load data to an Amazon Redshift instance enable big data analysis.

Business Intelligence Consultant

• May 2012 - May 2015

Develop, implement and maintain Enterprise data warehouse solutions at client sites by using the Microsoft Business Intelligence technology stack. Develop an ETL framework to log processing metadata and data errors for auditing and reporting purposes. Drafting technical specifications. Liaise with business users to understand requirements and priorities. Create reports to visualize processing metadata to end users. Develop, implement and maintain Enterprise data warehouse solutions at client sites by using the Microsoft Business Intelligence technology stack. Develop an ETL framework to log processing metadata and data errors for auditing and reporting purposes. Drafting technical specifications. Liaise with business users to understand requirements and priorities. Create reports to visualize processing metadata to end users.

Analyst Developer

• Nov 2008 - May 2012

Responsible for designing, developing and implementing new data warehouses. Design and develop the ETL framework for ETL processing, metadata maintenance and data validation using Microsoft technologies. Convert ETL from DTS to SSIS. Help maintain and improve existing data warehouses. Organising and leading projects. Conducting analysis and drafting specifications. Responsible for evaluating data warehouse components like ETL software and data warehouse appliances. Perform quality assurance of other team members’ work. Providing technical direction to less experienced team members. Creating reports for business users. Show less

Data Warehouse Analyst / Report Writer

• May 2007 - Oct 2008

Maintain existing and implement new data warehouses for clients. Cognos 8 data modelling. Planning, designing and creating Cognos reports for business users. Testing, evaluating and implementing upgraded Cognos software. Converting ETL processes from SQL Server 2000 DTS to SQL Server 2005 SSIS. Testing disaster recovery procedures. Night support duties. Maintain existing and implement new data warehouses for clients. Cognos 8 data modelling. Planning, designing and creating Cognos reports for business users. Testing, evaluating and implementing upgraded Cognos software. Converting ETL processes from SQL Server 2000 DTS to SQL Server 2005 SSIS. Testing disaster recovery procedures. Night support duties.

Senior Developer

• Jan 2002 - May 2007

Maintain and improve the Data warehouse, Improve efficiency of ETL processes. Manage night support duties. Help develop a front-end for the Data dictionary. Perform quality assurance of other team members’ work. Providing technical direction to less experienced team members. Creating reports for business users Maintain and improve the Data warehouse, Improve efficiency of ETL processes. Manage night support duties. Help develop a front-end for the Data dictionary. Perform quality assurance of other team members’ work. Providing technical direction to less experienced team members. Creating reports for business users