SUMMARY:

• Around 7+ years of experience as Oracle Fusion HCM R12 (Human Capital Management) and Oracle EBS HRMS R12 (E - Business Services) consultant.
• Experienced in all phases of implementation of Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll), Workforce Development (Talent Management, Performance Management, Goal Management) and Compensation Management (Compensation and Benefits) in version R8 to R11.
• Hands on experience with Oracle Fusion Financials and Fusion Accounts Receivable and Fusion Human Capital Management Foundation and support experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM)
• Experience in working with financial and non-financial domains.
• Hands on experience on customizing the security, by creating data roles, security profiles and effectively using job roles and duty roles.
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration, etc.
• Worked on Oracle Cloud HCM and EBS HRMS modules like core HR, Absence Management, Payroll, Benefits.
• Experienced with Agile (Scrum) software development & waterfall methodology.
• Experienced in moving data between HCM to in-house or third-party vendors using tools such as HCM Extracts.
• Experienced in managing systems requirements using best practices and techniques. Work closely with end users, participate in JAD sessions - to understand and document user expectations.
• Experienced in loading data into HCM using FBL/HDL and spreadsheet integration.
• Experienced using technical tools and utilities such as SQL, XML, fast-formulas, UDTs
• Good knowledge of report creation using OTBI or BI Publisher.
• Extensive experience in working with business management, end users, SMEs throughout PMLC (Project Management Life Cycle) on requirements, testing and other project related activities.
• 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.
• Experienced in creating eligibility profiles, rate definitions, absence plans, reasons and categories.
• Global instance experience in R-12 with Oracle e-Business Suite full life-cycle implementation and upgrades
• Experienced in Data Loading/Conversions using HCM Data loader (HDL) and spreadsheet loaders.
• Experienced in developing HCM Extracts/BI Reports for Global HR, Payroll Interface.
• Trained the super users and users on the application and conducting Pilot testing, integrated testing, design validations, setups of the Distributed ERP applications and coordination of UAT.
• Developed functional test plans, coordinates user acceptance testing and guides business users in testing.
• Worked on cross functional projects with groups such as HR, Payroll, Benefits, Stock, and Recruiting teams.
• Troubleshoot, diagnose and fix production software issues, configuring and monitoring solutions, and perform software maintenance and configuration.

TECHNICAL SKILLS:

Oracle Applications: Oracle Fusion HCM R9, R10, R11 and R12 (HR, Oracle Time labor, Payroll, Absence Management), Oracle EBS 11i, 12c (Core HR, Self Service Human Resource, Payroll, OAB, OTL)

Oracle Application 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

Databases: Oracle, DB2 and MS SQL Server.

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

Developer Tools: OBIEE, BI Publisher, OTBI, Toad, Oracle Workflow Builder, SQL Navigator, Forms, Reports, AME

PROFESSIONAL EXPERIENCE:

Oracle HCM Consultant

Confidential, North Bergen, NJ

Responsibilities:

• Developed custom reports using Business Objects in Oracle-Taleo for leadership, human resources, and talent acquisition teams.
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Customized management self-service for viewing and updating multiple employee status data. RMS modules HR, Advance Benefits, OTL and Payroll.
• Worked on Oracle HCM modules Core HR, SSHR, Performance Management, iRecruitment and Compensation Workbench.
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows etc.
• Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
• Customized management self-service for viewing and updating multiple employee status data. RMS modules HR, Advance Benefits, OTL and Payroll.
• Work cross-functionally with different teams to ensure effective execution of Oracle HCM Software such as Oracle HCM Fusion & Taleo Applications.
• Customized OTBI reports, Payroll Extracts, HCM Extracts to feed the information to third party systems and downstream systems.
• Involved in payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Pay slip, for Oracle Payroll.
• Worked as Integration and Transitions lead for Oracle Taleo/Fusion implementations.
• Tested and maintained Oracle payroll module software for enhancements and complete new conversions.
• Work cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications.
• Maintained integrations between Oracle/Taleo Recruiting and internal/external partners including background check, assessment, tax credit, CRM, and virtual interview.
• Performed benefits and work structures data population within Fusion HCM using spreadsheet based loaders.
• Perform Configurations as per the design for HR, Payroll, Self Service, Learning Management, Approvals Management and OAB modules.
• Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface.
• Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development & Testing.
• Performed gap analysis between business requirements and Fusion Compensation and Benefits functionality.
• Working as Oracle Fusion subject matter expert providing best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.
• Gather requirements and deliver information using Oracle Business Intelligence (OBIEE) and Oracle Noetic reporting software.
• Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.
• Developed high-level Requirement Documents such as Business Requirements Document (BRD) and Functional Requirement Document (FRD).
• Manage Payroll operations for growth while providing outstanding customer service.
• Performed relational database design and Modeling and conducted multiple SQL querying.
• Improved performance of tableau dashboards and maintained elevated level of data integrity.
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling.
• Test & document the changes that are being made to Oracle HR system.

Oracle HCM Techno-Functional Analyst

Confidential, Mineola, TX

Responsibilities:

• Involved in upgrading of Oracle HCM from 11i to R12 and then implementing Oracle Projects module and Integrating said Projects module with Oracle Financials and Oracle Time and Labor modules.
• Served as Lead Functional Consultant of R12 Oracle Compensation Workbench (CWB) implementation for US and Canada business groups
• Provided full time support to Oracle HR and Payroll users
• Prepared functional designs for Core HR, Payroll and SSHR and Prepared test cases for Payroll, Core HR and SSHR.
• Responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules
• Worked on Oracle HRMS (11.5.10.2, R12) and OPM modules, maintenance and support. Responsible for HR, Self Service, Time and Labor, ADP Payroll applications
• Reduced costs for Oracle EBS implementations/stabilization projects by eliminating the need for third-party implementers/consultants
• Assisted in running daily integration jobs from Workday to Oracle HRMS and Investigating/resolving data reconciliation issues related to the integrations.
• Lead the data conversion effort to facilitate superior quality of data from Oracle EBS to Oracle Fusion HCM
• Worked on the Integration of Oracle Fusion HCM with other modules like Taleo Recruitment and Onboarding
• Developed HCM Extracts and OBI Reports for Global HR, PeopleSoft Payroll Interface and Fusion Benefits
• Responsible for Maintenance &Support PA/OM, ESS/MSS, Payroll & Time Management
• Integrated Oracle new Human Resources (HR) Technology, which was transitioned from Workday HR, into Oracle Finance as a single reporting functional structure.
• Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), iRecruitment and Performance Management (PMS) modules to map the business requirements into Product functionality.
• Implement Workday HCM Core HR, Talent Module, Onboarding & Recruiting modules testing. Review, test, and implement system upgrades or patches
• Successfully configured Oracle Fusion Project Accounting and SLA rules
• Developed Outbound PL/SQL Packages, Procedures, and Functions for validating the Purchasing, Receipts and Invoice Payments and inserting in staging table to transfer data to third Party
• Developed HCM Data Extracts in Oracle Fusion Cloud OTBI and Oracle EBS R12.
• Providing technical and functional support for various Oracle E-Business Suite implementations with different Oracle Partners
• Have worked in several Oracle HRMS assignments as a team lead/coordinator that included various developments, Enhancement to existing Implementation, R12 Upgrades and Support project
• Worked on calculation process like quick pay and standard pay and other payroll processes like roll back, generate payment processes etc
• Acted as a lesion for OAB Custom Inbound and Outbound Interfaces and Configurations between Oracle EBS Applications and their Integration with legacy applications.
• Analyzed complex cross functional business processes and defines integrated requirements
• Configure Workflow routing rules for all Employee Self Service actions and Manager Self Service actions.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Worked through Fit/Gap Analysis, Configuration and Testing of Oracle Fusion Application Solution
• Providing post production support for the defects raised in ESS, MSS and WFA fixing them under tight timelines

Oracle HCM Analyst

Confidential, Glendale, CA

Responsibilities:

• Worked as Oracle functional consultant as part of Oracle Fusion implementation for Core HR Performance and Compensation Modules.
• Worked across all areas of the organization core EBS applications such as ATC, HTR, PAC, PJM, Taleo and PTP to identify, prioritize, and mitigate risks to the responsiveness and scalability.
• 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.
• Generating analyses using OTBI for Global HR, Goal and Performance Management subject areas.
• Configure custom Workflow routing rules for all Manager self-services and Employee Self-services with help of Area Responsibilities.
• Scheduling/monitoring ESS jobs and managing Employees, User accounts, User Roles in HCM and OIM.
• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• 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.
• Experience in Design, Development, Administration and Implementation of Oracle HCM Cloud (R10, R11) and Oracle Applications both 11i & R12 HRMS modules.
• Worked meticulously with technical resources on data integrity, data conversion, and data mapping from PeopleSoft to Oracle Cloud.
• 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.
• Worked on Fusion HCM core HR setup and Performance management setup.
• Participated in the testing of data in the PeopleSoft integration and co-existence with Oracle HCM Cloud applications.
• Coordination with Payroll Costing Team and provide all task details for Payroll Calculation, Taxation, Pay Terms and Conditions,
• Customized OTBI reports, Payroll Extracts, HCM Extracts to feed the information to third party systems and downstream systems.
• Worked on RICE (Reports, Interfaces, Conversions and Extensions) objects to as per the 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.
• Post production support of Core HR, Self-service applications HR (ESS and MSS), payroll in R12

Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Created Requirement documents like BRD, FRD, etc. depicting business flows & rules, processing-sequences, use-cases & inter-dependencies using UML.
• Participated in Design Review sessions with Project Managers, Developers and Product team
• Successfully implemented Core HR, Advanced Benefits (OAB), Talent Management, Oracle Time & Labor and Oracle Payroll modules for the client
• Facilitated Joint Application Development (JAD) sessions for communicating and managing expectations with SME's and to understand thoroughly the business process and the interface requirements, which need to be incorporated in the application.
• Involved in Functional Testing and preparing Test Scenarios, Test Cases and Test Data for Regression and Functional test cycles
• Conducted data mapping and gathered requirements for the custom extensions required to the HRMS applications. Provided requirements for the 'In bound' and 'Out bound' interfaces between HRMS and third-party applications
• Responsible for working with various union groups of the client, understanding their regulations and providing business requirement documentation to the technical team for implementation of corresponding 'person types', 'pay groups', payroll categories', 'salary basis' in Oracle HRMS
• Liaison between several teams to get the business requirements for non-oracle legacy systems and advise on either mapping them to Oracle HRMS or establishing custom extensions to the implementation
• Assist the testing team to define acceptance criterion & data elements.
• Documented Requirement Traceability Matrix for tracing the Test Cases and requirements related to them.
• Worked on Oracle database and wrote SQL queries to retrieve data from the database.
• Involved in various other change order tasks requiring XML, Hyperion reports creation & ERP in-house tool enhancement.
• Create and troubleshoot defect tickets in Jira before assigning them to developers.
• Prepared Use Cases, Use Case Scenarios and elaborated those using UML diagrams like Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Process and Data Process Model using MS Visio and Simulations using iRise.
• Maintained document repository management system using JIRA to house business/functional requirements, analyses, surveys and process flows. Used MS Visio to model the process flows using UML diagrams.
• Maintained and Prepared QA documents on testing various integration and functional modules.