Peoplesoft Analyst
Resume:
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