PROFESSIONAL SUMMARY:

• 7+ years of Experience in HR and HR Information Systems and implementation of Oracle EBS HRMS and Cloud HCM Fusion applications.
• Expertise in Fusion HCM offerings - Workforce Deployment (Global HR, Payroll, Absence Management).
• Experience on Taleo functionality like Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import-export schedule process errors resolutions.
• Expert in defining and documenting Oracle and non-Oracle standard solutions.
• Extensively worked on Implementation planning, Fit/Gap Analysis, and providing alternatives to the clients on product.
• Experience in Software Development Life Cycle (SDLC)
• Worked on complete lifecycle implementations involving Data allotment, Requirements gathering, Configuration, Development, Troubleshooting, Training and production support environment.
• Experience in multiple full end to end life-cycle implementation of all major cloud modules in both fresh and conversion projects from various legacy systems.
• Excel in interacting with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions and able to lead discussions during business requirement meetings.
• Excellent ability to learn and deliver the assignments in given time frame and ability to work on multiple projects with excellent communications skills.
• Broad-based knowledge of Human Capital Management with a strong area of expertise in Benefits.
• Experience in creating RTF templates for bi publisher reports and financial statements.
• Experience in configuring and working with functional set up manager and enterprise level configurations across Fusion Modules.
• Experienced in configuring Workflow routing rules for all Manager Self-services (MSS), Employee Self-services (ESS), approvals, security configurations.
• In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, functions, procedures
• Experience in Customizing Cloud HCM Security components like Data Role, Job Role, Duty Role, Security Profiles, Abstract roles and well versed with aggregate privileges and assigning duty roles.
• 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.
• Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and testing phases.
• Experience in Creating custom reports and analytics using OBIEE/OTBI in various Cloud HCM subject areas and Good knowledge in HCM Extract.
• Excellent experience in Data loading into Oracle HCM Cloud using SQL Loader, FBL, HCM Data Loader and PBL.
• Assisted end users with documenting new business procedures and test scripts for CRP & UAT.

TECHNICAL SKILLS:

Databases: Oracle, MS SQL Server, DB2.

Languages: SQL, PL/SQL, C, C++

Applications: Cloud HCM (HDL, PBL, BIP Reporting, OTBI), OBIEE, ODI, BPM, OIM and APM.

ERP: Oracle HCM Cloud Solution (v 9, 10, 11 and 12), Oracle Applications 11i. /12x (Core HR, SSHR, Payroll, OAB) up to EBS R12.2.4.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Oracle Techno-Functional Consultant

Responsibilities:

• Ensured that applications meet business requirements and systems goals, fulfil end-user requirements, and identify and resolve systems issues.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.
• Experience with configuration, testing, cutover and production support.
• Manage Enterprise HCM Information and Legal Entity HCM Information.
• Set up and Maintain Enterprise structure and Workforce structures.
• Created various Eligibility Criteria for Benefits Eligibility Profiles.
• Involved in the complete testing of the Employee Transfers and 2-Tier and 3-Tier employment model.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Created BI Publisher reports using custom templates.
• Performance Tuning BI reports by analysing SQL query, Data Model, NQquery.log, creating Aggregate tables and utilizing Materialized views.
• Worked with the business in understanding the HCM cloud features and analyse the feature that best fits the business requirements.
• Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
• Develop HCM Extracts/OBI Reports for Global HR.
• Involved in end to end test cycles and prepared the test scripts and scenarios required to test various business cases.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Involved in Regression testing of multiple offerings.
• Tested all the tasks and business process flows related Payroll, Global HR and Talent Management.
• Handled regression testing and file path migrations for inbound and outbound process.

Confidential, Winston-Salem, NC

Oracle Cloud HCM Consultant

Responsibilities:

• Initialized the users for setting up and implementing the oracle fusion HCM.
• 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.
• Extensive experience in Worker Creation and Loading the data file in to Fusion Application through HCM Data loader.
• Creation of new BI Publisher invoice reports for the additional BU.
• Created custom check for the new BU using BI Publisher.
• Effectively communicated with oracle support to resolve issues to complete the project smoothly and before deadline.
• Performance tuning BI reports by running execution plans capturing IO/disk usage, parallel hints etc.
• Took part in business workshops and supporting clients in defining relevant processes.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Worked with the team to design, develop, test & implement system. Creation of database objects like tables, procedures using Oracle tools like PL/SQL, TOAD. Written Stored Procedures using PL/SQL
• Ensured that the application meets the business requirements and system goals fulfill end user requirements and identify and resolve system issues.
• Reported to higher Management on progress and status for all business-related work products and deliverable.
• Was involved on production support of various HRMS modules including HR and Payroll.
• Involved in User Interface functional testing.

Confidential, Oxnard CA

Oracle HRMS Functional Consultant

Responsibilities:

• Working as a HCM Techno-Functional Consultant for Global HR, Payroll and Compensation .
• Involved in Implementation and support of Global HR, Payroll and Compensation.
• Involved in different Phases of Implementation and Participated in CRP’s with Business teams.
• Suggested best practices and feasible solutions to the business users to resolve functionality gaps .
• Working as liaison between business users and IT for identifying and resolving the issues.
• Created setup data and transactional data according to client requirement.
• Defined multiple reference data sets covering multiple business units for set enabled objects.
• Defined all the payroll setups and tested them.
• Created setups and Plans for individual Compensation.
• Created Different flexfileds and added value sets, Lookups according to Business requirement.
• Used OTBI for different analysis as per business user requirements.
• Loaded Core HR data, Payroll data using HDL, PBL and SSL from source system to target system.
• Created Different Configuration dcos, Test cases and User manuals according to user requirement.
• Supporting the payroll issues and troubleshooting them.

Confidential

Oracle Apps Consultant

Responsibilities:

• Worked as Oracle EBS consultant for implementing and supporting Oracle R12 Core HR, Payroll, Compensation Work Bench, Absence Management, ESS, and MSS.
• Participated in workshops with HR, Payroll, Compensation, Finance and HRIT teams to analyze the existing system.
• Involved in Setup Oracle HR, CWB and AM for Demo.
• Involved in developing test scripts to test the Oracle Self Service Modules.
• Analyzed business requirements for HR, CWB and OTL modules.
• Setup Key Flex Fields Job, Position, Grade, People Group, Cost Allocation flex fields.
• Setup Plan Types, Plans, and Options for Compensation Work bench module.
• Gathered requirements for participation eligibility for Bonus and Stock plans.
• Extracted and loaded data using Web ADI and created test case for UAT.
• Developed fast formulas for determining the eligibility for different types of stock plans.
• Design standard rates, derived factors and elements as required for compensation work bench.
• Responsible for implementing the modules through different instances.
• Developed test scripts and test data for testing in CRP1, Test, GOLD and UAT instances.
• Fit Gap analysis based on user requirements.
• Document and implement personalization and customization requirements.
• Coordinate with technical team for developing concurrent programs for custom reports, payroll and benefit extracts.
• Production support after Go Live.
• Prepare end user manuals for HR, Benefits and Payroll teams.