Peoplesoft Assistant

Stephen Keen

SUMMARY

Senior PeopleSoft Consultant

Profile: Stephen has 16 + years experience as leader in analysis, design, development and implementation of business application systems. He has 10 + years expertise in PeopleSoft Applications design and development. Stephen is a seasoned team leader with excellent interpersonal skills and is adept at interactions with end users. He has experience with upgrades, customization, implementations and Conversions for PeopleSoft 9.2/9.1/9.0/ 8.xx/ 7.xx / 6.xx / 5.xx HRMS/HCM. Stephen has experience developing with PeopleTools suite of v7.XX - 8.54

Knowledge Skills and Abilities:

Has demonstrated a high level of expertise in developing complex software applications involving new technologies methods, concepts, or approaches.

Has developed and utilized functional and conceptual design specifications with diagrammatic plans and design logic required to implement computer programs, IT systems and procedures in support of technical, administrative and information management functions and operations.

Analyzed specifications developed by a Systems Analyst for such factors as type and extent of information to be processed, designs detailing logic flow diagrams and program code

Developed extensive interfaces between PeopleSoft HRMS/ HCM and PeopleSoft Financials and Non PeopleSoft Financial systems

Extensive Reporting experience

Extensive Interface and conversions experience

SECURITY CLEARANCE - Secret

CERTIFICATIONS

C# Certification, 2013

PeopleSoft HR Certification, 1999

EDUCATION

Oglethorpe University – Atlanta

Pensacola Junior College – Pensacola Florida

University of West Florida – Pensacola Florida

Oglethorpe University – Atlanta

Major in Accounting

Minor in English

TECHNICAL SKILLS

SOFTWARE: PeopleSoft 9.2/9.1/9.0/ 8.xx/ 7.xx / 6.xx / 5.xx HRMS, PeopleSoft Financials, PeopleTools thru 8.54, SQR, PeopleSoft Time and Labor, Application Engine, Crystal Reports, nVision, Web Client, Visual FoxPro 2.6/3.0/5.0, Paradox, GEAC SmartStream, PowerBuilder, Data Mover, Dbase III/IV, MS Word/Access/Excel/PowerPoint, Visio, Convoy, Report Writer, Tree Manager, Citrix, Visual Basic, Visual Basic.Net, XML

HARDWARE: PC & Compatibles, Sun SPARC

OPERATING SYSTEMS: Sun-Solaris, MS DOS, Windows 3.x 95/98/8/10/, Windows 2000 Server and Professional, Windows NT 3.5/4.0, UNIX, Windows XP Professional

LANGUAGES: PeopleCode, SQL, COBOL, ASP, SQR, RDBMS Informix, DB2, Oracle7.x/8.x, Sybase

SERVERS: Servers: IIS, WebLogic, Tuxedo Application Server, 2000 Server

TOOLS: Tools: PS Query, Process Scheduler, Component Interface, Business Interlinks, Application Designer, Workflow, Operator and Object Security, Application Messaging Agent, Upgrade Assistant, Import Manager, Application Engine

EXPERIENCE

Peoplesoft Consulting, Inc, Atlanta, Ga 11/2015 – 12/2015

RBL Trinidad Tobago

Responsible for PeopleSoft HCM v9.2 and PeopleTools v8.54 installation to servers

Installation of Peopletools and SQL Server Instances on Windows OS Vanilla, Development, Test, Preproduction

Peoplesoft Consulting, Inc, Atlanta, Ga 11/2014 – Present

SQR Services, PeopleSoft HCM/HRMS SME

Responsible for the upgrade/integration PeopleSoft HCM v9.2 along with PeopleTools v8.54

Review and analyze table and field structures to integrate within PeopleSoft

Utilized SQR for reporting

Hewlett-Packard, Alpharetta, Ga 08/2011 – 11/2014

PeopleSoft Lead, Techno-Functional Analyst

Served multiple capacities for HP’s Enterprise Services business unit supporting multiple clients for PeopleSoft/PeopleTools services work.

Department of Defense

Part of a team that developed new and modified existing PeopleSoft pages and PeopleCode. These were developed outside any Peoplesoft module. The number of pages that the team modified, or created numbered in the thousands. Team members were given segments of applications that were called stories. Each story was a process or workflow that was programmed via pages. Based on user security any action that were selected on the page, certain fields were either grayed out, validated for profile, or allowed to save the application. At the end of the allotted time, the developer demonstrated the story to the client. The application was accepted, or rejected with more changes required.

GM

Project Lead - PeopleSoft HCM

As Project Lead, I was responsible for a 4 person team from design to user acceptance. The team consisted of both onshore/offshore resources to use a 3rd party website where applicant personal information, along with departmental and salary information was saved. Once the applicant accepted the position then information required to hire that person would be selected, validated and then inserted into tables then emails sent to appropriate managers. All correct and verified information would then be cross-referenced and saved within GM’s PeopleSoft HCM/HRMS Core HR module.

Developer - PeopleSoft HCM

As Developer I tested and identified SQR’s that were not operating in an accepted amount of time. I modified SQR’s either in selecting the correct field from a new table, or indexing the table, or inserting hints in the SQR. Testing involved a couple hundred SQR’s in multiple instances then comparing tables in both production and update instances for verification with PeopleSoft HCM/HRMS Core HR module.

River Road

Server Documentation Specialist

Used Sharepoint site to document Server builds, and verify applications on server farms were consistent with HP requirements for gold support. Some software was not server compliant (Gold level) and had to be documented as non compliant for disaster recovery teams to know not to restore during the disaster recovery period. Document the de-installation and installation of servers from one server farm to another.

Dollar Thrifty Rental Car

Technical Lead - PeopleSoft HCM

As Technical lead I coordinated with the PeopleSoft DBAs to perform software and Tax updates and to update to current releases of applications. I implemented the use of and the administration of Sharepoint to facilitate multiple tax updates and multiple Software updates to coincide with Federal and State tax codes and updates. Worked closely with the DBA to verify current architecture and correct architecture so that updates would be more streamlined and to increase performance within Dollar Thrifty’s PeopleSoft HRMS Core HR functionality.

Verizon Wireless, Boston, MA 06/2010 – 06/2010

Technical Resource – PeopleSoft HCM

1 month project where I was brought in for a specific portion of Verizon’s PeopleSoft customization. I created a stack of SQLs for identifying data that needed to be reviewed for cleanliness/accuracy. I created SQLs that inserted into spreadsheets location of tables by instance name and location of tables for specific upgrades that were to be performed. I created/populated a spreadsheet for questions and answers regarding Data Analysis. I created delete SQLs for all non production instances for orphan records in tables for specific upgrade to be used in conjunction with information stored within PeopleSoft HRMS/HCM Core HR and Benefits/Admin modules.

ADP, Atlanta, GA 10/2008 – 12/2008

SQR Reporting and Interfaces - Enterprise

Responsibilities:

Wrote technical specifications for SQR HR / Payroll reports and interfaces

Worked with functional team to develop technical specifications for the ADP Enterprise implementation

Testing of SQR

Migration of projects through the life cycle

Environment: SQR HR, SQR Payroll reports

Baptist Hospital of Louisville, Louisville, KY 09/2007 – 05/2008

Senior PeopleSoft Consultant

Responsibilities:

Performed conversion of HRMS 8.8 to HRMS 9.0 – Campus Solutions

Upgraded PeopleTools 8.47 to 8.49.xx

Used Change Assistant, Compare reports, Application Engine, Datamover, SQL Trouble shooting, Tax upgrades, Application Engine modifications and SQR modifications

Installed Vanilla HRMS 9.0

Performed cross compare reports, worked in development of xml reporting

Upgraded tools across all instances to 8.49.07

Installed and upgraded Tax updates to be consistent across all instances

Upgraded tools to 8.49.10 across all instances and brought Tax updates to current

Ran compare reports and evaluated reports and eliminated vanilla – no change items and sent remainder to team

Application Engine programs modified as well as Datamover scripts changed, updated and corrected

Environment: HRMS 8.8, HRMS 9.0, Change Assistant, Compare reports, Application Engine, Datamover, SQL Trouble shooting, Tax upgrades, Application Engine modifications, SQR modifications, Installed Vanilla HRMS 9.0

Time Warner Cable Inc, Charlotte, NC 05/2007 – 07/2007

PeopleSoft Consultant

Responsibilities:

Wrote technical specs for offshore conversion of SQR’s

Reviewed Mods from 8.3 wrote specs for 8.9 conversion

Client cancelled offshore development and shifted SQRs to in-house effort

Changes took one week with team of four

Environment: SQR, PeopleSoft HR 8.3, PeopleSoft HR 8.9

SQR Services Inc, Athens, GA 06/2005 – 05/2007

PeopleSoft Consultant

Worked with PeopleSoft HR versions 7.6, 8.1 and 8.9

Developed customized SQR Reports

Modifications to customized SQR’s

Worked mainly with utility SQR’s and SQC’s for previous clients

Provided reports and interfaces to third party applications

Developed customized Application Engines for versions 8.1, 8.3

Environment: PeopleSoft HR 7.6, 8.1 and 8.9, SQR Report, SQC

Knoxville Utilities Board, Knoxville, TN 11/2004 – 06/2005

PeopleSoft Consultant

Responsibilities:

Worked with PeopleSoft CIS for Utility Companies version 7.6 and 8.1

Developed customized SQR, Crystal reports for both versions of CIS

Applied 25+ APRD’s to 8.9 CIS for Utility Companies using Change Assistant

Modifications to customized PeopleCode as well as new PeopleCode

Worked with team of ten to assist in upgrading to version 8.9 CIS (which included modifications to Time and Labor module)

Revised and tested Queries in 8.9 databases which were both SQR’s and Crystal Reports

Prepared reports using XML

Environment: PeopleSoft CIS 7.6 and 8.9, Change Assistant, Crystal Reports

Merck Pharmaceuticals, Whitehouse, NJ 04/2004 – 11/2004

Conversion Lead

Responsibilities:

Supervised staff of 4 individuals is final phase of conversion process

Conversion utilized both SQL PLSQL and SQR’s in converting multiple diverse legacy data systems into the final version of PeopleSoft in a 8.8 environment

Developed Component Interfaces for conversion of legacy system data

Customization of Time and Labor module

Environment: SQL PLSQL, PeopleSoft 8.8, Legacy

Siemens Shared Services, Orlando, FL 10/2003 – 04/2004

Technical Support Developer

Responsibilities:

Production support and new development for Siemens Shared Services (Siemens supports upwards of 40,000 employees under 30 companies)

Involved in both new and Payroll support of Interfaces, people Code, App Engine, and pages

Tech Lead in Tax Upgrade 03G – F, 04-A

Customized Garnishment pages

Extensive SQR’s with customized upload of Garnishment system to Proprietary Financial system including uploads and downloads back to garnishment system

Environment: PeopleCode, App Engine, Pages, Tax Upgrade 03G – F, 04-A, SQR

ADP, Atlanta, GA 06/2003 – 10/2003

Technical Specs Enterprise

Responsibilities:

Wrote technical specifications for SQR HR / Payroll reports and interfaces

Worked with various teams to develop technical specifications for the ADP Enterprise implementation

Testing and re-writing of SQR’s submitted by off shore partners

Migration of projects through the life cycle

Extensive use of Application engine programs

Environment: SQR HR, SQR Payroll reports

IBM, Dayton, OH 10/2002 – 04/2003

Interface Lead

Responsibilities:

Coordinated SQR interfaces for a six person interface team implementing PeopleSoft 8.3. from version 7.5 Payroll and HR interfaces included New time and Labor, New Benefits vendor, New employment verification system

Changed customized interfaces to reflect new field names and changes to existing tables (Interfaces design had to take into account Merging companies from two different PeopleSoft 7.5 implementations upgrading to version 8.3 with new vendors)

Tested, Approved and performed signoffs for employees who were to be production support after go live

Modifications to Time and labor modules for 7.5 and 8.3 for both contingency and go live for Merger and upgrade

Environment: PeopleSoft Version 7.5, PeopleSoft Version 8, SQR

ADP, Atlanta, GA 08/2002 – 09/2002

Technical Specs Enterprise

Responsibilities:

Wrote technical specifications for SQR Payroll / HR reports and interfaces

Worked with a team of five people to develop technical specifications for the ADP Enterprise implementation

Environment: SQR Payroll, SQR HR reports

AFLAC Inc., Macon, GA 10/2001 – 07/2002

PeopleSoft Consultant

Responsibilities:

Reviewed and modified 40+ payroll / HR SQRs

Developed 5 major interfaces

Wrote specifications and coded SQRs to emulate delivered benefits administration processes (Some of the major areas of development were of Applicant Tracking, Benefit Administration, and Insurance interfaces)

Testing

Environment: PeopleSoft HRMS version 8, HR SQR

Maersk Inc., Morristown, NJ 07/2001 – 10/2001

PeopleSoft Consultant

Responsibilities:

Customized multi-company/multi-national journal entry system involving SQR payroll / HR development interface

Designed and coded SQRs to determine employee eligibility and price benefit options, monitor and report employee online application interaction, and load employee selections into base benefits tables, testing

Developed specs and General Ledger interface for PeopleSoft version 7.5 and version 8. Testing

Environment: PeopleSoft Version 8

Maxim Group, Atlanta, GA 08/1999 – 07/2001

PeopleSoft Consultant

Responsibilities:

Developed SQR interface between third party billing system and PeopleSoft Financials month-end automated accrual and reversal of journal entries, Testing

Developed leasing/property management system, Testing

Extensive use of Application designer, PeopleCode, Testing

Provided initial estimates for SmartStream 6.0.2 customized reporting requirements for financial applications

Designed detailed functional, technical and program specifications

Created unit test plans and monitored test procedure execution

Employee Self service implementation and modification

Installed PeopleSoft 8.1 Use and correction of Datamover scripts and Application engine programs

Environment: PeopleSoft Version 7.5, 8.1

PeopleSoft Inc., Atlanta, GA 03/1998 – 08/1999

PeopleSoft Consultant

Responsibilities:

Partnered with client technical team members to provide SQRs for termination, headcount, retention and employee review reporting

Performed panel changes for requisitions along with SQR for tracking requisitions and budgeted jobs

Assisted in review of current queries and conversion/rewriting of queries for globalization

PeopleSoft HRMS 7.5

Reviewed clients’ Business Unit, Set id, and Security setups and made recommendations on “go live” dates

Provided assistance with Payroll Interface setup

Partnered with client technical and functional team members to scope and provide initial estimates for all requirements, interfaces, and conversion programs and to complete application

Ensured interface, reporting and conversion tasks were accurately integrated into project plan

Led data conversion methods, mapping development and testing

Completed critical programming task

Drafted technical design documentation based on functional design documentation

Production support – Security setting up new users

Employee Self service implementation and modification

Environment: PeopleSoft HRMS 7.0, PeopleSoft HRMS 7.5

Renaissance Group, Atlanta, GA 01/1998 – 03/1998

PeopleSoft Consultant

Responsibilities:

Performed as a Liaison between Data Migration and Conversion technical teams on behalf of banking regions

Developed complete asset deployment/tracking processes

Developed Access programs for special needs of project coordination team

Presented data conversion process to regional bank management teams

Provided special training for PeopleSoft deployment

Security

Environment: PeopleSoft, Crystal Reports

Lockheed Martin Aerospace, Atlanta, GA 11/1997 – 01/1998

Consultant

Responsibilities:

Developed client server-based provisioning system for C-130J

Environments: SQL, SQR, Visual FoxPro 3.0/5.0, Windows 95/NT 4.0, Sybase

Equifax Inc., Atlanta, GA 01/1996 – 11/1997

Responsibilities:

Improved and enhanced existing applications

Developed United Way application, Family Medical Leave Act application, Short Term Disability application, Telephone Billing and Reporting system, and Year End Bonus application

Performed data mapping and conversion

Supported year-end COBRA enrolment and all enhancements

Environment: SQL, SQL, Visual FoxPro 2.6 (Windows/DOS)

Field Data, Conyers, GA 06/1996 – 10/1996

Responsibilities:

Concurrent with Equifax Contract

Visual FoxPro Windows NT

Improved and enhanced existing communications package and developed main host interface

Environment: Visual FoxPro Windows NT

Lockheed Martin Aerospace, Atlanta, GA 01/1995 – 01/1996

Responsibilities:

Improved and enhanced existing F-22 PRIDE provisioning system applications, including development of Bill and Materials section

Developed spares calculation application for C-130J to determine required number of spare parts retained in inventory based on flight hours, variable failure rates, and repair cycles

Created triggers to populate Sybase tables

Environment: SQL, Crystal Reports, FoxPro 2.6 Windows and DOS, PowerBuilder

General Electric Information Systems, Atlanta, GA 03/1993 – 01/1995

Responsibilities:

Developed tracking and recording system that tracked bids by end user companies to purchase natural gas

Assisted in development of sales and marketing database application

Environment: SQL, FoxPro 2.6 Windows, Paradox

Centers for Disease Control, Atlanta, GA 08/1991 – 11/1992

Responsibilities:

Developed EEOC reporting for human resources department

Environment: SQL, FoxPro 2.6 Windows, Paradox

Sun Microsystems, Atlanta, GA 1991

Dbase IV Developer

Marketing Communication Networks, Atlanta, GA 1990 – 1991

MIS Director

U.S.A. Programming, Atlanta, GA 1986 – 1998

Programmer

Contact this candidate