PROFESSIONAL SUMMARY:

• Over 8 Years of experience in Analysis, Design, Development, Customization, Implementation, Deployment, testing and upgrades of PeopleSoft Applications 8.4/8.8/8.9/9.0/9.1/9.2 (AP, PO, AR, BI, T&E, PC, AM, e - Pro, GL, Banking).
• Worked as a Technical consultant for implementation, upgrade and support projects in Finance for clients in Banking, Insurance, Health Care, Manufacturing and Retail Sectors.
• Expertise in using People Tools.
• Integration experience with various third party systems to PeopleSoft FSCM.
• Good Analytical, problem solving and communication skills.
• Key strengths include ability to work under pressure, excellent team player, and quick learner and adapt to any new environment.
• Expertise in Application Designer, Peoplecode, Application Package.
• Experience in data conversion using Application Engine, File Layouts, and Component Interface and creating interfaces.
• Creating reports using PS Query, SQR, XML Publisher, and Crystal Reports.
• Good Knowledge in using PeopleSoft Integration Broker.
• Worked in Full cycle implementation of Peoplesoft Treasury Management 9.0
• Worked in upgrade projects for PeopleSoft Financials application.
• Experience in writing UNIX shell scripts to FTP the files to vendors.
• Interacted directly with the Business Users and Subject Matter Experts for conducting Requirement Gathering, Requirement Analysis, and Process Analysis.
• Individual analysis and resolution of the tickets assigned.
• Good at System analysis and preparing technical design documents for all the customizations.
• Performed Unit testing and prepared Test Plan and Test review documents.
• Experience in developing, retrofitting of Peoplesoft objects and reports.
• Responsible for the quality of the deliverables as per the standards.

TECHNICAL SKILLS:

ERP Applications: PeopleSoft Financials 8.4, 8.8, 8.9, 9.0, 9.1, 9.2

ERP Tools: People Tools 8, 8.4x, 8.5x

Reporting Tools: PS Query, SQR, XML Publisher, Crystal Reports, nVision, Integration Broker

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

RDMS Tools: TOAD, SQL Plus, SQL Developer, Benthic

Operating Systems: Windows 9x, 200, NT, UNIX

Defect Tracking Tools: BMC Remedy, Clear Quest.

Change Management Tool: STAT, Phire

PROFESSIONAL EXPERIENCE:

Confidential, Columbia SC

Sr. PeopleSoft Consultant/ Advanced BI Publisher Developer

Responsibilities:

• Involved in development effort for Converting Assets from legacy system (Mainframes) to PeopleSoft.
• Designed and Developed custom Process (Asset Bolton), basically a custom configuration page for Chart Field mapping for the AM accounting entries generated by PeopleSoft to the Chart Field’s needed to support the GL reporting requirements prior to the journal generation of asset accounting entries from AM to GL.
• Designed and Developed a custom Bolton for Payment Request, where prior to the AP approval the default values could be confirmed or adjusted for the creation of a voucher
• Designed and Developed a custom USC Payment Request Inquiry Page which retrieves results based on the search criteria (combination of delivered & custom fields related to Payment Request) of the Inquiry.
• Researched and applied several PUM’s with the support of Oracle and also created several new SR’s with Oracle in giving them new Issues with delivered processes, coordinated with them on replicating the Issue.
• Analyzed compare reports and Involved in the People Tools upgrade from 8.54.15 to 8.55.09
• Customized the Capitalize checkbox functionality to not default on Requisition page.
• Replicated the Amount Only checkbox functionality (existing in line details) in the Requisition’s line level on the checkout page.
• Customized the Payment Request’s fields to consider negative amounts in the distribution lines.
• Involved in unit testing, functional testing several customizations for USC Enhancements.
• Reverse Retrofitted customizations which were overrode with Oracle Bug fixes back into combination of both delivered and custom functionality.
• Worked on a custom University Dashboard which is a financial management reporting tool that provides the numbers and information to help manage funds from beginning budget to remaining balance along with pre-encumbrance for Sponsored Awards, Internal Projects, Operations and Construction Projects.
• Assisted, coordinated with functional personnel, DBAs in data masking, module specific data clean up, queries & debugging Issues.
• Designed and Developed several other pages, BIP reports and worked extensively on Integration Broker to facilitate third party integrations.

Environment: PeopleSoft Finance 9.2(AM, AP, GL, PO, AR, BI, GM, e-pro), PeopleTools 8.54, Application Designer, Unix, Oracle 11g

Confidential, Woodlands TX

Responsibilities:

• Involved in fit gap analysis of for Peoplesoft Financials Application upgrade from 9.0 to 9.2.
• Involved in converting functional specifications to technical design documents.
• Involved in retrofitting the SQR’s and Application Engine batch process.
• Developed new batch process to accommodate with the Voucher Build process.
• Recreated and upgraded Component Interfaces. Solved related issues in Integration/Testing phase of Upgrade.
• Designed and developed a custom page to aid Suppliers into Self Service Invoicing reading the Dept ID/Project ID and determining the Buyer to meet the client’s needs according to the Vendor profile parameters.
• Created multiple DMS Scripts to transfer required configurations between several test environments and into Production.
• Developed custom tools for conversion to perform translates in sql and feed in to PeopleSoft via custom created Component Interfaces and SQRs.
• Modified Billing Extract process to pull custom information to be populated on the multi BU invoices.
• Worked with integrations between Peoplesoft HR and Peoplesoft Finance. Ensure the integration services are working.
• Developed new BI publisher reports.
• Involved in the testing the objects to ensure the functionality.

Environment: PeopleSoft Finance 9.2(AP, GL, PO, AR, BI), PeopleTools 8.54, SQR, Application Designer, Unix, Oracle 11g

Confidential, St. Louis. MO

Responsibilities:

• Worked on Setup and Configuration of AP, PO, GL modules.
• Developed customizations to Branding and Pagelets in eSupplier.
• Developed customizations to login functionality for the Vendors to login with custom ids and assist with forgot password.
• Configured the Integration Broker integration points in eSupplier from Vendors to portal in ePro
• Participated in the conversion from legacy system (MS4) to PeopleSoft SCM.
• Setting up price for items in Flexible Accounting Model by item, BU and cost book combination.
• Configured PeopleSoft Purchasing with Cost Management to Putaway the items with the price marked on PO and any additional costs on PO.
• Integrated third party customer facing Order system with PeopleSoft for flowing in the orders.
• Integrated home grown system with PeopleSoft to sync the items and attributes to PeopleSoft
• Defined new Contracts with vendors.
• Automated the integration of Billing and AR to record the transactions in AR as soon as payment is processed.
• Involved in setting up the General Ledger to implement the Journal processing.

Environment: PeopleSoft Finance 9.1, PeopleTools 8.53, SQR, Application Designer, Unix, Oracle 11g

Confidential, Houston TX

Responsibilities:

• Involved in maintenance and support activities PeopleSoft Financials.
• Worked on customizations in Travel and Expense which involved AWE.
• Created inbound interface to load the credit card data using file layout and component interface.
• Worked on customizations in Account Payables, Project Costing and Purchasing.
• Developed reports using XML Publisher in e-pro.
• Working on Remedy tickets which include mini and major Enhancements, Defect Fixes.
• Involved in Journal Generating, Editing and Posting of Journals in General Ledger.
• Involved in testing full cycle of Time Report process from Projects to Expenses.
• Involved in integrating third party vendors data to GL module.
• Developed interfaces from PO to Asset Management.
• Extremely involved in debugging of the Expenses and PO workflow routings.
• Involved in developing cash advances and Travel Authorizations in Expenses module.
• Involved in customizing Depreciation in Assets module.
• Involved in modifying custom SQR’s and Nvision reports.
• Involved in setting up of accounting rules for Projects module.
• Involved in defining Row-Level Security, permission lists, security access options, security views in PeopleSoft Financials.
• Developed an Application Engine program in contracts, which loads Client Contracts data for multiple Business Units from flat file via Component Interface. Various data validations are performed using Application Engine People Code for the initial load.
• Assisted functional team with trouble-shooting issues and providing resolutions during preliminary testing and build phase

Environment: PeopleSoft Finance 9.0(GL, AP, PO, e-pro, T&E, PC), Peopletools 8.49, SQR, Application Designer, Unix.

Confidential, Teaneck NJ

Sr. PeopleSoft Consultant/ Advanced BI Publisher Developer

Responsibilities:

• Involved in fit gap analysis of for Peoplesoft Financials Application upgrade from 8.9 to 9.1.
• Involved in converting functional specifications to technical design documents.
• Retrofitting the Peoplesoft objects and SQR’s.
• Implemented new process using Application Engine and File Layout to accommodate with the Peoplesoft tree mover import process.
• Worked with customizations related to the Bank Reconciliation process.
• Worked with vendors and third party systems to ensure the files are received in the new report paths.
• Worked with integration broker to synchronize the data with the other PeopleSoft systems
• Involved in supporting projects module and helping end users in fixing lot of projects related information
• Performed the data analysis and data mapping and designed and documented the conversion /interface /Report documents
• Provided support in solving Problems related to Voucher Posting and Payment Posting (App Engine Processes), AP matching process, GL, Purchasing modules
• Documented and designed the technical specifications for interfaces/data conversion and validation.
• Data cleaning, conversion and importing to PS staging tables from files received from legacy systems using SQR.

Environment: PeopleSoft Finance 9.1(GL, AP, PO, AM, PC), PeopleTools 8.50, SQR, Application Designer, Windows NT, DB2