PROFESSIONAL SUMMARY:

• Around 10 years of experience in PeopleSoft Financials 9.1,9.0, 8.8, 8.4 Accounts Receivables, Billing, General Ledger, Project Costing, Contracts, Purchasing, Accounts Payables, Commitment Control, Resource Management, Travel and Expenses and Asset Management Functional Analysis, Design, Design Testing, Implementation and Post Implementation Support. Expertise in PeopleSoft FSCM Involved with defining Test Strategy, Test Plan, Test cases and Test scripts for PeopleSoft Financials modules including Contracts, Project Costing, Accounts Receivables, Billing and Travel and Expenses Modules. Performed PeopleSoft System, Integration, and User Acceptance Testing as part of a Implementations and Upgrade. Extensive knowledge and experience of various business processes.
• In-depth proficiency of functional experience, in addition to Design, Fit-Gap Analysis, Implementation, Upgrade.
• Functionally proficient in Implementation, Customization, Maintenance, Interfacing/ Reporting, Data Conversion, Upgrade, Production Support and Testing.
• Managed Budget Checking and Exception Processing and Procure-to-Pay Life Cycle Using Commitment Control
• Managed Project Budgets Expense Budgets and Budget Closing using PeopleSoft Commitment Control
• Expertise in all implementation phases including Business Process analysis, GAP analysis, Blue print, Design/Build, Data migration, Unit, Integration and End User testing, Cut-off strategy, Go-live and Post go-live support and maintenance.
• Extensive experience in transferring existing data from legacy systems to PeopleSoft application database tables.
• EDI set up for transmitting invoices
• Hands-on-experience working with AP, Travel and Expenses, GL, PA, AR and Billing related production issues.
• Knowledge in creating specifications, project schedules, test scripts, analyzing the upgrade process to re-customize and reapply the customizations, supervising design activities and interfacing with customers for successful completion of project.

PeopleSoft Skills

• ERP Applications: PeopleSoft Financials 9.1/9.0/8.9/8.4/7.5, General Ledger, Account Payables, Account Receivables, Billing, 1099 Process, Pcard, Travel Expenses, Commitment Control, Grants Contracts, AR/Billing, Asset Management, Purchasing and Projects.
• PeopleTools: People Tools 8.52, Application Designer, Application Engine, Tree Manager, Import Manager, Application Reviewer, Data Mover and Upgrade Assistant.
• Reporting Tools: Crystal Reports 8.0/7.0,nVision, Pro C, SQR.
• Other Tools used: HP Quality centre, Autosys, OBIEE, Toad
• Databases: Oracle 10.x/9.x/8.x/7.x, DB2, SQL Server, SYBASE and MS Access
• Languages: SQL, PL/SQL, Shell Scripting, COBOL, VC , Visual Basic.
• Operating Systems: UNIX, MVS, MS DOS, Windows 98/NT/2000/XP

Confidential

Role: PeopleSoft Functional Consultant

Responsibilities:

• Worked with Business users and QA Team in implementing the automated test scripts for AP, AM GL modules.
• Involved in moving Crystal and nVision layouts and reports as is to 9.1 version, testing and verification of all reports
• Worked with Application Designer and Data Mover for finding out underlying tables and querying data
• Involved in resolving issues during Unit and Integration Testing.
• Created various private queries upon request and made changes to existing queries as per new requirements
• Involved in working with the Technical team on Compare Reports between the two versions
• Created test scripts for Unit and Integration tests for various Scenarios within GL, AP and AM modules
• Involved in fit gap analysis between 8.4 and 9.1 which, helped client taking decisions with regard to the upgrade in General Ledger, Accounts Payable, and Asset Management between 8.4 and 9.1
• Upgrade project of PeopleSoft Financials 8.4 to 9.1 General Ledger, Accounts Payable, and Asset Management. Responsibilities include design documentation, functional specifications, data mapping for transfer of data from 8.4 to 9.1 version, verification of queries, Functional UAT and End to End testing.
• Setup Banks for Accounts Payable. Involved in setup of Sales and Use Tax defaults and options
• Involved in Bank external Account set up, Payment Application, and Bank Reconciliation Process in Cash Management
• Extensively involved in testing the whole application from Accounts Payable to General Ledger from Accounting prospective.

Environment: People Tools 8.51, PeopleSoft Application 9.1 GL, AP, AM , Oracle 10g

Confidential

Role PeopleSoft Techno Functional Consultant

• Resolved numerous functional and technical issues within GL, AP and CC PeopleSoft modules relating to stability, performance, and faulty business processes
• Troubleshot Journal Generator process for 'missing Inter-Unit Accounting Lines', 'Unbalanced Journal Entries', 'subscript out-of range' errors
• Used 'Ledger Vs Journal Integrity Report for troubleshooting discrepancies between out-of-sync Ledgers and Journal tables
• Setup procurement workflow for Requisitions and Purchase orders as well as Commitment Control within Procure to Pay PeopleSoft applications.
• Setting up PeopleSoft Commitment Control and Security, Preparing Commitment Control Budgets
• Configured Accounts Payable to utilize Payment Matching and generation of annual 1099s.
• Applied bundles to Purchasing in-order to resolve numerous issues within module. Application of bundles involved QA of all objects as well as system testing prior to release into Production.
• Loaded budget data into General Ledger against which Commitment control validation was being performed.
• Configured commitment control to ensure commitments and actual expenditures did not exceed set budget.
• Maintained Business Units and Accounts reporting tress using Tree Manager.
• Setup Banks for Accounts Payable. Involved in setup of Sales and Use Tax defaults and options
• Established Vendor Terms, Vendor Locations and Vendor Pay Group Codes. Setup Payment Timing codes, Single and Multiple Pay
• Created various Summary Reports for Trial Balances, General Ledger, Balance Sheet, Income Statements, and Cash flow statements.
• Defined and setup SET IDs. Defined GL Business units and setup GL security with Permissions Lists, User Roles and Profiles.
• Performed AP-GL reconciliation and created queries to check flag status to assist in future.
• Provided general production support for GL, AP, AR, and CC modules.
• Environment: People Tools 8.51, PeopleSoft Application 9.1 AP, PA, AR, GL, Procurement and TA , Oracle 10g

Confidential

Role: PeopleSoft Techno Functional Consultant

• This Project is an implementation of PeopleSoft Financials 9.1 General Ledger, Accounts Payable, Accounts Receivable Billing Customers , Project Accounting Project Costing Customer Contracts , Procurement Purchasing, eProcurement, Strategic Sourcing Procurement Contracts and Time Attendance Time Labor and Absence Management . Responsibilities include design documentation, functional specifications, working with end users to tune the business process, working with the tech team on data mapping for transfer of data from PeopleSoft Financial Management System FMS to PeopleSoft Financials 9.1 and production support for the old FMS system.
• Involved in writing several specifications for bringing over the FMS data into PeopleSoft 9.1. Creating data mapping for the interfaces between FMS and PeopleSoft 9.1.
• Involved in working with the end users for tailoring the business process as per VDOT's requirements.
• Extensive data cleanup activities which includes 5 Mocks and a Final conversion test and fixed related issues.
• Involved in Research, troubleshooting, Tracing and debugging batch processes.
• Helping users to close out the financial applications during the month end, Quarterly and year end.
• Created functional specifications for a modification that would allow the Journal Edit / Posting process not to fail when certain revenue offsets and deferred revenue entries are posted to General Ledger. The modification will invoke the intra unit process to create additional required balancing entries.
• Involved in the setup of EDI 810 VAN Value added Network . VAN acts as an agent in transmitting invoices from DOM Dominion Virginia Power to the Financial Management system of VADOT. This is an EDI BIZTALK solution.
• Responsibilities including Subject matter Expert to provide solutions, research and helping users.
• Handling training sessions for user community.
• Created Controllers/Internal Control Reports, ARRA reports, General Assembly Report, Monthly AR and Quarterly AR Activity Reports.
• Analyzed and resolved daily Nightly Batch Job issues and archived all these issues on a daily basis for future review and Audits.
• Troubleshooting Voucher posting issues on daily basis, monitoring Batch jobs, escalating issues based on priorities.
• Created various private queries upon requests from the users and also made changes to existing queries as per new requirements.
• Updated Total Bill Amount on PS V BILL HDR using SQLs for hundreds of Out of Sync Project Agreements of Federal bills which are not in sync with the line items in PS V BILL LINE so that VDOT can bill FHWA for the new Bills.
• Worked on a variety of Production issues like Budget Checking errors in different modules, Buffer errors, Unique constraint errors, Re-Approval flags, Activity Code errors, Journal deletion/update requests, Bills not printing issues, Target run date - Bill cycle issues, Pending Item errors and Year End issues.
• Created design specifications / functional specifications for additional fields that were needed for the billing process, auto place bill plan on hold.
• Involved in the design and functional specification to populate the required chart fields when a deposit is created. This will allow cash control and deposit in transit accounting entries to post correctly to General Ledger.
• Created design specifications, data mapping documents for Work Orders Interface to Financials Interface. Also worked with the tech team for testing this interface thoroughly.
• Created functional specifications based on business process needs, wrote test scripts and supervised the entire customization process in collaboration with the technical team.
• Assisted the technical team with unit testing and created schedules for integration testing.
• Involved in working with the client in helping them integrate 3rd party products, within Supply Chain and helped with the integration testing for these products within PeopleSoft.
• Involved in the setup of business units, configuring the setup options for Supply Chain Modules AP, Purchasing, eProcurement .
• Submitted Weekly Status Reports to the Controller.

Environment: People Tools 8.51, PeopleSoft Application 9.1 AP, PA, AR, GL, Procurement and TA , Oracle 10g.

Confidential

Title: PeopleSoft Techno Functional Consultant

• An implementation of PeopleSoft Financials 9.1 for Interval International Company. Grants, Project Costing, Contracts, Accounts Payable, E-Procurement, Purchasing, General Ledger, Accounts Receivable, Billing and Asset Management . Responsibilities include fit-gap analysis, design, configuration and testing, production support of the PeopleSoft Grants Suite modules. Grants, Project Costing, Contracts
• Responsible for Fit gap analysis, design, configuration, testing and Production Support of the Grants, Project Costing and Contracts modules.
• Assisted clients with successful implementation of PeopleSoft Financials functionally.
• Present different options to the client for overcoming business challenges with functional solutions.
• Responsible for developing user procedure for using Grants module in a suitable fashion based on client requirements.
• Tracing and Debugging PeopleSoft Processes on ad hoc basis.
• Helped user community for reconciliation in Cash Management module
• Coordinate with end users to establish open issues, and set user expectations regarding deliverable scopes and timeframes.
• Fit gap analysis, design, configuration, testing and Production Support of the Grants, Project Costing and Contracts modules.
• Work with the end users to resolve issues with contract activation, initial grants billing and amount allocation for amount based contract lines.
• Configure and tested the valuation templates for easy online reporting. Created new analysis groups and added them to the valuation templates.
• Checking the production logs on web server and app server.
• Work with the controller's office in setting up cost and grants billing accounting rules within Project Costing. These accounting rules will be subsequently used in the automated revenue recognition process.
• Configure rate sets and rate plans within Project Costing pricing structure. Configured several rate plans.
• Work with the GL team in the design, configuration and testing of the GL Allocations. The pool for these allocations is a view of the tables within Project Costing.
• Extensive use of the Funds Distribution functionality within Project Costing. Covers the uncovered allocations using internal sources of funding.
• Configure the contracts module to default the rate plans based on the Pricing method and Product used.
• Explain and demonstrate the usage of date based and milestone based events for fixed fee contracts.
• Work with the security team in resolving issues related to grants/contract milestones.
• Configure the rate sets and accounting rules to release the funds from Temporarily Restricted to Unrestricted.
• Configure the contracts module to default the bill plan and the revenue plan based on the pricing method and product used. Worked with the GL team in configuring additional distribution codes for use on the bill type specified on the contract bill plan.
• Involve in configuring the Milestone notification process at the Business Unit level and set up of Milestones at the award level.
• Worked on Revenue Recognition in PeopleSoft Contracts by assigning bill plans, revenue plans, running the Initial Billing, Cost Collection into Project Costing from the sub systems and running the As Incurred Revenue Recognition.
• Word on configuring multicurrency functionality and integrated the multicurrency functionality within Grants Billing.
• Involved in preparing training manuals for end users and worked with the end users to resolve training issues.
• Worked with the business process owners to explain how PeopleSoft Grants, Project Costing and Contracts could help with their business and suggested best practices.
• Worked on the functional design for several reports such as the Grants Balance Report, TRNA Temporarily Restricted Net Asset Report, Funder Financial Report, Labor Distribution Report etc.

Environment: PeopleTools 8.51, PeopleSoft Application 9.1 GM, PC, Contracts, AP, GL, AR, BI, Purchasing and T A , Microsoft SQL Server

Confidential

Role: PeopleSoft Fit-Gap Analysis/Functional Consultant

• General Ledger, Payables, Billing, Receivables, Purchasing, Asset Management for Ingram Barge Company. Responsibilities include fit gap analysis between 8.8 and 9.0, customization retrofitting, business process customizations, Test Scripts for Unit and Integration Testing etc.
• Involved in the fit gap analysis for PeopleSoft Financials General Ledger, Payables, Billing, Receivables and Purchasing between 8.8 and 9.0.
• Involved in customization retrofit by taking into consideration the functionality changes in the new version.
• Functioned as a liaison with the technical team with regard to retrofit of customizations.
• Involved in design of functional specifications for additional customizations needed to the client's business process.
• Assisted the client in bringing over Voucher data by using the Spreadsheet Voucher Upload.
• Created test scripts for Unit and Integration tests for various Scenarios within PeopleSoft Financials.
• Involved in resolving issues during Unit and Integration Testing.
• Worked with Application Designer, Toad and Data Mover for finding out underlying tables and querying data.
• Involved in assisting the client with best practices in PeopleSoft
• Checking and Researching Financial application logs to isolate high priority issues.
• Worked in testing with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, Pay Cycle, AP Processing, AP Interfaces, Refund Processing, AP Reports and AP Security.
• Developed GL interface test cases, that loads data from various external systems into PeopleSoft General Ledger, while implementing combo rules and checking invalid Chart field combinations, Subtotals on Business Unit Level, grand totals, Error Handling Procedures and Printing Multiple output Reports

Environment: PeopleTools 8.48.09, PeopleSoft Application 9.0 AP, PO, AR, GL, AM , Oracle 10g.

Confidential

Role: PeopleSoft Fit-Gap Analysis/Functional Consultant

• Involved in fit gap analysis for PeopleSoft Financials 8.4 and 8.9. Created fit gap reports that helped the clients taking decisions with regard to the upgrade.
• Designed the business process to populate PeopleSoft Pre Award tables through an interface from a 3rd party system. This design does not allow editing the pre award information before generating the award.
• Designed a customization in PeopleSoft Grants Management that would prevent the user from using the Credit Entire Bill Option . This has been done to avoid all the expenses from being permanently disallowed for billing again.
• Involved in customization retrofit based on the fit gap analysis, business process customizations to the new system.
• Worked with Application Designer, PS Query and Data Mover during the upgrade.
• Involved in designing several functional specifications for Post Award customizations.
• Involved in writing functional specifications for Grants and Project Costing Reports such as Cost Sharing Detail Reports, F A Rate Changes, and Unapplied Deposits Report etc.
• Involved in assisting the client with Awards, Proposals issues and data validation for reports such as F A Exception Report, GM Subsystem Recon Queries etc.
• Involved in explaining the email collaboration for Requisition Approval within PeopleSoft eProcurement to the client.
• Involved in working with the procurement team about Procurement needs and tuning the business process as per the University's requirement.
• Involved in creation of design and functional specifications for modifications that were needed to the client's business process.
• Helped the client with Unit and Integration test scripts and worked within the due time line.
• Involved in debugging several functional issues such as issues with Generating Awards, Tracking Proposals, F A processes etc.
• Involved in setup of eProcurement by establishing various Business unit options as per the client's need.
• Functioned as the go to person for handling fit gap/functional issues.

Environment: PeopleTools 8.48, PeopleSoft Application 8.9 PO, eProcurement, AP, AR, BI, Grants, Project Costing , Oracle 10g, SQR, Data Mover.

Confidential

Role: PeopleSoft Fit Gap Analysis/Functional Consultant

• Involved in fit gap analysis between PeopleSoft 7.02 and 8.8. Stressed on the data conversion between 7.02 and 8.8 with regard to PeopleSoft Commitment Control.
• Involved in submitting detail fit gap analysis reports to SOA so as to understand the major differences between 7.02 and 8.8.
• Involved in working with the technical team on Compare Reports between the two versions and aided in retrofit of customizations.
• Created new functional specifications for customizations that were not retrofitted due to business process conflicts.
• Involved in creating data mapping for bringing over data from 7.02 to 8.8.
• Involved in creating unit and integration test scripts during the upgrade.
• Suggested custom solutions to the client for resolving issues during the upgrade.
• Worked with the technical team for testing customizations thoroughly before getting them approved.
• Worked on Process Scheduler to create various process definitions.
• Worked with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, PayCycle, AP Processing, AP Interfaces, Refund Processing, AP Reports and AP Security.
• Creating queries for all Open invoices and Modifying Invoice Print Crystal in PS Billing.
• Worked with Asset Managements on various modifications, which involves Entering Assets, Asset Cost Transactions, and Month End Processes, AM Interfaces, AM Reports and AM Security.

Environment: PeopleTools 8.46, PeopleSoft Application 8.8 AP/PO, AR, GL, AM Oracle 9.x, SQR