Experience Summary:

• Over 12 years of PeopleSoft experience in design, development, implementation, and support.
• Served on full life-cycle implementations, upgrades, customization and production support projects.
• Demonstrated leadership abilities and broad technical expertise with deep technical knowledge in design, development, support, and implementation of a wide variety of PeopleSoft products and modules.
• Ability to work within a team environment.
• Ability to be flexible and change direction at a moment’s notice.
• Excellent customer skills and ability to understand and communicate customer issues
• Strong oral and written communication skills with ability to communicate and interact with management, vendors, business clients, and partners.

Skills Summary

Operating System:

UNIX, Windows, Mainframe

Languages & Tools:

PeopleTools 8.50, 8.49, 8.4x, 8.x, 7.x, PeopleSoft 9.0, 8.9, 8.8, 8.x, 7.5, 7.x, PeopleCode, Portal, Application Designer, Application Engine, Component Interface, Process Scheduler, Security Administrator, Application Packages, Integration Broker, PeopleSoft Utilities, Tree Manager, Data Mover, File Layout, Configuration Manager, Application Server, XML

Reporting Tools:

XMLP Publisher, SQR, nVision, Crystal Reports, PS/Query

Database:

Oracle 10g, 9i/9.0, 8i/8.0, SQL Server, DB2, Informix

Web / Application Server:

BEA (Weblogic)

PeopleSoft Modules:

(Student Admin (SA) – now called Campus Solutions – including Campus Community, Student Records, Financial Aid, Admissions, and Courses). PeopleSoft FSCM, General Ledger(GL), Accounts Payable(AP), Accounts Receivable(AR), Billing(BI), Human Resources (HRMS), Human Capital Management (HCM), Payroll, Base Benefits, Benefit Administration, Employee Self-Service modules, Recruiting, Asset Management(AM), Purchasing (PO), Order Management (OM), Inventory(INV), Workflow (WF), Expenses(EX), Treasury (TR)

PROJECTS

Client: Confidential, Chicago, IL
February 2011-Present
Scope:
PeopleSoft Campus Solutions Production Support 9.0/PeopleTools 8.5

Responsibilities:

• Troubleshooting and resolving Production Support tickets for DePaul University. Areas within Campus Solutions including Campus Community, Student Records, Financial Aid, Academic Advising, Admissions, and Student Financials.

Client: Confidential, Dallas, TX
August 2010-February 2011
Scope:
PeopleSoft Campus Solutions Implementation 9.0/PeopleTools 8.5

Responsibilities:

• Created an Application Engine program which populated a custom table that held Student Health Insurance data and allowed Student Health Insurance link to be displayed on the Student Center.
• Developed a custom Student Financials Self-Service Health Insurance form which allowed students to enter their information on-line. Once the form was completed, 3Cs, the custom table, Service Indicators were updated.
• XMLP report developed allowing the student to keep hard copy of Health Insurance form.
• Created an Application Engine process and custom table to hold student Promissory Note Data and allowed the Promissory Note to be viewable through the Self-Service Student Center page. The student completed the form and upon submission, 3Cs were updated and the student had an option of printing a copy of the completed Promissory Note (XMLP Report)
• Certain Academic Programs at UT-Southwestern Medical required that students having been administered immunizations prior to enrollment. On the Self-Service Student Center page when a student would try to enroll, they would be re-directed through a series of custom built pages which required the student\'s completion or acknowledgment. Once this had been done, the student would be taken to the PeopleSoft delivered self-service enrollment pages. The next time the student tried to enroll because he/she had completed/acknowledged the immunization forms, the student would instead be taken directly into the PeopleSoft delivered self-service enrollment pages.

Client: Confidential, Richmond, VA
January 2010-September 2010
Scope:
PeopleSoft Campus Solutions Version 8.9/PeopleTools 8.49.

Responsibilities:

• Created custom pages using Portal PeopleTools and PeopleCode. These pages integrated with delivered Student Records and Enrollment. Used by colleges to validate students who have Veteran status.
• Created custom SQR and Crystal reports tracking Veterans info based on the pages created above, student enrollment, and student grades.
• Created inbound Portal Application Engine interface that reads XML files and updates student’s 3Cs and checklists.
• Created custom Application Engine process that assigns student communication (Communication Record) based on run control page parameters.
• Customized Faculty/Instructor Portal Self-Service pages utilizing PeopleTools and PeopleCode to accommodate VCCS business needs.
• Created inbound Portal Application Engine to read state identification inbound file and update VCCS’ PeopleSoft system.

Client: Confidential, New Hyde Park, NY
July 2009-January 2010.
Scope:
PeopleSoft FSCM Release 8.0/9/0 upgrade Tools Release 8.49, Oracle 10g, UNIX, AutoSys. Modules included: GL, AP, PO, BI, AR, PC, AM, eProcurement

Responsibilities:

• Updated PeopleSoft Portal delivered and client custom processes to ensure compatibility for PeopleSoft version 9.
• Created UNIX shell scripts to FTP files to/from client to hosted Oracle On-Demand PeopleSoft application.
• Updated AutoSys scripts to ensure compatibility including machine names, steps, PeopleSoft processes for version 9.0.
• Tested and resolved any incompatibility issues with PeopleSoft/AutoSys scripting between PeopleSoft 8.0 and 9.0.
• Production support with post-live PeopleSoft Financials Portal 9.0, Oracle On-Demand. Using PeopleTools, PeopleCode, Component Interface (CI), SQR, Oracle 10g.

Client: Confidential, Dallas, TX
March 2009- September 2009
Scope:
PeopleSoft HCM Release 8.9, Tools Release 8.47, Oracle 10g, UNIX, Authoria

Responsibilities:

• Created an HR interface using SQR and Application Engine extracting PeopleSoft Portal HCM 8.9 data into a pipe-delimited file so that client can import into a third party Talent Acquisition (TAM) tool. (Authoria).
• Used DMS scripting as needed to update, insert, delete data while unit testing.
• Created PS Portal Security roles and permissions for newly created PeopleSoft customizations.
• Created associated run-control page, record, menu, and component using PeopleTools, Portal and PeopleCode for this HR Interface.
• Created a Portal Component Interface to extract data from a third-party tool back into PeopleSoft.

Client: Confidential, Evanston, IL
October 2006- December 2008
Scope:
PeopleSoft Student Administration (SA)(now called Campus Solutions) 8.22.05-8.49, Oracle 10g Database Customizations, SunOs 5.10
PeopleSoft Upgrade Tools (8.22 to 8.49), Release (8.2 to 9.0)
Modules: Self-Service, Student Records, Student Financials, Financial Aid

Responsibilities:

• Developed 30 custom Portal Self-Service/Student Administration pages (using PeopleTools, PeopleCode, Application Engine, and Workflow) allowing Graduate School students to automatically apply for Degree and Thesis completion (TGS Forms project).
• Created a custom on-line Portal Financial Aid application for all Undergraduate students utilizing PeopleSoft delivered 3C’s.
• Used DMS scripting as needed to update, insert, delete data while unit testing.
• Created PS Portal Security roles and permissions for newly created PeopleSoft customizations.
• Developed 5 on-line Portal pages (PeopleTools, PeopleCode) capturing Northwestern’s Tuition Payment plans for students.
• Developed a Portal Component Interface (CI) capturing the Tuition Payment Plan from the custom pages to populate the Group Data Entry Component for posting.
• Retrofitted PeopleSoft version 8.22 client Portal customizations to 8.48 Toolset (PeopleTools, Application Engine (AE), PeopleCode, Component Interface (CI) in Student Records, Financial Aid, Student Financials, and Self-Service from the Oracle upgrade lab.
• Retrofitted and updated for version 9 custom PeopleSoft Portal application for Northwestern’s School of Continuing Studies Non-Credit program. System provided self-service access from a webpage to the creation of the student in PeopleSoft. All processing was completed behind the scenes various Component Interfaces within Peoplecode.
• Assisted in setup and configuration of Integration Broker which allowed the self-service School of Continuing Studies non-credit to establish his/herself on the LDAP directory by using a synchronous message. Completed through the consumption of a Webservice.
• Developed a bolt-on PeopleSoft CTEC (Course and Teacher Evaluation Council) application using PeopleTools, Rowset Peoplecode and Application Package technologies. This provided an on-line mechanism for students to evaluate courses and instructors.
• Developed several XMLP Publisher reports for the bolt-on PeopleSoft CTEC application including individual instructor and TA reports, and department chair reports.
• Participated in the fit/gap and functional requirements on many new projects listed above.
• Troubleshoot/resolved Production Support issues as assigned.

Client: Confidential, Virginia Beach, VA
July 2006- October 2006
Scope:
PeopleSoft HCM Upgrade 8.3 to 8.9/PeopleSoft Financials Upgrade 8.0 to 8.9. PeopleTools Release 8.47.05, Windows NT with Microsoft SQL Server.
Modules: Core HR, Benefits, Payroll, Time & Labor, Recruiting, Talent Acquisition Manager, ELM, GL, AP, AM, PO

Responsibilities:

• Develop 8 custom HCM Benefits SQR’s for Amerigroup including Event Triggers, ABBR Update, and Benefit-Tier Updates.
• Fix, modify, and customize delivered and non-delivered PeopleSoft objects (Core HR, Recruiting, Benefits, Payroll, Time & Labor) to insure compatibility and functionality between PeopleSoft 8.3 and 8.9. Tools used were PeopleTools, PeopleCode, SQR, Application Engine, and Application Packages.
• Created and executed Data Mover Scripts to bring over data from 8.3 to 8.9

Client: Confidential, Chicago, IL
April 2006- July 2006
Scope:
PeopleSoft 8.9 HCM Implementation (Human Resources(HR), Benefits, Payroll. The environment is PeopleSoft (Tools 8.46, 8.9 Financials Oracle Database on UNIX.)

Responsibilities:

• Participated in Requirements Gathering, Fit/Gap Analysis and initial functional design/customization of CPS’ new PeopleSoft HR system.
• Created conversion SQR’s to load foundation HR (Location, Department, Salary Plan, Salary Grade, and Job Code) tables.
• Created a SQR to convert Personal Data information from their legacy systems into PeopleSoft.
• Participated in the construction of a SQR that read legacy data and loaded into Oracle conversion staging tables.
• Assisted client in knowledge transfer process. Helped them learn PeopleTools, PeopleCode, Query, and SQR.

Client: Confidential,Chicago, IL December 2005- February 2006

Scope:
Production Support and on-going system customization/maintenance work of PeopleSoft System. The environment is PeopleSoft (Tools 8.4514, 8.8 SP1 HCM, DB2 database on OS-390 Mainframe.)

Responsibilities:

• Developed a PeopleCode customization within the eRecruit Module to prevent multiple Social Security numbers from appearing in the Identity/Diversity tab in the Job Data Applicant Component.
• Developed a PeopleCode customization within Position Management to prevent on-line errors when trying to reclassify a job to a different department in a different company.
• Developed a SQL data cleanup script that set the Referral Application Date equal to the Applicant Data Application date which resolved buffer errors that occurred when entering applicant data on existing employees.
• Customized a GL Interface SQR to fix an issue where the earnings code was going to the wrong GL expense code.
• Created 4 Application Engine programs which cleaned up the client’s Benefit Event Maintenance processing. Prior to this the procedure was completed manually.

Client: Confidential,Chicago, IL September 2005-November 2005

Scope:
The scope of this short-term 2 month project was to implement a custom PeopleSoft HR Stock Administration Module using a combination of the delivered module and custom Equity Office objects. PeopleSoft’s Human Resources (HRMS) on (Tools 8.20.13, Application Release 8.3, Microsoft SQL Server 8.00.194.

Responsibilities:

• Translated Functional Specs into Technical Specs.
• Maintained a close working relationship with functional experts in the modification of functional/technical specs, development, system, regression, and unit testing.
• Developed, coded, and unit tested custom and delivered mods throughout all of PeopleSoft’s HR Stock Administration and GL Interface modules.
• Worked extensively with Application Designer (PeopleTools, PeopleCode) to modify and/or create record and field definitions, Pages, Components and Menus in the development of the above processes.
• Developed custom Equity Office Properties reports and processes surrounding the HR Stock Administration Module.

Client: Confidential,Chicago, IL October 2004-August 2005

Scope:
The scope of this project is to implement PeopleSoft’s Student Administration (Tools 8.20.05, App 8.2, Oracle 8.17, Unix Compaq TRU64 Unix V5.1B) module including Student Records, Financial Aid, Student Financials, and Campus Community.

Responsibilities:

• Translated Functional Specs into Technical Specs.
• Maintained a close working relationship with functional experts in the modification of functional/technical specs, development, system, regression, and unit testing.
• Developed, coded, and unit tested custom and delivered mods throughout all of PeopleSoft’s Student Administration module (Student Records, Financial Aid, Student Financials, and Campus Community).
• Worked extensively with Application Designer (PeopleTools, PeopleCode) to modify and/or create record and field definitions, Pages, Components and Menus in the development of the above processes.
• Developed custom City Colleges of Chicago Financial Aid and Student Record processes using SQR and Application Engine.
• Involved in data and objects migrations across all the database instances uniform and unique (DEV, INT, CN, STG, UAT and Production Environment- PRD)
• Involved in conversion of data to load and unload Student Record Tables using SQR’s from the legacy system and excel sheets
• Mentored junior developers by assisting them with questions and development of their assigned modifications.
• Fixed data-related issues across the development and various testing environments using PeopleSoft’s Data Mover and Oracle’s Export Utility.
• Used FTP utility to migrate developed SQR’s to the correct file server.
• Administered/configured Application Server within the development environment when necessary (boot, clean cache, configure configuration file).
• Supported end-users during UAT (Unit Acceptance Testing) and post-production/change management issues.

Client: Confidential,Deerfield, IL August 2004-October 2004

Scope:
Query cleanup and consolidation of user ad-hoc queries within PeopleSoft HRMS. Baxter had given employees free reign in developing queries for reporting and data analysis. The goal was the consolidation of duplicate queries and to establish controls for the creation of further queries. The environment was PeopleSoft (Tools 8.17, Application 8.0) and Oracle 8.14 database.

Responsibilities:

• Analysis of existing user ad-hoc queries surrounding PeopleSoft HRMS including the modules of Human Resources, Payroll, Base Benefits, and Benefits Administration.
• Consolidating and combining duplicate queries across all Business Units.

Client: Confidential,Lincolnshire, IL Jan 2004-August 2004

Scope:
The scope of this project is to implement Sarbanes-Oxley (SOX) controls across the organization to comply with the Federal Government regulations and how it relates to PeopleSoft systems. Specifically PeopleSoft Workflow and a custom calculation tool were implemented for greater financial control across the Time and Charge Entry system.

Responsibilities:

• Designed, developed, coded, configured, unit tested and modified PeopleSoft Workflow for Hewitt’s Fee System.
• Designed, developed, coded, configured, unit tested a new tool for associates to assess there percentage of completeness (hours spent, revenue generated) for a specific project.
• Worked extensively with Application Designer (PeopleTools and PeopleCode) to modify and/or create record and field definitions, Pages, Components and Menus in the development of the above processes.
• Closely worked with the development/IS team during the construction of these tools
• Supported end-users during UAT (Unit Acceptance Testing) and post-production/change management issues.

Environment: PeopleSoft 8.4(Financials, HR, Time/Charge Entry), PeopleTools 8.43, PeopleCode, SQR, Process Scheduler, Utilities, Tree Manager, PS/Query, Security Administrator, Informix, UNIX.

Client: Confidential,Westmont, IL August 2003-February 2004

Scope:
The scope of this project was to combine two separate Business Units/databases from a merger of two separate transportation/logistical companies. Conversion of SQL Server to Oracle was a part of this process as well. After this was complete on PeopleSoft 7.5, then upgrade the new system to PeopleSoft 8.4.

Responsibilities:

• Executed and fixed application and tools errors from Sysaudit and DDDaudit reports as part of upgrade
• Created SQL, Data Mover, and SQL Loader scripts as part of upgrade.
• Fixed and cleaned up any data/tools related issues to the upgrade.
• Created NT shell script that notified administrator that the Application Server was down.
• Installed and configured the PeopleSoft application including BEA Weblogic server, PeopleBooks, and PeopleTools.
• Installed and configured client workstations with PeopleSoft for end-users.
• Downloaded and applied patches/fixes to PeopleSoft in the upgrade process.
• Created Oracle Export scripts to backup the database on a scheduled basis.
• Created Data Mover scripts to backup specific PeopleSoft data on a scheduled basis.
• Extensively worked with Application Designer to modify the record definitions, Pages, Panel Groups, Menus, Process Definitions, and Security Administrator.
• Worked closely with end users during UAT (Unit Acceptance Testing)
• Worked closely with end users during the conversion of SQL Server to Oracle.
• Modified GL Activity SQR Reports to retrofit in new PeopleSoft 8.4 environment.
• Boot the Application Server when necessary.

Environment: PeopleSoft 7.5, 8.4 Tools (Financials) 8.8 Application Release, PeopleTools, PeopleCode, Tree Manager, SQR, Crystal Reports, Process Scheduler, nVision, Utilities, Oracle, Microsoft SQL Server and Windows NT

Client: Confidential,Worcester, MA June 2003-August 2003

Scope:
The scope of this project was the implementation of PeopleSoft 8.4 Financials/Supply Chain at a New England utility company in partnership with a Big Five firm.

Responsibilities:

• Design and coded General Ledger chartfield interfaces using Component Interface, Application messaging and Integration Broker. The external systems were mainframe, 2-tier, or 3-tier type.
• Design and coded GL account validation and derivation interface from external systems into PeopleSoft using Component Interface and Integration Broker.

.
Environment: PeopleSoft 8.4 Tools, Application Release 8.8 (Financials, PeopleTools, PeopleCode, Tree Manager, SQR, Component Interface, Application Messaging, Process Scheduler, Utilities, Oracle and Windows NT)

Client: Confidential,Miami FL March 2003-June 2003
Scope:
The scope of this project was the implementation of PeopleSoft Financials 8.4 with Workflow at a private healthcare company in partnership with a Big Five firm.

Responsibilities:

• Created and implemented a completely custom PeopleSoft Workflow application within the Accounts Payable module which routed the client’s vouchers in a systematic and automated fashion.
• Implemented a checking process within PeopleSoft AP to automatically check and flag possible duplicate vouchers for outside vendors (Tools used: PeopleTools, PeopleCode, SQR, Process Scheduler)
• Created within this integrated application the ability to unpost and repost vouchers per the user’s request.

Environment: PeopleSoft 8.4 (Financials), PeopleTools, PeopleCode, Tree Manager, SQR, PeopleCode Trace, Workflow, Workflow Administrator, PS/Query, Process Scheduler, Utilities, Oracle and Windows NT

Client: Confidential,Madison, WI March 2002-September 2002
Scope:
The scope of this project was implementation of PeopleSoft 8.0 Financials, HRMS, and Supply Chain at a regional utility company in partnership with a Big Five firm.

Responsibilities:

• Provided technical analysis including gathering functional specifications, writing and designing the technical specs for the PeopleSoft Payroll to Accounts Payable feeds. Customized an SQR per the client’s business needs.
• Wrote SQR interfaces from the client’s legacy system into PeopleSoft Time & Labor, HR, Payroll, and Benefits Administration.
• Created web-based pages which allowed the executing of the SQR interfaces.
• Gathered Treasury Module specifications from functional team to write and design technical specifications.
• Created 3 custom SQR’s reports within PeopleSoft’s Treasury Module to track client’s Commercial Paper Transactions.
• Gathered functional specifications from the AP team to design and customize the ACH process within AP to accommodate the client’s UNIX directory structure.
• Gathered functional specifications from the Accounts Payable team to write and design a custom SQR that saved the client thousands in bank transaction fees. This SQR combined all of the ACH extract files into one large file for a single transmission to the bank.
• Successfully integration tested and documented the nightly Batch Scheduling process within the Financials and Supply Chain/Manufacturing Module.
• Created an SQL scripts within PeopleSoft projects to fill in missing converted data.
• Integration tested AP inbound and outbound interfaces involving Ariba and telephone feeds.
• Created a PeopleSoft inquiry page within PeopleSoft portal designed to test GL Combo field Edits.

Environment: PeopleSoft 8.0 (HRMS, Financials, Supply Chain), PeopleTools, PeopleCode, Tree Manager, SQR, Crystal Reports, Process Scheduler, Utilities, Oracle and Windows NT

FULL-TIME EMPLOYMENT Confidential, May 1998-February 2002

Staff Consultant
Clients: Various clients and locations across USA

• Programs, tests, designs, documents, and implements systems and/or software. Applies project and consulting methods and processes. Determines work priorities in accordance with project plans, project schedules, and changing work demands.
• Ensures client needs are met by actively soliciting, identifying and responding to questions, issues, and service opportunities.
• Gathered functional requirements, designed technical specs and developed panels, panel groups, menus, and processes utilizing PeopleTools and PeopleCode.
• Created/customized critical business processes usingSQR and Crystal Reports surrounding the following modules: GL (General Ledger), AP (Accounts Payable), AR (Accounts Receivable), BI (Billing), PO (Purchasing), IN (Inventory), OM (Order Management)
• Enabled security and Process Scheduler allowing the department manager to run these reports on an ad-hoc basis.
• Tested and migrated PeopleSoft objects from the development stage up through Production.
• Provided documentation support to the Technical Writer who created training manuals for the new system.
• Trained management and IT personnel on navigation, troubleshooting, and PeopleTools as part of the knowledge transfer process.
• Gathered functional requirements, designed technical specs and developed interfaces (SQR, Application Engine) from legacy systems to PeopleSoft Billing (BI), Purchasing (PO), Payroll, Benefits Administration(BA), Human Resources(HR), Time and Labor(TL), General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Order Management (OM), Inventory (IN), and Purchasing (PO).
• Executed test scripts using Rational Robot in a structured environment with System/Release Testing team according to PeopleSoft testing methodologies. Platform tested on Oracle, DB2/MVS, and SQL Server environments.
• Provided on-going 24 hour technical Production Support (on and offsite) for nightly financial batch processing.
• Developed UNIX scripts to assist users in executing their daily and quarter-end batch processing leading ultimately to client’s ownership of the new system.
• Maintained the clients’ Change Control System by synchronizing and migrating the development, testing, and production environments, which prevented system failure.

Confidential,Oak Brook, IL 1997 to 1998

• Participated on of a large financial services implementation team rolling out SAP to user’s desktops. Debugged Windows and resolved LAN/WAN and TCP/IP issues.
• Coded and fixed ABAP programs on a production support team for SAP Financials.
• Successfully completed mainframe boot camp training for Year 2000 projects.

PROFESSIONAL DEVELOPMENT (TRAINING)
PeopleSoft Technical Certification, PeopleSoft HR, PeopleSoft Asset Management, PeopleSoft Expenses, Business Process Design, nVision Reporting for GL, PeopleSoft Technical/Functional Boot camp, CICS, COBOL, JCL, DB2, SQA Robot, Oracle DBA Certification class

Education: BA Bachelors of Business Administration, Marketing