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), Technical Design documents (MD070) 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. Worked with Big 5 companies.
• Experience in design of RICE (Reports, Interfaces, Customizations and Extensions) objects as per the custom business process within Oracle 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.
• 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 multiple resources.
• Excellent knowledge of trading community Architecture (TCA), AOL objects, FND Tables and HCM Suite Tables. And Good Knowledge on KFFs and DFFs. And hands-on experience on Application Seed Packages. And excellent knowledge of all aspects of the Software development life cycle (SDLC).
• 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.
• 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.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

HCM Lead 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 Functional 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 (BR 100) 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

HCM Lead 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 functional 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 R12 (HR, Payroll), Oracle 9i, XML Publisher, Data Loader

Confidential

HCM and P2P Consultant 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 HCM 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 Organizations etc.
• Provided 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 Suite, P2P, AP, CM, RICEW, Data Loader

Confidential

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, Data Loader.