PEOPLESOFT EXPERIENCE SUMMARY

• Expert Level PeopleSoft Technical Developer and Functional Consultant PeopleSoft and Oracle Certified in Technical and Functional Consulting.
• 16 years of PeopleSoft Enterprise Development experience in Human Resources/Payroll HCM/HRMS , Financial Management FSCM , and Campus Solutions modules using PeopleTools versions up to 8.53 Application Designer, PeopleCode, Application Engine, SQR, nVision, Crystal Reports, PeopleSoft Query, Application Messaging, COBOL, XML Publisher, Component Interface, Integration Broker, PIA, PeopleSoft Test Framework, Security Administration, Business Interlinks, Change Assistant, Workflow, UPK, and AWE.
• 18 years of PeopleSoft Implementation, Upgrade, and Functional experience in HCM/HRMS, Payroll, Financials, and Campus Solutions modules. 13 years of SCM, ELM, CRM, EPM, and SRM Procurement module experience. Expert PeopleSoft UPK developer.

CONSULTING EXPERIENCE

PeopleSoft Developer

Confidential

Upgraded PeopleSoft Financials, Human Resources HCM , Payroll, and Campus Solutions from version 8.9 to 9.0, and then to version 9.2, as part of a team of developers and functional analysts in an 84 million project. My effort concentrated on Campus Solutions modules Financial Aid, Student Administration, Campus Self Service, Student Financials, Contributor Relations, and PeopleSoft Gradebook. Retrofit several SQR's, Application Engines, COBOL, nVision and Crystal Reports, and PeopleSoft Queries. Set up Workflow and App Engines, SQR's, Crystal Reports, and Component Interfaces to analyst specifications. Worked closely with Functional Analysts to ensure required functionality, used Oracle UPK to record new development modifications, and developed courses in PeopleSoft ELM to train students and staff. Performed testing on new modifications and retrofits, and documented People Code, SQR, Workflow, and App Engine mods. Eliminated several customizations in 8.9 to utilize new functionality in versions 9.0 and 9.2, thus saving time and effort to retrofit into future versions of PeopleSoft. Used XML Publisher for reports and queries.

PeopleSoft Techno-Functional Consultant and Trainer

Confidential

Worked alongside company IT and Marketing Department staff to initiate and lead Fit/Gap sessions with the purpose of improving business process efficiency through the use of PeopleSoft. Built a PeopleSoft bolt-on in SCM to prepare and scrub prospective customer data that flowed through a new Component Interface into three high-capacity Marketel Dialer Servers, which dialed 11-digit phone numbers at the rate of 280 per second. This tripled the speed of the auto-dialers and allowed the company to hire more telemarketing staff to handle the additional capacity and roll out same day order fill , an option that their customers did not previously have. This custom App Engine also screened the phone numbers against the Federal Do-Not-Call List to ensure compliance, at a rate roughly 10x the speed of their existing process. Set up Workflow and AWE in Payroll, AP, and Travel Expenses modules. Once customizations were completed, I implemented and taught weekly PeopleSoft classes on the new functionality, then gradually migrated the classes into PeopleSoft ELM to give employees more control over their training schedules.

PeopleSoft Functional Consultant Contract ,

Confidential

Implemented PeopleSoft Test Framework included in the new version of People Tools for Financial, HCM, and Payroll modules in preparation for an upgrade from PeopleSoft version 9.0 to 9.2. Used Oracle UPK to build a training module on how to use Test Framework in order to eliminate formal classroom training and allow the testing staff to view at their leisure. Trained IT staff on how all the testing pieces fit together, the module maintenance processes they needed to know, the IT testing reports now available to them, and gave a Best Practices recommendation on how to deploy their teams and other human capital during the actual migration weekend. PeopleSoft Test Framework, when used as recommended, shaves hours off the old testing schedule, so to prepare the staff for these new procedures we did a practice migration to PeopleSoft 9.2 to ease everyone's fears, all with great success.

PeopleSoft Techno-Functional Consultant and Trainer Contract ,

Confidential

Technical/Functional Consultant responsible for implementing and configuring PeopleSoft version 9.0 and upgrading to 9.1 Financial Aid, Student Financials, and Contributor Relations modules. Met with school subject matter experts SME's to perform Fit/Gap Analysis, wrote business requirements and technical specifications, mapped and loaded historical data from Legacy systems, installed software and configured applications Financial Aid disbursements, 3C letters, Soft Credits, and Workflow . Wrote customizations to delivered App Engines, SQR's, PeopleCode, and Component Interfaces, and developed new custom Pages, Tables, Crystal Reports, and App Engines. Integrated all three modules with PeopleSoft General Ledger, Accounts Payable, and Accounts Receivable. Used UPK to train school staff on Campus Solutions functionality. Installed PeopleSoft Test Framework module and performed Unit, System, User, and Integration Testing. Provided post-implementation support and tuning, and trained technical staff on new features of PeopleTools versions 8.51, 8.52, and 8.53, including PeopleSoft Test Framework and Usage Monitor.

PeopleSoft Workflow Consultant Contract ,

Confidential

PeopleSoft Workflow consultant and developer responsible for the design and configuration of the Approval Workflow Engine AWE for a new implementation of PeopleSoft Travel and Expenses version 8.9. Responsible for all Workflow technical requirements documentation, AWE setup, configuration, development and testing. Integrated the new Travel and Expense module with existing PeopleSoft A/P, G/L, and SCM modules, ran and tested paycycles, and wrote a custom SQR for the HR system feed into the Expense system. Developed custom Component Interfaces to load per diem rates, one time loads of Travel and Expense Authorized users, and Location Amounts for Expense Types. Developed custom App Engine to read incoming Credit Card feed, and helped implement a One Card system for employees. Customized several pages in Travel and Expenses to customer specs, including the Hotel Wizard. Developed custom Employee Notification e-mails for overdue transactions including a link to take the user directly to their Expense Reports. Wrote custom reports with XML Publisher, SQR, nVision, and Crystal Reports. Developed a UPK simulation for customizations and the training of PeopleSoft Expenses end-users.

Senior PeopleSoft Developer Contract ,

Confidential

Senior PeopleSoft Programmer on team responsible for consolidating all company employees on one PeopleSoft HR system. The company had half of their employees on PeopleSoft HCM version 8.9, and the other half on PeopleSoft HCM version 8.8, and decided to consolidate on version 8.9 on an Oracle database platform. PeopleSoft HCM version 8.9 modules included Core HR, Payroll, Benefits, Talent Acquisition Manager/Candidate Gateway, Stock Administration, ePerformance, and ePay. Developed new App Engines, Component Interfaces, Dashboards, Crystal Reports, SQR's, XML, and SQL to accomplish consolidation tasks. Used Change Assistant to apply Tax Updates to both 8.8 and 8.9 systems. Modified existing SQR's, PeopleCode, App Engines, and nVision layouts and developed and applied 8.8 customizations to 8.9 system. Used UPK to store all technical spec documents for project.

Senior PeopleSoft Consultant Contract ,

Confidential

Senior PeopleSoft Programmer Analyst, responsible for technical design and development in PeopleSoft Financials SCM version 8.9 modules G/L, A/P, A/R, KK, BI, OM, Expenses, Purchasing, Asset Management, Inventory, and Grants . Led team of consultants in developing customizations to Financials SCM modules using Application Engine, SQR, PeopleCode, Integration Broker, Component Interface, App Messaging, and Crystal Reports. Developed custom nVision Reports to customer specifications, incorporating Excel macros and VBA. Developed complex queries that allowed general accounting staff to easily modify the reports for their own reporting needs for month-end and year-end closing procedures. Developed Deep Linking URL's in ELM, which allowed employees to browse internal course catalogs and register for classes without having to navigate through PeopleSoft. Applied quarterly Tax Updates, Maintenance Packs, and patches using Change Assistant, and used Performance Monitor to maintain optimum system performance. Installed UPK and wrote several UPK simulations to client specifications.

Senior PeopleSoft Developer Contract ,

Confidential

PeopleSoft Lead Developer and Administrator responsible for developing and maintaining all company-wide PeopleSoft HCM version 8.9 modules Payroll, Core HR, Benefits Admin, ELM, Time and Labor, Employee Self-Service, ePay, eBenefits, ePerformance, eCompensation, eProfile, eEquity, Labor and Absence Management, Workforce Planning, and Talent Acquisition Manager/Candidate Gateway . PeopleSoft Development responsibilities include heavy module customization using Application Designer pages, menus, and interfaces , PeopleCode, iScript, App Engine, SQR, COBOL, Component Interface, Data Mover, Tree Manager, Mass Update, Crystal Reports, Process Scheduler, and Integration Batch. Used PeopleSoft Change Assistant to apply multiple Tax Updates and Maintenance Packs to databases. Developed Deep Linking URL's in ELM and modified delivered Payroll and Leave Accrual calculations. Set up Performance Monitoring in PeopleTools, configured Enterprise Portal, and used Integration Broker. PeopleSoft Admin/DBA duties include Performance Tuning, configuring and scheduling maintenance jobs in SQL Server 2005 databases, and backing up and refreshing all environments. Tasks include managing and troubleshooting PeopleSoft infrastructure, including Application and Database servers, Web servers/PIA services, Process Scheduler servers, and Load Balancing.

Senior PeopleSoft Developer/Analyst Contract ,

Confidential

Lead developer on post-implementation team for PeopleSoft Campus Solutions version 8.9. Responsible for developing custom Bolt-on's, SQR's, Crystal Reports, PeopleCode, Component Interfaces, and App Engines for PeopleSoft Campus Solutions version 8.9 modules, including Campus Community, Student Administration, Student Financials, Financial Aid, Student Records, Contributor Relations, Campus Self Service, Collections, Gradebook, Recruiting, and Admissions. Implemented and configured the Financial Aid and Contributor Relations modules and provided technical support. Acted as the school Lead Functional Resource for several Campus Solutions modules, including Campus Self Service, Contributor Relations, Student Administration, and Financial Aid. Modified existing Component Interfaces, SQR's, PeopleCode, COBOL's, and Crystal Reports, using a variety of PeopleTools. Developed simulations and trained end-users with Oracle UPK for Campus Solutions.

Sr. Technical/Functional Consultant Contract ,

Confidential

Responsible for Post-Implementation configuration and customization activities following upgrade from PeopleSoft Financials G/L, A/P, A/R, A/M, BI, Grants, Treasury, Purchasing, Contracts, Projects, Travel Expenses, KK , and SCM Billing, Inventory, COM v7.5 to v8.4, and PeopleSoft HRMS and HCM Core HR, NA Payroll, Benefits Admin, Time and Labor, Employee Self-Service, ELM, Stock Administration, and eApplication modules from v7.5 to v8.3, then v8.8 on an Oracle database platform. Upgrade to v8.3 and v8.8 involved heavy customization of Payroll, HR, and ELM modules, including Benefits, Payroll Taxes, Leave Accrual formulas and Deep Linking to specific Activities and Catalog Items. Applied Maintenance Packs and Tax Updates to databases with Change Assistant. Developed an interface between Kronos time and attendance system, Access, and PeopleSoft NA Payroll, and a Payroll Accrual program using actual Kronos time clock data. Wrote nVision Layouts, Crystal Reports, and Queries in PeopleSoft Financials and HRMS databases to client specs, and modified SQR's and PeopleCode extensively. Developed Application Engine programs and custom SQR's to client specs. Tested PeopleSoft development applications, provided Quality Assurance, and performance tuning. Developed automated Excel applications and Access databases using Visual Basic, VB.NET, and VBA, and integrated these with PeopleSoft Enterprise Solutions.

Sr. Consultant/Project Manager Contract ,

Confidential

Responsible for Post Implementation activities following conversion to PeopleSoft version 8.9. Led client SME and management team in Fit/Gap and needs analysis, identifying areas of necessary improvement to PeopleSoft modules, including additional functionality, reports, configuration, and changes to user interface. Used Application Designer extensively to build and modify components, pages, menus, records, and functionality in CRM Support, Marketing, HelpDesk, FieldService, Customer Scorecard , and Financials G/L, A/P, A/R, Purchasing, Asset Management, Travel Expenses, Billing, Treasury, Order Management, Demand Planning, and Promotions Management modules . Wrote SQR's, Application Engines, Component Interface, and Application Messaging programs on a DB2 database platform, and used SQL and PeopleSoft Query Manager to develop ad-hoc queries to client specs. Wrote and ran scripts in UNIX environment. Created project plan to keep client resources on track, on budget, and to meet specifications. Developed custom Crystal Reports, nVision Layouts, and Excel Macros and spreadsheets to customer specifications. Created a new application in Excel to interface with a legacy database management system. Trained staff using Adobe Captivate and custom PeopleSoft UPK applications. Used Hyperion Essbase database system to retrieve financial data for analysis.

PeopleSoft Project Manager Contract ,

Confidential

Led technical and functional teams through upgrade from PeopleSoft version 7.5 to 8.8 for the Financial modules G/L, A/P, A/R, Contracts, Grants, Billing, Purchasing, Asset Management, Travel Expenses, and Projects , and version 8.3 to 8.9 in the HCM modules Payroll/HR/Benefits, Time and Labor, ePerformance, ELM, and Workforce Planning . Led Fit/Gap analysis effort and requirements gathering phase. Modified PeopleSoft delivered SQR's, COBOL's Leave Accruals, Ben calc and PeopleCode, and wrote new SQR's, Crystal Reports, and App Engine programs. Wrote project plan and specs for smooth transition to new web-based interface on the Financials side. Responsible for leading all testing activities Unit, System, UAT, and Integration before go-live dates. Developed custom ePerformance Management Dashboards and trained in-house technical and functional staff on Dashboard development and configuration. Led PeopleSoft Mobile Palm Pilot, Blackberry technology configuration effort. Taught classes in PS Query, nVision, and new functionality to client management end-users. Developed automated interface from Kronos Time and Attendance system to PeopleSoft Payroll.

Senior Technical Consultant/Project Manager,

Confidential

Responsible for Accounting and Information Technology Project Management at Hilton Corporate Headquarters. Managed PeopleSoft HRMS and Financials development projects from conception through implementation using PeopleTools, SQR, PeopleCode, Application Engine, Application Designer, and MS Project. Wrote specifications, business rules, and process flow using MS Visio at the developer level for two complete Financials implementations and three custom systems implementations for the PeopleSoft General Ledger, A/P, A/R, Asset Management, Treasury, Purchasing, and Inventory modules in versions 8.8 and 8.9. Set up Trees and Chart fields for G/L and A/P modules using Tree Manager. Led development for four upgrades in the Financials and HR/Payroll modules. Used Integration Broker, Application Messaging, and Workflow extensively, and wrote reports in HRMS and Financials databases using Crystal Reports, nVision, and SQR. Conducted training in PeopleSoft Financials, nVision, HR, Benefits, and Payroll Systems for General Managers and Finance Directors at over 700 Hotel properties upon introduction and upgrades of new software. Wrote automated program for Balance Sheet reconciliations, and wrote Excel Macros to automate hotel monthly payroll accruals. Used Crystal Reports, nVision, SQR, and Acrobat to produce Financial Statements in PeopleSoft for eight Corporate Departments.

Programmer/Analyst PeopleSoft Development ,

Confidential

Worked on a team responsible for converting and upgrading 65 large hotel properties to PeopleSoft versions 6.5, 7.5, 8.4, 8.8, and 8.9 Financials, HRMS, and Payroll from a legacy system. Used PeopleSoft World extensively in conversion from AS400 environment. Converted hotel time clock systems from Kronos to TRM, and exported 10 years of payroll information from legacy Kronos system. Designed, wrote, and implemented new Profit and Loss statements and Balance Sheet in nVision, new SQR's and Application Engine programs for hotels. Modified PS delivered leave accrual process. Customized allocations to suit specific company needs. Wrote Macros in Excel and Access to automate daily accounting functions. Managed a staff of five staff accountants, directing them through daily accounting functions. Invented a process in Excel to calculate monthly payroll accrual now used by over 2,100 hotel properties. Built a PeopleSoft training program using Adobe Captivate.

Senior Accountant,

Confidential

Lead Financials Functional resource SME on PeopleSoft version 7.0 Implementation team. Wrote user reports using PeopleSoft Query tool. Reconciled 1.5B in balance sheet accounts on a monthly basis, and posted cash to general ledger accounts daily. Managed inventory and assisted in asset management and construction project costing. Managed staff of three general ledger accountants, responsible for month-end and year-end close activities.

Senior Credit Analyst,

Confidential

Responsible for financial analysis of 600 reseller accounts in five states. Managed an A/R portfolio of 45 million for a Fortune 500 computer master reseller corporation. Used PeopleSoft Financials versions 6.0-6.5 for G/L entries. Responsibilities included assigning credit lines, selling of financial packages, account reconciliation, and collections. Automated many of the job functions by building Excel spreadsheets using Macros to cut turn-around time in half.

Data Analyst,

Confidential

Organized and charted sales data, provided trend analysis, and pinpointed market opportunities for a staff of networking sales executives and upper management at a Fortune 500 communications company. Wrote Excel macros to automate many routine activities, and used MS Access extensively, including Access macros and VBA.

COMPUTER AND TECHNICAL EXPERIENCE

• Proficient in a variety of ERP Systems, Accounting, Business, Financial and Human Capital Management software packages, multiple programming languages, and Database Management Systems:
• PeopleSoft Developer and Technical/Functional expert in Financials, CRM, Supply Chain, ELM, Campus Solutions, HCM and HR/Payroll/Benefits modules versions 6.0, 6.5, 7.5, 8.3, 8.4, 8.8, 8.9, 9.0, 9.1 and 9.2 . Proficient in PeopleTools up to version 8.53. Expert level PeopleSoft/Oracle UPK Developer.
• Developer in Visual Basic for Applications, MS Excel Expert all versions , MS Access v.95 2013 , MS PowerPoint, MS Word, MS Outlook, MS Project v.2000-2010 , MS Visio, Crystal Reports v. 7 to XI , Adobe Captivate and Acrobat Professional.
• Software Development in C , C .NET, Visual Basic.NET, COBOL, Java, HTML, XHTML, XML, ASP.NET, CSS, Perl, SQL, SQR and PeopleSoft proprietary software PeopleTools and nVision.
• Relational Database Management Systems Developer in Microsoft SQL Server 2000/2005/2008/2010, Oracle versions 10 and 11, DB2 on OS/360 and OS/390, Sybase, Essbase, and Informatica.