SUMMARY:

• General PMP (PMI Certified) Project Management Professional with over sixteen years of experience in financial applications in PeopleSoft . Experience in planning, analysis, design, development, integration and support of applications for large and small enterprises.
• ERP Skills Extensive technical and functional experience (16+ years) with PeopleSoft Financials modules GL, AP, AR, BI, PC, AM and EX modules.
• Full life - cycle experience with PeopleSoft ERP implementations, customi zations, application development and production support .
• Expertise in administration of PeopleSoft Internet Architecture and excellent technical and functional knowledge of ancillary PeopleSoft applications.
• Proficient in PeopleSoft tools and functional knowledge of financial modules.
• Very good functional knowledge and setup experience with proper table loading sequence in PeopleSoft Financials /SCM modules implementation and upgrade.
• Designed and documented various inbound/outbound interfaces for PeopleSoft with various 3rd party systems using AE and SQR.

TECHNICAL SKILLS:

ERP: PeopleSoft 7.5/8.0/8.4/8.8/8.9/9.0/9.1

PeopleSoft Tools: Application Designer, People Code, Application Engine, Change Assistant, Tree Manager.

General Ledger: , Accounts Payable, Accounts Receivable, Purchase Order, Billing, Asset Management, Order Management and Inventory

Reporting Tools: SQR, PS Query, BI publisher, OBIEE 11g Analytics

Debugging Tools: SQL Trace, People Code Debugger, Application Engine Trace

Integration Tools: File Layout, Component Interface, Integration Broker, Application Messaging, SAP XI

EXPERIENCE:

Confidential, Madison, WI

Senior PeopleSoft Techno/Functional Consultant

Environment: PeopleSoft Applications Version 9.0/9.1 (GL, AP, EX) People Tools 8.49/8.51 (IB, Application Engine, Component Interface, PS Query, Tree Manager) People Code, SQR.

Responsibilities:

• Journal interface standardization to load data from multiple subsystems.
• Configure Summary Ledger for YE and QE reporting performance.
• Audit extracts as needed by external auditors.
• IU template pairs mapping and loading.
• System performance for allocations, Posting and loading journals, nVision reports, queries etc by identifying proper indexes on Ledger and Journal tables.
• Support for day to day activities and close related activities during month end and year end.
• Combo edit inquiry custom tool to have the proper combinations without Combo explode.
• Archiving GL data to improve the performance.
• Performance tuning of PS query from the server side tuning for query timeouts and set the query time out in the security for the queries in the user profiles.
• Production support issues related to GL, AP and Expenses modules.
• Security mapping to align with the corporate Policies.
• Application server configuration changes to tune for new processing loads for online/query activity.
• New reporting process scheduler servers with Dirty read configurations.
• Migrations/Change control process for managing the projects between environments.
• Support for all system admin functions.

Confidential

Senior PeopleSoft Techno/Functional Consultant

Environment: PeopleSoft Applications Version 9.1 (GL, AP, AR, BI, PC, AM) People Tools 8.50 (IB, App Designer, Application Engine, Component Interface, PS Query, Tree Manager) People Code, SQR

Responsibilities:

• Prepare functional & technical specification for various customizations in different modules like AP, GL, AR and BI.
• Work with Business analysts and design the technical specs required for interfacing the legacy system to the PeopleSoft accounts payable module.
• Modified the AP Bank reconciliation process to validate with the custom treasury department application. Stage the data for reporting with custom descriptions from the treasury application for high value items.
• Modified Journal Edit process (GL JEDIT) to avoid PeopleSoft delivered anchor concept by making changes to Application Engine Process. Added new AE Sections/Steps/Actions to implement Fund Balancing concept while generating offsets as a part of Journal Edit Process.
• Modified App Engines in AP (AP VB EDI, APVCHREDIT, AP PSTPYMNT) to update the Voucher ID field on PS ITEM ACTIVITY for refund transactions that come from AR, custom validations on voucher edits and additional withholding details tracking for payment posting process.
• Modified Dunning Application Engine (AR DUNNING), which was not populating the address values to print Customer country.
• Customized PROJECT ACTIVITY component interface in PC to load with external data from spreadsheets with custom validations related to the dates and Statuses etc.
• Created a custom process to load the project transaction level details before the Delete utility runs and stores the data in custom tables for review purposes and audit.
• Created specs and reports for AM users for review of depreciation and Net book value details after the Calculate Depreciation was completed.
• Modified the application engines for Asset Management Accounting entry creation process (AM AMAEDIST & AM AMDPCLOSE) for DPR entries and non-depreciation entries.
• Developed Application Engine program for batch journal approvals using 'JOURNAL ENTRY' Component Interface.
• Developed a custom Application Engine programs for Customer & Billing interface from External system into PeopleSoft.
• Customized BILDAR01 to populate Pending Item table in Accounts Receivables. Modified lockbox load process to load deposits in the AR module.
• Developed Cash advances and payment data to AP reconciliation report.
• Fit/gap analysis, analyze customization of online objects after reviewing the compare reports during the upgrade and flag the objects as needed for migration.
• Customized aging reports like AR30001, 30002, 30003, and 30004 as per end user specification.
• Designed and Customized reports for GL, AP, PC and AR modules like (Summary, P/L Report, Detail Balance report, Customer balances with variable criteria, Vendor payment projection etc.)

Confidential, Houston, TX

Lead PeopleSoft Techno/Functional Consultant

Responsibilities:

• Developed time schedule and strategy for development, testing, and quality assurance for the following projects: Cost Management System phase II, People Tools upgrade, and multiple PeopleSoft application bundle upgrades. Work with team members to meet the milestones per the schedule.
• Prepared and executed strategy for cutover and deployment of IT projects, including responsibility for preparing cutover checklists and running mocks to provide task implementers with hands-on experience in preparation for go-live, coordinate UAT and resolve issues .
• Performed monthly maintenance on Cobol Tables (both shared/non-shared) and completed performance- related maintenance such as archiving messages to reduce system load, etc.
• Extensive experience in developing interfaces with various applications using different technologies like XML, flat files, SQR, etc. In-depth knowledge of Oracle database and portal environments. Performed development using new tools and technologies to fulfill business requirements.
• Fit gap analysis of the acquired company’s business processes with WM’s existing business processes and Establish business units, Distribution Codes, journal sources and accounting entry templates.
• Configure and Customize Allocations logic for monthly journals to create based on dynamic pool data coming from third party systems.
• Worked on setup procedures for Reconciliation process in AP and also customized Pay Cycle Manager in AP for business needs.
• Expertise in enhancements and issue resolution including technical and functional understanding of the Application and good knowledge of processes like APPBVCHR, Pay Select, Voucher and Payment posting in AP, Transaction Loader, Depreciation Calculation and Accounting Entry creation process in AM, PC to AM process, AP to PC process and Journal generator (FSPJGEN) from all Financial modules to GL, etc. Experience with processes in COBOL SQL, Application Engine, SQR’s and People Code.
• Knowledge of Application functionality and technical helped to resolve or develop new functionality.
• Changed and ran DMS scripts to fix stored statement errors related to Allocations, GL edit and GLPPOST processes in GL.
• Created more Non-shared Temp tables to improve performance of online GL Edit. This enabled the system to avoid using the shared table as often. Performance increased dramatically after the change.
• Fixed/Enhanced application features to address issues occurred and resolved them by making changes in Application Designer for PS Objects, Application Engine, SQR’s and DMS scripts, etc.
• Developed GL Interface that loads data from various external systems into PeopleSoft General Ledger using SQR , which includes implementing complex business rules like Combo Rules , subtotals on Business Unit level, grand totals, error handling procedures, printing multiple output reports maintenance report and processed file report.
• Developed several GL SQR reports such as Daily Transactions by Dept, Daily Transactions by Account, Statement of Condition (Daily, Monthly) and Earnings reports (Daily, Monthly).
• Handled BI, AP, PO and GL production issues.
• Developed outbound interface to send GL Actuals and Budgets data in a pipe-delimited file.
• Built custom Application Engine programs to stage expense and time entries to PC EMP RES TM table those are to be pulled into Projects.
• Resolved GL, AP and BI month end close issues.
• Modified invoice print programs for specific requirements.
• Developed Payable Interface for uploading the custom Invoices in to AP using component Interface.
• Configured and Customized PC AP TO PC process as needed by the project team to capture the details of Category based on the accounts.
• Developed Projects Workflow and maintained with enhancements.
• Category search functionality has been added on the PO line.

Techno/Functional Lead

Confidential Houston, TX

Responsibilities:

• Applied bundles to the system ran compare reports, migrated projects and batch jobs after reviewing the source and target objects. Compiled the COBOL’s after bundles were applied on servers, etc.
• Worked on sys audit issues regularly to help minimize their volume, resolved issues related to environment refreshes, changes to the servers, migrations, FTP files from UNIX servers to the team, etc.
• Oversaw Tools upgrade, Web-logic upgrade, etc. and coordinated issues with the upgrade and development teams resolving numerous issues.
• Assisted with Vertex upgrade and install for the newer releases , maintenance and UAT .
• Created SQR Interface (Inbound & Outbound) and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, Derive various values based on the data from the external system.

Techno/Functional Lead

Confidential, St Louis, MO

Responsibilities:

• Customized PC RPO App engine process not to overwrite the data for a duplicate run for all business units and fixed issues with the RPO group having more groups by fields.
• Resolved Pay cycle-related issue to recreate Checks for a Bank if it has positive payment file process. If Checks process errors out, then it will let you run all the other steps and after you try to restart checks system will force to rerun the other steps as well.
• Changed the Bank reconciliation rules, which are used by Bank Recon Process (FSPRECON) application engine process-to-process only unreconciled payments.
• Changed interfaces to read and manipulate data with correct projects information to address Voucher Build not validating /data for Project information and keeping vouchers in recycle status.
• Reviewed voucher edit errors component for behavior anomalies between Pre-edit errors versus Voucher in Recycle status. Enhanced feature for pre-edit errors to enable the ability to manipulate chartfield information for Projects, if user knows that it is in error (Invalid activity or Resource type) for that project chart field.

Techno/Functional Lead

Confidential, Houston, TX

Responsibilities:

• As a System Administrator for production, worked on maintenance of application servers, process schedulers on UNIX, and migrations to production.
• Worked on the upgrade and helping with issues related to application and PeopleSoft security. Worked on upgrade in applying and testing custom functionality, changes to custom process and pages in version 8.4.
• Customized various Application Engine processes, SQR’s, and created online customizations using People Code.
• Years of experience with financial modules in 6.0/7.x/8.12 and 8.4 were instrumental in resolving several issues related to application functionality, customizations, interfaces, and processes related to external feeds, etc.
• Applied Patches and bundles in 8.4/7.5 and support on PeopleSoft application issues.

Techno/Functional Lead

Confidential, Houston, TX

Responsibilities:

• Worked on development, customizations and support of PeopleSoft Financials GL, AP, AR, BI, and AM & PC Version 8.16/8.14, 7.58 and 7.52. Changed existing conventional interfaces and processes to use PeopleSoft 8 integration tools such as Component Interfaces and Application Engine.
• Worked on several interfaces that feed data from external systems to multiple PeopleSoft modules. Familiar with Application Messaging, setting up Message nodes and Application-messaging Gateway.
• Collected functional details on several requirements, coordinated and completed the development/customization with other team members.
• Worked closely with eCenter in coordinating issues related to hosting, and also worked on several changes to PeopleSoft applications to keep the functionality in sync with the corporate environment. Helped in fixing several problems with eCenter environment, as well.
• Development/customization of both custom and delivered applications. This includes changing major processes for customer needs.
• Scheduled jobs to run automatically on the server to balance the load on the system.
• Applied patches and fixes, etc.
• Performed tuning of SQL for processing, reports and slow response times in panels, etc.
• Used the following tools extensively in People Soft: Application Engine, Tree Manager, PS Query, and Application Designer, SQR’s, Crystal, Import Manager, Data Mover.

Techno/Functional Lead

Confidential, Purchase, NY

Responsibilities:

• Designed Interfaces for AP from which data from different Sources were brought to PeopleSoft.
• Set up Banks and Payment methods for Banks.
• Set up New Step Definitions and Step Groups for different Pay cycles.
• Set up the System to make Payments in different forms like EFT, ACH etc. using People soft existing Functionality.
• Worked with all AP Processes related to Voucher Processing, Creating Payments, Posting to Accounting Lines, Posting to GL etc.
• Supported the AP system on production issues in Voucher Processing, Making Payments and Posting them to General Ledger, etc.
• Performed Technical Support for Other People soft modules (AR, BI, GL).
• Developed several Aged Trial Balance Reports (Detail & Summary) depending on different criteria
• Added New Functionality to the existing PeopleSoft AR System to report on external invoices interfaced into PeopleSoft system.
• Completed performance tuning for various AP and AR processes. Added indexes to records and modified People Soft delivered views with regards to performance tuning.
• Acquired much strength including complete understanding of database objects and tuning with respect to processes, and creating SQL queries to diagnose and correct problems occurring in PeopleSoft, identifying patches and applying them, etc.

PeopleSoft Techno/Functional Consultant

Confidential, CA

Responsibilities:

• Responsibilities for PeopleSoft Financials V. 7.5/7.0 (GL, AP, AR) included:
• Setting up Journal Generator for Asset Management, which included the definition of Journal generator templates and Accounting entry definition.
• Converting from legacy system to PeopleSoft system and populate the basic Asset management tables.
• Getting the depreciation and Net Book Values with the correct data as NUMMI needs.
• Developing SQR to update the customer credit authorization database and check whether the sum of the amounts are equal, closes the authorization by updating the approval status for the particular authorization, SQR ran every day after the AR update process.
• Developing SQR for converting the Customer Conversion Notes from the legacy system into PS tables. The SQR was developed to bring selective historical data from the legacy system.
• Developed SQR for the data conversion of the salesperson’s data from the legacy system to People Soft Accounts Receivable system.
• Developed SQR to report all credit authorizations during the day for the reporting purposes.
• Modules developed included:
• Retirements Report: To report gain or loss on Asset disposals for Asset id and Account in each Category;
• Depreciation Sub ledger: To validate GL depreciation and provide a detailed report of GL depreciation balance as of year and date for Category and Product. This gave Cost balance, YTD depreciation, LTD depreciation and Net Book Value for each Asset ID;
• CIP Sub ledger by Account number for WIP: To support GL CIP account balances, all fields required for this report are generated during the CIP add procedure. If a CIP asset were added online, it would not have the vendor name.

PeopleSoft Techno/Functional Consultant

Confidential, Dallas, TX

Responsibilities:

• Worked on development, customizations and support of PeopleSoft Financials GL, AP, AM and was involved in the implementation and customization of the Accounts payable module of People Soft Financials. Responsible for:
• Functional and technical aspects of setting up People Soft AP module.
• Configuring and implementing Accounts Payables system of People Soft Financials (7.0).
• Obtaining requirements to get current business processes and Gap Analysis. This involved heavy interaction with end users.
• Transferring data from legacy system to People Soft tables using Data Mover and Import Manager. Flat file conversion was also used in this process.
• Reporting tools such as PS/n vision, Crystal Reports as well as SQR were used for generation of reports.

Programmer/Analyst

Confidential

Responsibilities:

• This project was for an American-based oil company. The system allowed users to add/edit values for tax rates, wedge defaults, interest rates and project details based on drilling costs for a particular year. It also allows the user to assign an engineer for different project areas. Users were able to make annual forecasts for 25 years with information such as oil gas production, injection streams, disposals per day, capital, and reserve transfers for oil and gas. Responsibilities included:
• Database design, implementation and tuning
• Implementing all the DML statements by stored procedures