Resume of Oracle HRMS Technical Functional

Title
Oracle HRMS Technical Functional

Primary Skills
Oracle Apps 11i/11.03 (HRMS, payroll, Benefits, SCM, PLM) Oracle AIM

Location
US-CA-San Jose (will consider relocating)

Posted
Feb-12-08


Loc: CA
H1B
C2C

Summary: More than Six (6) years of IT experience as Techno-functional Consultant in Oracle Applications HRMS 11i(5.9,5.7)/11.03/10.7 including Oracle HR, Oracle Advanced Benefits (OAB) and Payroll API's with three (3) full lifecycle in core HR and payroll implementation. Extensive in analysis, design, customization, up gradation, development and implementation of application with strong in data conversion and interface design. Excellent experience in using Oracle AIM, PL/SQL, Toad, SQL Navigator, Jinitiator1.1, Oracle Discoverer Reports, Reports 6i/2.5 and writing stored procedures, database triggers with Oracle 9i/8i/8.0/7.0 as databases under HP-UNIX and Windows NT environment with interface experience in SCM and PLM.

Skills/Tools:

ERP Tool: Oracle Apps 11i/11.03(HRMS, payroll, Benefits, SCM, PLM)
Languages: C, C++, SQL/PLSQL, HTML, ksh/csh
Methodologies: Oracle AIM.
Tools/Utilities: Developer 2000 (Reports 6i/2.5, SQL *Loader, MS Excel, Toad, SQL Navigator. Oracle Enterprise Manager, Discoverer Reports.
Case Tool: Designer 2000
DBMS/RDBMS: ORACLE, Oracle RDB, MS access.
Operating Systems: Sun Solaris 5.6,HP-UX 9.x/10.x, VMS 7.0,DOS, Windows 2000/95/NT

City of Virginia Beach
Interface/Conversion Lead/ Oracle Apps HRMS Techno-Functional Implementation
February 2007 - Till date

· Involved in review of functional requirements and wrote technical design.
· Worked on complex Inbound/outbound interfaces including Reserve Bond Outbound Interface, Occupational Health Member Data and VRS Outbound Interface.
· Involved in all end-end HRMS conversions including Employee, address, assignment, phones, Tax, element entry, contacts, SIT, EIT and advance benefits.
· Performed setup steps, for defining key flex fields and descriptive flex fields. Created various lookups and value sets.
· Created elements, element links, balances and dimensions for various information elements.
· Developed Program to upload initial balances from legacy system using initial Upload Balance program.
· Provided functional support for customizations and conversions to developers
· Clean up data issues for employees whose salary proposals were not loaded with components during their salary changes using API's.
· Designed and developed Federal Reserve Bond interface that extracts selected active employee's bond data semi-monthly from Oracle HRMS and sent to Federal Reserve in Richmond. In form of output file.
· Designed and developed LETS interface that extracts active employee data from Oracle HRMS and sent it in form of output file.
· Designed PSADVANCE interface that extracts selected active and terminated employees data daily Oracle HRMS and sent to PSADVANCE Department of City of Virginia Beach. The information also included net accrual for each accrual plan and employee is enrolled
· Designed Interface, which will send selected employee data to Risk Management for existing employees and to add new employees. For terminated employees only those employees with termination dates within two months of system date.
· Developed Interface for Virginia Retirement System (VRS) and Minnesota Life interface that passes employee demographic information, prior month adjustments, employer retirement contributions, Basic Life Deductions, and Optional Life Deductions amounts to VRS and Minnesota Life. This is a monthly interface that is run for prior month on a monthly basis and will be passed to each vendor.
· Developed Deferred Comp and Active Employee Interface that extracts active employees with a deferred comp deduction. This interface is run bi-weekly or on demand from Oracle HRMS Applications and file is sent to CVB Payroll Department.
· Added plan information such as plan types, options, plans and programs to appropriate compensation object to streamline implementation process in OAB.
· Developed conversion procedure to create and update a Potential Life Event: Historical Enrollment with Status equal to Unprocessed and to create potential life events
· Developed conversion procedure to enroll employees in enrollment plans
· Involved in end-end testing of objects including installation scripts, Download and upload Ldt files.
· Worked on Tools like Toad 7.6, Sql Navigator for designing SQL Statements used as extraction criteria for Interfaces, Explain Plan for performance tuning.

Environment: Oracle Applications HRMS 11.5.9, Oracle Payroll, Benefits, OAB, Developer 6i, PL/SQL, SQL*Loader, Jinitiator1.1.x, Oracle9i, HP-UX 11.0.

Oracle
Technical Lead/Sciquest Integration with Oracle Iprocurement
December 2006 -- February 2007

· Involved in review of functional requirements and wrote technical design
· Involved in development and Unit testing for Puchout cart Return Outbound Interface.
· Involved in doing setup for Punch-out cart return.

Environment: Oracle Iprocurement, Jinitiator1.1.x, Oracle9i, HP-UX 11.0

Oracle
Conversion/Interface lead/ Fidelity EPS
October 2005 -- December 2006

· Involved in design, development and Unit testing of the Conversion from Fidelity 11.0.3 systems to 11.5.10
· Involved in review of functional and design specifications
· Worked on major conversions for fidelity including On hand Quantity, Item conversion, BOM Conversion, Item Attribute Conversion (PLM), item Attachment Conversion, Customer Conversion and Pricing conversion.
· Worked on Datamart Interfaces, which were scheduled to run at a specific interval of time
· Worked on Oracle Periodic Alerts and performance tuning of all conversions using Indexes and portioning.
· Developed BOM Conversion Procedure and Datamart Interfaces to extract data from 11.0.3 to 11.5.9.
· Involved in end-to-end testing till project went to GO Live and developed periodic Oracle Alerts to check if specific User concurrent program has been completed in Normal or warning status.
· Worked on Tools like Toad 7.6, Sql Navigator for designing SQL Statements used as extraction criteria for Interfaces, Explain Plan for performance tuning.
· Involved in end-end testing of objects including installation scripts, Download and upload Ldt files.

Environment: Oracle Applications HRMS 11.5.9, SCM (Inventory, BOM), PL/SQL, SQL*Loader, Oracle Periodic Alerts, Jinitiator1.1.x, Oracle8i, HP-UX 11.0

Oracle
Developer/ HR and PAYROLL Conversion
June 2004- September 2005

· Involved in technical/functional design, development and Unit testing of conversion from legacy systems to Oracle 11i.
· Worked in around three implementation involving Oracle Payroll, HR, Advance benefit implementation.
· Involved in conversions for Payroll Direct Deposit Accounts, Current Salary conversion, employee conversion, pay balance conversion, assignment conversion, element conversion and payroll W4 tax elements using API's.
· Worked on outbound interface, Kronos daily and Kronos Pay Period.
· Worked on fast formula's including Pension EE and ER, Life Insurance ER and Disability Insurance
· Developed Program to upload initial balances from legacy system using initial Upload Balance program.
· Provided functional support for customizations and conversions to developers
· Worked on Oracle Payroll fast Formula needed for calculating and administering Employer Paid Life Insurance for MCO.
· Worked on user hooks for creation of employee Api to provide additional Functionality.
· Involved in end-end testing of objects including installation scripts, Download and upload Ldt files.
· Developed procedure to upload earning elements and deduction elements, update employee's costing information and convert terminated employees
· Created elements, element links, balances and dimensions for various information elements.
· Developed Batch Element Entry Interface Program for loading the employee assignments, element entries.
· Defining the elements, Input Values.
· Worked on Tools like Toad, Sql Navigator for designing SQL Statements used as extraction criteria for Interfaces, Explain Plan for performance tuning.

Environment: Oracle Applications HRMS 11.5.9, Oracle Payroll, Benefits, Developer 6i, PL/SQL, SQL*Loader, Jinitiator1.1.x, Oracle9i, HP-UX 11.0.
Icelerate Technologies Private Limited
Technical Consultant/ Customization of Oracle CRM/ERP Application
June 2003 -- May 2004

Soft customization and implementation of Oracle CRM/ERP Application 11.5.6 including Form customization in CRM includes Oracle Service, Inventory and AR modules and Data conversion (17 No) from legacy systems, Report customization (90 No) for Oracle PO, AP, AR and INV modules, Interfaces (60 No) with other systems, Global role out of this implementation of this implementation in 12 Different countries and 7 different languages.

· Involved in technical design, development and Unit testing of the Outbound Interface (Oracle HRMS to pleides system)
· Involved for defining of person types, employees, assigned employees to assignment and then for Payroll and the elements.
· Defined Location, Organization, Job, Position, Position Hierarchies.
· Worked on the Definition of Elements, Payroll, Consolidation Sets, Assignment Sets, and Element Sets.
· Used Fast Formulas and Defining Processing Rules by assigning Elements to Formulas to be used.
· Involved in running the Payroll (Payroll Run), Quick Pay.
· Involved in enhancement and bug fixing.
· Used AIM methodology for all development.
· Involved in product development of QUICK UPGRADE tool.
· Created knowledge base that will capture differences in tables, Columns, packages and synonyms Changes between different 2 different oracle Applications versions 11.0.3 and 11.5.9.
· Worked on Tools like Toad, Sql Navigator for designing SQL Statements used as extraction criteria for Interfaces, Explain Plan for performance tuning.

Environment: Oracle Applications Inventory, BOM, HRMS 11.5.9, Oracle Payroll, Benefits, Developer 6i, PL/SQL, SQL*Loader, Jinitiator1.1.x, Oracle9i, HP-UX 11.0.

Winsome Private Limited
Developer/ Customization of the Winsome Human Resources and Payroll system
January 2002- May 2003

· Involved in the development of their Human Resources and Payroll System.
· Involves Implementation of their existing Payroll and HR that was into Old Legacy System (FoxPro) into A new Faster and more reliable System Using Oracle 8i and Oracle Developer.
· Involved in coding, testing and reviewing the application.
· Wrote procedures, functions, and triggers using PL/SQL
· Involved in Testing of Reports and Forms, validating against Database and checked for the desired requirements specifications.

Environment: Oracle Applications Core HR, Payroll 11.0.3,PL/SQL, SQL*Loader, Jinitiator1.1.x, Oracle9i, HP-UX 11.0.

Education: M.S. in Computer Applications.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-CA-San Jose »
View all resumes in US-CA »

View other Oracle HRMS Technical Functional resumes