SUMMARY

• 3+ years of Oracle HCM Cloud experience in Oracle Cloud Payroll, with a background of successful full cycle implementations.
• Exposure to functional areas like Core HR, Absence Management, Time and Labor and Benefits.
• Involved in full life cycle implementations including: planning, design, & build phases.
• Experience in gathering the business requirements and interpret them to appropriate configurations of the Oracle Cloud Payroll module.
• Coordinate efforts between other Module resources to implement the best solution for the client.
• Experience in the configuration and management of the Oracle Cloud Payroll applications and can independently work with Payroll team to resolve issues.
• Extensively worked in Oracle HCM Cloud Fast Formulas - Payroll, Absence & Benefits.
• Support the definition and validation of various payroll related conversion activities.
• Maintain system related processes and documentation and suggest changes to procedures.
• Worked with technical streams and provide guidance on integrations, conversions and reports.
• Experience in Oracle Cloud/EBS implementation for Public sectors.
• Experience in Inbound Integration procedures using HDL - HCM Data Loader, & PBL.
• Knowledge in Cloud security model.
• Exposure to - OTBI & HCM Extract.
• Strong experience on RICE (reports, interfaces, conversions and Extensions) Components.
• Strong programming skills in SQL, PL/SQL, EBS HRMS API’s, EBS Fast Formulas and Shell Scripting.

TECHNICAL SKILLS

Applications: Oracle EBS and Cloud HCM

Modules: Cloud - Core HR, Payroll EBS - HR, Payroll, SSHR, Absences, Benefits

Versions: Cloud - Release 13 EBS - 11i, R12

Programming Skills: SQL, PL/SQL, Schell Scripting

Tools: & Utilities: HDL, PBL, Web ADI, AME

Databases: Oracle 10g/11g/12c

Software Tools: Toad, Sql Developer, Workflow Builder

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential

Oracle HCM Consultant

Responsibilities:

• Participated in full implementation of payroll beginning with Discovery sessions, sprint sessions, SIT, parallel testing, UAT and go-live support.
• Designed and configured the Cloud Payroll applications:
• Payroll, Element & Balance definitions
• Rate Definitions - for composite rate calculations
• UDT’s, Value Sets, DFF’s and EIT’s as per business requirements.
• Created and modified Fast Formulas.
• Configurations/process to integrate with ADP.
• W2 setups
• Validation of Post payroll process.
• Conduct SIT Sessions
• Parallel testing
• UAT
• Costing Validations
• Create and update test scripts needed for functional testing.
• Maintain system related processes and documentation.
• Worked on Absence, OTL & Benefits related fast formulas.
• Assisted in key system processes (i.e. payroll cycle management, accruals, garnishments, enrolments, etc.)
• Publish weekly status reports to the project management team.
• Developed customer specific reports to validate run results as part of payroll reconciliation.
• Created HCM extracts for third party system interfaces.
• Uploading Payroll data using HDL and PBL.
• Create training materials and quick reference guides to support user adoption.
• Conduct training classes to prepare end users.
• Post-production support.

Confidential

Oracle HCM Consultant

Responsibilities:

• Supported Oracle cloud Payroll
• Involved in requirements gathering and developed the documentation with company standards, and did GAP analysis
• Prepared data mapping/Field mapping documents between EBS to Cloud.
• Worked on End to End Conversion process from EBS to Cloud.
• Set up and Maintained Enterprise structure and Workforce structures.
• Build Custom Security to HCM Cloud which includes Create/Modify Data roles and its Security Profiles.
• Created elements and payment methods, worked on proration and retro pay.
• Performed loading/conversions of Payroll data using HCM Data Loader (HDL).
• Prepared of test scripts and performed unit testing and integration testing.
• Effectively communicated with oracle support (SRs) to troubleshoot and resolve issues.
• Analyzed and resolved various functional as well as technical production problems of the production environment.
• Gathered technical requirements and detailed interface and conversion specifications, including data mapping.
• Developed and maintained all relevant technical and functional specifications documentation such as MD50, MD70 and BR100.
• Developed complex payroll inbound and outbound interfaces using PL/SQL packages.
• Provided technical and functional support during regular payroll runs, yearend activities and patch upgrades.
• Performed validations on monthly basis for Oracle released Vertex patches.
• Created custom menus, responsibilities and security profiles to be used in functional areas.
• Designed new process for monitoring contingent workers in Self-Service.
• Personalized SSHR pages for rendering necessary fields.
• Created and/or modified Oracle Fast Formulas to calculate employee payroll and PTO accruals.
• Developed migration/conversion scripts to migrate business data into Oracle Application using Oracle standard APIs.
• Customized workflow process using Workflow Builder.
• Developed and modified complex control files using Shell scripts.
• Supported the open enrollment process in Oracle Benefits.
• Worked closely with users from HR and Payroll departments to ensure business requirements were met.

Confidential

Oracle EBS HCM Techno-Functional Consultant

Responsibilities:

• Provided technical and functional support for various modules of the Oracle Applications like Core-HR, Payroll and Self-Service.
• Developed payroll reports (Element and Balance results) by using the Oracle Discoverer report tool.
• Extended standard functionalities of Oracle Application.
• Created custom menus, responsibilities and security profiles to be used in the functional areas.
• Set up of absence types, elements and links to be used in the PTO plans for their vacation, holiday and sick plans.
• Create and/or modify Oracle Fast Formulas to calculate the employee PTO accruals.
• Build custom components like reports and interfaces using PL/SQL.
• Personalized self-service pages as per business needs.
• Analyzed and resolved various functional as well as technical production problems of the production environment.

Confidential

Oracle EBS HCM Techno-Functional Consultant

Responsibilities:

• Analyzed, designed, and implemented various support and enhancement activities from offshore.
• Handled requirement analysis, designed and executed the quarterly service releases involving enhancements and new developments.
• Configured Work structures, key flex fields, value sets, security profiles, elements (various types recurring and non-recurring) and Salary Basis.
• Supported and executed complete pre and post payroll process activities.
• Developed conversion script to migrate the business data into Oracle Application.
• Build custom components like XML reports, outbound and inbound interfaces using PL/SQL.
• Used Web ADI’s to load data into Oracle EBS.
• Forms personalization for people and assignment screen as per user requirements
• Customized SSHR pages at the responsibility level for rendering necessary fields and flex fields required by the customer.
• Modify the Oracle Fast Formula according to the business requirements. (Oracle Payroll formula, Element Validation formula, Element Skip formula, PTO Accruals Formula)
• Extensively used AOL and System Administrator modules for Creation of various Concurrent programs, Request sets, Value-sets and request groups for reports and concurrent requests.
• Developed PL/SQL programs, procedures, functions, and packages.

Confidential

Oracle EBS HCM Technical Consultant

Responsibilities:

• Analyzed, designed, and implemented new enhancements.
• Converted Employee, Address, Assignment, Bank details, etc. into Oracle system, using Oracle standard APIs.
• Designed control files using Shell scripts to load data into custom tables.
• Developed inbound interfaces to update element entries based on the pension enrollment,
• Built PL/SQL programs, procedures, functions and packages.
• Prepared technical design documents (MD70) and unit test plans.

Confidential

Oracle EBS HCM Technical Consultant

Responsibilities:

• Captured and analyzed technical requirements.
• Mapped, design processes and interacted with users.
• Developed Periodic Oracle Alerts as per business requirements.
• Developed XML reports using Pl/SQL packages to generate web letters.
• Configured work structures like Location, Organization, Job, Position, Grades and application utility lookups.
• Developed PL/SQL programs, procedures, functions and packages.
• Customized user hooks to include custom logic.
• Developed Forms personalization for People and Assignment screen as per user requirements
• Prepared technical documents (MD70) and unit test plans.