• Over 7+ years experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
• 7 years experience in wide range of PeopleSoft Financials/SCM modules including Accounts Payable, Accounts Receivable, Expense, Billing, General Ledger, Inventory, Order Mangement and Project Costing.
• Strong PeopleSoft technical skills include PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, Process Scheduler, Query, Data Mover, Security Administrator and Definition Security), SQR (Inbound and Outbound Interfaces), and Crystal Reports.
• Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade. Applied PeopleSoft Patches, Bundles.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Strong database skills include data modeling, database design, Oracle server-side programming in PL/SQL and Oracle database administration.
• Knowledge on app server configuration, PIA, Process Scheduler, web server.
• Excellent troubleshooting and problem-solving skills.
• Team player with excellent interpersonal communication skills and technical documentation skills.
• Primary and secondary on-call for PeopleSoft Financials support.
• Experience in using Quest’s STAT change management and control solution for migrations.

Technical Skills

• PeopleSoft Financials (9.1, 9.0, 8.9, 8.8, 8.4, 8.0)
• Application Designer w PeopleTools w Peoplecode
• Application Engine w File Layout w Component Interface
• Security Administrator w Object Security w XML Publisher
• Tree Manager w Process Scheduler w SQR
• PS Query w Crystal Reports w Production Support

w Performance Tuning w Integration Broker w AWE

• Workflow w PL/SQL w Data Mover
• nVision

Operating Systems

w Windows 2000, NT w UNIX w Mainframe

Databases

w Oracle 11g/10g/9i/8/7.x w MS SQL Server w DB/2

Applications

w General Ledger w Accounts Payable w Accounts Receivable
w Purchasing w Billing w Inventory
w Asset Management w Project Costing w Expenses
w Order Management w eProcurement w Treasury(Cash Management)
w Grants Management w Contracts w Commitment Control

Education

Bachelors in Comp Science, Osmania University, India

Professional Experience:

Confidential,OKC Aug 12 – Dec 12

Project: Peoplesoft Financials/SCM (Purchasing and Inventory) 9.1 Tools 8.51 Responsibilities:

• Gathering the requirements for new business processes for the organization and writing the business requirement documents.
• Involved in writing Gap documents, solution and functional documents for
• requisition, Default Actual Cost Price update and Item Attributes.
• Involved in configuring the run controls for all batch programs in SIT and UAT
• Coordinated with Batch Team in scheduling the batch jobs in TWS (Tivoli).
• Coordinated with System Integration testing team in testing the Default Actual Cost Price
• update program all Batch Run Controls.
• Involved in defining the Primary Permission lists, Role to Position mapping, AtPar
• Involved in day-to-day support in the Implementation of PeopleSoft Financials and Supply chain Management version 8.9 Inventory, Purchasing and Order Management modules.
• Involved in Materials GO – LIVE locations. Involved in the pre-deployment and post-deployment activities for the Go-Live.
• Involved in Support to the users for the Hand held devices and for all the
• Production Issues that came across in Inventory and Purchasing and Order
• Management Modules.
• Involved in training the Materials Users on Hand held device in performing Cart Counts, picking, receiving, Stock Issues.
• Extensively worked in correcting the Par location Errors.
• Involved in training the managers in correcting the BCT Errors for receiving and picking.
• Work closely in User acceptance testing of Inventory and Purchasing modules.
• Involved in Support to GO – LIVE for WMS (Warehouse),
• CRP (Central Refill Pharmacy) and One Link.
• Involved in adding new par locations (clinics) for the Out Patient Pharmacies.
• Documenting the Job aids to train the Users.
• Involved in the stabilization of Northern California Pharmacies.
• Worked with extended IT team to support the overall Design Opportunity to Order Fulfillment business process.
• Participated in Catalog Management Requirements and Fit-gap sessions.
• Extensively worked in identifying issues, risks and defects related to integration between catalog management and PS Purchasing and EPro.
• Involved in accommodating the data mapping/transformations of imported catalog content.

Confidential,May 12 – Aug 12

Project: Peoplesoft Bundles and Tools Upgrade (8.51 to 8.52). Bundles MP10 – AP, GL, PO, EXP,OM

Responsibilities:

• Worked on Estimates and Reapplying customizations for Peoplesoft 9.1 Upgrade
• Reviewed compare reports and analyzed what all customizations need to be reapplied for GL,
• AP and PO modules.
• Reapplied Customizations for GL, AP, and PO module and tested the functionality in 9.1
• Expertise involved in working on enhancements and fixing problems includes, technical and functional understanding of the Application and good knowledge of processes.
• Reapplied customizations on the AP – FIN2025 EFT SQR Process. Resolved Issues with Error Loading Parameters during EFT Process submission on Pay Cycle manager
• Reapplied and Tested AP Crystal Check APY2021- . Resolved issues with APY2021- not working for Spanish Language
• 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.
• Reapplied Customizations on the Voucher and Vendor Components
• Analyzed Compare reports to Identify the customizations that need to be reapplied
• Customized Application Engine Programs like Payment Selection, Payment Creation,
• Discount Evaluation, Voucher Posting (AP_PSTVCHR) and Payment Posting
• (AP_PSTPYMNT) in AP.

Confidential,KS May 11 – Apr 12

Project: PeopleSoft Financials/SCM (Travel and Expenses Implementation) 9.1 Tools 8.51

Responsibilities:

• Responsible for the Implementation of Expenses for University of Kansas, Lawrence.
• Designed custom approval processing for Expense processing and reporting.
• Designed Custom Speed Chart Functionality for Expense Report Accounting Entry
• Developed Several Custom Validations that need to be Done Prior to Expense Report and Cash Advance Submission
• T&E: Configured ImageNow to Integrate PeopleSoft with Imaging System so Users can Enter and Store Receipts
• Implemented Bar-coding Feature on Expense Receipts Printing and Attachment
• Developed Settlement Process to Pay Certain Business Unit Related Expense Transactions from AP Vouchers
• Initial Load of Authorized Users List using Excel to CI
• Defaulting the GL BU and Account on User Profile and User Preferences of Setup of New Expense users
• T&E: Testing AWE Workflow End to End , Setup Test User Roles for AWE Testing in UAT
• Setup ACH and Bank Account Information for Expense users
• T&E: Designed a Process to Add a Set of Expense SuperUsers to Authorized Users for Employees prior to Golive.
• Developed Test Scripts for AP and Expenses for QA and UAT Testing
• Applied Bundles and Reapplied Customizations that have been Broken by Bundles
• Created user roles and security matrix for both Accounts Payables and Expense users. Developed custom checks for Business
• T&E: Designed Mileage Matrix used to store mileage distances based on zip codes used for reporting purposes
• T&E: Designed a Technical Design and Developed a Process using Excel to CI for Loading CONUS and OCONUS data provided by IRS
• Conversion: Responsible for all aspects of Employee and Vendor conversions.
• Provided post-production support for Expense module.
• Responsible for creating and leading training program to Expense Auditors.
• Designed the custom approval process using AWE in expenses module to replace the client’s paper based approval process.
• Setup, configure and troubleshoot PeopleSoft Enterprise Integration Points (EIP’s) between FIN v9.1 and HRMS v9.1 PeopleSoft systems.
• Configured the AWE (Approval Workflow Engine) for Expense Reports and Cash Advances
• Worked with PeopleSoft Customer Connection Support team to resolve the issues in 9.1 Tools 8.51.

Environment: PeopleSoft FIN/SCM 9.1, PeopleTools 8.51, Workflow, XML Publisher, Integration Broker, People Code, Application Package, Application Engine, Oracle 11g.

Confidential, KS Mar 10 – Apr 11

Project: PeopleSoft FIN/SCM (AP, Travel &Expenses, GL and PO) v9.0.

Responsibilities:

• Involved in the PeopleSoft AWE Implemenation for GL Journal Approvals, Expense Report and Cash Advance Approvals and PO Requisition Approvals.
• T&E AWE: Configured the AWE Approval Workflow for HR Supervisor, Pre Auditor and Post Auditor Approvals
• T&E AWE: Setup the Minimum Receipt Amounts ,Post and Pre Auditor Approval Amounts
• T&E: Setup Privilege Templates and Approval Profiles for AWE Configuration
• T&E System configuration – Such as Employee Setup, Authorized User Setup, AWE Setup Process Definition, AMEX and VISA Load Mapping Setup
• Setup Expense Report Approval Workflow Engine as per requirements.
• Solved various Defects for Expense Report and Cash Advance AWE.
• T&E: Automated the Load of new Credit Cards into Employee Profile
• Travel & Expenses: Developed Attachment Functionality to attach Receipts and Images to Expense Reports
• Resolved issues with Expense Stage, Post Liabilities and Post Payments Process
• Also Setup the Payment , overdue and Credit Card Notifications for Employees
• Involved in fit/gap analysis, analyze customization of online objects after reviewing the compare reports, detail design, development, testing. Troubleshoot/debug, performance tuning and Production Support. Developed and tuned scripts for data conversion using SQL/SQR, Application Engine and Data Mover.
• Involved in Workflow for ePro for requisition approval.
• Created a complete functional flow of ePro to Inventory flow using VISIO for the better.
• Setup AWE Workflow for ePro Requisitions. Also Customized the Workflow Approval Process as per Clients Requirements
• Production support in Account Payable and eProcurement Modules.
• Designed and developed in-bound and out-bound interfaces to and from Peoplesoft to existing legacy system.
• Modified the Pay Cycle Process, removed the PeopleSoft delivered Crystal (APY2021.rpt – Payment Advice- Format and Print EFT) and plugged in a custom SQR in to Print the Checks

Environment: PeopleSoft FIN/SCM 9.0/8.8, People Tools 8.49/8.47, XML Publisher, Workflow, Oracle10g.

Confidential,San Jose, CA Jan 09 – Mar 10 Role: Sr. Technical Consultant Project: Implementation and Production Support for various financial / SCM (INV, PO and CM,OM) 8.9. Responsibilities:

• Involved in the PeopleSoft Implementation Project for OM, INV, PO, BI, CM, Product Configurator and Manufacturing Modules.
• Conducted Fit/Gap, Pre-Design, Detail Design, Suggested and Implemented approaches on various business process of the client.
• Involved in development and review of High-level and detailed Technical specification documents based on the Functional specification documents.
• Modified the functionality in Order Management to return multiple order lines in order entry page based on the product configurator specification.
• Developed an Application Engine program to increase the demand line for an order based on the overrun in product configurator.
• Developed an ApplicationEngine program to automate the billing of non-inventory product charges based on the shipping of the finished goods.
• Travel & Expenses: Added custom Code to add fields on the Overdue , Payment and Employee Notifications
• Travel & Expenses: Added Link to Filenet to attach Expense Receipt Images
• Travel & Expenses: Configured Employees to handle EFT and ACH Payments for Expense and CASH Advance Payments
• Expenses: Added Custom Validations on the Additional Recipients, Hotel Wizard and Receipt Split Functionality on Sheet Entry Pages
• Travel & Expenses: Customized the Amex Load Process - Added a Log and Error Report
• Travel & Expenses Added Payment Type and Other fields on the Expense and Cash Advance Approval Pages
• Travel & Expenses Customized the Fields that can be seen on My Wallet Page, Employee Self Service and Manager Self Service Expense Report and Cash Advance Pages
• Travel & Expenses Resolved issues with Expense and Cash Advance Approvals
• Modified the peoplesoft delivered production document SQR report (SFS2003).
• Developed an on time shipping report in SQR to track the on time shipping data based on the shipping dates.

Environment : PeopleSoft financial/SCM 8.9 (GL, AP, Travel & Expenses, OM, INV, PO), People Tools 8.49, DB2, Application Engine, SQR, PeopleCode, Component Interface, Data Mover, PS Query, Windows NT 4.0

Confidential,Evanston, IL Apr 07 – Dec 08 Role: Sr. Technical Consultant Project: Upgrade and Production Support of various PeopleSoft Financial/SCM Applications Version 8.4 to 8.9. Responsibilities:

• Involved in the PeopleSoft Upgrade Project for AP, AR, PC, BI, PO, AM & GL Modules.

Involved in fit/gap analysis, analyze customization of online objects after reviewing the compare reports, detail design, development, testing. Troubleshoot/debug, performance tuning and Production Support. Developed and tuned scripts for data conversion using SQL/SQR, Application Engine and Data Mover.

• Developed Payment Interfaces to load bank recon data into PeopleSoft Payables from bank transaction files.
• Mass change process failed with large volume of data, fixed by breaking the data based on capitalization switch in AM.
• Developed GL Conversion that loads data from PeopleSoft v8.4 into PeopleSoft v8.9 General Ledger using SQR, which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level, grand totals, error handling procedures, printing multiple output reports, maintenance report and processed file report. Used various SQR functions, Arrays, Tress, Views,Load Lookups & SQC (which handles various Invalid Chartfield Combinations).
• Extensively worked with People code, application engine and reporting tools.
• Customized payments to have a Magnetic Ink Character Recognition (MICR ID) & customer ID to match payments to customers.
• Developed Purchasing Interface using File Layout, Application Engine, and Component Interface, which loads data from flat file into staging tables while doing various data validations using AE PeopleCode and finally loads into PeopleSoft tables through Component Interface.
• Wrote several SQR Reports for vendor activity information with dynamic SQL and dynamic sort and criteria options.
• Created Complex Enquiry page for Payable vouchers, age wise analysis, having flexible criteria selection options.

Designed additional tables to hold billing data received in PeopleSoft from the 2 additional source systems and enhanced the Staging Process (SQR program) and Billing Interface (BIIF0001) accordingly.

Environment : PeopleSoft Financials 8.4/ 8.9, People Tools 8.48, Oracle 10g, Workflow, Application Engine, SQR, Peoplecode, Component Interface, PS Query, Crystal Reports, Unix and Windows NT 4.0