Stephen S. Email & Phone Number

London Area, United Kingdom

Responsible for the migration of multi-million pound portfolio of service charge, accounting and other core financial and asset data from third party provider to inhouse teams. This includes setting up and administrating the migration data solution using SQL, Azure Data Factory and Power BI to undertake ETL, Data Quality and Validation processes before passing to target solution provider for load.Key accountabilities: • Responsible for developing and maintaining migration architecture using SQL, Azure Data Factory and Power BI to undertake the transfer of datasets from source to target solutions.• Develop complex data transformations to ensure data is fit for loading into target solution.• Ensure data integrity, validation and quality checks are defined, scripted, and managed as per best practise methodology.• Support UAT and reconciliation activities throughout lifecycle of migration through analysis of migration datasets. • Work closely with and provide specialist advice to stakeholders and third parties suppliers to ensure complex data issues are understood and are managed appropriately.

Bristol, England, United Kingdom

Responsible for the full lifecycle Implementation of the CluedIn Master Data Management Tool into client environments. This includes discovery pieces to understand data requirements, the as-is landscape, developing the to-be CluedIn MDM solution, including ETL/ELT and full MDM functionality, testing, and ongoing support for the service life of the application. Key accountabilities: • Leading on the implementation of client solutions.• Working with key stakeholders to document and detail business needs, data requirements and other key project information.• Implement data pipelines using Microsoft Fabric, ADF and other ETL tools to extract and load data from a variety of complex data sources including SQL Server, Blob and Api’s into the solution.• Setting up and developing the solution for the CluedIn MDM tool, including the data model, cleansing rules, de-duplication, golden records, governance and other key functionality.

Working within the Data Architecture Team I am responsible for supporting the implementation of large-scale BI, data and enterprise cloud solutions. This is through the creation of data and solution architecture artefacts, data analysis and technical implementation. I have worked on the successful implementation of several complex projects within this time including MDM, data governance, data validation, cloud storage solutions, data warehousing and reporting. Key accountabilities: • Developing data and cloud architecture for BI, MI and Enterprise Solutions, including data models, cloud architecture diagrams, data catalogues, data flow diagrams and others. • Undertake detailed technical, data and business analysis; profiling on a wide variety of data sources, applications and business processes for the purposes of developing data and application architecture. • Provide technical expertise and support implementation of cloud data applications – Data Lake, Data Factory, SQL Server, Power BI and others. • Stakeholder Management; Provide overall assurance of the methods used and products produced within these solutions to stakeholders, ensuring these align with the standards and governance required to pass through the various boards and stage gates to be implemented. Key achievements • Successful implementation of a cloud geo-spatial Azure data lake to support flood risk.• Successful implementation of a multi-organisation HR Azure data warehouse.• Successful implementation of data management and compliance system for water quality/permit management solution. • Successful completion of architectural documents for geo-spatial file transfer solution.

Bristol, England, United Kingdom

Previously worked as a data engineer, implementing cloud solutions for a key client, the Environmental Agency. I managed new solution development, built, administered and maintained the data platform and it’s structure and developed end to end data loading and reporting.Key accountabilities: • Administrating the cloud data warehouse, developing, implementing, and maintaining the data structure. Responsible for routine maintenance, developing views and stored procedure to support reporting and database health.• Developing complex ETL packages to extract data from multiple sources, from document repositories to system/reporting databases and publicly accessible data, transform and cleanse before loading into the data warehouse. • Developing BI and MI dashboards using multiple data sources to create complex, accurate reporting across areas including finance, asset and project reporting. • Implementing new software solutions into the reporting landscape.Key achievements • Leading full restructure of the Data Warehouse, creating a single version of the truth using best practise methodology to improve accuracy across the reporting landscape. • Leading a GDPR cleanse of the data warehouse and all supporting applications.

London, United Kingdom

• Leading process and mapping workshops to ascertain migration requirements for a wide range of areas including finance, commercial and customer data.• Source system analysis including profiling, data quality reporting, data dictionary and diagram creation.• Use of reporting tools including SSRS and PowerBI to generate data quality, financial and bespoke reports for consumption by stakeholders within the business from both legacy and transformed data sets.• T-SQL script creation for data set transformation as part of ETL, including writing stored procedures and designing and implementing data architecture for data migration and data warehousing.• SSIS package creation for data loading.• Support of defect resolution, validation and reconciliation in all migration test cycles, including project go live.• Creating business and financial cases for application and migration architecture changes and presenting these to the senior management team for review.• Working closely with other areas of the business including business teams, IT and BI as well as third party suppliers and contractors.• XML processing, transforming and loading into standardised databases.

• Undertaking data mapping and source system analysis.• Documenting all mapping and transformation f data sets from source to target for sign off by senior management and key stakeholders. • SQL script and SSIS package creation for data migration.• Maintenance and support of scheduled SQL agent jobs.• Support of defect resolution, validation and reconciliation in all migration test cycles.

London, United Kingdom

• Master data maintenance.• Data quality management, analysis and rectification.• Application support for CRM and customer accounts. • Development support and requirement gathering for application improvement. • Data source analysis and requirement gathering for migration activities.

Microsoft Azure Data Fundamentals, Data Modeling/Warehousing And Database Administration, Pass

Bcs Professional Certificate In Data Analysis, Pass

Foundation Certificate, Architecture Concepts And Domains, Pass

Foundation Certificate In Business Analysis, Business Analysis, Pass

New Manager Induction Programme, Management, Pass

Data Integration Fundamentals

Adatis accredited certificate covering various SQL related applications including SQL Server Management Studio, Integration Services.

Level 4 Certificate In The Housing Profession

Bachelor Of Arts (Ba), Classical And Ancient Studies