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=RA14424S
  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.
 

Professional Summary 

Six years of software development, implementation and consulting experience in Oracle HRMS Applications 11i and 12i E-Business Suite. 

Experience of two full cycle implementation of Oracle HRMS applications and involved in two Oracle HRMS upgrade projects. Three years of Oracle HRMS Localization product development experience from Oracle Corporation, India Development Center. Three years of Team leader experience and managing of on-shore and off-shore teams. 

Comfortable in implementation , design ,development and  customization of Oracle Core HR, Payroll, Labor Distribution (OLD), SSHR, iRecruitment, Learning Management (OLM) and Advanced Benefits (OAB). Responsible to prepare the Functional, requirements definition, solution design, interface design, data migration analysis and cleansing, reporting requirements and custom components technical specifications using Oracle AIM documentation methodology.  

Conduct user requirement workshops, CRPs, UATs, cross functional discussions and prepare meeting minutes and getting the acceptance from the business users and respective cross functional teams. Responsible for Production setup configurations, Prototype design, development, End user training, Training material documentation and support of the applications.

Having more than three years of overseas consulting experience and worked with various clients like [snip], Switzerland for implementation of Oracle HRMS applications, British Airport Authorities (BAA) London Gatwick airport for the upgrade of Oracle HRMS Applications, [snip] Egypt for the customization of SSHR Applications and [snip] Riyadh for the upgrade of Oracle HRMS applications and implementation of iRecruitment and Self service HR.  

Currently located in Switzerland and working for Oracle HRMS applications implementation project at [snip], Geneva, Switzerland.

Visa Status

Country

Type of Visa

Duration

United Kingdom

HSMP Visa

AUG-2009

 

Education

Degree

University

Year of Passing

M.C.A

KMPGC, Kakatiya University, Khammam

Dec 2000

B.Sc. (Computers).

Sadhana Degree College, Kakatiya University ,Khammam

Dec 1997

 

Employment History

Organization

Designation

Duration

[snip]., India

Sr. Systems Analyst

02/2004- till date

[snip] (India Development Center)

Applications Engineer

05/2001- 01/2004

 

Overseas Project Experience

Client Name

Project Description

Duration

[snip], Geneva, Switzerland

Oracle HRMS Applications Implementation.

11/2005 – till date

[snip], London ,U.K

Oracle HRMS Applications upgrade from 11.0.3 to 11.5.10 and Implementation of Oracle Learning Management (OLM)

11/2004 – 8/2005

[snip], Riyadh, Saudi Arabia

Oracle HRMS Applications upgrade from 11.5.7 to 11.5.9 and Implementation of Self service HR V4.0 and iRecruitment

05/2004- 10/2004

[snip], Cairo , Egypt (End Client)

Oracle Consulting, Egypt (Direct Client)

Oracle SSHR V3.0 customizations

02/2004- 04/2004

 

 

Competency

ERP Packages

Oracle HRMS Applications 11.0, 11i and 12i in the following modules 

1.      Core HR

2.      Payroll

3.      Labor distribution (OLD)

4.      Self Service HR (SSHR)

5.      iRecruitment

6.      Oracle Learning Management (OLM)

7.      Advanced Benefits (feasibility study)  

Oracle Foundation modules and other  

1.      Oracle Approval Management (AME)

2.      Discoverer 4i, 10G

3.      Oracle XML Publisher

4.      Oracle Web ADI

5.      Personalization & Customization of SSHR

6.      OA Framework 5.7H/5.10

7.      Oracle Alerts

8.      Applications Object library(AOL)

9.      DBA activities - Ad utilities, HRMS Legislative Data installation. 

Documentation methodologies

Oracle Applications Implementation Methodology (AIM)

Databases

Oracle 7.3/9i

Database and development Tools

 Oracle SQL, PLSQL, Developer 2000(Forms 4.5/6.0, Reports 2.5/6.0),JDeveloper 3.2/9i, Workflow 2.6 and SQL*Loader. 

Applications Utilities (FNDLOAD , PYUPIP, PYLOAD, AKLOAD, OAFWK JRAD import, export, HRMS Data pump)  

Testing and Version control Tools

Mercury Test Director, Kintana, PVCS

Third Party Tools for Development

TOAD 7.3 , SQL Navigator, SQL Developer and DATALOAD

Operating Systems

UNIX ,Unix Shell Scripting, Windows 95/98 , MS-DOS 6.2, Linux

 

 

Projects Profile 

1. Project Name

Oracle HRMS Implementation

Client

[snip] ,Geneva, Switzerland

Module Covered

Oracle HR, Payroll, Labor Distribution (OLD), Oracle Learning management (OLM) ,AME and Oracle Self Service HR

Role

Payroll, Core HR, SSHR, Labor distribution Functional Consultant

Environment

Sun Solaris, Oracle HRMS Apps 11.5.10

Project Duration

NOV-2005 to Till date

WHO is currently operating its administrative activities related to HR, Payroll, recruitment, costing, projects, grants, assets management and purchasing activities using the Mainframes and client server systems. 

The engagement involves the full implementation of Oracle HRMS E-Business Suite to meet the organization requirements. This implementation covers the 146 countries which are classified into six major regions AFRO, AMRO, EMRO, EURO, SERO, WPRO and one Head quarter. 

Contribution: 

As part of this engagement as ‘Oracle HRMS Functional’ Consultant from Satyam is responsible for the following - 

Ø       Studying of Current Business Process (BP40)

Ø       Studying of Current Business volumes & metrics (RD40)

Ø       Responsible for requirements gathering and conduct discussion sessions with the business users.

Ø       Conduct HR, Payroll workshops and preparation of meeting of minutes, getting the sign off and solution acceptance from the business users.

Ø       Feasibility study on Oracle Advanced Benefits

Ø       Documentation for Payroll, OLD & HR requirements using AIM Methodology.

Ø       Involvement of High Level Business Solution Design (BP70)

Ø       Involvement of WHO Oracle HRMS Global Solution template design covering all the regions and countries requirements

Ø       Documentation for Payroll, HR & OLD requirements (RD50).

Ø       Identification and Preparation for Payroll ,HR ,SSHR and OLD Gaps (BR10)

Ø       Documentation for HR, Payroll future process model (BP80).

Ø       Conduct meetings and  documentation of reporting requirements (RD80)

Ø       Analysis and functional design of reporting requirements and documentation of MD60.

Ø       Responsible for the Payroll, Core HR, OLD Functional solution design.

Ø       Conducting Payroll workshops for gathering of payroll calculation and costing requirements.

Ø       Impact Analysis of the current business process of HR, Payroll, GL Grants & Projects modules.

Ø       Cross Functional issues discussion with AP,GL and Grants modules

Ø       Responsible for all deliverables to the customer (Functional BP70, RD50, BP80, MD50 and etc) and sing off on time.

Ø       Designing of HR, SSHR and Payroll custom components and documentation (MD50) of custom components( Element interface, Self Service, payslip, SOE, absence validations, Common payroll payment file generation , payroll ,HR related approvals routing).

Ø       Responsible for HR, Payroll OLD and SSHR Configurations and Preparation of production setup documentation (BR100)

Ø       Configuration of Business group and relevant Key Flexfields structures.

Ø       Responsible for Payroll configurations (Payroll definitions, Bank details ,Balances, Payment Types, Run types ,Organization and Personal Payment methods ,Assignment sets ,Element sets and Consolidation sets)

Ø       Payroll elements design and configuration of the element classifications, elements, element links and fast formula results

Ø       Payroll prepayments distribution process design

Ø       Development of Oracle Payroll calculation fast formulas, element skip rules, Element Input validation and user defined Table validation fast formulas.

Ø       Responsible for Fast formulas unit testing, Integration testing and components link testing.

Ø       Configuration of Fast formulas functions, Globals, User defined Tables, Balances

Ø       Configuration of Absence Types, Absence Accruals and absence elements.

Ø       Development of Absence duration calculation formula and accrual fast formulas

Ø       Configuration of Approvals for Absences using AME and personalization of Self Service HR Absence screens.

Ø       Development of User defined functions required for payroll calculation fast formulas and absence validations.

Ø       Configuration of Special information , Extra Information and other descriptive flex fields

Ø       Configuration of Organizations, locations, grades, positions, jobs, work structure components and Organization, position hierarchies.

Ø       Configuration of Table event updated and Dynamic Triggers and development of custom Proration triggers

Ø       Responsible for Self-service and form personalization

Ø       Configuration of Approvals routing using AME for HR, Learning, Payroll processes.

Ø       Configuration of Task flows, Security Profiles, lookups, Messages, value sets, form functions, menus, responsibilities, concurrent programs, request groups, printer styles and etc.

Ø       Responsible for configuration management and movement of configurations across development and test instances.

Ø       Preparation of data migration Templates

Ø       Interacting with the technical team on custom components development and discussion on functional requirements.

Ø       Providing guidance to the technical team on business processes.

Ø       Conducting CRP and UATs

Ø       Usage of Kintana and PVCs for code maintenance and migration across instances

Ø       Responsible for Test scenarios and Test scripts preparation using Mercury Test Director

Ø       Functional testing of custom components and interface and raise the bugs against the technical team

Ø       Hand over of custom components testing to business users.

Ø       Providing guidance to the Regional/offshore teams on business processes.

Ø       Ensure timely submission of deliverables and sign off.

Ø       Weekly project review with the team and update status to the on-site project manager.

Ø       Motivate the team and provide direction towards successful completion.

 

2. Project Name

Oracle HRMS Upgrade Project

Client

[snip] , London

Module Covered

Oracle HR, Oracle Payroll, AME, Learning Management (OLM)  Oracle Self Service and Data Migration

Role

Team Leader and Oracle HR, Learning Management (OLM) & Payroll Techno Functional

Environment

Sun Solaris, Oracle HRMS Apps 11.5.10

Project Duration

NOV-2004 to SEP-2005

[snip] is currently on 11.0.3 with HR, Payroll, assets, projects, infrastructure and purchasing modules. The engagement involves overall upgrade of the existing Oracle ERP system from 11.0.3 to 11.5.10 version and restructuring of the Business group work structure components like positions, locations, Position hierarchy, Organization hierarchy, security and organization costing changes for automation of payroll costing.  

Contribution: 

As part of this engagement as ‘Team Leader’ from Satyam is responsible for the following; 

Ø       Conduct meetings and documentation of business requirements

Ø       Responsible for gathering Payroll, learning management requirements and preparation of functional specification.

Ø       Configuration of Business group keyflexfields, restructuring of business group and study of the impact of business group restructuring.

Ø       Configuration and setup of Oracle Learning Management (OLM) module

Ø       Data analysis and cleansing for data migration activities.

Ø       Cross process review with respect to Purchasing, GL and iExpenses module impacted changes to the business group restructure.

Ø       Impact Analysis of the current business process of HR, Payroll Purchasing, GL and iExpenses modules.

Ø       Responsible for the HDM Solution Framework design and HDM data conversion design.

Ø       Responsible for the functional and technical solution design and documentation.

Ø       Responsible for the Migration of HR, Payroll data and development of data migration scripts.

Ø       Configuration of approval routing using AME for HR, Payroll and Learning Management processes.

Ø       Configuration of Absence Types, Absence Accruals and absence elements.

Ø       Development of Absence duration calculation formula and accrual fast formulas

Ø       Configuration of approvals for Absences using AME for Learning Management and SSHR

Ø       Personalization of Self Service HR Absence screens.

Ø       Providing guidance to the offshore team on business processes.

Ø       Usage of Kintana and PVCs for code maintenance and migration across instances

Ø       Responsible for Test scenarios and Test scripts preparation using Mercury Test Director

Ø       Functional testing of custom components and interfaces and raise the bugs against the technical team

Ø       Conducting CRP and UATs

Ø       Responsible for the setup migrations to production instance

Ø       Responsible for handling the offshore team.

Ø       Interaction with the offshore team for the development of migrations script and Unite Testing and Code Review.

Ø       Weekly project review with the team and update status to the on-site project manager.

Ø       Ensure timely submission of deliverables and sign off.  

3. Project Name

Oracle HRMS Upgrade and Implementation of SSHR  and iRecruitment

Client

[snip], Riyadh

Module Covered

Oracle HR, Oracle Payroll, iRecruitment , Oracle Self Service and AME

Role

Project Leader and Oracle HRMS Functional Consultant

Environment

Sun Solaris, Oracle HRMS Apps 11.5.9

Project Duration

MAY-2004 to OCT-2004

 

[snip] is currently on 11.5.3 with HR and Payroll modules. The engagement involves removing the core customizations, upgrade to 11.5.9 and implementation of SSHR. 

Contribution: 

As part of this engagement as ‘Project Leader’ from Satyam is responsible for the following; 

Ø       Responsible for gathering Payroll, iRecruitment requirements and preparation of functional specification.

Ø       Implementation of Self Service HR V4.0 and iRecruitment

Ø       Responsible for the identification of key bottle neck and removing the pain areas and redesign of solution during the upgrade.

Ø       Enhancing the payroll engine and performing the health check on current business solution and redesign of payroll formulas

Ø       Upgrade of applications from 11.5.7 to 11.5.9

Ø       Configuration and setup of  iRecruitment module

Ø       Configuration and setup of  SSHR module

Ø       Configuration of approvals routing using AME for iRecruitment and SSHR.

Ø       Identification of the GAPS and mapping to the product for SSHR and iRecruitment modules.

Ø       Preparation of the GAP Analysis document (BR10).

Ø       Responsible for the Functional Solution design and documentation for HR and Payroll requirements.

Ø       Development of custom validations using CUSTOM.pll

Ø       Configuration and development of Salary Advances and loans payments and deduction custom payroll processes.

Ø       Development of Oracle Payroll calculation fast formulas, element skip rules, Element Input validation and user defined Table validation fast formulas.

Ø       Responsible for Fast formulas unit testing and Configuration of Fast formulas functions, Globals, User defined Tables, Balances

Ø       Configuration of Absence Types, Absence Accruals and absence elements.

Ø       Development of Absence duration calculation formula and accrual fast formulas

Ø       Development of User defined functions required for payroll calculation fast formulas and absence validations.

Ø       Development of reports using Oracle Discoverer 3i and Report 6i

Ø       Responsible for all deliverables to the customer (Functional & Technical)

Ø       Conduct CRPs and UATs

Ø       Responsible for the setup migrations to production instance

Ø       Providing guidance to the technical team on business processes.

Ø       Weekly project review with customer and the team.

Ø       Ensure timely submission of deliverables and sign off.

Ø       Motivate the team and provide direction towards successful completion. 

4. Project Name

Customization of Oracle Self Service HR Applications

Client

[snip]  Egypt

Module Covered

Self Service Human Resource Applications 3.4x

Role

Oracle HRMS Techno Functional Consultant

Environment

PL/SQL, Workflow 2.6, Oracle HRMS Applications 11.5.7

Project Duration

FEB-2004 to APR-2004

 

Project Description: 

The scope of the project was to customize their existing SSHR Leave Management module developed using Oracle SSHR Framework 3.4. Existing Leave management process was enhanced so as to include more business validations, Change in routing of notifications by customizing developed workflows as well as adding specific business rules for approvals. The scope also included development of new SSHR modules like Remote Leave Update Application Process, Leave Cancellation process etc.  

Contribution:

As part of this engagement as ‘Systems Analyst’ from Satyam is primarily involved in the following- 

Ø       Designed the new SSHR functionality for the Leave Update Application, using this application employee can update their approved leaves in case of employee is rescheduling his/her leave plan.

Ø       Designed the new SSHR functionality for the Remote Leave Update, using this application remote person can update the leaves on behalf of their peers.

Ø       Designed the new SSHR functionality for the Remote Leave Cancellation, using this application remote person can cancel the leaves on behalf of their peers.

Ø       Developed new Self-service user interface screen for the above three functionalities using the SSHR Framework 3.4.

Ø       Developed the new workflow definitions to the Leave Update, Remote Leave Update and Remote Leave Cancellation applications to support the approval management of [snip]. All the notifications are routed to their managers/HR/Doctors appropriately depending on the type of the leave and the number of absence days for the approval of the Leave Update Application.

Ø       Developed Technical Design specifications, Unit Test plans, User Manuals and Production Migration documents based on the functional specifications supplied by client.

 

Project Name

Enhancement to Employment Insurance Summary Process

Localization

Korea

Role

Applications Engineer

Organization

Oracle Corporation ( India Development Center)

Environment

Unix,  PL/SQL, AOL, Fast Formulas

Module Covered

Oracle HRMS Applications 11i  (Payroll)

 Project Description: 

For Korea legislation, with the current existing ‘Employment Insurance Summary Process’ functionality, the user has to manually enter the exception information to EIT Employment Insurance Exceptions for every employee who is not eligible for the Employee Insurance premium deduction at the time of payroll run. But some of the exception reasons like working period of less than 1 month or monthly working hours of less than 80 (weekly working hours of less than 18) can only be determined at the moment of payroll calculation