SUMMARY:

• He has 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

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)

TECHNICAL SKILLS:

Methodologies: MS Projects, Lotus Notes

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

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:

Confidential 

Acquisition Conversion PeopleSoft Technical/Functional

Responsibilities:

• 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

Confidential

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
• 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

Confidential

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)

Confidential

PeopleSoft HCM Technical/Functional ConsultantPeopleSoft Payroll Conversion Analyst 09/14 - 11/14

• 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

Confidential

PeopleSoft Payroll Conversion Analyst

• 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)

Confidential

PeopleSoft HCM/HRMS Benefits System Analyst 

• 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 sqls to 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

Confidential

PeoplSoft HCM/HRMS Conversion

• 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, Chillie, 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

Confidential

PeopleSoft HCM/HRMS Functional Payroll and Benefits Conversion

• 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)

Confidential

Responsibilities:

• 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

Confidential

PeopleSoft HCM/HRMS Benefits Administration Functional Interface Lead

• Proposed that Confidential 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

Confidential

PeopleSoft HCM/HRMS Open Enrollment Lead Developer

• 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 Confidential 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

Confidential

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

• 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

Confidential

PeopleSoft HCM/HRMS Upgrade Testing Team

• 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 Confidential 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

Confidential

PeopleSoft HCM/HRMS Benefits Customization Technical Developer

• 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

Confidential

PeopleSoft HCM/HRMS Production Support Developer

• 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