Senior Peoplesoft Consultant Resume
Plano, TX
SUMMARY
I am a Senior PeopleSoft Consultant with 14 years of IT experience. For the past 12 years I have been implementing PeopleSoft Financials for 18 different clients which includes 11 Full-Life Cycle (SDLC) implementation, 5 Upgrades to 8.X, 2 Production Support and have extensive Functional and Technical Experience in implementation of PeopleSoft Contracts, Grants, Project Costing, Billing, Accounts Receivable, Sales Order Management, Inventory, eProcurement, Purchasing, Accounts Payable, Asset Management, Pay/Bill, Procure-To-Pay, Order-To-Cash and GL modules (Version 9.0, 8.8, 8.4, 8.1, 7.5, 7.0 & 6.0).
I have implemented PeopleSoft to various industries as an Architect and Integrator such as Consulting Services, Electronics, Advertising, Energy, Telecom, Health Research, Government Technical Services, Construction, Hospitality, Tax Services, Student Loan, HealthCare, Automobiles, Automation, Logistics, and Manufacturing & Public Sector and have great exposure to above industry’s business practice.
I have worked in several roles with Big 5 Consulting Firms such as Functional Lead, Upgrade Analyst and Financial Analyst. At present I implement and upgrade PeopleSoft by Rapid Package Implementation Methodology using Ready-made Templates, Scripts, Flow-Charts, Documents and Programs thereby saving time and money. I have been trained with PeopleSoft Inc.
Education:
MBA (Finance & Computer Systems)
Functional Expertise:
· Scoping & Requirement analysis (JAD & RAD)
· Gap/Fit analysis (BPR, Bolt-On, Extension, Modification & Point Solution)
· Design (High & Detail Level, Customization/Integration Matrix)
· System Configuration (Control Table Set Up)
· Conference Room Pilot (CRP).
· Data Conversions (Custom SQR & Delivered Interface with Migration)
· Development (People Tools Changes, Patches, Version Upgrades)
· Security (Row Level Security, Permission Lists, Roles & User Profiles)
· Business Process Testing (System, Integration, Stress & Parallel Test)
· Extensive Report Development (SQR/Crystal /nVision)
· Knowledge Transfer/User Training (Hands-On Scripts with Quick Reference Guide)
· Go Live/Cutover Strategy (Parallel, Direct, Phased and Pilot Approach)
· Production Transition/Post-Production Support
Technical Expertise:
· ERP – PeopleSoft - PeopleTools Application Designer, SQR, PS/Query, Crystal Reports, nVision, Tree Manager, Security Administrator, Process Scheduler, Utilities, Business Process Designer, Data Mover, Application Upgrader, WorkFlow Administrator, DBAG & Import Manager.
· ERP – SmartStream Financials – Powerbuilder, Sybase 4.0, WorkFlow Activity Manager, Structures, ODBC.
· Database - Oracle7/8.x, MS SQL Server (6.5), Sybase (6.0), DB2 & PL/SQL.
Experience:
July 2009 to October 2009
Confidential, Plano, TX
Senior PeopleSoft Consultant
For a Consulting Services company Perot Systems Inc, I am a Senior PeopleSoft Consultant responsible for Implementing Contracts Module and have integrated contracts module from sales flow quote system to Billing/AR/OM/Inventory/ePro/AP/GL. My experience includes:
- Extensively involved as a key functional analyst in analyzing, designing, testing and production transitioning of Contracts 9.0 by interfacing contracts data from custom-built Sales Flow Quote system where the contracts are billed under different bill plan utilizing Billing module and recording payments utilizing AR module. Costs are captured by interfacing Contracts with Order Management to create contract SO where in requisitions are created for drop ship Items, sourced through eProcurement to create PO which are dispatched, matched and routed through AP Paycycle to generate payments for vendors. Utilized Inventory module to ship items from existing warehouse to Customers by running Material reservation, picking, shipping and depletion process.
- Created more than 100 test conditions, grouped test conditions under 12 different test scenarios and created step-by-step detailed test scripts for all 12 test scenarios that includes Drop-ship Items scenario, existing Inventory Item ship scenario, Value-addition drop-ship item ship scenario, Partial shipments of Drop-ship/Inventory scenario, Drop-ship/Inventory Combo scenario, Contract Amendments of additional line Items (Freight & Travel) scenario, Partial return of items with credit adjustments to the original bill scenario, Contract Amendments of deleting an existing line Items which are already shipped/billed, Multicurrency scenario of Canadian customer with Items shipped from US vendor and Multicurrency scenario of Canadian customer with Items shipped from Canadian vendor and deferred revenue recognition of Non-ordered items (Service/Support contract) with warranty renewal scenario. Acted as a Test Lead in executing the above scenarios by recording the issues, fixing the errors, retesting the issues and ensuring the entire system is completely integrated with reconciling accounting entries both on revenue/cost.
- Extensively worked and solved complex business process issues of entire Contracts integration functionality by creating several contracts under different Bill plans/Revenue plans with Date/Milestones/User-Initiated events, running the Contract sales order process (OM_EC) to create sales order based on contracts, creating Requisitions from SO, creating PO from requisition using eProcurement where requisitions are automatically quick staged, PO calculated and PO Created, Dispatched PO’s, Received PO’s, created PO vouchers, 3-way matched PO/Voucher/Receipts, posted vouchers, generated Paycycle process to make payments and journal generated vouchers/payments to track cost associated with contracts.
- Extensively worked in tracking revenue/bill from contracts by running Contracts to bill Interface process which are driven by Date/Milestone SQL events (Items are billed only after it is shipped to customers), Billing Interface process, Approving temporary bills, Single-action invoice process which combines 8 different processes such as Pre-process and finalization, Invoice extract process, Proforma, Invoice print, Currency conversion, Billing preload, Load GL to create bill accounting entries and Load AR Items to create Item in AR, running AR update process to ensure the Item is available to record payments from customers, Recording deposits, Applying payments for an Invoice using worksheet, Running AR update process to create payment accounting entries and finally journal generating billing Invoices/AR Payments to record revenues associated with contracts.
Experience:
Feb 2008 to March 2009
Confidential, Irving, TX
Senior PeopleSoft Consultant
For an established Telecom Manufacturer/Electronics company NEC Inc, I am a Senior PeopleSoft Consultant responsible for Setting up Contracts on multiple business units, Interfacing Contracts with various modules such as Billing, AR, Project Costing and Interfacing Concur Travel & Expenses with PeopleSoft Accounts Payables 8.9. My experience includes:
- Managed and acted as a Functional Lead in analyzing, designing, developing, prototyping, testing, production transitioning and supporting Contracts 8.9 and extensively utilized Express Contract, Gross Contract with multiple billing event, Gross Contract for 3rd party fees, Value based contract, transition costs, Rate based contract with Inter Unit Revenue Share, Amount based contract with Inter Unit Revenue Share, Create amendments for amount contract and rebill, write off temporary bill and credit and rebill.
· Setup and Created several Monthly Contracts by defining a new billing plans with ‘Milestone’ Method and converted into bills by executing various application engine process such as ‘Contract-To-Bill’ Interface process, Billing Interface Process, Pre-process/Finalize, Bill Print, Load GL to create billing accounting entries and Load AR to move the Items into AR module.
· Setup and Created Annual Contracts by defining a new billing plans with ‘% Complete’ Method and converted into bills by executing various application engine process such as ‘Contract-To-Bill’ Interface process, Billing Interface Process and Single-Action Invoice process which combines various process such as Pre-process/Finalize, Bill Print and Load AR.
· Processed Annual Contracts utilizing ‘Deferred Revenue’ Method where a revenue plan with ‘Apportionment’ Method is setup for generating revenue’s based on contracts.
· Participated as a key member in Integration of Sales Order Module by creating Sales order and passing the information to Inventory module to execute OM-BILL Interface to move the Order information to Billing Module. Executed Billing Interface Process (BIIF0001) to move interface bills in Single Action Invoicing (AJBIJOB1) for finalizing and printing the invoices.
· Participated in analyzing, designing, developing, prototyping, testing, production transitioning and supporting Concur Travel & Expense with PeopleSoft AP 8.9 by designing a custom-built application engine interface program which reads, validates and transfers the concur expenses of all employees into PeopleSoft EDI-delivered format which finally gets converted into PeopleSoft Vouchers by utilizing a delivered EDI Manager.
May 2007 to December 2007
Confidential, Dallas, TX
Senior PeopleSoft Consultant
For a reputable media company IDEARC Inc, I am a Senior PeopleSoft Consultant responsible for Upgrading PeopleSoft 8.9 financials and my experience includes:
- Involved in Business Process Review by interacting with end-users using RAD techniques and translated them into feasible solutions for PeopleSoft Contracts, Projects, Billing & AR.
- Participated as a key member in formulating GAP/FIT analysis and implemented strategies such as Evolution and Adaptization techniques incorporating new features/functionality.
- Thoroughly Tested the Contracts/Billing/AR/GL by creating Test Conditions, grouping test conditions to form Test Scenarios representing a logical business process flow, Creating Test Scripts for all the test scenarios and Executing the test scripts under different Test Cycles for System Test (Unit Test), Integration Test and Volume Test (Stress Test).
- Acted as a Lead person in performing Go-Live Task by facilitating Cut-off strategies such as Direct approach and provided post-production support.
Sept 2006 to April 2007
Confidential, PHILADELPHIA, PA
Senior PeopleSoft Consultant
For a reputed university Temple University Health Systems Inc., I was a Senior PeopleSoft Consultant responsible for Implementing PeopleSoft 8.8 Grants/Projects/Contracts and my experience includes:
- Conducted Fit/Gap Analysis using JAD (Joint Application Development) Technique with a large team comprising of user-groups spanning across multiple departments.
- Involved in Grants business process by creating several proposals, establishing the proposal budget, processed the ‘Print a signature page’ for authorization and copied an existing proposal to create new proposals.
- Involved in Grants Pre-Award business process by submitting proposals to various sponsors, negotiating award details with sponsors by tracking the type of negotiations, the status of negotiations and contact information. Managed an award projects with activities, managed award budgets and reviewed grant information.
- Involved in Grants Post-Award business process by setting up a letter of credit contract, Setting up cost reimbursement contract, Approving the Billing worksheet for LOC/Non-LOC contract, billing interface process, single-action invoice process and applying payments in AR for invoices.
June 2006 to August 2006
Confidential,Dallas, TX
PeopleSoft Contracts, Billing & AR Consultant
For Outstanding Real Estate Management Company, Jones Lang Lasalle Inc., I was a Contract Functional Consultant responsible for Implementing PeopleSoft 8.8 Contracts, Billing and AR Modules and my experience includes:
- Involved in Fit/Gap Analysis for an international project by interacting with end-users in countries such as Singapore, Japan and Taiwan by recording requirements and prioritizing them thereby translating business process into feasible solutions.
- Configured the contract system by inputting data for Rates for Employees, Rates for Job Code, Rate Templates, Project Types, Activity Types, Accounting Rules, Burden Templates and Burden Plans.
- Supported and Trouble-Shooted various Project Costing Business Processes such as setting-up of new projects and estimating project costs, Creating Contracts once the client approves the projects and running interface estimates from Contracts Process (INTFC_CNTRCT) and scheduling and processing Billing to create bills. Executed Billing Interface Process (BIIF0001) to move interface bills in Single Action Invoicing (AJBIJOB1) for finalizing and printing the invoices. Finally executed the PSAACCTGL process to move the data from PROJ_RESOURCE Table to GL and executing BIPCC000 process to move the billed invoice data into Projects/Contract table before running the Billing Adjustments to Contracts (PC_BI_TO_PC) Process.
Nov 2005 to April 2006
Confidential, St. Louis, MO
PeopleSoft Projects/Contracts/OM/Billing/AR Functional Consultant
For Leading Weather Forecasting Company, Surface Systems Inc., I was a Functional Consultant responsible for Implementing and Upgrading PeopleSoft 8.8 Project Costing, Contracts, Order Management, Billing and AR Modules and my experience includes:
- Reviewed and setup the Project Costing/Contracts/Billing/AR System Configuration by validating the data for General Setups and Structured Project Option Setups.
· Designed and built the entire Contracts Module for Deferred Revenue Accounting and Regular Billing Accounting entries by setting up several contracts for monthly and annual contracts and executing CABI Interface process to move the contract data into Billing Interface Tables and running Single-Action Invoice process to generate invoices.
· Upgraded Sales Order Management/Billing/AR modules for 3 different business units such as Energy Absorption Group, Nu-metrics and SSI group from Peoplesoft 8.0 to 8.9 by working on several phases such as System Configuration, Data Migration, Testing, Production Transition and Production Support.
Due to abridged version of the resume, I would like to highlight the salient feature of my experience with the following projects (Details can be given upon request):
June 2005 to September 2005
Confidential, DALLAS, TX
PeopleSoft Project Costing Functional Lead
July 2004 to March 2005
Confidential, SADDLEBROOK, NEW JERSEYPeopleSoft Projects/Billing/AR Functional Lead – 8.8 Implementation
March 2004 to July 2004
Confidential, BEDMINSTER, NEW JERSEY
Projects/AP/GL Functional Analyst – 8.4 Upgrade
October 2003 to December 2003
Confidential, HOUSTON, TEXAS
AP/Purchasing/Projects Functional Lead – 8.4 Upgrade
March 2003 to August 2003
Confidential, CHANTILLY, VIRGINIA
AP/Purchasing/GL Functional Lead – 8.4 Upgrade
Oct 2002 to Jan 2003
Confidential, OMAHA, NEBRASKA
AP/GL Functional Analyst – AP/GL 8.4 Implementation
April 2002 to Oct 2002
Marriott International WASHINGTON D.C.
Project Costing Analyst – PC/Contracts & Travel/Exp 8.4 Implementation
July 2001 to Dec 2001
Confidential, KANSAS CITY, MO
Upgrade Lead – ASSET MANAGEMENT 8.1 Upgrade
Jan 2001 to June 2001
Confidential, RESTON, VA
Senior Functional Consultant – Purchasing/AP 8.0 Implementation
July 2000 to December 2000
Confidential,DALLAS, TX
Senior Consultant – Team Lead – Accounts Receivable 7.53 Implementation
August 1999 to May 2000
Confidential, LOS ANGELES, CA
Senior Consultant – Functional Lead – PeopleSoft AP/Projects 7.5 Full-Life Cycle
May 1999 to July 1999
Confidential, DALLAS, TX Senior Consultant – Test Analyst – PeopleSoft Purchasing/AP 7.5 November 1998 to April 1999
Confidential, ATLANTA, GA
Consultant - Financial Analyst – Support PeopleSoft AP/Billing/AR 7.5 From 7.0
July 1998 to October 1998
Confidential, BOSTON, MA
Feb 1998 to June 1998
Confidential, AUSTIN, TX
Consultant – Developer – PeopleSoft GL 6.0 Implementation & Support
COGNI Confidential,INDIA
Product Consultant for SmartStream Financials - AP, AR, GL & FA 4.0
CONCLUSION:
· I am a Hands-on, Subject-Matter Expert with experience in various phases of project and have solved complex business issues and possess Multi-task Skills of Functional and Technical expertise.
· I provide the best Real World Solutions by giving support to documented deliverables and hands-on training.
· I can Work Independently and in a Team Environment.
· I have strong Written and Verbal communication skills and work in a structured, detail-oriented and systematic manner.
· I am well versed with Business Process Flow of Financial and Distribution Modules Data Flows between these modules and their Accounting Entries, the various Table Structures of the modules