SKILL SUMMARY
Applications: Oracle Application R12/11.5.10 (11i) /11.0.3.
Modules: HRMS, Payroll, OAB, SSHR, OTL, AR, GL, PO, AME, iRecruitment.
Technology: Workflow, Fast Formula, Discoverer

PROFESSIONAL OVERVIEW

• ERP expert with 13 years experience in implementation of HRMS, Payroll business systems and Financials for diverse organizations. I have 10 years of Functional and technical experience in all phases of implementation of Oracle Applications with 4 full cycle implementation.
• Strong Oracle HRMS, Payroll, OAB, OTL, AP, AR, GL knowledge crossing multiple responsibilities including Lead and practical activities.
• Excellent communication skills to interact with users/clients to clearly understand their requirements and business use and translate them Business Requirements Doc and Functional Design Docs using AIM methodology
• Effective leadership skills to manage and implement small to mid size projects using Oracle methodology and tools.
• Worked extensively in integration of HRMS, Payroll with other Apps modules.
• Provided implementation and post production support for medium and large companies (20k to 220k employees) as a lead payroll implementation consultant; a payroll tax year end lead; a post-production stabilization and subject matter expert; a project lead and a business process reengineering specialist.
• Worked on integration between Oracle application and other application, eg. ADP, Hewitt (India Payroll). Design interfaces to interact with ADP, Hewitt.
• Experience in conversion of HR and financial data from legacy system to Oracle application
• Experience in Off-shore model and multiple localization.
• Designed RICE objects based on business requirements

Work Status
US citizen

Education
MS Computers

Client: Confidential, 04/09 - till date
Position: Senior HRMS Business Analyst

• Providing Functional support for Payroll, HRMS and OAB processes and activities.
• Reviewing current practices and setups for HRMS, Payroll and OAB. Redesigned and implemented processes for payroll processing(element set, and benefit deduction (AFLAC).
• Enhanced and redesigned the 401k processing and PTO. New element setup and fast formula modification. Enhanced the interfaces.
• Worked with offshore team of technical consultants. Providing documentation and solution design to develop solutions
• Working on Design and development of interfaces with third party vendors, viz. ADP, TALX.

Client: Confidential, 06/2006 - 01/2009
Position: Lead Oracle HRMS Functional Consultant

• Worked on HR/Payroll Assessments/Setups as part of R12 functional scoping
• Worked as Functional Lead for India Localization implementation. Worked with business to gather business requirements and translate them into Functional Design Docs.
• Provided Solution Architecture for Spinoff project. This was to spinoff a subsidiary (LPS) from the parent company.
• Collaborated with client(s) to define High-Level Project Scope
• Created project plan(s) and helped defined external (consulting) and internal (client) resource needs for implementation team
• Identified dedicated Super User for project to ensure successful knowledge transfer
• Gathered Business Requirements by conducting and documenting Current State Analysis and Future State Analysis (includes Map & Gap Analysis and Functional Design Documentation)
• Created Test Plan and coordinated unit testing, integration testing, user acceptance testing and signoffs
• Led End-User Training and Post-Go-Live Support
• Experienced in leading (as lead) and configuring (as Business Analyst) in ALL of the following:
• Oracle 11i HR US and India localizations (11.5.10)
• Defining Key Flexfields (Job, Position, Grade, Costing, People Group, Special Information Types, Extra Information Types)
• Defining Business Groups (US with International Employees)
• Defining Workstructures within Business Groups (Organizations, Jobs, Positions, Locations)
• Defining Address Types (US and International)
• Defining Person Types (US Employees, and International)
• Defining the setups for interfacing with Financials
• Implemented Core HR Contingent Worker functionality
• Implemented Manager Self Service and Employee Self Service
• Designed and developed invoices interfaces for AP and AR.
• HRMS Suite upgrade(s) from 11.5.8, 11.5.9 to 11.5.10
• Provided post go live Support of HRMS, Payroll, OAB, AR, AP, GL.
• Experience assisting in Oracle Advanced Benefits - Open Enrollment and Oracle Payroll - Retro-Pay Processing.
• Collaborated with client and conducted US and International customer needs analysis to define HRMS Global Implementation Strategy
• Worked on integration point with Oracle Financials (AR/GL/PO)
• Worked as team member for OTL implementation.
• Worked on payroll interfaces for India Localization with Hewitt.

Position: Lead Business Process Analyst

The company is one of the biggest players in PEO industry outsourcing Human Resource services and payroll processing. Over the years the company has evolved a complex Oracle HRMS and Payroll system to satisfy various client needs. The company processed about 60,000 payrolls per week.

Synopsis of some of the major projects implemented at the current position

Custom W2 solution

• Architected and designed custom W2 solution for 300,000 employee per year.
• Gathered Business Requirements by conducting and documenting Current State Analysis and Future State Analysis (includes Map & Gap Analysis and Functional Design Documentation)
• Setup Descriptive flexfields required for the process
• Created Test Plan and coordinated unit testing, integration testing, user acceptance testing and signoffs

Lead the project to provide web-based Payroll reports. This project was initiated to enable the clients to view the reports as soon as payroll was run.

• Provided the solution architecture for the project.
• Gathered requirements and designed setups
• This process would handle multiple Business Groups.
• Setup Flexfields and EITs for driving the process.
• Designed the XML generation using XQuery from the datamart, which was rendered on the web using combination of XSL and HTML
• Researched for innovative techniques to increase the performance of the process.
• Managed and confered with team members to deliver the project on schedule.
• Developed and managed HRMS RICE list.

Two Full cycle implementation of R11i HR/Payroll.

• Implemented Oracle 11i HR 11.5.4 w/ Basic Benefits Functionality and 11.5.9 with OAB
• Defining Key Flexfields (Job, Position, Grade, Costing, People Group, Special Information Types, Extra Information Types
• Defining Key Flexfields (Job, Position, Grade, Costing, People Group, Special Information Types, Extra Information Types)
• Defining Business Groups (US with International Employees)
• Defining Workstructures within Business Groups (Organizations, Jobs, Positions, Locations)
• Defining Address Types (US and International)
• Defining Person Types (US Employees, and International)
• Worked on Irecruitment setup/implementation.
• Managed and implemented an After hour support system to resolve issues during payroll processing and based on these issues take proactive steps to modify code or processes to minimize potential Bugs/issues.
• Designed and architected a system to automate payroll processing in Oracle HR/Payroll, starting from Payroll posting Interface to generating the reports
• Created a set of multithreaded concurrent programs using PL/SQL packages that executed in background.
• Setup Flexfields to control the processing based on clients requirement.
• A master concurrent program controlled the submission of core Run, Prepay, Costing, Check writer process and handle the returns, updating tables to maintain status and logging at each step, as part of error handling.
• Another master process handled submission of reports and printing them and also posting them online.
• CRM APIs and functionality to create task and interactions as part of notification for error handling
• interface programs to interface with AR for invoicing and billing

Position: Technical Consultant

• Designing the Forms and Reports using Forms 6.0, Reports 6.0, to execute them effectively on Web
• Designed and created interfaces for Customer Receipts from custom application
• Writing Packages using PL/SQL to move processing on the server for optimum use of the Web environment
• Writing HTML scripts for menus to drive the forms/Reports
• Interacting with DBAs to optimize the performance for the Forms and Reports

Client: Confidential, Brockton, MA, 05/1998 - 08/1999
Position: Consultant

• Written Packages in PL/SQL to incorporate business logic.
• Written Database triggers using PL/SQL to perform certain auditing functions
• Written shell scripts for processes to interact other systems.
• Developed complex multi form screens in Forms 5.0.
• Written interfaces using Sql*Loader to load data from non-Oracle systems
• Involved in performance fine tuning of the process and application to decrease response time by query (code) optimization and indexes. It was done by using explain plan and Tkprof utilities.

Client: Confidential, Indore, India 05/1997 - 02/1998

• Designed GUI forms keeping in view the existing forms using Forms 5.0
• Written packages using PL/SQL to remove redundant coding in existing forms.
• Written database triggers to enhance auditing
• Designed and developed reports using Reports 3.0
• Developed on line queries to replace some existing Pro*C scripts
• Tuned long running reports and querries
• Written shell scripts to transfer data from stores to corporate

Position: Sr. Software Engineer

• Designed and developed systems for Payroll in Oracle
• Designed MRP system and WIP system for the plant
• Developed custom reports using PRO*C
• Designed and developed online query forms for top management which provide daily production and inventory status