Lead AWS data Engineer responsible for building a data lake and warehouse for Ziff Davis various subsidiaries. I have designed and built a solution based mainly on AWS serverless technologies including Glue, Lambda, S3, Athena, Step Functions, Transfer Family, Quicksight and Redshift. Also used EC2 to host open source Talend for Salesforce data pipelines.

Voluntary position with a local charity.

Sertorius IT Services Limited is the company through which Lorrie provides professional services.

Freelance consultant on a variety of short term projects, including writing bids for technology solutions.

Providing consultancy on creating an ISMS to meet the Department of Work and Pensions' ISO 27001 based security requirements.

Involved in building data pipelines in AWS for complaints data.

Designed and built AWS based data lake incorporating on-premise and cloud-based data.- Created data lake using AWS Glue and S3- Built on-premise integrations using MSSQL and SSIS- Created MS Power BI dashboards using AWS Athena as a data source

Designed, built and shaped the requirements for various data warehouses including a unified global data warehouse from multiple subsidiaries across the globe.- Created AWS data lake based on S3 and data lake formation.- Imported data from multiple source systems using AWS Glue, Lambda, Transfer Family, Python, MS SSIS and Talend.- Designed and built an AWS Redshift data warehouse.- Created end user dashboards using Tableau, SSRS, and AWS Quicksight.- Created ad hoc data analysis using AWS Athena- Created localized data solutions using MSSQL; Postgres; Presto; MySQL.- Designed a built on-premise MS SQL data warehouse

Conducted market research and wrote recommendations paper for procurement of replacement CRM system.

Providing BA and SQL BI Development services using MS SQL (SSIS SSRS, SSAS) Agile and PRINCE2 for several key accounts for the 2nd largest digital media agency in the world. Including:-Gathering requirements for data warehouses and SSAS cubes with key stakeholders.-Creating Agile backlogs and participating in Scrums.-Providing the liaison between business users and IT.-Creating conceptual and logical data models.-Maintaining existing warehouses and SSAS cubes.-Managing various data sources, including DoubleClick and Facebook.-Building a new data warehouse and SSAS multidimensional cube for a household name strategic client.-Designing and building SSRS dashboards.-Building and testing ETL processes with MS SQL Server.-Writing MDX scripts for complex calculations.

Responsible for delivering software development and BI services across 5 EU and 1 Middle Eastern Country through management of teams and hands on delivery of solutions, business analysis and SQL development.- Costed solution designs for both new business wins and to support bid teams for CRM, CSMs and customer facing responsive websites.- Managing both internal and 3rd party development teams.- Requirements gathering workshops- Specification writing, BPMN process mapping and data modelling - Agile Product ownership and back-log management- SQL development (stored procedures, views, tables, imports and exports using SSIS)- Data Integration- Data Warehouse design and support including ETL (SSIS)- SSRS reporting from design to build to delivery- Implementing and supporting Microsoft Azure Cloud strategy and transformation- Large scale software procurement- Member of security and threat board and heavily involved in threat mitigation- Managing multiple development teams- Stakeholder engagement and management- Prince2 Project management

Managing core business database software and development across 5 EU countries.- Hands on leader of team involved in designing and configuring COTs CRM and CMS systems.

Responsible for project managing the specification, testing, training and release of database MI systems across 4 countries.Also responsible for Change Management for all existing database installations