SUMMARY

• Over 8+ years of experience as FSCM Techno - Functional consultant, with expertise in creating requirements based on client’s needs.
• Thorough understanding of PeopleSoft Financials and Supply Chain Management modules, including AP, PO, GL, AM, Strategic Sourcing, Project Costing Contract, Billing, Financial Learning Resources, Payment Method, Catalog Structure.
• Maintenance and Production Support of PeopleSoft FSCM modules.
• Strong knowledge & understanding of industry standard methodologies including Software Development Life Cycle (SDLC) and Project Life Cycle.
• Excellent management and problem solving skills with thorough knowledge in Application Designer, People Code, SQR, PS Query, Application Engine, Component Interface, Security Process Scheduler and PeopleSoft development tools.
• Has extensive FSCM implementation experience in MSS, ESS, Accounts Payable, Accounts Receivable, General Ledger, Purchasing, etc.
• Strong knowledge on performance tuning of SQL, SQR and Application Engine Programs. Played various roles within projects - Functional Consultant, Technical Consultant, Techno/Functional Consultant and Defect Prevention Analysis (DPA).
• Strong collaboration & team building skills with proficiency Confidential grasping new technical concepts quickly and utilize the same in a productive manner.
• Great understanding towards the needs of the client to provide invaluable support from design to post-production stages.
• Experienced in working with Onsite/Offshore model.
• Hands on experience in setting up the configurations for PeopleSoft 9.0, 9.1 & 9.2 AP, GL, AR.
• PeopleSoft SQR experience in Data Conversion to facilitate the migration of data from legacy applications to PeopleSoft using SQR, File Layout Application Engine and Component Interface.
• Experience also includes Debugging and Performance Tuning of processes. Well versed with debugging tools like SQL trace, PC debugger, and Application Engine trace for Troubleshooting.
• Experienced in setting up projects and activities using delivered set ups in Project Costing.
• Expertise in Project Management, Project Scheduling, Project Tracing, Risk Management, and Team Management.
• Good understanding of PIA, App Server Configuration, Internet Architecture Process Scheduler, Web Server, Tuxedo and Jolt.
• Conversant with Administration Tools such as Process Scheduler PeopleSoft Security and Data Mover.
• Strong interpersonal and excellent communication skills.

TECHNICAL SKILLS

PeopleSoft FSCM Modules: PeopleSoft Financials … GL, AR, AP, PO, Inventory, eProcurement, Purchasing, Inventory, Energy & Utilities, Treasury … Enterprise Portal …

PeopleTools: Application Designer, Application Engine, Component Interface, Data Mover, Tree Manager, Query Manager, PS Security, Process Scheduler, PS/Query, Import Manager, Application Messaging, Configuration Manager, Process Monitor, Application Package, Workflow, Integration Broker, Process Scheduler, People Code Debugger, etc. Reporting Tools PS Query, SQR, XML Publisher, BI Publisher

Data Management Tools: Data Mover

Databases: Oracle 9i, Oracle 10g,Oracle 11g, SQL Server 2005, SQL Server …

Programming Languages: People Code, SQL, C/C++, Java

Operating Systems: MS Windows … UNIX.

Microsoft Tools: Visio, Projects, Access, Excel, Word, PowerPoint, and Outlook.

PROFESSIONAL EXPERIENCE

Confidential - Plano, TX

PeopleSoft Financial Functional Consultant

Responsibilities:

• Gathered requirements from business users related to their business functionality and understand their current system.
• Performed Fit Gap analysis based on the current and new PeopleSoft system for all the modules including GL, AP, AR, eProcurement and Security in Financials using Agile methodology.
• Involved in upgrade activities for financials tasks for AP, GL, AR, PO
• Converted custom crystal reports to XML BI Publisher
• Reviewed the fit gap documents with business before finalizing.
• Analyzing the current FSCM system as per the reporting requirements of client and their integrations with external systems using Agile methodology.
• Prepared high level functional and technical designs based on the fit gap document and provide the design to the business users.
• Used application upgrader to migrate objects from demo target instance.
• Gathered the workflow requirements from a business users and prepare a requirement document.
• Prepare the high level design to implement Approval Workflow Framework (AWE) using UML.
• Finalized the reporting requirements with users & provide the specifications for the same to the technical team.
• Analysis of compare report between 9.1 to 9.2
• Analyzed and gather requirements from security administrator related to current security design and prepare high level design.
• Assisted the users in designing the system using PeopleSoft setups for financials.
• Developed enhancements and customizations for FSCM modules include AWE using PeopleTools, Component Interface, Pages, Records, Menus, Folders and Nodes according to technical specifications.
• Have experience in writing People Code in application packages to handle the data sent by third party system and to send payment files to banks using Financial Gateway.
• Developed complex pages as per user requirement.
• Performed Quality Assurance work by building test scripts based on business use cases and recording test results.
• Developed conversion routines, interfaces with CI Application Engine process from existing systems. Interact with stakeholders and in documenting change request for the financial modules.
• Developed test scripts and perform integration testing.
• Reviewed the new enhancements/modifications to ensure quality product and make sure the requirements are met.
• Migrate developed code from development to testing environments and provide assistance to the users in User Acceptance Testing.

Environment: PeopleSoft FSCM 9.0, 9.2, AP, AR, GL, BI, PO, PeopleTools 8.54, Objects-People Code, BI Publisher, Application Designer, Application Engine, Component Interface, File Layout, XML Publisher and SQR.

Confidential - Chicago, IL

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in design and development of customizations and enhancements using PeopleCode, PeopleTools, Integration and Reporting Tools.
• Designed and developed conversion programs to load legacy data in PeopleSoft tables.
• Designed and developed integration broker interfaces for inbound/outbound interfaces.
• Designed and developed Voucher and GL integration broker interfaces using service operations, app messages, app packages and PeopleCode.
• Developed custom Purchase Order dashboard component to display Requisition, Purchase Order and General Ledger information related to purchase order.
• Customized the AP positive pay file as per the client’s bank requirement.
• Involved in configuring and testing the check printer.
• Customized the delivered PO SQR as per client requirement.
• Assisted AP users to excel voucher upload process and Journal import process.
• Customized AP and GL XML reports as per the business requirement.
• Configured, delivered and developed custom workflow processes using AWE.
• Configured Requisition, Voucher and Purchase Order approval processes using AWE and developing custom objects.
• Extensive debugging to find the data integrity problems and data conflict errors.
• Designed and developed multiple complex SQR, crystal and XMLP reports as per the business requirement.
• Data Mover scripts to move the data from Development database to QA and to production database.

Environment: PeopleSoft Financials 9.0, 9.1, PeopleTools 8.54, Application Engine, Component Interface, File Layout, XML Publisher and SQR, Windows NT/2000 UNIX.

Confidential, Herndon, VA

PeopleSoft Functional Consultant

Responsibilities:

• Have hands-on implementation as a functional consultant for Accounts Payable 9.1 and General Ledger 9.1 modules (AP, GL).
• Designed and configured Chart-fields. Modified and customized Chart-Field labels to suit Confidential 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 with Bank of America.
• Designed AP Voucher approval workflow.
• Created nVision Balance Sheet reports for new business units. Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing business units.
• Maintained business units and accounts reporting trees using Tree Manager.
• Configured new Allocations including Inter-Unit Allocations.
• Assisted users in suspense Journal Corrections. Worked with enhanced 8.8 spreadsheet loader and excel to CI utility.
• Performed Month-end and Quarter-end close. Troubleshoot out of balance-sheets.
• Configured new Journal Source and troubleshoot new GL Interface issues.

Environment: PeopleSoft 9.1, Oracle 9i, Windows XP, Visio, Crystal Reports 11, nVision, PS Query (GL, AP, PO, AM, Expenses, ePro).

Confidential, Richardson, TX

PeopleSoft Functional Consultant

Responsibilities:

• Worked as a functional consultant for core finance system that includes GL, PO, ePro AP, PC, KK, AM, Contracts and AR modules.
• Responsible for day to day production support financial issues and responsible for enhancements of the modules.
• Recorded test cases using PeopleSoft test framework in Requisition, Purchasing, eProcurement and Asset Management, Security modules.
• Developed custom PeopleSoft fluid applications using PeopleTools.
• Developed PeopleSoft Dashboards.
• Involved in business unit consolidation - Setups table set control changes, Interface testing.
• Integrated PeopleSoft subsystems like Asset Management, Account Payables, and Expenses into General Ledger.
• Integrated various interfaces from external systems which generate a flat file and developed customized process to ensure the standard journals are created.
• Setup the File Layout to match the standard journal template and involved in setting up accounting entry definition and journal templates.
• Played an important role in developing excel to flat file conversion to load General Ledger Journal and Commitment Control Journals.
• Worked on the concepts of Accounting Open Periods and its dependency on the PeopleSoft subsystem validations.
• Developed a GL daily reconciliation report that provides information on what is recorded on Journals and what is the PeopleSoft subsystem expected to pay.
• Experienced in Setting up workflows for Requisitions and Purchase orders using Workflow technology and route control profiles.
• Involved in Purchasing Set Ups including buyer, Requestor, and User Preferences.
• Integrated purchasing including Requisitions and Purchase Orders into Project Costing using delivered PeopleSoft Interfaces.
• Involved in coordinating with data stage to read the files from the external system and send the data to the Account Payables system to create vouchers using Voucher Build Process.
• Integrated interfaces with PeopleSoft Subsystems like Expenses to read the files and directly create the vouchers.
• Involved in Year End Activities for Tax Reporting involving 1099.
• Involved in Fiscal Year Accrual Activities to accrue the commitment amount from one fiscal year to next fiscal year.
• Involved in understanding the interfaces from various PeopleSoft subsystems into Project Costing including Purchasing, Account Payables and Expenses.
• Knowledge on various analysis types coming from PeopleSoft subsystems that determine the remaining budget in project costing.
• Integrated external systems to read the projects and activities from Project Costing and insert into their customized tables.
• Worked on the Excel to CI utility that helps in loading budget into Project costing.
• Worked on various reports to track budgets in project costing.

Environment: PeopleSoft Financials 9.1, General Ledger, Accounts Payable, AR, Purchasing, Workflow, Commitment Control kk, Application Engine, People Code, Component Interface, PeopleTools 8.44, SQL, nVision and SQR-3, Windows XP, UNIX, Oracle, PL/SQL.

Confidential

PeopleSoft Consultant

Responsibilities:

• Development & Customization using PeopleTools in sales and marketing module of PeopleSoft to achieve the Business Requirements.
• Analysis, design, construction and implementation of new PeopleSoft components
• Part of core team for incorporating customizations and providing support for Out-of Box delivered PeopleSoft CRM.
• Created the Application Packages for inbound interfaces which uses this application package
• Designed, developed and testing of the assigned enhancements and bugs.
• Prepared technical design documents.
• Fixing the production issues within the agrees SLAs
• Reviewed design documents and Code along with the test scripts.
• Supported the testing team in resolving functional queries during the testing phase, to check the Data dependency in the PeopleSoft Application
• Preparation of Implementation plans and Migration checklist for pre-migration and post- migration
• Involved in offsite support and production support and enhancement to the application to enable to the proper use of end users.

Environment: PeopleSoft CRM, PeopleTools, Crystal Reports 9, People Code, Application Engine, Data Mover, Flow, Security, Application Package, DB2.

Confidential

PeopleSoft Consultant

Responsibilities:

• Applied PeopleSoft knowledge to help business partner analyze data and provide recommendations for business and system related issues.
• Configured PeopleSoft Integration Broker
• Used JBuilder to create mapping
• Provide and consume web services with third-party systems
• Test connector and message processing using the send master utility
• Used Transformation test to test the transformation engine
• Used Handler tester to test service operations
• Creating an Application Engine Transform Program using J Builder
• Developed a transformation engine for outbound and inbound messages
• Send Master and the Handler Tester, Utility Tester utility to test the integrations

Environment: PeopleSoft Financials - Payables 9.0, v9.0 with MP21, PeopleTools, Integration Broker, PeopleCode, Application Engine, Data Mover, Flow, Security, Application Package, Fusion Middle 2.5 Ware and Seibel CRM 8.2.