SUMMARY:

• Over 8+ years of IT Experience on various aspects of Software Design, Development, Implementation, Validation, Project Coordination, Client Interaction, Troubleshooting, Debugging and testing of software based on a solid formal education and experience.
• Extensive experience in designing, developing and customizing of PeopleSoft Financials, HCM, HRMS and Supply Chain (AR, AP, GL, BI, AM, Project Costing, Contracts, PO, e Pro, INV and OM).
• The PeopleSoft HRMS/HCM involves the following Core modules - Administer Workforce, Recruit Workforce (TAM), HCM Self Service, NA Payroll and Time and Labor, Compensation, Position Management, Benefits Administration, Base Benefits and Portal Applications: eProfile, ePay, eCompensation.
• Extensive experience in data conversion from legacy system to PeopleSoft application database tables using SQR’s, Component Interface, Application Engines & File Layouts.
• Worked extensively with interfaces using Application Engine programs and SQR’s.
• Expertise in writing and tuning SQL’s.
• Experienced in Developing and customizing several reports using XML Publisher, SQR, Crystal and nVision .
• Experience in PeopleSoft Full-Cycle Implementation includes Analysis, Upgrades and Interface Design.
• Reporting, Data Conversion, Configuration, Testing Troubleshooting and Production Support.
• Extensively worked on different Relational Databases like DB2, ORACLE, and MS SQL Server.
• Good knowledge in writing test scripts and doing manual testing.
• Expertise in System, Integration, Regression, Performance, Retrofit and End-to-end testing of the PeopleSoft applications.
• Proficient in gathering and analyzing requirements to successfully design applications based on user needs.
• Hands on Experience with PeopleSoft Financial/SCM Application versions 8.8, 8.9, 9.0, 9.1 and 9.2.
• Extensively worked with PeopleTools such as Application Designer, Integration Broker, Process Scheduler, Application Engine, Component Interfaces, File Layouts, Security Administrator, Tree Manager, and Query tools
• Strong debugging, problem solving, and analytical skills with excellent understanding of system development methodologies, techniques and tools.
• Excellent oral/written communication skills and a good team player.

TECHNICAL SKILLS:

PeopleSoft Applications: PeopleSoft Financials 9.2, 9.1/9.0/8.9/8.8/8.4 x (General Ledger, Accounts Payable, Accounts Receivables, Billing, Asset Management, Purchasing, eProcurement, Order Management, Project Costing, Contracts and Inventory) PeopleSoft CRM 9.0

Operating Systems: MVS, Windows XP/NT/2000/7, Unix

Databases: DB2, Oracle 10g/11g, Microsoft SQL Server 7.0/2000

Languages: SQR, SQL, Peoplecode, COBOL, JCL, PL/SQL, XML/XSLT, HTML, C, C++, UNIX Shell Script

People Tools: Peoplecode, Application Designer, Application Engine, Data Mover, Upgrade Assistant, Change Assistant, Process Scheduler, Security Administrator, Component Interface, Excel to CI, File layouts, Application Messaging, Integration Broker, EDI manager, Workflow, Data Archival

Reporting Tools: XML Publisher (BI Publisher), Crystal Reports, SQR, PS/Query

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Peoplesoft Developer

• Working on a PeopleSoft Upgrade Project from 9 .0 to 9.2 and Tools 8.53 to 8.55.17 which involves writing test scripts, Retrofitting, System Integration testing and UAT for Finance and Supply Chain modules.
• Reapplied customizations and Performed end to end testing for all the below modules through Scripts - Accounts Payables, Bank Data Management, General Ledger, Commitment Control, Project Costing and Procurement and external integrations such as Cayuse, SciQuest and WorkDay.
• Customized login page logos and configured online Open Item Setup for the new environments.
• Created entire suite of Setup Data Mover Scripts and SQL’s required for the Upgraded environment which include Bank Integration Layout, AP Rule Scope & Match Rule Configuration, Grants, Assigning PeopleSoft Users and Match rules, Importing Message Catalogue to target.
• Marked and resolved issues which came up as part of the upgrade and worked with Oracle on applying patches to the new environment.
• Worked on the NYU - Project Lighthouse, an integration of the PeopleSoft system with SciQuest (Jaggaer) P2P application and retiring an existing system, eReq.
• Worked on the vendor conversion data from eReq to PeopleSoft system (FAME) and into the new vendor SciQuest.
• Built the PO, Invoice Export integration where in NYU needs to update PO create process to validate master data, added new codes to PO Export messages.
• The Invoice export integration included the mapping review with SciQuest, added new payment methods and Payment status checks, and also involved in the Supplier Export to make sure the PeopleSoft system receives and acknowledge messages along with updating the supplier data sending the import messages updating ID’s.
• Worked on the Supplier Load reviewing the load template by adding Supplier name, ERP Number, Order Address with PO distribution info.
• Customized several App Class’s in TR FORMAT App Package as per the Users requirement.
• Involved in the testing and issue resolutions of PO Export and Budget date to use the system date versus the accounting date and pass the system date for prior budget years.
• Helped resolve the day-to-day Production Support issues and resolved complicated XML report errors.

Confidential

Peoplesoft Developer

Responsibilities:

• Worked on Estimates and Reapplying customizations for PeopleSoft 9.2 Upgrade
• Reapplied Custom Code on Several Customized Objects. Developed New Application Engine, SQR and People code objects on People Tools 8.54.
• Reapplied Customizations for AP, PO, GL, INV and EXP module and tested the functionality in 9.2.
• Involved in the Technical Upgrade of PeopleSoft FSCM & HRMS applications from 8.9 to 9.2.
• Handling workflow used for mail triggering for concern person when specified action happens in HCM.
• Involved in Configuring the AP implementation.
• Carried out Integration test, System test for Accounts Payable Interfaces and trained Business Users Processing the interface voucher data.
• AP: Configured the Matching Rules for Matching Vouchers with PO's and Receipts.
• AP: Configured the Workflow for Voucher Approvals, Journal Approvals and for Matching Exceptions.
• Developed Workflow in AP for Approval of Vouchers Before they can be Posted and Payments can be generated. The delivered Business Process PROCESS VOUCHERS was customized with a 4 level approval rule set based on dollar amount on the unpaid invoices.
• Worked on the PO and Requisition customizations.
• Created Crystal reports to List all the Open Purchasing Order’s, Purchasing Order Receipts report.
• Developed Department Encumbrances and Department Profit and Loss Reports using nVision and Drill Down Capability.
• Customized the delivered POP0005 XML Publisher Report and App Packages to handle new Custom Fields and terms and conditions on the Purchase Order.
• Did Performance Tuning of Several SQL's for Reports that were running slow in Initial Testing Phase
• Design the Technical specs for Capital Expenditure Report, AM GL Reconciliation report, Aging Report for AR Project Costing CIP Balance Report, Custom Drill down Record for nVision Report, Modified the Billing process interface (CA BI INTFC) not to process un-paid voucher for billing.
• Developed multiple Payroll & Benefits related queries and reports using XML Publisher
• Design the technical specs and develop the code for PO dispatch process (POPO005.sqr) and POXMLP process using the XML Publisher Tool.
• Integration Broker: Configured Local node, remote nodes and setup the services and queues.
• Setup Nodes, Gateway and Service Operations and Tested Connectivity between PeopleSoft and ESB Application

Environment: PeopleSoft FSCM 9.2, People Tools 8.54 (App Designer, Application Engine, PS Query, Integration Broker), BI Publisher, nVision, Connected Queries, PS/Query, Peoplecode, Oracle 11i, UNIX/Windows NT.

Confidential, KY

Peoplesoft Developer

Responsibilities:

• Created Audit files in a XML format that included Invoice information, User Id Information, Expenses Payments File and Vendor Info using XML Publisher.
• Key participant in PeopleSoft FSCM/HCM 9.1 to offer comprehensive solutions to manage client’s business processes requirements.
• Created over 20 management and margin reports for AR/BI/PC/Grants and KK modules .
• Decreased the reporting run time of several major reports from hours to minutes after implementing several performance tuning techniques.
• Worked in customizing the Performance summary Dash-board process (ePerformance) using XML publisher reporting.
• Involved in the Inbound/Outbound integration of Tax data messaging with external Tax software systems.
• Created Custom Interfaces and reports on Recruitment Workforce (TAM).
• Customized the delivered grants invoice SQR process to modify the company logo, the format changes and also fixed the calculation of cumulative amounts by contact number.
• Customized the F&A Components/Pages according to Business Requirements
• Grants Management: Used sponsor ESA tables will be used for initial load of Sponsors from third party interface system.
• Developed New Purchase Order Dispatch BI Publisher Templates, Fixed page Break and formatting issues in Delivered Layout
• Developed new BI publisher Layout for Grants Invoice Templates using Connected Queries. Gathered data from Grants, BI and Contracts Table to get the necessary information to be printed onto the Invoice Layouts
• Set up new nVision report distribution security and organize Report Manager
• Customized Application Package GM FORMS, which takes data from the PeopleSoft tables and generated the XML file.
• Used bottom of the tree nPlosion and style sheets and created Tabular nVision reports for the Tax Department.

Confidential, MD

Responsibilities:

• Involved on a People Tools upgrade for the modules ATS and ALIC from 8.49 to 8.53.
• Extensive experience working in an Agile development environment .
• Worked on a PeopleSoft Upgrade project from Version 8.9 to 9.2 which also involves writing test scripts and System Integration testing and UAT for Finance and Supply Chain modules.
• Worked in close cooperation with project managers and other functional team members to form a team effort in development and upgrade.
• Modified several BI Publisher reports and customized various Application Engines to be compatible to the new Tools version
• Handled production support primarily on the PS Treasury and T& E modules.
• Modif ied treasury wire and bank transfer pages as per the requirements. Debugging SWIFT formatting related issues and updating the PMT DISPATCH app engine related to EFT and bank transfers.
• Also supporting the message subscription peoplecode for bank statement loads and imports. Fixing issues related to automatic and manual bank reconciliation. Support T& E page issues and workflow issues. Worked on the expense report creations, modification and approvals.
• Customized T& E workflow to send e-mails to the submitter after the last approver has approved the expenses. Created app engine to send reminder e-mails to the submitter to submit any pending docs to the pre-pay auditors.
• Written several SQR reports in AR/Billing Module.
• Developed consolidated and Non-Consolidated invoices using XML publisher.
• Expertise in XMLP Bursting Concept.
• Expertise in creating consolidated and Non-Consolidated invoices with Tree-Level data in it using XML Publisher.
• Developed the following reports using Crystal Reports: Billing Invoice register, AP Vendor History by Payment. Used PS Query to create Queries and used the queries as source for the Crystal Layouts. Most of the reports included Groups, Subtotals, and Grand totals on the layout.
• Designed and developed custom Crystal report for Billing using a different Invoice format and new query, which involves creating many sub-reports and sections and groups as well.
• Created Expense reports using SQR’s and modified many complex SQR reports for batch processing.
• Work with Development team for necessary enhancements done, tested and migrated from Development environment to testing environment, tested and got approved as per client needs.
• Added new states and customizations to an existing process, Non Resident Licensing (NRLR) using Application Engines and also created a new application New Non Resident Licensing (NNRL) as per the new norms of NIPR (National Insurance Producer Registry).
• Enhanced the version of the Non-Standard questions and also added a new set for both the NNRL and NRLR applications which included changes to several parts of application engines and application servers.
• Changes to the existing pages and new pages have been added to the application, New HTML areas have been included to the pages for adding the new questions to the application, Once the NNRL and NRLR application have been completed, signed by agent and reviewed and submitted by the License Tech, it was sent in the existing NNRL process to Vertafore for processing through the web service
• Worked with the Oracle Customer Support for the 8.53 tools upgrade to fix various Delivered bugs.
• Lead the project - Web 3.0 Enhancements where in the ATS portal (Geico Careers) has been refreshed using new colors and fonts which had changes to the existing pages, Application Engines, Text ID, java code behind the HTML areas.

Confidential,New York, NY

Peoplesoft Developer

Responsibilities:

• Involved in development, support and analysis for the GL, KK Interfaces along with the AR, AP, PO, Inventory, AM and Billing modules with various Customizations.
• Developed GL and KK reports using XML publisher and SQR.
• Worked closely with end users in identifying functional and technical requirements, implementing solutions for PeopleSoft CRM and FSCM suits. Also participated in several major upgrades: CRM 8.8/9.0/9.1.
• Worked with the Application team on the tools Upgrade 8.50 to 8.52, Customer Relation Management upgrade, and the migration switch to Phire.
• Developed Interface to Load ACH, EFT, Manual and Regular Claim Checks to be Processed by AP Module using SQR
• Developed AP Check Pay Cycle Request by Payment Handling Code and AP Check Printing Page to Switch Printers for Scheduler Every Month End.
• Developed Positive Payee and Payee Positive Files for Confidential of America Accounts
• Developed Reports like AP Check Register, Multi Pay Statements, Interface Error Reports
• Setup Positive Pay and ACH Payments for Confidential and Confidential Accounts. Customized the ACH APY2050 SQR/ SQC Programs for EFT and ACH Payment Formats
• Used XML Publisher (BI Publisher) to build Extra Budgetary Status report for the Donors using Application Engine as a source of XML data and included complicated templates with heavy XML code customization on the template using several grouping and conditional region clauses.
• Created a whole suite of custom reports for the new accounting standards ‘IPSAS’ using SQR’s and BI Publisher, the reports include Resource Overview reports for Fund, Office, Project and Regional.
• Worked on the Budget Associations and Loading Budgets related to Journals into the Commitment Control, created a custom load App engine for the Budget association process to load into the system UN KKLD (KK Tables upload process) .
• Setup Positive Pay and ACH Payments for Confidential and Confidential Accounts. Customized the ACH APY2050 SQR/ SQC Programs for EFT and ACH Payment Formats
• AP to AM interfaces: Tested the AP to AM and PO to AM Interfaces with Transaction Gain and Loss due to Currency Conversions and Discount Payment Terms
• INV/PO: Developed various Inbound and Outbound Interfaces, such as Item Masters, Conversions, vendor Conversion, Sending and Receiving PO’s and Requisitions, Sending Sales Orders, Item Balances Update and Shipment Confirmation Process.
• Working on all Business Processes involved in the Order-to-Cash Data Model, like Creating Sales Orders, Quotes, Buying Agreements, defining Items, customers, fulfilling, shipping, invoicing, Replenishments, RMA, Receiving, put away, Picking, Billing and Creating AR Pending Items Etc., ePro: Setup the integration between several Merchant web sites and People Soft (Punch Out) using Application Messaging.
• Did a modification in eProcurement Catalog Management giving the ability to setup and make the static items available and searchable.
• Modified Purchase order dispatch SQR POPO005.sqr to include logo and other custom fields on the PO.
• Involved in troubleshooting Billing Interface process (BIIF0001) and extensively used SQL to analyze the interface staging tables to correct the errors.
• Customized Bank to Book custom SQR that will capture all deficit accounts.
• Monitoring and support of daily and nightly GL Batch runs (Journal Generator) for the journal processing.
• Running and monitoring monthly accounting procedures for posting Commitments and Fee Rows for all the Country offices associated with UNDP and UNCDF business agencies.
• Customized the GMS pages of the Project Management part of the Grants module, had to customize the setup of the GMS Calculation rate specific to a certain Business Unit for the ‘Earn As You Go’ and a few Distribution Modality specifications.

Environment: PeopleSoft Financials FSCM 9.0 People Tools V.8.52, People Code, SQR, PS Query, File Layout, Application Engine, Oracle 10g, Integration Broker, Shell Scripts, Unix, BENTHIC, Team Track, Control-M, PHIRE.

Confidential, OH

Peoplesoft Developer

Responsibilities:

• Techno-Functional resource for the AP and GL Interfaces and Customizations in AP, AR modules.
• Designed and developed the Application Engine/File Layout Programs conversion program to retrieve the legacy data from the STATS Application
• Designed and Developed the GL interfaces for the Journals generating from the Nursing Applications to insert the data as sub system journals for the Journal Generator programs.
• Worked on Converting Existing Legacy system GL Month End and Year End reports into BI Publisher Layouts. Run control has the Option to Run Report by Fiscal Year, Accounting Period and Tree Name
• Developed Run Control Utility and Standard Functions to have the ability to add Include all, Exclude all Options on Custom Run Control Page
• Developed AR/GL, AP/GL and AM/GL Reconciliation Reports with Drill Down capabilities
• Worked on the performance tuning of Journal Edit, Combo Edit, ADB post and ADB calc by creating indexes, hints and modifying the SQLs in the respective programs
• Modified PO Dispatch SQR program to print Forwarder and Agent details. Also included logic to print digital signatures of approvals defined using workflow on the PO.
• Customized POPO005 Purchase Order Dispatch Process
• Designed and developed the dunning letters PPSFAR06 (30 day’s) and PPSFAR07 (60 day’s dunning) letters as per client requirement’s.
• Developed a new interface using Application Engine to populate the quick voucher tables (PS VCHR HDR QV, PS VCHR LINE QV, PS VCHR PYMNT QV, PS VCHR DIST QV) from the input files, which in turn is used by the voucher build process AP VCHRBLD to create PeopleSoft Vouchers.
• Customized AP MATCHING process to perform Matching validation among receipts, PO and invoices and a Match exception crystal report APY1090 to view the disputed values that are populated after running Matching process.
• Extensively worked on the AR UPDATE to resolve the issue with the Posting of the converted payments.
• Provided the column mappings for the legacy systems to PeopleSoft for the BI Datamart applications to execute the reports in Cognos Systems.
• Assisted SME’s to map the new PeopleSoft system processes with the legacy systems by Fit/Gap analysis.
• Design, development and specification documents for the Expense Analysis reports using XML Publisher and email the blasted reports by department/location to the Department managers and Vice Presidents.
• Formatted INC5500- Inventory Replenishment Report as per the CSR
• Fixed Issues with Incorrect Buyer ID on Purchase Orders after Sourcing From Requisitions
• Design, Development of Asset Roll Forward Report for the Asset Cost data, Depreciation balances by each month

Environment: PeopleSoft FSCM 9.1, PeopleTools 8.50, Application Engine, Peoplecode, SQR, PS Query, Integration Broker, SQL Server 2008, n-vision, Crystal Reports 9