Oracle HRMS Consultant

OVERVIEW

• Over * years of IT experience, with over 6 years as techno-functional consultant with Oracle HRMS , Payroll, OSB, Oracle Advanced Benefits OTL, iRecruitment, Self Service HR Web Applications,

• Strong understanding of HRMS business flows. Actively involved in implementing various modules in HRMS. (HCM)

• Customizing oracle applications using OAF, Workflow, PL/SQL, Forms 6i, Reports 6i, Discoverer 4I/10g, Fast Formulas.

• Strong Exposure to data Conversion and migration to Oracle Applications using ORACLE API, Writing Functions, Procedures, Packages to Validate Legacy System Data, Loading Data into Interface Tables, Handling the Errors.

• Expertise in Preparing/writing Requirement Analysis, Technical, User Training and acceptance and Customization Documents using Software Development Life Cycle Standards

Corporate Affiliations

Position Company

Senior Principal Consultant Polaris Associates Inc. USA Mar’ 06 - Till date

Technical Consultant EiS Technologies, Inc., USA Dec’ 02 – Mar’ 06

Software Programmer Visisht Infosolutions Pvt Ltd, India Jan’ 00 – Nov’ 02

Education

Master of Computer Applications, Bharathidasan University, India.

Bachelor of Commerce, Osmania University,India,Hyderabad.

Applications and Technology Capabilities

ERP Experience E-Commerce/Internet

Oracle R11i, 11.0, 10.7 NCA, 10.7SC - HRMS (Payroll, Human Resource, Advanced Benefits, Compensation Workbench, Ota, Otm, IRecruitment )  Oracle (SSHR) J2EE Oracle 9 IAS, XML, HTML, VB Script, Java Script, Perl, JSP, Servlets

Oracle Stack

• Oracle Applications Framework (11.5.10.CU2), Oracle Workflow, AME, XML Publisher 5.6. • SQL* Plus 8.0, PL/SQL, SQL *Loader, Oracle Forms 4.5 & 6.0, Oracle Reports 3.0 & 6.0, Discoverer 4I, 10g

• Oracle Database 8i/9i/10g • Shell programming

Tools (Others)

• JDeveloper 9i, Sql Navigator, Toad, SqlDeveloper, Jdeveloper 10g ,Visual Basic 6.0 • Fortran/Basic/Pascal/C/C++

Operating System Hardware

• Dos, Unix, (Sun, HP) , • Sun/Sparc, HP, Dell Servers, S390, Es9000,

Win3.1/ Win95/98/2000/ XP

WinNT 4.0 Workstation/Server

Other Database

Ms Access 8, Sybase

MS-SQL Server 7 Mercury Interactive Test Tools

Win Runner

Professional Experience

Knowledge Learning Center, Portland OR, Aug 2008 to Till Date

KLC is the leader and preferred childcare provider in early childhood through school age education. KLC uses the entire suite of Oracle HRMS modules for managing its employee related data worldwide, while, Oracle Payroll is used for paying US employees.

Working as a Senior Principal Consultant for Benefits modules to analyze, design and development.

• Involved in building new report for the 401k like True up, New Enrollment, Vesting Date, New Hire , YE Non Discrimination , Year end Deduction Report.

• Involved in Conversion of Benefit Enrollments from Third Party to Oracle for Open Enrollments

• Worked and involved in some custom Inbound and outbound interface for ODS, IPA.

• Written some Fast Formulas for Rate Periodization Rule, Suspend Enrollment Rule, Derived factor Age calculation Rule.

General Dynamics, Canada, May 2008 to Jul 2008

The client has already implemented HRMS in 11.5.9 but currently they need to change there organization structure in 11.5.10 for this I have written conversion programs and data migration.

• Involved in the Conversion of HRMS Data migration.

• Used the Oracle API to Load History data for the Employee, Assignments, Contacts, Elements, Salaries, and Costing.

• Prepared Technical, User Training and acceptance and Customization Documents

Knowledge Learning Center, Portland OR, Mar 2006 to Apr 2008

KLC is the leader and preferred childcare provider in early childhood through school age education. KLC uses the entire suite of Oracle HRMS modules for managing its employee related data worldwide, while, Oracle Payroll is used for paying US employees.

Worked as a Senior Principal Consultant for SSHR, Payroll ,HR and Benefits modules to analyze, design and development of custom pages using OAF , Personalization and Conversions, Interfaces, Reports, Open Enrollment, and Production Support.

• Worked closely with client to gather requirements.

• Involved in Conversion of Benefit Enrollments from Third Party to Oracle for Open Enrollments

• Worked and involved in some custom Inbound and outbound interface for BCBS, ODS, MERA, IPA.

• Built the custom screens for the Benefits to show the Employees and Assignment history, Leave information and ESM using OAF

• Modified the Seeded Forms Contact & Employee Balances forms to show from the Benefit Service Center

• Written Person Selection Rule Fast Formulas to use with Ben mangle, Blackout and Temporal Communication Process.

• Written Benefit Fast Formulas to derive coverage and rate dates based on business logic

• Involved in production support for various interfaces and reports, resolving issues with Tars.

• Personalization of Seeded Pages based on the Business logic for the client requirements, like In Job Change page add additional Validation and display the alert messages

• Created New Custom Business Area in the Discoverer for the Benefits, HR and Payroll Also created some custom report for the client based on the requirement.

• Worked or involved in several inbound and outbound interfaces for Banks Check Reconciliation, COBRA, BEE, Benefit Balances, Benefit Statements, Headcount, and Fast Formulas using Oracle.

• Modified the Check Writer, Deposit Advice as per the KLC Requirements.

• Created custom Payroll Register, PTO report which will distribute to all the Center Directors and District Managers.

• Wrote programs for converting Legacy data into Oracle HRMS system for Employees, Assignments, Elements, Pay Methods, Salaries, Contacts, Addresses, Contact Addresses, Phones and Costing including history and involved in Benefits conversion.

• Written Payroll Fast Formulas to handle local payroll taxes

• Built the custom tool the KLC Employee Status Monitoring – Auto Status Changes and Auto Termination. This tool is designed to check the number of hours paid to employees over a defined ESM Period, and change the status (assignment category) of certain employees based on defined rules, or automatically terminate certain employees based on defined rules. And provided the Managers warning reports, Benefit processing report, payroll processing report, and Actual termination Audit Report.

• Build the Custom report using XML Publisher for the Positive pay which will show the total number of checks and amount, sent to the Bank of America.

• Built some custom views for the BI, This views give all the information about them employees data from the css, hr.

• Involved in testing and implementation of 11.5.10.2upgrade,

• Responsible for analyzing the impact of new patches and family packs on the current product.

Embry-Riddle Aeronautical University, Daytona Beach, Florida, Sep 2005 to Feb 2006

Embry-Riddle Aeronautical University teaches science, practice and business of aviation, aerospace. Uses the enter suite of Oracle HRMS modules implemented the IRecruitment Customized Job openings for students and approval with the Hiring manger, Recruiting manager, Supervisor and Final approver.

Worked as a Techno Functional and Involved in Setting up the new customization and modification of iRecruitment Process, Workflow and personalized the some pages at responsibility level and site level, creating a new process to monitor and costing

• Customized the Vacancy Approval Process

• Modified the seeded IRC_WF workflow process as per the business requirements.

• This customization process helps the Hiring mangers, Recruiting manager, HR/Comp to change the job description and there position, locations and view the vacancy details.

• Once the final approver approves the notification all the corresponding mangers get the FYI Notifications.

• Customized the Candidate Offer Process

• Modified the seeded HR_OFFER workflow process as per the their needs

• Customized the seeded HR Letter package as per their requirements.

• Created a new workflow and program to send, notifications to the rejected candidates.

• Created a new vacancy monitor process this helps the manager and the users to check the vacancy, which are waiting for the approval or rejection.

• Created a new vacancy costing process.

Enterprise Integration Solutions, Inc , Dec 2002 to March 2006

Oracle Applications 11i - HR/Payroll

Role: Involved in Customization, Development & Implementation of EiS e-Business Reporting and Payroll Processor.

• Build new features of EIS Payroll Processor which automates processing.

• Build Oracle Payroll Reports Check Register, Payroll Register, Earnings, Deductions for new EIS e-Business reporting tool..

• Build new features of EIS Reporting solutions.

• Involved in the development of Conversion Automation tool for EiS which converts HRMS data from Legacy Systems to Oracle HRMS. This tool converts Person, Address, Assignment, Salary, Payment Method, taxes, contacts, phones, EITs, SITs, Terminations, Rehires using Oracle APIs.

• Modified Interfaces between Oracle Advanced Benefits to third party vendors.

• Build Discoverer reports for HR / Payroll / Benefits on demand basis.

• Developed scripts to load Concurrent Programs, Executables, Registering Forms, Tables, Menus, and Reports.

• Developed custom reports Using Oracle Reports

The University of Texas-Pan America. May 2005 To Sep 2005

Oracle Applications 11i – Time Entry System

Role: Involved in Customization, Development & Implementation of time entry system

• Building new system to capture the time.

• Created custom tables to store the time information

• Implemented the system to auto generate timecards for employees

• Involved in the gathering system requirements from client

• Involved in the system design

• Involved in the implementation of time validations and exposition rules

• Building the setup and moving the system to client instances.

Baltimore City Public School System, Baltimore, MD Feb 2005 to May 2005

Oracle Applications 11i – Time Entry System

Role: Involved in Customization, Development & Implementation of time entry system.

• Building new system to capture the time.

• Created custom tables to store the time information

• Implemented the system to auto generate timecards for employees

• Involved in the gathering system requirements from client

• Involved in the system design

• Involved in the implementation of time validations and exposition rules

• Building the setup and moving the system to client instances.

Chick-fil-A, Atlanta, GA Oct 2004 to Feb 2005

Oracle Applications 11i – Time Entry System

Role: Involved in Customization, Development & Implementation of time entry system.

• Building new system to capture the time.

• Involved in gathering system requirements and system design

• Created custom tables to store the timecard data

• Involved in the implementation of workflow.

• Involved in the timecard transfer to BEE.

• Building the setup and moving the system to client instances.

Staff Leasing (Gevity), Bradenton, Florida, May 2003 to Sep 2004

Activities Performed

• Involved in the Conversion of 2000 clients of EPIX with total 30,000 employees from Legacy Systems to Oracle HRMS. This involves conversions Person, Address, Assignment, Salary, Payment Method, taxes, contacts, phones, EITs, SITs, Terminations, Rehires using APIs.

• Implementation of EIS Payroll Processor.

• Build Discoverer reports for HR / Payroll / OAB.

• Modified Web based Time Entry Interface to import worked hours from Excel sheets to Oracle HRMS.

• Developed custom forms for the requirements of the clients and integrate them with Oracle HRMS Product.

• Developed custom reports for the requirements of clients and integrate them with Oracle Applications.

• Customized custom.pll to meet the functional requirements of clients.

• Developed custom forms to track HR Employee budget counts and developed Head count analysis reports by region. Involved in setting up security profiles and custom responsibilities.

• Developed scripts to load Concurrent Programs, Executables, Registering Forms, Tables, Menus, and Reports.

• Developed a custom interface from Oracle HRMS to MSA Payroll (Legacy System). This interface will captures new hires and any changes to existing employees in HR database on daily basis and transfers them to MSA Payroll. Developed a custom form to run this interface. Developed Custom workflow process to send notifications on any salary changes or position changes to the management team.

• Developed custom views for reporting purpose and configured Discoverer End layer so that user can access these views for reporting purpose.

• Developed various Custom Reports for Head Count Budget Analysis for HR Community.

• Designed and developed various number of views for HR/Payroll users in discoverer and integrate them end layer.

• Customized the Payroll register, Check writer for client needs.

• Mentored in-house technical people and assisted them in developing custom reports & interfaces.

Visisht Infosolutions Pvt Ltd, India, Jan 2000 to Nov 2002

Position: Software Programmer

Environment: Oracle 8i, Oracle Tools, UNIX, and DOS.

Forms 4.5 & 6, Report 6, Visual Basic 6.0

Involved in Requirement Analysis, Design, Development & Implementation of the Product HRIPS.

HRIPS is a Payroll Product from Visisht Infosolutions Pvt ltd., for automating Payroll/HR process across the organization. This is basically developed in oracle Client Server architecture & GUI environment and designed to meet the requirements of the business rules.

Implementation Experience: Implemented Payroll Product (HRIPS) for the following clients:

Avanti Corp (Synopsys) –India

Dr Reddy’s Laboratories –India

Tata Honeywell - Pune (India)

• Involved in converting the legacy data in to HRIPS (Payroll Product).

• Installation and Configuration of Oracle Database and Performance tuning.

• Developed custom forms for the requirements of the clients and integrate them with HRIPS Product.

• Developed custom reports for the requirements of clients and integrate them with HRIPS Product.

• Customized custom.pll to meet the functional requirements of clients.

• Developed interfaces between HRIPS to Oracle Financials for costing.

• Developed various Custom Reports for INCOME TAX, Statutory reports and MIS Reports.

• Led the development team through out the implementation at various client locations.

Development Experience: Developed a comprehensive and integrated ERP solution for the following client:

Excel Logistics - India

Enterprise Software & Solutions for Express Business (ESSFEB) is a comprehensive and integrated ERP solution for Transportation and Distribution Logistics for companies engaged in Courier, Express Cargo and Transport Business. This Application was implemented for Chennai based Excel Logistics. The ERP solution caters to all functional requirements of business of logistics Companies starting from Business prospecting to Customer Service. The software implements Hub and Spoke arrangement of movement of cargo. The application operates in Client Server environment at Branches, Area Offices, Regional Offices and the Head Office. The external interface is available through Internet for Track & Trace, On-line Booking, On-Line Complaints recording, and Products & Services etc. Application also provides automation through interface with mailing and FTP system. This Application consists of 14 modules.

References: Available upon request

Contact this candidate