We provide IT Staff Augmentation Services!

Oracle Hrms/payroll Team Lead Resume

New Orleans, La

SUMMARY: An experienced Oracle HRMS/PAYROLL Team Lead. Experienced in all phases of project implementation. Implemented or upgraded Oracle HR/Payroll at 9 clients. Familiar with the functional, technical and business requirements of Human Resources and Payroll Departments. Familiar with Oracle Time Entry / Labor Distribution (OTL), Advanced Benefits, GL, OTL and SSHR modules. Managed the activities of other professionals. Over 15 years of experience, includes the management of analysis, design, development and implementation of application software using today's methodologies (AIM). Extensive experience with many types of applications both purchased and developed. excellent verbal and written communication skills.

  • Functional Oracle Payroll: 7 years
  • Functional Oracle Hrms: 7 years
  • OTL : 5 years
  • Standard Benefits : 5 years
  • Advanced Benefits : Training
  • SSHR : 3 years
  • Fast formulas : 5 years
  • Oracle :10 years
  • Year Ends : 8
  • Open Enrollments :5
  • AIM Methodology :5 years
  • Mercury automated testing :2 years

EXPERIENCE:

Confidential April 1, 2009 - present Team Lead for implementation of OTL release 12. utilizing Aim Br100, Md050s. The implementation involved several unions.

Confidential- New Orleans La. Aug 2008 - April 2009 Senior HR/Payroll Oracle Support

  • HR/PAYROLL Production Support.
  • OTL implementation and production support.
  • Self Service Production Support
  • Trouble shooting production issues
  • Fast formulas 401k, PTO
  • Training documentation
  • Data Loader
  • Year End Prep
  • Year End Process
  • SQWLS
  • Patch Testing
  • Created several plsql reports and registered them to the application And created the output as delimitated files which are available from the Application in the output queue.

Confidential - Houston, Texas. May 2008 - Aug 2008 Senior HR/Payroll Oracle Support

  • HR/PAYROLL Production Support (release 12i)
  • Us and Canadian payrolls
  • OTL Production Support
  • Self Service Production Support
  • Wrote numerous reports
  • Trouble shooting production issues

Confidential - Coral Gables , Florida APR 2005 - May 2008 Senior HR/Payroll Oracle Support

  • HR/PAYROLL Production Support.
  • US and Canadian payroll
  • Developed test script for HR/Payroll and Finance modules Using Mercury.
  • OTL Implementation and Production Support
  • Self Service Production Support
  • Trouble shooting production issues
  • Fast formulas 401k, PTO
  • Training documentation
  • Data Loader
  • Standard Benefits
  • Year End Prep
  • Year End Process - produce W2s
  • SQWLS
  • Patch Testing
  • PTO plan setup and maintain
  • PTO carryover
  • Family Pack planning and testing
  • Open Enrollment
  • Created several plsql reports and registered them to the application And created the output as delimitated files which are available from the Application in the output queue.
  • Developed Noetix/Discoverer Queries /Reports .
  • Developed and supported several interfaces examples: Benergy, Aflac, Positive Pay, Concur)

Confidential Feb 2005 - APR 2005 Assistant Project Manager

  • . Assisted project manager with updating the project plan for the conversion of GoldenGate Hr to Oracle HRMS 11i.
  • Assisted in the "Health Check" of the Brunswick conversion project from GoldenGate to the Oracle Corporate HR Enterprise.
  • Assisted in the development of a project Charter document for the migration of Brunswick Mercury Marine to the Brunswick Corporate Enterprise.
  • Assisted in the development of a Training strategy document with course outline for the Oracle HRMS system..

Confidential June 2003 - Feb 2005 HR and Payroll Functional Team Lead

  • Post Production Support. Weekly payroll for approximately 18,000 employees
  • Trouble shooting production issues
  • Fast formulas 401k, PTO
  • Training documentation
  • Data Loader
  • Standard Benefits
  • Year End Prep
  • Year End Process - produce W2s
  • SQWLS
  • Patch Testing
  • Kronos Time Entry - Upload to HRMS
  • PTO plan setup and maintain
  • PTO carryover
  • Family Pack planning and testing
  • Open Enrollment
  • SSHR - for Executives
  • Created several plsql reports and registered them to the application And created the output as delimitated files available from the application In the output queue.
  • Developed methodology to take Noetix/Discoverer Queries And create oracle report 6I which is registered to the application. reports then can be run from oracle HRMS/payroll as concurrent Job utilizing the application security.
  • Review interfaces for extraction criteria and make recommendations

Confidential, December 02 - February 03 HR and Payroll Functional Team Lead

  • Year end processing, PTO carryover and salary Corrections.
  • Tax balance adjustments (element set up )
  • Set up New PTO Elements and link
  • PTO fast formulas - customize
  • Developed a PTO Accrual Report
  • Uploading of (Time) OTL batches via BEE
  • Labor Distribution (OTL)
  • Managed one consultant
  • Developed and implemented test plans and scripts
  • Worked closely with users from hr and payroll to ensure business requirements were met.

Confidential, July 02 - December 02< HR and Payroll Functional Team Lead

  • Conversion of the HR/Payroll data from release 10.7 to 11.5.5.
  • Supervised two consultants
  • Assisted in the development of the overall project plan.
  • Worked closely with users from hr/payroll to ensure business
  • Requirements were met.
  • Developed and implemented test plans and scripts.
  • Monitored team progress against the project plan.
  • Worked with Oracle Time Entry ( OTL ).
  • Worked on Labor Distribution (OTL)
  • Co-coordinating the conversion of 10.7 OTL batches to 11i OTL batches
  • Designed/coded/tested and implemented the conversion scripts
  • Written in PLSQL Utilizing Oracle's API's to unload data from 10.7 .
  • and load data into 11i.

Confidential, April 02 - July 02 Functional HR Benefits Team Lead

  • Investigated and resolved major payroll issues, created and monitored TARS or developed work-arounds to issues that could not be resolved quickly.
  • Responsible for the hr 11i implementation and set up of the oracle standard benefits.
  • Set up and link of Benefit elements.
  • Assisted in the development of the overall project plan.
  • Monitored team progress against the project plan
  • Created user documentation on how to enter and maintain benefit plans.
  • Worked closely with users from hr and payroll to ensure business requirements were met.
  • Managed two consultants.
  • Developed and implemented test plans and scripts
  • Trained users and consultants.
  • Oracle Application HR/Payroll Release 11i.

Confidential, July 01 - April 02 HR and Payroll Functional Team Lead

  • Assisted in the project planning, writing of functional and technical specifications for the Upgrade from 10.7 to 11i.
  • Investigated and resolved major payroll issues, created and monitored TARS or developed work-arounds to issues that could not be resolved quickly. Changed setup, it that is what caused the employee to "error".
  • Assisted Payroll group with implementing payrolls for 25,000+ employees
  • Responsible for fixing several benefit fast formulas that were not calculating correctly, created several fast formula skip rules.
  • Assisted in the year end processes.
  • Produced functional documentation for the top five data issues to be implemented via custom library edits.
  • Wrote scripts to identify invalid data from 10.7 version, that will be corrected before upgrading to 11i.
  • Developed and implemented test plans and scripts
  • Worked with OTL, Oracle Labor distribution modules
  • Monitored team progress against the project plan
  • Setup Payroll group procedures for running Oracle Payroll.
  • Managed two consultants.
  • Open Enrollment
  • Oracle Application HR/Payroll Release 10.7 to 11i upgrade

Confidential, January 01 - July 01 Dallas, Tx office Functional / Technical Team Lead

  • Setup Payroll group procedures for running Oracle Payroll and Quick Pays.
  • Modified Fast Formulas and Formula Results.
  • Assigned to the implementation of Oracle 8I database for HRMS/PAYROLL on UNIX platform.
  • Documented and wrote program specifications for 40 plus interfaces.
  • Performed production support duties included a custom check writer and fast formula and skip rules.
  • Assisted in the development of the overall project plan.
  • Monitored team progress against the project plan
  • Oracle Application HR/Payroll Release 11i New Install

Confidential, August 01 - December 01 SENIOR Oracle DEVELOPER

  • Developed and designed Oracle Reports for HR and Payroll groups.
  • Responsibilities included new Reports, year-end (attended Oracle year-end Class), data clean up and all around HRMS (Benefits /PAYROLL) support.
  • Oracle Application HR/Payroll Release 10.7 NCA
  • Confidential, January 97 - July 01
  • HR and Payroll Functional / Technical Team Lead
  • Participated in Capacity Planning for new Unix Servers and Disk Arrays.
  • Assisted in the development of the overall project plan.
  • Monitored team progress against the project plan
  • Developed and implemented test plans and scripts
  • Interface with clients and support for the application (on-line and batch).
  • Developed many PL/SQL scripts and Oracle Reports to resolve user request.
  • Trained User personnel in the Oracle Application.
  • Open Enrollment
  • Trained “IT" personnel in PL/SQL and the Oracle Application
  • Developed and maintained audit reports to compare similar data in the HR/Payroll system with the legacy system.
  • Two year ends which included making balance adjustments for the taxes , producing the W2's and 1099's
  • Developed and maintained custom application forms and reports.
  • Developed and maintained interfaces to outside systems by building PL/SQL processes and Unix scripts to load data into the system or export flat files and/or reports.
  • Developed and maintained imports into the Oracle system for recurring and non-recurring elements necessary for payroll processing.
  • Ran production payrolls and Quick Pays
  • Developed and maintained exports such as EDI
  • Responsible for the transmission of numerous outbound files to the vendors utilizing FTP, Pro Com, EDI and lotus Notes.
  • Assisted in the project planning, writing of functional and technical specifications for the Upgrade to 10.7.
  • Managed up to six developers.
  • Oracle Application HR/Payroll Release 10.7 Upgrade

SOFTWARE: ORACLE, PL/SQL, ORACLE REPORTS, ORACLE FORMS, UNIX, Oracle (Benefits / Payroll) 12i, Oracle Report Builder 6i, fast formulas, Custom Libraries, SQL LOADER, Oracle procedural Gateway, TOAD, oracle developer 2000,PL/SQL, C, Powerbuilder, Sybase, Windows, lotus notes, ADW, Project Workbench, IBM30xx, OS/MVS, OS utilities, ADSO, COBOL, COBOLII, Culprit, Assembler, PL1,ADF,DB2, IDMS,IMS,QMF,ADS/A, ADSG, ISPF, ISI Payroll, IMS DB/DC, CICS, Data Loader, PL/SQL

TRAINING:

Oracle: Introduction to Oracle for Developers Advanced Oracle for Developers Relational Data Base Design for Oracle Oracle Application HR/Payroll Implementation Oracle Application HR/Payroll Boot Camp Oracle Payroll Technical Foundation, Release 11 Oracle HR Technical Foundation, Release 11 Oracle Advanced Elements and Fast Formulas Oracle Developer 2000 Oracle Reports 6i Oracle Sql Tuning Oracle Year End

EDUCATION: BA Psychology 22 Hours towards Masters in Psychology Diploma in Systems and Computer Programming, Various computer courses

Hire Now