Jocelyn L. Johnson

SUMMARY

Jocelyn have twenty plus years of experience working with information technology, with focus on PeopleSoft HCM/HRMS implementations, conversions, customizations, reporting and upgrades since December 1997. Working in a PeopleSoft functional and technical role combined with strong communication, organizational, planning, and technical skills to achieve professional results. The various opportunities have allowed me to maintain a strong technical background that includes a wide variety of software, languages, hardware, and operating system within various industries.

Industries:

Banking, Education, Transportation, Food and Services, Property Management, Insurance, HR, Medical, Public Energy, Publication, ADP, Financial Services, Construction Equipment Manufacture, and Staffing Company, HealthCare, Car Manufacturing, Hospital, University

Functional Areas:

Functional and Technical Specifications for HR, Payroll, and Benefits Administration, TAM, Customized Reports, Self-Services, HR Configuration, Global and North America Conversion, Workforce Development (Person Profile)

Methodologies:

MS Projects, Lotus Notes

SKILLS PROFILE

Application Development Tools:

PeopleSoft HCM/HRMS: Application Designer, Process Scheduler, PeopleTools, Peoplecode, App Engine, Component Interface, ExceltoCi, Crystal Reports, Data Mover, DMS Statements/Scripts, Projects, Query, UltraEdit

Application Package:

PeopleSoft: Payroll (North America and Global), Workforce Administration, Human Resources, Base Benefits, Benefits Administration, eBenefits, eRecruit, Reporting Tool, Self Service (Manager/Employee), Talent Acquisition Manager (TAM), Benefits Billing

Databases / DB Tools:

Unix, PL/SQL, Toad, DB2, Oracle, SQL Plus, MS Access

Desktop Tools:

MS Project, MS Office, Visio, Lotus Notes, SharePoint, HP Application Lifecycle Management, SDLC Artifact

Operating Systems:

Unix, Oracle, OS/VS, MVS, IBM Mainframe, IBM XT/AT/PC/NT

Programming Languages:

Cobol, SQR, SQL Server, Peoplecode, Microfocus COBOL

Network Software / Communications:

TCP/IP, HTTP, HTTPS, FTP

Utilities / Command Languages:

JCL, PANVALET, SPF/PC, TSO

PROFESSIONAL EXPERIENCE

A.T. Kearney

PeopleSoft Functional Analyst Conversion Project/Production Support 09/19 - 01/20

This project required writing queries converting from legacy system into Peoplesoft, writing functional designs supporting the conversions, training the Benefits, HR and Payroll team to run converted queries, and interfacing with the selected third-party vendor. PeopleSoft 9.1.

Wrote functional designs supporting converted legacy programs into Peoplesoft queries

Worked with assigned Business Owners for training and query understanding

Worked with various supporting vendors

Participated with UAT testing on all conversion

Attended various meetings

Maintained and supported production issues and inquries

Participated with cross-functionally training

Environment:

Oracle SQL, PeopleSoft HCM/HRMS: (HR, Benefits, and Payroll),

People Tools (Application Designer, Query, Oracle SQL, HP ALM, PeopleSoft SDLC)

University system of Georgia

PeopleSoft Functional Analyst 10/18 - 08/19

This project required writing queries, writing functional designs for the benefits tables, working with the setup tables within the Benefits, HR and Payroll modules, and interfacing with the selected third-party vendor. University System of Georgia is on PeopleSoft 9.2 and PeopleTools 8.56.

Writing functional designs for retirement project of various programs needed to interface to new vendor

Working with assigned Business Owners for fit gaps and mapping of data

Working with the selected retirement vendor

Creating test scripts and execution utilizing HP ALM tool

Working with setup tables, integration points and reporting

Participate in the critical thinking process

Participate in the problem-solving process

Some worked and validation required using PS Query and running SQL

Participate with cross-functionally with variety of people to accomplish set goals

Environment:

Oracle SQL, PeopleSoft HCM/HRMS: (HR, Benefits, and Payroll),

People Tools (Application Designer, Query, Oracle SQL, HP ALM, PeopleSoft SDLC)

Wells Fargo Banking

PeopleSoft Functional Analyst 12/17 - 09/18

This project required writing queries, writing functional designs and looking behind the scenes of detail HR data. Duties also include writing the QA testing scripts and working with business owners. Wells Fargo is on PeopleSoft 9.2, PeopleTools 8.56

Writing functional designs for various HR PeopleSoft data projects

Working with assigned Business Owners for fit gaps and mapping of data

Creating test scripts and execution utilizing HP ALM tool

Utilizing the SDLC model throughout the project

Attended daily meetings with various business owners to address and outstanding issues and/or questions

Unit testing all changes for JOB, PERSONAL, and PAYROLL data by working with developers

Integration testing all changes

Resolving any fallouts during testing

Worked with offshore QA testing team

Environment:

Oracle SQL, PeopleSoft HCM/HRMS: (HR and Payroll),

People Tools (Application Designer, Query, Oracle SQL, HP ALM, PeopleSoft SDLC)

Northwestern Memorial Hospital (NMH)

PeopleSoft Open Enrollment Benefit Interfaces and Acquisition Conversion 10/14 - 8/17

This project initially started as NMH 2015 open enrollment required various changes to their current benefits due to the merge with two other hospitals and bringing their employees onto the system. These changes required changes to their benefit interfaces and configuration changes. My tasks involved writing and updating the functional requirement documents, configuration, and working with the technical developer to support the changes for the benefits. Duties also include writing the QA testing scripts and working with various vendors. NMH is on PeopleSoft 9.2

Acquisition Conversion PeopleSoft Technical/Functional

Writing various interface specification documents to convert acquired company’s data into NMH PeopleSoft for data supporting, Workforce Administration, Benefits Admin, Payroll, and Workforce Development Person Profile

Working with assigned Subject Matter Experts (SME) for fit gaps and mapping of data for conversion

Converting JOB, PERSONAL, PAYROLL, Person Profile, and setting up configuration for acquired company’s data

Working mapping, loading, and creating profiles for professional employees that have license and/or certifications

Served as developer in acquisition of Hospital by utilizing PeopleSoft Component interface within an Application Engine programs.

Working on various interfaces

Meeting with various SME to ask and request more knowledge relating to the conversion

Unit testing all changes for JOB, PERSONAL, and PAYROLL data by working with developers

Integration testing all changes

Resolving any fallouts during testing

Writing various specification interface documents for BENEFITS and PAYROLL data. Also

Working with developer to resolve any outstanding questions and/or issues

PeopleSoft Open Enrollment 2016 PeopleSoft Technical/Functional

Attend benefits meetings

Updated configuration settings for benefits administration

Modify existing specification documents with new benefits specifications

Create new specification documents for new benefits vendor for 2016

Performed fit-gap analysis and retro-fitting activities for technical role

Worked with assigned developers on code changes and unit testing

Wrote QA testing scripts and tested data

Tested and validated benefit files data

Worked with various vendors for testing outbound files and receiving inbound files

Created the final outbound files to various benefit vendors

PeopleSoft Upgrade implementation 9.2 and PeopleSoft Tools 8.53 (assisted with testing)

Wrote technical specification documents for all coding changes

Made necessary coding changes for required programs (including supporting interface programs that sends benefit data to various vendors including selected 401k vendor).

Unit tested all coding changes made to ensure programs function

Executed necessary jobs to perform System test

Created and executed test scripts for 9.2 upgrade

Resolved issues detected during the testing phase with the Benefit Analyst

PeopleSoft Open Enrollment 2015 PeopleSoft Analyst/Functional

Attend benefits meetings

Attend team meetings

Updated configuration settings for benefits administration

Modify existing specification documents with new benefits specifications

Create new specification documents for new benefits vendor for 2015

Worked with assigned developers on code changes and unit testing

Wrote QA testing scripts and tested data

Tested and validated benefit files data

Worked with various vendors for testing outbound files and receiving inbound files

Created the final outbound files to various benefit vendors

Environment:

Oracle SQL, PeopleSoft HCM/HRMS: (HR, Benefits, Ben Admin, Payroll),

People Tools (Application Designer, Query, Oracle SQL)

BrookDale Senior Living

PeopleSoft HCM Technical/Functional Consultant

PeopleSoft Payroll Conversion Analyst 09/14 - 11/14

This project required working with the HRIS team to help develop solutions to their complex core modules

and Ben Admin module requirements. This project also required some technical SQRs and SQL task. Brookdale is on PeopleSoft HCM/HRMS 9.1 (A Deloitte project)

Worked with the HRIS team to gather needed information for specification documents

Wrote functional specification document for the HR and Benefit modules

Coded SQR’s and made necessary modifications to existing programs to support conversion changes

Conducted unit testing on modified code

Attending weekly status meetings

Created needed complex queries for users

Wrote QA testing scripts and tested data

Updated SharePoint documents accordingly

Environment:

SQL, PeopleSoft HCM/HRMS: HR, Ben Admin, PeopleSoft query manager

Johnson Controls, Inc. (JCI)

PeopleSoft Payroll Conversion Analyst 05/14 - 08/14

This was a global project converting from PeopleSoft Payroll 8.9 and 9.0 to Workday. My task involved writing technical requirements to convert the payroll module to Workday. Duties also included writing the QA testing scripts. JCI is on PeopleSoft 8.9, 9.0 (client server). THIS PROJECT WAS CANCELED DUE TO BUDGET.

Writing technical specification document for the Payroll module, this included global countries

Attending defect meetings to resolve defects and errors

Modifying existing specification documents to resolve identified issues with conversion runs

Wrote QA testing scripts and tested data after Workday load

Updated SharePoint documents accordingly

Environment:

Oracle SQL, PeopleSoft HCM/HRMS: (HR, Payroll (Global)), PeopleTools

(Application Designer, Query, Oracle SQL)

RANDSTAD

PeopleSoft HCM/HRMS Benefits System Analyst 08/13 - 05/14

Working on the Open Enrollment 2014 team assisting with preparation for the upcoming open enrollment for benefits and assisting with outsourcing changes to new benefits vendor. Randstad is on PeopleSoft HCM/HRMS 9.1 (client server)

Setting up benefits configuration tables for 2014 open enrollment

Preparing test scripts for benefits open enrollment testing

Writing various specification documents, documenting changes to system

Making necessary changes to vendors interface data pertaining to include new 2014 open enrollment

Updating daily and monthly reports

Preparing test scripts for outsource testing to new benefits vendor

Writing various sql needed data for testing

Working with various vendors to validate new 2014 benefits data are being interfaced correctly

Working on various mini projects assigned

Assisted with daily errors and resolutions

Wrote the custom State Mandated Leave Accrual specification document

Setup the custom State Mandated Leave Accrual testing scripts

Environment:

SQL, MS Access, PeopleSoft HCM/HRMS: (HR, Job, Benefits, Payroll),

PeopleTools (Application Designer, Query

CATERPILLAR INC.

PeopleSoft HCM/HRMS Conversion 06/11- 08/2013

Working on the US/Global Conversion Team as a PeopleSoft HCM/HRMS Team Lead/Functional/Technical and Configuration Consultant. The acquisition company was on Ceridian and Caterpillar is on PeopleSoft HCM/HRMS 8.9 and PeopleTools 8.49 (client server)

This project intent is to convert companies that were purchased through acquisitions, US and Global based. The acquisition company’s legacies HR/Job/Payroll data (Ceridian) are converted into PeopleSoft HCM/HRMS.

Participated in initial fit-gap analysis for the acquisitions

Held technical conversion meetings to discuss data transformation

Writing functional documentation to support US and global conversion for HR/JOB/ and PAYROLL data.

Writing technical templates and supporting documentation for the HR/JOB/ and PAYROLL data.

Working with users to validate converted data

Create ExceltoCi to assist with converting data

Create conversion interface programs to convert data

Attended in Kronos training with new users to understanding Kronos time entry role into Peoplesoft PAYROLL

Participated with verifying correct data was being sent on the conversion Payroll interface file to be mapped to Kronos data fields

Setup configuration of Latin America conversion population

Created conversion program and setup configuration for the Global Payroll supporting

Brazil, Chilly, Panama, Columbia, and Acuna Mexico

Validated conversion data that would feed into the payroll interfaces for the global clients

Managed offshore team by assigning tasks and test case for conversion

Traveled to various user sites to assist with fit gap analysis and give presentations

Created test scripts for conversion data

Created document for go-no-go presentation

Attend all post go-live meetings

Part of the post go-live support team

All documents are stored on secured drive

Environment:

SQR, SQL, MS (Access, Power point), PeopleSoft: (HR, Job, Payroll), PeopleTools (Application Designer, ExceltoCi, App Engine, migration, Query, Component Interface), Remedy ticketing system

Ascension

PeopleSoft HCM/HRMS Functional Payroll and Benefits Conversion 03/11 - 06/11

A member of the conversion team as a PeopleSoft HCM/HRMS Functional Payroll and Benefits Data Consultant. Ascension was on PeopleSoft 9.0. (An Accenture project)

Ascension business practice is providing Health Care to the needy throughout the United States. This project intent was to convert from Ascension’s legacy HR/Benefits system to PeopleSoft. The project was broken-down into various phases. The project was implemented on a state basis.

Writing various sql to validate the converted data.

Create various PeopleSoft reports using PeopleSoft Query tool and sql scripts to send back to the users

to validate data.

Created various MS Access databases to load the converted data and validate Payroll and Benefits

Run PeopleSoft Benefits Admin to test benefits population and assignments

Reported test results and fallouts to project manager and users for next steps

All documents are being stored in SharePoint depository

Environment:

MS Access, SQL, PeopleSoft HCM/HRMS: (HR, Payroll, Benefits, Query)

State Farm Insurance

Insurance

01/10 - 02/11

PeopleSoft HCM/HRMS 9.1 Upgrade System Analyst Developer

PeopleSoft HCM/HRMS project to Upgrade State Farm Insurance HR, Benefits, and Benefits Administration modules from PeopleSoft 8.9 to PeopleSoft 9.1

Wrote technical specification documents for all coding changes

Made necessary coding changes for all Cobol and SQR programs (including supporting interface programs that sends benefit data to various vendors including selected 401k vendor).

Made necessary JCL changes accordingly

Unit tested all coding changes made to ensure programs function

Executed necessary jobs to perform System test

Resolved issues detected during the testing phase with the Benefit Analyst

Documented any modifications required

Environment:

Cobol, SQR, Lotus Notes, JCL, SQL, DB2, MVS, TSO, JES, PeopleSoft: (HR, Benefits, Benefits Admin, Benefits Billing), TSO, Panvalet, File-Aid

Chicago PUBLIC SCHOOLS

Education

01/08 - 08/09

PeopleSoft HCM/HRMS Benefits Administration Functional Interface Lead

The Chicago Public School (CPS) System required a re-implementation of their Interface programs which utilized the PeopleSoft HCM/HRMS 8.9 Benefits and Benefits Administration modules. The project would create separate program support on a vendor bases, streamlining required data, while reducing data integrity issues found with employees’ benefits enrollment, deductions, and payments.

Proposed that Chicago Public Schools use the EDI HIPAA layout for their interfaces that would be sent to outside vendors deemed, which saved CPS money, time, and kept them government compliant

Conducted analyst by meeting with Benefits team, vendors, and Director of the Benefits Department to gather data, issues, and concerns

Conducted the fit-gap analysis phase by meeting with Benefits team, vendors, Director of the Benefits Department, and technical team to gather data, issues, and concerns

Wrote all benefits interface functional specification documents for various outside vendors

Met with Benefits team and Technical team on each specification documents

Wrote all benefits interface technical specification documents

Met with Technical team on each technical specification documents to explain and elaborate on data selection for junior developers

Created test plan documents

Created test cases

Tested interfaces with Business Analyst and vendors as a joint effort

Worked with Business Analyst and vendors to resolve any detected issues

Also resolved some payroll issues and Benefits Billing issues

Wrote various PeopleSoft Queries

Also wrote and documented supporting interface for CPS Life Insurance vendor

Environment:

Excel, Word, SQR, SQL, Process Scheduler, Oracle, Unix, PeopleSoft Queries, PeopleSoft 8.9

(The following six projects’ were under ONE CONSULTING COMPANY GNC)

Jones Lang LaSalle

Property Management/Real Estate

08/07 - 01/08

PeopleSoft HCM/HRMS Open Enrollment Lead Developer

A PeopleSoft HCM/HRMS project was warranted to prepare Jones Lang LaSalle for their 2008 Open Enrollment. The open enrollment project required new rates to be loaded and to add a new vendor for medical selection. There were also new links to be added to the open enrollment pages along with new instructional verbiage.

Created project time line and assignment of task

Updated benefits configuration tables

Added new rates to rate tables

Updated Peoplecode supporting 2008 changes

Updated the benefits text tables with modified 2008 verbiage

Updated the link pointing to the 2008 Jones Lang LaSalle Benefits handbook

Update benefits tables with new vendor information

Wrote SQR program supporting new vendor interface file

Wrote functional and technical specification documents supporting new interface

Worked with Business Analyst and created test scripts testing open enrollment 2008 changes and new interface

Created test plan with Business Analyst

Attended weekly status meetings

Participated in the post implementation support

Environment:

Peoplecode, SQR, PeopleTools, PeopleSoft: HR, Benefits Administration, eBenefits, PeopleSoft benefit tables, Unix/Oracle, SQL, MS Project, MS Excel and Word, PeopleSoft Application Designer, Process Scheduler, UltraEdit

Aegon Insurance Company

Insurance

04/07 - 08/07

PeopleSoft HCM/HRMS Self Service, HR, Learning Management Developer

Project Description Summary

Modified delivered Peoplecode supporting the Self-Service modules with Aegon customizations

Coded customized error capturing page

Created test scripts with Business Analyst

Tested customizations with Business Analyst

Created technical specification document defining customization

Attended the weekly status meetings

Environment:

DB2/MVS, SQL, Peoplecode, PeopleSoft Self-Service and Learning Management modules, PeopleTools, MS Word, PeopleSoft Application Designer, TSO, Panvalet, File-Aid

Evanston Northwestern Hospital

Medical

03/07 - 04/07

PeopleSoft HCM/HRMS Upgrade Testing Team

Project Description Summary

Developed test scripts for ePerformance, eRecruit, and Benefit modules

Created test plan with Benefits Analyst for the ePerformance, eRecruit, and Benefit modules

Also created special test scripts more custom to Evanston Northwestern Hospital with Benefits Analyst

Processed online self-Service testing

Executed Payroll calc’s and confirms

Wrote testing documentation defining testing process and results

Participated in post implementation support

Environment:

PeopleSoft: HR, ePerformance, eRecruit, TAM, MS: Project, Excel and Word, Unix/Oracle, PeopleTools, SQL, PeopleSoft Queries

Laidlaw Education Services

Transportation

12/06 - 02/07

PeopleSoft HCM/HRMS Benefits Customization Technical Developer

Laidlaw Education Services is a transportation services for the school systems. The employees drive the school buses based on the school system schedule, and not on a regular Private sector business schedule. The project was created to customize the delivered benefits deductions process according to the school system schedule without altering current PeopleSoft Benefits Admin processing.

Attended weekly fit gap and specification gathering meetings

Wrote functional interface specification document

Wrote technical interface specification document

Wrote customized benefits Cobol program which also will retrieve necessary data from customized benefits tables

Coded new SQR program to support new benefits vendor

Coded new SQR program to support GL interface program

Created new PeopleSoft pages to support customization

Created test scripts

Developed test plan to test all new programs and interface programs

Worked with Benefits Analyst during testing

Participated in post implementation and resolved all issues that arose

Environment:

PeopleTools, SQR, Microfocus Cobol, Oracle/Unix, MS: (Project, Word, Excel), PeopleSoft: (HR, Benefits, Benefits Admin), Application Designer, UltraEdit

Laidlaw Education Services

Transportation

09/06 - 12/06

PeopleSoft HCM/HRMS Production Support Developer

Laidlaw Education Services implemented a project to upgrade their current system servers. The resources for this project utilized the actual Laidlaw employees which in-turned, required additional production support resources to maintain daily issues and special projects.

Resolved daily PeopleSoft issues: security settings, password resets, added new hires, etc

Resolved ticket issues relating to HR, Benefits, Payroll

Addressed all phone called issues

Documented new issues and inserted into the issue tracking systems for the appropriate department

Closed/cleared tickets that were resolved to user satisfaction

Tested changes and fixes with user

Wrote various PeopleSoft Queries

Environment:

PeopleTools, PeopleSoft: (Application Designer, Query, Security, App Engine, Process Scheduler), Unix, Ultra Edit, Microfocus Cobol, SQR, UltraEdit

Peoples Energy Corporation

Public Energy/Electric

06/06 - 09/06

PeopleSoft HCM/HRMS Upgrade 8.9 Benefits Functional Analyst

Peoples Energy upgraded to PeopleSoft HCM/HRMS 8.9 for their HR, Benefits, and Payroll modules and needed training manual for the Call Center department on the new features and procedures. Also created a Call Center procedure manual for the step-by-step instructions corresponding from current to the new PeopleSoft HCM/HRMS 8.9 process.

Attended daily meeting with Call Center employees to gather specifications and learn their daily routine

Wrote Call Center procedure manual documenting step-by-step procedures utilizing the new PeopleSoft 8.9

Wrote the Call Center training manual outlining new 8.9 PeopleSoft features

Conducted the training class

Converted simple SQR programs into PeopleSoft Queries

Assisted with testing the eRecruit and TAM modules

Created test scripts for eRecruit and TAM testing

Created test plan working with Benefits Analyst

Environment:

MS Projects, Word and Excel, PeopleSoft Queries, PeopleSoft: (HR Benefits Admin, eRecruit, TAM), OS/MVS, DB2

Schawk, Inc.

Advertising

08/05 - 05/06

PeopleSoft HCM/HRMS Upgrade 8.9 Technical Developer

Schawk, Inc implemented an upgrade project, upgrading their current PeopleSoft HCM/HRMS HR, Benefits Admin, and Payroll to 8.9. This project required additional resources to come aboard to support upgrading Schawk’s vendor interfaces.

Attended daily meetings with the subject matter experts for data gathering

Wrote functional and technical specification documents for all vendor interfaces

Created new interfaces to support new vendors

Created new interfaces that were used to populate GL modules

Modified existing interfaces coding to support the PeopleSoft 8.9 upgrade changes

Modified PeopleSoft App Engine programs

Created a mapping document for all assigned interfaces

Worked with subject matter expert to create test plans for the interfaces

Created test scripts and test matrix

Wrote on-demand queries for analyst

Modifications were made to existing Crystal reports

Attended the interface walk-thru

Environment:

PeopleSoft tools, PeopleSoft: (App Engine, Application Designer, Security, Migration), SQR, MS Word, Unix/Oracle, PeopleSoft: (HR, Benefits Admin, Payroll), UltraEdit

Pepsi/Quaker Oats

Food and Beverages

08/03 - 08/05

PeopleSoft HCM/HRMS Open Enrollment/Production Support Technical Developer

Pepsi implemented a project to prepare the Pepsi system for Open Enrollment. New vendors where being brought onboard, new rates, and new verbiage. Also, an additional resource was needed for day-to-day production support.

Attended daily meeting with Benefits manager to gather specifications

Created data mapping document

Wrote new SQR programs that would interface requested data to the newly selected vendor.

Updated existing reports

Wrote functional and technical specification documents

Created test scripts and test matrix

Worked with vendor testing interface and transmitting

Participated in the post implementation support and resolved any issues found

Made necessary changes to all modules for Open Enrollment

Updated PeopleSoft benefit tables to support Open Enrollment

Updated SQR program inserting new Open Enrollment verbiage

Modified vendor interfaces accordingly to support Open Enrollment

Assisted with resolving daily production support issues

Assigned to smaller special projects with the Payroll and GL areas

Environment:

OS/MVS, DB2, SQR, PeopleSoft: (Tools, Queries, Application Designer, Security, HR, Benefits, Payroll, GL), SQL, Toad, TSO, Panvalet, File-Aid, JES

ADP

Payroll Servicing

06/03 - 07/03

PeopleSoft HCM/HRMS HR, Payroll, and Benefits Admin Maintenance Technical Developer

A long time ADP client was not renewing their contract with ADP. This project was created to assist and support the client by interfacing their data back into the company.

Assisted and resolve daily maintenance problems

Running on-demand PeopleSoft Queries

Creating ad-hoc report programs

Monitored nightly batch jobs

Environment:

PeopleSoft: (Tools, Application Designer, Queries, Security, HR, Payroll, Benefits Admin), SQL, Oracle/Unix, MS Word

Quaker Oats

Food and Beverages

08/02 - 04/03

PeopleSoft HCM/HRMS Customization Technical Developer

Pepsi implemented a project to bring Fidelity aboard as a savings plan vendor. This project required the resource to work with Fidelity transmitting the requested data needed for enrollment.

Attended daily meeting with Benefits manager and vendor to gather specifications

Created data mapping document

Wrote new SQR programs that would interface requested data to the newly selected savings plan Pepsi vendor. This data was retrieved from Payroll,

Created new reports displaying various stats

Wrote functional and technical specification documents

Wrote conversion program transferring current vendor data to Fidelity file layout

Created test scripts and test matrix

Worked with vendor testing interface and transmitting

Participated in the post implementation support and resolved any issues found

Environment:

OS/MVS, DB2, SQR, PeopleSoft: (Tools, Queries, Application Designer, Security, HR, Benefits, Payroll, GL), SQL, Toad, FTP, MS: Word, Excel, TSO Panvalet, File-Aid, JES

H & R Block

Tax Services

06/02 - 07/02

PeopleSoft HCM/HRMS Functional Analyst

H & R Block created a project to have their PeopleSoft HCM/HRMS system assessed. They were experiencing problems with the Payroll and Benefits processes. They were seeking suggestions and recommendations on improving the overall systems especially Payroll.

Conducted interviews with the subject matter experts in the HR, Benefits, and Payroll departments

Attended daily meetings to gathering necessary specifications and data information

Assessed current processes by partnering with a employee of each department

Wrote findings and recommendations to improve current PeopleSoft system

Wrote solution proposal with estimated cost

Environment:

MS: Word, Excel, Projects, PeopleSoft: (HR, Benefits, Payroll)

Cap Gemini Ernest and Young

Professional Services

03/02 - 05/02

PeopleSoft HCM/HRMS Interface Technical Developer

Cap Gemini cast a project to assist with splitting of the business entities into to parts. Cap Gemini would maintain business with consulting while Ernest and Young would focus on Tax Services. As a result of the separating of the company into two entities a new vendor (Fidelity) was added.

Modified existing SQR supporting interface changes

Wrote new SQR interface program supporting the data needed by Fidelity

Worked with Business Analyst on creating test scripts

Worked with Business

Contact this candidate