SUMMARY

• More than 7+ years of experience in Implementation, Upgrade of PeopleSoft Financials & Supply chain Management.
• Extensively used People Code, Process Scheduler, Data Mover, SQR, and Application Designer in developing batch and report applications.
• Strong knowledge in PeopleSoft Financials and Supply Chain Management (AR, AP, GL, BI, T&E, AM, PO, INV, CONTRACTS, e - Pro).
• Experienced in working with Report Generation in PS Query, XMLP, PS/nVision and Crystal Reports.
• Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Expertise in the development of Conversion and Interface programs using SQR, Component Interface and Application Engine,Integration Broker.
• Performed extensive debugging and performance tuning of various processes.
• Used Peoplesoft Integration Broker for real time interfacing of peoplesoft systems with external systems.
• Created and modified Application Packages as needed for use with Integration Broker.
• Analysed Upgrade Plans, executed and reviewed Compare Reports, applied Upgrade Application steps, fixes and patches for the upgrade process, and performed production test moves.
• Expertise in troubleshooting of various technical and functional issues.
• Proficient in creating and customizing pages and tables using Application Designer and PeopleCode.
• Expertise in documenting technical specifications for customizations in various modules.
• Development and modification of Outbound and Inbound Interface programs.
• Involved in development of Test Plans, writing and execution of test Cases and generation of Test scripts.
• Experience with Data mapping and Conversion of data from legacy systems to PeopleSoft system.
• Adaptable to work both as a team member as well as independently.

TECHNICAL SKILLS

ERP: PeopleSoft Financials and SCM 8.4, 8.8, 8.9, 9.0, 9.1

ERP Modules: Billing, Accounts Payable, Accounts Receivable, General Ledger, Purchase Order, Inventory, T&E, Contracts, Asset Management

People Tools: Application Designer, Application Engine, Component Interface, Workflow, Process Scheduler, Data Mover, People Code, Tree Manager.

Reporting Tools: SQR, Crystal, PS/nVision, XMLP.

Languages: People Code, SQL, PL/SQL, C

Operating Systems: Windows 98/NT/2000/XP/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Responsible for developing Interfaces for AR, Billing and Vendors from Peoplesoft toNetsuite.
• Developed Interface to Travel and Expenses
• Involved in design and development of GL interfaces from 3rd party system to peoplesoft
• Customized XMLP check printing
• Supported AM and PC issues
• Developed Interface for Sales Orders from Netsuite to Peoplesoft.
• Developed Interface to create Purchase Orders with in peoplesoft from the Netsuite Orders.
• Primarily responsible for developing report to display Purchase orders created within peoplesoft for the corresponding Netsuite Orders.
• Developed 3rd party interface to load cash payments into AR
• Involved in designing the Interfaces, Reports and customization of the reports for the AR, AP, and GL Modules.
• Used integration broker to integrate data from FMS to Netsuite.

Confidential, St. Louis, MO

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Performed enhancements and customizations of PeopleSoft Financials
• Analyzed AE reports and worked with the functional analyst to develop in XMLP.
• Involved in designing the Interfaces, Reports and customization of the reports for the AR, AP, and GL Modules.
• Supported people soft T&E systems.
• Modified BIIVCPN process to print custom Invoices as per the client need in BI.
• Supported in troubleshooting of processes like Payment Selection and Creation, Voucher Posting (AP PSTVCHR) and Payment Posting (AP PSTPYMNT) in AP.
• Used integration broker to integrate data from HRMS to FMS for travel reimbursement through AP.
• Customized Voucher Worklflow
• Developed GL interfaces with IBM mainframes.
• Modified a Custom interface AE process in BILLING to eliminate duplicate entries from a flat file and load a single entry to interface tables, and generates a report with all duplicates entries as a batch.
• Created an interface to load accounting entries from third party systems into custom accounting entry table in GL.
• Involved in general user support for nVision reporting, GeneralLedger, and Accounts Payables modules.
• Created custom accounting entry table, Journal template and accounting entry definition in GL to load journals from custom accounting entry table into JRNL HEADER and JRNL LN tables.
• Created application packages to be used in messaging using integration Broker.
• Fixed different issues in Procure to Payanddoing Production Support for the different Issues.

Confidential, Washington DC

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Modified (AR DUNNING) Application Engine in Receivables, to create report of all accounts for which the customers are past due and send them to Collection Processing.
• Modified component interface DC PENDITEM CI for more validations.
• Maintained detail and Summary trees. And Involved in performance tuning of nVisionreports and PS Query.
• Involved in retrofitting and fit gap analysis
• Redesigned financial reports in XMLP
• Retrofitting of all PO customizations.
• Developed AE interface Program that loads AR Open Items into PS PENDING ITEMS, PS GROUP CONTROL tables from the legacy system.
• Developed PO interfaces withIBM mainframes.
• Customized e-Pro Workflow
• Developed AE program that will select PO data from custom interface tables, merges it with PO default information, and loads the data into the PeopleSoft Purchase order tables.
• Customized aging reports like AR30001, AR30002, AR30003, and AR30004 as per end user specifications Performed customizations for the TIN number required on the vendor records.
• Customized Pay Cycle Application Engine process (APY2015)
• Worked onAP MATCHING Application Engine Matching Process to verify matching exceptions and fixed issues regarding matching.
• Created new XMLP reports for matching exceptions by group in AP.
• Developed an interface to generate the flat file with details of all checks for payments and cancellations for the Bank Reconciliation in AP.
• Rewrote (AR PREDCT) process to apply payments based on Business Unit, Customer and Item or Business Unit, Item and Pay Amount match.
• Created Test cases and Test Scripts and coordinated with users to resolve the issues.
• Developed custom AE program in GL to load journals from external interfaces into JRNL HEADER and JRNL LN tables. Created validation and Load reports.
• Extensively used People Code in RowInit, SearchInit, Page Activate, PreBuild, Field Formula, Field Edits, Save Edits, Save Pre Changes and Save Post Change events.

Confidential, Houston, TX

PeopleSoft Techno-Functional Analyst

Responsibilities:

• Modified Voucher Build (AP VCHRBLD) App engine process in Accounts Payable
• Modified the AR Dunning Application Engine extract (AR DUNNING), and the Crystal Reports layout.
• Involved in data mapping between legacy andPeoplesoft System
• Developed conversion programs using AE
• Implemented and customized workflow
• Customized Journal Entry Detail Report, FIN2001 to show correct chartfield values.
• Developed custom Application Engine that uses Component Interface to load data into tables and workflow to notify the managers to take proper action in specified time line in AP
• Applied patches and bundles in Purchasing, Inventory modules, to bring the existing version to the current level of patches
• Worked on setup procedures for Reconciliation process in AP and also involved in the setup of Pay Cycle Manager in AP.
• Developed Interface Application Engine program to load Billing Invoice information from a flat file that validates and loads data in to Interface tables.
• Implemented Voucher Upload and Journal upload templates
• Design and Development of Interface programs for Vendor portal
• Applied fixes delivered by PeopleSoft during Implementation
• Designed an interface program to load pending items from a third party billing legacy system in to PeopleSoft Receivables pending tables.
• Created custom interface to load voucher data in to voucher staging tables from Flat files in Accounts Payable using application engine.

Confidential, Connecticut

PeopleSoft Technical consultant

Responsibilities:

• Created custom interface process to load voucher data in to voucher staging tables from Flat files in Accounts Payable.
• Developed custom program that validates the chart fields before sending the data from Receipts accrual to GL.
• Designed AE program so as to give exception reports, which gives the result of converted rows, not converted rows etc in AR and BI.Created Temp tables for the Conversion purpose dynamically and deleting the tables after conversion is completed.
• Developed Business Unit tree and Account Tree using Tree Manager.
• Developed reports for Accounts Payables and Accounts Receivable modules using SQR, CrystalReports.
• Developed inbound interfaces to import data from third party providers to PeopleSoft using Application Engine and Component Interface.
• Developed Application Engine programs to load Cash and Tax receipts from third party systems to PeopleSoft GL.
• Developed and customizedSQRreports as per the client specifications.
• Used Import Manager to load mass data’s into PS tables and Data mover commands to export data’s.
• Worked on setup procedures for Reconciliation process in AP and also involved in the setup of Pay Cycle Manager in AP.
• Customized several Crystal reports as per the organizational needs.
• Created an SQR to load data into pending items table from third party promotions management into PeopleSoft Receivables.

Confidential, Houston, TX

PeopleSoft Technical Consultant

Responsibilities:

• Performed problem solving and analysis for PeopleSoft Receivables, Payables and General Ledger.
• Customization of Check Printing reports and development of various Accounts Payables reports using Crystal Reports for PeopleSoft.
• Developed interface in Payables that will be used to generate the flat file with details of all checks for payments and cancellations this was used for the Bank Reconciliation by the Client.
• Customized the Billing interface process, Invoice Pre-process and finalize process and Invoice printing process.
• A custom Application Engine was designed to import billing information from a flat file and load it into billing staging tables.
• Involved in Designing WorkflowRules, Roles and Routings for Workflowand Incorporated Rules to determine what activities are required to process Business Data.
• Developed an application engine program in General Ledger to load flat file accounting entries from FTP folders into journal staging tables.
• Updated Search View for pages in AP and GL basing on the roles and permissions as per client requirements.
• Worked with chart field conversions, chart field validation, combo edit checks in GL.
• Involved in extensive PL/SQLscripting for validation of the input data.
• Solved various issues during the running of Billing Interface Program.