Summary

• Over 30 years of professional Information Technology experience, including 15 years of extensive functional-technical experience using PeopleSoft HRMS HR/Payroll/ Benefits , and current experience with release 9.1
• In depth knowledge of various Time and Labor Absence Management applications both in house/third party applications
• Extensive experience with development of Structured Query Reporting SQR .
• Full lifecycle experience, including implementation and upgrade of PeopleSoft applications.
• Excellent communication and interpersonal skills.

Technical Skills:

• Others: PeopleSoft HRMS version 6.0, 7.0, 7.5 and HCM version 8.0, 8.8, 8.9, 9.0, 9.1
• Modules: HR / Base Benefits / Benefits Administration /NA Payroll / Position Control
• / Recruitment
• Implementations: 2 full cycles 6.0, 8.0
• Functional: Performed Fit/Gap analysis, provided documentation on implementation process from Mainframe GEAC to PeopleSoft and Genesis to PeopleSoft
• Technical: Performed Fit/Gap analysis, provided export/import mapping from main frame GEAC to PeopleSoft and Genesis to PeopleSoft
• Functional/Technical: Presentations to upper management on benchmark status of conversion
• Upgrades: 4 upgrades 6.0 7.0, 7.0 7.5, 7.5 8.0, 8.9-9.1
• Functional Experience: Training of users on the online/batch processing of core PeopleSoft HR, Payroll and PS queries, creation of How-To documentation of processing cycles, documenting setup of Ben Admin events, rules, levels of eligibility and OE cycles, maintenance of break/fix processes
• Technical Experience: SQR, SQL analyzer, Interface Reporting, COBOL, Application Designer, PeopleTools and PeopleCode
• Other Applications: MS Suite 2003, 2007, 2010, Access, Excel, Outlook, PowerPoint, Publisher and Word ,
• 2010 Excel, Word , STAT
• Operating Systems: Windows XP Professional, Windows 7, UNIX

Professional Experience:

Confidential

PeopleSoft Technical/Functional HRMS 9.1

Responsibilities:

• Creation of scripts to support the installation of bundles and patches
• Gathering and documenting the generated scripts
• Review current configurations for the 2014 open enrollment
• Documented each scripted process to users approval
• Created adhok SQL functions using the current PeopleSoft tool sets

Selected Achievements:

• Review the structure of the benefits for inclusion of the new benefit plans for 2014
• Created Query Reports to list employee classification for inclusion in the roll-up process
• Creation and updating selected fields from the audit queries
• Created audit reports and queries to validate the technical customizations

Confidential

PeopleSoft Technical/Functional HRMS 9.1

Responsibilities:

• Create customized SQL functions depending of the client requirements
• Provide custom check print layout processes using Tools people code new and customized routines
• Selected Achievements:
• Developed new SQL processes to add special formatted pay check lines for the client
• Documented process to be included in the how to routine catalog

Confidential

PeopleSoft Functional Benefits Administration HRMS 9.1

Responsibilities:

• Short term project in the completion of the merging of a new company
• Gathering and documenting the final benefits testing of the merger
• Preparation of the upcoming open enrollment of year 2014

Selected Achievements:

• Review the structure of the benefits for inclusion of the new plans for 2014
• Created Query Reports to list employee classification for inclusion in the new merger
• Creation and updating selected fields from the audit queries

Confidential

PeopleSoft Functional Benefits Administration HRMS 9.1

Responsibilities:

• Creation of PeopleSoft Benefits Open Enrollment Benefits plans
• Gathering and documenting entire process of the upgrade of the existing Benefit Plan
• Analyzed configuration of clients customized absence management of associates time off benefit
• Creation of 3 new functions for inclusion in the new Benefit program
• Developed the process to automate the current time labor to pass to the current payroll system
• Conversion of the current in house Cobra processing to an outsource at United Health Care
• Developed and installed the new health Care benefits plans with Bright Horizons
• Analyzed impact of new 2013 federal changes to the NA Payroll process

Selected Achievements:

• Created Query Reports to list employee classification for inclusion in the new plans
• Creating the test plans to validate the Open Enrollment process
• Benefits documentation upgraded to current standards

Confidential

PeopleSoft Functional Benefits Administration HRMS 8.8

Responsibilities:

• Creation of PeopleSoft Benefits Open Enrollment Benefits plans
• Gathered and documented entire process of the conversion of the existing single Benefit Plan to a model for multiple plans

Selected Achievements:

• Created Query Reports to list employee classification for inclusion in the new plans
• Created a test plan to validate the test Open Enrollment model process
• Trained the benefit users on the sequence of creation of the other 4 plans

Confidential

PeopleSoft Technical Lead HRMS 9.1 upgrade Retrofit implementation

Responsibilities:

• PeopleSoft Technical Lead for onshore and offshore 9.1 post upgrade
• Gathered and documented necessary specifications, configuration requirements, business process changes and testing considerations throughout the post upgrade implementation.
• Validated record counts between the old release HCM 8.9 and 9.1.
• Compared the differences between the user batch customized vanilla 8.9 release and the upgraded 9.1 release
• Created the required Oracle service requests to pass issues to offshore team for further resolution
• Coordinated the priority of current and future modifications and in scope required modifications

Selected Achievements:

• Resolved post implementation user data issues resulting in the 9.1 upgrade customized release retro fit.
• Created user testing scenarios validating off shore technical upgrade and Retro fit customized SQR modules.
• Validated the user coding/documentation standards were enforced in all modifications
• Participated in the Daily conference calls to coordinate the progress of modifications and resolution of identified priority issues
• Performed analysis on existing customized Sqr's to conform to the new release record configuration

Confidential

PeopleSoft HRMS 8.9 Ben Admin, Payroll upgrade and maintenance implementation

Responsibilities:

• Analyzed and implemented PeopleSoft HRMS Payroll and Base Benefits in release 8.9.
• Gathered and documented necessary gaps/specs, configuration requirements, business process changes and testing considerations throughout the implementation.
• Maintained and modified changes to the clients absence management for both salaried and hourly employees
• Created customized SQR and SQL analyzer queries to conform to the latest company enhancement changes.
• Processed selected tax updates and retro fit the customization in the updates
• Acted as a part of functional/technical development team to convert current recruitment TAM from an outside source to function using E-Recruit.
• Acted as a part of functional/technical development team to integrate position control using the department/job code structure.

Selected Achievements:

• Resolved post implementation user data issues resulting in the conversion from the outside record keeper to PeopleSoft.
• Identified and resolved numerous issues with Ben Admin configuration and setup.
• Created user documentation on the process flow of HRMS Benefits, HR and Payroll .
• Modified Benefit Admin definition processes/configuration for Open Enrollment years 2010, special OE for 06/2010 and current Open Enrollment for 2011.
• Troubleshot post go-live issues for Ben Admin and open enrollment.
• Created user testing scenarios validating vendor interfaces for medical, dental, vision, accident and cancer inbound and outbound processes.
• Created and documented Fit/Gap and mapping of department/job code structure for presentation to the functional/technical developers.
• Created and documented Fit/Gap analysis for position control using the department/job code method for presentation to the technical users.
• Performed functional analysis to link recruitment and position control to be able to create organization reporting structure.

Confidential

PeopleSoft HR 8.8 Global Implementation/Upgrade

Responsibilities:

• Modified Raytheon customized SQR modules to conform to the latest taxing changes.
• Created SQL scripts to validate the integrity of data loaded from Pay Global system to PeopleSoft.
• Implemented additional PeopleSoft Patches to correct 2006/2007 Taxes.

Selected Achievements:

• Applied the last 2006 tax update including misc year end modifications and the first 2007 tax update
• Assisted in creation of Data Load scripts using the TOAD for SQL Server utility for Australia.

Confidential

PeopleSoft HRMS Analysis

Responsibilities:

• Retrofitted 6 PeopleSoft Tax Updates and selected bundles that were required for continued maintenance
• Analyzed implementation and problem resolution of PeopleSoft Mexico to include payroll, financials and time and attendance.
• Involved in application of PeopleSoft maintenance pack upgrade patches using Application Designer and Data Mover Processes.
• Completed the updating of the DHL functional and technical online and batch documentation.
• Participated in the functional analysis of the upcoming casualty claim interface conversion to replace the old record keeper.

Selected Achievements:

• Created the user how-to functional documentation creation or updating of online 5.1 systems.
• Applied old tax and bindle updates to bring PeopleSoft maintenance processing to current standards
• Assisted in the Fit Gap analysis of the proposed Kronos 5.2 upgrade process from the old release.
• Trained DHL Personnel on the PeopleSoft HRMS application Process scheduler, Application Designer and DHL customized applications interface/report processing.

Confidential

PeopleSoft HR Consultant

Responsibilities:

Created specification documents for automating PeopleSoft Process Scheduler for benefit and payroll report distribution.

Confidential

PeopleSoft Functional/Technical Consultant

Responsibilities:

Created fit gap analysis for Ameriprise Financial PeopleSoft upgrade located in Minneapolis, MN, and additional data locations in Lexington, Kentucky, and St. Louis, Missouri.

Confidential

PeopleSoft Consultant

Responsibilities:

• Created United Healthcare enrollment/interface for the year beginning 2006 using SQR and FTP secure site processing.
• Analyzed the new total compensation WEB access process for the highly paid.
• Mapped for the self service notification of employees.

Selected Achievements:

• Implemented mapping for the self service notification of employees either going on leave of absence or returning from leave to remove or restore access to all system access.
• Created PS Query processes to validate results from benefits open enrollment elections.
• Performed analysis on the new total compensation web access process for the highly paid

Confidential

PeopleSoft Developer

Responsibilities:

• Applied modifications to existing and new processes using Application designer under release 8.8.
• Produced functional specifications to the new Doctors/Nurses.
• Applied programmed specifications to use the current SQR/SQL tool sets.
• Produced user documentation to support the new medical licensing processes.
• Built the audit reports to support the validation of the COGNOS processing applications.
• Created help aid documentation to assist the users in the execution of ad hoc processes.

Selected Achievements:

• Created functional interface processes to track and report Medical license information.
• Created functional/technical specification for converting from legacy systems to Cognos reporting data system.
• Created PS Query and WinSQL processes to validate results from Cognos reporting test results.

Confidential

PeopleSoft Application Analyst/Developer

Responsibilities:

• Executed the 2005 Open enrollment and reports for the Payroll/Benefits dept. under Release 8.3 PeopleSoft HRMS.
• Created ad hoc reports using the utility TOAD for validation and error correction of new user.
• Defined application sets in identifying employees in the various locations.
• Created the user defined employee leave accrual tracking system by pay period to validate usage and accruals.
• Created a user version of time and labor report audits and tracked by process group or individual employee.
• Processed selected tax updates and retro fit the customization in the updates

Selected Achievements:

• Produced functional how-to documentation on processing open enrollment and employee self-service.
• Created and modified several payroll application using SQR/SQL tool sets to track and report leave accruals by the employees pay period, bond activity for refunds and new pretax deduction reporting.
• Created new and modified applications using the new software STAT, this automates the development and migration of PeopleSoft applications.
• Applied outstanding PeopleSoft Patches and maintenance bundles.
• Established process scheduler run controls for the process of scheduled and ad-hoc report.
• Used the PeopleSoft Application Designer to create pages and menus to support the error analysis of identifying employees who have terminated or suspended their benefits.
• Participated in the technical testing and debugging of the latest tools upgrade.

Confidential

PeopleSoft Consultant

Responsibilities:

Rewrote several SQRs to support the user versions of PeopleSoft monthly balance pages to include pays and deductions not processed in the same month.

Created ad-hoc reports to validate earnings, tax and deduction balances.

Confidential

Non-PeopleSoft Financial Analyst

Responsibilities:

• Analyzed family financial needs and made recommendations on how to become debt free in a shorter period of time.
• Prepared the complimentary Financial Needs Analysis for review by the clients.
• Scheduled paperwork for execution of fast start mortgages and long term care proposals.

Confidential

PeopleSoft Developer

Responsibilities:

Wrote several SQRs to support 2003 Open enrollment and reports for the Payroll/Benefits department.

• Worked under Release 8.3 PeopleSoft HRMS.
• Produced audit queries to support the balancing of the annual open enrollment and 2002 year end.
• Created run control for the process scheduler of scheduled and ad-hoc report/processes.

Selected Achievements:

• Wrote SQR ad-hoc reports for the mail Services Dept. to identify employees stationed in the outlying locations.
• Created/modified online pages and menus to support the error analysis of identifying employees who have terminated or suspended their benefits.

Confidential

Non-PeopleSoft Project Analyst

Responsibilities:

• Performed fit/gap analysis to automate branch office customer list.
• Assisted in the knowledge training use of the latest MS Office Products.

Confidential

Non PeopleSoft Project Manager Analyst

Responsibilities:

• Served as Project Manager to implement a construction job cost system using CGC company software to be run on an AS400 computer.
• Supervised two other contractors on the conversion interfaces to support the job cost for construction customers also included is the interfacing functions of accts payable, accts receivable and general ledger modules.

Confidential

Team Leader PeopleSoft HRMS

Responsibilities:

• Wrote functional and technical SQR specifications to support the new 2001 interfaces to the various benefits insurance and banking vendors.
• Coordinated the three data downloads from the outsourced service center of PS objects and 2000 employee data.
• Conducted the unit/parallel tests of payroll data and customized SQRs created for Prologis Trust.
• Wrote several SQLs to support the validation process of the downloaded employee data for accuracy of content for each of the three milestones.
• Created the checklist of completed processed job to be used by the users to verify that all processes were completed and successful and the instructions of how to restart and reschedule abended or incomplete processes.

Selected Achievements:

• Served as Team Leader to migrate the PeopleSoft HRMS Payroll/Personnel release 7.51, which was performed by an outsourced service center and upgraded the PS Tools 7.54 to PS Tools 7.59. This project was place in production on the first of January 2001.
• Performed FIT/GAP in the production of the various documents to estimate the total cost of the migration of the 7.5 HRMS/Payroll/Benefits to the new data center, upgrading to 8.0.
• Created the test plans to validate the HR, Payroll and Benefits data being imported from the old vendor.
• Created the Prologis automatic scheduling of daily, weekly and monthly report and interface processes to be run under the PeopleSoft process scheduler.
• Produced functional how-to documentation adding or modifying HR and benefit data.

Confidential

GEAC/PeopleSoft Specialist

Responsibilities:

• Created the interfaces to import/export of the Open Enrollment employee elections into PeopleSoft and to the Hewitt Inc. record keepers.
• Upgraded and maintained Mc Cormack and Dodge payroll package including necessary tax updates for 47 out of the 50 states.
• Maintained Genesys personnel package including necessary system upgrades and patches as needed.
• Implemented and maintained the Old Vendor Payroll/Personnel system.
• Wrote several SQRs to support the interfaces to the various benefits insurance vendors.
• Created necessary queries and ad-hoc Reports to support the balancing of the annual open enrollment.
• Developed and maintained panels and views using the PeopleSoft tools set to support the scheduled and ad-hoc reports and to be used under other PC applications.

Selected Achievements:

• Implemented functional time and labor time clock process and setup the rules for daily and off shift processing at Ontario, California, distribution/manufacturing plant.
• Programmed the UNIX script to download and import the time and labor hours into the PeopleSoft HRMS payroll time sheets.
• Converted old payroll/personnel legacy system to PS 6.00, including old history, by writing Mainframe COBOL and DYL280 modules to load the PS current and history records.
• Designed the 401k interface system to track both pre and post contributions for Emps and Execs to observe the federal limits and automatically roll employee contributions to a post tax basis.
• Developed the test plan s scenarios to create the unit and acceptance test criteria to validate modifications to the HR, Payroll and Benefits PeopleSoft system.
• Converted the old mainframe system's absence tracking process for union and management to the current benefits absence management processing
• Wrote several SQR's to support the interfaces to the out sourced General ledger vendor Hyperion.
• Assisted as a team in the upgrade from PS 6.00 to 7.00, then to 7.51 under Oracle 7.0.