SUMMARY:

• Over 9 years of professional experience in Oracle, in all phases of software life cycle with expertise in Oracle Applications 11.0.3, 11i, R12 HR, Benefits, iRecruitment, Performance Management, Compensation Workbench, OTL, AME, Workflow, ESS, MSS and Self Service Benefits modules. This includes the full lifecycle of Requirement Analysis, Design, Development, Implementation and Testing.
• Responsibilities include designing, coding and testing of interfaces & Data Conversion scripts, Payroll and Benefits Fast Formulas, Documentation using Oracle AIM, Reports & Forms Creation and Customization, OAF, Data Porting using Open & Closed Interfaces for Commercial Applications and Customization Upgrades from 10.7 to 11 and 11i to 11.5.10. Have strong technical exposure on Developer 2000 - Forms 6i, Reports 6i, 3.0 and has worked extensively on Oracle releases up to 10g.
• As a dynamic Oracle HRMS Consultant, I am capable of analyzing business requirements and developing innovative solutions to optimize business processes and productivity. Also I have a proven track record of success in implementing Oracle technical solutions for businesses in a cross section of industries.

TECHNICAL SKILLS:

Oracle Apps 10.7,11.0.3,11i,R12: Oracle Human Resources, Payroll, Benefits, iRecruitment, OTL, Performance Management, Compensation Workbench, AME, SSHR.

Oracle Technical: Data Conversions, Forms, Reports, Interfaces, Extracts, PL/SQL, XML Publisher, HRMS API CallsSelf service and workflow personalization and customizations, OAF, JSP.

Environment: UNIX, Windows 95/98, 2000, NT, Oracle 8.x, Oracle 9i

Tools: Sql Plus, Toad, Sql Loader, Developer 2000/6i,kintana

Methods: Oracle AIM for Documentation and Test Scripts preparation.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst /Techno- Functional- HRMS

• Worked on automation of several HR processes and enhancements to MSS and ESS.
• Write upload programs for job, organizations, assignments, Salary etc.
• Work on oracle to ADP Payroll, Benefits (Oracle to Workterra), Oracle to Concur (Travel Portal), Oracle to Fidelity (401K) Integrations.
• Work on Kenexa 2XB and 2XR to Oracle Integration Project.
• Implement Oracle Employee Self Service.
• Working on Compensation workbench plans.
• Currently working on Oracle 11i to Fusion HCM migration.

Confidential

Sr. HRMS Business Analyst

• Work on ongoing maintenance for Oracle Core HR, Manager Self Service, Employee Self Service and interfaces to vendors like Workscape, Taleo, and Saba etc.
• Write Design documents for quarterly releases
• Personalized Self-service forms in SSHR.
• Work on year end Benefit open enrollment.
• Work on Compensation oracle compensation Workbench plans like commissions. Bonus, Promotions etc.
• Create BO reports to meet the business needs.

Confidential

Business Systems Analyst

• Worked on the Interfaces to ADP e-TIME.
• Responsible for on-going maintenance, support of HRMS Modules.
• Developed generic programs to mass update HR Data. The program will update existing employee assignment information, payroll information, SITs, etc
• Developed few Pl/sql scripts and modified custom forms, reports and workflow.
• Analyzed iRecruitment module for implementation.
• Worked on Training Manual for Managers and HR. Wrote MD50 from SSHR- MSS AME
• Conducted UAT sessions for SSHR and managed test results.
• Worked on the interfaces from Oracle to Project Costing.

Confidential

HRMS Business Analyst

• Develop functional documents.
• Modify and fully test all modules they have selected to use.
• Develop custom test scripts and perform all system testing and quality assurance.
• Responsible for on-going maintenance, support of HRMS Modules.
• Support Custom tools like ePAN and Vacation tool.
• Work on Interfaces to Third party Recruiting Portals like Virtual Edge.
• Worked on a creating a sandbox for performance management
• Personalized Self-service forms in SSHR.
• Worked on the Interfaces to ADP e-TIME.

Confidential

HRMS Business Analyst

• Supporting a continuing implementation of Oracle Release 12 HRMS and Oracle Time and Labor (OTL)
• Develop generic programs to mass update HR Data.
• Implemented SSHR - Manager Self Service using AME
• CRP/UAT sessions for HR/SSHR.
• Setup a new localization.
• Worked on the outbound interface to feed ADP from Oracle and an inbound interface from jobvite to feed oracle.
• Implemented ESS.
• Create discoverer reports to meet the business needs.

Confidential, Sunnyvale, CA

HRMS Techno-Functional Consultant

• Responsible for on-going maintenance, support of HRMS Modules.
• Developed generic programs to mass update HR Data. The program will update existing employee assignment information, payroll information, SITs, etc
• Implemented SSHR - Manager Self Service using AME
• Personalized Self-service forms in SSHR.
• Worked on alerts, notifications to support SSHR process.
• Worked on Training Manual for Managers and HR. Wrote MD50 from SSHR- MSS AME
• Conducted UAT sessions for SSHR and managed test results.
• Participated in Purchasing AME implementation
• Developed few pl/sql scripts and modified custom forms, reports and workflow.
• Analyzed iRecruitment module for implementation.

Confidential, Redwood City, CA

Oracle HRMS Consultant

• Performed data mapping from legacy ADP system.
• Configured OAB to satisfy enrollment requirements.
• Developed test procedures reviewed implementation setups, system testing and transition to production environment.
• Worked on OAB Benefits Programs, Life Event Processing and Plan Enrollments Conversions
• Worked on the design documents for two outbound extracts, one sends the data from Oracle to a third party Benefits Provider, Proview and the other to ADP Payroll Vendor.
• Prepared the Map-Gap Analysis and Functional Documents for those two extracts.
• Testing those interfaces, developed by the technical team.
• Implementing Self Service HR and Manager Self Service.
• Ran CRP/UAT sessions for HR/OAB/SSHR.
• Worked on various alerts for both HR and Financials.
• Designed and Developed several Fast Formulas in OAB.
• Worked on setting up compensation workbench plans
• Created new Discoverer and XML Publisher reports based on the business requirements

Environment: Oracle Application R12 Human Resources, Oracle Advanced Benefits (OAB), Performance Management, Oracle RDBMS, Discoverer, UNIX, SQL*Loader and XML Publisher

Confidential, Redwood City, CA

Oracle HRMS Consultant

• Involved in updating all the MD50s and MD70s up to date in sync with the actual program, as they were not modified by the production support team, while resolving the tickets.
• Involved in defining the structure of Business groups, Locations, Jobs, Grades, People groups, SITs, EITs, Salary bases, Payrolls, etc..
• Worked on the design documents for Oracle HR and Payroll interface CRs, includes preparing the BR100, Map-Gap Analysis, Functional Documents, Technical Documents.
• Incorporated a new benefit, HealthCare FSA. This involves setting up the element and links, implementing the logic to receive FSA enrollment information from the vendor, and also to add the FSA enrollment to the output file that goes to the third party benefit provider.
• Worked on personalization and customizations of HR and Benefits Employee self service pages, viz…Benefits Enrollments, personal Information, Additional Assignment information etc.
• Support includes development of reports using Oracle tools, continued support to payroll processes and on going testing of system functionality. Various ad-hoc SQL queries and PL/SQL Procedures to extract data from the Database. The file is later converted to CSV file and the data is loaded into oracle.
• Work closely with HRIS and Data Management on a weekly basis, discuss with them on the issues, prioritize and work with HRIT in solving the issues based on the priority and keep the tickets count low.
• Created new Discoverer Report based on the business requirements.
• Create Interfaces, Extracts, Reports, and Alerts.
• Managed oracle TARS.

Environment: Oracle Application 11.5.10 (Family Pack-K) Human Resources, OAB, Oracle RDBMS, Discoverer, Developer 2000 (Forms 6i and Reports 6i), UNIX, and Sql*Loader.

Confidential, Las Vegas, NV

Oracle HRMS Consultant

• Involved in defining the structure of Business groups, Locations, Jobs, Grades, People groups, SITs, EITs, Salary bases, Payrolls, etc..
• Created the Job, Grade, SIT, People groups, etc... Key flex fields.
• Created the Person EIT, Establishments, etc… Descriptive flex fields.
• Prepared the Map-Gap Analysis and Functional Documents for those two extracts.
• Testing those interfaces, developed by the technical team.
• Implementing Self Service HR and Manager Self Service
• Designed and developed a CIGNA, Kaiser, MetLife, VSP, Vanguard 401K, CMS COBRA outbound interfaces (Benefits) which write the participants and dependents information to a flat file to feed to the respective Vendors.
• Configured OTL to meet business requirements
• Developing the CRP scripts to conduct CRP with the HR team (users).
• Designed various Supervisor Hierarchy reports for the business, viz. Supervisor Hierarchy All Employees report as of run date, Active Employees as of a specific date, All transactions occurred (Movement) for a supervisor in a specific date range, etc….
• Designed Security profiles based on the locations and streamlined the process access rights across the organization.
• Developed of reports using Oracle tools, continued support to payroll processes and on going testing of system functionality.

Environment: Oracle Application 11.5.10 (Family Pack-K) Human Resources, Oracle Payroll, OAB, iRecruitment, iProcurement, GL, Purchasing, Oracle RDBMS, Discoverer, Developer 2000 (Forms 6i and Reports 6i), UNIX, and Sql*Loader, Kintana.