PROFESSIONAL SUMMARY:

• Over 12 years of progressive experience in implementing and maintaining Oracle HRMS Applications. Experience in both functional and technical domain. Demonstrated capability in all functional phases of implementation - Requirement Gathering, Design, Gap Analysis, Configuration, Testing, CRP, UAT, End user and post Go-live support and experience in support, upgrade (11i to R12) and rollout projects.
• Good expertise as well as sound knowledge of Fusion HCM Offerings: Workforce Deployment (Global HR, Payroll), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Compensation workbench, Absence Management and Security.
• Strong understanding in Fusion Security Model and creating roles and various security Profiles.
• Strong Knowledge on Cloud Functional Setup Manager.
• Technical expertise in HCM Extracts, Spreadsheet Loader, HCM Data loader, Payroll Batch Loader, OTBI and BI reports, Dashboards, Page personalization using sandbox and Approval setup.
• Experience in design of Reports, Interfaces, Conversions and Extensions (RICE), workflow customization, Form customization, alerts, AME configuration Implementation and support of various Oracle Apps modules. Involved in implementation, upgrade and rollout of Oracle HCM modules like Core HR, Self service Human Resources (SSHR),Oracle Payroll, Oracle Advance Benefits (OAB),Oracle Time and Labor (OTL), iRecruitment, Performance Management, Learning Management(OLM).
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support.
• Worked on Documentation using AIM methodology for Business Requirement Definition (RD050), Business Requirement Mapping (BR030), Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Document (MD070), Business System Testing (TE040), Conversion Mappings (CV40) and Conversion Test Plans (CV70).
• Expertise in Data Conversions, and working with business owners to determine data mapping to design the data templates accordingly.
• Experience in managing & creating Flex Fields like Key Flex Fields, Descriptive Flex Fields, and Values Sets.
• Experienced in configuring Workflow routing rules for all Manager Self-services (MSS) and Employee Self-services (ESS).
• Good leadership and commination skills, on time deliveries, multi-tasking and assisting clients in the selection, implementation planning, fit/gap analysis, conference room pilots, configuration, testing, to end users, upgrade, rollout, post-implementation support.

TECHNICAL SKILLS:

Operating systems: Windows 95/ 2000/ NT/ XP, Linux, Unix

Fusion HCM Cloud: - Workforce Deployment, Workforce Development, Talent Management and Security

ERPs: Oracle Applications R-12, (HRMS, HR, Self service HR, Payroll, OTL, Learning Management, Performance Management, Absence Management iRecruitment and AME)

Lang/ Tech: SQL, PL/SQL, OAF (Oracle Application Framework)

Tools: TOAD, SQL Developer, Forms 6i/9i, Reports 6i/2.5, SQL*Loader, Jdeveloper, Oracle Workflow Builder, SQL*Plus, XML, Publisher, MS Visio, Data Loader.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

HCM Techno Functional Consultant

Responsibilities:

• Development and testing of inbound and outbound interfaces for HR and Payroll.
• Requirement gathering, design and preparation of Functional design document and unit test scripts for RICE objects in HR and Payroll.
• Setup of grade ladder and grade step and development and testing of custom program for mass update of assignment grade step and other inbound and outbound HR interfaces related to EIT and outbound file created with employee’s personal and assignment details.
• Basic payroll setup involving setup of payment method, creation of element link and enable qualifiers and define costing details in payroll
• Development and testing of payroll outbound interfaces and quick pay run, payroll process run, pre-payments, check writer, NACHA, costing, payroll reversals, rollbacks etc. as part of interface testing.
• Creation of assignment sets, element sets and Batch element entries and customization of payroll and third party payroll check.
• Development and testing of Benefits report with Medical, dental and vision plan details. Process Life events and enroll to plan based on eligibility to test Benefits report.

Confidential, Chicago

HCM Techno Functional Consultant

Responsibilities:

• Did end to end implementation of Oracle Performance Management (Objective setting process and Appraisals). Received client appreciation for successful implementation and deployment of project. Configured competency flexfield, rating scale, questionnaire, objective and competency templates, eligibility profile, defined competencies, published performance management plans.
• Built custom programs for objective sharing, push employee’s scorecard to manager, Allocation of managerial competencies to manager and cascade objectives of top-level executives in supervisory hierarchy.
• Worked on BI, EIS and oracle reports for Core HR (People and Assignment data), OTL, Performance management, Learning management, irecruitment. Gathered business requirement for development of reports and prepared functional design document (MD050) for technical team. Did thorough testing, identified bugs and involved in development and modification of reports as per business requirement.
• Involved in support and enhancement of Oracle R12 HRMS modules like core HR, Payroll, Self Service HR, Performance management and Learning management.
• Involved in payroll balance adjustment, modification of fast formulas and creation of element entries as per business requirement.
• Involved in enhanced retro pay setup and creation of event group, retro pay elements and creation of links for different elements. Assisted business users with retro pay processing and payroll processing.
• Developed concurrent programs to automatically assign/end date elements based on employee’s assignment criteria.
• Involved in writing and modification of Fast formulas used in Oracle Payroll, Oracle Performance Management and Oracle Advanced Benefits.
• Involved in setup of responsibilities, menu, functions, security profiles and did personalization for self-service HR modules (employee self-service and manager self-service). Configured various functions in ESS and MSS for rmation, special information types, al Qualifications, Appraisals etc. Did page level validation using user hooks.
• Involved in workflow customization and modified HR workflow processes to meet business requirements, AME configuration for different processes in HR modules - absence management, enrollment approvals in Learning management etc. Development of interfaces, custom programs and alerts for core HR, Performance management, i recruitment and Payroll. Did customization of workflow notifications for self-service functions. Defined task flow nodes and task flow to customize forms.
• Involved in implementation of absence management. Defined absence elements, absence types, accruals, fast formulas and configured employee and manager-initiated absences with approvals in self-service modules.
• Developed SQL queries for data analysis and reporting needs.
• Involved in implementation of i-recruitment. Configured vacancy and offer approval process. Setup of external site visitor, security profiles, menu and responsibility for different users. Did workflow customization and configured approvals for vacancy in i-recruitment (Workflow customization to update vacancy status during different stages of vacancy creation and update approvals) to meet Business requirement.
• Documented As-Is and To-Be processes as per AIM methodology (RD50, BR30, BR100, TE040, MD050, MD070 document preparation). Involved in time/effort estimates for custom components and accordingly, distribution of work to team members.
• Involved in troubleshooting issues and resolving tickets on priority and raised service request on Oracle Metalink for support related issues.
• Participated in detailed Payroll requirement information gathering needed for Reports development.
• Designed employee date tracked report, new hire report, employee assignment report, organization wise summary report to show regular earnings, over time earnings, sick leave earnings, regular hours worked.
• Involved in OAF personalization, form personalization, workflow customization.
• Assisted functional team and end user for Payroll Pre-processing, Payroll Processing, Process Payroll Using subsets (Assignment set, Consolidation set, Element set), Elements creation, Payroll Post processing, Costing, Year End Process, NACHA, Deposit Advices, Check writer, Quick pay, Rollbacks, Retries, Reversals, Run various reports, Retro pay Process.

Confidential

HCM Techno-Functional

Responsibilities:

• Worked as a Functional Lead in end-to-end implementation of Compensation workbench (CWB), participated in requirement gathering, solution design, build and deployment of Compensation workbench. Conducted UAT and involved in resolution of UAT issues; performed internal functional testing and interacted with technical team for delivery of custom components. Custom programs, web ADIs and discoverer reports were build to meet business requirement. Received client appreciation for successful implementation and deployment of the project in record time with minimal bugs.
• Worked on the Bank file Transfer interface and also few internal interfaces like FND user interfaces where the Program is set create the FND User and also attach the Employee Self Service responsibility to the user.
• Worked on the Data migration activities of Core HR/Payroll through conversion scripts (like employee creation, assignment, job, contacts, phones, address, bank details, element entry, pay proposals etc.)
• Involved in upgrade activity of HRMS modules (Core HR, SSHR, OLM, PMS) from 11i to R12.Did thorough testing of all functionalities.
• Support and enhancement of Core HR, Self-service applications HR (ESS and MSS), Oracle Learning management and i-recruitment modules in R12.
• Rollout of iExpense module for Airtel Sri Lanka.
• Involved in Oracle Forms 6i customization to meet business needs.
• Involved in development of XML reports and data analysis and testing of discoverer reports developed for Core HR, Oracle learning management, irecruitment modules.
• Participated in gathering business requirements and preparing AS-IS documents, discussed and finalized TO-BE processes along with GAP fitment documents, conducted CRP and UAT and involved in build and deployment of talent management and succession planning bolt-on. Custom programs and pages were built to meet the business requirement.
• Developed SQL queries for data analysis and PL/SQL processes to perform various HR processes as per Business requirement.
• Involved in design and setup of termination process in core HR. Setup of approval and checklist for employee and manager initiated termination.
• Involved in creation of inbound interface for integration of payroll data sent by third party and setup of custom payslip for employees, manager and HR in employee self service and manager self service.

Confidential

HCM Techno-Functional

Responsibilities:

• Involved in implementation and end-user of Core HR, SSHR, Payroll modules.
• Post production support of Core HR, Self-service applications HR (ESS and MSS), payroll in R12
• Developed dynamic SQL queries for data analysis.
• Involved in data conversion for Core HR and Payroll. Defined and linked elements, Balance initialization, balance adjustment, creation and modification of fast formulas as per business requirement, setup of payment methods, creation of earning and deduction elements, setting up of cost allocation key flexfield and GL flexfield mapping, batch element entries, retro pay setup.

Confidential

HCM Techno-Functional

Responsibilities:

• Involved in client interaction, requirement gathering, system demonstration, solution design and application setup of Core HR, Self Service applications HR (ESS &MSS), i-recruitment, OLM and PMS.
• Planned and conducted successful CRP and UAT of Core HR, Self-service HR (ESS &MSS) in Bharti Teletech and Core HR, Self Service applications HR, i-Recruitment, OLM and PMS in Bharti Infratel Ltd.
• Developed D2K reports for Core HR,PMS and i-recruitment modules.
• Documented As-Is and To-Be processes for Core HR, SSHR, OLM and PMS as per AIM methodology (MS Word (RD50, BR30, BR100, TE040, MD050, MD070 document preparation)). Involved in time/effort estimates for custom components and accordingly, distribution of work to team members.
• Configured security structure - Menus, Nodes, Task Flows, Responsibilities, Request Groups, and Security Profiles including Custom Security Profiles and customized oracle forms after creating a replica.

Confidential

HCM Techno-Functional

Responsibilities:

• Involved in series of discussions with client to understand their requirements and provide best-fit solution for payroll. Successfully conducted current process study (AS IS) and Future Process Mapping (To BE) for Payroll. Involved in design and solution build for Payroll.
• Responsible for development of custom payslip and Oracle Reports using xml publisher for OTL.
• Responsible for development of OTL interface (Inbound interface) to integrate swipe in time with oracle and split time (overtime, late entry etc.) as per the business logic.
• Responsible for development of user hook and configuration of AM for SSHR (ESS and MSS).
• Development of standalone custom workflow for approval process in OTL (Workflow was called from custom page/OA page).
• Developed data migration templates and scripts and involved in data migration of person and assignment records. Used MS Excel (CSV format) for data correction and upload.Responsible for development of Alerts for different HR and payroll processes, Configuration of AME for self-service HR, Interfaces for core HR and payroll.
• Development of D2K reports for HR, Payroll, i-recruitment and OLM.
• Development of encryption decryption interface to encrypt and then decrypt at run time confidential information in payslip. Built custom payslip and user hook for Leave validation.
• Basic Setup of Payrolls, Elements, Input Values, and Element links for Earnings, Deductions, and Information type elements, payroll fast formula and balances and balance dimensions.
• Configured security structure and handled issues related to Security Structures - Menus, Nodes, Task Flows, Responsibilities, Request Groups, and Security Profiles including Custom Security Profiles.
• Involved in Oracle Forms 6i customization.