Summary
Overview
Work History
Education
Skills
Certification
Training
Timeline
Generic

Yemi Ayofe

Certified TOGAF 9 Architect
Stanmore

Summary

Resourceful Data Management Professional with wealth of experience in Data Analysis, Design, Modeling, Mining, Migration, Integration, Analytics, Administration, Warehousing and Governance with Master Data, Reference Data and Metadata. Great team player, self-starter and adaptive to change with ability to design and implement scalable data solutions that align with business goals.

Overview

21
21
years of professional experience
2
2
Certifications

Work History

Data Architect

University of York
11.2024 - 01.2025
  • Led the migration of HR and Payroll data from ResourceLink to Snowflake and Workday HCM, enabling enhanced reporting and streamlined HR processes.
  • Produced conceptual, logical, and physical data models of HR and Payroll with appropriate Entity Relationship Diagrams (ERD) to streamline the HR database schema for a successful migration.
  • Served as the primary technical liaison between HR and IT teams, translating complex payroll business rules into scalable data models that reduced processing errors.
  • Produced and optimized data migration scripts, ensuring accuracy and consistency during data transformation and loading processes.
  • Collaborated with cross-functional stakeholders to understand business needs, identify key datasets, and extrapolate actionable data insights through advanced SQL querying and analysis.
  • Conducted data quality assessments to detect inconsistencies, evaluated accuracy/completeness, and implemented corrective measures, ensuring data integrity and compliance post-migration.
  • Provided expertise in data architecture best practices, ensuring scalability and future-proofing of the database and data warehouse designs.
  • Developed essential data governance artifacts, including ETL pipelines, a Data Dictionary, Business Glossary and Data Catalog to standardize HR data definitions, improve transparency, enhance discoverability, support and ensuring data quality pre and post migration.

Data Architect

Crisis
08.2023 - 08.2024
  • Lead Data Architect in a digital transformation programme, overseeing data migration from Legacy application to Microsoft Dynamics CRM 365.
  • Led the development of comprehensive data migration strategies, ensuring seamless transition and integration of data across multiple platforms.
  • Led the streamlining and archival of large-scale historical datasets to ensure GDPR compliance, enforce retention policies, and reduce storage overhead.
  • Spearheaded the data mapping process, meticulously defining data structures, formats, and transformations to facilitate accurate and efficient data migration.
  • Conducted thorough inventory of data sources, identifying key datasets and dependencies to inform migration planning and mitigate potential risks.
  • Collaborated closely with cross-functional teams including IT, data analysts, business analysts and key stakeholders to analyse data requirements, define migration objectives, and streamline processes for enhanced efficiency.
  • Developed and maintained documentation including data dictionaries, mapping documents, and migration plans to ensure transparency, compliance, and knowledge transfer across project stakeholders.
  • Developed data governance frameworks to ensure reliability of data in the CRM system and across the organisation.

Data Architect

Hyperion Global Services
05.2020 - 07.2023
  • Liaised with key Stakeholders to analyse and review the overall Information and Data architecture of the business.
  • Developed and documented the Information/Data Architecture to align with the Enterprise business goals.
  • Designed a unified Customer and Product Master Data Model solution, ensuring a single source of truth for compliance and cross-functional analytics.
  • Developed and optimized ETL pipelines to ingest and transform data from disparate sources into a unified MDM and Enterprise Data Warehouse, improving data consistency.
  • Reviewed and analysed existing data against business requirements and needs to develop the EDW.
  • Designed and implemented a scalable Data Warehouse solution using Azure Synapse Analytics, leveraging Azure Data Lake Storage to enable enterprise reporting and advanced analytics.
  • Created Conceptual, Logical and Physical data models of the current Relational Database Management System (RDBMS)/Transactional/Operational Data Store.
  • Created Data Dictionary for the Enterprise RDBMS/Transactional/Operational Data Store.
  • Defined requirements and rules for the Enterprise Data Standards to assist on how data is collected, formatted and stored.
  • Supported in delivering data analytics and other key information capabilities for the Enterprise
  • Responsible for Data Migration planning and implementation.
  • Reviewed Information Governance to ensure adherence to the Information and Data Strategy of the Enterprise.

Data Architect

Intellectual Property Office
10.2019 - 01.2020
  • Assessed and produced current state of Enterprise data architecture vis-à-vis data domains and data models.
  • Engaged with key Stakeholders to review, and produce Principles, Policies, Standards and Processes for Data Quality, Data Migration, Metadata, Reference and Master Data Management.
  • Developed Data Governance Framework for the Enterprise’s data management.
  • Defined Data Quality metrics and ensuring they are in place to maintain and improve data quality.
  • Produced Business glossary and Data dictionary for IPO data sets.
  • Performed Data and Information audit to identify datasets that require Data Protection Impact Analysis (DPIA).

Data Architect

Department of Education
10.2018 - 09.2019
  • Lead Data Architect in the design and implementation of end-to-end data architecture deliverables for a data streamlining project.
  • Designed and produced data strategy and end-to-end technical data requirements for the implementation of online transactional Provider Information and Management system on Azure Cloud.
  • Produced Conceptual, Logical and Physical Data Models using Sparx EA for a Provider Management System and also for API implementation.
  • Collaborated with stakeholders to define business concepts and produce entity definitions at the conceptual data model level.
  • Utilized Sparx Enterprise Architect for forward and reverse engineering to develop logical and physical data models, supporting system design and documentation.
  • Produced source to target data mappings documents from various data sources to a single system.
  • Developed data migration technical document and supervised the migration to Cloud platform.
  • Produced data integration, data quality, data lineage, reference data, data security, data dictionary and business data continuity blueprints of a Provider Management System.
  • Developed Data Governance framework for the management and security of data used within the system and at Enterprise level.

Data Architect

Shropshire Council
01.2017 - 09.2018
  • Produced Enterprise Data Strategy document to serve as centralised vision with a single and unified organisation-wide approach to data management in a digital transformation project.
  • Designed and implemented an end-to-end multi-domain Master Data Management (MDM) Solution for a Single View of Customer and Employee Domains from divergent sources.
  • Designed and implemented end-to-end Enterprise Data Warehouse (EDW) solution on for Business Intelligence (BI) and data mining.
  • Created Conceptual, Logical and Physical Data Models using Erwin for the Customer and Employee Domains for Single View of the Customer and EDW.
  • Developed Data Quality, Data Lineage, Reference Data, Metadata, Data Standards, Data Flows, Business Glossary and Source-to-Target Mapping specifications for MDM and EDW solutions.
  • Produced technical data requirements in liaison with key stakeholders to achieve specific data integration, migration and management goals.
  • Responsible for CRM, ERP, Social Service, Revenues and Benefits data migration to Cloud platform.
  • Produced high level technical documents and solution blueprints of newly implemented MDM and EDW.
  • Designed integration solution architecture that uses Application Programming Interface (API) in a Service Oriented Architecture (SOA) based implementation.
  • Performed Data and Information audit to determine the source, where stored, who it is shared with of Personal Data for GDPR readiness assessment.
  • Review of Personal Data landscape and development of roadmap to address GDPR requirements such as sources and recipients of Personal Data, retention periods, purpose and lawful basis of processing, consent, security, transfer to third parties, backups & recoveries and automation.
  • Developed and implemented data security solution to address GDPR Compliance and data security concerns.
  • Remodeled data entities to a level of granularity to show and allow assignment of data ownership to roles, show data subject consents, third-parties and entry points of Personal Data.
  • Define business rules to uniquely identify data subjects in the Enterprise Data Landscape.
  • Responsible for mapping data model to business processes using CRUD matrix to identify deletion responsibilities and points of creation of Personal data.

Data Architect

Office of Public Works
07.2015 - 12.2016
  • Designed and implemented end-to-end Enterprise Data Warehouse (EDW) solution from existing Facility, Financial and Maintenance systems for a new BI system to support enterprise reporting, data visualization, data discovery, data mining, Dashboards, ad hoc queries and Analytics.
  • Designed end to end data solution for Property Management System from business need and requirements, produce Technical requirements to re-engineer Enterprise Property portfolio.
  • Liaised with various stakeholders to produce “as-is” technical document and develop a “to-be” data solution that aligned with the business vision and data strategy.
  • Created conceptual, logical and physical data models using Erwin, with project and technical architecture design documents for the EDW/BI system.
  • Developed ETL process using Informatica from existing sources for migration to the BI system and established strategy related to data cleansing, data quality and data consolidation to guarantee data quality assurance.
  • Developed Data Lineage including logical data mapping to establish various data sources with any transformations that occurs and its corresponding target in the EDW for BI purposes.
  • Developed data migration requirements and strategy, identified and produced solutions for data collection, profiling, cleansing, remediation, validation and loading for the EDW/BI system.
  • Identified the right data sources in liaison with stakeholders, integrate, store and analyze the data, developed high level extraction process and developed metadata to integrate the ETL and the BI.
  • Designed data warehouse solution that align with the organization’s architecture standards and practise, based on data requirements and identified data sources.
  • Developed Data Dictionary for the Operational Systems and Data Warehouse describing their ownership, contents, format, and structure to serve as a point of reference for developers and managements’ team, ease of access to required information and control of any changes made.
  • Developed, reviewed and implemented data strategy, policy, standards, procedures, naming conventions and related data issues that conforms to Data Governance process and adhere to regulatory compliance and standards.
  • Developed strategy for migration of data to cloud architecture that aligns with governance policies, security models and best practices within a DevOps and DataOps environment.
  • Reviewed and established a structured approach to Change Management process within the enterprise.

Data Architect

GeoPlace
04.2011 - 02.2015
  • Created conceptual, logical and physical data models used for the implementation of a street and address spatial information system using Oracle SQL Developer and Erwin.
  • Responsible for logical and physical designs of RDBMS systems and oversaw the implementation for a spatial data infrastructure that supports street and address Information Systems.
  • Liaised with stakeholders to identify various sources of data to aid the development of EDW solution.
  • Performed gap analysis by producing the current “as-is” and the target “to-be” deliverables, initiated and developed a roadmap to address the gaps.
  • Designed and implemented an Enterprise Data Warehouse (EDW) for reporting, data discovery, data visualisation, data mining, Dashboards, ad hoc queries and Analytics purposes.
  • Developed Data Lineage that includes identifying data sources, profiling, cleansing, integration, transformation and loading to destination including metadata and reference data to support the EDW, to determine errors, if any in the ETL pipeline.
  • Produced a data validation solution by enforcing business rules and best practices to ensure data security, accuracy and consistency for use in both Transactional RDBMS & Analytic Data Warehouse.
  • Developed solution for data quality analysis and profiling of data from disparate sources in the ETL routine to ensure data accuracy, uniqueness, validity and completeness to support EDW.
  • Developed and reviewed high and low-level design documents for ETL process used for the implementation of Enterprise Data Warehouse.
  • Designed and implemented data replication from source to destination using Streams technology.
  • Developed solution for data virtualization implementation and its best practices.
  • Performed vendor and product evaluations to deliver new and extended solutions by conducting research on products and negotiating with various vendors and suppliers.
  • Developed data integration solution that uses Operational Data Store (ODS) for reporting and use operational decision support.
  • Designed and implemented solutions for Data High availability and Disaster Recovery Strategies for Online Transaction Process and Decision Support Systems.
  • Designed and reviewed Backup and Recovery Strategies including Business Continuity Plans.
  • Researched and Developed strategy for migration of data and DBMS to cloud environment.
  • Developed plans and jobs for periodic data auditing and data security enforcement.
  • Produced the Project design and technical design documents for the EDW project and others such as Data and RDBMS Migration, Disaster Recovery, Capacity Planning etc.
  • Responsible for team leadership and supervision of the Database Team, staff training and mentoring.

Data Implementation Lead

American Insurance Group
01.2008 - 11.2010
  • Implemented, supported and managed large Oracle Databases on Solaris 10 with SAN architecture including RAID assemblies.
  • Implementation, support of PEGA Application in a multi-tier and mission critical environment with Oracle backend on Sun Solaris OS with WebSphere as middle tier.
  • Technical Lead in a team administering several Oracle 9i and 10g databases (Data Warehouse and OLTP) for Production Support, Testing and Development in a 24 x 7 environment.
  • Coordinated and implemented changes to development, UAT, QA and production environments.
  • Implemented Database backup and recovery strategy using RMAN (Full, Incremental and Cumulative), use of Export/Import and use of customised scripts for cold and hot backups.
  • Performed regular database and schema cloning and refreshing using RMAN and Export/Import dumps.
  • Implementation of several Database Upgrades from 9.2.0.8 to 10.2.0.2.
  • Responsible for capacity planning, database sizing, space, memory and disk I/O monitoring.
  • Implemented object, instance and database level security policy using password management policies, data encryption, creating and maintaining profiles, users and roles.
  • Implement User auditing procedure and database monitoring system to ensure data integrity.
  • Responsible for resolving database and application problems from Service Desk within the agreed SLA and according to the company and department laid down policies and procedures.

Database Support Manager

Ford Motor Company
10.2006 - 11.2007
  • Production Support of Business-Critical Applications on multiple Oracle Databases sitting on Sun Solaris, Linux and Windows OS in a 24 x 7 environment with Oracle Application Server as middle-tier.
  • Responsible for RDBMS Backups, Restores & Recoveries using RMAN, BMC Sql-Backtrack and Scripts.
  • Responsible for database and object level security by implementing and maintaining database security such as creating and maintaining users, roles, grant and revoke privileges. Provided monthly Database audit for production databases to management.
  • Perform database & application tuning, ensuring proper database design, mem allocation & disk I/O.
  • Responsible for space monitoring, sizing, capacity planning and database security on both Operating Systems and Oracle Databases.
  • Responsible for and performed Oracle Security patches releases and bug fixes.
  • Technical Lead in production releases in liaison with developers, business analysts and project managers. Ensured database change request is strictly adhered to and any changes documented.
  • Administration and support of ETL processes using DTS and SSIS. Migrated DTS packages to SSIS.
  • Production support and daily administration of several Microsoft SQL servers 2000 and 2005 on Windows NT, 2000 Server 2003 servers in a .NET environment.
  • Involved in the design and implementation of, DR (Data Replication), warm-standby (Data Log Shipping, Database Mirroring) database solutions.
  • 24 x 7 on call support within defined Service and Operational Level Agreement.

Database Engineer

BT Consulting
04.2004 - 08.2006
  • Responsible for Oracle Database administration and support for production, training, development, and test platforms on Oracle versions 7, 8i, 9i, 10g and Oracle Applications E-Business Suite 11i.
  • Implementation and support of Oracle Apps 11i databases, performing patching, cloning and refresh.
  • Responsible for Database and UNIX files backups, restores and recoveries using scripts and RMAN.
  • Responsible for database refreshes using Export and Import and Hot backup Cloning on Standby, Training, Development and Test Databases. Responsible for database capacity and security planning.
  • Performed several Oracle Database upgrades and migrations using Exp/Imp and Migration Wizard.
  • Configuration and support of Oracle Data Guard on Solaris OS for High Availability.
  • Perform database, application and Sql tuning and optimisation and monitoring using OEM and TOAD.
  • Wrote SQL, PL/SQL scripts and shell scripts for database performance and operating system housekeeping. Write shell scripts for oracle and UNIX files backup and recoveries.
  • Involved in providing production support and administration of MS SQL Server on Windows NT4.
  • Installed and configured SQL Server 2005 in development, test and production environments.
  • 24x7 on call support within Service Level Agreement tolerance.

Database Engineer

Ericson
10.2003 - 02.2004
  • Responsible for administration and support for Production and Development/Test Oracle 9i Data Warehouses and OLTP for PrePaid Telephone Networks Management Project.
  • Responsible for analysing indexes, tables and partitioned tables and index rebuilds on a regular basis.
  • Installation and configuration of Oracle 9i from on Sun Fire V1280 and V480 with Solaris 5.8 OS.
  • Optimisation of Sql queries and database performance tuning using Tkprof and Statspack.
  • Responsible for database backups using Veritas Net backup and database crash recoveries.
  • Responsible for space monitoring, sizing, capacity planning, bug fixes, testing and database security.
  • Documentation of DBA procedures and tasks such as health checks, backups, and recovery.
  • Passed on Oracle DBA knowledge to members of staff and also perform staff training.
  • Wrote SQL and PL/SQL scripts for database performance and for other housekeeping duties.
  • Wrote UNIX shell scripts for operations such as checking for errors in alert logs, trace files & backups.

Education

MSc - Information Systems & Technology

City University

BSc (Hon) - Economics

University of Ibadan

Skills

Expert in data solution designs that align with business strategies and project requirements, employing structured, comprehensive approach and framework to achieve business objectives

Strong and effective stakeholder relationship management skills

Expert at building Conceptual, Logical and Physical Data Models including Canonical Models through the Business process models and business requirements

Expert in Data analysis, migration, modeling, integration and development of master data management solution, data warehouse/data marts concepts and applications with associated policy

Experience in creating Solution Blueprints, Data and Technical Architecture Specifications (HLD, LLD, TDD, and PDD) Expert in design and implementation of Information Catalogue and Business Glossary

Expert in developing End to End Data Solutions from Conceptual, to Logical, to Physical Layer These includes the designing and implementation of ETL processes and routines to support Business Intelligence (BI), Data Mining and Analytics

Expert in dimensional modeling (Kimball star/snowflake schemas, Inmon, Hybrid) and Data Vault 20 for building scalable EDWs

Skilled in Design and optimisation of 3NF relational database models for high-performance OLTP systems, ensuring data integrity and transactional efficiency

Skilled in design and implementation of modern scalable cloud-based data platforms (Databases, Data Warehouses, Data Lakes) on Cloud Platforms to enable advanced analytics

Sound knowledge of design and implementation of End-to-End data solutions using proven product, data and project management methodologies including Agile and Waterfall

Expert in Data Governance with focus on Data management policy, standards and Lifecycle Frameworks

Possess practical experience of Data administration and management skills which includes upgrades, migration, performance, backups, recoveries and business continuity planning (BCP) measures

Experience of middleware solutions such as ESBs and APIs in SOA and Microservices Implementation

undefined

Certification

TOGAF 9 Certified

Training

  • TOGAF 9.1 Foundation and Certified
  • Introduction to Big Data
  • Hadoop Fundamentals
  • Oracle Database Administration
  • MSSQL Server Administration
  • UNIX Systems Administration
  • Linux System Administration
  • Korn Shell Scripting

Timeline

Data Architect

University of York
11.2024 - 01.2025

Data Architect

Crisis
08.2023 - 08.2024

Data Architect

Hyperion Global Services
05.2020 - 07.2023

Data Architect

Intellectual Property Office
10.2019 - 01.2020

Data Architect

Department of Education
10.2018 - 09.2019

Data Architect

Shropshire Council
01.2017 - 09.2018

Data Architect

Office of Public Works
07.2015 - 12.2016

Data Architect

GeoPlace
04.2011 - 02.2015

Data Implementation Lead

American Insurance Group
01.2008 - 11.2010

Database Support Manager

Ford Motor Company
10.2006 - 11.2007

Database Engineer

BT Consulting
04.2004 - 08.2006

Database Engineer

Ericson
10.2003 - 02.2004

BSc (Hon) - Economics

University of Ibadan

MSc - Information Systems & Technology

City University
Yemi AyofeCertified TOGAF 9 Architect