SUMMARY

• Having 13 Years’ experience in the area of HRMS/HCM Cloud domain as technical, functional and operational experience in oracle applications on versions 11i & 12i, specializing in HRMS, Oracle Advanced Benefits, Compensation Work Bench, Payroll, Self - service HR, Oracle Learning Management, Performance Management, Oracle Succession Planning, Absence Management and OTL modules.
• Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
• Experience in system analysis, requirement study, and project plan definition, specification generation, test plan preparation, unit testing, system integration testing, CRP and user training.
• Extensive experience in setup/enhancements in running OPEN Enrollments, Performance management, Compensation workbench process and troubleshooting production issues.
• Well conversant with application implementation methodology (AIM). Worked on end to end implementations involving business process analysis, solution design, gap analysis, security design, user training and documentation.
• Excellent ability to support multiple simultaneous assignments in a fortune organizations as well as leading the team.
• Experience in release/version upgrade (11i to 12 and 12.1.2 to 12.1.3 and R12.1.3 to R12.2.4), latest mandatory patches, documentation, testing, and user acceptance and production migration.
• Extensively worked on API’s, Alerts, and RICE, Workflow, XML Publisher Reports, SQL Loader utility scripts, JAVA and PL/SQL in writing stored procedures, functions, reports, fast formulas, Web-ADI and packages to validate the inbound and outbound data between the oracle applications and third party systems and UNIX shell scripting.
• Extensive experience in EXCEL & VBA scripting, used for oracle data validation.
• Experience of end-to-end HRMS implementations and post-production support and SOX compliance.
• Experience on Fusion HCM Cloud and ability to configure Global HR, Oracle Advanced Benefits, Compensation Workbench, Talent, assigning duties to users, adding new approvals on transactions and Integrating with Oracle HCM Cloud, File/Worksheets based loaders for HCM components

TECHNICAL SKILLS

ERP: Applications (12.1.3, 12.1.2, 11.5.10.2,11.5.10), Fusion R10, R11, Workday R25,R26

E-Business suite Modules: HR, OAB, OTL,PAYROLL, OLM, OPM, CWB, OSP, SSHR, SYSADMIN

RDBMS: Oracle v 11g, 10g, 9i, 8i

Operating Systems: LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP

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

Tools: & Utilities: Forms 6i/9i, Reports 6i/2.5, EiS, SQL*Loader, Jdeveloper, Oracle Workflow Builder, TOAD and SQL*Plus, XML Publisher, MS Visio and MS Excel.

Hardware: HP 9000, Intel Pentium based PC’s

Documentation: AIM Documentation (BR100, BR030, MD50, MD70,DO070, DO060, MD120,CV60,CV40,TE40)

PROFESSIONAL EXPERIENCE

Confidential

Fusion HCM Consultant

Responsibilities:

• Worked on Core HR, Absence Management, Compensation, Talent Management, Payroll and Benefits modules.
• Understanding the Business requirements to be a part of the FUD (Functional Upgrade Doc), and FDD (Functional Design Doc).
• Use Oracle Fusion Functional Setup Manager (FSM) to implement workforce deployment.
• Set up and Maintain Enterprise and workforce structures.
• Configure and manage Workforce Compensation Budget Models.
• Configure, Validate, manage and Administer Workforce Compensation plans.
• Configure Fusion Compensation plans, budget pool, worksheet, Total Compensation Statement and budget sheet customization.
• Configure and manage benefit programs, plans, plan types and options.
• Maintain Benefit rates and coverage.
• Configure changes required for 2017 Fusion Benefit Open enrollment.
• Configure Organization trees, action reasons, content types, enhanced fusion flex fields, jobs and departments etc.
• Configure Fusion Talent management sections like Goal plans, Questionnaire, Performance scale, Appraisal template and performance document.
• Configured the Absence Management module to enable the Vacation and Sick plans.
• Written Accrual fast formulas to support the vacation and sick absence plans.
• Data Conversions using HCM Data Loader, Payroll batch Loader and Spread Sheet Loader.
• Migrate elements and formulas between environments using FBL.
• Created batches related to payroll element/element entries/Payment methods etc. using Payroll Batch Loader.
• Configured security profiles as per the client requirements.
• Configured Approvals using BPM.
• Wrote Fusion fast formulas for Benefit enrollment validation like post edit election.
• Involved in User Interface functional testing.
• Involved in preparation of Test Cases, Test Scripts for the Global HR, Benefits, Talent and Global Compensation.
• Wrote MD.50 documents for OTBI Fusion reports.
• Wrote Admin Guides for Global Compensation and Benefits.
• Developed fusion reports for performance, goals, benefits and global compensation.
• Tested Core HR, Interfaces and Reports for Rel.11 Upgrade.
• Assisted end users with documenting new business procedures and test scripts for CRP & UAT

Environment: Oracle Fusion HCM Release 10 and 11

Confidential - Austin, TX

Sr Techno Functional Consultant - Oracle HRMS

Responsibilities:

• Setup self-service global contractor placement functionality with AME Approval
• Workflow customization for absence management and iRecruitment functions
• Integration between contractors’ data with red-carpet third party systems.
• Setup annual open enrollment for 2016 with new enhancements as per the new client requirements.
• Identifying the new interface changes for vendors.
• Enhancements to OTL requirements.
• Writing benefits and payroll outbound interfaces.

Environment: Windows, Oracle 11g, Oracle Applications 12.2.2 XML Publisher, SOAP, EiS, JDeveloper, XML Gateway, TOAD, E-Business.

Confidential - Cleveland, OH

Sr Techno Functional Consultant - Oracle HRMS

Responsibilities:

• Primary responsibility involves system study, requirements gathering, preparing functional specs, conversion design, test scripts, user manuals and business process documents.
• Setup functions, menus, responsibilities, and request groups and performed other system admin responsibilities.
• Setup open enrollments, performance management and compensation workbench for yearly process.
• Writing fast formulas for coverage benefit start date and transferring employees from old plan to new plans including the qualified dependents.
• Setup plan changes as ending the existing no offered plan and migrating the enrolled employees with dependents to newly offered plan.
• Setup annual open enrollment for benefits election, conducting mock open enrollments, user testing and production migration.
• Developed the quality control reports to cleanup detected and unprocessed life events that could affect the open enrollment life events from processing.
• Validating the new rates, plan drops and dependent drops due to eligibility and fixing the benefits issues during open enrollments.
• Personalized OAB Self-Service pages with custom tips which give explanation of plans offered to employees.
• Designing OPEN enrollment reports like pre-open enrollment, post open enrollment and open enrollment status like no of enrollment happened on daily and weekly.
• Designed benefits plans to reflect the newly acquired company and converted the benefit enrollment data.
• Worked on setting up of Work Structures - Location, Organization, Job and Grade in HR.
• Setup manager and employee Self Service for core HR.
• Setup global compensation workbench for merit, lump sum and bonus for US, CA, MX, UK, China and Germany business groups.
• Documented the setup specification using AIM - BR0100 as setup document for deliverable.
• Setup talent profile/succession planning webpages where managers and employee can access their Self Service functions like adding/,modifying qualification, benefits, and employee assignments, salary, performance and objectives.
• Defined Organizations, Locations, Jobs, Payrolls, and Salary Basis etc. to setup Global HR. Implemented HR for US, MX, CA, Germany, UK, Swiss and China countries.
• Defined global deployment setups to transfer employees from one country to another country for part time or full time.
• Setup approval rules using AME for MSS, CWB and OPM self-service transactions.
• Enabled matrix manager approvals systems for performance management.
• Setup up rating scales, objective templates, questionnaire and appraisal templates for performance management system.
• Setup objective process, approvals and performance tracking.
• Setup alerts that run weekly before the objectives/appraisals deadlines and sent to respective managers.
• Personalized self-service appraisal web pages as per client requirements.
• Setup performance management for yearly appraisals.
• Developed custom BI reports for managers to print objectives, performance tracking and appraisals reports thru self-service.
• Developed custom concurrent programs to include employees into appraisals who are missed/error due to manager termination or during seeded appraisal concurrent process.
• Designed and developed outbound interfaces to third party vendors like Medical, Dental, Vision and ADP (Globally).
• Designed catalog to accommodate the needs of organizations and individuals.
• Worked on catalogue security and managing enrollments in oracle learning management.
• Integrated learning management with third party vendor Skill port.
• Personalized learning management pages as per the client requirements.
• Designed documents for conversion and benefit enrolment for Nichols Company acquisition, attended business user meetings, handled team at offshore to meet the deadlines and conducted CRP testing with end users.
• Designed setup and migration documents for workforce who enrolled benefit plans to new offered plans.
• Provided a solution to allow users to enter cost allocation key flex fields thru self-service to synchronize with finance modules for GL, and taken care of effected regular ongoing interface and reports, documented the change for future enhancements.
• Workflow administration and trouble shooting of approvals.
• Defined various security profiles based on business requirements.
• Writing business requirements for offshore teams and validating the work deliverables.
• Customized webpages using oracle JDeveloper.
• Wrote fast formulae for performance, compensation and benefits
• TAR Creation and follow-ups using Metalink.

Environment: Windows, Oracle 11g, Oracle Applications 12.1.2, 12.1.3, XML Publisher, SOAP, EiS, JDeveloper, XML Gateway, TOAD, E-Business.

Confidential - Philadelphia, PA

Sr Techno Functional Consultant - Oracle HRMS

Responsibilities:

• Part of a team implementing Oracle R12 HRMS modules HR, SSHR, Advance Benefits and OTL. Assisted in Business process mapping and prototyping, gap analysis, solution design, HRMS setup, testing and user training.
• Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, worker’s compensation codes/rates, Global Values, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations, Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation Sets, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility
• Set-up employee self-service to for updating employee personal data on-line. Customized management self-service for viewing and updating multiple employee status data. Did set-up for employee self-service for reviewing job descriptions and applying on-line. Performed set-up on on-line position management for overseeing the entire hiring process from posting to interviewing to hiring
• Documented the setup specification using AIM - BR0100 as setup document for deliverable.
• 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.
• Documented MD050/MD070/CV040/CV070 for application extension / modification / interfaces & conversion.
• Performed OTL setup by defining approval rules, hour types, and time entry rules, approval styles, Self Service OTL, OTL timekeeper groups, alternate names, rotation plans, earning policies, holiday calendar, work plan, earnings policy, assignment time information, automatic timecard generation, transfer to BEE and setting up the preferences.
• Wrote a pl/sql package to receive timecard data from time machines to oracle and fast formulae for timecard validation.
• 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.
• Wrote fast formulas to calculate coverage amounts, enable/disable the options programmatically and validation of options selection like he/she must select same emp/emp+1/family option across all plans (Medical/dental/vision/prescription) provided.
• Employee and manager self-service personalization and user creation.
• Developed fast formulas to calculate coverage amounts, enable/disable the options programmatically and validation of options selection like he/she must select same emp/emp+1/family option across all plans (Medical/dental/vision/prescription) provided.
• Preparing system for open enrollments and conducting mock open enrollments in advance to avoid issues during open enrollments.
• Interacting with third party benefits providers (IBC, Delta Dental, Vision Benefits of America and CVS Caremark) and prepared functional specifications for the carrier extracts.
• Adding new plans/options and ending existing plans, rate changes.
• Modified the seeded HR workflow processes as per their needs for oracle self-service and Payroll.
• Assisting end user training performed by key users.
• Created Approval Rules, Conditions, and Approval Groups (AME.B) as per the City’s organization structure.
• Wrote dynamic attributes for AME.B and modified workflow notification to display employee number & employee name using Sql and PL/Sql.
• Created security profiles to avoid departments to access other departments Information.
• Regular status reviews through conducting meetings with client & variance analysis if any through issue & risk log.
• Was involved in Unit testing, system testing and in phase of UAT across multiple environments.
• Configured different approval routes for exempt and non-exempt employees.
• Worked closely with the users and trained the trainers on using the OTL functionality
• Performed the Workflow Administrator role.

Environment: Windows, Oracle 10g, Oracle Applications 12.1.2, XML Publisher, SOAP, EiS, JDeveloper, XML Gateway, TOAD, E-Business, Forms 6i, Reports 6i, Discoverer 10g.

Confidential

Sr Functional Consultant - Oracle HRMS

Responsibilities:

• Primary responsibility involves system study, Requirements Gathering, preparing functional specs, Conversion Design, Test script documents, User Manuals and Business Process documents.
• Involved in business requirements finalization process, assisted functional team lead in design, gap assessment, and process redesign sessions.
• Setup OAB as per client legacy plan structure and documented the setups.
• Setup ICD Plans for 401(k) contribution so that, employee can contribute money directly thru self-service.
• Prepared testing documents using AIM and Business user training
• Supported the business users in their testing and ensured all the issues are resolved in a timely manner.
• Wrote conversation documents for moving legacy benefit enrollment data to Oracle OAB.
• Conducted CRP’s (CRP1 & CRP2) for the client to demonstrate the business process flows.
• Successfully completed OPEN enrollment first time with 87% of employee participation.
• Trainings super users on oracle payroll and benefits business operations
• Functional validation of payroll processes and reconciliation
• Design fast formulas for EBA payroll derived allowances
• Module functional design of oracle payroll components
• Business process analysis of legacy payroll system

Environment: Windows, Oracle 9i, Oracle Applications 12.1.3, XML Publisher, SOAP, EiS, JDeveloper, XML Gateway, TOAD, E-Business.

Confidential - Memphis - TN

Sr Techno Functional Consultant - Oracle HRMS

Responsibilities:

• Primary responsibilities include identifying the requirement of reports needed for business users and finding issues in existing reports.
• Participated in detailed payroll requirement information gathering needed for Reports Customization.
• Wrote fast formulas for payroll and OTL processes.
• Developed discoverer reports for OTL, Payroll and OAB.
• Supported the business users in their testing and ensured all the issues are resolved in a timely manner.

Environment: Windows, Oracle 9i, Oracle Applications 12.1.3, XML Publisher, SOAP, EiS, JDeveloper, XML Gateway, TOAD, E-Business.

Confidential - Columbus, IN

Sr Technical Consultant- Oracle HRMS

Responsibilities:

• Data conversion, customization and development of inbound and outbound interfaces.
• Loading legacy system data (csv, xml, flat files) into HRMS using SQL*Loader, pl/sql and API’s available in HRMS modules
• Registering forms, reports, packages, web pages and Unix scripts in AOL
• Customization of SSHR web pages using JDeveloper (OA Framework).
• Customized New Hire V4.0 workflow process for contingent worker maintenance.
• Developed custom web pages in OA Framework for contingent workers self-service for rehire process.
• Developed custom web pages in OA Framework for the Cummins merit review process.
• Extraction of employee, payroll and benefits data from HR, PAY and BEN tables using custom views.
• Development and enhancements of the reports for core HR, Payroll, OAB modules using reports6i and XML Publisher.
• Developed BI reports for COBRA and HIPPA.
• Writing utilities using Unix Shell Scripting for FTP, SFTP, Encryption and Decryption
• Developed Periodic/Event based alerts as per the business requirement.
• Handling Change requests from Clients.
• Analyzing the data issues in development, proxy and production servers.
• Updating the technical documents as per the functional design documents.
• Creating unit test planning and test case documents.
• Code debugging, review, defect sheet updating and checking into Clearcase.
• Prepared functional design specification for the historical conversion event to transfer the benefit elections from legacy system to OAB.
• Prepared functional design specification for the benefit Structure/Eligibility/Rates/Premiums/Others as per the User needs.
• Involved in Design of Life Events, Eligibility, Rates and System Extracts (e.g. Carrier Extracts, AP, Payroll etc.)
• Prepared functional specifications for the carrier extracts and designed/configured/tested the extracts in OAB using system extracts.
• Developed functional specifications for various business rules which were implemented in OAB as fast formulas for the requirements which weren’t satisfied by in built OAB functionality setups.
• Developed functional specifications for various reports needed by the user.
• Used AIM methodology for OAB project plan documents/deliverables.
• Conducting knowledge-sharing programs on every week among the team members.
• Ongoing production support for HRMS/Payroll/OAB.

Environment: Sun OS (8.0), Oracle 9i AS, Oracle Applications 11.5.10, Workflow Builder (2.6), J2EE, BC4J, OAF JDeveloper, XML Publisher, TOAD, E-Business, Forms 6i, Reports 6i, Discoverer, VSS, Clearcase and Citrix.