SUMMARY:

• Total 17 years of IT experience in analyzing, designing, developing, testing, implementing software applications and Oracle E - Business Suite (Oracle EBS R12)
• Over 10 years of strong experience in Implementation, Customizations and Support of Oracle Applications 11i and R12
• Worked as Techno-Functional Engineer (70%-Functional & 30%-Technical) on Oracle E-Business suite (R12/11i HRMS).
• Involved in 5 End to End implementations and 4 Support Projects of Oracle E-Business suite (R12 HRMS modules)
• Strong experience in HRMS modules of Core HR, Payroll, SSHR and iRecruitment
• Good domain expertise on Oracle Time and Labor R12 (OTL),Oracle Learning Management(OLM) and Oracle Advanced Benefit(OAB) modules.
• Successfully Implemented Core HR, Oracle Payroll and Oracle Self Service(SSHR) modules for US, Middle East and India legislation.
• Worked on Business requirement gathering, Conference Room Pilot(CRP) and User Acceptance Testing(UAT) phases.
• Prepared BR100/MD050/MD070/BR040 documents using Oracle AIM standards for Core HR, Payroll, SSHR and iRecruitment modules.
• Hands on Experience with Oracle EBS offshore-onsite Model.
• Handled product demonstration and user training on Oracle E-Business suite R12 HRMS modules.
• Worked on R12 upgradation Project (12.0.5 to 12.1.3)
• Good technical background with excellent interpersonal skills.
• Developed AME(Approval Management Engine) rules for handling approval absence rule hierarchy.
• Worked on salary, jobs, grades and organization updates using Data loader & Web ADI utility.
• Expertise in writing and modification of Fast formulas used in Oracle Payroll and Absence Management.
• Involved in the Data migration of Core HR and Payroll & Absence Management using Standard Oracle APIs.
• Developed and customized HR and Payroll Reports in Oracle Discoverer report, Oracle Developer report and XML publisher tools.
• Worked on Form and Web page personalization for label changes & validation in Self Service Module.

TECHNICAL SKILLS:

RDBMS: Oracle 10g

Operating Systems: Linux, Windows 2000/2003/XP/ 7,8 &10

Languages: SQL, PL/SQL

Tools: Web ADI, Data Loader,SQL developer,Oracle Discoverer Report,Report Builder and XML Publisher.

ERP Systems: Oracle Applications 11i/R12.1.3 and R12.2.5

PROFESSIONAL EXPERIENCE:

Confidential, Seattle

Senior Oracle HRMS Lead

Responsibilities:

• Modified Oracle Advanced Benefits Payroll Fast Formula as per the requirement
• Developed the GL Interface(GLIN2) Inbound Programs as per the business requirement by using PL/SQL Code.
• Developed HR and Payroll Reports in Oracle Discoverer Tool.
• Resolved the Production Support Issues Specifically Related to Enhanced Retro Pay and Payroll Calculation
• Developed Custom Functions and Formula Functions for Oracle Advanced Benefits.
• Interaction with client/end users & updating the change request / task.status
• Developed Configuration Document on customization and interfaces programs.
• Involved in the basic testing of Payroll fast formula with test case scenarios.

Confidential, IL

Senior Oracle HRMS Lead

Responsibilities:

• Setup People Management, Work structures and Absence Management
• Configured Oracle EBS Payroll - Payment Methods, Consolidation Sets, Payrolls, Salary Basis, Elements, Element Links, Retro Pay, BEE, Absence Management and PTO Accrual Plans, Values sets, Employer and Employee Tax Rules, Assignment Sets, Fast formulas, Balances, Dimensions, User Functions, Global Values, Responsibilities, Request groups, Users.
• Configuring the work structures and organization hierarchy.
• Involved in creation of New Users/New Hires/New Responsibilities/Adding Responsibilities to Users.
• Involved in the Setup of OTL - defining recurring periods, Alternate names, Flex field Mapping, element sets, Approval periods, Approval rules, Preferences, Eligibility criteria, Timecard Layouts, Time Entry rules and transferring timecards from OTL self service to BEE.
• Configured and implemented iRecruitment setup steps-system profiles, recruiting sites, Creation of Vacancies, Vacancy approvals, Job Seekers, Site visitors, job Search and candidate processing.
• Prepared BR100/MD050/MD070 documents
• Created OAB- Life Events, Benefit Group, Derived Factors, Eligibility Profiles, Programs, Plan types, Plans and Options, Enrollment Requirements and standard rates
• Created element types and element links for Benefit Plan elements.
• Handled tickets and application support to the end-users. When an issue is received, it needs to be analyzed and resolved.
• In case, if the issue requires the support of development, then transfer the issue to development team with the inputs. Monitor and help development team to complete the task.
• In case, if the issue requires support from Oracle, then raise SR and co-ordinate with oracle support team till closure.
• Interaction with client/end users & updating the issue status.
• Training the end users and preparing end user training material.
• Developed the Interface Programs like Inbound Interface and Outbound Interface as per the business requirement by using PL/SQL Code.
• Developed HR and Payroll Reports.
• Developed program for Mass Upload of Salary, Bonus, Organization data.

Confidential, GA

Senior Oracle HRMS Lead

Responsibilities:

• Successfully led the implementation of Core HR and Payroll modules for US and other legislative countries. Followed AIM Methodology during the implementation.
• Setup People Management, Work structures and Absence Management for US legislation.
• Created Business Groups, Organizations, DFFs, KFFs, Extra Information Types, and Special Information Types
• Set up Payroll, Payment Methods, Event Groups, Elements with Earnings, Information, and Deduction classifications, Element Links, Element Entries, Element Set, Assignment Sets, Consolidation Sets, Retro Pay, Proration, Balance Adjustments, Batch Element, Costing, Payroll User Tables
• Set up of Absences and PTO Accruals elements.
• Security setups including organization Hierarchy, Menus, Nodes, Task flows, Responsibilities, Request Groups, Custom security Profiles.
• Setup Time Card layout design, Preferences, Time-card Approval and Time Entry rules, Payroll and OTL integration responsibilities and security profiles.
• Configured and implemented iRecruitment setup steps-system profiles, recruiting sites, Creation of Vacancies, Vacancy approvals, Job Seekers, Site visitors, job Search and candidate processing.
• Configured Self Service HR Personalized Employee and Manager web pages.
• Setup additional flex fields to capture client specific information using self service web pages.
• Defined Life Events, Derived Factors, Eligibility Profiles, Programs, Plan types, Plans and Options, Enrollment Requirements and standard rates in Oracle Advance benefits.
• Defined Catalog, Courses, Offerings, Delivery Modes and Classes in Oracle Learning Management.
• Worked on Catalog security and managing enrollments in Oracle Learning Management.
• Interacted with End users to understand the change requests in the system
• Developed a script to upload the absence management closing balances.
• Written Oracle fast formula for prorated calculation for new joiners, resignation and retirement employees.
• Developed a script to upload the monthly salary data in payroll using standard API
• Developed various HR and Payroll Reports in Oracle discoverer tool.
• Written a script to upload Payroll salary data through data loader utility
• Developed PL/SQL script to migrate HR and Payroll data in ERP.
• Developed adhoc reports for HR, Payroll and absence management modules.

Confidential, CA

Oracle HRMS Engineer

Responsibilities:

• Setting up HRMS work structures(setup of Key Flex fields, Descriptive Flex Fields, Setting up Business group, Special Information types)
• Setting up business groups, locations and organizations, jobs
• Setting up People Assignment likes defining Person types, assignment status, and Personal Analysis Key Flex field.
• Setting up Workers compensation
• Set up of PTO sick and vacation plans and its per-requisite set up of information elements and absence types.
• Set up Grade step progression plans along with their required derived factors, eligibility profiles
• Defining earnings and deduction elements.
• Defining Element classification.
• Defining links, salary basis elements.
• Setting up employer and employee tax information.
• Creating Payment Methods and payroll.
• Wage attachments.
• Payroll, pre-payment, NACHA, deposit advice, check writer processes.
• Costing processes.
• Retry, rollback and reversal of payrolls.
• Worked on lots of new plan setups, Designing and Developing special Fast Formula rules for Domestic partners/Common Law spouses - Certifications etc.
• Worked on custom Benefit Confirmations with Statement of Health attachments.
• New Plan Setups, Rate Conversions, Plan Conversions and 401K Enrollments for the new plan years.
• Setting up of Manage Self Service, Work-flow Approval and AME Approval setups.
• Custom ABBR Process to calculate and insert record in People SIT.
• Worked on Salary updates using Salary API.

Confidential, CA

Oracle HRMS Engineer

Responsibilities:

• Developed Functional specification for application implementations, enhancements, modifications, extensions, reports, data conversion and post-conversion verification routines.
• Configured Oracle EBS-HR/Payroll. Set up Key and Descriptive flex fields, Organizations (Business Groups, GRE, HR etc), Locations, Payment Methods, Consolidation Sets, Payrolls, Salary Basis, Elements, Element Links, Retro Pay, BEE, Absence Management and PTO Accrual Plans, Values sets, Employer and Employee Tax Rules, Assignment Sets, Fast formulas, Balances, Dimensions, User Functions, Global Values, Responsibilities, Request groups, Users etc.
• Following are activities that I have assisted the client: Payroll Pre-processing, Payroll Processing, Pre-payments, Process Payroll Using subsets (Assignment set, Consolidation set, Element set), Payroll Post processing, Running Year End Process, Federal/State W2, NACHA, Deposit Advices, Direct Deposit etc, Adjust Balances, Processing Quick pay, Rollbacks, Retries, Reversals, Run various reports, Creation of elements, Retro pay Process, Setup 401(k) plans etc.
• Wrote fast formulas and functions for various elements.
• Created and implemented various test plans. Conducted Functional, Technical and User Acceptance Testing. Assisted the Business Users to execute the Test cases and to verify the test results.
• Reviewed Technical and Migration documents for Conversions, Interfaces and Extensions.
• Assisted the Technical team for conversion of Employees, Address, Assignments, Element Entries, Taxes, SIT, EIT and Balances for US and Canada.

Confidential

Software Engineer

Responsibilities:

• Worked with client business managers and process owners in performing application and reporting gap analysis
• Involved in complete functional setups for the HR and Payroll module.
• Assisted the technical team in understanding the functionality and building the required set up.
• Prepared set up docs Documents.

Confidential

Software Engineer

Responsibilities:

• As a team member involved in setting up HR and Payroll from the application setup document
• Prepared document for Solution Design, CRP and End Users
• Participated in the client workshops and meetings to decide on the Earning elements and deduction elements as well as the gap analysis
• Worked on the solving issues with Oracle Payroll after the Production go-live.
• Involved with HRMS system administration tasks like Defining responsibilities & application users, Restricting access to records, Running security processes and Setting user profile options.

Confidential

Software Engineer

Responsibilities:

• Involved in understanding, mapping and documenting the functional needs of the customer.
• As a team member involved in configuration and setting up of Payroll & Recruitment from the application setup document.
• Assisted users with their conference room pilot test cases.
• Supported the payroll processes after go-live.

Confidential

Software Engineer

Responsibilities:

• Installation, Implementation and troubleshooting of HR and Payroll ERP software.
• Handling client issues relating to ERP software.
• In corporate the changes to the system as per client's requirements