SUMMARY:

• Overall 7+ years of it experience as oracle hcm cloud consultant and ability to configure hr, oracle advanced benefits, compensation workbench, talent and have done integration with oracle hcm cloud, file/worksheets based loaders for hcm components expertise in configurations, personalization, and fusion role based security, hcm data loaders (hdl), spreadsheet loader, otbi reports, bi publisher reports, hcm extracts, workflows and approval configuration, fast formulas for absence management and payroll modules.
• Strong expertise in oracle HCM modules like Core HR, SSHR, Payroll, Oracle advance benefits (OAB), Oracle time and labor (OTL), Compensation workbench (CWB), performance management system (PMS), I - recruitment and Oracle learning management (OLM) Modules.
• Good Expertise and implementation experience on Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and, Security.
• Strong expertise in oracle HCM modules like Core HR, SSHR, Payroll, Oracle advance benefits (OAB),Oracle time and labor (OTL), Compensation workbench (CWB), performance management system (PMS), I-recruitment and Oracle learning management (OLM) Modules.
• Experience in Human Resources, Payroll Management, and Finance Administration using advanced HRIS systems such as Oracle EBS HRMS and OTL, and ADP Time and Labor Management.
• Proficient in all phases of Oracle Applications R12/11i implementation with major focus in HRMS of Oracle Applications including Oracle HR, Oracle Payroll, Self Service Human Resource (SSHR), Oracle Time and Labor (OTL).
• Experience of end-to-end HRMS implementations and post-production support and SOX compliance.
• Working knowledge of Procure-to-Pay (P2P), Order-to-Cash (OTC), Drop Shipment, Internal Sales Order (ISO) cycles. Excellent Technical skills in developing CEMLI (Customization, Extension, Modification, Localization, and Integration) and RICEW (Reports, Interfaces (Inbound and Outbound), Conversions, Extensions and Workflow) Components in the domain of Oracle Applications E-Business Suite.
• Hands on experience in interface design, customizations, integrating disparate systems, and data conversion. Design and developed Real Time Interfaces for OM, CDH and SDH using Oracle Workflow Business Events which interacts with other system through Fusion Middleware.
• Experienced in span business process like understanding and interpreting fast Formula PBL, HCM Data Loader (HDL) Full Mode, HCM Extracts, Data Modeling, OTBI, OBIEE/BIP custom and predefined Report and Subject Areas.
• Analysis, Design and Implementation of Workflow extensions for OM header & line, PO Requisition Approvals and AP Invoice Approvals.
• Experience in Oracle EBS HRMS and Oracle Cloud HCM Talent management.
• Worked on SQL, PL/SQL programming, SQL Loader, and UTL file by creating Packages, Procedures, Functions, Triggers and other database objects.
• Developed Oracle Fusion Cloud OTBI and BI reports. Loading Files using FBDI and ADF DI.
• Extensively involved in Enterprise level design sessions and helped in HR and Payroll one-time setups and Involved in third party integration to and from Cloud HCM.

PROFESSIONAL EXPERIENCE:

Oracle HCM Technical Consultant

Confidential - Lexington, MA

Responsibilities:

• Currently working as a Sr. Oracle HCM Consultant in various HCM process areas like Workforce Management, Talent Development, and Compensation Administration.
• Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB, OTL modules and wrote conversion programs using API's.
• Executed the multi-phase global implementation (suitability analysis to post go-live stabilization) and maintenance of Oracle Cloud ERP, EPM, and SAP applications.
• Worked on Oracle EBS for Payroll, performed setup of all Earnings, Deductions, Payrolls, costing and element links.
• Supported in the upgradation of projects from 11i to R12 and Performed several end-to-end implementations, upgrades as well as conducting conference room pilot (CRP), providing post production support, end user training and documentation.
• Worked on complex reports using OTBI and BI Publisher for Global HR, Payroll, and OTL.
• Interacted with client and involved in Requirement gathering, preparing process requirement documents, Business requirement documents, and mapping with Oracle Cloud HCM , and GAP analysis.
• Worked on SQL, PL/ SQL programming, SQL Loader, and UTL file by creating Packages, Procedures, Functions, Triggers and other database objects.
• Compared existing environment with the new fusion environment and provided demo session on the fields for better understanding of the end user.
• Worked on HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
• Interpreted various geographies, action reasons, content types, context, flex fields, jobs and department setups.
• Involved in creation of Custom Security for Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Developed Oracle Fusion BI Reports, OTBI and HCM Extracts, custom reports and Benefits interfaces using integrated oracle Business Intelligence Publisher (BIP) and HCM Extracts.
• Worked on various product specific bugs in Oracle cloud ERP applications, during the various rollouts by extensively testing the core functionality and work in collaboration with Oracle support for issue resolution to reduce the overall impact on the implementation deadlines.
• Worked on complete end to end test cycles in Oracle Fusion financial Applications Implementation Project mainly focusing on General Ledger, Account Payables, and Account Receivables.
• Preparation of installation files. Migrating and installing code to CRP and UAT instances using GIT.
• Setup Self Service OTL, OTL Timekeeper groups, Alternate names, Rotation plans, earning policies, Holiday calendar, Work plan etc.
• Addressed systems issues or opportunities with Oracle /Taleo and other integrated partners or vendors; managed follow-up to ensure timely resolution.
• Maintained integrations between Oracle/Taleo Recruiting and internal/external partners including background check, assessment, tax credit, CRM, and virtual interview.
• Knowledge on both Inbound & Outbound interfaces using HCM Extract, BI publisher & Data Modeling.

Oracle Fusion Consultant

Confidential, Atlanta, GA

Responsibilities:

• Initialized the users for setting up and implementing the oracle fusion HCM.
• Extensively worked on payroll module.
• Element configuration and Developing Fast Formulas.
• Defining Security Profiles and Custom Roles in ERP Cloud as per the SOX Compliance and business needs.
• Creation of security profiles and monitoring security processes.
• Initial setup for payroll, creating payroll definitions, creating bank and other initial setups.
• Custom element creation for additional benefits based on client requirement.
• Payroll archiving.
• BIP and OTBI.
• Archiving the data using HCM extracts for w2.
• Fast formulas in both payroll and absence management module.
• Written fast formulas for the absence management module.
• Loaded Core HR data using FBL, HDL and PBL.
• Fixing issues related to Setups/ Configuration, Personalization, Interfaces.
• Manage Enterprise HCM Information and Legal Entity HCM Information.
• Set up and Maintain Enterprise structure and Workforce structures.
• Worked in excel report with multiple tabs for CM Reconciliation Report.
• Worked in GL Trial Balance Report for secondary ledgers.
• Extended custom Global Posting Form for secondary ledgers.
• Integration of REST based web services for online ordering purposes
• Integration of customized order processing rules tied into the REST web service return information
• Worked on Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.
• Integration of REST based web services for online order purposes
• Worked on secondary ledger COA mapping report.
• Preparation of installation files. Migrating and installing code to CRP and UAT instances using kintana (minority report). Was involved on production support of various HRMS modules including HR and Payroll.
• Involved in Design, Development, Testing, Customer Support for Oracle E-Business Suite APIs ( PL/ SQL,SQL, Package Codes), Forms, Reports & Batch Processes.

Oracle Fusion Consultant

Confidential - San Francisco, CA

Responsibilities:

• Supported Core HR, Payroll modules.
• Mainly involved in upgrading the system by performing the pre-upgrade and post upgrade steps.
• Worked closely with the project team members and Technical team responsible for developing custom components - Fast formulas, and interfaces.
• Conducting knowledge-sharing programs on every week among the team members.
• Creating users, assigning roles.
• Set up and Maintained Enterprise structure and Workforce structures.
• Assigning data roles and managing security profiles.
• Role customizations for security purpose.
• Worked for Oracle applications client's databases. Technologies involved - Oracle Apps version 11.5.9, 11.5.10 & R12 on LINUX, multi node RAC system with Database 9i, 10g &11g.
• Used HDL to load data of new workers, locations into the system.
• Assisted Oracle DBA team with Linux administration and Oracle RAC configuration on Dell servers to prepare for installation of Oracle E-Business Suite software.
• Migrating the data from legacy system to Fusion HCM.
• Prepared the documentation for Business Requirements, Functional specifications and Test case documents.
• Primary responsibility involves system study, Requirements Gathering, preparing functional specs, Conversion Design, Test script documents, User Manuals and Business Process documents.
• Responsible for creating custom security profiles for HRMS based on Job, Organization and Payroll.
• Utilized the Application Object Library to register SQL Loader programs, shell scripts, PL/ SQL procedures and RDF Reports.
• Worked extensively on payroll module.
• Worked as member of Support Team for modules AP, GL, PO, AR and CM.
• Training super users on oracle payroll and benefits business operations.
• Ran payroll, Pre-Payments, Costing, Quick Pay, Retro Pay, Retro Pay by Element, Retro Costing, Import payroll transactions from HRMS.
• Check printing and also using NACHA.
• Involved in Creation of bank and other initial setup elements in payroll module.

Oracle Consultant

Confidential - Northbrook, IL

Responsibilities:

• Involved in extending the functionality of Core HRMS modules. Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical specification.
• Worked on menus, added new concurrent requests, registered the custom applications, value sets etc. using System Administrator Module.
• Involved in implementing various business process extensions of HRMS as per the business requirements.
• Supported Personalized and extended various web pages on SSHR using Oracle Applications framework. Added Custom notes as per HR Polices.
• Worked on the conversion of key HR, Payroll and Benefits systems from a Mainframe to an Oracle platform. Composed detailed specifications to serve the conversion process.
• Oracle Alerts using PL/SQL and UNIX scripting to send automated email responses to users as a result of errors within the reconciliation of order information from the web environment to orders that have been interfaced to Oracle Applications.
• The Cash management implementation covered the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.
• Involved in Configuring and maintenance of BR100 for setting environments in production, pre-production, UAT, Patch and development instances.
• Worked on PLSQL Procedures for importing year end W2 information from companies acquired.
• Customized and extended fast formulas.
• Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Worked on Meta link to raise and track Service Requests to Oracle .
• Coordinated knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.
• Supported the workflow and approval tasks for Salary Change, Promotions, Transfers, Work relationships, Change manager, Change Location, Working hours change, Termination and ICD approvals based on the business requirement to route the approvals.
• Approval setup for the leaves based on the leave types.