SUMMARY:

• 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)
• Methodologies: MS Projects, Lotus Notes

TECHNICAL SKILLS:

Application Development Tools: PeopleSoft HCM/HRMS: Application Designer, Process Scheduler, PeopleTools, Peoplecode, App Engine, Integration Broker, Component Interface, ExceltoCi, Crystal Reports, Data Mover, DMS Statements/Scripts, Projects, Query, Ultra Edit

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 11g, 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, Micro focus COBOL

Network Software/Communications: TCP/IP, HTTP, HTTPS, FTP

Utilities / Command Languages: JCL, PANVALET, SPF/PC, TSO

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Acquisition Conversion PeopleSoft Technical/Functional

Responsibilities:

• Writing various interface specification documents to convert acquired company’s data ( LAWSON ) 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 LAWSON data for conversion
• Converting JOB, PERSONAL, PAYROLL, Person Profile, and setting up configuration for acquired company’s LAWSON 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

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 (BCBS, CIGNA, VOYA, VSP, etc.)

Environment: Oracle SQL, PeopleSoft HCM/HRMS: (HR, Benefits, Ben Admin, And Payroll), People Tools (Application Designer, Query, Oracle SQL)

Confidential

PeopleSoft HCM Technical/Functional Consultant, WI

• Worked with the HRIS team to gather needed information for specification documents
• Wrote functional specification document for the HR and Benefit modules and Workforce Administration
• 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

Confidentia l

PeopleSoft Payroll Conversion Analyst, WI

• Writing technical specification document for the Payroll module, this included global countries
• Attending defect meetings to resolve defects and errors and workforce administration.
• 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 9.0 /HRMS: (HR, Payroll (Global)), PeopleTools,n(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
• Integration Broker
• Preparing test scripts for outsource ( ADP ) testing to new benefits vendor
• Writing various SQL’s 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 9.0 /HRMS: (HR, Job, Benefits, and Payroll), PeopleTools (Application Designer, Query

Confidential

PeopleSoft 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.
• Worked with the integration tool mapping Mexico’s data to send the outsourcing payroll vendor
• Writing technical templates and supporting documentation for the HR/JOB/ and PAYROLL data.
• Working with users to validate converted data from Ceridian to PeopleSoft
• 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, Chile, 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 9.0 /HRMS: (HR, Payroll, Benefits, and Query)

Confidential

System Analyst Developer

• 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
• Time and Labor (T & L)
• Worked with BI Publisher.
• Integration Broker
• 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, Pan Valet, File-Aid

Confidential

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
• Time and Labor (T & L)
• Worked with BI Publisher.
• 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

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
• Time and Labor (T & L)
• 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, Ultra Edit

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, Pan valet, File-Aid