Terry Patmore
Orewa,AUK
Summary
Skilled [Type] Specialist focused on maximizing [Description] success through effective use of [Skill], [Skill] and [Skill] abilities. Top-notch communicator with excellent time management, administrative and customer service skills.
Overview
14
14
years of professional experience
Work History
Data Migration Specialist
NEX Building Group
01.2024 - Current
- Lead the migration from Oracle Fusion Human Capital Management to Cornerstone OnDemand Human Capital Management solution
- This included: Workforce data, Compensation data integrated with ADP, Learning modules (LMS)
Data Lead
Te Whatu Ora Health New Zealand (ADHB)
12.2024 - 12.2024
- Lead the data team (54 people) involved with the Tu Pono Aroha PAS (Patient Administration System) implementation
- This includes: Leading multiple teams: Data Migration; Business Intelligence; Data Engineering; Reporting; Data Architecture, Lead Data Governance, Vendor Management
Data Lead Data Migration
Metlifecare
12.2022 - 07.2024
- Lead the data migration from VCARE and Greentree to D365 CE and FinOps, Pipeline development using ADF
Project Manager Data
Plumbing World
06.2024 - 01.2024
- Lead the Data Migration for the 56 Branch network from Frameworks to D365 F&O and Supply Chain
- This included: Script development, Pipe build via ADF (Azure Data Factory) using kingswaysoft, Data Migration Strategy development, Data Cleansing, Requirements gathering for Reconciliation Reports, DevOps via Azzure
Data Lead Data Migration
The Warehouse Group
10.2022 - 02.2023
- Lead the data migration from legacy systems into Oracle Retail and Oracle Financials
Data Migration Lead
Downer
07.2022 - 12.2022
- Manager the migration from COINS to JDE 9.1
- This includes: Develop Data Migration Strategy and Plan, Field mapping with SME’s, Build of Data Migration Environment for Extract, Transform and Load, Requirements gathering for Reconciliation Reports
Data Chapter Lead
Compello Partners (USA based firm involved in Mergers and Acquisitions)
05.2021 - 12.2022
- Provide Data Migration expertise to Compello Partners
- The systems migrated in/out of include: HubSpot, Zoho, Shopify, SkuVault, SAP Business by Design, NetSuite, Salesforce (CPQ, CLM) and D365 F&O (Supply Chain)
Data Migration Specialist
Parliamentary Services
02.2021 - 08.2022
- Migration of legacy Petition, Select Committee Reports, and Member Reports to a new custom-built platform
Technical Business Analyst
ASB Bank
02.2021 - 06.2022
- Key deliverables include: Data lineage of Critical Data Elements (CDE’s), Development of Data Quality rules
Technical Business Analyst (BI)
Fulton Hogan
06.2020 - 01.2022
- BI related projects including: Data lineage of Financial Reports using SSRS, SSIS and SQL, ‘As Is’ and ‘To Be’ process mapping, Development of SQL scripts to reconcile the migration of prod source data to a new EDW model, System testing of EDW models for UAT and Prod releases
Data Consultant
Chorus
03.2020 - 12.2021
- Lead the Data Migration for a salesforce classic to Salesforce Lightening upgrade including: Development of Data Migration Strategy, Lead the field mapping, cleansing and profiling, Developed ETL scripts via SSIS and SQL, Migration of structured and unstructured data, Development of Reconciliation scripts
Data Migration Lead
ERoad
08.2019 - 03.2020
- Lead the data migration activities for a migration from an old classic instance of Salesforce to D365 F&O (FinOps and Supply Chain) and lightening Salesforce, including CPQ and CLM
- This included: Leading the field mapping, cleansing, profiling and data transformation activities, Lead the ‘As Is’ and ‘To Be’ process mapping, Generate the SSIS/SQL scripts to migrate data from legacy systems to D365 F&O and Salesforce
Data Migration Lead
AMP Financial Services
03.2019 - 10.2019
- Lead the Data Migration activities as part of the demerger (separation) from AMP Australia and sale of AMP Life
- This included: Development of Data Migration Strategy, Slice NZ Data from AMP Australia and migrate to Salesforce, Lead Data integrity management during the transition, Lead the Data Transformation activities, Lead the Data Migration Team
Senior Business Analyst
Horizon Energy Group
10.2018 - 03.2019
- Migration of legacy systems (simPRO/Accredo/MYOB) to Pronto 740
Data Consultant
PlaceMakers
10.2018 - 12.2018
- Migration of Product Master data from JDE/ACE to Innovit’s PIMS (Product information Management System)
Senior Business Analyst
Vodafone
07.2018 - 06.2018
- Involved in numerous projects gathering requirements, facilitating workshops and generating User stories/Requirement documents
- This includes the following projects: Digital identification– biometric scanning of new Customers to validate identity, improve the Customer journey and reduce fraud, Digital mobility – enhancing the Customer journey through digital mobility, Involved in a RRT (Rapid Response Team) to improve the Customer Journey through simplification of the CRM systems
Technical Business Analyst
Chorus
07.2017 - 06.2018
- Provide technical support for the Data Migration Billing Replacement project (ICMS/Singl.eView/Salesforce to SAP ECC), Mapping Business processes to ensure they align with the new system, Data Mapping, ETL, Develop reconciliation reports, Facilitating workshops
Business Analyst
Fletcher Building – NZ Distribution
01.2014 - 07.2017
- Involved in the following key projects: Data Migration of Peoplesoft to Workday HCM for Fletcher Building Corporate, ERP replacement project – Arma Plus for Fletcher Reinforcing, Data Migration of Peoplesoft to Workday HCM across the PlaceMaker network, Design and Implementation of a product Information Master System (PIMs) using GS1 standards
Project Manager
NZ Health Partnership Limited
05.2016 - 01.2017
- The key tasks involved the redesign of the National Data Hub
- The Data Hub holds all the purchase transactional data from the 21 DHB’s
- This involved: Requirements gathering, Data Architectural design, Database Design and Build, Develop new business processes, Development of a suite of Business Reports and Dashboards, Document and support the transition to BAU
Technical Business Analyst
2 Degrees
10.2015 - 05.2016
- The key tasks involved providing analytical support to the Data Migration Billing Replacement project
- This involved: Development of Reconciliation process for Source against Target (Oracle Stack), Automation of test scripts via PLSQL, Development of Reconciliation scripts (PLSQL), Development of Reconciliation Dashboards
Project Manager
Ingram Micro
06.2015 - 10.2015
- Rescue the Prime Mover project with Spark
- The project was 4 months behind schedule and the relationship between the two company’s project teams was toxic
- The main tasks were: Developed a project plan with clearly defined deliverables, Improved the relationship with Spark by delivering to the timelines, Provided data integration technical expertise
Senior Business Analyst
Health Alliance
07.2013 - 12.2013
- Involved in a Win 7 desktop migration
- The primary tasks were: The design and building of a SQL database with integration to SharePoint and Microsoft Access using SSIS to track progress, Migration of Applications to the Win 7 environment
Data Migration Lead
Auckland Transport
11.2012 - 09.2013
- Managed the migration of data from the Auckland Council legacy systems (DataWorks, RDC Pathway, WCC Pathway, SAP CRM, Resolve) to an EDW (Enterprise Data Warehouse) and CRM Dynamics
- This involved: Working with the owners of the legacy systems to extract the data, Mapping of data fields, Mapping of current business processes, Translation of data and data cleansing, Development of Functional Requirements and Functional Design documents, Design of a Web Form that interfaced with the EDW as the UI for the user base, Development of SQL scripts to massage the raw data from the Council legacy systems and transforming the data into a format suitable for the EDW, Development of Test Plans
Data Migration Lead
Health Alliance
04.2012 - 07.2013
- Migration of data from CRIS to 3M Health System
- This involved: Development of a Data Migration Strategy (100M documents to migrate; 100% accuracy required)
- Large volumes of unstructured data, Leading the data migration process within an international project team, Management of data cleansing – 100 million pages and 10.5 million client records, Development of a reconciliation process to ensure 100% accuracy via SQL scripts, Managing the cutover of 32 interfaces from the legacy system to the 3M Health System using HL7 integration standards
Data Migration Lead
Dept. of Statistics
08.2012 - 12.2012
- Migration of data from legacy systems to Microsoft CRM Dynamics
- This involved: Scrum Master for the agile software enhancements and migrations, Leading the data migration process, Management of data cleansing, Development of current state and future state process documents, Running User workshops
Data Migration Lead
Mercury Energy
12.2011 - 04.2012
- Migration of data from Siebel to SAP CRM and SAP IS-U
- This involved: Development of a Data Migration Strategy, Development of extract scripts from Siebel using SQL, Data cleansing, Documenting current state processes, Building the load package using LSMW (SAP import work bench)
Data Migration Lead
Southern Cross Insurance
11.2010 - 12.2011
- Migration of data from Oracle Financials to Technology One
- This involved: Development of extract scripts from Oracle Financials using PL/SQL, Development of a reconciliation system, Data cleansing, Data Transformation using Microsoft Business Intelligence Development Studio (BIDS), Building the load package using SQL Server Integration Services (SSIS), UAT (unit acceptance testing)
Education
Skills
- Data Migration Specialist
- Extensive experience in data migration This includes the following systems:
Datamanagementexperience
Extensive experience working with data. This includes: master data management; data analysis, integration, data profiling, data cleansing, data transformation, data governance, data modelling, data lineage (data trace), EDW fact and dimension design, econometric forecasting, report development via PowerBI, data mapping and ETL (Extract, Transform, Load).
Datamigrationexperience
- Oracle Fusion Human Capital Management (HCM) to Cornerstone OnDemand Human Capital Management solution, NEX Building Group, NewCastle, 01/01/YY - 01/01/YY
- Frameworks to D365 F&O Supply Chain, Plumbing World, 01/01/YY - 01/01/YY
- VCARE and Greentree to D365 CE and FinOps, MetLifeCare, 01/01/YY - 01/01/YY
- 3 Patient Administration Systems (PAS) to TrakCare, ADHB, 01/01/YY - 01/01/YY
- COiNS to JDE 9.1, Downer, 01/01/YY - 01/01/YY
- Multiple legacy systems to Oracle Retail and Oracle Finance, The Warehouse Group, 01/01/YY - 01/01/YY
- Legacy data into SAP Business by Design, NetSuite, Salesforce(CPQ,CL) and D365 F&O Supply Chain, Compello Partners (USA based Private Equity firm), 01/01/YY - 01/01/YY
- Old classic instance of Salesforce to a new lightening instance of Salesforce, Chorus, 01/01/YY - 01/01/YY
- Real estate data into ReThink (Salesforce), Ontario Apartment Group, 01/01/YY - 01/01/YY
- Old classic instance of Salesforce to D365 F&O (FinOps and Supply Chain) and lightening Salesforce, including CPQ,CLM, EROAD, 01/01/YY - 01/01/YY
- NZ data from the Australian instance of Salesforce to a NZ Salesforce instance, AMP New Zealand, 01/01/YY - 01/01/YY
- Legacy systems (simPro/Accredo/MYOB) to Pronto 740, Horizon Energy Group, 01/01/YY - 01/01/YY
- Product master data from JDE/ACE to Innovit PIMS, Fletcher Building, 01/01/YY - 01/01/YY
- ICMS and Singl.eView to SAP ECC, Chorus, 01/01/YY - 01/01/YY
- Legacy systems to the Oracle stack, 2 Degrees, 01/01/YY - 01/01/YY
- Legacy HR systems into Workday HCM, Fletcher Building Corporate, 01/01/YY - 01/01/YY
- Peoplesoft to Workday HCM, PlaceMakers, 01/01/YY - 01/01/YY
- Auckland Council legacy systems to CRM Dynamics/Data Warehouse, 01/01/YY - 01/01/YY
- Dept. of Statistics legacy systems to Microsoft CRM Dynamics, 01/01/YY - 01/01/YY
- MYOB to Unleashed Software, 01/01/YY - 01/01/YY
- CRIS (Auckland District Health Board) to 3M Health System, 01/01/YY - 01/01/YY
- Siebel to SAP IS-U and SAP CRM, Mercury Energy, 01/01/YY - 01/01/YY
- Oracle Financials to Technology One, Southern Cross Insurance, 01/01/YY - 01/01/YY
Timeline
Data Lead
Te Whatu Ora Health New Zealand (ADHB)
12.2024 - 12.2024
Project Manager Data
Plumbing World
06.2024 - 01.2024
Data Migration Specialist
NEX Building Group
01.2024 - Current
Data Lead Data Migration
Metlifecare
12.2022 - 07.2024
Data Lead Data Migration
The Warehouse Group
10.2022 - 02.2023
Data Migration Lead
Downer
07.2022 - 12.2022
Data Chapter Lead
Compello Partners (USA based firm involved in Mergers and Acquisitions)
05.2021 - 12.2022
Data Migration Specialist
Parliamentary Services
02.2021 - 08.2022
Technical Business Analyst
ASB Bank
02.2021 - 06.2022
Technical Business Analyst (BI)
Fulton Hogan
06.2020 - 01.2022
Data Consultant
Chorus
03.2020 - 12.2021
Data Migration Lead
ERoad
08.2019 - 03.2020
Data Migration Lead
AMP Financial Services
03.2019 - 10.2019
Senior Business Analyst
Horizon Energy Group
10.2018 - 03.2019
Data Consultant
PlaceMakers
10.2018 - 12.2018
Senior Business Analyst
Vodafone
07.2018 - 06.2018
Technical Business Analyst
Chorus
07.2017 - 06.2018
Project Manager
NZ Health Partnership Limited
05.2016 - 01.2017
Technical Business Analyst
2 Degrees
10.2015 - 05.2016
Project Manager
Ingram Micro
06.2015 - 10.2015
Business Analyst
Fletcher Building – NZ Distribution
01.2014 - 07.2017
Senior Business Analyst
Health Alliance
07.2013 - 12.2013
Data Migration Lead
Auckland Transport
11.2012 - 09.2013
Data Migration Lead
Dept. of Statistics
08.2012 - 12.2012
Data Migration Lead
Health Alliance
04.2012 - 07.2013
Data Migration Lead
Mercury Energy
12.2011 - 04.2012
Data Migration Lead
Southern Cross Insurance
11.2010 - 12.2011
Similar Profiles
James EvansJames Evans
Construction Supervisor at NEX Building GroupConstruction Supervisor at NEX Building Group
SEASTRUNK NATHANSEASTRUNK NATHAN
CONTRACTOR at Coffey Building Group Inc, RFJ Meiswinkel, MGM Drywall Inc, Sanders Contracting Inc, Magnum Drywall Inc Stockham Construction Inc Coffey Building Group IncCONTRACTOR at Coffey Building Group Inc, RFJ Meiswinkel, MGM Drywall Inc, Sanders Contracting Inc, Magnum Drywall Inc Stockham Construction Inc Coffey Building Group Inc
Christian HernandezChristian Hernandez
ADAS TECHNICIAL at NEX AUTOMOTIVEADAS TECHNICIAL at NEX AUTOMOTIVE
Ian ParkIan Park
Kokodak Silverdale at KokodakKokodak Silverdale at Kokodak
Bruce (Yiming) LiBruce (Yiming) Li
Cashier at Golden city takeawayCashier at Golden city takeaway