Position
Oracle HCM-Payroll Functional Consultant
Name
JOHN ODION OSHIOTSE
Date of Birth
04-April-1976
Gender
Male
Marital Status
Married
Nationality
Nigerian
Name of current location
Lagos
IT Experience
13 years
Relevant Experience in Oracle HCM
10+ years
Joining Period
Two weeks’ notice period
Do You Possess a Valid Passport
Yes (Passport No: A06443247)
Immediate Contact Number
+2348067377763

+2347056514732
Residence Number
24, Ponle Ajayi Street, Off Ogunrun, Mowe, Ogun
Experience in Business Process Analysis
As a functional Consultant it is mandatory for one to have knowledge of BPR because this is the basis for system setups. Business Requirement must be gathered, analyzed and mapped with the system to be implemented. This is to identify if there are gaps. Identified gaps are handled by what is known as solution design which include re-engineering, work around and customization in order to deliver the system/application for the Client.

Therefore, as a functional consultant I have much knowledge and experience in Business Process Requirement, acquired during my 4 end to end implementation of oracle HCM-Payroll applications.

Email Address
[email protected]

[email protected]
Phone
+2348067377763 or +2347056514732
Skype
johnodion1
Objective

·       To work with a world-class organization with view of developing my career

·       To maintain integrity and high sense of responsibility in whatever I find doing in a challenging environment

·       To bring to bear my educational background and various training obtained over the years while working with the organization’s resources in the pursuit of its goals

Job Description Summary

·      Conduct scooping in order to analyze and clarify the current business process in lieu with the future business process

Mapping the current business process (AS-IS) with the future business process (TO-BE) with a view to design and build a software solution tailored along with the organization business needs
Identify integration issues and develop a solution to those issues
Implementation and configuration of the system based on identified gaps to suit the organization business process.
Documentation of the implementation steps and procedures, and preparation of training manuals to assist clients in gaining better understanding of the system processes
Clarify processes to the end user and business stakeholders as expected to elicit comments and feedbacks
Provide guidance on technical feasibility and appropriateness of proposed solutions when alternative solutions are available.
Design and develop data migration tools such as Data loader for easy integration and migration of data
Provide supports on both pre and post go live with a view to resolve issues and helping the end users to understand the various application processes
Reporting project status and Liaising with technical personnel in resolving issues that are technically inclined.
Receptive to feedback/coaching on performance from clients and other members of the team.
Summary of work experience and expertise

·       SME Functional Head of Unit Oracle HR/Payroll Consultant

Project site:  Edo State Government)  Edo Nigeria                                              2009 to 2015

·       Oracle HCM implementer consultant between

Project site (Ecobank Group Transnational) Accra, Ghana                               Feb-2015 to Feb-2017

·       Oracle HCM implementer/ Support consultant

Project Site: Lagos State Government Lagos Nigeria                                         Feb-2017 to date

·       Oracle HCM implementer/Support consultant

Project site : African Reinsurance Cooperation) Nigeria/West Africa             Feb-2017 to date
Technical and Setup skill

Writing of oracle payroll formula and editing of EBS/Cloud fast formulas.
EBS/Cloud AME human resources application setup.
Data gathering.
Oracle iRecruitment
EBS/Cloud Oracle Performance Management
EBS/Cloud Oracle Learning Management
Oracle Advance Benefits
EBS/Cloud Oracle Self Service Setup
EBS/Cloud Oracle Payroll Setup
Requirement gathering skills (Scooping).
Preparing adequate deliverables for all modules.
Excellent Presentations skills using Microsoft Power-point.
Good knowledge using Microsoft Visio in analyzing process flow.
High knowledge of Microsoft Excel work sheet.
Excellent communication skills.
Good use of Data load for data migration for oracle EBS R12.
Project work experience
(1) Edo State Government Information and Communication Technology Agency

a. Project Name: Oracle HCM-Payroll Implementation Edo State Government) Edo, Nigeria.

SME Functional Head of Unit Oracle HR/Payroll Consultant                                                2009- 2015

Detailed Task Assigned:

First/Second level support on issues relating to HR and Payroll
Analyzing and aligning business process with the oracle application
Configuration of Key and Descriptive Flex Fields, Grade, Job, Position, Organization, Location, Salary Structures, Special Information Type (SIT)
Identify gap in business process requirements and design a work around
Defining Grade levels and Jobs by navigating through work structure in HCM responsibility
Feeding of elements (earnings) to allow for tax deduction
Creating and defining of Payroll and Payment methods
Creating of Elements and linking them using defined criteria such as grade, job, payroll, group etc
Fast Formula administration and implementation to drive employees allowances (elements)
Creating responsibility and assigning functions
HR and Payroll functions such as creating and updating employees records
User Administration
Running of Monthly Payroll
Issues/ Crisis management and general Troubleshooting
Coordination of the HR-Payroll Unit
Generation of customized Reports
Reporting to the Managing Director & the Director of Software Department.
Training of Staff & Various MDA’s
2. SoftAlliance and Resources Nigeria Limited, Lagos

b. Project Name: Ecobank Group Transnational.  Accra, Ghana.   Functional Consultant Oracle HR/Payroll                                                                                                                     Feb- 2015-Feb2017

Detailed Task Assigned:

Business Processing analysis and solution design taking into consideration the AIM procedure during implementation
Mapping organizations business process with the application in order to identify gap thereby building solution to bridge the gap.
Documentation of BP030  Gap Analysis Mapping, BP 40 Business Process as-is, BP 80 Business Process to-be, BR100 Application Configuration,MD050 Functional Design, RD020 Requirement Document, TE040 Test script and  D070 User Manual  etc  both Core HR and Payroll
Serve as second level support in resolving issues and liaising with the SME’s on the use of the application
Configuration of Key Flex Fields such as Job, Grade, People Group, Competence, Person Analysis of multiple Business Groups, Languages and Currency etc
Oracle modules currently implemented for Ecobank Group are; Core HR, SSHR, Payroll, OLM, OAB etc.
Defining Business Group for 48 African affiliates and 4 Global affiliates at Ecobank Group. Set up the key Flexfield structures for the Business Group- Job, Position, Grade, People Group, Competence, Cost Allocation and Bank Details. Also, specified descriptive flexfield contents, defined various descriptive flexfields – Additional Assignment details, Additional Personal Details, Location Address, Personal Address information, Special Information Type etc to align with the Ecobank business process
Identify gap in business process requirements and design a work around
Defining Grade levels and Jobs by navigating through work structure in HCM responsibility
Setting up of Absences in SSHR
Defining and Configuring Balances to drive Payroll Processes
Creating and defining of Payroll and Payment methods
Creating of Elements and linking them using defined criteria such as grade, job, payroll, group etc
Fast Formula administration and implementation to drive employees allowances and deductions(elements)
Run parallel payroll run and compared with the payroll of legacy systems.
Defining Menus and Function based on business requirements
Creating responsibility and assigning functions
Setting up of User profile options value for responsibilities. Security Profiles; HR: Business Group, HR: Security Profile, HR: Users Type Profile and MO: Operating Unit. Adapt of relevant Menus, Functions, Responsibilities and Users and attached to defined Business Group.
Training of Employees (SMEs) on the use of the application
Performing HR and Payroll functions such as creating and updating employees records
User Administration
Issues/ Crisis management and general Troubleshooting
·       Configured and tested Web Page Layouts for Learning management, and Self-Service Human Resources that include:

o   Configured iRecuitment and Self-Service Web Pages with Personalization Framework

o   Personalization of various levels mostly region including buttons and links

o   Defined profile options for personalization framework including tabular regions

o   Defined Key Flexfield segments for system administrators

o   Defined Descriptive Flexfields using the personalization framework for activation

o   Configured the E-Mail Address and the Global Button Bar

Developed the means to personalizing Logos by replacing default logos with personal logos
c. Project Name: Oracle HCM-Payroll Implementation Lagos State Government, Lagos, Nigeria.                                Functional Consultant Oracle HR/Payroll                                                                    Feb- 2017- to date

Detailed Task Assigned:

Serve as second level support for the Lagos state payroll system
Training of staff on the use of oracle payroll application to achieve desired result
Implementation of allowance such as non-accident allowance for drivers in the state with strong emphasis on fast formula to drive it
Implementation of change in statutory deductions such as contributory pension and tax with strong emphasis on fast formula to drive it
Implementation of Lagos State Pension Share and Pension Union for Pensioners with strong emphasis on fast formula to drive it
Help in monthly data migration and upload by using Dataloader and Batch element to ease and fasten payroll process for the month
d. Project Name: Oando Vitol Helios Divestiture Project, Lagos, Nigeria. Remote Support HCM Functional Consultant                                                                                                               May- 2019- Till date

Prepare Standard OUM Test Script for Core HR, Self Service, Payroll, OLM and Performance Management.
Carry out Hire to Retire process for all modules.
Quality Assurance on all the Data and modification to meet client requirement.
Use of Custom Application “TaskHUB” for project validation.
To verify all OVH Data are up to date and meet client requirement.
e. Project Name: OANDO.  Lagos, Nigeria. Functional Consultant Oracle HR/Payroll                                                                                                                    Jan- 2018- to date

Serve as second level support for the Organization Core HR, SSHR, AME and Payroll system
Resolution of issues relating to Core HR such termination of employees with future process, SSHR and absence management
Documentation of Test Script for User Acceptance Test (UAT) to ensure successful migration to production instance (OVH)
f. Project Name: African Reinsurance Cooperation (ARC).  Lagos, Nigeria. Functional Consultant Oracle HR/Payroll                                                                                                                Feb- 2017- to date

Detailed Task Assigned:

Serve as second level support for the Organization payroll system
Help in resolution of issues such defining Payment Method
Help in the setup of descriptive flex field for additional Element Type Details to capture the Base Balance, Gross Balance and the Element Name so as to be able to group it for the purpose of designing statutory Payslip
Personal Skills:
Good communication skill
·       High skills in the use of information and communication technology

·       Excellent navigation skills of oracle HRMS/Payroll application

Great inter-personal relationship
Work under pressure
A good team player
Work with little or no supervision
Good problem solving skill
·       Proven leadership skills and highly trainable

Time Management skills
Organizational, managerial, interpersonal and leadership skills
Training and Administrative skills
Research and Development
Auditing Abilities
Ability to work long hours to meet Client’s needs
Professional Skills:
Proficient user of Microsoft Office tools such as Microsoft Access, Excel, Word, Visio and Power-Point.
Working knowledge of Oracle Data Base
Unix operating system such as Linux OS
Visual Basics
Networking
Software Deployment
Database Design
Professional Certification:
·       Oracle HCM Implementer Specialist (OCS EBS)                           2015- Oracle University

·       Oracle HCM Cloud implementation Specialist (OCS Cloud)       2018- Oracle University

Educational History

M.Sc in Library and Information Science                                                                                       2010
Certificate in Data Processing/Internet Technology                                                                    2003
Bachelor Degree in Library and Information Science                                                                  2002
GCE Certificate                                                                                                                                   1994
WAEC Certificate                                                                                                                                1992
Training Obtained with Date

·       Quick project company Oracle Training, comprises of Oracle E-business suite HRMS/Payroll Essentials, Unix operating system such as LINUX, Oracle Database Management System.      2014

·       Edo state ICTA Training Unit, Certificates in Presentation and Leadership skills                         2014

·       Soft Alliance and Resources Ltd, Certificate in Enterprise Resource Planning

(Oracle E-business suite HRMS / Payroll Module)                                                                            2010

·       Quanteq Information Technology Services/VIPCG

Basic System/Network Administration, Database Mgt, Project Management,

Payroll Information System, Docuware Administration, Human Resource Mgt, Change Mgt and Auditing                                                                                                                                                    2009

Training Certificate Issued

Certificate in Presentation skill                                                                                                       2014
Certificate in Leadership skill                                                                                                           2014
Certificate in Oracle E-Business suite HRMS/Payroll Module                                                    2014