Summary

• 9 years of experience as a PeopleSoft Financials consultant with experience in 9.x/8.x/7.x versions.
• Well versed in business process re-engineering and implementations of PeopleSoft Financial and SCM solutions.
• Planned and conducted Fit-Gap sessions and workshops with users for analyzing Business requirements.
• Proficient in all phases of the systems development life cycle including requirements definition, data conversion, data mapping, system implementation, system testing and acceptance testing.
• Demonstrated ability to understand customer requirements and support products within client environment and cross functional integration technologies for batch as well real time integration beyond the PeopleSoft.
• Experience in generation of Reports using SQR, nVision, Query and Crystal reports.
• Excellent Communication, Interpersonal, Leadership, Analytical and Problem solving skills.

Skill Set:

Professional Experience

Confidential

PeopleSoft Functional Consultant

Responsibilities:

• Created Functional design documents for requirements in AR, AP, PO, e-Pro and GL modules.
• Created functional design document to Capture ACH returns exceeding the Network Banking Limit of 99.99 Million Dollars.
• Created design documents to update AR PGG and AR POST process to be run mode from parallel to serial mode.
• Added 35 new Remit Codes to an existing BU to segregate the advance activities and enable the desired accounting for Fannie Mae without any downstream Impacts.
• Created functional design document to improve the Discrepancy report run time. Functionally tested to confirm that the Discrepancy report runs faster.
• Involved in weekly meetings with Fannie Mae users to approve the Functional specification documents and Test scripts associated with the requirements.
• Created functional design document to address the requirement for Late Journal VP approval.
• Provided solutions to Excel to CI - Account and Project being run to Error.
• Created functional design document to validate that the ADAMS Export process SQR report is FTP'd to the correct server.
• Created functional design document to address the Voucher page customizations where Voucher Comments, Purchase order Info on the page need to be displayed as view only to particular user group.
• Created functional design document to address the Issue of Assets not being created through the ITAM Interface when Requisition Id is not associated on a PO.
• Worked with Technical users to configure the Verity Collection search process in e-Pro.
• Performed Shakeout testing of AP and PO modules.
• Developed and Executed Test scripts for the following AR, AP, PO, GL requirements.
• Capture ACH returns exceeding the Network Banking Limit
• AR PGG and AR POST process to be run in serial mode
• Extensive testing of the 35 New Remit codes added.
• Excel to CI - Account, Project
• Late Journal VP Approval
• ADAMS Export Process Validate
• Batch Validation Method Update.
• ITAM Interface
• Tracked Functional Test script execution progress using Quality center.

Environment: PeopleSoft Financials/SCM 9.1 AR, AP, GL, PO, ePro People Tools 8.51 App Designer, Application Engine, PS Query, Tree Manager , Crystal Reports.

Confidential

PeopleSoft Functional Consultant

Responsibilities:

• Responsible for testing 25 Verizon wireless Inbound and Outbound Custom AP Interfaces. Interfaces included Stale dated payment, Stop payment confirmation, Payment confirmation files and Vendor extract information.
• Responsible for testing the custom Bank Reconciliation functionality in AP and the custom PO Reconciliation functionality in PO module. Logged defects to be addressed for the development team.
• Responsible for Functional testing of AP and PO modules.
• Involved in weekly meetings with Verizon Business users and Functional team to get the Functional design documents approved.
• Gathered requirements/created Functional design documents to develop an Imaging solution using Oracle IPM which replicates the existing VZW Imaging solution in PS8.4 using Markview system. Oracle IPM was used to create New Vendors, Control groups and Vouchers from Images uploaded to the user queue in PeopleSoft.
• Created functional and technical design documents for Data Conversion work effort from PS8.4 to PS9.1. Designs include Buyers conversion, Requestors Conversion, Purchase Orders conversion, Receipts conversion, Item Categories conversion and eQuotes conversion.
• Created Functional design document to address the enhancements done to the custom PO Reconciliation process and also performed Functional testing to ensure that the deliverable met the VZW standards.
• Created Functional design documents to review/migrate the customizations done in PS 8.4 for the Requisition Auto source process.
• Created Functional design documents for custom Journal creation Interfaces in the GL Module.
• Worked with Verizon Business user's to identify requirements.
• Involved in defining vendor setup, purchasing attributes, Vendor UOM and pricing.
• Designed custom Inventory and Purchasing reports on supply, demand and resulting shortages.
• Played a key role in different Bug Fix and Performance Enhancement development releases.

Environment: PeopleSoft Financials/SCM 9.1 AP, PO, GL, INV, ePro People Tools 8.51 App Designer, Application Engine, PS Query, Tree Manager People Code, SQR, Crystal Reports, Oracle IPM.

Confidential

PeopleSoft Reporting Consultant

Responsibilities:

• Part of Functional specifications Design Specialists Team for AP, PO modules.
• Created Technical specification documents for the functional requirements AP, PO Modules.
• Designed and developed a custom Crystal report - Purchase Order RFQ Bid Tab Report which provides the ability to find Bid information for relevant RFQs.
• Developed a custom SQR report that reports the Voucher and Expense Accrual Information.
• Designed and developed a custom SQR report that provides a detailed listing, relevant information, for vouchers that have been paid beyond their due date for a particular Business Unit.

Environment: PeopleSoft FSCM 9.0 AP, PO People Tools 8.49 App Designer, Application Engine, PS Query, Tree Manager People Code, SQR, Crystal Reports.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Worked with business users to gather requirements, perform fit-gap analysis, and define overall scope and definition of the project's functional requirements.
• Designed Inbound interface to import employee health care and benefit changes from third party benefit provider to PeopleSoft using Application Engine and Component interface.
• Designed a process to print Individual Development Plan, Annual Performance Document and Progress review in rtf format. This provided users with the option to download the report and make correction/modifications offline.
• Created a Batch process to generate the PRENOTES to the bank on a daily basis so that the new employees would have their initial payment as a direct deposit rather than a Manual pay check.
• Created a custom Journal Process to accommodate the UW Journals as per the State Department of Administration requirements. This process involved into classifying the Journals before they were interfaced to the SFS system.
• Created Custom Application Engine/XML publisher integration to generate a Payroll Edit report to be created centrally and distributed by UW Campuses/Division/Department.
• Developed a custom SQR to inactivate the direct deposit information for an employee who returns after a payment gap in excess of 12 months.

Environment: PeopleSoft HRMS 9.0 Time Labor, HR, Benefits, Benefits Administration People Tools 8.49 App Designer, Application Engine, PS/Query, Query Manager People Code, SQR, Oracle 11G, STAT -5.3.1

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Created a custom HCHD process to bring forward the Unrecorded Liability Crystal APY1407 and the App Engine AP APGLOPEN which was dropped out by Peoplesoft in 9.0 in Accounts Payable Module
• Troubleshoot PO REQSORC Application Engine process as the user was Unable to Cancel an Approved Requisition in Purchasing Module.
• Customized the Configuration defaults for the Depreciation AM . Set the STATUS field to Non Depriciate when a particular Business unit is selected in Asset Management Module.
• Troubleshoot the PC Flex Analysis so it can be tied to the Summary Report/Page.
• Troubleshoot the Ledger Period comparison report which errors out.
• Created an outbound file using Application Engine and File layout to send Purchase orders to vendors that are approved and flagged as EDI .

Environment: PeopleSoft Financials 9.0 AP, PO, AM People Tools 8.49 App Designer, Application Engine, PS Query, Tree Manager People Code, SQR.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Worked with the Business users to gather requirements, perform fit-gap analysis.
• Prepared Functional Technical Specification Documents for the Conversion of Customers active customers , Customer Conversations, open AR-Items invoices related to open Items Bills installment, recurring bills and open transactions .
• Involved in Customizing and Testing the AP Pay Cycle Process to print the Custom Checks.
• Customized AR30003.SQR, AR30004.SQR to print the number of disputed items for each customer along with the number of disputed items for the business unit, order number, and reports.
• Customized AP MATCHING process to perform Matching validation among receipts, PO and invoices and a Match exception crystal report APY1090 to view the disputed values that are populated after running Matching process.
• Customized VCHR EXPRESS1 page by incorporating DUKE Signature Authority Functionality to create and approve vouchers based on the amount levels.
• Customized the Commitment Control Posting App Engine FSPQPOST to post the budget journals to the control budget ledger.
• Customized the following Crystal reports :

PPSFBI08 STANDARD INVOICE

• PPSFBI09 PREPAID INVOICE
• PPSFBI10 PROPERTY DAMAGE INV
• PPSFBI11 JOINT USE INVOICE
• PPSFBI12 QUANTITY GRID INVOICE
• PPSFBI13 CONSOLIDATED INVOICE
• PPSFBI14 STDNOTES
• Modified the respective queries attached to the crystals. Format and layout changes were made according to the Functional User Specifications.
• Developed a SQR to load Contracts for Purchasing to obtain the most favorable Contract pricing and to report on YTD purchases by Contract.
• Updated Financial Transfer report and Inventory Transfer report based on new location typed added.

Environment: PeopleSoft Financials 8.9 /8.8 GL, AP, AR , BI ,PO,INV and AM , People Tools 8.49, People Code, Process Scheduler, Application Engine, SQR, XML, PSQuery, Mercury Quality Center 9.0/TestDirector 8.0,Crystal Reports 9.2.3, nVision, WorkFlow, Oracle 10g/9.2. Changeman DS 5.7, Lotus Notes.

Confidential

PeopleSoft Functional Consultant

Functional Responsibilities:

• Worked with the functional team to gather requirements, perform fit-gap analysis, and define overall scope and definition of the project in terms of functional technical requirements.
• Successfully completed full cycle implementation of version 8.9 GL, AP, AR, PO modules.
• Involved in configuring, defining, identifying, and completing fit/gap analysis and resolving cross-functional financial and distribution issues between Payables General Ledger.
• Created Functional Design documents for GL and AP modules and implemented the same.
• Journal Generation
• Ledger Archiving
• Voucher Approval
• Outbound Payment Files
• Vendors Check Printing Formatting
• Express Payment
• Income Statements, Revenue Statement, other nVision reports
• Set up plans, develop, and create nVision layouts for General Ledger. Run PS/nVision on the web and run advanced reports. Implementing Summary Ledgers, use Drilldown, Query Criteria in Matrix Layouts and Query criteria in Tabular Layouts.
• Designed an nVision report, which gives the Revenue for Department/Location by time spans. This report mainly summarizes about the revenue of each and every office around the US to monitor the marketing leaders business.
• Re-designing reports for Profit and Loss Balance sheet in nVision
• Prepared Gap closure documents by streamlining the gaps in Business process, by defining default values the gaps in Technical gaps.
• Performed nVision performance tuning by examining and analyzing the SQL in RDBMS tool.
• Created custom SQL scripts to identify and resolve data discrepancy issues
• Created custom SQL scripts to change SETID 'SHARE' to custom SETID defined in our environments.
• Created Reconciliation process SQL scripts, Word Doc, etc. in order to validate and verify the accuracy of the results.
• Designed requirements for customized procedures of Flat file Journal and Ledger Import processes in GL.
• Involved in Chartfield configuration design of Spreadsheet Journal Import procedure in GL.
• Responsible for creating and maintaining Allocations required for different campuses at University of Minnesota Locations.
• Managed and updated Accounts Receivable and Inventory System for Non-Regulated Business Units.
• Quality Analysis Responsibilities:
• Functional testing of whole functionality and new customizations, reports and queries. Responsible for creating the test procedures, and documenting.
• Maintained the Business Requirements and Test cases in the Mercury Quality Center, and prepared the test lab.
• Exported and imported the test cases into Test Director by using excel add-in..
• Developed and executed the following QTP scripts for the General Ledger and Payables modules.
• Journal Generation
• Ledger Archiving
• Voucher Approval
• Outbound Payment Files
• Vendors Check Printing Formatting
• Express Payment
• Income Statements, Revenue Statement, other nVision reports
• Prepared test scenarios and test cases for System Integration testing and UAT.

Environment: PeopleSoft Financials 8.9 GL, AP, AR, PO, e-Pro and Workflow , Mercury QTP 9.1/8.2/7.5, Quality Center 9.0/TestDirector 8.0, SQR, XML.