SUMMARY

• Over Twenty Years of functional and Technical experience in PeopleSoft Financial and supply chain Modules. Excellent business process knowledge in PeopleSoft AP, PO, GL, Billing, KK and AR modules. Experienced in Implementing, Upgrading and configuration of Financial and Supply Chain Modules.
• Played an active role as Sr. Business Systems Analyst (BSA) and IT Lead in various PeopleSoft Projects. Lead various PeopleSoft Projects in Tech Lead Capacity and implemented various PeopleSoft Projects.
• Experience in configuring Multi Currency for Multiple Global Business Units and consolidating multiple business units.
• Experience in multiple implementations and life cycle experience for PeopleSoft Financial and SCM configuration with expertise in PeopleSoft General Ledger, Commitment Control, Accounts Payables, Purchasing, Billing, Accounts Receivables, Inventory, and Asset Management including integration with legacy systems.
• Having excellent knowledge and experience in upgradation and Production support of PeopleSoft Applications. Involved in Upgrading PeopleSoft applications at various sites right from release 5.8 through 9.2.
• Performed Fit - Confidential Analysis in Oracle CDM Model for PeopleSoft 9.2 Financials and Supply Chain Application.
• Excellent knowledge and experience in Developing Financial Reports using PeopleSoft nVision along with excellent Technical and Functional Expertise in Systems Analysis, Design/ Development & Implementation.

TECHNICAL SKILLS

ERP: PeopleSoft 8.0/8.4/8.9/9.0/9.2 Financial & Supply Chain Management and HRMS Modules.

PeopleSoft Toolset: PeopleTools, SQR, Crystal Reports, Application Engine, People Code, Workflow, Query Mgr, Tree Manager, PeopleSoft Security, App Messaging, Integration Broker, Component Interface, Process Scheduler

Databases: Oracle 10g, SQLServer2005, MS SQL Server2000, DB/2UDB, Sybase, Informix and Microsoft Access

Technologies: PeopleSoft FSCM, PeopleSoft HRMS, Accelio Present Central and Web Applications, Right fax, Kofax, Fortis, Business Objects, Maestro and Endeavor in Mainframe, Vertex

Testing Tools: Rational QTP, IBM Quick Place, Rational Clear Quest

Languages: COBOL, JCL, SQL, Pro*C, JavaScript 1.2, Shell Scripting, HTML and TCL

Software: SQR, Crystal Reports, nVision, MS-Office, Visio

Version Controls: Microsoft SourceSafe, JCVS, Rational ClearCase, Quest STAT, IBM Endevor

Operating Systems: Windows NT, Windows 2003 server\Windows 95\98\2000\Windows NT\XP, IBM 3090, OS/390, UNIX and DOS

Project Management: MS Projects 2002, Enterprise Development Portal (EDP)

Communications: CICS, TSO/ISPF, CMS, Microsoft Exchange Server, Lotus Notes/IM

Industries: Automotive, Financial Services, Insurance, Real Estate, Health Care, Energy, Entertainment, Software Development and Transportation.

System Development: Business Interviewing & Requirements Capturing, System Design, Upgrade, Development, Testing, Implementation, Documentation and User Training

PROFESSIONAL EXPERIENCE

Confidential, Michigan

Sr. ERP Functional Analyst

Responsibilities:

• Primarily responsible and point of contact for business support of Financials and Supply Chain Modules.
• Responsible for Performing Functional Fit- Confidential Analysis, Testing of Retrofit objects, coordinated with users for UAT testing during upgrade of PeopleSoft from release 9 thru 9.2 and applying PUM images up to image 16.
• Created and modified various nVision reports for the month ending reporting purpose. Modified nVisions to dynamically pull the accounting balances from the trees for multiple business units.
• Assisted business users in GL Consolidation process and resolved various issues related to General Ledger consolidation process.
• Modified nVision reports to dynamically pull the data from Trees and created necessary scopes and drilldown capabilities and created layouts and assisted users
• Reconfigured the voucher invoice processing setup to avoid duplication of vouchers and its payments in PeopleSoft Accounts Payable modules.
• Provided various Adhoc queries to PeopleSoft AP and AR user groups to run the queries and their reports on adhoc-basis. Implemented 1099 Mechanism for Financial Users.
• Functional Lead for upgrade of PeopleSoft FSCM modules from release 8.8 thru 9.2
• Assisted Merkur Team in providing necessary queries and assisted users in training, configuring, testing, implementing Automatic remittance advices using Merkur in AP module.
• Implemented Vertex Taxware for computing accurate Use Tax and Sales Tax using integration with PeopleSoft Modules.
• Created preliminary queries, Process flow documents as a part of preparation and assisted users in testing, configuring, implementing new changes in production for PeopleSoft Power Plant Integration into Financial Systems.
• Financial Lead for upgrade of Powerplant integrating with PeopleSoft GL Modules.
• Configured vertex on Billing modules in Test Environments and performed QA activities and modified Billing invoices and queries and assisted users.
• Implemented PeopleSoft functionality related to override exceptions to force reconciles bank statements.
• Demonstrated PeopleSoft process flow for consolidation of GL books & GL allocation process in IT group. Prepared various configuration documents and training documents for AP, Billing & GL modules. Implemented vendor archival process for Accounts Payable modules.
• Implemented ACH Payment processing across all business units in Accounts Payable modules.
• Implemented PNC Active Pay Project that enables the Accounts Payable module to process payments through EFT and enabled the Bank Reconciliation Process.
• Created an automated process to load the sales tax and use taxes from external spreadsheet to PeopleSoft Sales tax and Use Tax Tables.
• Resolved issues and assisted Accounts Payable Department in resolving various production related issues related to FORTIS (Document Management System).
• Demonstrated to implement recurring vouchers through Purchase contracts module and Accounts Payable modules.
• Prepared integration documents and process flow documents between PeopleSoft GL modules and Power plant modules as a part of preparation for BPR for PeopleSoft and Power Plant integration.
• Standardized payment advices for multiple payment methods such as wires/ACH/EFT and enabled automatic default of business units in the payment advices in Accounts Payable Module.
• Enabled automatic default ship to locations by configuring ship to locations at the control setup to enable default ship to locations in voucher processing.
• Provided Accounts Payable department, various reports to validate the integrity between AP open Liability balances and GL balances. Created ITC custom AR Statements and Dunning letters and scheduled these processes for every month.
• Identified historic vouchers that are with wrong posting status and corrected them appropriately to be in sync with sub ledger entries.
• Modified Trail Balance Report in nVision to pull the GL balances dynamically from the multiple business units.
• Performed various test matrices and test cases during implementation of PeopleSoft EFT, ACH, Wire payment processing mechanism. Configured new business units in AP and GL modules to enable the transaction flow between AP and GL modules.
• Implemented XML publisher report for Invoices with accounts balances for the specific period in Billing Modules.
• Performed unit/integration testing between AP & Fortis Approve it system used for invoice approval. Assisted AP users in implementing ERS vouchers in Accounts payable module.
• Configured and setup new FSA bank accounts to enable the treasury and Accounts Payable to process the FSA payments through PeopleSoft delivered payment process.
• Created new control report queries to help AP group to close their monthly books without much manual exercise.

Confidential

Sr. Functional Financial Analyst

Responsibilities:

• Primary responsibility is to analyze IT monthly budgets periodically for the corporate IT department.
• Implemented Canadian EFT payment mechanism for Canadian Business Unit of Confidential Inc.
• Trained users in Australia in the functional capacity after implementing AP for Australia Business units. Prepared training documents in EFT mechanism in PeopleSoft, Payment Processing Mechanism, Bank Reconciliation statements in PeopleSoft AP and Treasury Modules.
• Prepared the conversion strategy document on converting legacy assets of Australian Assets into PeopleSoft AM modules.
• Resolved various issues related to converting Australian assets into corp books, Tax books and financial books. Created various tabular and matrix nVision layouts and modified the existing nVision layouts to pull the account balances from the trees in the dynamic form and enabled the effective performance of reports during run time.
• Involved in the implementation of AR, BI system for China Business Units. Study involves review of existing accounting practice for BI and AR module in China business unit and develop the consolidation strategy to consolidate the revenue recognition into US business units. This involves critical understanding of Chinese business processes and their country tax structures and accordingly to set up the business units and charts of calendars and processing controls for centralized recording and controlling purpose through PeopleSoft AR and BI modules.
• Implemented year end closing processing in GL by creating various time spans and calendars and defined year end closing rules to process the WIP accounting netted to the appropriate buckets for the period 998 for 2009 closing.
• Involved in implementing the Global consolidation process by defining the proper netting mechanism and creating various elimination rules for PeopleSoft consolidation process in GL modules.

Confidential, MI

Lead Techno/Functional Analyst

Responsibilities:

• Actively involved in the Technical Team in Upgrading PeopleSoft from release 8.8 to Release 9.
• Responsible for analyzing Technical Fit Confidential Analysis and actively involved in retrofitting various
• Resolved various issues in cash applications to the items in the Accounts Receivable Modules.
• Helped users in resolving issues with Payment Predictor setup for cash applications in A/R modules.
• Configured General Ledger, Billing and Accounts Receivable modules as per the new requirement to enable the Billing System to load the items into AR modules for subsequent posting of through AR update process.
• Developed new object and new pages and enforced new PeopleCode for new ACH payment details information in Accounts Payable Module.
• Created a process for effective receivable collection by generating weekly nVision reports for business partners.

Confidential, Westborough, MA

Sr. Techno/Functional Consultant

Responsibilities:

• Responsible for PeopleSoft Production support and Upgrade of Financials and Supply chain modules. Led PeopleSoft upgrade project to release 8.9 and retrofitted various PeopleSoft objects and SQR programs
• Involved in PeopleSoft upgrade from 8.4 thru 8.9 and responsible for retrofitting customizations in PeopleSoft Objects in PeopleSoft Accounts Payable, General Ledger, Billing, A/R and Purchasing Modules. Developed various reports using nVision tabular and Matrix Layouts to drill down GL balances to the AP/AR sub ledgers.
• Suggested implementation approach for printing correct AP checks due to the bank change of business units.
• Responsible for determining the business requirements as per the existing rules in eProcurement for Workflow in release 8.4 and Implemented workflow mechanism for new release of PeopleSoft 8.9
• Created critical queries that will be used as a preventive manner to resolve data integrity issues related to EDI vouchers.

Confidential, OH

PeopleSoft Functional Lead/Business System Analyst

Responsibilities:

• Primary Responsibilities include study of existing business processes in highly customized PeopleSoft AR and Billing Modules and conduct impact analysis on existing customized systems and Processes with the introduction of new customer types and new health care products in their financial system.
• Responsible for setting up of control set up information that include new chart of accounts, Calendars to process the year end financial statements. Ran various reports for business users for financial year closing using time spans and calendars.
• Responsible for documenting the functional and technical requirements associated with the introduction of new product line and customer segment in GL, Billing and AR modules.
• Responsible for preparing various SOX related Documents such daily Test Matrix, Traceability Matrix, and Logging the defects in Defect Matrix that are required for Change Approval Board before approving the Change Requests. Responsible for configuration, coding and retrofitting the new functionality into the existing customized interfaces and business processes.

Confidential, OH

Sr. Techno/Functional Consultant

Responsibilities:

• Primarily responsible for Production Support of PeopleSoft Financials and Supply Chain Modules such as Purchasing and Inventory/Accounts Payable and GL.
• Responsible for maintaining various third party interfaces into PeopleSoft. Third Party interfaces include PeopleSoft HRMS, BAAN, ARIBA and I2.
• Resolved critical issues in the interfaces between PeopleSoft HRMS Modules and GL.
• Responsible for capturing HRMS data from third party vendors, integrating with PeopleSoft HRMS and General Ledger Modules. Customized the projects module to include a rate table when determining project costing.
• Implemented PeopleSoft commitment Control Modules. Resolved various data related issues in Commitment Control and Purchasing modules. Coordinated with users in QA Testing process and instrumental in bringing these fixes into Production Environment.
• Configured Mutli currency setup, setting up of currency codes and involved in trouble shooting during conversion,revaluation of multicurrency operations.
• Responsible to fix various process related issues in Requisition Loading, PO Sourcing, Budget Check, Depletion, GL Posting and Put away processes.

Confidential, FL

Sr. PeopleSoft Analyst

Responsibilities:

• Primarily responsible for maintaining and Implementing PeopleSoft GL, PO and AP modules Responsible for implementing new enhancements and fixing issues in PeopleSoft GL Accounts Payable Modules.
• Responsible for upgrading the PeopleSoft applications from release 8.45 to 8.8 in both Financials and Supply Chain Modules. Played a key role in completing upgrade tasks and retrofitting customizations.
• Point of contact between functional users and upgrade team during user acceptance testing and assisted users in completing UAT. Implemented various tree structures in PeopleSoft to accommodate the organizational changes and business rules.
• Resolved various production related issues and prevented them from further occurrences in PeopleSoft Financials modules.
• Assisted users in customizing their own pages for effective journal entry data processing using new functionality of PeopleSoft 8.8.
• Responsible for implementing projects and fixes as per the change management controls defined by SOX procedures.

Confidential, MI

Team Lead

Responsibilities:

• Primary point of contact and Team Lead for PeopleSoft and other financial applications.
• Primarily responsible for fixing issues related with production, applying patches, adhoc reports and PeopleSoft projects.
• Customized nVision report books based on the new business unit additions in PeopleSoft system. Primarily responsible for upgrade of PeopleSoft module for its tools version from PeopleTools 7.59 to 7.6. Ran all the Upgrade steps as a part of upgrade process and reapplied customizations to the 7.52 database.
• Responsible for assessing Hardware and Software requirements, creating the Fit/ Confidential analysis, coordinating with technical support team in the decision making process of selecting the right kind of new hardware and software, preparation of Project Plan for the PeopleSoft upgrade from 7.52 to 8.
• Implemented P-Card functionality by customizing PeopleSoft Application and integrated its transactions thru Peoplesoft Accounts Payable Module.
• Conducted impact analysis on PeopleSoft 7.52 due to DB2 version change and modified affected programs and SQRs to accommodate DB2 new release.
• Responsible for preparation of Upgrade plan PeopleSoft release 8 and configuration of the systems.
• Implemented the PeopleSoft automatic journal approval mechanism using workflow in the client’s financial services department. As a part of this project, I have modified the delivered PeopleSoft Journal approval business process and implemented new approval rules and communication mechanism that are required as a part of this project.
• Having rich experience in developing nVision reports. Implemented various matrix layouts, which are required to run new nVision reports.
• Implemented the screening mechanism before making payments to Specially Designated Nationals as defined by the Office of Foreign Assets Control. For this project, I have customized PeopleSoft Paycycle manager and checks are produced after being scanned through the SDN database.

Confidential, CA

Programmer/Analyst

Responsibilities:

• Involved in upgrading PeopleSoft queries from Version 5.0 to 7.51. Also, responsible for modifying the PeopleSoft queries and test them and move them into Production region.
• Fine-tuned various customized PeopleSoft queries as to improve the performance. I have created various Crystal Reports for the PeopleSoft HRMS module.
• Involved in preparation of test plan, test cases and launch plan and to coordinate with the release team for smooth production release.

Confidential, San Mateo, CA

Programmer/Analyst

Responsibilities:

• Worked as Systems Analyst in its Corporate IT Department and looking after Production support and development related issues in People Soft Finance Modules such as General Ledger, Accounts Payable, Accounts Receivables and Billing.
• Involved in Development, Testing and Customization of Aging Reports by tree in Accounts Receivables Module and to ensure that they are in sync with the Aging Reports by Business Unit. Worked extensively on AR, Billing and AP modules. Duties include developing and documenting a conversion strategy and determining the tools and approaches used for data conversion.
• Technical launch lead for PeopleSoft Asset Management and Project Costing modules
• Created Asset Management to Project Costing interface programs, to extract asset data from PeopleSoft Asset Management and transferring basic asset information, depreciation, Net Book Value and Asset Acquisition details to Project Costing Module.
• Involved in configuring and implementation of Accounts Payable Module for their new Business Units in Europe.
• Involved in configuring currency codes, currency conversion codes for the new business units to enable the transactions to report in the base currency and actively participated in supporting processes related to revaluations to ensure that the realized gains and losses are posted to appropriate accounts in General Ledger.
• Responsible for debugging issues related with multi currency operations in AP and GL modules.
• Worked on issues related with tying of Sub Ledger Balances with General Ledger for their year ending reports.

Confidential, CA

Technical Consultant

Responsibilities:

• Implemented various SQRs in HRMS/ Payroll/ Benefits modules 7.5. I was Involved in the modification of existing panels, Various PeopleSoft objects, Reports, creation of queries, views and interfaces processes to suit the business requirements of the client.
• Implemented Revenue Accounting Systems in PeopleSoft Financials using Project Costing, Billing, AR, and AP applications, that has interfacing with web based application called Voyager and Main Frame application.
• Involved in analysis of business and technical processes of Revenue Accounting System against PeopleSoft financial modules such as Projects, Billing and Receivables and customized various interface reports.