Summary

• Over 10 years of IT experience in Implementation of Oracle HRMS Applications.
• Expertise on the Oracle HRMS modules of Human Resources HR , Oracle Payroll, Oracle Self Service Human Resources SSHR and strong knowledge of Oracle Advanced Benefits OAB , Oracle Time and Labor OTL .
• Excel in preparation of Functional Design MD.050 , Conversion Design CV.040 , CRP and Go-Live Test Scripts TE.040 documentation using AIM standards for HR, SSHR, Oracle Payroll modules. Worked on 2 Full life cycle Implementations.
• Worked on HCM Suite Configurations Core HR, Payroll and OAB and Prepared BR100s. Developed User Procedures for HCM Suite. Excellent Knowledge on AIM methodology. Excellent client facing skills.
• Experience in design of RICE Reports, Interfaces, Customizations and Extensions objects as per the custom business process within O
• racle HRMS implementation.
• Expertise in gap analysis, application design, application configuration, application customization and personalization, CRP and UAT run and production support.
• Expertise in Oracle Payroll configuration in Multi-Org environments and also good knowledge of TCA. Trained end users on Navigation and Prepared documents on How to Run Payroll processes. Worked on Retro Pay and Child Support EFT Automation.
• Expertise in designing of payroll inbound and outbound interfaces and which and related to non-Oracle Payroll system like Xerox, TIMES, Front End and PeopleSoft
• Expertise in writing and modification of Fast formulas used in Oracle Payroll, Oracle Advanced Benefits for US, Canada legislation. Worked on Post production Support, Enhancements and Performance Tuning. Managed 2 Functional resources.
• Proficient in defining Users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent programs, Lookup types and defining Value sets. Participated in FIT GAP analysis. Worked as Functional Subject Matter Expert.
• Excellent Knowledge on Oracle Application Data Structures FND Tables and HCM Suite Tables. And Good Knowledge on KFFs and DFFs. And hands-on experience on Application Seed Packages.
• Expertise in Form personalization and SPEL personalization.
• Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
• Good understanding of data flow in the different modules of Oracle Applications
• Excellent problem-solving skills and ability to multi-task

PROFESSIONAL EXPERIENCE

CONFIDENTIAL

HCM Lead Payroll Consultant.

Responsibilities:

• Part of a team implementing Oracle R12 HRMS modules HR and Payroll for US CA Active Union and Non-Union and Retiree Group .
• Assisted in Business process mapping and prototyping, gap analysis, solution design, HRMS setup, testing and user training. Worked Full life cycle Implementation.
• Set up locations, elements, element links, costing, payrolls, Payment method, security profiles, application utility lookups, user defined tables Structures. Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation Sets, and Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility.
• Involved in defining balance, balance feeds, Assignment sets, Consolidation set, Element links. Extensively worked on Union Non Union Payrolls.
• Created and updated multiples payroll earnings and deductions Fast formula.
• Design conversions for core HR and payroll assignment, element entry, balance etc
• Prepared functional design documents based on requirement gathered from business users. Trained Payroll team on how to run various Payroll Processes.
• Prepared various configurations documents and testing of various custom extensions.
• Design multiple Inbound Outbound interfaces to support for US CA Active, Retiree and Union payroll processing. Some of the important interface are as:
• Times and Labor with external system inbound and outbound interface
• Health Welfare deduction inbound and outbound interface
• Steel worker Trust payment outbound interface
• United way Deductions
• Payroll to oracle payables outbound interface.
• Worked with offshore team throughout the implementation in providing clarification and functional help with delivering the requirements.
• Prepared various User procedures for Core HR Payroll.
• Loaded work structure data using Data Loader.

Environment: Oracle Applications R12.1.3 HR, Payroll R12 , Oracle 11g, SOA, Data Loader, Clear case, Share Point HP-QC.

CONFIDENTIAL

Sr. HCM Payroll Consultant.

Responsibilities:

• Worked on Oracle E-Business Suite 11i implementation which includes Core HR, Oracle Payroll. Co-ordinate Implementation team and Client.
• Assist Functional team in Business Requirement Specification BR100 for HR and Payroll. Worked on Support Issues and SRs. Migrated configurations between instances.
• Involved in business requirements finalization process, assisted functional team lead in design, gap assessment, and process redesign sessions.
• Involved in Defining elements, element links, input values, balance, balance feeds, application utility lookups.
• Worked extensively on updating numerous Fast Formula for payroll elements. Prepared MD65s.
• Preparing and updating functional documents as per business requirement.
• Prepared configurations documents BR100 and testing of various custom extensions and reports.
• Provided support Payroll team in various payroll processing activities on a daily basis.

Environment: Oracle applications 11i HR, Payroll , Oracle 9i, TOAD XML Publisher.

CONFIDENTIAL

HCM and P2P Functional Lead SME

Responsibilities:

• Prepared Work estimations, Sequence of Tasks and helped project director on resource planning. Designed high level solutions.
• Coordinated with offshore team and transition work assignments.
• Triaged Product Test defects to on-shore and off-shore team members.
• Help critical defects in during Product Test and UAT cycle and help on-shore team resolving. Designed Data Conversions for 50K Employees.
• Extensively involved in HCM Configurations and Prepared BR100s.
• Loaded Data using Data loader for List of Values, Lookup Codes, and Orgnizations etc.
• Provided technical functional support to both on-shore and off-shore team.
• Conducted training for new joiners. Maintain Issue log/Run book and work on post production enhancements. Excellent knowledge on HCM process flow. Automated Garnishment Payment process. Prepared Project plan, Test Plans for PATCH installations and responsible for User sig-offs.
• Worked on major customizations and prepared MD50s and BR100s.
• Worked on various functional configurations for different Business Groups.
• Customized Iprocurement Pages to allow user to added one than more approver.
• Design and modification PO approval, Requisition Approval workflow.
• Customization for the Purchase Order reports to send output via email/Fax from oracle program. Full life Cycle Implementation.
• Design of complex APEX form to create and stored GL code combination for Procurement integration.
• Design custom APEX form to upload files from desktop which also prevents file if not provided in correct format.
• Design custom APEX form report to store list of third party vendor for local supplier in Belfast.

Environment: Oracle Applications 11i, HCM Suit, PTP, AP, CM, RICEW, TOAD, SQL PL/SQL.

CONFIDENTIAL

P2P Functional Consultant

Responsibilities:

• Analysis of the functional specifications provided by the business and updating functional documents and handing it for development team
• Updated multiple design of custom forms like CIBER Contract User Access Form, SCC Auto Registration Form etc .
• Update design documents for custom reports based on new changes from business.
• Assisted in testing of various custom RICE objects.

Environment: Oracle applications 11i, IB, CRM, SA, RICEW, TOAD, SQL, PL/SQL