SUMMARY:

• Around 9 years of Oracle HRMS expertise in enterprise - wide Oracle Applications design, development, and support for 11i / R12 implementations and upgrades.
• Extensive experienced as an Oracle HCM Business Analyst and strong experience in Oracle HCM e-Business Suite, Taleo Product Consulting and Project Management experience.
• Working diversified Oracle HCM Analyst expertise in Oracle Applications R12/11i, with extensive exposure in for Design, Configuration, Implementations, Production Support and Upgrades in Oracle HRMS/HCM.
• Experience in the entire Software Development Life Cycle (SDLC) including analysis and requirement gathering, design, development, testing, deployment and implementation of solutions in EBS applications.
• Provided out of box solutions to match and exceed user expectations in implementing the business rules.
• Experience providing technical and functional support for daily/month end tasks of an Oracle EBS application.
• Proficient in all phases of Oracle Applications R12/11i implementation with major focus in Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources (HR), Oracle Payroll, Self Service Human Resource (SSHR), Oracle Time and Labor (OTL).
• 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 in HCM Cloud offerings: Global HR, Talent management, HCM Data Loader (HDL), HCM Extracts, BI Publisher and OTBI reports.
• Extensively worked on PeopleTools such as Application Designer, PeopleCode, Application Engine, Component Interface, File Layout, Data Mover, PS Security, SQR, PS Query and XML Publisher.
• Responsible for integration between Talent Acquisition (Taleo), HR (Oracle), Timekeeping (Kronos), Payroll (Oracle) and Performance (Cornerstone) systems and Learning Management System (Meridian) and oversee delivery of HR-IT projects.
• Oracle Learning Management (OLM), Oracle Advance Benefits (OAB), Oracle Performance Management (OPM).
• Created Dynamic columns and used Dynamic calculations for some of these columns in the CWB worksheet.
• Well experienced in design of Reports, Interfaces, Conversions and Extensions (RICE), Implementation and Support of various Oracle Apps modules. Involved in implementing versions/upgrades of Oracle Applications 11i, and recently involved in implementing Oracle Applications R12 for Oracle Business.
• Prepared the Designs for Gaps, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents and Sys Admin setups documents.
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support.
• Extensive experience in integrating Oracle EBS with legacy warehouse systems and Transportation management.
• Designed Custom Reports, Forms, Workflow Customizations, Forms Personalization and all other RICE objects to meet customer requirements in Fresh Implementation and Production Support projects of Oracle Applications.
• Proficiency in understanding client's needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.
• Effective communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.
• Worked with Offshore Technical team on Development, Testing and Migration of Objects.
• Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
• Experience in managing HR data requests and Assemble, analyze and format data into usable reports.
• Experienced in configuring Workflow routing rules for all Manager Self-services and Employee Self-services.
• Experience in developing functional and technical design and documentation for Oracle Applications using data conversions, interfaces, custom reporting.
• Experience in functional and technical consulting services by acting as subject matter expert and leading clients through the entire cloud application services implementation lifecycle for Oracle Fusion projects.
• Experienced in on-call 24/7 Application support in Production Environment and working with business users to implement or enhance the solutions into ERP system.
• Provided technical and functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.
• Experience in monitoring the system and track the issues, fix and escalate them as per the client policies.

TECHNICAL SKILLS:

Oracle Applications: HRMS 11i, R12 - Core HR, Self Service, Payroll, OTL, Advanced Benefits, Time and Labor, I- recruitment, OLM, Talent Management

Oracle App Tools: Oracle Application Framework (OAF) 11i, R12, XML Publisher, Web ADI, Fast Formulas, Oracle Approvals Management (AME), Application Object Library (AOL)

Operating Systems: Windows, Linux, UNIX and Mac and Linux

Databases: Oracle, DB2 and MS SQL Server

Languages: SQL, PL/SQL JAVA, HTML, XML

Application Tools: PeopleSoft, EBS, Cloud Fusion, Oracle Business Accelerator, Toad, SQL dev, Office Suite (Excel, Word, Project, PowerPoint, Front Page, Publisher, Visio), OIM, File Based Loader, Spreadsheet Data Loader, Informatica with Dac and ODI

PROFESSIONAL EXPERIENCE:

Sr. Oracle Techno- Functional Analyst

Confidential,Glendale, CA

Responsibilities:

• 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 the integrations.
• Involved in customization of Oracle HR/ Payroll (ADP), OAB, SSHR, CWB, OTL, IRC, Performance Management, OLM modules.
• Prepared functional and technical design specification for the Historical Conversion Event to transfer the benefit elections from legacy system to OAB using Oracle API's.
• Go to resource for business areas using Oracle HR, Finance, Payroll and Benefits applications. Met with internal clients to identify needs, budgets and timelines, and managed projects to completion.
• Worked on cross reference mapping and data conversion from PeopleSoft HCM to Oracle HCM Cloud.
• Developed complex programs to extract data from PeopleSoft in Oracle HCM Data Loader (HDL) required format.
• Setup Oracle Advance Benefits by establishing Elements for various Benefit Plans, Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the Customizations in OAB and modified the Configurations at various levels to follow Oracle rules and hierarchy of Eligibility and Electability rules.
• Integrated Oracle new Human Resources (HR) Technology, which was transitioned from Workday HR, into Oracle Finance as a single reporting functional structure.
• Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB and OTL modules and wrote conversion programs using API's.
• Benefits Self Service Personalization with communication message text changes and added text on SSHR pages to provide information about the plan which they are about elect and enroll.
• Involved in extracting data from PeopleSoft HCM, data mapping, transformation and data migration to Oracle Cloud HCM.
• Key stakeholder of vendor/product evaluation team to evaluate moving from Oracle HR & Payroll to either ADP or Workday solutions.
• Worked across all areas of the organization core EBS applications, ATC, HTR, PAC, PJM, Taleo and PTP to identify, prioritize, and mitigate risks to the responsiveness and scalability.
• Responsible for entering in all assigned time cards along with the necessary information into payroll software based on client protocols.
• Create and assigning respective responsibilities to Users and provide SOX compliance documentation.
• Responsible for business requirements gathering, process analysis and design, gap analysis, functional system design and specification, development of system tests, business process procedures and training documentation.
• Responsible for developing standardized Global HCM business processes across spectrum.
• Helped client for successful testing of developed solution including System Integration Testing (SIT), User Acceptance Testing (UAT) and working with business users to validate the converted data in HCM Cloud.
• Worked with offshore resources on day to day basis. Managed the deliverables and validated development work to present to client for sign/off.
• Responsible for working with Oracle Support, Oracle Product Development, third party vendors to ensure an On-Time Go-Live.
• Created security profiles to avoid departments to access another departments Information.
• Assisted client in extracting data from PeopleSoft HCM by providing table mapping between PeopleSoft HCM and Oracle HCM Cloud.
• Helped team to setup HCM Core HR configuration, DFFs, Workflows, Security, User-Defined Tables.
• Provided production support during and after HR/Benefits/Payroll and Financial go live.

Oracle EBS Functional Consultant

Confidential,Chesterfield, MO

• Performed payroll workshops demonstrating Oracle payroll functionality and processes. Gathered requirements related to payroll configuration in Oracle.
• Provided various reports, and advised HR Comp and HRIS teams on best practices of Oracle EBS system, tool, reports, or software usages.
• Managed and successfully delivered full life cycle implementation of Oracle Fusion HCM applications along with Taleo Recruitment and Familiar with using some commonly used Oracle HR API's for development.
• Develop various package/procedure to push data from legacy system to EBS for the month end closing and data reconciliation across the organizations.
• Performed payroll workshops demonstrating Oracle payroll functionality and processes. Gathered requirements related to payroll configuration in Oracle.
• Provided various reports, and advised HR Comp and HRIS teams on best practices of Oracle EBS system, tool, reports, or software Taleo on boarding.
• Was involved in OAB setup and wrote script to load Open Enrollment benefits legacy data using OAB sequence of API.
• Ability to learn and understand the basic payroll process to better support the operations.
• Researched, developed and implemented Oracle Streams functionality for near real-time data replication between Oracle EBS and Oracle Coherence cache.
• Assisted in resolving all Oracle HRMS related trouble tickets and VMware custom on-boarding/ex-boarding HR2R and XR2R application related problem cases.
• Strong Exposure to Data Conversion and migration include HRMS, Payroll, Oracle Advanced Benefits (OAB), Oracle Time & Labor (OTL), modules to Oracle Applications USING ORACLE API.
• Wrote SQL scripts to generate various reports in response to users' ad-hoc requests, or to aid in problem analysis and resolutions.
• Functional Oracle payroll knowledge related to Oracle payroll processing and configuration of Oracle payroll.
• Worked with HR Comp and HRIS users on finalizing their BRD (Business Requirement Documents) and in turn created and submitted IT FRD (Functional Requirement Document) for approvals.
• Was involved to open oracle Tar and fixed issue related HR/Payroll/OAB and Financial modules.
• Guided or consulted with developers on technical developments in fulfillment to FRD's technical specs. Assisted in development, development testing, QA testing, QA sign-off documentation, deployment stage monitoring, through go-live.
• Involved in post-production support for HR/OTA/OLM/Benefits/Payroll and financial module.
• Created test cases and initiated and managed change migration steps to ensure a strict adherence of the SDLC methodology.
• Organized cross-functional team meetings and UAT testing meeting to cover changes impacting HR or Finance to ensure a successful data migration or system implementation.
• Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
• Very strong in the configuration of the US Payroll elements, salary basis and payroll Configuration.
• Worked on setting goal plans and assigning them to workers and integrating with the performance documents.
• Involved in data conversion process for migrating the legacy systems from SAP to Oracle EBS using XML.
• Ensured that applications meet business requirements and systems goals, fulfill end-user requirements, and identify and resolve systems issues.

Oracle HCM Functional Analyst

Confidential,Columbus, IN

• Transition of benefits administration from Oracle Advanced Benefits to third party administration in time for Open Enrollment.
• Responsible for shared modules Oracle Advanced Pricing, Oracle HR, Oracle iPayment, Oracle Order Management, Oracle EBTax and Oracle Accounts Receivables.
• Worked as Oracle functional consultant as part of Oracle HRMS implementation for Oracle Core HR, CWB and OAB.
• Worked with development to design data extracts for data conversion and daily FTP data feed to TPA, modifying HR ADP views to prevent element entries from transferring to payroll system.
• As primary HCM resource identified business requirements and performed tasks required for configuring Oracle HR.
• Set up payroll elements, element links and grades required for salary entry; created Extra Information types and elements to accommodate various allowances and data points.
• Coordinated with developers in design and development of reports to meet corporate standards.
• Worked with Project lead, development and DBA's as the HR resource for the migration of the Oracle database from Oracle Austin Data Center to ITC.
• Responsible for data integrity and security by accurately and timely maintenance of the HR Oracle systems.
• Coordinated user testing; worked with DBA's and Developers to facilitate transition of interfaces for Payroll and benefits to pristine environment.
• Working with ADP resources to upgrade payroll software from PCPW to Payforce and provided support for Payforce, ETime and ADP Connection.
• Collaborating with business users to identify areas for process improvement to reduce manual efforts. These activities included developing data loaders, training users on use of Mass Update functionality, working with Developers to design audit reports and programs to automate upload of Merit Increases and Performance Ratings.
• Working in conjunction with the technical development team to develop and support interfaces to/from third party software, reports and programs.
• Well versed with the setup of Work Structures - Location, Organization, Job and Grade in HR.
• Identified and addressed client needs: building solid relationships with clients, developing an awareness of Firm services.
• Provided Oracle Application support in the following modules: HRMS, Self Service, PTO, Performance management, Compensation Workbench, Oracle Time and labor, Ceridian PAYROLL Created an implementation project to maintain the setup of specific business processes and activities for Fusion HCM, Global HR.
• Set up of elements to implement new Cellular Stipend Allowance and coordinating testing through import to Payroll system.

Functional HRMS Analyst

Confidential,Houston, TX

• Participated in full cycles as functional EBS consultant in a long-term data transformation project for this global agribusiness company.
• Worked as Oracle functional consultant as part of Oracle HRMS implementation for Oracle Core HR, CWB and OAB
• Propose Data Conversion strategies for inbound and outbound data interfaces. Create Integration documents for HCM Data load exchange strategy. Study the legacy system and built the Inbound Integration strategy.
• Create HCM extracts to generate different assignment files for outbound interface to the third-party systems.
• Worked on Functional Setup Manager in Test Sandbox Instance and test the different assigned tasks of Core HR & Payroll.
• Identify the data inconsistencies in Oracle HR including Date Tracking Issues, Payroll data issues, Benefit Life Event Issues and Conversion Issues.
• Coordination with the Web Services team to create web services to automate the export of data to downstream systems (for both HR and non-HR) and import data to update fields into Cloud HCM and Setting the details of HCM Data Loader Scope parameters.
• Involved in conversion requirements, converting people data, assignment data and salary data.
• Gather requirements for Oracle Advanced benefits implementation. Meet with users to gather requirements regarding various benefit plans including medical, dental, HAS and CORBA plans.
• Setup eligibility profiles, enrollment requirements, life events, benefit groups at program, plan and option levels as required.
• Gather requirements from the business users document the requirements and initiate the development process after requirement sign-off.
• Advise HRIS about the Oracle best practices, AIM methodology, minimize data redundancy, automate concurrent process and improve existing interfaces with external vendors.
• Modify existing third-party vendor interfaces and develop new vendor interfaces as required.
• Hands-on configuration working with functional set up manager across Oracle HCM Cloud modules.
• Developed work plan, follow and deliver in line with Oracle HCM Cloud Implementation Roadmap and Methodology.
• Lead groups in business process re-engineering, workshops, best practices and customization.
• Drive workshops and build business requirements and procedures, obtain client sign off to ensure client alignment of proposed solution.
• Provide inputs to the assigned Project Manager to ensure a comprehensive project plan developed and buy-in from key clients.
• Identify the changes that need to be incorporated in each release and coordinate with change management and release management teams during deployment.
• Test & document the changes that are being made to Oracle HR system.