SUMMARY:

• 13+ years of PeopleSoft Financial Consultant experience in PO, Purchasing, eProcurement, EDI, Order Management, Inventory, Accounts Payable, General Ledger, Accounts Receivable, Billing, Project Costing.
• Handled worldwide support, develop, trouble shoot of whole suits of PeopleSoft Financial and Supply Chain, which includes GL, AR, AP, Purchasing, eProcurement, Inventory, OM and BI for different business entities from v.8.4, v.8.7, v.8.9. v.9.0, v9.1, v9.2.
• Responsible for Upgrade of PeopleSoft HCM from version 9.1 to 9.2 and performed impact of changes with the technical teams.
• Experience in Peoplesoft production support, enhancements, and upgrades to existing and new PeopleSoft HCM and PeopleSoft CRM Customer Support.
• Experience in business - related project milestones such as in Requirements Gathering, Data Modeling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.
• Experience in PeopleSoft Financials 9.1/9.0/8.0 and used Application Designer, UNIX shell scripting, HTML/DHTML, People Code, SQR, Application Engine, Application Package, Crystal Reports, Integration Broker, Component Interface, JavaScript and Oracle (creation of complex SQL, Query optimization, creating database triggers, creation packages and procedures) from version 10/11g.
• Excellent functional knowledge and project experience in the areas of PeopleSoft FSCM Core modules AP, AR, BI, PO and GL.
• Functional lead and support of the Oracle Financial project, which included GL, AR, AP, Purchasing, and Inventory. Provided fits and gaps business analyses, user tests, system tests, trouble shootings and post-production support.
• Hands-on experience in Requirements Gathering, Data Modelling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.
• Experience in PeopleSoft Full-Cycle Implementation includes Analysis, Upgrade, Interface Design, Reporting, Data Conversion, Configuration, Testing Troubleshooting and Production Support.
• Extensively worked on People Tools like Application Designer, Data Mover, Application Engine, Application Package, Component interface and Utilities upgrade assistant.
• Experience in working on FSCM to identify the changes and enhancements done in AP, PO, e-Procurement, AR and Billing modules.
• Responsible for the research of the release notes for FSCM to identify the changes and enhancements done in AP, PO, AR and Billing modules.
• Strong Functional experience in PeopleSoft financials 9.x, 8.8, 8.4, 8.3, 8.0, 7.5, 7.0 and experience in analysis, design, and development and testing of various PeopleSoft modules such as GL, Order to Cash process, Purchase Order
• Proficiently upgraded PeopleSoft from FSCM 8.9 to 9.1. Worked on several reports relating to FSCM modules AP, AR, PO, IN and GL relating to aging, vendors, matching, Stock Status and payments.
• Experience in managing upgrades to FSCM, new functionality, system performance, and business process analysis.
• Experience in PeopleSoft Financials 9.1/9.0/8.0 and used Application Designer, UNIX shell scripting, HTML/DHTML, People Code, SQR, Application Engine, Application Package, Crystal Reports, Integration Broker, Component Interface, JavaScript and Oracle (creation of complex SQL, Query optimization, creating database triggers, creation packages and procedures) from version 10/11g.

PROFESSIONAL EXPERIENCE:

Sr. PeopleSoft Financial Consultant

Confidential - Eau Claire, Wisconsin

Responsibilities:

• Assisted with General Ledger setup and inquiries and handled Accounts Payable and Purchase Order errors.
• Involved in evaluation, customization and setting up of workflow for Journal Entry Approval, Asset Transfers approval and Voucher Approval Processes, Receivable processes.
• Completed fit gap analysis to identify the requirements for PeopleSoft FSCM application upgrade from version 9.1 to version 9.2.
• Modified existing Report formats and added new reports using PS Query to generate reports of the customized application as per the user requirement.
• Optimized the complete process Procure to Pay Cycle (PO, AP, AM and GL) and Order to Cash (BI, AR and GL).
• Worked on creating an app engine to generate XML file since Delivered system was unable to support file size.
• Resolved issues related to Integration broker, Component interface and Application package PeopleCode.
• Provided additional knowledge and expertise of Purchasing, Receiving, Payables, Project Costing, and General Ledger modules, as well as other PeopleSoft features such as Security.
• Understanding PeopleSoft 9.2 table structure/architecture, SQL, and how various modules function and integrate with one another to produce expected accounting and financial results.
• Used SQL to extract and analyse data from 8.8 and 9.2 databases and identifying system differences between the two PeopleSoft versions. Providing this information to stakeholders.
• Performed requirements elicitation, fit-gap analysis, and identifying system solutions for supporting City business processes.
• Researched the release notes for FSCM 9.1/9.2 to identify the changes and enhancements done in AP, PO, e-Procurement, AR and Billing modules.
• Completed fit gap analysis to identify the requirements for PeopleSoft FSCM application upgrade from Version 9.1 to version 9.2.
• Worked on development and modification of Interfaces and data conversion from Legacy systems to PeopleSoft records by performing numerous validations using SQRs and Application Engine.
• Worked closely with Business users in capturing requirements and creating Functional Design documents (BRD & FRD) and designing Technical Documents based on FRD.
• Facilitated the student financial legacy system assessment and fit/gap analysis in anticipation of implementing PeopleSoft 9.2.
• Designed and developed interfaces to load data from the legacy system into the PeopleSoft system.
• Worked closely with the Business team and users to understand their issues and solve the incidents and work orders.
• Worked as a member of their production support team for PeopleSoft FSCM 9.1 and HCM 9.1 systems while working on the upgrades FSCM 9.1 to 9.2, People Tools 8.5 .11, then HCM 9.1 to 9.2, People Tools 8.5 .16.
• Organized and facilitated stakeholder meetings to address system requirements and resolve issues.
• Developed and documented software configuration options and presenting recommendations to stakeholders.
• Designed new process in Accounts Receivables to provide a last chance to user to review the Invoice information before sending to customer. Added this process in single action invoice job.
• Involved in end to end testing for Procure to Pay and Order to Cash process in FSCM since database is updated to higher version and document the results.
• Designed and developed Voucher and General Ledger Integration Broker interfaces using Service Operations, App Messages, App Packages and PeopleCode.
• Involved in the integration of PeopleSoft Payables with PeopleSoft Accounts Receivables and General Ledger.
• Developed reports analysing and documenting the "as is" City financial business processes and other topics to support departments and PeopleSoft Re-Implementation activities.
• Assisted departments in preparing for the Fit-Gap sessions that were conducted as part of the implementation project to support their business requirements.
• Worked closely with the business owner's subject matter experts and the functional analysts to provide information about departments to assist with determining business process changes and system configuration.
• Developed custom Purchase Order dashboard component to display Requisition, Purchase Order and General Ledger information related to purchase order.

Sr. PeopleSoft Financial Analyst

Confidential - Dallas, TX

Responsibilities:

• Primary role was to develop the Accounts Payable Workflow, Configure, and Design and develop integration broker messages for Inventory and purchasing module with third party systems.
• Worked in PeopleSoft Finance modules like GL, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing and having knowledge of G/L business process and financial reporting. Also, knowledge of Contracts, Billing, and enterprise pricer with strong App Designer.
• Worked on Report Conversion process from SQR/Crystal to XML publisher in PeopleSoft 9.1 environment. Worked on the Business Objects Data Insight to analyse and monitor the claims reports.
• AS-IS PeopleSoft business process gathered from various sources including workshop and individual interview sessions.
• Performed multiple consulting roles during my career including Project manager, Project Lead, Technical/ Functional Consultant. Experience in maintain the message between PeopleSoft FSCM modules using the integration broker monitor and toolset.
• Worked closely with Installation, administration and upgrades of PeopleSoft environments on an Oracle/ Solaris, PeopleSoft application architecture including the table structure, delivered objects, design standards, protocols and Involved in various PeopleSoft Applications Up gradation using Upgrade/ Change Assistant.
• Involved in Design, Development, Testing, Implementing and Enhancement of PeopleSoft Finance and Supply Chain Management.
• Managed people and projects in various phases of the Software Development Life Cycle, especially object-Oriented Software Design and Development.
• Provided Production support for PeopleSoft finance modules (Accounts Payable, Accounts Receivable, Cash Management, General Ledger and Billing).
• Worked as a hands-on function lead of analysts to support the PeopleSoft HCM/ELM 9.2 Upgrade effort.
• Provided subject matter expertise guidance for PeopleSoft SCM (OM, Inventory) existing functional and technical usage and additional customization recommendations for various strategic project needs.
• Supported House PeopleSoft cross module application such as Commitment control, General Ledger, Accounts Payable, Asset Management.
• Involved in PeopleSoft 9.1 and 9.2 upgrade initiatives, Fit/Gaps and analysing new enhancements and features.
• Acted as a single point of contact all Treasury related product support activities. Apart from production support working on In-house projects
• Created queries for all the Finance Modules, maintenance of chart fields and Combo Editing process.
• Worked on User Productivity Kits (UPK) to prepare training materials related to BI and AR and helped in the preparation of job aids/change management materials.
• Managed vendor relationships, processed invoices in Bill.com and finalized year-end 1099 tax reporting.
• As part of PeopleSoft Financials and supply chain management (FSCM) team worked on implementation of General Ledger, Accounts Payable, Accounts Receivable, E-pro and Purchasing, Order Management and Inventory modules.
• Involved in Analysis, detailed design, development, testing, conversion, production support, ongoing maintenance and modifications of the system as per the requirements during this life cycle Implementation.
• Involved in fit/gap sessions to identify requirements and gaps and then created business requirements and technical requirements documents from these sessions.
• Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Reviewed account reconciliations, prepared technical accounting memorandum's and resolved reporting issues.
• Worked on User Productivity Kits (UPK) to prepare training materials related to BI and AR and helped in the preparation of job aids/change management materials.
• Worked closely with the Business team and users to understand their issues and solve the incidents and work orders.

PeopleSoft Financial Analyst

Confidential - Dallas, TX

Responsibilities:

• Worked on installation of PeopleSoft (understand the PeopleSoft Internet Architecture-PIA). Using Change Assistant, running upgrade scripts and debugging when issues occur.
• Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
• Managed gap analysis & feasibility study, created interfaces between PeopleSoft, Oracle EBS and in-house applications to integrate the systems, schedules, and the entire implementation life cycle.
• Customized HCM 9.0 applications for adding reopen functionality in absence management system, providing functionality to user to enhance and update preferred name through self-service.
• Configured and Documented all key components of General Ledger including GL options, calendars, chart fields, business units and ledgers.
• Managed upgrades to FSCM, new functionality, system performance, and business process analysis.
• Provided support to GL, MSS, Chart Field Interfaces to integrate PeopleSoft HR with PeopleSoft Finance Systems. PeopleSoft Production support for Finance & Accounting and SCM.
• Provided subject matter expertise guidance for PeopleSoft SCM (OM, Inventory) existing functional and technical usage and additional customization recommendations for various strategic project needs.
• Provided on-going project status, reporting, issue/action item resolution, and assisted the Project Manager with the development and documentation of methodologies and procedures.
• Implemented application customizations based on fit-gap analysis and enhancements for Projects, Grants, Commitment Control Billing, Projects, AR, AP, AM, Travel & Expense, Contracts and GL modules.
• Developed Purchasing Interface using File Layout, Application Engine, and Component Interface that loads data from flat file into staging tables while doing various data validations using Application Engine People Code and finally loads into PeopleSoft tables through component Interface.
• Performed customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that is already in stock.
• Developed an interface using Integration Broker to receive the fulfilments from the third-party system.
• Developed a custom Application Engine program to interface Sponsor data from Info Ed to PeopleSoft using the delivered Customer Component Interface.
• Worked on several reports relating to FSCM modules AP, AR, PO, IN and GL relating to aging, vendors, matching, Stock Status and payments.
• Worked on PeopleSoft SCM, FSCM modules such as General Ledger, Account Payable, Account Receivable, E-Procurement, EX, KK, MFG, Billing, Inventory, and Purchasing.
• Worked on PeopleSoft Internet Architecture, PeopleSoft FSCM and PeopleSoft Security Design and configuration for 9.0.
• Performed research and study of the existing system tables and business processes. Also, involved in the in- depth study of the customizations made in the GL, AP, AR, PO, INV modules.
• Involved in functional administration, application setups, training and support of PeopleSoft Financials (GL, AP, AR, Billing, EPRO, Security access, Workflow) as well as active involvement in the SOX audit process.
• Worked on AP module and Customized the Journal Entry page, People Code in GL to store certain custom information. Customized the Ledger Inquiry and Journal Inquiry pages.
• Loaded data from external source to PeopleSoft using application engine and SQR. Design/ Developed Hyperion feed for PeopleSoft chart fields and Ledger using store procedure and SQR.
• Identified all comparable and non-comparable objects to be upgraded and retrofitted them in the respective database.
• Worked as a single point of Contact for all the GL issues. implementing the reports for Treasury Module (Roll forwards & SEC reports)
• Worked on projects and product support environment. Month End Closing Activities. Production Support to the GL Module.
• Worked on Approval Framework AWE configuration for HCM MSS transactions and FSCM transactions like Purchase Order, General Ledger.