The following profile is a candidate from IT Consultants Direct "ITCD".
http://www.it-consultants-direct.co.uk/
  This candidate can be contacted via the following link:
mailto:candidates@itcd-group.co.uk?Subject=GA13997S
  The complete ITCD candidate database can be accessed at:
http://www.it-consultants-direct.co.uk/search.html
  Please note that you will need to register with us before direct contact with any candidate can be arranged. This is to protect both the candidate's privacy and yours. Registration is free and without obligation. We are registered under the data protection act and the data we hold is for our own internal use only, we do not share this data with anyone outside of ITCD unless required to do so by law.
 
PROFILE

Highly skilled Oracle Applications Technical Consultant, with 20 years Oracle functional and technical experience gained in mainly senior roles working on a variety of large, high profile projects. Curre[snip]y based in the UK, but offering international project experience acquired mainly in South Africa, Europe and the UK. A highly motivated and focussed professional with a solid track record of achievement, demonstrating proven ability to interpret client requirements and implement effective solutions, utilising expert functional and technical knowledge of Oracle Financials, HRMS/Payroll, OTA, OTL and HRSS modules, together with extensive IT systems and applications training. Excellent team leading ability, with effective coaching and training skills, demonstrated in the role of team leader on most projects.

KEY CAREER ACHIEVEMENTS

• Acting as a Payroll Functional consultants in successfully designing and implementing solutions as an Oracle Payroll specialist on the Oracle Payroll implementation for [snip] in the UK on versions 11.5.10.

• Acting as the solution design architect in successfully designing and implementing solutions as an Oracle HRMS/Payroll specialist on various HRMS/Payroll implementations for [snip] in the UK on versions 11.5.9 and 11.5.10.

• Part of a strong application development and testing team doing support, training, development and testing as an Oracle HRMS/Payroll specialist on the world’s largest Oracle HRMS/Payroll implementation for the [snip] in the United Kingdom on 11.5.9/10

• Acted as the Team Lead successfully implementing auditing in HR, OTA and OTL. Defined and developed HR, OTA and OTL reports using Discoverer 4.1.48 for [snip] in the United Kingdom.

• Part of a very strong application support and development team doing second line support, training and development as a Oracle HRMS and Payroll specialist on the world’s largest Oracle HRMS/Payroll implementation for the [snip] in the United Kingdom.

• Selected to be part of the data migration team in designing and migrating legacy data to the Oracle HRMS application at the [snip]. Lead the formulating and compiling of the Data Migration System Test Strategy and System Test Plan.

• Selected to lead the successful design and implementation process for a high profile HRMS and Oracle Financial solution project for the [snip] financial brokers.

• Managed the implementation of a highly effective, bespoke HR Self-Service solution for the [snip]. Successfully resolved significant payroll issues and delivered solutions within strict timescales.

• Designed and implemented a complex generic payroll migration tool for [snip], successfully eliminating manual employee data capture from 3rd party payrolls.

• Implemented a highly effective, bespoke payroll calculation solution for [snip], designed to calculate employee occupational sick pay. Increased efficiency reduced processing time and eliminated the need for manual calculations for the first time in 5 years.

• Successfully completed a key position hierarchy integration solution for the [snip] retail outlet. Developed and Implemented a crucial interface between HRMS 11.0.3 and 11i, allow the use of a 26 000 position hierarchy created in 11i to be transferred to 11.0.3.

• Led the development and implementation of a major, bespoke HRMS solution from scratch for the [snip] financial services company, enabling a higher degree of efficiency in all HR and Payroll procedures within the company for the first time.

ORACLE TECHNICAL EXPERIENCE

• Tools
Oracle Forms 4.5/5/6i
Oracle Reports 2.5/3/6i
Oracle SQL*Plus 3.3/8.x
Oracle PL/SQL 2.1/8
Oracle SQL*Loader 2.1
Oracle Discoverer 3.1/4i
Oracle Workflow Builder V2.6
Designer/2000 2.1
DataLoad Professional 4.1
Toad 7.2
• Financials
Release 11.0.3/11i (GL, AP, AR, PO, FA)

• Human Resources
Release 10.7/11/11.5.5/11.5.7 /11.5.8/11.5.9/11.5.10
(HRMS, Payroll, OTA, HRSS,SSP/SMP, OTL)
• Databases
Oracle 6/7/8.x/9.2.0/9iAS/9i Enterprise Edition/9.2.0.5.0/9.2.0.6.0
• Oracle Skill Set
Many years experience in numerous Oracle DBMS/access methods, programming languages, methodologies/CASE and applications. Detailed skill set available on request.

RECENT CAREER HISTORY

June 2005 – [snip] - Senior Oracle Applications Consultant

Provided technical and functional applications consultancy services to various clients in the UK.

Client: [snip] – Jan 2007 – current
• Acting as an Oracle Payroll Functional specialist in defining the solution design and implementing all aspects of the Oracle Payroll using HRMS 11.5.10 and RDBMS 9.2.0.6.0.
• Engaged in compiling System Test Scripts and System Verification Testing
• Supporting the business users in conducting User Acceptance Testing

Client: [snip] – Jan 2007 – Feb 2007
• Designing and mapping employee and payroll data to be extracted for a third party payroll system
• Developing migration scripts to extract employee and payroll data from the Oracle HRMS system using PL/SQL on a RDBMS 9.2.0.6.0 database

Client: [snip] – Sep 2005 – Jan 2007
• Acting as the architecture in defining the solution design and implementation of changes to the newly implemented Oracle Payroll system using HRMS 11.5.9/11.5.10 and RDBMS 9.2.0.5.0/9.2.0.6.0.
• Configuring all aspects of Oracle HRMS/Payroll and System Administration
• Developing custom modules as an extension to the existing Oracle HRMS system using PL/SQL, SQL*Loader, SQL*Plus, Oracle Reports 6i and Discoverer 4.1.8
• Training team members and users in the use of Oracle HRMS
• Engaged in functional support and testing of customisations of inbound and outbound interfaces and reports
• Analyze, develop, design, implement, and deliver solutions in accordance with best business-practices, and project processes and procedures using the Oracle AIM methodology
• Review, impact assessment, testing and implementation of enhancements, Oracle patches and family packs
• Creation of Test Plans and Test Scripts
• Compiling Technical and Functional specifications
• Conducting impact analysis on new functional requirements
• Executing of system and regression testing of the new/changed modules and/or functionality

Client: [snip] – Jun 2005 – Sep 2005
• Acting as the architecture in defining the solution design and implementation of changes to a complex Oracle Payroll system with integration to and from Oracle Time and Labour using HRMS 11.5.9/11.5.10 and RDBMS 9.2.0.5.0/9.2.0.6.0.
• Acquired in depth knowledge of SSP/SMP and design and build a custom model for OSP to integrate with the standard UK Payroll.
• Engaged in system configuration and act in an advisory role to other members on the team
• Analyze, develop, design, implement, and deliver solutions in accordance with best business-practices, and project processes and procedures.
• Executing in depth system testing of developed and configured system

Aug 2003 – present [snip] - Senior Oracle Applications Consultant

Provided technical and functional applications consultancy services to various clients.

Client: [snip], London, England (Oct 2004 – Sept 2005)
• Part of a very strong application support and development team analysing and resolving implementation and customisation issues within the Electronic Staff Record (ESR) system using HRMS 11.5.9/11.5.10 and SSHR 4.2.1, OTA, Discoverer 4.1.44 and Web ADI. RDBMS 9.2.0.5.0/9.2.0.6.0.
• Acquired in depth knowledge of the UK Payroll legislation and configuring all aspects of Payroll
• Engaged in system configuration and client support for the [snip] project on HR, Payroll, System Administration, interfaces, customizations and data migration. Tasks also involved functional support and testing of customisations and interfaces.
• Analyze, develop, design, implement, and deliver solutions in accordance with best business-practices, and project processes and procedures.
• Review, impact assessment, testing and implementation of enhancements, Oracle patches and family packs
• Creation of regression test scripts using Mercury TestDirector 7.6SP3
• Executing regression testing according to detailed test scripts
• Executing in depth system testing of developed and configured system

Client: [snip], London, England (Jul 2004 – Aug 2004)
• Part of a strong HR application technical team defining HR, OTA and OTL report requirements for development and implementation in Discoverer v4.1.48 using HRMS 11.5.9 (Family Pack G) and SSHR 4.2.1, OTA and OTL.
• Defining and Installing Auditing on the HR, OTL and OTA installations
• Executing system and regression testing on the developed reports
• Compiling Functional and Technical specifications on implementing HRMS auditing and auditing reports
• Developing of audit reports in Discoverer

Client: [snip], London, England (Nov 2003 – Jun 2004)
• Part of a very strong application support team analysing and resolving implementation and customisation issues within the Electronic Staff Record system using HRMS 11.5.7/8/9 (Family Pack G) and SSHR 4.2.1, OTA, Discoverer 4.1.44 and Web ADI. RDBMS 9.2.0.5.0
• Mentoring and coaching of key personnel in the Oracle Application
• Executing regression testing according to detailed test scripts developed
• Executing system testing of developed and/or configured functionality

Client: [snip], Chelmsford, England (Jul 2003 – Nov 2003)
• Successfully formulated and compiled the Data Migration System Test Strategy and System Test Plan for the Oracle HRMS implementation which comprises 9 business groups.
• Successfully configured one of the business groups ie Key Flexfields, Descriptive Flexfields, Business Group Set-up, Value Sets, Value Set Values, etc.
• Successfully loaded data using DataLoad Professional and published HRMS APIs to load organisations and locations
• Successfully delivered customised HRMS APIs to reconciliate the Oracle Payroll results with the Legacy Payroll System and a third party CarPlan system

Mar 2001 – July 2003 [snip] - Senior Applications Technical Consultant

Provided technical applications consultancy services to various clients of this Oracle implementation company, which is an advanced Oracle partner.

Client: [snip], Dublin, Ireland
• Conducted a comprehensive evaluation of the HRMS requirements of this insurance company, before formulating recommendations and successfully implementing customised HR Self-Service and Workflow process solutions.

Client: [snip] Yamane, London, England
• Successfully delivered customised HRMS, Payroll and Oracle Financials interface solutions for this London based financial broker, involving the development of a number of key interfaces to 3rd party systems, enabling the migration of existing data.
• Performed full range of technical team leading responsibilities, including training, consulting, project scheduling and costings, compiling technical specifications, test plans and migration and installation documentation, plus QA and system testing.

Client: [snip], Bromley South, Kent, England
• Designed and delivered bespoke HRMS payroll solutions for this large insurance group.
• Solutions included a generic external payroll migration tool, incorporating HR Data Pump and HRMS core APIs and a customised module to automate the processing of statutory occupational pay entitlement, which required the development of specially customised APIs.
• Provided a customised configuration of HRSS, including customised Self-Service functionality and tailored workflow processes.

Client: [snip], Coventry, England
• Managed a project to process mass employee terminations within a specific business group. Utilised standard Oracle HRMS APIs in the successful delivery of this project.

Client: [snip], London, England
• Implemented a highly effective solution involving the creation of Oracle event alerts, designed to mail alerts to the relevant managers when positions had changed in the system.
• Designed Oracle Training Administration functionality to create training courses on the HR side after being scheduled on the Self-Service side. Utilised standard PL/SQL programming and core HR APIs in the delivery of this solution.

Client: [snip], London, England
• Delivered a key Position Hierarchy Interface solution between different versions of HRMS, from creation of technical specification through to acceptance testing and full implementation.

Nov 2000 - [snip] - Applications Technical Consultant

Client: [snip], Geneva, Switzerland
• Technical consulting role for this well known international trade organisation, with the remit to design and develop a series of key reports and extracts from HRMS.

Oct 1998 – Feb 2001 Oracle SA - Applications Technical Consultant

Client: [snip], South Africa
• Performed the roles of technical consultant and technical team leader in a major implementation for this financial services company, the 2nd largest in South Africa, with overall project and resource management responsibility.
• Managed all aspects of the development and implementation of the HRMS application, including the design and development of a database model, PL/SQL interfaces, several HRMS modules and a range of new reports.

Feb 1994 - Sep 1998 Various Contract Positions

[snip] (Largest Telecommunications Company), South Africa
Medscheme (Medical Fund Administration Company), South Africa
MTN (Mobile Network Company), South Africa

PREVIOUS CAREER HISTORY

Details of career history prior to 1994 available on request.

TECHNICAL EDUCATION

Extensive formal IT systems and applications training including Unix, Oracle, Infomet, C, SQL and PL/SQL. Detailed list of technical training available on request.

LANGUAGES

English and Afrikaans

REFEREES

Available upon request


                                 
 
 
 
© 2004, 2005 Copyright IT Consultants Direct Ltd. All Rights Reserved.