Executive Summary:

Oracle HRMS Techno-Functional Consultant with over eight plus years of IT

experience which includes almost five years in designing, implementing and

enhancing Oracle E-Business Suite applications with extensive skill set in

Human Resources (HR), Payroll, Advanced Benefits, Time and Labor, Employee

Self Service, Compensation Work bench, Workflow, i-Recruitment, General

Ledger(GL), AP, AR Discoverer 4i/10g, Reports 10g-6i, XML Publisher and

Integration technologies in the areas of Web Services and BPEL. Clients

that I have encompassed are in a wide variety of industries including

Engineering, Oil and Gas, Energy, Finance, Logistics, Retailing and

Communications.

Accomplished a solid record of achievement in Human Resources, Payroll,

Advanced Benefits, Time and Labor; Implementation, development,

maintenance, support, testing and training. Analyzed, designed and

developed successful software solutions for numerous large and diverse

projects. Designed custom solutions, worked in coordination with developers

in transforming design to a solution. Midhun is creative, resourceful and

organized professional with a strong work ethic, hard worker with

analytical and problem solving skills, excellent communication,

presentation skills and excellent team player. Project experience includes

many full life cycle implementations which included requirements analysis,

project planning, solution design, application setup, security

implementation, training and meticulous testing events. He is an

exceptional group member, technical expert and is well equipped with

superior interpersonal and communication skills.

. Experience in Oracle E-business suite Applications release 11i & R12;

Database technologies like Oracle 9i/10g, SQL, PL/SQL, SQL*PLUS,

SQL*Loader.

. Good experience in Oracle HRMS, Payroll, OAB, OTL, SSHR, Forms

Personalization, Oracle Discoverer, Oracle XML Publisher, Oracle

Workflow, Oracle PL/SQL, Oracle API's, Discoverer 4i and 10g, Oracle

Forms, Oracle Reports 6i.

. Gap Analysis, Solution Design, Functional and Technical Expertise.

. Experience includes full lifecycle implementations of Oracle Applications

release 11i covering HRMS modules: Core HRMS, Payroll, OTL, OAB, Self

Service and Workflow.

. Technically proficient in RICE (Reports, Interfaces, Configuration and

Enhancements) methodologies including Implementation, Interfacing,

Conversion and Data Migration.

. Integration of Modules and Business rules along with Oracle HR, Oracle

Advanced Benefits Setups, Standard and Custom Interfaces, custom

reports and other customizations in Oracle Applications .

. Involved in Requirements gathering, Analysis, Design and Configure.

. Expertise in Interfacing, Conversion and Data Migration from legacy

systems to Oracle HR, Payroll and Advanced Benefits.

. Experience in using Oracle Reports, Discoverer and XML publisher for

reports generation.

. Experience includes Application System Administration activities like

managing concurrent managers, application user setup, defining

responsibilities, values sets, reports, concurrent programs by using

Application Object Library (AOL) and knowledge on developing and

customization of forms.

. Strong expertise in Development of FAST FORMULAS (OAB and PAYROLL)which

involve creating cursors, several packages, stored procedures, and

functions to bridge the gaps in the business requirements.

. Strong programming experience in creating Procedures, API, Packages,

Functions, Triggers and other database objects using SQL and PL/SQL.

Providing support to apps users for any technical or functional issues.

. Experience includes support for Benefits Open Enrollment which includes

new Plan structure, Eligibility profiles, Rates/Premium Calculation

Setups, System extracts, Interfaces, and Reports.

. Excellent analytical skills in Analysis and business requirements

gathering from end users to the client and experience in design using

BR100, MD 50,MD70 documents. Proficient in AIM Methodology.

. Developed a suite of utility services (Java components, Web Services,

REST Web Services, code-instantiated and invoked BPEL utility processes.

. Integrating Oracle HRMS product with 3rd Party Software Packages.

Configuring and Integration of Oracle 11i HR to ADP Payroll Systems

Functional/Technical Expertise:

Extensive in-depth knowledge in Oracle apps modules, Technical

architecture, Apps Tables, Oracle apps APIs, Data Flow Between Modules, Set-

ups, Design, RICE Components, Data Mapping, Data Migration/Conversion,

Integration/Interfaces, Customizations, Reports/Forms, Upgrades, Workaround

solutions, Project Planning, Team Coordination, AIM Methodology,

Performance tuning, Debugging and Data Extraction. I am capable of

analyzing business requirements and developing innovative solutions to

optimize business processes and productivity with strong Technical

background and in-depth functional knowledge.

Configured, customized, personalized and created new Responsibilities,

Menus, Functions, System profiles, Security setup by security profiles

request groups, Data groups, Reports, KFF and DFF Flex Fields, Validation

Sets, SIT and EIT's. Involved in Core HR setup; Business Groups,

Organizations, Hierarchy, Jobs, and Grades Setup Multi Worksite Reporting

and complex PAYROLL and OAB setups like life events, Eligibility Profiles,

Compensation Objects and Rates/Coverage setups. Setup EEO Reporting,

supported the processing of payrolls, Benefits open enrollments and user

training. Prepared the technical specification documents (MD070) for

several OAB Interfaces and Payroll Time interface. Supported user community

during testing phase and involved in day to day production issues

resolution, team co-ordination, setting coding standards for the best

technical practices for developers, mapping documents (CV40) and Technical

Design Docs (MD70).

Skill Synopsis:

Applications: Oracle Human Resources, Oracle Payroll, Oracle Advanced

Benefits, Oracle Time and Labor, Self Service Benefits, Self

Service Human Resources, Work flow and Compensation

Workbench, Oracle SOA Suite (BPEL, Web services),OA

framework

Application Oracle 10.7, 11i, R12

Versions:

RDBMS: Oracle 7.x, 8.x, 9i, 10g

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

Tools: SQL*Plus, SQL*Loader, TOAD, Oracle Discoverer, Data loader,

Oracle Forms, Oracle Reports, XML Publisher, Putty, Visio,

PVCS, FND Load, UTL File, Workflow Builder

Oracle Project Experience:

Client: Port Of Oakland(Oakland, CA)

03/2010 to till date

Project: Oracle HRMS, Payroll, OAB, OTL R12 Implementation

Role : Oracle Techno-Functional Consultant

Creating MD-50,Md-70 s for custom component design.

Involved in creating BR100 documents.

Created end-end test scripts for modules HRMS, PAYROLL, OAB &

reviewed with business users during User acceptance testing and CRP

Instances.

Involved in creation of training material and training the users

for HR,OAB processes and payroll runs.

Created the functional setup document with step by step

instructions to migrate the setups through different environments.

Trouble shot workflow issues during approval processes.

Involved in client meetings to decide upon custom components list

and involve din a team to provide solutions and design to the team.

Designed, Developed and Tested HR CONVERSIONS like Locations, Jobs,

Grades, Positions, Employees, Addresses, Extra Information Types,

Special Assignments, Salary, using oracle API'S.

Designed and Developed Payroll conversions like Element Entries,

Element link update.

Successfully implemented Oracle Advanced Benefits data conversion

from legacy to Oracle.

Developed Custom Payroll Reports for FLSA, PERS contribution using

XML publisher.

Developed Oracle Payroll and Benefits Interfaces to Calipers and

benefit vendors.

Used Oracle framework for creating custom pages and functions.

Created lot of fast formulas for benefits, payroll and OTL time

card validations.

Involved in developing various FAST FORMULAS like Auto Enrollment,

Rate Calculation, Interim Coverage, Trigger Life event etc.,

Created reports using BI Publisher (XML Publisher) to update the HR

people to analyze the enrollments.

Used JDeveloper to Customize and personalize java pages using OA

framework for Employee self-service and manager Self-Self Service.

Worked on validating transferring employee timecards to BEE,

Oracle Projects

Developed and executed the data clean up scripts as per business

requirement.

Also responsible for logging TAR's, Issues, Service requests etc

for fixing some bugs in HR and Payroll

Client: HighMount Exploration and Production(Houston, TX)

08/2009 to 03/2010

Project: OAB Open Enrollment 2010 R12 Implementation and support,HR,

Payroll and OTL support

Role : Oracle Techno-Functional Consultant

Benefits

Functional:

Created Eligibility profiles for plans not offered, new plans.

Created new plans, options, employee and dependent eligibility

profiles for Medical, Voluntary ADD, Long term Disability plan

types.

Created coverage calculations, variable and standard rate profiles

for voluntary life insurance, voluntary ADD plans voluntary spouse

life insurance.

Setup the program structure for 2010 Benefit selections by adding

all the new plans and eligibility profiles.

Created default enrollments and enrollment codes for all plans for

open enrolment life event.

Defined open enrollment period and ran processes for scheduling

open enrollment life event.

Created testing scenarios and involved in testing & reviewing with

business users.

Created the functional setup document with step by step

instructions to migrate the setups through different environments.

Provided Support activities during and after open enrollment.

Setup of new Absence elements and their accruals.

Technical:

Created various scripts to get the enrollment information, which

helped in extensive testing.

Fixed bugs in the custom confirmation statement report and changed

the template as per the user's instructions.

Created a Pl/SQL procedure to generate a csv file with employee,

dependent beneficiary information in printer acceptable format to

print the current year enrollment information in the pre

enrollment booklet.

Created report for finding out started and unprocessed life events

at the time of open enrollments and made sure they got processed

before open enrollments.

Created a script and a report which shows people enrolled and the

plans they are enrolled in during open enrollments to keep a track

and sending out notifications to the un-enrolled employees.

Used system extract to interface with third party benefit vendors

(Medical, Dental, Vision & COBRA files). Gathered, analyzed and

created interface data elements, layout definitions, Extract

criteria, Extract definition both for ANSI 834 and regular full

file.

Involved in meetings with the vendors to resolve issues and

extensive testing of the extract files and could deliver them with

open enrollment data as per the deadlines.

Created lot of Fast Formulas of types Extract Person data Element,

Extract dependent data element, Extract Enrollment data element,

Post Extract Rule to effectively send the enrollment data.

Created UNIX scripts to FTP the created files after encrypting in

the vendors specified servers.

Created new confirmation statement templates using BI publisher

Fixed issues with Sick reallocation, Sick Refresh, PTO accrual

carry over process programs to serve the year end requirements.

Used the Batch element entry API to load 2010 vacation

entitlements

Created scripts to delete old i-recruitment data.

Assigned ADP codes for new benefit plans with extensive testing

such that new benefit rates show up in the 2010 element entries.

Analyzed, and fixed the existing ADP census and deductions files

to fix the bugs and made sure that they work properly after the

new plans are implemented.

Created a new time entry validation fast formula to solve issues

with overtime elements in OTL.

Personalized and customized Self Service Benefits screens to meet

the customer look and feel and customization needs.

Generated reports for Benefits bulk confirmation statements,

Enrollment Results, Enrollment Status, Pre and Post Enrollment

Report, Absence plans report with BI publisher.

Generated reports for Business users in Discoverer during

Enrollment process.

Client: Jacobs Engineering (Pasadena, CA )

Project: 07/2007 to 06/2009

Oracle OAB open Enrollment, HR, PAYROLL Support

Role: Oracle Techno-functional consultant

Responsible for requirement analysis and preparation of high level

design document.

Designed, Developed and Tested HR CONVERSIONS like Locations,

Organizations, Organization Hierarchy, Jobs, Grades, Positions,

Employees, Addresses, Extra Information Types, Special Information

Types, Assignments, Salary, Performance Reviews and Ratings using

oracle API'S..

Involved in designing of PAYROLL SETUPS and CONVERSIONS like

Element entry, Element link, Payment methods.

Worked on Data Conversions of OAB (Plan Types, Options, Plans,

Rates, Eligibility Rules and Life Events) as per requirements.

Developed and configured both standard and client specific FAST

FORMULAS as per the requirements.

Worked on designing, validating values, value sets for flex fields

like People Group Flex fields, Soft coding key flex fields, and

Cost Allocation flex fields.

Worked on setting up Accrual plans and Accrual balance adjustment.

Extended Technical and Functional Support for PAYROLL processes

like pre-payments, check -writer and Costing.

Worked on Salary administration, Absence records, Time card entry

and Overtime element records.

Developed REPORTS involving balances in oracle PAYROLL using

pay_balance_pkg and also worked on balance adjustments.

Worked on Open INTERFACES Batch Element Entry (BEE) and OTL-HR

data transfer.

Worked on the design documents and implementation for outbound

extracts for third party health insurance providers.

Worked on Form extensions using the Custom.pll.

Converted oracle REPORTS to XML PUBLISHER REPORTS.

Responsible for designing, creation and registration of XML

REPORTS for HR, PAY, OAB.

Responsible for gathering requirement from user for designing of

the REPORTS.

Responsible to log HRMS TARS for Oracle support and resolve

issues.

Responsible for distributing work among peers for timely

fulfillment of the job.

Supported the implementation and configuration issues related to

Eligibility, Electability, Life events, Rates and configuration

of rates, Premiums etc

Configured OPEN Life Event, new rates, ending coverage's based on

plan and eligibility changes.

Created System Extracts for Health Care providers using the system

extract tool.

Involved in modifying the Interfaces for third party providers to

comply with the vendor requirements.

Client: British Petroleum(Houston, TX)

08/2006 to 06/2007

Project: Oracle HRMS/PAYROLL/OAB Implementation

Role: Oracle Techno-functional consultant

A part of complete HR/PAYROLL/OTL/OAB implementation life cycle.

Implemented HR Conversions like Jobs, Positions, SIT, Element

entries and cleanup scripts like Update Final Process Dates,

Change Standard Hours to 40, and Update Work Schedule at

Assignment and Org level.

Configured various payroll components such as elements, links,

deductions, earnings, payrolls, payment methods and costing. Wrote

number of Fast Formulas to support payroll calculations.

Implemented Advanced Benefit CONVERSIONS like Historical Life

Event Creation, Participant Enrollment, Dependent Coverage etc.

and also Open Enrollment.

Responsible to create new medical, dental benefit elements,

modified formulas, formula result rules and all underlying

reports, processes.

Implemented PAYROLL CONVERSIONS like Federal and State Tax Rules,

Element Links, Personal Payment Methods, Deduction Elements,

PAYROLL Balances, Paid Time-off Accruals etc.

Involved in requirement gathering of INTERFACES. Customized FAST

FORMULAS for various elements in PAYROLL.

Designed, Developed and Tested Batch Control REPORT, Costing

Summary and Detail REPORTS, Employee Changes, New Hire and Rehire

REPORT, Termination REPORT etc.

Designed, Developed and Tested Inbound INTERFACES like Mellon 401K

and Kronos Inbound.

Outbound INTERFACES for healthcare providers using PL/SQL to

extract data from Oracle HRMS tables and used UTL_FILE package to

write data into file

Involved in the various levels of testing.

Resolved issues with the PL/SQL codes in AP, AR modules of the

client.

Post-production Support for HR, PAYROLL and Benefits.

Client: Symmetrix Solutions (Dallas, TX)

04/2005 to 07/2006

Project: HRMS Implementation, REPORTS

Role: Oracle Technical Consultant

Developed an Inbound Interface for Oracle PAYROLL using PL/SQL and

SQL*Loader, Oracle API.

Wrote Control files (CTL) and scripts to load data from ASCII/flat

files into Oracle Database.

Developed Outbound INTERFACES for Oracle HR/PAYROLL.

Developed Conversion program for Employee, Personal Payment

Methods, Salary, and Termination using Oracle APIs.

Develop custom REPORTS for the requirements of clients and

integrate them with Oracle Applications.

Worked on ADP PAYROLL interface.

Build REPORTS for Oracle HR / PAYROLL

Designed and developed a custom Time Entry Form using Oracle FORMS

6i.

Registered the FORMS, created form functions and attaching form

functions to Menu.

Performed unit testing and Integration testing for the INTERFACES.

Customized Various AP/AR/GL/PO REPORTS which includes modification

to Oracle 6i standard REPORTS and creating new REPORTS using

PL/SQL packages, SQL*Plus and 6i REPORTS,XML PUBLISHER.

Client: Info logic Systems Ltd, India

02/2003 to 02/2005

Project: Implementation of Oracle Financials

Role: Technical Consultant

Support Production systems for Oracle Applications (Apps)

10.7/11.0.3 - Enterprise Resource Planning (ERP) Financials.

Modules: GL, AP, AR, Fixed Assets (FA).

Customize Oracle applications10.7/11 (AR, AP,GL, FA,CM) REPORTS

Troubleshoot REPORTS 6i and FORMS 6i. Fixed bugs.

Production support for Applications Desktop Integrator (ADI).

Follow up on MetaLink Technical Assistance Requests (TARs) and

Patches.

Use TOAD for application development. Registered REPORT using

AOL.

Testing and documentation of the REPORTS.

Customized Sales Order REPORT in OM.

Involve in System Administration activities.

Customized GL interface as per client requirement.

Customized AR customer interface.

Customized Purchasing workflow as per client requirement.

Designed and developed and OM Xactly Extract outbound process to

load sales order and credit memos information from AR

Involve in Application tuning and performance, debugging and

tracing the application server issues, concurrent jobs and

workflow issues and provided resolutions.

Client:

BVRIT, Hyderabad India

04/2002 to 01/2003

Project: Oracle FORMS and REPORTS

Role: Oracle Technical Developer

BVR IT was one of the clients at CSS.

Involved in Developing various FORMS and REPORTS as per the

Clients specification, wrote various validation scripts Using

Oracle as Back End & Dev/2000 as Front End.

This module included maintaining the record of students in a

College and their academic details starting from fee details to

exam details and their results.

Using this system locating the details of any particular student

was made possible with ease as the system had a variety of

REPORTS.

Various FORMS were developed to accomplish the requirements.

References:

V Will be provided on request

Contact this candidate