| PROFILE: Accepted the challenge of a change in career direction and applied new skills to become proficient in DataStage ETL systems. Adaptable in providing support of Mainframe HR/Payroll, financials; Midrange financials; Midrange Purchase order. A professional employee of Thomas Cook/Travelex for twenty-six years who is able to communicate effectively and with confidence across all levels of management. A loyal and committed IBM mainframe HR specialist who has developed with the business in achieving its expectations in Payroll, Personnel, and Pensions.
TECHNICAL SKILLS 9 years DOS VSE/JCL 3 years Sybase SQL
16 years MVS/OS-390 JCL 10 years FileAid/AbendAid Ringwood Information Manager Cobol MS-Word CICS MS-Excel CA-Easytrieve Plus MS-Access Assembler MS-DOS TSO Qbasic Remedy Action Request system AIX VSAM Sybase version 10 UniPay Unicenter AHD Unipersonnel VB (3) Endevor Windows 95,2000,XP SDSF 5 years DataStage (6 ; 7) SAR VBA Connect Direct PGP Sams Disk KEY SKILLS: Provide the Datastage knowledge / expertise within a multi disciplined team for the migration of a legacy payroll system to SAP for Nordea. Team player developing Datastage 7 jobs within an HP-UX environment to validate and transform DHL operational and master data to SAP. Team player developing Datastage 7 jobs within an AIX environment to validate and transform HSBC operational data for their Global Credit Risk DB2 DataMart. Responsible for the Travelex ETL Call Centre update using Ascential DataStage. Identified and applied enhancements to Datastage procedures to reduce manual intervention Experienced IBM MVS analyst/programmer with PC/Unix programming exposure. Provided end-user support for the HR, Payroll and Financial package systems. Provided system enhancements and upgrades of mainframe financial systems (General Ledger; Fixed Assets; Purchase Ledger; Reconciliation; Reclamation) and Human Resources (Payroll/Personnel). Managed a small team who provided the technical ability and business knowledge for the end-user. Provided the 24x7 operation support for the HR and Payroll applications. Achieved a high level of knowledge and expertise in the specialised area of HR and Payroll applications, which under his stewardship remained operational for twenty five years. MAJOR ACHIEVEMENTS: Replacement of the 3rd party legacy Payroll to SAP R/3 FI interface with 3rd party SAP FI to SAP FI interface whilst maintaining the functionality of the in house audit tracker system; posting transactions to local MSA G/L and excel reconciliations to the business warehouse for Nordea. Migration of DHL "France" vendor master data from six accountancy systems to SAP including de-duplication; cleansing, and enhancement. Migration of the Ceridian Pradigm/Paylink (Access 2) system to a Northgate/Rebus HRonline system for Motability Operations with restricted IT support. Responsible from January 2003 for the running of the ETL process of the Travelex Call Centre system for 34 corporates, and developing processes for new clients as well as enhancements to the existing. The call centre ETL function is run by IT for the Business. Mike completed the automation, to maintain data integrity, of a manual process for a corporate that had been active for three years. Mike was responsible for the successful upgrade of DataStage 3.6 to 6.0.1. Developed numerous extract and reformat scripts to facilitate the transfer of Payroll and HR data from the Rebus mainframe systems to Centre File and SAP Payrolls. Responsible for the transfer of all mainframe Payroll and HR data to an Access 2000 database in preparation for the mainframe systems decommissioning. In collaboration with payroll and compensation and benefits installed a profile related pay scheme which increased employee pay and reduced company NI costs by 3m per tax year. Reduced stationery costs by replacing multipart impact print payslips and P60 with Laser. Reduced manual payroll update by EDI automation of tax code changes. Reduced joiner/leaver manual processes by EDI automation of P45/P46 returns. Managed the support team for the Mainframe Rebus Payroll, Personnel; MAS/MSA financials and Corona/Hermes reconciliation systems. This includes installation and testing of all statutory changes and product enhancements within strict time scales. Inspirational in the development and use of the Ringwood Information Manager mainframe/PC data transfer package used by the HR community for transfer of data from the mainframe to the PC. Shown adaptability by providing support with minimal notice for a Unix/Sybase Platinum Software Purchase order system when the development team was disbanded. The Purchase order system was supported from May 1995 until 1998. Project managed the upgrade to Unix, Sybase and the application software during this period. Trained four colleagues in the systems and technology supported by the team including the Indian personnel recruited as his replacement. Developing the first CICS systems (financial Budgeting) for Thomas Cook in 1978
|