SUMMARY:

• Over Twenty five years of PeopleSoft experience as a Techno - Functional expert in HCM, Campus Solution and Financials at over twenty Higher Education institutions, four major Healthcare providers, Federal Government and various private sector organizations.
• Owner and Developer of Ferrary Consulting Services (FCS) Software for Custom PeopleSoft Solutions for Upgrades, Conversions, and Data Management. This software beats the competition over and over.
• Solid PeopleSoft Techno-Functional experience and extensive Software Development experience using PeopleTools.
• Custom PeopleSoft Solutions for Upgrades, Conversions, and Data Management using my proprietary Ferrary Consulting Services (FCS) Software.
• Extensive RICEW & CEMLI experience on several full implementations with major implementation partners including Oracle, Pricewaterhouse Coopers (PWC) & Sierra Cedar.
• Sound development experience on PeopleTools, Mobile, Web, PIA, Windows, Unix and Mainframe platforms.

EXPERIENCE SUMMARY:

• PeopleSoft HCM Version 9.2, 9.0, 8.9, 8.8, 8.15, 7.5, 7.0 and 6.0 (13 years)
• Commitment Accounting, Human Resources, Global & North American Payroll, Benefits Administration, Recruiting, Time & Labor, TAM, Absence Management, Approval Workflow Engine (AWE).
• PeopleSoft Campus Solutions Version 9.0, 8.9, 8.18, 8.12 and 7.0 (10 years)
• Financial Aid, Student Financials, Student Records, Campus Community, Recruitment and Admissions, Academic Advisement, Student Center, Self Service

TECHNICAL SKILLS:

PeopleSoft Financials Version: 9.2, 9.1, 8.9, 8.4, 7.0, 6.0 and 5.1x (7 years) Self Service, Travel & Expense, General Ledger, Accounts Payable, Accounts Receivable, Asset Management, Purchasing and Project Costing

PeopleSoft Tools: Versions up to 8.56 (28 years) Service Oriented Architecture (SOA), Application Packages, Classes & Methods, Component Interface, Integration Broker, Web Services, WSDL, Application Engine, XML Publisher, Equation Engine, PeopleCode, PS COBOL, Query, Crystal reports, nVision, SQR, Application Designer, Security Manager & Data Mover. Installed the latest PeopleSoft PUM 9.2 Versions of Campus Solutions, HCM and FSCM on my laptop

Mobile Applications: PHP, CSS, XSL, XHTML & JavaScript Siebel Call Center, Sales and Professional Services Enterprise Version 7, 6 and 5

Tools: Configuration, Siebel VB, Siebel E-Script, Java-Script, VB/COM, EAI, XML, IBM MQ-Series, Workflow Administration, Assignment Manager, Interface and Conversion

Programming Languages/Tools: PeopleCode, PHP, CSS, XSL, JavaScript, C++, Visual Basic, Siebel VB, SQR, COBOL, PL/SQL, SQL Developer, Toad, MS Office Professional, Sharepoint, JIRA, Phire, STAT & FCS Migration/Upgrade tools.

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft HCM Commitment Accounting/GL Conversion Lead

Responsibilities:

• Functional Conversion Lead on Commitment Accounting to General Ledger (CA/GL) & Core-HR.
• Designed and maintained multi-location Conversion Design Documents and Conversion Mapping Documents.
• Conversions on Chartfield/Combo code load, Department Budget, Position Budget, Work Study, JOB, Compensation & a highly customized Salary Cap Academic Pay project where funding for complex pay employees and tracking against multiple funding sources.
• Assisted with troubleshooting on Benefits, TAM & Absence Management modules.
• Designed and executed multiple test scripts against multiple conversion runs for each location.
• Wrote complex SQL to untangle the issues and determine the source (Design, Configuration, Code, etc.).
• Used JIRA to create tickets for reporting issues and getting feedback from multiple universities.
• Wrote several programs to better troubleshoot and report out conversion issues using AppEngine.

Confidential, Jacksonville

PeopleSoft Campus Solutions Technical Consultant

Responsibilities:

• Initially tasked with analyzing some Security issues, but quickly realized a major risk created when the client removed a consulting partner and hired new consultants with no turnover.
• There were several databases where source code existed and documentation was missing or incomplete.
• Convinced management that action was needed to identify the source of various projects.
• Worked closely with the Cutover Lead and Management to complete tasks.
• Wrote processes to tie projects back to JIRA’s and to any documentation that might exist.
• Created process to use Batch Command files to launch Application Designer via command line to export hundreds of projects with thousands of objects from several databases.
• This executed behind the scenes.
• Delivered reports to Management on project source and provided assistance on migrations.
• Assisted Financial Aid, Student Financial & Admissions teams on customization analysis.

Confidential

PeopleSoft HCM Technical Consultant

Responsibilities:

• PeopleSoft analyst working on an HCM upgrade from 9.1 to 9.2 (8.55 tools).
• Working on a Confidential hosted environment, I had to retro-fit customizations to the upgraded 9.2 environments.
• After getting developers more productive with point below, my concentration was on ePerformance changes.
• Reduced development time by running my proprietary code to produce Beyond compare reports against PeopleCode, SQL, AppEngine & Pages.

Confidential

PeopleSoft FSCM Technical Consultant

Responsibilities:

• PeopleSoft developer working on an FSCM upgrade from 9.1 to 9.2 (8.55 tools).
• Retro-fit customizations for the Financials upgrade.
• Supported and troubleshooting issues surrounding AP Pay Cycle Manager.

Confidential

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• PeopleSoft developer working on an HCM upgrade to 9.2 (8.54 tools).
• Retrofitting customizations for Recruiting, Time & Labor, Core HR, Payroll and Benefits Administration.
• Wrote test scripts and conducted testing on all modifications for Unit, Integration & System tests.
• Heavy troubleshooting of Approval Workflow Engine (AWE) setup and processing. These retrofits were difficult as the delivered Application Packages changed quite a bit. Working closely with the functional users on UAT.
• Using FCS tools, shortened development phase by delivering better compare reports against PeopleCode and SQL (AppEngine, View, & SQL Objects). The process leverages Beyond Compare and shortened our timelines significantly.
• Performed migrations and object analysis using Phire migration tool and the underlying tables used by Phire.
• Supported Commitment Accounting setup and testing as it related to Payroll processes.
• Assisted other users in testing complex online issues by coordinating with administrators in turning on trace and retrieving and troubleshooting trace files.

Confidential, Milwaukee, WI

PeopleSoft Campus Solutions Technical Consultant

Responsibilities:

• Worked on Application Packages/Classes within the new Notification Framework to send Emails to multiple recipients other than the students email address.
• Notification Framework is fed from Population Selection PS Queries.
• Modified reports that compared and tied together Financial Aid to Student Financials modules.
• Assisted in User Acceptance Testing (UAT) in testing the Notification Framework changes.

Confidential, Chapel Hill, NC

PeopleSoft HCM Functional Consultant

Responsibilities:

• Supported functional QA and UAT activities for a complex Peoplesoft implementation with high level of customizations in Core HR, Benefits, Payroll and Commitment Accounting on an HCM 9.1 (PeopleTools 8.53) Implementation.
• Wrote test scripts to test several modifications to Core HR, North American PR & Benefits.
• Heavy testing of Core HR functionality (Hire, Fire, Pay, etc.) with Gideon Taylor e-Forms on the front end of PeopleSoft.
• Validated the integrity of effective dating and other common coding errors for all customizations.
• Insured Benefits and Payroll compliance with the Affordable Care Act (ACA) in configuration and customizations.
• Worked on high profile project that had to ensure critical data tied out between Payroll, Benefits, Commitment Accounting and General Ledger on the Finance system.
• Tested Identity Management software using SOAPUI and Application Messaging.
• Setup and tested Mass Update to insert/update JOB rows for employee transactions.
• Point person within the HCM Functional team for PS Security, Query & Cybermation scheduling tool setup and issues.
• STAT migration tool was used for object migrations.

Confidential, Knoxville, TN

PeopleSoft HCM Technical Consultant

Responsibilities:

• Worked closely with Testing Lead on test plans for the different phases (unit, integration, system & acceptance).
• Developed multiple Core HR & P/R AppEngine programs to stage and cleanse the data and then to load into PeopleSoft using Component Interface.
• Built chunking process where one AppEngine spawns up to 40 clones to process sections of data to speed performance.
• Directly responsible for building conversions for configuration setup components like Jobcode, Departments & Salary Plan/Grade/Step, Tax and multiple transactional components.
• My main focus was on Job data. There were many issues with the Job stack that had to be resolved programmatically (missing hire rows, rehires without term rows, etc.). Complex algorithms were required to handle several issues including the need to insert missing hire rows and setting the correct employee record number to ensure separation between employees, contingent workers, retirees receiving medical benefits and retirees receiving pensions.
• Multiple cross walk tables were built to allow the code to translate old values to newly established values.
• Worked closely with functional leads from Core HR, Payroll, Compensation and Benefits Administration to correct mapping issues, ensure documentation was kept up to date and to agree on creative ways to resolve complex issues.

Confidential, Boca Raton, FL

PeopleSoft Financials (FSCM) Technical Lead Consultant

Responsibilities:

• This was a PeopleSoft FSCM upgrade from version 8.4 to 9.1 (PeopleTools 8.52). This was a reimplementation/upgrade for GL, AP, PO, ePRO, AM, AR/Billing and PC. There was a major Chart of Accounts design change that will invalidate some historical transactional data and force a reimplementation.
• Worked with the functional leads using Setup Manager, we mapped how we would get setup and master data into the system. We determined what data would be keyed into our initial configuration, what tables would be converted using either Data Mover Scripts (DMS), Excel to CI tool, or converted using App Engine calls to Component Interface (CI).
• Created and executed multiple Excel to CI conversion layouts and DMS conversion scripts.
• Ensured that PeopleSoft installed products were working correctly, including nVision, XML Publisher, report repository, etc.
• Sat in on Fit Gap sessions and on Interactive Design and Prototype (IDP) sessions.
• Worked with functional lead to alter the Chart of Accounts (COA) using Chart field configurator. Tracked down several issues as this tool alters the structure of multiple tables and other objects.
• Configured Integration Broker to get the Voucher Upload spreadsheet to work for a proof of concept in an IDP session.
• Analysis determined that a double hop upgrade was not necessary as only limited transactional tables would be needed to be upgraded. The structure changes caused by the COA change forced a re-implementation.
• The upgrade would have been from a client installed MS SQL Server FSCM to a CedarCrestone hosted Oracle 9.1 install (Tools version from 8.4 to 8.52).
• Used my FCS SQR Scanner to analyze all SQR’s in the system to determine record and field access.
• This data is stored in custom tables and produces reports of what upgrade work is needed on all programs. This system also makes it easy to determine where hard coding exists and is used as a productivity tool to find examples of programs with specific SQL scenarios.

Confidential, Miami, FL

Sr. Principal Consultant PeopleSoft Campus/ HCM/ FSCM

Responsibilities:

• Working at the home office on PeopleSoft Financials version 9.1, Campus Solutions 9.0 & HCM 9.1 (Tools Version 8.51)
• Developed Integrations between mobile apps and PeopleSoft Financials and Campus Solutions including all aspects of Integration Broker and development of the mobile apps that connect to self-service.
• Initial Financials focus was on Integrating Travel & Expenses from PeopleSoft Finance to the mobile applications.
• Initial Campus Solutions focus was on the Recruiting appointment calendar.
• Initial HCM focus was on the view Paycheck and Pay Advice.
• Developed new Web Service, Application Packages, Classes, Methods and Component Interfaces that gather and update PeopleSoft data. Testing XML message using Handler Tester prior to moving to mobile app side.
• Developed Mobile Apps using PHP, XHTML & CSS.
• Consulting at Embry Riddle Aeronautics University, Daytona Beach, FL.
• This was an initial implementation of PeopleSoft Campus Solutions version 9.0 (Tools version 8.51) where I worked on all aspects of RICE (Reports, Interfaces, Conversions and Enhancements).
• My concentration was on the Financial Aid, Student Financials & Student Records modules on this Cedar Crestone hosted environment. This was a combined consulting effort with Oracle, Cedar Crestone and independent consultants. All modules were implemented on time and under budget.
• Designed and implemented multiple Financial Aid CEMLI enhancements. Two of the larger enhancements surround the unique way Aid is awarded and dispersed by Track rather than Term as they have Terms start each month grouped by varying numbers of months. Hundreds of objects were created to solve this need.
• Assisted in the design and setup of Equations for FA Packaging and other FA processes.
• Lead the effort to design an FTP system to handle all interface files flowing in and out of the University. Multiple programs and Unix Shell scripts were needed to accomplish this task. Worked closely with Cedar Crestone and all developers to implement solution that would fit all the unique needs for handling the files and cleanup.
• Worked on several Conversions dealing with Financial Aid and Student Records data from the legacy Datatel system. Used complex AppEngines to process high volume components into manageable chunks.
• The complexity of the unique Financial Aid Track design forced extensive analysis and modification to SQR, COBOL and DMS scripts to alter the way the delivered COBOL handles FA Term Build. Due to the pain involved in ever changing PeopleSoft COBOL, I designed a process to rewrite the COBOL code to combine all Copy/Call code together, place trace statements on each paragraph entry point and to display the actual SQL the program was about to execute. This made it much easier to read the source code and provide enhanced COBOL log files.
• Designed and implemented other enhancements to the Student Records, Self Service and Student Financials modules.
• Helped to set up initial development environment for other developers. Designed and implemented a Project Documentation process that extracts PeopleCode and SQL from a project, checks on and reports out individual object comments to ensure they are documented according to Technical Standards. It also allows the acts as the major portion to each Technical Design Document ( Confidential ).
• Designed nVision and XML Publisher reports that give all the details needed to paste directly into the Confidential, saving developers many hours each week in avoiding duplication of effort.
• Analyzed and used Phire Migration tool to migrate projects. In addition, I added a project analysis tool prior to importing into Phire. Due to the limited amount of databases available, we need to check the accuracy of the project prior to importing into Phire. This produces reports on missing objects and is a great aid on initial implementations where the customer users are new to both PeopleSoft and Phire.

Confidential, College Park, MD

PeopleSoft Sr. Campus/ HCM Systems Analyst

Responsibilities:

• Sr. Technical Systems Analyst focused on Financial Aid & Student Financial on a Campus Solutions upgrade to version 9.0.
• Assisted HCM/HRMS team on the new Person Model design in the new version.
• Ensured complete documentation of all modifications, including functional & Technical specifications, user acceptance testing scripts, migration instructions and user guides.
• Developed new functionality including Custom Satisfactory Academic Progress (SAP), NSLDS, Applying Service Indicators on Overdue Balance / Pending Financial Aid process and other Financial Aid & Student Finance processes.
• Customized the Financial Aid daily process to build FA Term for Summer Term students using custom Pop Select ApEng.
• Supported FA tools such as Population Selection/Update and Equation Engine.
• Support of asynchronous message Integrations between Student Financials and Financials.
• Developed Academic Advisement and Student Records customizations including Degree Audit and enrollments.
• Involved in Interactive Design & Prototyping (IDP) / Fit Gap sessions and upgrade discussions for version 9.
• Used STAT Migration tool and Quality Center modification identification tool to coordinate projects.
• Responsible for applying bundles, patches and tax updates including Financial Aid Regulations.
• Using my own FCS software, I implemented processes to streamline the Software Development Life Cycle (SDLC).
• Produces easy to read software flows for App Engines, SQR’s, etc.
• Produces detailed upgrade reports to identify sections of code that need to be changed for the upgrade.
• Produces enhanced cross reference reports to more easily identify what objects access Record, Fields & other objects.
• Produces listings of “What did PeopleSoft do” to programs during the upgrade.
• Streamlines the application of software bundles and the migration to all environments.

Confidential, Miami, FL

Independent PeopleSoft Campus Consultant

Responsibilities:

• Reporting Lead on a Campus Solutions Upgrade project from version 8.0 to version 9.0
• Coordinated the upgrade of thirteen thousand PS Queries. The duties of this high profile position included:
• Establishing standards
• Determining upgrade needs
• Assessing security concerns
• Identifying and assisting with query changes
• Documenting training material
• Holding training, testing and upgrade lab sessions
• Conducted System & User Acceptance Testing (UAT) sessions
• Arranging for and ensuring the reliability and availability of physical classroom and labs
• Communicating statuses to directors across the University with presentations, meetings and emails
• Created reporting system to deliver summary and detail information specific to their needs to all managers and users.
• Mentored a new developer in all aspects of PeopleSoft development and ensured complete turnover of my system.
• Modified thousands of PS Queries behind the scenes. This ensured the structure was not lost when first opened online after upgrade.
• Developed PIA pages showing the differences between the versions and changes needed for their Queries and other PeopleSoft objects including SQR’s and Views.
• Assisted Security Administrator in his daily duties where PS Query was concerned (Access manager & Role Security).
• Created nVision layouts and scopes to deliver reports to University managers. Aided Finance team on nVision issues.

Confidential, St. Louis, MO

Independent PeopleSoft Campus Consultant

Responsibilities:

• Supported Student Records, Financial Aid & Student Financials in a post upgrade environment.
• Modified and supported Equation Engines for Financial Aid and Student Financials.
• Designed a flexible way to load students into Student Groups and/or Service Indicators using Application Engine, Component Interface and Peoplecode. The system allowed the user to use PS Query or flat files as the source of the Student ID’s (Emplid’s) to load date into various components. This functionality was not available until version 9.0.

Confidential, Princeton, NJ

Independent PeopleSoft HCM/ Campus Consultant

Responsibilities:

• Documented Technical Specifications and completed coding, testing and implementation of multiple modifications.
• Redesigned Self Service Paycheck and Advice PDF viewing using XML Publisher, App Package & App Engine tools.
• Upgraded dozens of modifications to keep HRMS present. Many of these large modifications to PeopleCode were in areas that have converted to using Component Interfaces (i.e. Position Management updates to Incumbent data, etc.).
• Designed tools to untangle the 9.0 Person Model upgrade changes that affect Campus Community and HRMS.
• Redesigned Admissions test score loads to use the new 9.0 App Engine and App Package/Class PeopleCode. Old customizations were in SQR, so in-depth research of new AppEngine was required to apply customizations.
• Assisted Campus Community in analyzing impacts of new Service Oriented Architecture (SOA), which maintains HR Core Services and the Application Packages and Classes that control and enable access to this core data housed within HR,. HR and SA Components, Component Interfaces and the Core Services needed to change for their customizations.
• Using my own FCS Upgrade Lab tools, I presented client with tools that identify what changes are needed due to the Upgrade to 9.0. These tools create custom Upgrade tables and store data on how to:
• Upgrade all SQR’s.
• Upgrade SQL, including SQL used in Application Engine, Views, SQL objects, etc.
• Upgrade PeopleCode (Component, Record, Application Engine, Application Package/Classes etc.)
• Upgrade PS Queries.
• In addition to identifying what needs to be done to upgrade these objects, the system stores enhanced cross reference information regarding the full table access on all these objects.
• Standard PeopleSoft delivered cross reference information misses approximately 40% of Peoplecode matches and ignores SQR’s and SQL in App Engine and Views.
• These Upgrade Lab tools cover all these objects and present data in simplified and user friendly ways.
• Wrote scripts to help Security Administrator deal with the new Security Model.
• Assisted the Student Admin and Campus Community team on complex modifications.

Confidential, Malvern, PA

PeopleSoft Principal Campus Consultant

Responsibilities:

• Technical Lead on a Financial Aid 8.4 project correcting issues with Budgets and Award Packaging.
• Redesigned FA Term process to correct issue where there are dozens of terms per year overlapping the Aid year.
• Business analyst and technical developer on Campus Solutions 8.9 project (Tools 8.46, Oracle & Unix).
• Customized Student Financials Self Service Pages, Components, Component Interface & PeopleCode for the Student Center to allow the student to view their account summary and move funds around.

Confidential, Wilmington, DE

Independent PeopleSoft HCM Consultant

Responsibilities:

• Business analyst and technical developer on an HRMS 8.9 Global Payroll project (Tools 8.46, Oracle & Unix).
• Technical Developer on a Global Headcount process working with Functional Leads from Great Britain and Sweden. This system had multiple feeds in and out due to the complexities of how each country stored and categorized its data.
• Supported Global Payroll processing in test phase.
• Upgraded many Interface programs for multiple HRMS functional areas.
• Developed and supported Position Management and Absence Management processes and traveled abroad to complete.

Confidential, Miami, FL

Sr. PeopleSoft HCM/ Financials Analyst

Responsibilities:

• Business analyst and technical developer on an HRMS & Financial 8.8 project (Tools 8.45 & MS SQL Server).
• Involved in all phases of the SDLC (Planning, Analysis, Design, Implementation & Maintenance).
• Designed and implemented processes and procedures for Sarbanes Oxley (SOX) Compliance.
• Built Upgrade/Conversion SQR’s on both the HRMS upgrade from 7.5 to 8.8 and Finance upgrade from 8.4 to 8.8.
• Designed creative solutions to unique Financials & HRMS reporting needs using Application Engine, PeopleCode, Query Crystal reports, nVision & SQR.
• Designed, Coded and delivered multiple processes and interfaces for Benefits Administration and Payroll systems.
• Security Administrator on HRMS and Finance modules.
• Built complex Workflow solution for Payroll Increases making better use of the Department Security Tree.
• Designed complex views and reports to untangle the complex web of PeopleSoft Security architecture.
• Built Complex Report Distribution solution for nVision Financial Statements using undocumented knowledge.
• Coordinated the testing of dozens of reports and communicated statuses to management.
• Analyzed using Integration Broker linked to IBM’s BizTalk via iWay adapter for Interface replacement project.

Confidential, Cleveland, OH

Independent PeopleSoft Campus Consultant

Responsibilities:

• Business analyst and technical developer on an Upgrade to Learning Solutions 8.18 (Oracle DB) project.
• Beat out P/S Upgrade Lab convincing CSU I could design better system to perform Upgrade Lab tasks. This was the beginning of the FCS toolset.
• Developed system to analyze custom SQR’s, Views, PeopleCode & Queries to determine which items needed to be modified due to new table structures caused by upgrading from version 7.6 to version 8.18
• Designed system to rewrite all SQR’s to enforce standards and add debugging statements.
• Coordinated the testing of these 500 custom SQR’s and effectively communicated the statuses to management.
• This system will also be used to aid future development by identifying work needed and ensuring correct versions of items are migrated safely from database to database.
• Developed software for Government Compliance (SEVIS) processing and reporting.
• Assisted Functional analysts on Financial Aid, Student Financials, Admissions & Student Record setup.

Confidential, West Paterson, NJ

Independent PeopleSoft Campus Consultant

Responsibilities:

• Business analyst and technical developer on a PeopleSoft Learning Solutions 8.18 (MS SQL Server) project.
• Performed analysis and implemented Setup changes for PeopleSoft Student Self-Service connecting over the Internet using LDAP authentication, Custom Sign-on PeopleCode, Messaging and Component Interface.
• Built Component Interface object to update Student Financial Security tables during LDAP authentication.
• Customized Learner Services and Personal Portfolio Self-Service PeopleCode to satisfy complex enhancement requests from the Student Records, Student Financials and Campus Community functional teams.
• Designed custom Self-Service Audit process to track Students that are using Web Self-Service functions. Utilized PeopleCode and Application Engine to insert records into custom tables. This system automatically emails custom Crystal reports when certain audit triggers are hit.

Confidential, Orlando, FL

Sr. Siebel Consultant

Responsibilities:

• Business Analyst and Technical Developer on a Siebel 7 (Oracle DB) Call Center and Sales Enterprise Implementation. Lead effort in designing and implementing interfaces between Epiphany and Siebel using VB/COM, Siebel VB, eScript, Java-Script, Business Services and Virtual Business Components.
• Worked on the Load Testing team using Load Runner.
• Configured Workflow processes to schedule Business Services.
• Assisted with the setup and execution of Load Runner load testing software, including installation of software, setting up test scripts and monitoring the load testing.