SUMMARY:

• Confidential has over 16 years of experience on 28+ PeopleSoft engagements. His project portfolio spans PeopleSoft Supply Chain Management (SCM), Financial Distribution Manufacturing (FDM), and Enterprise Performance Management (EPM) projects to include: Services Procurement (sPro), eProcurement (ePro), Purchasing, Inventory, Accounts Payable, Accounts Receivable, Asset Management, Planning & Budgeting, Project Costing, and General Ledger, as well as six upgrades - including 2-step upgrades.
• Confidential is versatile: on these projects he has served in the capacities of Senior Developer, Senior Business Analyst, Team Lead, as well as Project Manager.
• Confidential is unique because he transcends the traditional dichotomies of technical and functional expert, manager and worker; breadth and flexibility are his strengths.
• Confidential is often engaged on complex projects because of this unique amalgam of technical and functional proficiency, and because his PeopleSoft experience begins at release 2.
• Thus, Confidential can leverage this diverse set of skills to perform well on PeopleSoft Human Capital Management systems, Campus Solutions, CRM, EPM, SCM, or other PeopleSoft function whether novel or familiar.
• Confidential is formally educated in the domains of Information Technology, Supply Chain, General Business, and the Confidential - generally graduating in the top 1% of his class.
• Confidential values excellence, is highly motivated, and self-directed.
• His work ethic is exceptional.
• He has experience in Healthcare, Oil and Gas, Real Estate, Financial Services, Retail, Insurance, Marketing Research, Defense, and the Public Sector.

PROFESSIONAL EXPERIENCE:

Principal Consultant

Confidential

Responsibilities:

• Developed Excel-to-CI interface that closed and finalized workorders.
• Troubleshot, advised, and resolved abends in several custom Application Engine programs, as well as POPO005.SQR.
• Analyzed risk & impact of tools upgrade to PeopleTools 8.50.24; championed & drove initiative to its ultimate adoption into Production. Patch 24 resolved several known problems including signification issues related to manual invoice generation & submission in sPro.
• Provided support for various year-end close initiatives in the Services Procurement module. Conceived custom solutions that released 450 workorders previously stuck in various stages of their lifecycle. These documents spanned 10 different transaction buckets, formed 20 distinct business cases, and involved 1,087 timesheets.
• Role included ongoing mentoring & one-on-one training responsibilities, use of Quest Toad 11.5, and Quest Stats 5.6.
• Designed & developed a bolt-on module that audited the PeopleSoft Purchasing system. PO Audit consisted of a multivariate, 13-point audit of requisitions against POs in clients PeopleSoft Supply Chain (SCM) system. Additionally, the process compiled an exception table, and reported on these exceptions using a Crystal Report 2008 definition that included formulas. Process consisted of 2,715 lines of Tools-8.5’s Object-Oriented-PeopleCode housed in an Application Package: class/method. The PeopleTools project comprised of Application Engine (AE) program, and 45 other PeopleTools objects including several Component Interfaces (CI). Process audited all purchasing business units in the PO system in 20-90 seconds; designed as a sharable module between the PeopleSoft Supply Chain (SCM) online and batch systems.
• Developed Application Engine program to integrate stores, distribution centers, trade/payable vendors, & carriers to Descartes ITMR4 software for Canadian Exports. Module was programmed to facilitate configurable selection criteria and included full- & incremental-sync functionality. PeopleTools project comprised of file layouts, pages, components, derived work records, and views; designed & developed new menu for Descartes.
• Performed analysis on Purchasing, Requisition, & Cost Management system for client; Performed Integration-Broker-related PeopleCode changes, and executed PeopleSoft go-live of systems using Integration Broker (IB).
• Routinely used Oracle SQL Developer 3.x & HP/Mercury Quality Center; wrote over 300 SQL queries.

Confidential

PeopleSoft Functional SME

Responsibilities:

• Integral to the 2010 audit and 2010 financial statement regeneration; enterprise SDLC initiatives like AP Bank Reconciliation & AR Lockbox interface with Confidential ; the Ledger Migration project; as well as Confidential projects such as project profitability reporting, merger integration, and Quote-to-Cash cleanup of EMEA + startup entities’ go-live. Participated in UATs; executed GL redesign migration for phase 1 and migration testing for phase 2; this involved re-configuration of the G/L system's ledger groups & consolidation rules.
• Operated the PeopleSoft General Ledger daily and during monthly/quarterly accounting close; responsible for Confidential of GL & sub-ledger open/close period, GL accounts, departments, & projects; maintained GL rollup trees, n/Vision reports, & performed analysis on account imbalances. Duties include functional analysis, system re-configuration, and testing.
• Liaised with internal audit and Ernst & Young auditors; provided PeopleSoft support for Hyperion implementation.
• Routinely used PL/SQL Developer, Queries, n/Vision, and BMC Service Desk; wrote over 100 SQL queries.

Confidential

PeopleSoft Financials

Responsibilities:

• assisted with AP/AR monthly close, enterprise SDLC initiatives, Confidential projects, & UAT. Routinely used SAP Business Objects XI, Toad/SQL Queries, BMC Action Remedy, HP Quality Center, IBM Rational ClearQuest and automated Excel models using VBA. Extensive troubleshooting of integration points between AP & VMS-based, loan-level ledger, as well as EDI 820 check interface to Confidential .
• Installed PeopleSoft Applications; PeopleTools; BEA Tuxedo; BEA WebLogic (w/ add, delete & customized reporting of security realms); PeopleSoft Pure Internet Architecture (PIA); Crystal Reports; Micro Focus Net Express 4.0/5.1; SQL Server 2000 & 2008; experienced in PeopleSoft database creation using Database Configuration Wizard (DCW).
• Proficient with peopletools.properties configuration, webprofiles, psprcs.cfg, psappsrv.cfg & psappsrv.ubx config, with thorough understanding of PSADMIN and its nuances. Skilled at coding, debugging, performance tuning Data Mover & SQL scripts in PeopleTools versions 5.x - 8.50, including tools releases 8.46, 8.48, & 8.49.
• Thorough understanding of PeopleTools Development Environment: Application Designer, Application Upgrader, PS/Query editor, n/Vision, as well as Change Assistant.

Confidential

PeopleSoft Inventory, Asset Management

Responsibilities:

• Developed SQL and PS/Query that reconciled PeopleSoft Inventory put-aways and issues to General Ledger Trial Balance - completed 6-month outstanding task in two partial days.
• Conceived, developed, and presented to CAO, CIO, and department heads PowerPoint slides that accurately identified and categorized corrupted AM system into 8 unique problem types: under/over-amortizing assets, cost basis adjustments without asset add transactions, assets stuck in depreciation, assets depreciating to incorrect ChartFields, assets stuck on the PC to AM interface, assets with corrupted ChartField sequence numbers, assets with transaction records missing, assets abend-ing with SQL errors for duplicate key on insert into PS DEPRECIATION, or otherwise - devised 3 potential solutions, and made recommendation.
• Facilitated functional walk-thru sessions reviewing Inventory, Asset Management, and Project Costing process & functionality at Confidential . Reviewed asset ADD, ADJ, TRF, PDP, RET, RCT, BKS, & DPR transactions, as well as asset profiles & categories, PC AM-AMIF1000 Interface, Depreciation Close (AM DPRCLOS), Accounting Entry Creation (AM AMAEDIST), Journal Generator + Journal Edit/Post job (FS JGEN) and other functionality in the system.
• Configured AETs and AE Defn’s to handle retirements-to-sale, retirements-to-inventory, plus other scenarios.
• Collaborated with Property Accounting Manager: conceived solutions to correct over 300 corrupted assets involving ChartField Sequence Number (CFSEQ NO). Delivered 10 highly-tested SQL scripts for Microsoft SQL Server environment or Data Mover that fixed corrupted assets; performed unit test, system tested, and facilitated User Acceptance Test (UAT) on same. Multi-faceted strategy employed delivered functionality, custom scripts, and an asset-delete SQR, with undelete functionality.
• Analyzed processes: Depr-Calc (AMDPCALC), Asset Load, AE Creation, Combination Edit, Mass Changes, group asset processing, Inter/Unit Processing; transactions: Transfers Out (TRANS IN OUT = 'O'), multi-ChartField transfers, multi-trans-coded retirements, multi-ChartField book transfers, multiple books transfers; tables: Ps Open Trans, Ps Cost, Ps Asset, Ps Depreciation, Ps Book, Ps Book Hist, PS Dist ln, Net Book Value Table, Depreciation Reporting Table; and fields: Trans Date, Activity SW, Retire SW, Open Trans ID, Dttm Stamp. Task included numerous write-ups on functionality.
• Invented methodology, and developed SQR program to holistically delete an asset from AM, plus all its touch points in sub-ledgers.

Confidential

PeopleSoft EPM Planning & Budgeting Implementation, Birmingham, AL

Responsibilities:

• Performance Tuning: Developed a holistic tuning & test plan that increased the performance of the P&B application by reconfiguring the application server and application cache running on IBM PSeries servers ( Confidential ); conducting tuning sessions; and by testing and tuning long-running SQL queries (Oracle 10g). Configured Confidential .
• Took a lead role in driving the resolution of several application defects in Data Staging / Model Calculation, a critical path process. Performed testing, analysis, and provided technical expertise on Analytic Calculation Engine ( Confidential ), Application Engine, and PeopleSoft middleware. Task included several write-ups and UAT scripts.
• Proficient in troubleshooting and performance-tuning PeopleSoft Application Server and its middleware components such as: PSAPPSSRV, PSQCKSRV, PSQRYSRV, PSANALYTICSRV, BBL, and Confidential (Process Scheduler).
• Skillful with ALTERS in-place or by table rename; CREATE tables, views, triggers, indexes; and DROPS using both Microsoft SQL 7 through Microsoft SQL 2008 SQL scripts, as well as Oracle 7 through Oracle 10g.
• Created EPM security design; configured and tested security; applied numerous PeopleTools upgrade & application bundles.
• Tested scenarios and performed an evaluation of the installed suite of Enterprise Resource Planning (ERP) software applications and processes. Conducted a review of procurement accounting, general ledger (G/L) reporting and the processing of capital purchases. Presented findings and recommendations to executive, as well as middle managers. Project was under budget and on time.

Confidential, Birmingham AL

Project Manager

Responsibilities:

• Responsible for developing and maintaining the project plan using Microsoft Projects. Designed user acceptance test (UAT) plans, test scripts, software product customizations, data conversions, reporting strategies, and conducted “fit analysis” — managed scope, deliverables, and timelines.
• Compiled and delivered professional documentation on all aspects of project. Project was under budget and on time. These products were implemented to track the capital spending and assets of a multi-million dollar, natural-gas-fired, Confidential generation facility, a peaking plant.
• Provided production support for Confidential ’s applications after each implementation, including AP, AR, GL, PO, IN.

Confidential

PeopleSoft General Ledger, Birmingham, AL

Responsibilities:

• Tested and resolved application defects and corrected customizations to COBOL and PeopleCode programs that many previous firms could not resolve. During the accounting close cycle these defects caused accounting entries to double-post creating many errors on the quarterly financial reports. Corrections reduced the customer’s monthly close process by nearly three days.
• Successfully upgraded, integrated, and tested two live, independent Fixed Assets installations.
• Customized and tested Accounts Payable (A/P) pay-cycle process to create a “lights out” pay-cycle. Modifications required the integration of PeopleSoft Accounts Payable with Control-M scheduler, and the development of numerous Unix Korn shell scripts in an X-windows environment running on IBM AS/400 computers / Confidential .
• Tested and resolved issues with check printing, Crystal Reports, positive payment reports and Accounts Payable voucher matching functionality.
• Provided UAT testing, and consulting expertise in upgrading from Financials release 5 to release 6 - AP, AR, GL.
• Interfaced Accounts Payable check printing software from Bottom Line Technologies to new release of PeopleSoft Accounts Payable. Upgraded and implemented new “positive pay” functionality.

Consultant

Confidential, Birmingham, AL

Responsibilities:

• Responsible for the integration and acceptance testing (UAT) of EDI transactions with PeopleSoft Purchasing Purchase Orders (POs), functional acknowledgement, Advanced Shipping Notice (ASN) . Solely responsible for the coordination of a complex network of integrators including Control & Confidential, Inc. Integrated PeopleSoft IN/PO with Group 8760’s web-based EDI solution, IBM’s Advantis Value Added Network (VAN), and Sterling Software’s ANSI X.12 EDI translator, Mentor. Completed assignment on client’s deliverables schedule.
• Provided consulting and reporting expertise for Purchasing and Inventory implementation. Instrumental in the rollout of Crystal Reports to field offices, integrating PeopleSoft and Crystal Reports to Citrix System’s terminal server.
• Responsible for production support of PO, IN, AR applications after implementation.
• Provided functional and technical expertise during the implementation of Southern Natural Gas Company’s and Confidential Marketing Company’s Accounts Receivable Implementation.
• Provided integration consulting for connecting external billing system and reports with PeopleSoft Accounts Receivable.
• Solely responsible for the production support of Confidential Marketing Company’s Accounts Receivable application.
• Provided functional and technical expertise in PeopleSoft upgrades 2 to 3, 3 to 5, 5 to 5.12, and 5 to 6. Work products include testing; PeopleSoft application configuration and setup; chartfield modification and customizations; Application Engine modifications; Mass Change, Application Designer, and PeopleCode customization; Data Mover scripts, Crystal Reports and SQR reporting; SQL tuning; and SQL*plus reporting scripts. Added many efficiencies to the delivered upgrade scripts and steps. These conversions involved multiple software applications (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, Fixed Assets) across many databases.
• Information Technology Lead for Confidential Marketing Company’s Accounts Payable implementation.
• Performed software customizations and chartfield modifications using PeopleCode and PeopleSoft’s Application Designer.
• Developed conversion programs using Natural 2, and Structured Query Report (SQR) writer, Structured Query Language (SQL) and PeopleTools.
• Interfaced PS/AP with bank, Treasury Services and developed ProComm scripts to conduct cyclical “positive pay” transmissions, a fraud deterrent mechanism.
• Integrated Bottom Line Software’s CheckGard software and Troy’s Magnetic Ink Character Recognition (MICR) printers to PeopleSoft Accounts Payable. Rolled out several check fraud prevention mechanisms including secured electronic signatures.
• Facilitated “fit analysis” as well as integration consulting for connecting Lotus Notes based expense reporting system to PeopleSoft Accounts Payable.
• Sole provider of production support for the PeopleSoft Accounts Payable application of Confidential Marketing Company.
• Instrumental in the design of the corporate general ledger chart-of-accounts structure (chartfield design). Developed numerous conversion programs to split, collapse, and merge accounting entries using the Natural 2 development platform, Structured Query Language (SQL), and Infopump. The conversion took place on the Oracle database engine, Software AG’s adaptable database engine ( Confidential ), and IBM’s DB2 engine.
• Pivotal to the construction of the PeopleSoft chart of accounts for Confidential Marketing (i.e. chartfield design).
• Facilitated & implemented bar codes on G/L journals and A/P voucher reports.
• Served as Project Lead for five-person development team. GPS was developed on a mainframe platform (IBM’s MVS) using Job Confidential Language (JCL), the Natural 2 development platform and Software AG’s adaptable database engine ( Confidential ).