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 InterfaceApplication Messaging/Integration Broker, Business Interlinks, Application Engine, App Packages

Administration Tools: Application Security, User Security, Query security, People Tools, workflowData 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

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

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

Confidential, New York, NY

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

Confidential, New York, NY

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

Confidential, Phoenix, AZ

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 EngineWindows NT, Oracle 10g

Confidential, Hartford

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, 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 EngineWindows NT, Oracle 10g

Confidential

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

Confidential, Salt Lake City

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

Confidential, New Jersey

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

Confidential, Richmond

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