abh9s4@r.postjobfree.com W. Greg

Lyon

317-***-****

Skill Synopsis:

Applications: Oracle Human Resources, Oracle Advanced Benefits, Oracle Time and

Labor, Self Service Benefits, Self Service Human Resources,

Compensation Workbench, Oracle Training Administration, Oracle

Approvals Management, and Oracle Payroll

Application Oracle 10.7, 11i, R12

Versions:

RDBMS: Oracle 7.x, 8.x, 9i, 10G

Languages: PL/SQL, SQL, HTML, XML, .Net

Tools: SQL*Plus, SQL*Loader, TOAD, Discoverer, Dataloader, Oracle Forms,

Oracle Reports, XML Publisher, PuTTy, WinSCP, Visio, and Workflow

Builder, UPK

Experience Summary:

Mr. Lyon is a HCM functional and technical consultant who has over 11 years

in implementing and supporting Oracle Human Resources, Advanced Benefits,

Self-Service, Compensation Workbench, Time and Labor, Self Service Web

Applications, Workflow/Approvals Management, Payroll, and Training

Administration modules. He has a triumphant history of successfully

converting and implementing various HCM systems for a wide variety of

clients using Oracle's AIM methodology. His project experience includes

scores of full life cycle implementations which included requirements

analysis, project planning, solution design, application setup, security

implementation, compiled and conducted training, and meticulous testing

events. He is an exceptional team leader, group member, solution architect,

and is well equipped with superior interpersonal and communication skills.

Professional Experience:

[pic] Metropolitan Sewer District, St. Louis, MO (OTL)

May 2010 - Oct 2010

. Worked with Payroll and Finance in defining the business requirements

(BR030) that were required to ensure there was fewer defects and

issues with the employee entering time and transferring that time over

to Payroll and Grants Accounting

. Formulated the OTL setups (entered into a BR100) which were needed to

handle the complex and exception based HR policies for Flex/Non-Flex

Schedules, Shift/Non-Shift, Project/Non-Project, Temporary, and other

worker groups via Timecard Eligibility, Timecard Preferences, and

Earning Policies

. Conducted CRP, SIT, and UAT sessions with the business SMEs as they

tested the business requirements using test scripts and string tests

that were developed

. Created custom solutions in narrowing the Hours Type, Projects, and

Expenditure Type fields with valuesets, views, and custom code

. Developed numerous MD050s for Time Entry Rules, Missing

Timecard/Pending Approvals Alerts and Reports, and custom Timecard

Layouts for custom Project and Payroll fields for Payroll and Grants

Accounting

. Assisted the Training team in developing OTL curriculum, job aids,

user audience lists, and UPKs in training the Super Users, SMEs, and

other employees entering and/or approving time

[pic] Regeneron, White Plains, NYC (OTL)

January 2010 - July 2010

. Roles included being the OTL functional and technical lead, Project

Management lead, and technical resource for Oracle Projects

. Prepared a resource and task tracking spreadsheet to keep the

Regeneron project team up to date on where we stood with hours based

upon what we had first estimated, actual hours worked, and hours left.

. Lead and followed up with 2 other OTL technical resources in creating

reports, Time Entry Rules, Conversions, and a custom Ceridian

interface.

. Completed Phase 2 tasks which included Accrual plans, associated Time

Entry Rules, Alerts, XML reports, and additional Absence Leave setup

. Migrated OTL functional and technical setups to Production after

receiving approval from the UAT testing group

. Created Time Entry rules to validate time start/end times for Non

Exempt employees, determining if a user is a Super User that chooses

Override Approvers, ensuring that the expenditure type and tasks are

the same, checking PTO minimums, etc.

. Developed periodic alerts that send reminders to employees, their

supervisor, and their supervisor's supervisor when employees are

missing timecards and when timecards have not been approved by the

supervisor.

. Formed logic for mapping an employee's cost center to user defined

tables to determine what projects an employee may view.

. Created Assignment Time Information scripts to populate shifts,

rotation policies, and earning policies based upon defined logic that

was provided by the business.

. Setup OTL with approval styles, elements, alternate names, element

time info, shifts, work plans, rotation plans, earning groups, premium

eligibility policies, earning policies, shift differential policies,

Time Entry Rules, and preferences.

. Assisted with troubleshooting during UAT events and instance

configuration

. Determined and documented the order of OTL and Project processing

using a Visio process flow diagram and modifying it to suit the needs

of the Payroll and Projects teams.

[pic] Wendy's Arby's Group, Atlanta, GA and Columbus, OH (CWB and HR)

October 2009 - February

2010

. Worked closely with the WAG HR super users to determine what

responsibilities and security users should have on the Wendy's and

Arby's side along with ensuring both business groups were secure using

a security matrix.

. Assisted during UAT and go live with Online ESR (in house built self

service) when errors would occur between that system and Oracle using

APIs.

. Updated Desk Level Procedures and job cheat sheets to be used as a

reference to help aid day to day activities

. Built Discoverer workbooks based upon requirements the client had

provided, along with troubleshooting and fixing problems found by the

users during UAT.

. Developed numerous scripts during conversion and production go live

activities to determine if the data was converted properly and that

business rules are in place.

. Created technical scripts for validating conversion activities on the

People, Assignment, Address, Salary, and other miscellaneous HR data.

Worked closely with the business and technical owners in determining

solutions for data issues that existed in legacy (UltiPro and

Peoplesoft) and oracle.

. Supported CWB functional and technical setups through go-live while

creating custom functions that would determine eligibility, eligible

salary, rating quartiles, proration factors, bonus targets, and target

percentages.

. Conducted training for HR and Compensation teams at Wendy's for

Discoverer Plus, Oracle Navigation, and Advanced/Troubleshooting HR

User Day to Day Activities for both the US and Canada business groups.

. Developed fast formulas for participant and rate eligibility and rate

value calculations

. Created user hooks to display bonus percent, min/max merit ranges, and

rating quartiles

[pic] Regeneron, White Plains, NYC (OTL and CWB)

July 2009 - December 2009

. Created CWB fast formulas for returning eligible salary and if an

employee is eligible for a promotion

. Added custom user hooks to the CWB worksheet that included YE & Stock

Plan's prior segment2 value, displaying rating factor, displaying

quartile, 2008 performance rating, and Year end Stock Option shares

that was manually added to an employee's elements

. Prepared and presented OTL demonstrations to scientist and executives

to win approval to implement the base product with supported

customizations for a pilot group after thorough testing during the CRP

and UAT testing events

. Lead OTL workshops to determine the functionality we needed to

configure and determine where gaps and provide options

. Setup OTL work structures, approval styles, absence types, policies,

earning elements, links, alternate names, OTL preferences, eligibility

criteria, and modifying time entry and review templates

. Developed mockups of project unallocated hours region on the timecard

entry and notification templates while assisting in meetings

discussing design, functionality, and data flow for custom table

region

. Modified Time Entry and Review templates for Projects and Payroll to

use Time In/Out fields

. Requirements gathering and Gap Analysis completed for OTL and Projects

needs

[pic] Tanana Chiefs Conference, Fairbanks, AK (HR)

July 2009 - October 2009

. Compiled HR System Administrator reference guide for week long

training to go over work structures, security, workflow, alerts, BEEs,

Web ADI, concurrent program setups, taskflows, flexfields, printers,

self service personalizations, and fast formulas

. Assisted in setup of network printer to print XML Check Writer checks

. Developed script to find jobs without worker compensation codes or

rates and determined the WC balances that were never paid by the ER.

Created balance adjustments via the Batch Balance Adjustment Web ADI

functionality to adjust employee's WC employer liabilities

. Created Dependent Care and Health Care FSA elements and modified the

fast formulas to deduct based upon a plan year and a global value

starting on 8/1 (deduct based upon pay periods left in this and next

year's pay period

. Supported onsite Oracle business analyst in troubleshooting and fixing

issues with Payroll, OTL, Workflow, and HR

. Documented and help implement the Oracle Batch User Creation process

to help automate the creation and termination of user accounts.

[pic] SEM Group, Tulsa, OK (OTL and CWB)

May 2009 -

October 2009

. Created CWB rate value calculation fast formulas for eligible salary

and proration factor

. Added user hooks to the CWB worksheet that included the min/max merit

range, merit quartile, bonus amount, and bonus percent

. Supported UAT OTL testing after setups were overhauled to use best

practices and payroll consolidation

. Provided troubleshooting support and made configuration changes to

allow test scenarios to pass

. Point person for questions about OTL setups, business processes, and

the future direction of OTL

. Created custom function that narrows the Hours Type list of values on

the timecard based upon an assignment's employment category and

Timecard Required value in the GRE

. Updated the Time Entry, Review, and Confirmation layouts so that the

cost center would not be seen and to allow the hours type list of

values to call the custom function that narrows the list of values

down

. Worked with Oracle Support where employees would not receive overtime

premiums if their total hours went into overtime on a holiday based

upon FLSA rules

. Updating and testing TERs that failed during User Acceptance Testing

. Troubleshooting element, underlying fast formulas, and OTL setups

during testing event as issues arose

. Modified Employee Details XML report to provide additional time and

benefit related information during bi-weekly processing

. Developed TER that checks for outstanding PTO that has not been

transferred to an assignment's elements to ensure that the employee is

not trying to submit time that they have already taken

[pic] Maverik, Salt Lake City, UT (HR, Manager Self Service, Workflow/AME,

and OAB) June 2009 - October 2009

. Ongoing support for Payroll, HR, OAB, and Self Service

. Wrote scripts to migrate the New Hire Composite Score from the People

DFF to the Assignment DFF while personalizing Manager and Employee

Self Service to show the new flexfield segment

. Created process that populates costing, runs a custom XML Costing

Journal report, and rolls back the costing before a payroll run so

Financials can verify employee balances and close out their books

before the last day of the month

. Driving escalated SRs for payroll issues determined during the 11g

Upgrade testing and working with the DBA in tweaking performance and

technical aspects in the database

. Implemented Garnishment setup to clear out past Garnishment Accrued

balances before they are re-used on employees

[pic] Frontier Airlines, Denver, CO (OAB)

June 2009

Created post election edit formula that computed the Maximum Enterable

Coverage' amount that returns the lesser of $500k or 5 x Annual Salary

[pic] Tri-State (CWB), Denver, CO

June 2009 - July 2009

Created participant eligibility fast formula to determine if an

employee is eligible for an annual increase

. Developed user hooks to display the min/max increase range, max

increase amount, and exempt status on the worksheet

. Helped troubleshoot issues during CRP and migrate setups to production

[pic] West Virginia University, Morgantown, WV (OTL)

April 2009 - May 2009

. Created Fit/Gap Analysis from OTL Assessment and conducted follow-up

requirements gathering sessions with the business analysts and HR,

Payroll, and Benefit managers

. Designed Visio Dataflow diagrams that represented the flow from the

manual entry of forms to inputting the data into Oracle HR, along with

paper flow chains

. Worked with HR to determine what policies and premiums were FLSA

versus University/State driven to ensure compilance

. Provided 2 OTL demos to executives and IT to demonstrate the available

time and labor functionality, ease of use, and user interface within

the Self Service timecards

[pic] NRECA, Arlington, VA (CWB)

March 2009 - April 2009

. Created setup kit that included all of the components that were needed

to install CWB's Merit Planning fast formulas

. Developed custom package and 4 CWB fast formulas that return the

proration factor, eligible salary, merit amount, and merit max range

[pic] IMMI Indianapolis, NC (HR and OTL)

February 2009 - May 2009

. OTL functional matter expert in assisting client in troubleshooting

outstanding issues, creating timeline for the implementation,

determining the course of action for each phase, creating checklist of

items to test during UAT/CRP events, and providing technical

assistance for fast formula and interfaces

. Developed Paid Time Off Accrual Plans for FMLA, Vacation, Sick, Bonus

Time, and Birthday time with customized accrual periods that meet the

business requirements by developing custom fast formulas for each plan

. Provided functional support and technical assistance for adding fields

to the timecard templates, adding Time Entry Rules, adding Eligibility

Criteria, and Preference Trees

. Created a Forms Configurator functional reference help assist them in

developing customized forms for IMMI personnel

. Customized Security Profiles to give supervisor the flexibility to

complete timecards for others while the employee's supervisors are out

of the office

. Provided support for go-live activities in capturing and sending time

to payroll

[pic] Redhat, Raleigh, NC (OSB)

February 2009 - May 2009

. Project, Functional, and Technical Lead for the Open Enrollment OSB

project with a tight 1 month timeframe in entering new compensation

objects, rates, and rules for over 2000 employees

. Provided support and guidance during enrollment and post enrollment

activities

. Modified FSA interface to Flores that included the new plan setups and

logic on which records should be inserted in the outgoing file to the

provider

. Created new fast formulas to deal with the employee and employer

maximum contributions for HSA plans and making sure the HDHP plan is

selected during the enrollment with the HSA plan

. Determining setup that is needed for taxable and non-taxable Domestic

Partner Dependents' imputed income

[pic] Tanana Chiefs Conference, Fairbanks, AK (OTL)

February 2009 - April 2009

. Modified existing OTL templates to call custom function that reduces

the list of hours type/alternate names

. Customized timecard to reduce list of hours based upon the employee's

shift, their FLSA, and if they had a secondary status/leave of

absences

. Created script to add secondary status for all active employee

assignments so they could take a funeral leave for a retired executive

[pic] Maverik, Salt Lake City, UT (HR, Manager Self Service, Workflow/AME,

and OAB) October 2007 - May 2009

. Open Enrollment support that included troubleshooting errors and

issues that employee's received, determining if employee and employer

elements are taken out appropriately, providing self service metrics,

writing reports to determine which rates and coverages changed from

the prior enrollment.

. Wrote fast formula and custom function to return annualized salary for

401k rate calculations.

. Determined eligibility rules and wrote fast formula to give employee

the opportunity to elect medical plans based upon length of service

logic.

. Developed Person Selection criteria fast formula to be able to backout

only certain individuals that had particular job titles

. Diagnosed enrollment and self service issues by creating scripts and

testing before putting 'fixes' into production.

. Personalized Manager and Employee Self Service based upon the client's

needs and setup workflow to send notifications to the appropriate

managers and/or supervisors.

. Created benefit XML report and scripts that report upon changes for

each employee on what they previously had and what they elected during

the current open enrollment.

. Built a batch user creation process that assigns a username, password,

and responsibilities based upon logic given from the client.

. Created Oracle Alert based upon needs for determining a store clerk's

eligibility after 90 days

. Conducted several day training and gap finding classes with HR and

Payroll to review new fixes and enhancements to Manager Self Service

and Workflow.

. Developed numerous alerts to help payroll and HR determine problem

areas before the next payroll and benefit processing.

. Owned issues list and followed up on tasks that needed to be complete

by Maverik employees and PEG consultants during the Self Service and

Workflow rollout.

. Creating fast formula to void out un-necessary new hire life event

when a termination life event is detected

. Provide workflow support on items that get stuck or need to be re-

routed

[pic] Vectren, Evansville, IN (OAB, HR, and Self

Service)

June 2008 - May 2009

. Created 2 highly intricate programs for active employees and retirees

that include over 150 standard rates, 250 VAPROs, and many dozen

Eligibility Profiles based upon bargaining unions, FLSA status,

subsidiary organizations, person type usages, and benefits groups.

. Directed a technical team in creating fast formulas based upon

specifications given from client interviews. Tested and troubleshot

completed fast formulas, created new fast formulas (post election,

compensation calculation, participation and rate eligibility, premium

value calculations, and waiting period) using PL/SQL functions.

. Setup multiple environments for CRPs, UAT, and another to validate

both BR100 documentation and the plan design copy process. Also, used

the functional administrator to migrate self service personalizations

from each instance.

. Gathered requirements and prodded the benefits team to ensure the best

benefit processes are being followed in reducing paperwork,

spreadsheets, and time/expenses.

. Lead the HR, Payroll, and Benefits teams in determining what

personalizations, communication types, tips, and messages were needed

in the active and retiree responsibilities.

. Worked with the benefit knowledge experts in creating test scripts for

UAT and other regression testing events

. Setup Actual Premiums for self-insured plans that allowed benefits to

pay their providers monthly.

. Developed an automated/custom tuition reimbursement function where an

employee makes the request via self service and the once all paperwork

has been received and approved, benefits approves the certification

that is created. Once approved, a payroll element is created that

will be included in the employee's next pay.

. Assisted the technical team in fixing data issues, creating benefit

assignments, moving bargaining data from a flexfield to the seeded

bargaining fields, and adding benefit groups to employee records.

. Split retiree participant and retiree spouse plans to allow

eligibility profiles and fast formulas to determine if a spouse may

have the same plans the participant receives for when they are under

or over the age of 65.

. Customized the Benefits Enrollment Confirmation Statement XML page to

mimic the self service confirmation page.

. Project, Functional, and Technical lead in moving Purchasing from

Positions to HR. Developed scripts and procedures needed to transfer

assignments from using positions to jobs.

. Created SQL scripts that Discoverer workbook will use for Succession

Planning instead of using the seeded Position functionality with

Manager and Employee Self Service

. Provided alternative approach to submitting and approving Tuition

Reimbursements since elements were not populating correctly for

payroll

[pic] Ultradent, Salt Lake City, UT (OAB)

January 2009 -

February 2009

. Developed highly complicated fast formulas based upon waiting periods,

anniversary dates, and having prior coverage in Long Term Care,

Employee Life, and/or Employee AD&D plans that returns the appropriate

coverage start date based upon these factors

[pic] Powell Industries, Houston, TX (HR, XML Reports, and PL/SQL)

December 2008 - January 2009

. Created XML reports for Terminated, Dependents, Applicant, Salary

Review, Deductions, Employee Detail, and Premiums for benefit

providers.

. Developed XML Total Compensation Statement that uses data that is

imported via backfeed process from Ceridian

. Wrote APIs to end date legacy HR positions and rename existing HR

positions

[pic] Tanana Chiefs Conference, Fairbanks, AK (HR)

May 2008 - June

2008

. During the job to position implementation, analyzed the jobs that were

be input to ensure that all values entered were meaningful and matched

up correctly with previously used job titles.

. Input the new jobs, valid job grades, further information (EEO, salary

codes, etc.), and later attached the jobs to employees via Oracle APIs

and temporary tables created using SQL Loader.

. Created new positions and attached the previously created jobs and

associated jobs to them. Added the positions to the employee's

assignments via Oracle APIs.

[pic] SEM Group, Tulsa, OK (OAB and SS)

April 2008 - July 2008

. Implemented EOI Certifications that are required by life event, along

with EOI certifications for Optional Employee and Dependent Life

coverages.

. Added setup for when employees go in leave with/not with benefits

. Created Post Election Fast Formula rule during enrollment so that

Vision and Dental options should match

. Determined eligibility configuration needed for when an employee takes

a 401k Hardship Withdrawal so they no longer receive the 401k benefit.

. Troubleshooting post Open Enrollment, self service personalizations,

security profile, and OAB setup issues.

. Created Post Election Fast Formula rule to ensure that the employee

enter a date of birth for their dependents before they can choose

plans with options for dependents.

[pic] IMMI Indianapolis, NC (HR and

OTL)

April 2008 - August 2008

. Conducted training for OTL and PTO fast formulas, initial setup, and

ongoing support

. Completed health check to determine if any holes exist in the OTL and

PTO setup, along with troubleshooting issues that have come up during

testing

. Developed proposed model for interfacing to TimeLink clock/badge

system in importing time information into OTL and attached PTO Accrual

plans

. Providing ongoing support during their implementation during 2008

[pic] Redhat, Raleigh, NC (OSB)

January 2008 - July 2008

Worked with the Human Capital team in determining the needs and

business rules for the open enrollment that must be followed to ensure

that there are fewer clean-up tasks afterwards.

. Personalized the enrollment train (steps) to make it as simple as

possible for employees and added communications with HTML code

throughout for readability.

. Developed and updated project plan with outstanding issues throughout

the project.

. Created 15+ fast formulas to accommodate the business rules that were

needed to check to ensure the employee enters the proper data and

benefit provider requirements were satisfied.

. Maintained the BR100 for all functional and technical setups that were

completed for the mock enrollments and production implementation.

. Provided feedback on how IT should map new elements to ADP and for

their benefit provider interfaces.

. Setup several mock enrollments after the requirements were added to

the functionality and made adjustments based upon feedback.

. Support and troubleshooting issues during open enrollment and making

adjustments after thoroughly testing in a QA environment. Creating

SRs and escalating them as needed to make sure employees are able to

enter their elections during open enrollment.

. Creating reports for the Human Capital team to determine which benefit

coverage amounts need to be adjusted and other miscellaneous requests

after open enrollment.

. Continued after Open Enrollment to help troubleshoot ongoing issues,

log SRs, and find solutions for OSB limitations like certifications

and EOI approvals.

. Made enhancements to provider interfaces PL/SQL packages to include

new GRE that was recently acquired

[pic] Rockefeller University, New York, NY (HR, OAB, OTL, and Self

Service) October 2007 - July 2008

. Created Person Selection fast formula to be used in backing out all

individuals who had a FICA Person DFF attribute. Once backed out,

created a script using the People API to update each record with a

null value, so that when the Participation process ran again, their

Supplemental Life rates would calculate correctly.

. Developed custom PTO accrual plan that stores the accrued vacation

that an employee is eligible for the beginning of the next fiscal year

and end dates prior vacation accrual element.

. Created custom fast formulas and 5 custom functions (and package) to

move the accrued vacation over to the primary PTO accrual plan that

stores absences and vacations.

. Worked with the HR Managers to determine the logic for the custom fast

formulas and accrual process.

. Open Enrollment support and troubleshooting errors/issues employees

were receiving throughout open and providing metrics on how many

employees accessed the system.

. Developed a Time and Labor Time Entry rule to determine if an employee

has a shift entry on their statutory information if they choose Shift

as an hours type on their timecard.

. OTL ongoing support for issues that employees are receiving when they

submit their timecards. Opening SRs with Oracle and troubleshooting

the problems, and analyzing the setup between instances.

. Another Time Entry Rule was created to determine if hours worked a

week exceeds the number of regular hours plus absence hours. Since no

hours are stored in the database until saved or submitted, created

custom process to pass the timecard values to a temp table for further

processing by the calling fast formulas.

. Wrote XML reports for total absences each employee has taken by

department and a timecard summary report listing out all time entry

for a given week.

. Developed reports for how much vacation each employee is entitled and

what they have taken at the end of the year.

. Payroll element analysis to determine if conversion efforts were

successful and to recognize patterns in what should have been

converted and not.

. Created script to give part time employees a specific pay grade that

was omitted during conversion but is needed for benefits eligibility.

. Setup Absence Management and Time and Labor configuration in

production and all other environments.

. Created a Child Education PTO Accrual plan that is similar to the

other employees, but instead or on an academic year instead of a

fiscal year as the rest of the company.

. Continued supporting them for OTL issues with the timecard and

production errors involving eligibility. Also, worked with Oracle

Support on many occasions in solving &Measure_of_Unit error after

choosing STD for an hour type on the timecard.

. Completed a knowledge transfer and helped support new technical

employee that took over the PTO and Reporting processes.

[pic] Franklin Covey, Salt Lake City, UT (HR and OBB - Basic Benefits)

December 2007 - January 2008

. Developed package to load in all current benefit data provided by the

benefits provider and determine which employees are no longer enrolled

in the previous benefits they elected.

. Created, updated, and end dated elements depending on if the employee

is still enrolled in the benefit, if the rates changed since the last

enrollment, or if they had never elected the benefit.

. Created scripts to cross reference with the provider's employee data

file that will be used for the next enrollment period.

[pic] Motorola, Tempe, AZ (HR)

September 2006 - October 2007

. HR lead completing requirements gathering, workshops, fit/gap

analysis, and questionnaires for the US, Germany, India, and Mexico

. Worked on completing HR Assessment and proposals of current and

proposed architecture for each phase.

. Created and presented proposed architecture to Finance, HR, and IT

Managers

[pic] United States Gypsum (USG), Chicago, IL (HR, Oracle Payroll, OAB,

Manager, & Employee SS) August 2006 - August 2007

. HR Lead that configured instances for the CRP (Conference Room Pilot),

Parallel event, numerous conversions, and mitigated releases in

Production. Also, lead and completed work on security, government

reporting, and the yearly hourly increase processes (using Web ADI).

. Designed and implemented security structure for all responsibilities,

security profiles, custom functions, menus for 7 go live plants and

corporate departments (200~ responsibilities alone).

. Compiled and Implemented thorough translation list that were needed

for the French Canadian translations for the Montreal plant and

office.

. Developed test sets and test scripts through Mercury's Test Director

for all HR business processes and updated datasheets that were to be

used during the CRP.

. Logged issues through Serena's TeamTrack (TReq) system for all defects

and enhancements that were found during CRP, parallel testing, User

Acceptance Testing, and all conversion builds.

. Determine appropriate 'fixes' that were needed for the conversion

errors and prior records that were created using a legacy interface to

keep Oracle Purchasing and SCM up to date.

. Worked with the training team in developing webinars and classroom

training materials

. Met with the Payroll, Benefits, and Self Service teams on a regular

basis to ensure that all setups were being configured properly and

discuss issues that needed to be addressed for the shared environment.

. Helped diagnose issues within Discoverer reports and using the

appropriate security, along with registering all Oracle Reports and

Processes through AppWorx to execute those jobs.

. Met with Purchasing and SCM often to determine if HR configurations

for Organizations, Locations, Jobs, and security would affect those

modules and developed a more flexible job structure for HR and

Purchasing.

. Worked with QA to move new/modified configurations and specifications

into new environments using version control and auditing.

. Completed setups and discussions for Kronos integration to Oracle

HR using user defined tables, DFFs, and valuesets.

[pic] Vertex Pharmaceuticals, Cambridge, MA (HR, OAB, and Self Service)

June 2006 - August 2006

. Project Manager and HR functional lead in implementing Oracle HR and

Advanced Benefits with existing Oracle Financials system.

. Held Financials Integration workshops to find best practice in using

current Finance organization hierarchy and Jobs that were used for

approvals in Purchasing.

. Conducted workshops for determining the client's future and present

business needs and determine best approach to move from Ceridian's HR

system.

. Key Deliverables were prepared and reviewed with the client for

signoffs.

. Managed and reported total hours the team had worked, along with a

forecasted hours for the duration of the project.

. Determined the appropriate Family Pack and instance strategy for the

project.

. Configured HR system and modified existing shared HR work structures.

. Updated the detailed project plan as changes were needed and resources

had changed, along with ensuring resources were not over allocated or

working while out of the office.

. Provided the project team with updates using weekly status meetings

and daily dialog, while monthly steering committee meetings were

conducted to ensure project sponsors were informed on the project's

status, risks, and finalize open items or issues.

[pic] Mentor Network, Boston, MA (OAB)

May 2006 - August 2006

. Created ANSI-834 Kaiser System Extract with post extract process.

. Troubleshooting issues with existing Cobra System Extract.

[pic] Michael Baker Corporation, Pittsburgh, PA (HR, OAB, iRecruitment,

Self Service, & OTL) October 2005 - May 2006

. Oracle Human Resources Functional Lead in configuring instances per

Oracle On-Demand hosted environment and customer requirements.

. Lead several Conference Room Pilots with HR users and management to

determine if system has been configured correctly based on the

business needs of each of their divisions.

. Created and updated BR100 and TE.40 test scripts for HR users, Super

HR users, and HR Compensation users, which were used later to help

create HR functional user manuals.

. Determined Security requirements for iRecruitment, Benefits, Human

Resources, and Self Service.

. Setup EEOC and AAP reporting requirements within work structures.

. Worked closely with the technical team to ensure conversion was

importing the proper information from Peoplesoft.

. Setup payrolls, balance feeds/types, grades, jobs, GREs, locations,

elements, audit trails, organizations, descriptive flexfields, extra

information types, and soft coded key flexfields needed for conversion

storage and future business needs.

. Setup and tested Salary Web ADI process of exporting and importing

salary proposal changes.

. Copied and modified US Hiring Applicants, while adding business

specific customizations and validations throughout the configuration

template form.

. Developed a Custom Security Process (using a custom package) that is

based upon values from the People Group and verifying if the users

have access to employees based upon a security EIT.

[pic] Banfield Pet Hospitals, San Francisco, CA (Compensation Workbench)

April 2006 - December2006

. Created Changes and Full System Extracts (utilizing the post extract

post process)

. Providing miscellaneous OAB and Self Service Support

. Troubleshooting Post Election Fast Formula

[pic] Activision, San Barbara, CA (Compensation Workbench)

December 2005 - January 2006

. Developed test scripts and individual training manuals for the entire

compensation lifecycle. Some chapters included compensation setup,

security, creating budgets, allocating budgets, approving allocations,

submitting compensation changes, and closing compensation plans down.

. Wrote eligibility profile fast formulas for multiple plans and helped

troubleshoot recursive supervisor issues.

[pic] Family Dollar Stores, Charlotte, NC (HR and OAB)

January 2006

. Developed and delivered detailed presentation slides (reference

guides) to present to Human Resources and Benefits users needing an

overview of both Oracle HR and Benefit modules.

. Both presentations included setup steps for implementation, on-going

production support, future enhancement possibilities, and guides for

troubleshooting common errors and issues.

[pic] ADESA, Inc., Indianapolis, IN (HR and Self Service)

July 2005 -

October 2005

. Gathered Requirements for Oracle Human Resources implementation,

configured system per clients requirements, created Solution Design

documentation, led User Acceptance testing and Systems Integration

Testing and provided post go-live functional support

. Converted employee information and work structure information from

legacy system to HRMS system

. Gathered requirements for vendor interfaces, developing the code for

each, tested, and implemented for go-live implementation

. Created coding and naming standards for Oracle HRMS system's objects

and configurations, along with setting up process for version control

. Implemented security setup using responsibilities, functions, task

flows, profiles, and request groups.

. Worked closely with the customers and project manager to ensure

deadlines were met for requirements on interfaces, conversions, and

configurations

[pic] Merrill Lynch, New York, NY (HR, Self Service, and Compensation

Workbench) December 2004 - July 2005

. Led the US deployment and implementation of Oracle HRMS and Self

Service (Manager and Employee)

. Worked closely with the Oracle technical team to provide timely

solutions

. Managed and imputed over 200 + Oracle Self Service personalizations

. Maintained BR100 for Global Oracle Human Resources

. Developed training program for Service Center Managers

. Worked with Oracle Development and Support for ongoing issues during

deployment and acceptance testing

. Onsite functional and technical resource for Oracle HR setup and

functionality questions

. Created ad-hoc reports after conversion to identify default values for

salary, payroll, GREs, and jobs using SQL Plus and Toad

. Logged and managed issues associated with Oracle HR and Self Service

using Mercury's Test Director

. Diagnosed security issues compounding from security profiles, task

flows, responsibilities, and proxies for Manager Self Service

. Managed security and functional issues for Compensation Workbench

. Diagnosed Post Conversion Data issues and offered solutions in

inoculating issues

. Offered solutions for the Family Pack J upgrade for both Core HR and

Self Service

[pic] S1 Corporation, Atlanta, GA (HR and OSB)

November 2004 - December 2004

. Created Flex Spending System Extract for HCAP insurance company

. Created Cobra System Extract for HCAP insurance company

. Troubleshooting issues related to ADP Connect and Oracle Standard

Benefits

[pic] Jefferson Pilot Financial, Omaha, NE and Greensboro, NC (HR, OSB, &

OAB) September 2003 - November 2004

. Gathered Requirements for Oracle Human Resources and Oracle Advanced

Benefits implementation, configured system per clients requirements,

created Solution Design documentation, led User Acceptance testing and

Systems Integration Testing and provided post go-live functional

support

. Created OAB Life Events, collapsing rules, fast formulas, eligibility,

and updated benefit plan rates

. Developed change and full system extract files based on the provider's

requirements, along with modifications to Post Extract Process

. Overhauled the PTO Carry Over based upon the client's business needs

by using the Carry Over, Calculation, and Period Accrual fast

formulas.

. Created custom packages/procedures to calculate negative carryover,

reset carryover amounts, and deal with special situations in which

officers received additional vacation time.

. Added and modified existing element, element links, accrual plans, and

absence types to accommodate the PTO Carryover Process and the

client's business rules

. Created an automated process for timecard exceptions that inputs them

into the BEEs, transfers them, and send Oracle Alerts to the customers

after processing

. Modifications to Self Service module personalizations, messages,

communications, and researched ways in changing the self-service look

and feel based upon client's needs

. Conducted post-live production support for HR staff and system

administrators on a daily basis for questions they had and problems

they would encounter during normal business operations

. Setup application and defined customizations necessary to meet the

clients' business requirements

. Researched and consulted with the HR client about Oracle Time and

Labor's functionalities, requirements, and estimated time of

implementation in relation to their business requirements

. Researched approach needed by the HR staff to make changes to the

organization structure that were easier and more efficient to complete

. Setup process for changing, adding, and deleting cost centers, which

included using the Position Mass Move, Mass Update Assignments, and

FNDLOAD

. Developed unit-testing scripts and manage the process when upgrading

to a higher family pack version

. Post production support for HR department

. Implemented Self Service Benefits and made changes to

personalizations, messages, communications, and region items (5.7h)

. Created fast formulas and modified communications for upcoming

enrollment period

. Developed many Forms 6i enhancements and fixed bugs for client's

Dental system and Life Insurance Quote Engine

. Created table structure and UNIX processes to import data from an

acquired LTD insurance company for policy re-writes

[pic] First DataBank, Indianapolis, IN (Oracle Forms & Oracle Reports)

September 2002 - September 2003

. Created and supported forms and reports for the client's custom drug

application

. Migrated Forms that were designed to help drug editors migrate dosage

information from older system to a new maintenance system

. Created and tested reports used by the editors to verify drug

information validity

. Assisted in creating a three-tier .Net system that would begin

replacing older drug systems

[pic] ATA Airlines, Indianapolis, IN (HR, OAB, OTM, OTL, SS, Oracle Report

& Forms) June 1999 - September 2002

. Developed and implemented Oracle 11.5.7 HRMS, including OAB, HR, OTA,

and Self-Service

. Created and maintained standards and processes for Work Force

Analysis, Job Group Analysis, Vets 100, Veteran Analysis, and other

government reports for the EEOC.

. Tightened Oracle security within the application and reports using

task flows, request/data groups, and customized code within each 6i

report

. Created and maintained home grown and existing forms using Forms 6i

and custom library

. Setup and maintained 16 different HP printers and modified styles,

types, drivers, and postscript driver configurations

. Worked with technical team in getting PTO process to calculate and

load BEEs appropriately for flight crew, corporate officers, full and

part time employees, and furloughed/laid off employees.

. Installed, setup, and began testing Discoverer functionality to

determine if the reports could be delivered timely and accurately

based upon the functional specifications that were proposed.

. Created interfaces and reports for Human Resources and Payroll systems

. Project Lead for several projects that included FOSHM (third party

audiometer software), Y2K, 11i sub-projects, database upgrades, and

Discoverer 3i

Education:

B.S. Business/Computer Information Systems, Indiana University -

Bloomington, IN

Contact this candidate