Experience Summary

• More than 11 years of Application Development Maintenance experience in ERP Applications for different industries - Banking, Financial Services, Insurance and Retail.
• Sound functional technical knowledge of Peoplesoft applications Peoplesoft HRMS, Benefits, North American Payroll and Global Payroll and Financials.
• Sound functional technical knowledge of PeopleSoft Financials modules like Purchasing, e-Procurement, Accounts Paybles, Account Receivables, Billing, Expenses, General Ledger, and Treasury.
• Possess good experience on PeopleSoft upgrade for different releases.
• Possess extensive experience in analysis, design, and development of applications built using various versions of PeopleSoft Technologies - 7.5, 8.0, 8.4, 8.8 and 8.9.
• Worked extensively in People tools like PeopleCode, Application designer, Application Engine, Component Interface, SQR, File Layout, Data Mover etc.
• Possess good understanding of Software Development Life Cycle, Business processes and ability to articulate problem from the business perspective.
• Possess Good communication interpersonal skills, Customer Orientation, Cross Cultural Sensitivity and Innovativeness Analytical Skills.
• Worked extensively at client locations in multiple geographies like North America, Europe and Asia.
• Have demonstrated Leadership qualities by playing a key role in driving managing multiple complex projects involving extensive client interaction and onsite-offshore coordination.

Technical Summary

• ERP Packages : PeopleSoft v7.xv8.x HCM
• PeopleSoft HRMS, North American Payroll, Global Payroll, Base Benefits
• and Benefit Administration
• PeopleSoft v7.xv8.x, 9.0 Financials
• Account Payables, Accounts Receivables, Purchasing, Billing, Treasury, Asset
• Management, General Ledger, Travel and Expenses
• Development Tools : People Tools 7.63, 8.19, 8.42, 8.45, 8.48, 8.52. People Code, Application
• Designer Dev utilities, Tree Manager, PS Query, Component Interface,
• Application Messaging/Integration Broker, Business Interlinks, Application
• Engine, App Packages
• Administration Tools : Application Security, User Security, Query security, People Tools, workflow,
• Data Mover, Mass Change
• Reporting Tools : SQR, PS Query, PS nVision, Tree Manager, Crystal Reports.BI Publisher.
• Batch Processing Tools : Process Scheduler, BMC Control M, Autosys.
• Change management Tools: Quest STAT / BMC Remedy.
• Operating Systems : MS DOS, WINDOWS NT, WINDOWS 95/98/00/XP/7/HP UNIX/Solaris.
• RDBMS : SQL SERVER 6.5/7.0, ORACLE 7.1/7.3/8i/9i/10G/11G Toad,WinSql / DB2
• Significant Projects
• Project Description: Upgrade PeopleSoft Finance 8.9 to 9.1, Production Support
• AP , AR , PO , e-Pro ,GL , AM ,PC , EX, BI
• The Bank of New York Mellon Corporation is upgrading its PeopleSoft Financial Supply Chain Management FSCM application suite from version 8.9 to version 9.1, as version 8.9 is no longer supported by the vendor. This upgrade is technical and an attempt to utilize new functionality delivered in the newer release of PeopleSoft, except where doing so would eliminate current customizations.

Confidential

Role : Technical Lead

Responsibilities :

• Involved in studying the compare reports and perform proper retrofitting of FSCM system.
• Involved in assessment work, fit gap analysis and resource planning.
• Involved in designing environment strategy, upgrade methodology, and migration and test strategy.
• Responsible for categorizing the PS objects into RICEW Reports, Interface, Conversion, Enhancements and Workflow objects.
• Involved in comparison between 8.9 demo and Copy of production to analyze the technical environment.
• Involved in analyzing the retrofitting work and retrofitted several objects required.
• Involved in analyzing the existing technical environment FSCM and filter out the unnecessary objects.
• Created Technical Design Specifications for interface, customization, data conversion and reports.
• Unit and Integration Test Plan Preparation prepared Test Plans and Test Cases
• Continuous 24 7 production Support for various modules of the existing system.
• Environment : PeopleSoft Finance 8.9, 9.1People Code, SQR, Application Engine, DB2 8.5

Project Description: Global and Domestic Roll out, Production Support

AP, AR, PO , e-Pro ,GL , AM ,PC , EX, BI

The Bank of New York Mellon BNYM has implemented PeopleSoft Financials PFN ERP Application for its Financial Accounting and the objective of the Global Roll out project is to create a single common GL Account Reconciliation platform supporting the recon process that satisfies the local accounting and control environments in each of the countries while accommodating corporate reporting needs and regulatory concerns. This project was implemented in different phases for continental Europe, UK, Asia and South American countries over the period of 2 years.

Confidential

Role : Technical Lead

Responsibilities :

• Responsible for requirement gathering and solution design.
• Responsible for preparing technical design document ,TDD review, code walkthrough, TDD sign off and formulating the design for interfaces and Conversions.
• Involved in development/enhancement, support, conversion, security and interface design.
• Developed multiple multicurrency GL extracts for different third party applications having Journals posted details for a day and the Ledger extract in required format.
• Developed multiple AP Extracts for multiple countries with details like Voucher and payment for a particular day.
• Developed OFAC extracts for multiple countries based on format required.
• Coordinated development and testing efforts between functional, technical and user groups.
• Developed an Extract for third party application WINNAR for reconciliation between all the AP, Expense payments, Manual transaction entries and the ledger balances.
• Designed and developed the custom app engine program to load the bank details of Global Employees .The bank information comes in the form of flat file and custom programs loads the information in Expense related tables.
• Designed and Developed Custom AP workflow for Vouchers with different origins.
• Worked on Various online enhancements as required.
• Responsible for categorizing the PS objects into RICEW reports, interface, conversion, enhancements and workflow objects.
• Successfully completed all four phases of Global Roll out of PeopelSoft Finance 8.9 for continental European countries like Germany, Italy, Luxembourg, Belgium , UK , Netherland ,Ireland and South Asian countries like Japan , China ,Singapore , Korea , Australia etc.
• Provided production support and functionality enhancements on AP, AM, EX, ePro, PO PC and GL
• Involved in troubleshooting AR UPDATE process, which is used to process and update customer balance and history information, corresponding item information, and item activity.
• Customized the Application Engine AP PAYSELECT so that it picks up the vouchers only after the accounting entries have created.
• Customized AR Payment Predictor Process AR PREDICT2 by Creating New Algorithm Group to handle specific payment situations like partial payments by customer, which is not supported by Peoplesoft
• Setting up and executing payment predictor, applying payments to receivable items, loading lockbox files for bank reconciliation.
• Involved in setting up the delivered Excel to CI utility to load the data into Asset Management staging tables, AP ship to Locations.
• Developed SQR programs to convert customer set up data from legacy system to People Soft in Accounts Receivables.
• Developed Payment Interfaces to load payment data into PeopleSoft Receivables from bank transaction files. Designed and implemented payment-invoice matching algorithms to automate payment matching process in PeopleSoft Receivables.

Environment : PeopleSoft Finance 8.9, People Code, SQR, Application Engine, DB2 8.5

Project Description: Sub ledger Roll out, Production Support

The Bank of New York rolled out its existing PeopleSoft FSCM system for Mellon. The objective was to bring Mellon and BNY system on one platform Financial 8.9 system.

Confidential

Role : Technical Lead

Responsibilities :

• Responsible for requirement gathering and solution design.
• Responsible for preparing technical design document, TDD review, code walkthrough, TDD sign off and formulating the design for interfaces and Conversions.
• Involved in development/enhancement, support, conversion, security and interface design.
• Developed various PO and AP reports for as part of the roll out.
• Developed custom AP application to load the service invoices into AP. The custom App Engine makes use of file layouts to read the data, process and load Voucher staging tables. VCHRBLD loads the AP voucher tables during nightly batch process.
• Modify the Employee Notify App Engine to communicate employees the payment made during the day as well as notify prepay auditors about the expense reports are due for approval by 15 working days .
• Coordinated development and testing efforts between functional, technical and user groups.
• Developed custom AP application to load the service invoices into AP. The custom App Engine makes use of file layouts to read the data, process and create an EDI AP text file which further used by EDI inbound agent to load Voucher staging tables. VCHRBLD loads the AP voucher tables during nightly batch process
• Developed Extract for Abacus, a third party system having GL transactions for the day.
• Modified the custom program having the ledger and ADB balances which is distributed to multiple systems.
• Provided production support and functionality enhancements.
• Managed issue tracking and creating technical and Project documentation.
• Environment : PeopleSoft Finance 8.9, People Code, SQR, Application Engine, DB2 8.2
• Project Description: Production Support and Enhancements, ADM
• A production support, Integration support and Enhancements to the existing PeopleSoft FSCM system consisting of FSCM modules like PO, AP, AR, BI, GL and TR.

Confidential

Role : Technical Lead

Responsibilities :

• Responsible as a primary contact for all production support related issues in FSCM system.
• Handling the urgent production support activities as and when required.
• Worked on several enhancements for Account payables, Account receivables and GL.
• Developed Conversion program using Application Engine and Component Interface for loading open Vouchers from legacy system into People Soft Accounts Payable.
• Written Technical Design Specs for all of the Interfaces and Reports those were customized or newly developed.
• Responsible for requirement gathering, preparing the test cases and coordinating with users.
• Applied lot of Oracle patches and individual fixes as the system was on very low bundle.
• Designed developed a custom SQR program to load billing data from mainframe application in to PeoplSoft billing interface tables.
• Worked on AR DUNNING Application Engine process troubleshooting and fixing.
• Modified POPO005.SQR to get the line and Header comments printed properly. Modified the program to print the Logo and Signatures. Helping user in overcoming issues with PO Build Process.
• Customized AR Aging reports like AR30001, 30002 as per the User Requirements.
• Developed Test scripts for additional processes in PS AR such as Pending Items creation, Receivables update, Deposit Entry and Payment application through worksheets.
• Customized queries inside BIIVCEN.sqr when it's extracting from extract invoice tables before printing crystal reports like BIPRNT00 in Billing.

Environment : PeopleSoft Version 8.8 Finance, People Code, SQR, Application Engine,

Windows NT, Oracle 10g

Project Description: Receipts and Disbursements RAD ADM

A production support, Integration support and Enhancements to the existing PeopleSoft Finance system known as Receipts and Disbursements RAD , a Payment Engines for Claims LOB. It is a component of PeopleSoft's Accounts Payable module which is used to manage vendors,

Vouchers and payments. RAD interfaces with multiple Claims Administration Front Ends as well as downstream financial ledger systems.

Confidential

Role : Technical Lead

Responsibilities :

• Owned and managed a complex project of migration of all Claim Offices supporting a major Line of Business from a decommissioned system to a new Front End which uses RAD as the payment engine.
• Responsible for integration support for various vendors in the new claim processing system.
• Responsible as a primary contact for all Integration related issues in the above project having a very challenging delivery schedule.
• Responsible for Business requirements gathering, analysis and solution design, delegation to onsite and offshore team members, follow-ups and tracking the work requests till closure.
• Responsible for TDD review, code walkthrough, TDD sign off.
• Provided support during System and Integration testing, performance tuning prior to deliverables being moved to production.
• Proactively interacting with the clients and end users to ensure customer delight.
• Facilitating smooth execution of offshore work by mentoring, training and providing the team with required clarifications and resources.
• Provided the critical inputs required for weekly status reports and closely coordinated with the project manager in the generation of project metrics sent to customers and senior management.
• Closely worked with the production support team.

Environment : PeopleSoft Version 8.3 Finance, People Code, SQR, Application Engine,

Windows NT, Oracle 10g

Project Description: Upgrade FSCM 8.4 to 8.9

An upgrade of existing PeopleSoft financial system from Version 8.3 to 8.9. It included an upgrade of all the modules Asset Management, General Ledger, VAT etc also ensuring the Interoperability of existing delivered and customized Interfaces with the new version. This project also involved various enhancements to ensure the smooth migration of existing functionalities to the new version.

Confidential

Role : Technical Lead

Responsibilities :

• Responsible for all development work for this upgrade project.
• Closely interacted with the customer and business analysts during fit-gap analysis between the as-is and to-be systems.
• Was involved in analysis of compare reports and identification of customizations to the existing system.
• Was involved in providing valuable inputs in preparation of the technical design documents for multiple development work and the retrofitting of existing customizations.
• Resolved several challenging issues encountered during the multiple phases of project execution.
• Was accountable for the design and development of several critical deliverables.
• Environment : People soft 8.9, People Tools 8.46, People Code, SQR, Application Engine, Windows NT, Oracle 10g
• Project Description: Production support for Confidential Payroll 8.8, HR and Benefits
• This project involved the production support of applications built on Peoplesoft North American payroll 8.8, HR, Benefits. It included 24 7 production support for all the mission-critical systems. It involved all kinds of technical enhancements analysis and development work on various modules - Payroll, HR and Benefits.

Confidential

Role : Lead Developer

Responsibilities :

• Requirement analysis, solution design and resolution of Production Support issues in Payroll, Benefits HR.
• Worked as a primary contact between the client and offshore in providing 24 7 support.
• Successfully resolved several technical issues encountered in the Production Support and the development of new functionality.
• Accountable for the design and development of some critical deliverables.
• Assigning work to offshore, follow-ups and tracking the work down to closure to ensure
• the adherence to strict SLA.

Environment : People soft 8.9, People Tools 8.46, People Code, SQR, Application Engine, Windows NT, Oracle 10g

Project Description: PeopleSoft Support and Maintenance 8.3

This project was a production support contract of North American payroll, HR and Benefits systems implemented at MMC. The systems used to get multiple feeds from different sources containing data related to earnings and deductions, benefits and HR related information and load them into PeopleSoft system using various interfaces. It covered all aspects of a payroll process from loading earnings and deduction to payroll calculation, tax computation, Benefit calculation and Pay check generation. This project also involved generation of various reports and out bounds.

Confidential

Role : Payroll Lead

Responsibilities :

• Was involved in the Knowledge Acquisition Phase of the engagement journey.
• Successfully trained built a competent team at offshore.
• Was the primary contact for all the Payroll related issues.
• Was responsible for Requirement analysis, solution design and resolution of production support issues in Ben Admin/ Base and Benefits/HR/Payroll.
• Was closely involved in analysis of Tax updates and supported the financial year-end closure of USA operations.
• Was actively involved in the global rollout of PeopleSoft systems to other countries and development of new Interfaces for Global rollouts involving multiple currencies and multiple language support.
• Was Responsible for mentoring delegating the work to the team members.

Environment : People soft 8.3, People Tools 8.16, 07, People Code, SQR, Application Engine, Windows NT, Oracle 9i

This project was an Upgrade of peoplesoft FSCM implemented by Capital One from their current version 8.01 to 8.8. This project involved the complete life cycle of an upgrade process i.e. doing the fit gap analysis, identifying the changes, applying customized Objects manually, support through Test Move to Production and Final Move to Production.

Confidential

Role : Lead Developer

Responsibilities :

• Primary contact for all the development work at the client location.
• Worked on several technical issues encountered and several new enhancements to the new functionality in various modules during Different phases of upgrade.
• Reapply customizations.
• Involved in analyzing and resolving the issues encountered during System testing and Integration testing.
• Involved in extensive interaction with the customer and end users.
• Worked on different interfaces and reports to meet the requirement of the new system.
• Work with the offshore team and help them analyze and fix the issues.
• This project also involved the production support after the project went live during the stabilization process.

Environment : People Tools 8.45, People Tools 8.12, People Code, SQR, Windows NT, Oracle 9i

Worked on HRMS upgrade from 8.01SP1 to 8.8SP1 for Corio India Bangalore. Visa International was the client of Corio. . This also involved modifying several SQRs as per the new release and online changes like records, pages, components and menus, Application Engines, Component Interfaces

Confidential

Role : Developer

Responsibilities :

• Extensively worked on re-applying customizations to all online objects and reports.
• Was involved in preparing tech design documents for all the new enhancement requests.
• Developed New SQR reports and new Interfaces using File Layout/AE/CI.
• Contributed extensively on modifying more than 100 SQR programs, application Engine programs.
• Involved in analyzing and resolving the issues encountered during different phases of the project.

Environment : People Tools 8.43, People Tools 8.12, People Code, SQR, Windows NT, Oracle 8i

Confidential

Worked on HR Benefits, H I for Merrill Lynch at IBM Global Service, Bangalore. Merrill Lynch was a client of IBM. This project Involved the technical enhancements, Investigation and maintenance for the several health and Insurance benefits like Medical, Dental, FSA, Cobra, SLTD etc of all the Merrill Lynch employees while taking care of the contribution by the employees and the company and their benefits. This project involved running the monthly payroll interfaces and various reports and sending the output files to different vendors of Merrill Lynch.

Confidential

Role : Developer

Responsibilities :

• Responsible for the all the technical enhancements, Investigation and development work on the H I Benefits.
• Modification of PeopleSoft Online objects and PeopleCode.
• Developed New SQR reports and modified existing new reports.
• Development of new Interfaces using file layouts/Component Interface/App Engine.

Environment : People Tools 7.62, People Code, SQR, UNIX, Oracle 8i, Payroll Interface

Apart from the highlighted projects I worked on different other relevant projects like Post Release Development for Global Payroll UK for peoplesoft Inc 02/06/2003 30/10/2003 , Global Payroll for Malaysia Country Extension for peoplesoft Inc 10/02/2002- 05/30/2003 , Post Release Development for PeopleSoft North American Payroll for peoplesoft Inc 03/05/2002- 09/25/2002 as a developer.