SUMMARY:

• Over 9 years of experience in PeopleSoft 8.x/9.x Implementation, Development, Upgrades, Customization and Production Support.
• Extensive Experience in PeopleSoft Financials & SCM (GL, AP, AR, AM, BI, PO, OM, eProcurement, Commitment Control).
• Experienced in working with PeopleTools Application Designer, Application Engine, PeopleCode, Process Scheduler, Security, PS/Query Tool and Report Manager, Integration Broker, Configuration Manager, Change Assistant, Workflow, Application Workflow Engine (AWE).
• Experienced in working with Report Generation using SQR, XML Publisher, Crystal Reports, nVision and PS Query.
• Experience using Oracle 12g/11g/10g/9i, MS SQL Server, DB2.
• Experience in Upgrades and new Implementations, Conversions, Migrations, Interfaces and Reporting.
• Working with end users in various roles in order to gather the specifications, develop the application and unit testing before going to production, production support for troubleshooting.
• Key role in installation development, support, troubleshooting, up - gradation, migration, application performance tuning and maintenance.
• Proficient in all phases of the system development lifecycle, including requirements definition, Data Conversion, System Implementation, System Testing and Acceptance.
• Excellent communication skills, Effective team player & Quick learner.

TECHNICAL SKILLS:

ERP packages: PeopleSoft Financials & SCM 9.x/8.x (GL, AP, PO, OM, AR, BI, eProcurement, Commitment Control)

People Tools: 8.5x/8.4x, Application Designer,Application Engine, Tree Manager

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

Debugging Tools: SQL Trace, People Code Debugger, Application Engine Trace

Integration Tools: File Layout, Component Interface, Integration Broker,Application Messaging, Excel to CI

Data Management & Batch Processing Tools: Data Mover, Application Engine, Import Manager and Process Scheduler, Configuration Manager, Change Assistant, PHIRE, Control-M

Administration Tools: Portal Administration, Object Security, Workflow and Query Security

Languages: People Code, SQL, Unix

Operating Systems: Windows 95/98/2K/NT/XP, and DOS, Linux

Databases: Oracle 12g/11g/10g/9i, MS SQL Server, DB2

PROFESSIONAL EXPERIENCE:

Confidential, Troy,MI

Functional Analyst.

Environment: PeopleSoft Financials & SCM 9.2(AP, AR, GL, AM, PO, eProcurement, Treasury), People Tools 8.54, Application Designer, PeopleCode, PS/Query, SQR, Integration Broker n-vision, XML Publisher, Oracle 12g, Windows 7, Linux, Control-M, PLSQL, TOAD.

Responsibilities:

• Resolving day to day issues and troubleshooting batch abends.
• Was part of post implementation support team.
• Created several Queries and modified several reports as per business requirement.
• Served a SME for 1099 processing. Trained users with PeopleSoft 1099 functionality. Created several reports for reconciliation and modified delivered pages to make the process flexible for business users.
• Involved in applying updated PUM images to fix defect with voucher build where the process fails if there are multiple receipts to a single voucher line.
• Resolved several issues with AP MATCH. Reconfigured Document Association rules for 3 way matching to fit the existing business process.
• Setup new match rules/modified existing matching rules to support the existing business process.
• Created a new interface using Application Engine program to create Credit memos for Cardinal.
• Created Excel to CI for Vendor updates and worked on setting up integration broker setups for delivered Excel to CI for Voucher uploads.
• Modified ELITE GL interface which is a SQR program to do inter unit entries.
• Created several reports for users using XML Publisher and PS Query tools.
• Modified XML Publisher check layouts as per business requirement.
• Served as Accounts Payables SME to resolve the day to day business issues by data analysis, analyzing the gaps in the system/business process and coming up with a strategy/plan to fix the issue and prevent it from happening in the future by putting proper code/process controls in place.
• Played a key role in stabilizing PeopleSoft Accounts Payables.

Confidential,ME

Software Development Engineer

Environment: PeopleSoft Financials & SCM 8.8/9.2(AP, GL, AR, BI, AM), People Tools 8.53/8.48/8.46, Application Designer, PeopleCode, PS/Query, SQR, Integration Broker, n-vision, Oracle 11g, Windows 7, Linux, Control-M, PLSQL, TOAD, JIRA, Confluence.

Responsibilities:

• Resolving day to day issues and troubleshooting batch abends.
• Provided 24/7 support on an on-call rotation.
• Developed new sqrs and customized several Application Engine programs as part of implementing payment terms for customer invoicing where Due days decide the due date for the customer payment based on the billing cycle.
• Created new custom pages and developed new Application Engine programs as part of implementing Paper Delivery Fee where a customer gets charged for getting a paper invoice.
• Created custom pages and modified highly complex late fee program as part of late fee increase/suppression. Implemented it with zero defects in a very tight deadline for which I won Kudos award and also received spot bonus.
• Designed and developed Cash Product for WEX. This involved modifying several custom/delivered jobs and pages as per the requirement.
• Played a key role in implementing Cash product. Modified several delivered pages and programs as part of it.
• Fixed several defects by modifying various Application Engine programs and SQRs.
• Was part of PeopleSoft 9.2 Upgrade from 8.8 for GL, AP and AM.
• Developed interfaces for overseas invoices to send out payments through PeopleSoft AP 9.2.
• Customized several ACH layouts which are part of pay cycle manager ACH generation process.
• Involved in implementing the interfaces using Application Engine for integrating Journal data for overseas business.
• Developed several custom pages as per business requirement.
• Fixed several defects of Reactivation Fee where a customer gets charged for reactivating the account after suspension.
• Resolved issues in various systems (plsql/java) where financial data was not reaching the downstream bank database for reporting.
• Fixed various issues that were raised because of the datacenter move from Confidential to Denver with very low turnover time.
• Gathered data for IRS Auditing.

Confidential,San Antonio,TX

PeopleSoft Techno-Functional Consultant.

Environment: PeopleSoft Financials & SCM 9.1/9.2(AP, GL, PO, AR, AM, eProcurement, eSettlement, KK), People Tools 8.52/8.53, Application Designer, PeopleCode, PS/Query, SQR, n-vision, Oracle 11g, Windows 7, Linux.

Responsibilities:

• Monitoring PeopleSoft jobs which are run through Control-M, and troubleshooting the job abends.
• Customized several AE programs which are part of AREF (Automatic Receipt of External Files).
• Implemented AWE for invoice approval which is part of AREF cycle.
• Implemented AWE for e-settlement module where an external vendor can submit an invoice.
• Performed performance tuning for several Application Engine programs and SQRs.
• Customized delivered PeopleSoft pages as per client requirement.
• Supported UAT for the development done by the off-shore team.
• Developed a new functionality which monitors the inbound files coming from vendors and notify business if the vendor file does not come in to the system on time.
• Set up Integration Broker (IB) where a Purchase Order is sent to a newly registered Vendor.
• Interacted with business to resolve the daily issues related to PeopleSoft.
• Customized the department and operating unit excel to CI’s in Asset management (AM) Module.
• Resolved several issues in Asset Management where the Asset Depreciation Reporting table are not loaded and Asset cost showing up in the reports even after the asset was retired.
• Customized the online deposit component in Account Receivables (AR) module as per the user requirements.
• Developed a custom interface which will accept the files from other systems and create the Journal’s into the PeopleSoft Journal ledger(GL) system.

Confidential,Knoxville,TN

PeopleSoft Techno-Functional Consultant.

Environment: PeopleSoft Financials & SCM 9.1/8.8(AP, GL, PO, AR), People Tools 8.52/8.48, Application Designer, PeopleCode, PS/Query, SQR, n-vision, Oracle 11g, Windows XP.

Responsibilities:

• Upgraded PeopleSoft Financials (PO,AP, GL and AR Modules) System from 8.8 to 9.1
• Worked with SYSAUDIT and DDDAUDIT reports in analyzing the data redundancy and identifying the inconsistencies and orphaned objects.
• Worked on retrofitting and reapplying the customizations in 9.1.
• Helped admin in Configuring Change Assistant utility, run scripts and installing product patches.
• Involved in implementing the AWE (Approval Workflow Engine) for requisitions, purchase orders.
• Worked on installing fixes, coding batch scripts and altering peoplecode.
• Redesigned and Implemented PeopleSoft security.
• Involved in retrofitting of various SQRs & Application Engine programs during upgrade from Finance 8.8 to Finance 9.1.
• Customized the delivered Application Engine programs and Pages as per the client requirement.
• Customized workflow for Journal entry approval and voucher approval processes.
• Developed new Workflow functionality for Change Order Approvals.
• Modified existing custom nVision reports.
• Modified and tested various SQR reports like General Ledger activity, Posted Journal summary and Journal entry details.
• Involved in set up of Integration Broker to integrate with vendors for the Direct connect Punch-out functionality in eProcurement for several vendors.
• Developed an Enterprise Integration strategy for integrating HCM and Financial by Setting up the Gateway, Nodes, and Messages using Integration Broker.
• Involved in troubleshooting of Integration broker for integration of data.

Confidential,Rockville,MD

PeopleSoft Techno-Functional Consultant.

Environment: PeopleSoft Financials & SCM 9.1(GL, AP, AR, BI, PO, OM, Inventory, eProcurement) PeopleTools8.50, PS workflow, Oracle 10g, SQR, Crystal Reports, Windows NT&UNIX.

Responsibilities:

• Involved in production support on AP, PO, OM, KK, E-Pro, GL, AR, and BI modules after upgrade to PS 9.1
• Developed interface programs for Accounts Payable to read flat file data and load into payables transaction tables using Application Engine.
• Developed XML Publisher reports for BILLING/Purchasing modules.
• Worked with Billing Interface Application engine process.
• Involved in customizing Account payables App Engine program AP MATCH.
• Involved in solving Account payables issues related to Paycycle Manager (AP APY2015).
• Involved in troubleshooting app engine program PO PO EMAIL.
• Resolved an issue where the Batch Journal Edit process (GL JEDIT) does not create InterUnit Company Entries.
• Changed the code to join PENDING DST to PENDING ITEM instead of GROUP CONTROL in order to increase the performance of ARUPDATE at step AR POSTING.GROUP WK.ED OPITM.
• Resolved a Payment Predictor performance issue at AR PREDICT2.PGEN.UPD PYTI by modifying the do select step to have the full primary key at the join and to set the Reuse flag for the steps.
• Modified PeopleCode so that WAO/WAU VAT Amounts is available in Draft Worksheet of Account Receivables.
• Modified code on the Express Order Notes page so the system displays the Print on Documents check boxes correctly when a custom note type is entered.
• Troubleshooting of Production issues in eProcurement, Purchasing, Account Payable, General Ledger, Commitment Control, workflow.
• Resolved issues in Voucher Posting and Payment Posting (App Engine Processes).
• Developed and customized the various records, pages, menus and reports as per the client functionality using Application Designer.

Confidential,AZ

PeopleSoft Techno-Functional Consultant.

Environment: PeopleSoft Financials & SCM 8.8/9.0, PeopleTools 8.46/8.49, Application Designer, PeopleCode, Application Engine, PS/Query, Application Messaging, Data Mover, Crystal Reports, nVision, SQR, SQL, DB2.

Responsibilities:

• Involved in upgrading from PeopleSoft version from PS 8.8 to PS 9.0
• Worked with SYSAUDIT and DDDAUDIT reports in analyzing the data redundancy and identifying the inconsistencies and orphaned objects.
• Retrofitting and reapplied customizations on Upgraded Oracle 10g database.
• Involved on applying patches and fixes, used change assistant.
• Developed several custom SQR reports, ps queries as per client requirements.
• Wrote technical specifications and unit test plan for new Customizations and Conversions.
• Worked on creating integration test plans for new customizations.
• Developed and customized the records, pages, menus and reports as per the client requirement using Application Designer.
• Involved in the setup of the gateways, message channels and nodes in Integration broker.
• Worked on PeopleCode to publish and subscribe messages using Integration Broker.
• Modified existing workflows (Requisition, PO Invoice, and Non PO Invoice) per client requirements.
• Developed an App Engine Program for loading journals using Excel to CI interface.
• Provided Technical support to a team using PeopleTools & application designer, data migration.

Confidential

PeopleSoft Techno-Functional Consultant.

Environment: PeopleSoft Financials & SCM 9.0(AP, AR, AM, GL, OM, eProcurement and PO modules) PeopleTools8.49, PS workflow, Oracle10g, SQR, Crystal Reports, Windows NT&UNIX.

Responsibilities:

• Implemented and tested PeopleSoft Financials 9.0(AP, AR AM, GL, eProcurement and PO modules).
• Worked on data mapping by identifying all the external source tables and fields and identifying corresponding PeopleSoft tables and fields for our Data Conversion.
• Involved in data conversion to PS9.0 using SQL Loader.
• Developed new AP and Purchasing reports, including; PO-Receipt Report.
• Experience in implementing workflows using AWE (Approval Workflow Engine).
• Experience in generating dynamic approves and reviewers.
• Developed application package for AWE and various classes for AWE user lists and dynamic check criteria.
• Worked on custom Component interface for PO change order.
• Developed specifications for various Inbound/Outbound Interfaces with PeopleSoft Purchasing.
• Performed report Fitgap analysis.
• Used Integration Broker to send a XML document across databases and schemas to synchronize data for members such as personal information, contract data, and dependency data.
• Developed and customized the records, pages, menus and reports as per the client functionality using Application Designer.