Data Migration Consultant
Riwal
(Other)
Skills
SSMS, SQL Server, SAS, VBA, MS Access, MS Excel, DAX, Power BI, Alteryx Designer, Python, Oracle NetSuite, Oracle PPM, SAP, MS Dynamics, DynaRent, MS Office, G Suite, MS Project, Crystal Reports, PeopleSoft, Infusionsoft CRM, Visio, Leisure, Textile Manufacturing, Journalism, Agriculture, Data Migration, NetSuite, ERP, InspHire, video conferencing, file sharing, ETL, MS SQL Server, SQL, SAP Hana, OPPM, Alteryx, training data, MS Access/Excel/VBA, Outlook, HTML, data modelling, Excel, Infusionsoft CRM, data extraction, PeopleCode, Paradox, Lotus
Project history
11/2019
-
07/2020
Worked with global subject matter experts & project managers to determine the data requirements for conversion to Oracle NetSuite and InspHire systems from MS Dynamics/Dynarent. G Suite was used exclusively and extensively for all aspects of the project, including collaboration, video conferencing, and file sharing.
Developed and executed ETL data migration and integration plans in a frequently changing environment, primarily using SSMS/MS SQL Server, VBA, MS Access and MS Excel.
Developed and executed ETL data migration and integration plans in a frequently changing environment, primarily using SSMS/MS SQL Server, VBA, MS Access and MS Excel.
11/2017
-
11/2019
Data Migration and BI Consultant
Yara International ASA
(Other)
Developed and ran the global data migration process, converting multiple standalone systems on all continents into the new OPPM system.
Worked with global production and sales & marketing managers to determine the data requirements for migration to OPPM.
Defined and developed data definitions, mappings, data templates.
Developed a self-checking data-input template to streamline the data migration process.
Provided technical and business guidance for the technical contacts to deliver high quality, timely project data.
Designed and developed MIS reporting using SQL, Power BI, DAX, and VBA, combining data from SAP Hana and Oracle PPM (OPPM) via Alteryx.
Prepared training data tailored to individual trainees.
Worked with global production and sales & marketing managers to determine the data requirements for migration to OPPM.
Defined and developed data definitions, mappings, data templates.
Developed a self-checking data-input template to streamline the data migration process.
Provided technical and business guidance for the technical contacts to deliver high quality, timely project data.
Designed and developed MIS reporting using SQL, Power BI, DAX, and VBA, combining data from SAP Hana and Oracle PPM (OPPM) via Alteryx.
Prepared training data tailored to individual trainees.
11/2009
-
08/2017
MIS Analyst Consultant
Various
Clients: Various across South-West France
Established an MIS reporting facility for a major tourism business, providing rapid, accurate information to senior management.
Designed and automated all weekly MIS reporting for senior management of a film production company, primarily using SQL/MS Access/Excel/VBA.
Installed robust processes for populating a complex petty cash system in Access.
Created Outlook VBA functions for producing HTML templates for the Marketing department.
Provided technical guidance in data modelling, data definition, mappings and data management.
Streamlined the payroll process through development of Excel functions.
Established an MIS reporting facility for a major tourism business, providing rapid, accurate information to senior management.
Designed and automated all weekly MIS reporting for senior management of a film production company, primarily using SQL/MS Access/Excel/VBA.
Installed robust processes for populating a complex petty cash system in Access.
Created Outlook VBA functions for producing HTML templates for the Marketing department.
Provided technical guidance in data modelling, data definition, mappings and data management.
Streamlined the payroll process through development of Excel functions.
05/2004
-
03/2009
IT Director
Effective Directory Ltd
(Marketing, PR and Design)
Developed successful digital marketing campaigns to attract local businesses to advertise.
Introduced online automated, tailored marketing campaigns using Infusionsoft CRM.
Sold the business in 2009 following relocation to France in 2006.
Introduced online automated, tailored marketing campaigns using Infusionsoft CRM.
Sold the business in 2009 following relocation to France in 2006.
06/1999
-
05/2004
International Athlete
UK Sport
Took a sabbatical from full-time work to train and compete at international level, competing for Great Britain on the track and in cross-country.
Project-managed the overhaul of legacy systems at UK sport, establishing data extraction and cleansing routines using MS Access/Excel/VBA.
Project-managed the overhaul of legacy systems at UK sport, establishing data extraction and cleansing routines using MS Access/Excel/VBA.
07/1994
-
06/1999
Senior Systems Analyst/Project Manager
Citibank
(Banks and financial services, 1000-5000 employees)
Project managed the data-migration of confidential legacy systems' data to the HR module of a new ERP system (Peoplesoft), including a complex payroll system. Data included personal information, employment details, salary and bonus history for over 3000 employees, including expats in multiple countries. The migration required extensive, detailed analysis and understanding of all HR processes, systems and data sources.
Streamlined the compensation process through the development of effective MIS systems, using VBA, SQL, MS Access, MS Excel, Crystal Reports and PeopleSoft .
Established complex year-end compensation systems reports - sourcing data from European personnel systems, from head office in New York and from market data companies.
Analysed the data and calculation of year-end bonuses and tax-efficient ways for paying those
bonuses.
Streamlined the compensation process through the development of effective MIS systems, using VBA, SQL, MS Access, MS Excel, Crystal Reports and PeopleSoft .
Established complex year-end compensation systems reports - sourcing data from European personnel systems, from head office in New York and from market data companies.
Analysed the data and calculation of year-end bonuses and tax-efficient ways for paying those
bonuses.
Local Availability
Only available in these countries:
Norway
