SUMMARY

• Over 8 years of experience in PeopleSoft, includes gathering user requirements, Systems Analysis, Fit - Gap-Analysis, Design, Implementation, Upgrade, Development, Testing, Production support for Client Server and ERP applications.
• Expertise in People Tools like - Application Designer, Application Engine, People Code, Application Package, Approval Framework (AWE), Data Mover, Process Scheduler, PS Security
• Expertise in PeopleSoft Implementation, Maintenance, Upgrading, Interfacing/Reporting, Troubleshooting and Production support. Good functional Understanding and working experience in Accounts Payable (AP), Purchasing, Accounts Receivable (AR), Billing, General Ledger(GL), Cash Management, Treasury, Projects, eProcurement, Order Management (OM), Manufacturing and Inventory.
• Worked with internal and external teams to analyze, design and implementPeopleSoftERP system. Financialmodules includedGrants, Contracts, Accounts Receivable, Billing, Purchase to Pay.
• Extensively worked with PeopleTools such as Application Designer, Application Engine, PeopleCode, Component Interface, File Layout, Integration Broker and AWE.
• Proficient in development and customization of complex pages using Application Designer.
• Worked with reporting and analyzing tools such as XML Publisher, SQR and Crystal Reports.
• Experience in configuring Integration Broker with third party systems and PeopleSoft systems.
• Configured and Setup Integration Broker for retrieving real time data from the legacy/source systems.
• Participated in all phases of ERP life cycle like Implementation, Conversion, Customization, Development and Production Support.
• Hold good experience in working with reporting tools like PS Query, nVision, BI Publisher, Crystal Reports and SQR.
• Extensively worked on interfaces and conversions from legacy/third party systems to PeopleSoft.
• Worked intensively with to implement Row Level Security, Creating Roles and Permission Lists
• Excellent troubleshooting and problem solving skills.
• Possess good knowledge in RDBMS, Web/Client-Server applications and security.
• Good at Analytical thinking, Testing, troubleshooting, and Error fixing.
• Served as the key point of contact/Liaison between on and offshore resources.
• Team player with excellent interpersonal communication skills and technical documentation skills.

TECHNICAL SKILLS

Application: PeopleSoft Financials v8.8-9.2(AR, AP,AM, GL, Billing, Treasury, PO, Project Costing, Contracts, ePro, Grants, OM, KK, T&E and Inventory)

Development Tools: Application Designer, People Code, Application Engine, Process Scheduler, SQR, Cobol, Data mover Component Interfaces, Application Messaging, Integration Broker.

Administration Tools: Security Administrator, Object Security and PeopleTools Utilities, Data mover

Integration Tools: Integration Broker, File Layout, Application Engine & Component Interface.

Reporting Tools: PS Query, PS/nVision, SQR, Crystal Reports, Xml Publisher, OBIEE

Programming Languages: SQL, PL/SQL, SQR, COBOL, Java, .NET, HTML, JDK, C, C++.

Database: Oracle 9i, 10g/11g, MS SQL Server, MS access, MySQL.

Operating Systems: UNIX, LINUX, Windows 10/9/8/7/XP/2000/NT/98/95.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia

Sr. PeopleSoft Developer

Responsibilities:

• Perform Fit-GAP Analysis of New Features in 9.2, Compare report Analysis, Customization that can be removed due to delivered features in 9.2.
• Responsible for the Upgrade of PeopleSoft 9.0 to 9.2 Tools 8.54.
• Analyzed Compare Reports, Retrofitted Code for 9.2 Upgrade.
• Worked on PeopleSoft upgrade project for modules in Finance 9.0 to 9.2, Applied patches and bundles using PeopleSoft Update Manager PUM images and installed Oracle Secured Enterprise Search database software and configuring it from within 9.2 applications
• Upgraded components/pages and application engine programs like Billing Interface and Payment Predictor and other SQR programs in Billing and Receivables from PeopleSoft v9.0 to 9.2
• Customized Bill Entry pages for pages as per the requirement and incorporated required functionality.
• Developed BI Publisher reports on AR Invoices by billing location, Open Invoices and Credit memos by billing point, open invoices and Open items, AR Balances by State and Country and Customer Activity.
• 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.
• Customized the dunning selection application process (AR DUNNING) to group invoices to the letter code that is appropriate for that invoice instead of age of oldest invoice for the customer.
• Created the custom version of the Aging Detail by Unit (AR30003) and Aging Detail by Summary (AR30003) to sort the items based on customer name.
• Customized the dunning letter BI Publisher templates ARX33000, ARX33001, ARX33002, ARX33003 as per the client requirements.
• CreatednVision Balance Sheet reportsfor new Business Units. Modified and maintainedIncome Statements, Trial Balances and Cash flow statementsfor existing Business Units.
• Involved in setting up of AR to Billing modules.
• Resolved Several Issues that came on DDDAUDIT And SYSAUDIT Reports
• Implemented Work Centers, AWE and BI Publisher Reports in 9.2.
• Involved in the retrofitting of custom PeopleSoft objects from PeopleSoft image 5 to image 23.
• Worked on PeopleSoft image 23 features such as Resource Management keyword search, Approval workflow engine for assignment approval and miscellaneous cash receipts.
• Developed technical specifications based on the Functional requirement document.
• Customized various online pages according to the user needs.
• Implemented Several Custom AWE Workflow Projects and Configured the AWE Process definition, Notification templates.
• Developed several BI Publisher Reports and made use of Bursting to Send Emails of PDF Reports by Department ID.
• Successfully project managed PeopleSoft project for Inventory, Purchasing and Order Management, along with being the module lead for all three modules.
• Resolved Crystal to BI Publisher Conversion of AP Check Printing Process in 9.2
• Participated as a one of the technical Member for the PeopleSoft FSCM 9.0 to 9.2 upgrade project
• Compared new enhancements with current customizations, performed code merged, tested.
• Assisted functional teams with development of test plans and scripts, and respond to all technical issues and queries that arise during the integration testing.
• Applied PeopleSoft patches to fix PS bugs in a reactionary incident bases, making sure all Prerequisites are applied in order and proper documentations are kept.
• Worked with the DBA team and developers, troubleshoot and Performance Tune Conversion scripts and code as required

Environment: PeopleSoft 9.2(GL, AR, AP,OM,SCM, BI, PO,), People Tools (8.54), App Designer, SQR, Windows NT, UNIX and Oracle.

Confidential, Oakland, CA

Sr. PeopleSoft FSCM Techno Functional Consultant

Responsibilities:

• Compare the reports for that are loaded in the ADP with Peoplesoft Worked on a conversion of core legacy mainframe systems into a modern SOA, BPM, portal based solution.
• Handling Business Process Workflows for the PeopleSoft Financials & HR modules (AR, BI, GL, AP, AM, PO, Contracts, PC, Travel and Expense) in a technical capacity.
• Involved in Day-to-day interactions with the Users on the Project Costing, Accounts Receivable, BILLING and Travel & Expenses Development requirements and Change requests.
• Extensively working on Integrating PeopleSoft Financial modules with Third party applications using Integration Broker, Component Interface, and Financial Gateway & Application Engine.
• Debugged and fixed various production issues related to AR UPDATE process (create pending items)
• Fixed Add/Update Receipts page toNOTshow Lot Control and Location Missing flag for items that are not setup under the Business Unit even though it is Inventory Item.
• Designed and Developed interface for loading Asset Management ADDS, TRANSFERS and RETIREMENTS data using application engine and File Layouts.
• Modified the AR customer statement BI Publisher template ARX32000S to calculate the subtotals on the statements by Contract number for Grants team
• Designed and developed interfaces for Accounts Receivable, BILLING to sync data from third party systems using Integration Broker (xml messages).
• Designed and Developed interface programs using Application Engine & EDI Manager for Procurement module to import the external PCard Data.
• Implemented approvals in Procurement using Approval Workflow Engine.
• Created a new Application Engine program UC R CT BLD which creates the Inventory Counting Event and generates Counting sheet UCPRNTCT for a specific Storage Area.
• Created custom Tree structure id and custom Tree and various custom query as the foundation for the various custom Matrix nVision report due to custom tables foundation for the nVision Reports .
• Developed custom nVision Drilldown.
• Customized Add/Update Requisition page under Purchasing and Manage Replenishment Requests pages under Replenish Inventory and modified People Code to generate warning message when a user cancels the requisition or request for any RBC item that has zero On Hand Quantity.
• Designed & configured to route vouchers from Accounts payable clerks to department managers using Approval workflow engine.
• Developed several SFTP Unix Scripts from Windows/NT to UNIX and also Mail-X Commands for the process to send out Emails on UNIX Servers
• Developed nVision reports for multi-currency reporting that were being created manually. Created query and crystal reports used in an initiative for better Cash flow reporting.
• Designed and developed interface programs for Accounts Payable to read flat file data and load into payables transaction tables using Application Engine.
• Designed and development xml publisher reports for BILLING/Purchasing modules.
• Designed and developed interface between General Ledger and Congo’s reporting system using SQR to have the ledger balances.
• Customized the delivered pages for Accounts Payable as per the business requirements.
• Customized delivered pages, Peoplecode to fit the business requirements.
• Extensively worked Application Engine, Component Interface to load the external data into PeopleSoft modules.
• Designed and developed interfaces for AP modules to load the voucher data from third party systems.
• Interacting with users and collecting business requirements for IFRS, USGAAP reporting and prepared functional and technical specification documents.
• Involved in the scrum meeting/calls on daily basis.
• Created Meta data scripts to full data from data base for IFRS and USGAPP reporting.
• Created application engine to full Meta data scripts and store load data into PS custom tables which use to generate YTD balance file on monthly basis.
• Generates the monthly and daily basis files and send it front office load data into Force and LRDW systems.
• Involved in the design of OSB Layer forsalesforce.com (communications with Rabo Bank's PeopleSoft EPM Engine and legacy systems using Oracle OSB 12c.
• Created people soft objects like Components, Pages, Records and fields to automate the Off-Balance assets and liabilities and load Off-Balance assets and liabilities data into monthly balance file.
• Created reconciliation screen to show the difference between ledger and EPM data.
• Created data stage job to interface/full data from PeopleSoft GL into PeopleSoft EPM.
• Supporting the EPM application and fixing the production bugs.

Environment: PeopleSoft Financials 9.2, People Tools 8.53/8.54, Windows NT, UNIX and Oracle.

Confidential, Albany, NY

Sr. PeopleSoft Consultant

Responsibilities:

• Designed and Developed interfaces and conversions for Account payables & Account Receivables using file layout, Application engine and crystal reports.
• Did testing using test scripts provided by the functional team in AR and BI modules in Staging and QC environment, reported technical and functional issues to the Issue Tracking team.
• Developed an interface using Application Engine and Component Interface to convert all open vouchers from legacy system in to PeopleSoft Accounts Payable.
• Merged Put away Plan report (INS3500) and Receipt Delivery Report (NYRECPRNT) so that it should print Put away plan report for Inventory items and Receipt delivery report for Non Inventory Items.
• Converted Reconciliation Report INS5050 to Excel report along with Existing pdf in the Process Monitor Output directory.
• Created Material Transfer Put away Plan report (NYRPRNTPA) which displays the quantity of supplies transferred from warehouse inventory to point of use locations.
• Wrote the functional specification for Vendors Conversion using the delivered Application Engine (VNDR IMPORT).
• Modified the functionality in Order Capture to return multiple order lines in order entry page based on the product configurator.
• Extensively worked on People code with object orientation (Row set, Row, Record, and Field) Familiar with stand-alone row sets in people code.
• Customized PO pages and Modified Purchase Order SQR as per requirements.
• Prepared technical design documents for OM, Purchase Orders & Requisition Contracts for Vendors.
• Modified the Packing Slip - INS6500.SQR not to print the Packing slips that were already printed and added additional functionality of reprint.
• Modified the Picking Plan INS6000.SQR to print the Orders in the sort of Business Unit, Demand Source, Source Business Unit, Order Number, Item ID, Storage Area, Storage levels.
• Prepared migration documentation and coordinated migration to production with DBA, System Support group, Security and Users.

Environment: PeopleSoft Financials 8.8/9.1, People Tools 8.53, Windows NT, UNIX and Oracle.

Confidential, Boston, MA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Review literature articles and process adverse event reports from literature per project Technical Specification guidelines.
• Establishing Object Management Systems using security groups based on Role, User and Job
• Conducting Secessions for Performance Improvement and Reduced risk Processing.
• Co-ordinate and implement changes and PeopleSoft Fin/SCM Applications Changes/Tasks
• Designed component interfaces for EE Matter mapping Page
• Used Integration Broker to integrate and channelize the movement of person feed to Chrome River.
• Code adverse event terms and write narratives according to client’s request.
• Generated XML reports using xml Publisher/BI publisher
• Used People tools 8.51 to develop design and implement project for Mapping page for PeopleSoft and reconciliation files to chrome river application.
• Maintain knowledge & understanding of PPD and client-provided SOPs and current FDA regulations.
• Effectively communicate with project team members, client contacts and adverse event reporters.
• Designed Outbound Process to schedule master files extracts on a daily basis. These master file extracts are used by the agencies to sync-up their systems with SFS.
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft Financials with third party services and publish the employee information from PS Financials to other application.
• Setup and configured purchasing Approval framework.
• Receiving notification customization - Created an application engine program which notifies users if a Purchase Order has not been received for 4,8,12, or 16 days after the due date.
• Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
• Designed and developed a program that loads assets from a comma delimited file into asset interface tables.

Environment: PeopleSoft 9.1(GL, AR, AP,OM,SCM, BI, PO), People Tools (8.51), App Designer, SQR, Windows NT, UNIX and Oracle.

Confidential, Atlanta, GA

Responsibilities:

• Developed technical design documents for Conversion and Interfaces, build Conversion and Interface Programs using people tools.
• Responsible for working closely with management team specialists to ensure that the final system meets or exceeds all current service levels and reporting requirements.
• Developed cross reference tables to map the legacy and PeopleSoft chart field values for conversion of General Ledger data from Legacy System into PeopleSoft system.
• Developed custom Reports for the PeopleSoft Financials using SQR and nVision Reports.
• Modified the existing user queries to improve the performance which are run during the month end close.
• Developed unit test plans as part of the build process.
• Support the users during the month end close.

Environment: PeopleSoft Financials Application 8.8 - PeopleTools 8.47, STAT, Oracle 11, Application Designer, Application Engine, PeopleCode, SQR, File Layout, Data Mover, SQL Developer.

Confidential, Dallas, Texas

PeopleSoft Developer

Responsibilities:

• Re-Designed and Developed 6 core integrations between PeopleSoft Purchasing/eProcurement and IBM Maximo system. I used variety of technologies, mainly People tools in developing these integrations. I worked extensively on getting the data mappings of these interfaces.
• Designed, configured and developed the virtual approval framework for the PeopleSoft v8.8 Procure to Pay (PTP) business processes (Requisitions, Purchasing, Vouchers, Vendors, Journals, Commitment Control) and credit invoices using the custom new business processes, Activities, Approval Rule Sets.
• Modified the functionality in Order Management to disallow change or cancellation on orders if the item on the order is on allocation, reservation or confirmed status.
• Created an Application Engine Program to automatically load Markov put away file (lot balance) every day. Created a Run control page under Items > Block Buster Item Maintenance > Block Buster Item Lot Balance Load navigation.
• Consumed third party webservice to create service operations, nodes and Message schemas.
• Customized Application Engine IN ITMLOAD during item load process.
• Customized the PO Dispatch and Print SQR (POPO005) to print the Ship To comments at the Ship To label, which is used for printing the address. This change is made specifically for customized Ship To’s with just single Ship To address. Also made changes to accommodate the standard Ship To comments for customized single Ship To’s at the Ship To label.