EXPERIENCE SUMMARY:

Oracle Fusion Payroll release 11 and 12 and E - Business Suite (EBS) R12 Human Capital Management (HRMS) Certified professional, having +20 years of experience in Information Technology, of which +16 years’ relevant experience in implementing and supporting Oracle payroll.

PROFESSIONAL EXPERIENCE:

Implementation specialist

Confidential, Dallas, Texas

Responsibilities:

• Requirements gathering
• Element configuration
• Developing 401k Fast Formulas
• Running payrolls and quick pays
• Running of reports
• Working service request with Oracle
• Developed test scripts for users
• Training users on fast formulas
• Training technical users on the table structured and Oracle SQL

Confidential, CA

Responsibilities:

• Requirements gathering
• Payroll configuration
• Element configuration
• Running payrolls and quick pays
• Data Validation
• Running of reports
• Working service request with Oracle
• Developed test scripts for users
• Training users on OTL / Payroll

Confidential, Houston, TX

Functional support consultant

Responsibilities:

• Confidential /PAYROLL Production Support (40,000 plus employees worldwide)
• Held classes for IT personnel and end user
• Responsible for troubleshooting production issues
• Developed and modified several fast formulas
• Training documentation for Confidential and payroll user functions.
• Completed Year End Payroll process for US, Canada and Mexico
• Responsible for patch testing
• Created several PL/SQL reports

Consulting

Confidential, Boston, MA

Responsibilities:

• Setup and testing Confidential
• Worked with users on accepting testing and documentation

Confidential, Houston, TX

Functional support consultant

Responsibilities:

• Confidential /PAYROLL Production Support (5,000 employees)
• Held classes for IT personnel and end users
• Self Service Production Support
• Responsible for troubleshooting production issues
• Developed Fast formulas for 401k, PTO, OTL modifications
• Training documentation for Confidential and payroll user functions.
• Data Loader for BEE and correction various SITs
• Completed Year End Payroll process
• Responsible for patch testing
• Created several PL/SQL reports
• Worked with the Kronos project leader developing and maintaining the project plan
• Developed test scripts
• Kronos system configuration
• Setup time clocks
• Develop training material
• Write interface from in house users
• Train Timekeepers on the Oil Rigs
• Debug issues as they arise
• Production support,
• Worked with Kronos Support on issues

Confidential, Houston, TX

Functional support consultant Oracle HRMS/Payroll R 12.1.3

Responsibilities:

• Functional support for multiple clients HRMS/Payroll R12.1.3 for year end, upgrade assessments and day to day issues.

Confidential, Orangeburg, South Carolina

Functional support consultant

Responsibilities:

• Functional iRecuritment Set Up
• Competencies
• Skills
• Reports
• Applicant Qualifications
• Personalization
• Added seeded functionality to the mix
• Self Service
• New PTO Plans
• New PTO report
• Payroll post year end support
• Confidential / Benefits support
• Costing Issues
• Labor Distribution enhancements
• Modified numerous plsql procedures
• New Interfaces for various vendors

Confidential, New Hampshire

Functional support consultant

Responsibilities:

• Functional Year End Processing support
• Function report requirements
• Functional setup and testing the Pennsylvania Act 32

Confidential

Project Manager

Responsibilities:

• Created a new business group for Germany
• Managed the conversion and loading over 4500 Employees
• Managed the Employee Self Service implementation for Germany. Functions implemented were: New Hire, Terminations, Confidential Views, Change assignment Status.
• Managed the personalization of self service for Germany. Many fields had to be hidden and drop downs that were not changed by selecting German as the language were manually changed to contain German syntax.
• Used data loader to load various work structures.
• Provided User Training

Confidential, Sacramento, CA

Functional Consultant

Responsibilities:

• Confidential Production Support - includes logging and monitoring SRs with Oracle Support
• Self Service Production Support
• Added new functions to self service including emergency contacts, Confidential views, hire, and termination.
• Created new PTO plans to track bereavement and jury duty
• Responsible for resolving Payroll issues
• Responsible for Year End payroll balance adjustments and processing
• Data Loader - to create BEE batches
• Developed new Reports in PLSQL
• Provided User Training
• Developed testing scripts and procedures

Confidential, Baton Rouge, LA

Senior Functional Consultant

Responsibilities:

• Team Lead for implementation of OTL
• Utilizing AIM BR100, MD050s
• Functional implementation involved several unions and fast formulas modifications
• Multiple work schedules, shifts and special pay.

Confidential, New Orleans, LA

Senior Functional Confidential /Payroll Oracle Consultant

Responsibilities:

• Confidential /PAYROLL Production Support (5,000 employees)
• OTL support
• Held classes for IT personnel and end users
• Self Service Production Support
• Responsible for troubleshooting production issues
• Developed Fast formulas for 401k, PTO, OTL modifications
• Training documentation for Confidential and payroll user functions.
• Data Loader for BEE and correction various SITs
• Completed Year End Payroll process
• Ran SQWL’S
• Responsible for patch testing
• Created several PL/SQL reports

Confidential, Houston, TX

Senior Techno/Functional Confidential /Payroll Oracle

Responsibilities:

• Confidential /PAYROLL Production support
• OTL Production Support
• Self-Service Production Support
• Wrote numerous reports
• DISCO Reports

Confidential, Coral Gables, FL

Senior Confidential /Payroll Oracle Functional Analyst

Responsibilities:

• Functional Confidential /PAYROLL Production Support
• Developer Mercury Test Scripts
• User Training
• Developed test scripts for Confidential /Payroll and Finance modules using Mercury
• Functional OTL Implementation and Production Support
• Self Service Production Support
• Fast formulas modifications for 401k and PTO accrual plans
• Training documentation for Confidential and payroll.
• Trained end users in running payroll.
• Data Loader for various work structures and element entries
• Implemented Standard Benefits
• Year End Process - produce W2s
• Ran SQWL’s
• Responsible for patch testing
• Family Pack planning and testing
• Created several PLSQL reports and registered them to the application.
• Developed Noetix/Discoverer Queries /Reports
• Developed and supported several interfaces examples: Benergy, Aflac, and Concur
• Assisted project manager with updating the project plan for the conversion of Golden Gate Confidential to Oracle HRMS 11i
• Assisted in the development of a Training strategy document with course outline for the Oracle HRMS system.

Confidential, Smithfield, VA

Payroll Functional Team Lead

Responsibilities:

• Post Production Support.
• Supporting weekly payroll for approximately 18,000 employees
• Trouble shooting production issues, logging and monitoring SRs.
• Modified and maintained Fast formulas for 401k, PTO which had several unions
• Training documentation for payroll and human resources.
• Data Loader to load various works structures and element entries.
• Supported Standard Benefits
• Year End Process - produce W2s
• Ran SQWL’S
• Developed and maintained test plans for new oracle patches
• Developed new scripts to upload Kronos Time Entry to HRMS
• Created and maintained new PTO plans
• Ran the PTO carryover process
• Created and maintained testing procedures for family packs from Oracle support.
• Supported Open Enrollment for standard benefits
• Implemented SSHR - for Executives
• Developed methodology to take Noetix/Discoverer Queries
• Review interfaces for extraction criteria and make recommendations

Confidential, Marksville, LA

Payroll Functional Team Lead

Responsibilities:

• Supported Year end processing, PTO carryover and salary Corrections.
• Made Tax balance adjustments required for year end.
• Set up New PTO Elements and link
• Made modifications to the PTO fast formulas including accrual amounts based on hours worked.
• Developed a PTO Accrual Reports in plsql
• Uploading of (Time) OTL batches via BEE
• Developed and implemented test plans and scripts for Confidential and payroll
• Gathered business requirements for Confidential and payroll enhancements
• Worked closely with users from Confidential and payroll to ensure business
• Requirements were met for new enhancements
• Conversion of the Confidential /Payroll data from release 10.7 to 11.5.5. Included people, assignment, address, elements data.
• Developed and implemented test plans and scripts for Confidential and Payroll

Confidential, Santa Ana, CA

Functional Confidential Benefits Team Lead

Responsibilities:

• 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 Confidential and Payroll to ensure business requirements were met
• Developed and implemented test plans and scripts

Confidential, Morgantown, WV

Payroll Functional Team Lead

Responsibilities:

• 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-around for issues that could not be resolved quickly
• 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 Confidential /Payroll Release 10.7 to 11i upgrade

Confidential, Dallas, TX

Functional / Technical Team Lead

Responsibilities:

• 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 Confidential /Payroll Release 11i New Install