Oracle HRMS Consultant

CHARLES J. OBERFRANC JR.

**** *** ******* ****

OSWEGO, IL. 60543

630-***-****(OFFICE)

630-***-**** (MOBILE)

**************@********.***

SUMMARY

• Strong experience specializing in all areas of the Oracle HRMS modules.

• Practice Manager at Xcelicor, a fast growing best of breed consulting services company with 30+ employees. which focused solely on the Oracle HRMS suite of products.

• Contributed to the development of Xcelicor’s human resource standards and procedures.

• Project Manager on a 500k project with 20+ users and 4+ consultants.

• Implemented many successful projects for many diverse companies and cultures.

• Most implementations were of a rapid implementation timeframe 6 to 9 months.

• Supervised staff of 4 senior consultants working throughout the country.

• Presented many papers at various user group meetings, OAUG and NCOAUG.

• Twelve years of experience implementing all aspects of the Oracle HRMS suite of products.

• Successfully implemented projects in HR, Global HR, Payroll, Time and Labor, OSB, Irecruitment, Training Administration, Self Service with Workflow.

• In-depth technology experience – 20+ years implementing/supporting systems for many diverse companies.

EXPERIENCE

Ryan Alex Inc. 2004 to Present

Consultant/President

• Current: Project Lead and Lead Functional Resource for a successful implemention of Compensation Workbench for a Global Manufacturer and Marketer of business machines, records storage solutions and technology accessories.

• Project Manager with the Chicago Transit Authority managing a successful million dollar plus project with a team of three developers and one functional resource to successfully transition their Wage Rate and Wage Progression systems from their Mainframe GEAC system to their Oracle HRMS system

• Develop and debug OAB Fast Formulas and train the client at the Brunswick Corporation.

• Project Lead and Lead Functional Resource for a successful implemention of Career Management for the HR Department of the City of Chicago.

• Project Lead and Lead Functional Resource for a successful Global Oracle HRMS 11.03 upgrade to 11.5.10 at Fellowes, Inc. in Itasca, IL. Redesigned Fellowes HR setups to support the company’s global rollout of Oracle HRMS to Canada and Australia. Successfully implemented from scratch, OSB as well as setup iRrecruitment for a Phase II rollout. Phase I of this implementation was completed in a rapid timeframe, with only 6 months from start to finish. Phase II will include rollout of HR to Europe and HR Daily Business Intelligence and Self Service HR for US, Canada and Australia.

• Provided Strategic Project Implementation Planning for a successful 21,000 employee HR/OAB implementation at the Brunswick Corporation, in Chicago, IL. Led the design and development of the Global HR setup and Web ADI Mass Salary Upload functionality. Guided the client toward using best practices for the Global HR implementation. Created multiple OAB fast formulas from design to go live implementation.

• Lead Payroll Resources in the successful implementation of a 40,000+ person City of Chicago payroll system. Key contributor to the final testing of this City’s Payroll Processes and Procedures. Debugged and wrote many Payroll Fast Formulas as well as other Oracle Payroll functional and technical issues.

Xcelicor 1998 to 2004

Practice Manager and Senior Principal Consultant

• Project Manager on a successful $500,000 dollar project implementing Oracle HR and OAB with ADP connect replacing Peoplesoft HR and Benefits with a global operations review for Readers Digest.

• Global Design Lead on an implementation for the US, UK and Philippines for InfonXX. The UK portion of the project is live while the US phase is next.

• Functional Lead on a global planning project for a rollout to at least 15 countries. Implemented the Philippines into an existing US and Canadian Oracle HR Payroll Implementation for Teletech.

• Project Director on a highly successful 5 month OAB implementation and conversion project in California for Macrich.

• Project Manager on a successful rapid implementation of Oracle HR/Payroll/OAB/SSHR for Southern Union Company. This was a 1.4M project with 35+ client project team members and 6+ functional and technical consultants. The project team successfully consolidated 5 divisions and 7 different hr and payroll systems with this implementation.

• Project Manager and Lead Functional HR Resource on a successful rapid implementation of Oracle HR/Payroll/OAB/SSHR for Troon Golf, a multi-state 3500+ person payroll implementation. Create custom Workflows and Approvals for the SSHR module.

• Supervised/Mentored four experienced consultants

• Participated in annual consultant performance review process for 25+ consultants

• Created custom paid time off solutions, custom workflow notifications and custom HR Self Service solutions in a rapid implementation environment.

• Participated in multiple sales calls with prospective clients.

• Technical Lead on a successful HR Rapid Implementation for Cree, Inc. Created conversion and interface programs for this project. Also created custom development standards for the client.

• Product knowledge expert for City of Chicago IT department during the implementation of Oracle HR/Payroll for the city’s 45,000 employees. Provided technical and functional direction to the City, its sub-contractors and lead implementers.

• Project lead for a multi-phase, multi-country implementation of Oracle HR/Payroll for Delmonte, a 2500 employee company. Trained many of the core system users in different countries. Conducted weekly meetings with the company’s senior level management. Setup and implemented Oracle HR and SSHR with a multi-language setup. Setup and implemented Oracle Training Administration for multiple countries.

• Analyzed and developed many functional and technical solutions. Wrote conversion programs for employee conversion and employee balance conversion. Produced many interface programs, reports and ad hoc scripts during many implementations.

Oracle Corporation 1995 to 1998

Senior Principal Consultant and Principal Consultant

• Lead resource on the successful implementation of Oracle HR/Payroll for OHM, a 3500 employee multi-state company. Responsibilities included resource supervision, project planning, meeting organization, requirements gathering, design, development and testing of system solutions. Custom developed many items including custom paid time off solution for the client, custom forms, custom reports and interfaces.

• Integrated a new company into a live HR/payroll client which involved the setup of new key flexfields, descriptive flexfields and element for the new company. Create ad hoc reports using Oracle Reports. Supported functional consultant during year end processing by researching and resolving bugs and writing custom scripts.

• Developed a custom tips process for one of the first Oracle HR/Payroll customers. Designed and developed many custom reports for the client.

Molex, Inc. 1990 to 1995

Systems Analyst and Programmer Analyst

• Implemented various projects with lead support on the implementation of the D&B HR/Payroll System

• Installed new vendor HR System software, and directed the conversion of the preexisting RPG payroll system to a new vendor Human Resource/Payroll system

• Designed and built all of the related subsystem links for the above-mentioned HR implementation:

 Stock Purchase Plan

 Profit Sharing Plans

 Check Reconciliation interfaces

 Bonus Processing

• Designed, built, and administered the IT portion of the 401k plan implementation

• Provided IT supported for many year end processes from the IT side

Servicemaster Corp. 1986 to 1990

Programmer Analyst and Programmer

• Managed all aspects of support for HR/Payroll system and other programming projects.

SKILLS

Management

• Supervision, Performance Reviews and Strategic Planning

Software Project Management

• Planning, estimating, scheduling, and managing many software projects using Oracles AIM structured development methodology

Oracle Software Experience

• HRMS Releases 10.7 through 11.5.10

• Functional setup for HR, Global HR, Payroll, Standard Benefits, Training Administration, Time and Labor, Manager and Employee Self Service, Irecruitement and Talent Management. Technical work include employee conversion, balance conversions, interface coding, custom form creation and custom report creation. Customized HR workflows and configured approvals using Oracle Approvals Management. Personalized HR Self Service forms. Developed many Payroll and OAB Fast Formulas.

Application Development

• Forms, Reports, database procedures and batch applications development for relational database environments, Oracle Custom Library.

Database Administration

• DBA I class from Oracle Education

Training

• Experience teaching users on Oracles HR/Global HR/Payroll/OTA/SSHR/Talent Management/OAB FF, GUI Product and technical architecture.

Platforms/Operating Systems

• 486/586 PC, DEC ALPHA, HP 9000, IBM 3090, UNIX, OS/2, DOS, Windows 98, NT, Win2k and XP

RDBMS/Tools/3GLS

• Oracle: Sql Plus, PL/SQL, Forms 6, Reports 6

• IBM 3090: COBOL, VSAM, Microsoft Access

EDUCATION

Illinois Benedictine University - Lisle, IL

Masters of Business 1994

Devry Institute of Technology - Lombard, IL

Bachelors of Computer Science 1986

CLIENT LIST

First Health Ohio Hazardous Materials Troon Golf Southern Union Company

Reader’s Digest City of Chicago Cree, Inc. INFOnxx

Huntsman Petrochemical Teletech Brunswick Fellowes

AHA

INDUSTRIES

Utilities Health Care Government Manufacturing Telecommunications Publishing

Contact this candidate