We provide IT Staff Augmentation Services!

Oraclehcmtechnical Consultant Resume

Indianapolis, IN


  • Overall 7+ years of it experience as oracle HCM cloud consultant and ability to configure hr, oracle advanced benefits,compensationworkbench, talent and has 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 andpayrollmodules.
  • Good Expertise andimplementationexperience on Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and, Security.
  • Specialization in Order Management,ProcurementandManufacturingSystems and absence management andpayrollmodules.
  • Strong expertise inoracleHCM modules like Core HR, SSHR, Payroll,Oracleadvance benefits (OAB),Oracletime and labor (OTL), Compensation workbench (CWB), performance management system (PMS), me - recruitment andOraclelearning management (OLM) Modules.
  • Experienced in functional as well as technical understanding of Order to Cash (O2C) and Procure to Pay (P2P) processes.
  • Experience in Human Resources, Payroll Management, and Finance Administration using advanced HRIS systems such asOracleEBSHRMS and OTL, and ADP Time and Labor Management.
  • Proficient in all phases ofOracleApplications R12/11i implementation with major focus in HRMS ofOracle Applications includingOracleHR,OraclePayroll, Self Service Human Resource (SSHR),OracleTime and Labor (OTL).
  • Strong expertise in oracle HCM modules like Core HR, SSHR,Payroll, Oracle advance benefits (OAB), Oracle time and labor (OTL),Compensationworkbench (CWB), performance management system (PMS), me-recruitment and Oracle learning management (OLM) Modules.
  • Experience of end-to-endHRMSimplementationsand post-production support and SOX compliance.
  • Working noledge 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 andWorkflow) Components in teh 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 OracleWorkflowBusiness 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 ofWorkflowextensions for OM header & line, PO Requisition Approvals and AP Invoice Approvals.
  • Experience in OracleEBSHRMS andOracleCloud 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 andBIreports. Loading Files using FBDI and ADF DI.
  • Extensively involved in Enterprise level design sessions and helped in HR andPayrollone-time setups and Involved in third party integration to and from Cloud HCM.


OracleHCMTechnical Consultant

Confidential - Indianapolis, IN


  • Implemented Talent Management and Compensation Management in R12 including Employee Self Service, Manager Self Service, Security Administration, Workflows & approvals, Reports & Analytics, Email Alerts/Notifications, Application Customization and Data Migration, etc.
  • Worked with businesses to ensure requirements are finalized, perform prototype review and train them on Functionality.
  • Worked meticulously with PeopleSoft team related to issues with data integrity, data conversion, and data mapping from PeopleSoft to OracleHCMCloudto support Coexistence model.
  • Eexperience in Data loading into Fusion HCM using HCM Data Loader Tool which includes theWorkforcestructure data, Worker data, Work relationships data, and Salary info.
  • Responsible for Implementation Support / Configuration of Oracle FusionHCMGlobalPayroll, Absence, Performance Management and Workforce Modeling modules.
  • Customized teh Requisition import process form me-Procurementto Purchasing.
  • Identified business requirements for CoreHCM, Absence, compensation, Performance and map them to OracleHCMCloudApplication functionality.
  • Prepared several OTBI reports including customized reports for mostHCMmodules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
  • Performed troubleshooting and resolved issues found in parallel tests scripts, validatedpayrollsetup,payrollelements andpayrollfast formulas.
  • Supported inImplementing new interfaces (Purchase Order, ASN and Order Confirmation) and integration adapter for Oracle EBS integration with Procure-To-Pay (P2P) and Supply Chain Cloud solution provider SAP Ariba.
  • Determined allCloudGlobal HR and Absence Management requirements for an ERP implementation project where a Mass Global Transfer was to occur.
  • Assisted inPayrolllifecycle process using OracleHCMCloudlike hiring, element entries, W4, validating data and processingpayrolls.
  • Worked on Resources and Budget Monitoring, Health Check, Recommendations and Project Closure Forms, User Learning Plan (TR070)
  • Supported in teh 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 usingOTBIandBIPublisherfor Global HR, Payroll, and OTL.
  • Interacted with client and involved in Requirement gathering, preparing process requirement documents, Business requirement documents, and mapping withOracleCloudHCM, and GAP analysis.
  • Worked onSQL,PL/SQLprogramming,SQLLoader, and UTL file by creating Packages, Procedures, Functions, Triggers and other database objects.
  • Perform all teh setups for OM, me-Procurement, shipping, inventory, Purchasing modules.
  • Worked onHCMExtracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
  • Involved in creation of Custom Security forOracleHCMCloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
  • Developed Oracle FusionBIReports,OTBIand HCM Extracts, custom reports and Benefits interfaces using integrated oracle Business IntelligencePublisher(BIP) and HCM Extracts.
  • Worked on various product specific bugs in Oracle cloud ERP applications, during teh various rollouts by extensively testing teh core functionality and work in collaboration with Oracle support for issue resolution to reduce teh overall impact on theimplementationdeadlines.
  • Setup Self Service OTL, OTL Timekeeper groups, Alternate names, Rotation plans, earning policies, Holiday calendar, Work plan etc.
  • Worked on Oracle Forms, Business Objects, Documentum, custom PL/SQL procedures/functions) and is in teh process of being upgraded to Oracle
  • Work on teh setups and configuration for Purchasing, me-procurementsupplier base, Order Management, Advanced Pricing.
  • Identified business requirements for Core HCM, Absence,compensation, Performance and map them to Oracle HCM Cloud Application functionality.
  • Maintained integrations betweenOracle/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,BIpublisher& Data Modeling.
  • P2Pproduction support.


Confidential -Harrishburgh, PA


  • Participated in teh testing of data in teh workday integration and co-existence with OracleHCMCloudapplications.
  • Worked on RICE (Reports, Interfaces, Conversions and Extensions) objects to as per teh custom business process within Oracle HRMS implementation.
  • Integrated Oracle new Human Resources (HR) Technology, which was transitioned from Workday HR, into Oracle Finance as a single reporting functional structure.
  • Primary responsibility involves system study, Requirements Gathering, preparing functional specs, Conversion Design, Test script documents, User Manuals and Business Process documents.
  • Assisted in running daily integration jobs from Workday to Oracle HRMS and Investigating/resolving data reconciliation issues related to teh integrations.
  • Involved in implementing of Oracle HR/Payroll(ADP), OAB, SSHR, CWB, OTL, IRC, Performance Management, OLM modules.
  • Defined setups of Core HR, Self Service HR,Payroll, Oracle Time and Labor (OTL), Recruitment and Performance Management (PMS) modules to map teh business requirements into Product functionality.
  • Worked on teh setting up of punch, outs in oracle me-Procurement
  • Worked on teh catalog's setups in Oracle me-Procurement
  • Worked on teh configuration of stores me-Procurement
  • Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
  • Involved in teh Data Loading/Conversions usingHCMData loader (HDL) which includes teh Workforce structure data, Worker data, Work relationships data, Salary info etc.
  • Responsible for requirement analysis, design and architect of teh business processes in OracleCloudand transition from 2 existing legacy applications for Compensation.
  • Analyzed current Time and Labor rules, eliminated those not needed anymore, and provided guidance for change or consolidation for those currently not producing desired results.
  • Fast formulas in both payroll and absence management module.
  • Written fast formulas for teh absence management module.
  • Manage EnterpriseHCMInformation and Legal EntityHCMInformation.
  • Set up and Maintain Enterprise structure and Workforce structures.
  • Extended custom Global Posting Form for secondary ledgers.
  • Integration ofRESTbased web services for online ordering purposes
  • Integration of customized order processing rules tied into theRESTweb service return information
  • Worked on Oracle FusionBIReports and Analytics and Involved in testing existingBIReports and creation of ad-hocOTBIreports.
  • Integration ofRESTbased web services for online order purposes
  • Worked on secondary ledger COA mappingreport.
  • 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.

OracleFusion Consultant

Confidential - Bolingbrook, IL


  • Supported Core HR, Payroll modules.
  • Mainly involved in upgrading teh system by performing teh pre-upgrade and post upgrade steps.
  • Worked closely with teh project team members and Technical team responsible for developing custom components - Fast formulas, and interfaces.
  • Conducting noledge-sharing programs on every week among teh 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.
  • Assisted Oracle DBA team withLinuxadministration and Oracle RAC configuration on Dell servers to prepare for installation of Oracle E-Business Suite software.
  • Migrating teh data from legacy system to FusionHCM.
  • Prepared teh 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 teh Application Object Library to registerSQLLoader programs, shell
  • scripts,PL/SQLprocedures 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 onoraclepayroll and benefits business operations.
  • Ran payroll, Pre-Payments, Costing, Quick Pay, Retro Pay, Retro Pay by Element, Retro Costing, Import payroll transactions from HRMS.
  • Create custom reports, forms and batch programs for Oil & Gas supplier
  • Distribution and Quality, Shipping & Receiving.
  • Involved in Creation of bank and other initial setup elements in payroll module.

Oracle Consultant-

Confidential - Atlanta, GA


  • Involved in extending teh 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 teh custom applications, value sets etc. using System Administrator Module.
  • Involved in implementing various business process extensions of HRMS as per teh business requirements.
  • Supported Personalized and extended various web pages on SSHR usingOracleApplications framework. Added Custom notes as per HR Polices.
  • Worked on teh conversion of key HR, Payroll and Benefits systems from a Mainframe to anOracleplatform. Composed detailed specifications to serve teh conversion process.
  • Oracle Alerts using PL/SQL andUNIXscriptingto send automated email responses to users as a result of errors within teh reconciliation of order information from teh web environment to orders that has been interfaced to Oracle Applications.
  • Teh Cash managementimplementationcovered teh Bank setups, teh 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 toOracle.
  • Coordinated noledge transfer to technical team and guided them on prevailing technical
  • issues and generalOracleApplications issues.
  • Supported teh workflow and approval tasks for Salary Change, Promotions, Transfers, Work relationships, Change manager, Change Location, Working hours change, Termination and ICD approvals based on teh business requirement to route teh approvals.
  • Approval setup for teh leaves based on teh leave types.

Hire Now