Summary

• Over 10 years of progressively responsible experience in Oracle Applications consulting with involvement on both functional and technical aspects of the product. Possess extensive experience in the following modules:
• Oracle HRMS Applications like HR, payroll.
• Oracle advanced benefits and compensation work bench
• Oracle i-Recruitment
• Oracle Time and Labor OTL
• Oracle Alerts
• Oracle Self Service using Application Object Library AOL
• Extremely adept at designing simple solutions to complex problems and technically proficient in the following:
• Oracle OAframework
• Oracle PL-SQL, Shell Scripting, XML Publisher, WEB ADI
• Forms 9i/6i/5.0, Reports 9i/6i/3.0, Discoverer
• Fast Formulas, Custom Libraries and Workflow

Skills and Experience

Employment History

Job Title Oracle HRMS Techno Functional Consultant

Confidential

Roles and Responsibilities

• Implementation and setup of Open Enrollment in Oracle Advanced Benefits Module in R12.
• Extensively worked on developing fast formulas in OAB Module.
• Involved in resolving production issues during open enrollment in vision interface, COBRA interface and UHC interface.
• Extensively worked on Outbound interfaces for Benefits extracts Medical Vendor, Dental Vendor , Vision vendor ,COBRA vendor and FSA vendor.
• Extensively worked on Setting up plan enrollments, SIT upload and different setups in Compensation Work Bench.
• Extensively worked on Medical/vision/Dental Interfaces technical modifications.
• Used Oracle Meta link for raising and tracking SR's for oracle support, issues and patches.
• Used AIM Methodology for project related documentation.
• Developed an outbound Interface for Cobra file. Developed an outbound interface on Employee's Vision Plan.

Job Title Oracle HRMS Techno Functional Consultant

Confidential

• Department of transportation is state government of Confidential. RIDOT uses Oracle HRMS module for managing HR information and timecard information. RIDOT is mainly focused on this project upgrading oracle internet time to oracle time and labor module.
• Working as technical consultant to analyze, understand customer requirements and developed best solution .

Roles and Responsibilities

• Upgrade is mainly focused transfer information from oracle internet time to oracle time and labor then transfer timecard details from OTL to Grants Accounting module.
• Developed Complex programs to transfer timecard details from time and labor to Grants Accounting.
• Extensively worked on Customization and setting up time and labor workflow such as OTL Workflow for Employees to meet the customer requirements
• Extensively worked on extending OAframework page controller, view objects and application modules in time and labor module
• Developed triggers on database objects like tables.
• Developed program to update people group flex field program to make timecards editable
• Developed conversion program to convert data from OIT to OTL
• Developed Lot of customizations in timecard.ldt ,review.ldt file and confirmation.ldt file which meet the customer requirements in oracle time and labor module.
• Personalized time entry page using self service personalization.
• Developed program to update accruals balance as per bi-weekly basis.
• Developed lot of reports to report data from oracle internet time to time and labor module.

Job Title Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• Setting up open enrollment process for 19291 employees in 2012 year and involved in resolving many issues during this process.
• Conduct meetings workshops to capture department mission vision.
• Designed and built Compensation workbench plans such as Bonus processing plan and success objectives plan.
• Developed many Payroll and OAB Fast Formulas.
• Extensively worked on iRecruitment setup issues, open enrollment issues and CWB issues.
• Implementation of new weekly payroll and new benefits associated to specific payroll.
• Was involved in setting up new rates for long term disability.
• Designed pl/sql programming for custom programs and adp payroll setups.

Job Title: Oracle HRMS Technical Consultant

Confidential

Roles and Responsibilities

• Extensively worked on r12 upgrade in Oracle HRMS application for Core HR and Self Service HR.
• Completely worked on oracle payroll and HRMS in extracting data from HR to ADP payroll interface technically and functional.
• Extensively worked on extension of OAframework WebPages.
• Extensively worked on customizations, personalization's of Self service WebPages in Employee self service and Manager self service.
• Involved in setting Core HR configuration setups like job, position, grade ,key flex fields and descriptive flex fields in Core HR setup.
• Was involved in report development in R12 upgrade project for payroll
• Was worked on PL/SQL programming, forms, discoverer reports in oracle HRMS and Payroll. Was extensively involved in Core HR conversion, iRecruitment conversion.
• Used Shell Scripting for FTP process to send the file to vendors.
• Used Shell Scripting for PGP encryption.
• reeshma

Job Title: Oracle HRMS Technical Consultant

Confidential

Roles and Responsibilities

• Extensively involved in Oracle Time and Labor module, Payroll for US Business Group and Benefits Module.
• Was involved in setting up OTL self service process by defining Approval rules, Hours types, Time entry rules, Approval styles and Setting up the Preferences.
• Worked on approving and transferring timecards from OTL Self Service to BEE.
• Developing technical specification and performing actual conversions from legacy system to Oracle applications.
• Extensively worked on Fidelity Interface development, testing, training and sending files to fidelity in Rovi Corporation.
• Extensively worked on Benetrac Benefits Inbound interface development, testing, training users with SONIC integration with Rovi Corporation.
• Extensively worked on Payroll interface of importing 800 sonic employees, payroll information from SONIC organization into Rovi Corporation.
• Developed reports using discoverer report like US employee's headcount report.
• Was involved in resolving Helpdesk tickets from different countries like United States, UK and Germany.
• Used Oracle Meta link for raising and tracking SR's for oracle support, issues and patches.
• Used AIM Methodology for project related documentation.
• Customization of discoverer End User Layer involved creating customized folders, building robust business layers, customized joins and granting privileges.
• Creation of discoverer workbooks for iRecruitment implementation reports.
• Designed MD70 documentation Benefits, payroll conversions and discoverer reports.
• Used SQL Loader to import Benefits, fidelity and Payroll data from flat files to Oracle tables.
• Developed test cases for unit and integration testing.
• Designed technical documents and release notes.

Job Title: Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• OracleApplications11i 11.5.7 , Windows2000, Oracle 8i RDBMS, Payroll, OAB, HR, SELF SERVICE, Open Enrollment, Reports6i, Forms6i,Discoverer4i, Workflow.
• Involved in finalizing the Target Flow Process, extensively worked on Employee Self Service Personal Information, Online Pay Slips, Tax Forms, Pay Methods, Leave of Absence and Manager self service Hire, Assignment Change, Pay Change, Manager Change, Terminations using OracleApprovalmanagement.
• Use of Workflow builder for Employee Self Service Involved in day to day production
• Customized the Seeded Check Writer and Deposit Advice Report as Client's Requirement.
• Developed an outbound Interface for Ceridian on Cobra file. Developed an outbound interface for Eyemed on Employee's Vision Plan.
• Used API's for mass Salary Upload of Employees, Termination and NEW-Hire.
• Used the BEE API for dumping the payroll data into Element entry tables. Solved lot of setup issue with Elements in payroll process. Added couple of interface to different Responsibilities. Created SQL Loader script to populate the staging tables from the feed data, created PL/SQL packages to validate the feed data against the primary tables.
• Extracted the Balances using pay balance pkg.get value. Helped in setting up of EIT's and SIT's of People and Assignment. Defined and designed various KFFs, DFFs, value sets, and carried out validations.
• Involved in creation of TAR Technical Assistance Request Report in Metal ink. Added Third Party sick pay Element for calculating STD Leave.
• Created EULs according to user requirements using Discoverer Administration and was involved in giving privileges and security roles Discoverer Administrator.
• Created Custom Folders built on SQL, PL/SQL Functions. Created Functions, Calculations, and Item classes, Summaries, Hierarchies and Joins. Worked in SQL Importing and Exporting. Converted standard application reports to Discoverer reports as per user requirements.

Job Title: Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• Involved in the full life cycle implementation of i-Recruitment Responsibilities included configuring the required profile options, setting up additional DFF's, Lookups Also was involved in setting up Qualification Types, Competencies, Compensation Plan, Security Setup and testing since the module to the company's extranet. Worked closely with the Business to define the Approval Hierarchy for both Vacancy creation and Candidate Approvals. The Approval process was setup using Oracle Approvals Management Engine AME .
• Solely responsible for setting the EAM plug-in for the Resume mirror concept in iRec. Setting up of offers and creating multiple custom offer letter templates using XML Publisher, Integration of the job with the Job Vendors like Monster, Career BuilderandHotjobs . Wrote one-time PL-SQL programs to convert Recruitment data from various Legacy systems, which in some cases included spreadsheets. Also created audit scriptstoassistwithdatareconciliation.
• Was involved in setting up iRecruitment module Recruiting Sites, Applicant Assignment Statuses, External Assignment Statuses, Creating Vacancies, Vacancy Approvals, Vacancy Security, Job Seekers, Site Visitors, Registered Users, Job Search, Job Baskets, Candidate Processing ,offer and Hire.
• Developing technical specification and performing actual conversions from legacy system to iRecruitment applications.
• Designed and developed iRecruitment Conversions like Vacancy Conversion, Applicant Conversion, Skill Conversion and Competence Type conversion using PL/SQL programming.
• Was involved creation, updation, deletion process, personalization and extension of web pages in OAFramework and ADF modules
• Created and maintained Daily Business Intelligence Discoverer Business areas.
• Customization of discoverer End User Layer involved creating customized folders, building robust business layers, customized joins and granting privileges.
• Creation of discoverer workbooks for iRecruitment implementation reports.
• Designed MD70 documentation iRecruitment conversions, forms, reports6i and discoverer reports.
• Worked on designing reports using reports 6i developer.
• Worked on designing form using forms6i developer.
• Was involved in designing and registering oracle iRecruitment reports using reports 6i.
• Used Shell Scripting for FTP process to send the file to vendors.

Job Title: Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• Worked extensively on Oracle Payroll with specific focus on configuration.
• Worked closely with the functional lead to assist in the setup of Payroll Elements, Taxation rules, GREs and Tax Balances. Also worked on Paid Time Off PTO setup for Vacation, Sick and PTO plans.
• Create a Benefits Report using Reports 6i by aggregating data from various Oracle Advanced Benefits OAB Tables.
• Created an interface for hospital System call as STIX, where you pull all the current as well as Ex-employees information and put into a file which in turn is passed into the Hospital system called STIX.
• Create a View only Custom Form using Forms Configuration.
• Created SQL Loader script to populate the staging tables from the feed data, created PL/SQL packages to validate the feed data against the primary tables.
• Prepared functional document to Create Assignment Set programmatically to include all the employees both existing, rehire as well as terminated employees eligible for special pay so that the payroll processes only employees with pay.
• Prepare specification to process the payment of long due special bonus to the eligible employees. Coordinate with the users, identify the employees based on the various criteria, and include programmatically the eligible employees into various Assignment sets, to be processed by various payrolls.
• Defined and designed various KFFs, DFFs, value sets, and carried out validations. Created missing information Report of Phone, email, location comparing with the Directory system and Hr system that list using Reports 6i.

Job Title: Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• Customized Oracle Application Forms Element Entry System, Address and Phones, School and Colleges and Person as per the Client Needs using Forms 6i. Was involved in setting up Paid Time off PTO Accruals in absence Management.
• Was involved in customization of Checks and Deposit Advices as per the business requirement.
• Worked on adding columns in Employee self Service Responsibility with support of Java Entity Object OAFramework Extensions Personalization.
• Involved in creation of template builder and registration of XML reports like Check Writer XML and Deposit Advice XML .
• Customized effort report form of the Oracle Application as per the Client RequirementusingReports6i.
• Developed inbound interface For Mass Upload of Salaries from legacy system to OracleHRMSTables.
• Developed file for the Hospital. This process creates a file of all active hospital employees.
• Developed outbound interface to builds a file of employee data for Hospital Employee Health and developed the report for the same.
• Developed outbound interface for all the employees. This file is created monthly of all employees and developed the report for the same.
• Developed Arrearage summary report for the Employees. Developed the script to load the data into the temporary tables using SQL LOADER.
• Created concurrent programs to integrate them with Oracle Application instance.

Job Title: Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• Worked on implementation setup processes of Oracle HRMS applications-HR,ADP, and OAB
• Worked on setting up of Work Structures - Location, Organization, Job and Grade in HR.
• Involved in setup and implementation of Absence management with Accrual Plans to define the Vacation package for the employees and Involved in definition of Absence types, Accrual Plans.
• Involved in Data Mapping to better understand the requirements.
• Extensively involved in setup of System Extract, Flex credit programs and Benefit pools.
• Defined Eligibility profiles, Enrollment Requirements, Plans, Programs and standard rates.
• Worked on Conversions for Employees, Addresses, Phones, Assignments, and Salary using Oracle seeded Application Programming Interfaces.
• Extensively worked PL/SQL Entity Object, Debugging OAFramework pages and Master details pages in OAFramework.
• Worked on Oracle ADP Connection Implementation project to send employee data from Oracle HR to ADP.
• Was involved in Hiring Applicants and Terminating employees.
• Was involved in writing the PL/SQL procedures, packages and functions for meeting the business requirements.
• Designed MD70 document for conversions and MD50 for ADP interface.
• Was involved in designing and registering oracle HRMS reports using reports 6i.

Job Title: Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• Extensively worked on E-Business Suite applications-HR, Payroll and OTL
• Was involved in working HR core entities like Person, Assignment, Organization, Address, Phone and Contact.
• Involved in defining Elements, Element sets, Assignment sets, Consolidation set, Element links.
• Worked on Transferring Timecards to BEE.
• Was involved on transferring timecards to third party interface such as KRONOS interface.
• Extensively worked on 401K interface for payroll bi-weekly employees.
• Involved in writing Discoverer reports for Employee Contacts, Person EITs, Employee Assignment, Assignment EITs, Person flex fields.
• Worked on Conversions for Jobs, Extra Information Types, Personal Payment Methods and Elements.
• Extensively worked in Canadian payroll of ADP setups.
• Extensively involved in setting up Date tracking modes and termination process.
• Used CUSTOM.PLL extensively to modify the functionality provided by standard forms according to client requirements and created custom forms using zoom functionality.
• Created and maintained Daily Business Intelligence Discoverer Business areas.
• Customization of discoverer End User Layer involved creating customized folders, building robust business layers, customized joins and granting privileges.
• Designed MD70 documentation for payroll and HR conversions.
• Worked on Conversions for Jobs, Extra Information Types, Personal Payment Methods, Elements using Oracle seeded API's.

Job Title: Oracle HRMS Functional-Technical Consultant

Confidential

Roles and Responsibilities

• Extensively worked on E-Business Suite Applications-HR,ADP,OLM
• Was involved in setting Salary Administration setup and absence management.
• Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types.
• Involved in System administrator related tasks- Creating Users, Responsibilities, Menus and Function Security.
• Integrated Oracle HR with ADP for payroll processing and designed and developed the interface between the systems.
• Integration with third party ADP to run the payroll
• Worked on Catalogue security and managing enrollments in oracle Learning Management.
• Involved in developing forms and reports for Salary Administration System project.
• Involved in data modeling and schema design for efficient storage of data.
• Developed various business and ad-hoc reports.
• Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.

Job Title: Oracle HRMS Functional-Technical Consultant

Roles and Responsibilities

• Involved in resolving the up-gradation issues in Payroll, OAB and HR modules through Meta link.
• Analyzed Business requirements designed and specified functional and technical solutions.
• Created test plan, test labs and raising defects in Mercury Quality center.
• Defined Security Profiles and Profile Options.
• Involved in validating the existing Key Flex-fields, Business Group, Organization and Organization Hierarchy, Security Profiles, Task Flow Nodes and Task Flows.
• Was extensively worked on open enrollment in advanced benefits OAB .
• Worked on setup of prerequisite payroll processing steps-Consolidation sets, element set, payroll definition and payment methods.
• Involved on setup element costing process in payroll.
• Designed payroll reports and registered into oracle using reports 6i/10g builder.
• Worked on Development and Testing instances Following SDLC .
• Developed AIM documents-MD70 and BR100.
• Involved in end-end testing of objects including installation scripts, Download and upload Ldt files.
• Responsible for developing Libraries, Packages, Procedures and Functions using PL/SQL for HRMS.

Job Title: Oracle HRMS Functional-Technical Consultant

Roles and Responsibilities

• Responsible for designing and developing extensions for Oracle HR.
• Designed and developed an error-handling Package to store errors in custom tables using PL/SQL in Oracle HRMS APIs.
• Responsible for developing Libraries, Packages, Procedures and Functions using PL/SQL for HRMS.
• Designed and developed custom database packages for HR and Payroll modules
• Developed Packages to validate raw data from Flat Files and insert into tables.
• Used Public APIs Order HRMS APIs to upload/update the Legacy system data
• Responsible to load external data in the Oracle database using Oracle APIs and SQL Loader.
• Customized and developed forms using CUSTOM.pll and TEMPLATE.fmb to meet the clients requirements
• Created and Scheduled Jobs from time to time.
• Created Records, Tables, Objects, Collections Nested Tables and VArrays , and Error Handling.
• Performed Unit Testing on Forms and Reports and PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Created UNIX scripts for automating the conversion from the legacy system
• Extracted and analyzed HR and Payroll data using SQL to be used in reporting and/or loading into another instance of the application
• Coordinate with the client, trouble shoot and resolve the technical issues.