SUMMARY

• Having around 7 years of experience in PeopleSoft Financials 9.1, 9.0, 8.9, 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.
• Defined and designed Workflow rules for approval and control requisition authorizations through workflow - enabled approvals. Extensive knowledge, and experience of various business processes.
• In-depth proficiency of functional experience, in addition to Design, Fit-Gap Analysis, Implementation and Upgrade.
• Functionally proficient in Customization, Maintenance, Interfacing/ Reporting, Data Conversion, Upgrading, Implementation, 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.
• 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 re-apply the customizations, supervising design activities and interfacing with customers for successful completion of project.

TECHNICAL 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, Cash Management, Grants & Contracts, AR/Billing, Asset Management, Purchasing and Projects.

PeopleTools: People Tools 8.52, Application Designer, Application Engine, PeolpeCode, Workflow, File Layout, Component Interface, Application Messaging, 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 8, 7, Vista, XP, 98/NT/2000.

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

PeopleSoft Functional Consultant

Responsibilities:

• TroubleshotJournal Generator processfor ‘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 toPay 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 involvedQA 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 usingTree Manager.
• SetupBanksfor Accounts Payable. Involved in setup ofSales and Use Taxdefaults and options
• EstablishedVendor Terms, Vendor Locations and Vendor Pay Group Codes. Setup Payment Timing codes,Single and Multiple Pay
• Created variousSummary ReportsforTrial Balances, General Ledger, Balance Sheet, Income Statements, and Cash flow statements.
• Defined and setup SET IDs. DefinedGL Business unitsand setup GL security withPermissions Lists, User Roles and Profiles.
• PerformedAP-GL reconciliationand 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 - Richmond, VA

PeopleSoft Functional Consultant

Responsibilities:

• 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 Confidential ’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.
• Troubleshooting Pay cycle issues on daily basis.
• 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.
• Validated data before final extracts using MS-Access and test scripts.
• Checking the production logs on web server and app server.
• Worked on various conversion issues as per Cutoff schedule and recommended production control of when to put hold on jobs permanently.
• 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 Confidential 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).
• Resolved Financial Management System Open issue tickets initiated by Users on a daily basis. Used HP OpenView Service Center to open, close or re-route the tickets to respective groups.
• 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 - Miami, FL

PeopleSoft Techno/Functional Consultant

Responsibilities:

• 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, Topeka, KS

PeopleSoft Fit-Gap Analysis/Functional Consultant

Responsibilities:

• 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.