Lee Doolan Email & Phone Number

Preston, Gb

Preston, Gb

London, England, Gb

I am a Principal Data Engineer for Qodea formerly AppsBroker CTS, Europe's largest dedicated Google Cloud Partner. Using solid knowledge of cloud architecture and data modelling principles, coupled with a keen sense of business concerns and priorities, I am a trusted advisor and developer for our customers helping design scalable, governed and secure Cloud Data and Gen AI platforms.• Perform ‘hands-on’ billable delivery work for our customers across the UK and Europe.• Advise customers on cloud data engineering tools and processes to orchestrate batch and streaming data, and on modern architecture techniques such as ELT & Data Lakes.• Develop customer Gen AI LLM chatbots, leveraging retrieval-augmented generation and langchain to elevate user experience and engagement.• Build telephone IVR systems powered by serverless infrastructure and linked to an LLM, streamlining customer interactions with AI intelligence.• Thought leadership aspects, such as writing blogs, performing tech talks, supporting hackathons and attending various technical community events helping to advocate innovative solutions and inspiring others.• Work with customers and our Pre-sales Team to identify opportunities, prepare SOWs & translate requirements into technical designs, following through to delivery of the solution.• Promote internal best practices, reusable code bases and solutions to expedite and standardise delivery.

Manchester, Gb

I lead our data engineering function to ingest, secure and govern data pipelines into our group wide GCP BigQuery Data Lake, ingesting from structured databases, files, real-time streams, webhooks and APIs. We then curate data into our Kimball Data Warehouse making data available to our BI & Insights teams as well as integration into our e-commerce web sites and apps. We manage the whole GCP Data Platform from infrastructure, security and costs.• Led our GCP BigQuery Data Analytics migration moving data silos from AWS Redshift, S3/Hive Athena, MSSQL data platform and various other data sources• Hired and recruited a skilled Data Engineering team who I continue to lead, mentor and advise on best practise methodologies & technologies• Developed custom Python ETL Framework to encourage rapid development of data pipelines, be consistent and easy to maintain. Pipelines now built using SQL & YAML code files only and version controlled fully in Github• Built custom serverless alert and monitoring process measuring data latency and quality and integration into the wider DevOps Datadog platform• Introduced the use of Dataform (similar to dbt) as our data transformation and scheduling tool and am evangelical about its adoption both internally and even to Google who have recently acquired the product• Encourage better SQL writing throughout the analytics teams, offering training and promoting good practises• Built API Gateways and subsequent AWS Lambdas/GCP Cloud Functions to help us ingest real time messages from cross-cloud platform apps and 3rd party tools and expose data back to our websites• Liaise continually with the business to identify real data needs and current limitations and gaps• Extract, curate and garner value from our Google Analytics data for all our websites, apps, brands and territories

Manchester, Gb

Employed to design, develop and be the evangelical lead of the enterprise wide Data Warehouse with the sole purpose to improve the efficiency, consistency and data quality of data consumed by all areas of the business located around the UK.• Led on BI Strategy and documented fully for complete executive engagement• Liaised with the business to identify real data needs and current limitations and gaps• Solely managed the Data Warehouse project from a technical perspective (end-to-end) and developed using the full Microsoft BI stack• Introduced real-time data warehousing with the use of Data Replication from heterogeneous systems and Change Data Capture• Utilised the latest functionalities of SQL Server 2014 such as Column Store Indexing• Introduced Data Quality initiatives with the introduction of Master Data Services and encouraging real data ownership and responsibility through Data Stewardship• Assisted with recruitment of 3 new BI developers, subsequently acting as mentor and providing full documentation for methodologies & technologies used

Liverpool, Merseyside, Gb

Employed to extract & transform the groups Engineering Q4 system data into meaningful KPI’s and dashboards.• Owned the project from a technical perspective (end-to-end)• Helped define engineering KPIs offering effective trend and contextual analysis• Designed a Kimball methodology Data Warehouse with multiple star schemas and conformed dimensions• Developed using the full Microsoft BI stack moving data from source systems, data warehouse and a cube• Delivered SharePoint dashboards with an embedded combination of Excel Services and Analytical Scorecards• Introduced Master Data concepts to improve data quality and disseminate data ownership away from IT• Provided full documentation for methodologies & technologies used for internal IT staff

Manchester, Gb

Employed on a short term contract to help test, report on and implement a large scale data migration project moving SIPP pension data from their Abacus legacy system to the Composer pension system. • Automated the processing and error trapping of the data migration scripts using SSIS• Allowed end user reporting of the timings, errors and data defects using linked SSRS reports• Increased the scope of field-to-field component testing with an automated SSIS package• Introduced MS Master Data Services empowering end users to own their own data

Preston, England, Gb

Employed on a short term contract to develop an interactive dashboard reporting Inpatient Admissions, Discharges & Length of Stay duration, and deliverable to CCG executives.• Identified required metrics & extracted data from data warehouse• Advise on missing data, target and specification issues• Developed drill thru reports and parent dashboard using the Yellowfin BI software suite

Leyland, Lancashire, Gb

Initially employed to provide a BI Health Check & Strategy document over the summer I was then subsequently contracted to design and develop a new Data Warehouse to automate the groups strategic KPIs and to replace several disparate legacy report and data sources.• Design and Develop an ETL framework to extract data out of various core systems• Helped identify/specify metrics for various operational functions• Developed a Balanced Scorecard including several linked KPI values, goals and statuses• Provided recommendations on all limitations, risks or gaps in the existing BI environment• Utilised the full Microsoft BI stack i.e. SSIS / SSAS / SSRS (2008 r2)• Implemented MS Master Data Services to improve data quality and disseminate data ownership• Introduced a Version Control and Release Management process• Provide full documentation and coaching material for internal IT staff• Assisted with recruitment of a new internal permanent BI Manager

Blackpool, Lancashire, Gb

Employed on a fixed term project to deliver an MI solution to increase the effectiveness and handling efficiency of Motor Insurance Claims and additional Services.• Delivered filtered and drillable self service Performance Point Dashboards to end users via Sharepoint• Used an embedded combination of Excel Services and Analytical Scorecards • Cost effectively utilised the existing on-site Microsoft BI stack including SSIS, SSAS & Sharepoint PerformancePoint• Implemented OLAP Cubes and complex MDX KPI Calculations• Designed a Data Warehouse using multiple star schemas with conformed dimensions• Developed efficient ETL processes integrating data from many sources

Manchester, Greater Manchester, Gb

I managed a team of 4 to provide full end to end BI development for both internal and external clients and utilising the Microsoft BI Stack.• Managed a small team to design, develop and test a greenfield Data Warehouse solution• Built high performing ETL data flows using SSIS and modular set based T-SQL procedures• Provide expert knowledge to team members on database design and indexing configuration• Advised on hardware configuration, and data file performance best practises• Implemented effective consistent reporting layers using views and SSAS cubes• Introduced version control software to maintain and manage development• Used Sprint/Scrum planning methodologies to delegate and resource manage multiple developments

Provided Data Warehouse ETL, dimensional modeling and SAP Business Objects reporting solutions alongside Qlikview dashboard development.• Routinely liaised with stakeholders to determine contractual measures and requirements• Maintain and develop the SAP Business Objects reporting universes and environment• Design, test, build and schedule reports to be placed in MS Sharepoint• Design and build dimensional models to meet reporting needs• Extract relevant data from a MS Dynamics CRM system and load into the data warehouse• Load external Marketing material into data warehouse to help increase customer base• Upload team and personal target information into the warehouse for performance reporting• Provide data layers to expedite dashboard development and consistency

London, London, Gb

Provide end to end BI solutions using Oracle Data Warehousing & SAP Business Objects technologies as well as other DBA / Data Migration tasks.• Meet with managers and process owners to determine MI requirements• Design and then lead on the development of dimensional models in the Data Warehouse• Determine and then communicate ETL methodologies to the team• Communicate and oversee report and dashboard building and ensure customer satisfaction• Document reporting procedures and requirements• Carefully manage project deadlines and timescales • Delegate work and determine team training to maintain a high performing team• Liaise with external suppliers and consultants• Ensure quality standards are met and maintained• Act as internal BI Consultant to IT Management and Departmental Heads• Manage the security, upgrade and installation of various database and BI toolsets

• Design and maintain various relational databases including developing front-end reports and forms• Use SQL & Visual BASIC to extract and transform data for Reporting and Document Management purposes

Education record

Education record