PROFESSIONAL SUMMARY

• Over 7 years of experience as Techno-Functional consultant in PeopleSoft implementation of Financials Supply Chain Management AccountsPayables,Travel expenses, Purchasing,Grants,Cash Management,E-procurement, OM, Treasury, Inventory, Project Costing Contracts versions 8.0, 8.4, 8.8, 8.9,9.0,9.1,9.2 Tools Ver. 8.16/8.41/8.45/8.46/8.48/8.49/8.50/8.52/8.53.
• Over 7 years of Overall IT experience in all implementation phases including Business Process analysis, Fit-GAP analysis, Design/Build, Data migration, Unit, Integration and End User testing, Cut-off strategy, Go-live and Post go-live support and maintenance.
• 7 years of experience in writing PeopleCode, SQR and SQL, Crystal Reports, PS query development experience using PeopleTools and in writing inbound and outbound interfaces using SQR and Application Engine.
• Expert: Inbound Outbound Interfaces using: Application Engine, SQR, Data Conversion and Reports using Crystal and SQR.
• Hands-on experience working with the PIA architecture, App Designer Application Message,
• Component Interface, Business Interlinks and Batch Processes
• Good understanding of PeopleSoft Internet Architecture.
• Experience with People Code events, Editor, Methods and built in functions.
• Highly skilled in RDBMS concepts and data extraction/manipulation/reporting tools.
• Extensively worked on different relational Databases like DB2, ORACLE, and MS SQL Server.
• Strong analytical and quantitative skills along with outstanding learning capability and a result oriented attitude.

SKILL SUMMARY

PROFESSIONAL EXPERIENCE

Confidential

Sr Peoplesoft Technical FSCM Analyst

• Project: Peoplesoft FSCM v9.2 Integration between GPI and Advance auto parts. work streams like SCM, merchandise, integrated replenishment of ware houses , finance p2p,R2R, O2C .
• Developed Historical Payables Load App Engine Process
• Developed Daily Interface Feed For GPI Invoices into Peoplesoft AP using App Engine and File Layout
• Worked With GPI Team in Data Mapping and Data Cleanup of AP Vendor and Historical Payables Data
• Developed an Application Engine with CI and File Layouts for Conversion of Vendors from Legacy system into Peoplesoft.
• Configured the Matching Rules for Matching Vouchers with PO's and Receipts.
• Configured the Workflow for Voucher Approvals, Journal Approvals and for Matching Exceptions.
• Helped in configuring the AP module for conversion and go live which included implementation of EFT payments.
• To support decentralization of journal entry, journal approval workflow was implemented. The submitters would enter the journal on-line, attach supporting documentation, run the journal edit process, fix any journal errors and submit the journal for approval and posting once valid.
• Customized Journal Import Application Engine process for conversion of Journal entries from legacy system

.Confidential

Sr Peoplesoft Techno-Functional Consultant

• Project: Peoplesoft FSCM v9.0/9.2 Upgrade GL,AP,PO,AM Application Engine, AWE,SQR,Data Mover,PS Query ,XML publisher, Workflow, SQR,Peoplecode,Oracle 11i ,UNIX/Windows NT, People Tools 8.53.
• Implemented Crystal report in peoplesoft 9.2 by modifying peoplecode and page settings.
• Prepared Powerpoint presentation for a Cutsom Payment entry Method which will replace the current Concur system.
• Implemented Custom AWE Workflow for Projects and Pre Voucher AP Approvals
• Reapplied customizationstons to FIN2025.SQR,POPO005.SQR,FINEFT.SQC FINPYMNT.SQC afte 9.2 Image 5 update.
• Designed and developed AP Voucher Match Exception workflow process to send worklists and emails for the Match exception to the appropriate users.
• Developed Conversion program using Application Engine and Component Interface for loading open Vouchers from legacy system into People Soft Accounts Payable.
• Worked on a requirement for an EFT/ACH file using the current data in AP module
• Customized the delivered Accounts Payable Checks, Advices, Trial register and Match Exceptions report.
• Implemented GL Audit Features in 9.2 to Track Journal Posting, Editing and Creation by User ID
• Implemented GL Journal Approval Workflow in 9.2
• Developed Inquiry pages to show ASN and POA Information which will be navigated from Requisition life cycle.
• Fixed issues relating Purchase Order Dispatch to Perfect Commerce Market place.
• Developed custom messages and transformations to receive Invoice POA ASN'S Advance Shipment Notification from Buyer Quest Supplier Network in CXML format.
• Reapplied customisations to App engines,App packages,Pages,components,Peoplecode,Records in AP,GL AM .
• Configured and tested the AP Voucher and Vendor AWE workflow process.
• Resolved issues and fixed Bugs in AP,AM GL after 9.2 Upgrade.
• Resolved issues related to Integration broker Messaging.
• Created SR's,Resolved issues and applied Bug fixes.

Confidential

Sr Peoplesoft Consultant

• Project: Peoplesoft FSCM v9.2 Implementation Grants,GL,AP,Expenses,Inventory,procurement,AR,Billing and Contracts Application Engine, AWE,SQR,Data Mover,PS Query ,XML publisher, Workflow, SQR,Peoplecode,Oracle 11g ,UNIX/Windows NT, People Tools 8.52.
• Designed and developed Custom Bolt-on application for the e-Invoice entry .
• Designed, Map data for conversion, developed the Scripts for Conversion, Executed and Verified Converted data Supply Chain Management Financial Scripts
• Worked with the DBA team and developers, troubleshoot and Performance Tune Conversion scripts and code as required
• Designed and developed attachment functionality for e-invoice,Workflow routing for e-invoice and Peoplecode to execute AP Voucher build for these e-invoice.
• Developed XMLP Bursting for Billing Invoices.
• Involved in designing and developing Bank Statement Processing for AP.
• AP/Treasury: Wrote ACH and EFT interfaces to send data in CTX format.
• Designed an outbound interface in Accounts Payable which sends Vendor information from PSFT to external system
• Involved in the Creation and review of Business/Functional Requirement Documents.
• Modified Fin2025 SQR ,Fineft.sqc and created New SQC for creating Vendor Data Payment file to Wells Fargo in their required format.
• Involved in troubleshooting AR UPDATE process, which is used to process and update customer balance and history information, corresponding item information, and item activity.
• Developed a new program to print invoices for Billing module.
• Developed New App Engine inteface to load 3rd Part Billing Invoices into Billing interface staging Tables.
• Designed and Devloped the Custom XMLP Pre award spending Report in Grant/PC/Contracts.
• Designed and Developed the Custom XMLP Awarded Grants report.
• Resolved issues related to Integration broker,Component interface and Application package Peoplecode.
• Designed and Devloped Custom XMLP Active Grants Report.

Confidential

Sr Peoplesoft Consultant

• Project: Peoplesoft FSCM v9.1 Upgrade/reimplementation AR, BI, GL, AP, Expenses, Inventory, Purchasing, eProcurement Application Engine, Integration Broker,CI,Crystal Reports,XML publisher, Workflow, SQR,Peoplecode,MS SQL Server,UNIX/Windows NT, People Tools 8.52.
• Involved in analysis, design and documentation of the business process as required by the end users.
• Performed Fit-Gap analysis for proposed financial modules AP, AR, e-procurements, Expenses, AM and GL.
• Designed a Data Conversion Strategy for converting data from different sources into Financials, using AE, Component Interfaces, File Layouts and Application Engine - Converted GL, AP and PO Data
• Reponsible for Conversion of Data from Maximo into Peoplesoft Finance/SCM Applications
• Implement Vendor Conversion using Component Interface, File Layouts and Application Engine.
• Written a Conversion Program using Application Engine to Convert Customers
• Developed a Conversion Process to Convert External Bank Accounts into Peoplesoft.
• Developed a Conversion Process to Load External Vendors, Purchase Orders into Peoplesoft Using Component Interface and Application Engine
• Performed requirements gathering for inbound and outbound interfaces with ancillary systems.
• INV: Customized and validated the Packing Slip INS6500.SQR not to print the Packing slips that were already printed and added additional functionality of reprint.
• Developed custom message and transformation to convert output format from xml to Cxml format for Sending PO'S to Buyer Quest Network.
• INV: Formatting the Packing Slips, order Acknowledgments, Invoices and Purchase Orders etc.
• INV: Worked and Solved Issues Related to PICK PLAN, PUTAWAY and Replenishments
• Involved in creating a process to build Inventory demand which verifies the inventory table BU ITEM INV and then consequently checks the Inventory availability and then a calculation process is developed to source it to a PO using Purchasing module.
• Involved in mapping the legacy data with the corresponding PeopleSoft data.
• Did End to End Testing of AP, AR, Billing and GL Modules
• Provided User Training on AP, AR and Billing Modules
• Customized AR Aging reports like AR30001, 30002 as per the User Requirements.
• AR: Wrote a Component Interface that updates the month item based on the previous month item and item activity. This program creates a CSV file, which is sent to the custom Pending Item Loader App Engine program to load data into Pending Item and PENDING DST tables.
• BI: Creating custom reports on aging details and summary for regular bills and Expense bills.
• Creating a report for the Account Receivable on Pending items that runs and gives report periodically, that gives the list of all Pending Items, and Pending Payments.
• Modified Dunning Application Engine AR DUNNING , which was not populating the values to print Customer country
• Involved in setting up of Business Units and SETIDs using the Define Business Rules Menu and the Define General options panel group
• Involved in the Design of Interfaces to Load third Party vouchers in to Peoplesoft using inbound file publish Utility and VOUCHER BUILD message ,service and service Operation.
• Involved in the Design of Open PO conversion All open Purchase orders from v8.4 DB2 using Application Engine and Component Interface.
• Involved in the Creation and review of Business/Functional Requirement Documents.
• Involved in the setup of Web services between Peoplesoft and Informatica.
• Resolved issues related to Integration Broker asynchronous Messages.
• Involved in the Creation and review of Technical Design Documents.

Confidential

Sr Peoplesoft Consultant

• Project: PeopleSoft financials implementation and upgrade Treasury, AR, BI, GL, AP, Expenses, AM Purchasing Application Engine, XML publisher, Workflow, SQR,Peoplecode,Oracle10g,UNIX/Windows NT, People Tools 8.50/8.52
• Involved in the analysis, design, development PeopleSoft FSCM 8.9 and Upgrade 8.9/9.1 AP,Expenses,Inventory,purchasing,procurement .
• Completed full life cycle of Fit Gap Analysis, Business Process Reengineering, Designing, Developing and Unit Testing .
• Treasury: Worked on New Bank Format changes in TR FORMAT app Package for PMT DISPATCH process
• Treasury: Did Setup of Bank Recon and BSA Rules, Developed Process to Load Bank Statements into Peoplesoft
• GL Journal and Ledger Data Conversion: Written App Engine Programs to Load Journal and L edger Data from legacy into Peoplesoft GL
• Gathered requirements for GL Chartfield Redesign during 9.1 Upgrade
• Designed Mapping Documents for new GL Interfaces from Mainframe to Peoplesoft GL
• Identified all comparable and non-comparable objects to be upgraded and retrofitted them in the respective database.
• Responsible for running Compare reports against different PS databases.
• Upgraded several SQR reports and Interfaces for PeopleSoft Financials Upgrade.
• 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.
• Configured the AWE Workflow Approval for Vendor Approval, Journal Approvals, Expense Report Approvals.
• Reapplied Customizations on AWE Application Package for Expense Report Approvals.
• Reapplied Customization on AMEX Load Process, Expense Report Custom Validations and Other Expense Processing Application Engine Steps.
• Developed custom sqr programs to validate inbound GL interface load files, convert the flat file to GL standard inbound flat file in the file layout object GL JRNL IMPORT format to load the journals into PeopleSoft through the Application Engine Program GL JRNL IMP .
• Responsible for designing the interface between PeopleSoft General Ledger and Odyssey Billing , Avista Utility , Pyramid Claims and Payroll.
• Involved in Setup of Email Notification Templates and Escalation Rules for Journal Approvals AWE.
• Tested AdHoc GL Journal Approvals and ePro Requisition Approvals .
• Migrated AWE Process Definition, Transaction Registry and Transaction Configuration from One Environment to Other Using Data Mover Scripts.
• Customized the Vendor Approval AWE Process. Triggered AWE only when a New Vendor Is added or Updates on Certain Field Like: Vendor Address, Location and Vendor Name.
• Written and modified PeopleCode for panel and records and fields.
• Developed, performed, and facilitated application testing programs.
• Developed and customized on-line Panels and Menus according to the application requirements.
• Compiled and analyzed test scripts to find errors and confirm that scripts meet testing specifications.
• Customized the Check Printing Process, Developed New Pages,Peoplecode,New Queries,Crytsal Reports and App engines to Support the CUNA check Printing.
• Necessary Data Migration and Data Conversations required for Implementation.
• Worked with functional users to troubleshoot issues in production and test various scenarios in designated test domains.