Project Functional Consultant

SUMMARY

** ***** ********** **********: Analysis, Design, Development, Team

Leadership in PeopleSoft Financials and Supply Chain 9.0 8.9, 8.8, 8.4,

. Full life-cycle PeopleSoft Implementations, Interfaces, Conversion,

Production Support, Training

. Strong verbal and written communication skills

. General Ledger, Accounts Payable, Asset Management, Project Costing,

Inventory, Enterprise Performance Management (EPM)

. PeopleTools, PeopleCode, Application Engine, SQR, PS Query

Tools, Environments, Databases: PeopleSoft Training Completed:

PeopleTools, DB2, Oracle, Remedy, PeopleTools, SQR, PeopleCode,

SQLPlus, MVS, Excel, COBOL, Application Engine, PS Query, Crystal

UNIX, MS Access, SQR, Reports,

Mercury Quality Center General Ledger, EPM Bootcamp

PROFESSIONAL EXPERIENCE

1 Wells Fargo Bank, Minneapolis, MN 12/2009 to

01/2010

Technical Consultant for PeopleSoft EPM 9.0 Implementation

. Created custom Application Engine for Partner Balancing. This engine

generates Account node balances by Organization for three levels:

Equity, Total Assets, and Total Liabilities.

. Created Allocation File Upload process. This page allows users to

upload allocation files (Filters, Distribution Methods, and Standard

Allocation Rules) from their desktops to the server.. The upload

triggers an Application Engine to edit and stage these files. The

page displays each file's upload status as well as any edit errors.

. Responsible for troubleshooting and minor fixes, page modifications,

as well as performance tuning,

2 Blue Cross Blue Shield of Louisiana 07/2008 to

11/2008

Tech-Functional Lead

Designed and implemented Positive Payment for PeopleSoft A/P 8.4

and 9.0

. Built new Positive Pay functionality to integrate with daily EDI

and Bank Statement load processes. Also integrated with external

Treasury application for reconciliation and with PS A/P for voucher

completion.

. Coordinated between functional team, Treasury, Communications

Group, AP users, and Capital One bank

. Gathered requirements, created functional and technical

specifications

. Provided training for AP users

. Using Mercury Quality Center, created Test Plan, test scenarios,

performed unit testing, designed and coordinated user testing,,

documented requirements, test cases and test results

. Provided user support, new enhancements, developed Test Scripts,

conducted testing and training

Performed requirements analysis and helped prepare various project

proposals for Kaysoft

3 Lowe's Companies, Wilkesboro, NC 10/2005 to 4/2008

Techno-Functional Consultant

PeopleSoft 8.4 and 8.9 AP, GL, AM, PC, KK.

. Production problem troubleshooting

. Performed defect analysis of delivered processes, developed fixes or

got solutions from PeopleSoft

. Resolved several integration issues between PO->AP->PC->KK and GL.

. Provided analysis, design and development support to GBI project team

implementing PS AP/PO

. Resolved defects in inbound and outbound custom-built interfaces such

as AP to Data Warehouse, Inbound Invoices etc...

. Provided user support, new enhancements, developed Test Scripts,

conducted testing and training

. Created numerous Business Design and Technical Design documents

. Analyzed PS Audit reports, documented and resolved 50+ discrepancies

between DB2 and PS index definitions

. Created and modifed PS Queries per user requirements

4 State Dept of Transportation, Cheyenne, WY 5/2005 to 10/2005

Techno-Functional Consultant

PeopleSoft 8.8 Financials implementation

. Project Costing Conversion lead: used Application Engine and SQR to

extract and convert Job Table data

. Modified pages, created Message Catalog entries, migrated projects,

created Data Mover scripts to grant permissions. PeopleSoft Training

Facilitator

Kaiser Permanante, Pasadena, CA 3/2005 to 5/2005

PS Training Facilitator

. Lead a series of 3-week PeopleSoft training bootcamps for COBOL / DB2

client . Subject matter included Requirements-gathering and Standards-

compliance as well as basic SQR, Application Designer, Application Engine

and PeopleCode.

Educational Testing Service, Princeton, NJ 6/2004 to 2/2005

Techno-Functional Consultant

PeopleSoft 8.4 Financials implementation

. Conversion lead. Used Application Engine to convert legacy balances

into PS Billing and General Ledger.

. Developed user-friendly pages using PeopleCode to perform numerous

edits and to embed Tree Viewer in pages.

. Built a series of SQR programs using Project and Department trees to

report monthly costs and labor hours.

5 Capital One Corporation, Richmond, VA 5/2001 to 5/2004

Functional Consultant

PeopleSoft 8.8 EPM implementation

. Business Systems Analyst for PeopleSoft EPM 8.8 financial warehouse

implementation. Worked closely with end-users in corporate management

to gather requirements. Created business and system requirements for

Other P&L Allocations, Loan Loss Allocations, and Balance Sheet

Allocations.

. Designed bolt-on reconciliation process to verify that EPM financial

warehouse balances with General Ledger.

. Managed requirement gathering / refinement process in Rational

RequisitePro for new EPM-based Dimensional Hierarchy System (DHS).

Responsible for DHS requirements change management using Rational

ClearQuest. Liaison with EPM test team during DHS test script

development.

Techno-Functional Consultant

PeopleSoft 8.1 Financials implementation

Asset Management Conversion Technical Lead for PeopleSoft 8 Asset

Management implementation. Used Oracle SQLPlus to extract assets from

legacy tables. Used SQR to convert 20,000 assets across 215 Business

Units.

. GL Conversion Team Lead for international PeopleSoft 8 implementation.

Designed, constructed, tested, and executed multi-currency conversion

of a half-million legacy journals to PS General Ledger in an

UNIX/Oracle environment. Created Application Engine/PeopleCode,

PeopleSoft pages, and SQR programs to convert ChartFields, translate

international currencies, validate converted values, and load journals

for multiple ledgers. Also converted monthly and daily currency

conversion rate data with Import Manager.

HMS Host, Bethesda, MD 1/2001 to 5/2001

Technical Consultant

PeopleSoft 8.4 Financials upgrade

. Analyzed and modified numerous customized SQR programs in upgrade of

PeopleSoft Financials

. Migrated projects between PS instances, created Data Mover scripts to

grant permissions.

. Created numerous Business Design and Technical Design documents

. Created or modified PS Queries per user requirements

8 Duke Energy, Charlotte, NC 6/2000 to 1/2001

Techno-Functional Consultant

PeopleSoft 8.1 Corporate Consolidations GL Conversion

. Created process to generate balancing GL journal entries for inter-

Affiliate transactions. Greatly enhanced the speed and accuracy of the

monthly consolidations process.

. Designed and built bolt-on process to maintain new tables. As

technical lead on DENA General Ledger chartfield conversion project,

used Microsoft Access, COBOL, and DB2 to develop and implement a GL

chartfields conversion.

National Gypsum, Charlotte, NC 7/1999 to 6/2000

Techno-Functional Consultant

PeopleSoft 7.5 Financials implementation

. Conversions lead for Inventory and Asset Management. Gathered user

requirements, created design specifications, detailed conversion

procedures, PeopleSoft panels, mapping tables, program specs and test

plans. Developed in COBOL, SQR, SQL, Access, Crystal Reports, and DB2.

. The Inventory conversion was accomplished via two paths. One path

resulted in the loading of the Master Item table and associated Item

attribute tables. The second path loaded default location values and

provided the actual inventory balances on hand. Used PeopleSoft's

delivered Load Stage table process was to coordinate the loading of

all remaining tables.

. For Asset Management, converted 40,000 legacy assets for 42 business

units across the US and Canada. This required mapping and translating

complex combinations of legacy values to three PeopleSoft AM loader

tables. Used Transaction Loader (AMIF1000) to load the numerous AM

tables, and Depreciation Calculation (AMDPCALC) to calculate

depreciation. Tweaked delivered loader to reduce its run time to less

than half. Developed rapid method of re-running Depreciation Calc.

10 Walker & Associates, Welcome, NC 2/1999 to 6/1999

Techno-Functional Consultant

PeopleSoft 7.5 Financials Upgrade

. Used PeopleTools to create and modify records, menus, and panels.

Communicated daily with system users. Modified and debugged nVision GL

reports, created Crystal Reports, and wrote SQR programs. Researched

PeopleSoft's Item Loader and presented findings to client management.

11 Duke Energy, Charlotte, NC 10/1997 to 12/1998

Techno-Functional Consultant

PeopleSoft 8.1 Financials implementation (Accenture project)

. Technical lead for PeopleSoft Projects conversion on FMIS project.

This required intensive interaction and co-operation with users.

Designed the conversion path by which we converted legacy system Work

ID's to PeopleSoft Projects. Worked extensively with PeopleSoft

Projects data. Designed, built, and tested programs and panels for

data extraction, translation, reformatting, and loading into

PeopleSoft tables. Directed work of several developers.

. Helped to design and implement interface architecture linking legacy

and PeopleSoft GL, AR, and Accounts Payable systems.

. Designed legacy Feeder System Interface File layout, Inbound Bank

Statement process, AP Interface Reformat and Post process, and AP

voucher load process via EDI.

US Airways, Winston-Salem, NC 5/1992 to 4/1995

13 Technical Consultant

. Performed maintenance and new development of US Airways Frequent

Traveler system. Wrote numerous COBOL/DB2 batch and online CICS

applications. Re-wrote the Member Statements sub-system. Created the

New Enrollments function.

Planters Lifesavers, Winston-Salem, NC 12/1991 to 4/1992

14 Technical Consultant

. Maintained COBOL/JCL Order Entry system and EDI programs interfacing

with external vendors.

Sara Lee Corporation, Winston-Salem, NC Tech Consultant 8/1987 to 11/1991,

5/1995 to 10/1997

. Participated in DSD Re-engineering project for the Hosiery division: a

multi-platform Order Processing system spanning hand-held

computer/scanners, UNIX on Sun servers, and MVS on IBM mainframe.

Provided enhancements in COBOL/DB2, CICS, as well as in C using Sybase

stored procedures on UNIX. CICS/DB2 maintenance for Coach Leatherwear

division. CICS/DB2 development for many new systems including Customer

Information Management, Order Entry, Order Processing, and Topline

Forecasting.

Systems Analyst and Programmer

Calif. State Auto Assn., San Francisco, CA 7/1986 to 8/1987

Wells Fargo Bank, San Francisco, CA 6/1984 to 7/1986

Crocker Bank, San Francisco, CA 5/1982 to 6/1984

. All were TSO, COBOL and JCL batch systems.

Contact this candidate