SUMMARY:

• A seasoned Business Analyst and PeopleSoft Functional Consultant with around 8 years of experience. Worked in various project phases and area starting from Requirements Gathering, Development, Upgrade, Conversion, Testing and Production Support.
• Have worked in diverse domains of business involving Procure to Pay Modules - eProcurement, Purchasing, Procurement Contracts, eSettlement, Strategic Sourcing, Asset Management, Account Payables, General Ledger and Order to Cash Modules -Order Management, Billing, and Accounts Receivables.
• Expert experience with People Tools: Application Engine, People Code, Page Design, Database Performance Monitoring and Application Designer, Workflow, PeopleSoft Reporting Tools XML Publisher, PS Query, Connected Queries, SQR and PeopleSoft Integration Tools EXCEL2CI, Component Interface.
• Strong understanding of Agile and Waterfall SDLC methodologies .
• Used Application Engine to perform background processing against the data.
• Created new reports using SQR, XML Publisher and modified the existing ones as per the changes specified.
• Created and customized SQR reports as per the requirements and scheduled them using Process Scheduler.
• Experience in Business Requirements gathering, Fit-GAP analysis and writing Functional and Technical Specifications.
• Expertise in writing PS Queries for creating reports.
• Profound knowledge on SQL and RDBMS concepts such as Normalizations, SQL optimization and tunings.
• Sound knowledge on SQL Language Definitions i.e. DDL, DML and DQ.
• Strong analytical skills to convert Functional design specifications into Technical Design specifications.
• Excellent in problem solving and self-learning attitude and has clear understanding of business procedures and ability to work as an individual and also part of the team.

TECHNICAL SKILL SET:

ERP: PeopleSoft Financials (Account Receivables, Account payables, General Ledger) and Supply Chain Management (Order Management, Procurement Contracts, Purchasing, Strategic Sourcing, eProcurement, Asset management, Billing) 8.9/9.0/9.1/9.2

People Tools: Application Designer, Application Engine, Workflow, Component Interface, Integration Broker, People Code, AWE, Query, Process Scheduler, Data Mover, Security, File Layout, Application Messaging, Excel To CI.

Scheduling Tools: Process Scheduler, Control M, Tivoli, Zena

Languages: People Code, ASP 3.0, VB 6.0, HTML, VBScript, JavaScript, UNIX, Java, C/C++

RDBMS: SQL Server 7.0, 2000, Oracle 11g, 10g, 9i, 8i, 7.3

Administration Tools: Portal Administration, Object Security, Workflow, AWE and Query Security.

Reporting Tools: SQR, Crystal Reports 8.x, PS Query, nVision, XML publisher, BI Publisher, QlikView, Tableau, Business Objects

Operating Systems: Windows NT 4.0/XP/2000/98/95, Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Senior Functional Consultant

Responsibilities:

• The scope of work for this project is to upgrade their existing PeopleSoft FSCM 9.1 system to Peoplesoft FSCM 9.2 along with implementation of newly added requirements . Retrofit customizations and use any new functionality.
• Responsible for Fit and Gap Analysis, Business requirement gathering, configuring the system, Designing functional and technical documents and creating Process flows.
• Performed Initial Pass steps.
• Worked on Procurement modules - EProcurement, Purchasing, Procurement Contracts, and Strategic Sourcing.
• Documented new functionalities that are going to be used in the new system.
• Prepared Configuration Documents using Setup manager for all the procurement modules - Configurations required for the existing features and also the configurations required for new features.
• Implemented Change Request/Change Order process and Close short process.
• Worked on setting up Buyer WorkCentre and Dashboards.
• EProcurement Requisition workflow enhancements implemented.
• Developed Test Scrips for TM1 and TM2, includes customizations, interfaces, and reports and prepared validation documents for the same.
• Coordinate with technical team for resolving defects and changes.
• Worked with Oracle on issues/bugs.
• Coordinate with users for UAT, Document failures and provide re-testing.
• Conducted In-class Training for Users on all the Procurement modules.
• Provide production support for year-end close and all production functional issues.
• Work with team of Developers and Functional consultants in End-to-End Go-Live Deployment.
• Performed and validated conversions.

Confidential, Rosemont, Illinois

Environment: PS 9.0

Senior PeopleSoft Consultant

Responsibilities:

• As part of business requirement (Indirect Spend) Implementing the Indirect Spend Procurement with the Ivalua technology (SAAS) will achieve to automate the AP Source-to-Pay process to limit the manual process and give the better reporting on the spend to operate the business.
• Design and develop Invoice/Voucher/Vendor integration between IVLAUA PO system and PS Accounts Payable.
• Gathered requirements from the users and made Design Documents.
• Discussed Data mapping of Accounts Payable fields for the integration with users.
• Created Functional Design document with the requirements gathered from user.
• Created new AP records, pages and components using Application Designer according to the functionality.
• Developed complex Inbound Interface to populate the AP Voucher tables from XML files.
• Built a dynamic process for mapping data from XML file into PeopleSoft AP custom tables, which lets us have control over data flowing into the system.
• Developed a new Application Engine to move data into Confidential Custom AP Voucher tables, which takes care of multiple validations along with custom error handling.
• Involved in modification and fine-tuning of Application Engine, SQR programs.
• Developed test cases, Document BR (Business requirements), Perform UAT, Document failures and provide re-testing (PTF).
• Involved in resolving issues raised during SIT/UAT.
• Involved in knowledge transfer and training.

Confidential, Greenwood Village, CO

Environment: PS 9.2

Senior Functional Consultant

Responsibilities:

• Team lead on upgrading FSCM 9.0/9.2.
• Gathered requirements from users and designing the Functional documents.
• Configure PeopleSoft system for GL, INV, AR, AP, CM and P2P modules.
• Designed and configured chart-fields, Modified and customized chart-field labels to suit business.
• Configured Business Units, Ledgers and Ledger Groups .
• Configured Journal Sources .
• Designed and configured combination edits and closing rules .
• Designed GL Journal approval workflow .
• Created nVision Balance Sheet reports . Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units.
• Configured new Allocations including Inter-Unit Allocations.
• Configured ACH layout, payment source and pay-cycle steps.
• Designed and configured payment handling codes and payment term timing codes .
• Designed and configured vendor categories and withholding codes (1099)
• Designed, configured and tested ACH and check payments.
• Designed the reconciliation process from start to end in AP module.
• Designed the dup checking functionality in AP module.
• Handled technical requirements related to Expenses, Asset Management, Accounts Payable, General Ledger, Purchasing and Project Costing.
• Developed various reports in PS Query, SQR in various modules like Account Payables, Billing and GL
• Developed proficiency in Procure to pay business process particularly in Payables.
• Developed several Queries for the Financial Reporting Purpose in AR, AP, and PO.
• Worked on modifying the Billing invoice XML reports and created new billing templates for different countries.
• Created job-aids to run jobs through Mainframe and ESP for other team members and new recruits.
• Assisted in Fit and Gap Analysis, business requirement gathering, configuring the system, demo, test plans, resource allocation and issue allocation.

Confidential, Kansas City, MO

Environment: PS 9.2

Functional Consultant

Responsibilities:

• People soft upgrade of Finance 9.1 to Finance 9.2.
• Gathered requirements from users and designing the Functional documents.
• Developed various prototypes and interfaces in AP and P2P as per business requirements.
• Involved in Client Meetings for testing GL data loads based on various sources.
• Developed a fresh interface for Multi-Currency transactions in AP and GL for customers on the Canadian side of the border.
• Purchasing and eProcurement sourcing from inventory Business processes implemented.
• Created a new Interface to migrate the Payment Information from Auto Integrate to PeopleSoft.
• Worked on allocations/Ledger copy processes from Maestro.
• EProcurement catalogues designed and implemented for purchasing and inventory items.
• Created custom job schedules and jobs definitions using Maestro tools.
• Worked with DBA/PS Admin teams in the process of resolving long running jobs/job schedules from Maestro tool.
• Worked on production issues occurs on day to day basis and communicated with Business Teams and Users Effectively with updates while resolving issues.
• Maintenance and Support of PeopleSoft financial applications along with non-production activities in GL module and Project Costing across multiple environments.
• Involved in Technical Fit Gap Analysis by attending meetings with end user team.
• Modified existing and wrote new PeopleCode to meet business requirements identified in fit gap analysis.

Confidential

Functional Internship

Responsibilities:

• Created new records, pages and components using Application Designer according to the functionality.
• Wrote PeopleCode for validating the data in the pages and for implementing the functionalities in the Application.
• Worked on developing Subcontract Automation Payments (Work Order) by integrating Recruitment and HR and Finance system for internal system Automation.
• Developed CI based Application engines for retrieving the data from Core HR Recruitment to create the Purchase Orders in Finance as part of Subcontract Automation Payments (Work Order).
• Created CIs for integrating and to sync the Recruitment system data with Finance system for Subcontract employees’ payment automation.
• Involved with Business requirements gathering, Fit and Gap analysis for GL, INV and PO modules.
• Created new SQR Reports and modified the existing SQR reports Finance in AR, Billing, PO, AM, GL as per the user requirements.
• Created a customized workflow for category-based approval in PO, Vendor approval.
• Prepared Technical design documents for corresponding functional documents.
• Prepared Unit testing documents, test logs and testing functionality of the reports based on given requirements.
• Worked on EXCEL to CI for the Item codes creation.
• Worked on AP, AR, Purchasing, AM and Expanse in solving P1, P2, P3 and P4 in PO, AP, AM, Expanse Modules tickets.
• Created the CI based web service for the PO and Expanse modules for the mobile-based approvals.
• Wrote various SQL queries for various operations on databases to accomplish user functionality.