Computer Expertise:

US Citizen having over 8 Years years of extensive experience in design, implementation,testing and upgradation of various Oracle based systems. Over 6 + years of experience in ERP PeopleSoft Applications using Web based and Client/Server applications with strong business understanding knowledge of PeopleSoft Finance and Supply Chain modules (AP, PO,EPRO,CM AR, BI, GL, TE, AM and Invenotry). Key expertise includes testing and debugging GUI and Multi-Applications environment and automated testing using HP Quality centre (Application Life Cycle Management), Quality Center and Quick Test Pro. Excellent verbal and written communications skills and the ability to develop a systemic approach to facilitate the completion of deliverables within timeline and budget. Excellent technical and functional knowledge in PeopleSoft wherein working on the customization and migration. Expertise with People Tools like Development tools, Administration tools and Reporting tools.

Excellent working knowledge of the PeopleSoft Internet Architecture and the flow of data exchange between various FSCM modules.

In-depth proficiency of functional and technical knowledge, in addition to Design, Development, Implementation, Upgrade, Customization, Testing and Support experience in PeopleSoft AR, AP, PO, GL, BI, EPROC and AM.

Experience in creating test plan, test script and testing execution.

Extensively worked on AR, GL and Billing modules and interfacing between the modules.

Extensively worked on HP ALM,Mercury Tools.

Worked with Quality Center, WinRunner, QuickTest Professional and LoadRunner.

Proficient in developing custom pages and tables using Application Designer and PeopleCode

Excellent working knowledge and experience using reporting tools such as Crystal Reports, SQR.

Proficient in Module Development, Interfaces, Conversion, Data Migration and Report Writing

Well versed in writing and calling procedures within the PeopleCode events.

Worked with Panels, Components, Menus, Business Process Maps and Workflow.

Extensive experience in transferring existing data from legacy systems to People Soft application database tables using SQR and Application Engine.

Hands-on experience working with the PIA architecture, Application Engine, Application Message, Component Interface, Business Interlinks and Batch Processes.

Reputed Knowledge in creating specifications, project schedules, analyzing the upgrade process to re-customize and reapply the customizations, supervising design activities and interfacing with customers for successful completion of project.

Technically proficient in performing User/Security administration, interfacing and report writing using SQR, Crystal Reports and nVision.

Strong skills in Back end testing using SQL Queries on Database tables.

Possess excellent communication skills and good zeal in adapting to new technologies.

Skill Summary:

ERP Applications: PeopleSoft 9.1/9.0/8.9/8.8/8.4/7.5/7.0(Campus Solutions, Purchasing, Benefits, Student Admin, EPROCUREMENT,CM(CONTRACT MANAGEMENT),GL, AP, AR, Project Costing, AM, PO, Billing, Grants, Customer Contracts, Commitment Control, Inventory, Pay Roll, Time and Labour, Travel & Expenses and OM modules)

People Tools: Application Designer, Application Engine, People Code, Maintain Security, Security Administrator, Object security, Process Scheduler, File Layout, Component Interface, Application Messaging,Tree Manager,Integration Broker, Import Manager, Application Reviewer, Data Mover, Application Upgrader.
Testing Tools: Quick Test Pro, Load runner, Win runner

Test management tools: HP ALM(Application Life Cycle Management),Quality Center 9 .2, Test director

Database: MS SQL Server, Oracle 11g/10.g/9.i DB2, SYBASE and MS Access/Sharepoint 2007.

Operating Systems: HP-UNIX, MVS, MS DOS, Windows, 98/NT/2000/XP/Vista/7.

Reporting Tools: SQR, Crystal Reports,nVision.

Languages: SQL, PL/SQL, Shell Script, C, C++.

Professional Experience:

Client: Confidential,St.Louis,MO Nov\'11 – till date

Project: Testing and executing reconciliation routines to quickly verify data accuracy and provide end user reports
Role: PeopleSoft Functional Consultant

Environment: PeopleSoft Supply Chain eProc/PO, Inventory and Supplier Contract Management, Oracle,SQL, Windows XP, HP Application Life Cycle Management 11.0

• Automated all the Purchasing processes such as Requisitions and Purchase Orders to test the functionality of each process as well as to do regression testing.
• Designed and Documented Test Scripts in accordance with the Business Requirements Documents and the Functional Requirements Specification documents.
• Responsible for creating test cases and test plans to test all possible cases based on Test Scenarios
• Created Test Files for the test scripts based on Techncial Requirements Specification documents.
• Interact with Functional and Technical Team to resolve issues & conflicts as needed.
• Done Negative Testing by entering the wrong data in test files according to the requirements.
• Involved in testing PO, ePro,Supplier Contracts and Inventory modules.
• Created Data sheets for the test scripts which helps to do testing and for further use.
• Done Backend Testing by using SQL.
• Developed Test plans, Test cases and create test data and executed in HP ALM 11.0 for ePro,PO,Inv,CM
• Participated as a key member with the Team for Regression testing where day-to-day bugs were monitored.
• Co-Ordinate with the development team and the Project Managers in fixing bugs in the system.
• Involved in the testing eprocurement functionality from creating requistions to create PO based on requistion.
• Worked with user community during the month end closures.
• Generated detailed reports of the Bugs, Pass-Fail report and Comparison Chart.
• Involved in analyzing the requirements and finalizing the scope of the testing process.
• Walk through with business user, TBA and development team.
• Collaborated with appropriate team leaders to ensure quality of test deliverables & timely completion of individual test plans.
• Contributed in regular status meetings to state any bugs, problems and risks.
• Worked mostly on critical defects.

Client: Confidential,Dover, DE Mar\'10 – Oct’11

Project: New implementation project of FSCM modules and support the production system of 9.1 Application
Role: PeopleSoft Subject Matter Expert

Environment: PeopleSoft Financial 9.1 AP, GL, eProc/PO, Commitment Control and AM, Project costing, PeopleTools 8.48, SQR, PeopleCode, Application Engine, nVision, Toad, STAT, Oracle, Windows XP, Quality Center 9.2

• Involved in analyzing the requirements and finalizing the scope of the FSCM module process.
• Responsible for creating test cases and test plans to test all possible corners of the system
• Involved in creating Design documents for GL, AP, AR, PO, AM, Project costing and ePro modules.
• Configured Vendors, entering vouchers, processing payments.
• Involved in testing Batch voucher processing/new interfaces in AP module.
• Conduct meeting with end users, developers, managers and discuss the test requirements, strategies, plans and outcomes.
• Work on testing the Journal approval workflow with multiple roles and users in PeopleSoft GL module.
• Involve in testing of GL Background processes GL_LED_IMP and GL_JRNL_IMP.
• Worked extensively on Back end testing using tools like Toad and Query Analyzer.
• Used Quality Center extensively to Plan, Monitor and maintain the testing process.
• Automated all the Purchasing processes such as Requisitions and Purchase Orders to test the functionality of each process as well as to do regression testing.
• Co-Ordinate with the development team and the Project Managers in fixing bugs in the system.
• Working with Site Administrator for Quality Center as well as single point contact for all the mercury tools
• Created Traceability Matrix to check that all business requirements were met.
• Worked with clients to finalize testing process and customized lists and user groups.
• Trained Developers, testers and PMs.
• Created Manuals for Business users.
• Working with developer and DBAs to migrate objects to different environments
• Involved in creating the Test Suits for End-to-End system testing for USA Implementation of FSCM 9.0
• Involved in testing of complete end –to end scenarios for General Ledger, Payables, Asset Management, Billing, Accounts Receivables

Client: Confidential,Southfield, MI Mar\'09 – Feb\'10

Project: Led business applications development providing services to designing and implementation of Financial System.
Role: PeopleSoft Functional Consultant.

Environment: PeopleSoft FCM 8.4/8.9(AR, AP, PO, OM, ePro, SCM, GL, BI, T&E and AM), People Tools8.47, Quality Center, WinRunner, QuickTest Professional and LoadRunner ,People Code, Application Engine, Component Interface, SQR, Integration Broker, Crystal reports 9.2.3, nVision,

Responsibilities:-

Created test scripts for Billing Interface Errors.

Gathered requirements to customize several SQR reports like AP/GL Reconciliation report, Excel Journals for Upload etc.

Involved in integrating between Financials and HRMS. Designed and Developed Message channels, Message nodes and Messages for Account Codes, Vendors.

Designed Purchasing Interface using File Layout, Application Engine, and Component Interface, which loads data from flat file into staging tables while doing various data validations using AE PeopleCode and finally loads into PeopleSoft tables through Component Interface.

Customized PeopleSoft delivered Crystal reports in Payables like Vendor Detail, Vendor Summary, Closed Voucher, APY1010 – Voucher Register, APY1010A - Posted Voucher Register, APY1040 - Open Voucher Report, APY2015 - Check Register.

Involved in integration testing and system testing. Developed Testing Scenarios. Troubleshooted and fixed bugs and errors as per client requirement after applying patches and bundles.

Involved in the testing eprocurement functionality from creating requistions to create PO baased on requistion.

Tested GL Interface that loads data from a flat file into PeopleSoft General Ledger using SQR, which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level, grand totals, error handling procedures, printing multiple output reports and processed file report. Used various SQR functions, Arrays, Load Lookup & SQC.

Worked exclusively on the Account Receivables Part of the business units.

Client: Confidential,Chicago, IL Mar\'08 – Feb\'09

Project: Involved in the Conversion, Implementation and Customisation of PeopleSoft Applications.
Role: Functional Functional Consultant.

Modules: General Ledger, Project Costing, Billing, Contracts,purchasing,e-procurement, Accounts Payable and Accounts Receivable

Environment: PeopleSoft FSCM v 8.8 Implementation (AR, AP, PO, GL, ePro, T&E BI, OM and AM), People Tools8.47, People Code, Application Engine, Component Interface, SQR, Integration Broker, Crystal reports 9.2.3, nVision, Oracle 9i, Quality Center, WinRunner, LoadRunner, SQL Server 2005, UNIX .

Responsibilities:

• Involved in the testing of new records, Pages, Components and menus. Customized and created record definitions, designed new page to display additional information and used People Code to incorporate validation rules according to the specifications.
• Worked with Open Interfaces in all Financial Modules and also used standard Oracle APIs for Interfaces and conversion procedures. Developed Interface Programs for data transfer between modules OM , AR.
• Worked extensively with the AR_UPDATE (Receivable Update Process) and AR_AGING (Aging Process).
• Tested Implemented PeopleSoft Financials with E-bill & Credit Card functionality for AR.
• Worked on eprocurement total module functionality testing which includes creating requisitions and requisition workflow.
• Applied Payments to items using the Payment Predictor process (AR_PREDCT) which automatically applies payments.
• Worked with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, Pay Cycle, AP Processing, AP Interfaces, Refund Processing, AP Reports and AP Security.
• Tested GL interface that loads data from various external systems into PeopleSoft General Ledger using SQR process, while implementing combo rules and checking invalid Chart field combinations, Subtotals on Business Unit Level, grand totals, Error Handling Procedures and Printing Multiple output Reports.
• Involved in defining System and Profile options. Implemented Auto receipts, Auto cash rules, Tax methods, and Auto Invoice and Auto Accounting methods. Set up Lock Box transmission system and Imported Receipts into AR using Auto Lock Box.

• Creating new report Customer Credit Reference Details including Customer Name, address and Credit amounts and also will give Aging Category and Payment History details on As of Date.
• Involved in testing of Application Engine Programs like
  AR_CASHCNTL, AR_OVRDUE & AR_UPDATE in Account Receivable.
• Resolved the issue of caused by the conversion of AR Direct Journals which caused budget error by updating the SQL in the App Engine.
• Worked on Process Scheduler to create various process definitions and attached these processes to the pages.
• Unit Testing and Integration Testing the Interfaces and Processes and created the Test Scripts

Client: Confidential,Indianapolis, IN Feb\'07 – Feb\'08

Project: Family and Social Security Administration. Extensively involved in full life cycle and the Implementation, Customisation, Data Conversion and Report generation, upgrading, Distribution of DATA to FSSA mainly using GL, AP, PC & AR modules in Peoplesoft Financials.

Role: Peoplesoft Consultant

Environment: People Soft Financial FSCM 8.4 (GL, AP, AR, BI, KK, AM, PC, T&E, Inventory) People Tools (8.43), PeopleCode, SQR, Workflow, Integration Broker, File Layout, Application Engine, Component Interface, Quality Center, WinRunner, QuickTest Professional and LoadRunner DataMover, DB2, SQL Server 2000,

• Prepared functional and technical specifications for Account Payables, Travel and expense.
• Tested Account Payable Application interfaces and SQRs which are ACH/EFT Payment files to send to chase Bank, Cleared check information from bank to PS, AP Vendor data to SLIM, Check data to SLIM, Check clearing data to slim and garnishment invoice payment information to payroll.
• Created new rules and assigned role type and role names.
• Tested customized the existing Expense workflow to send payment notification email to employee.
• Worked on a Conversion program to update the location codes in the DEPT_TBL with the store locations which are in the Legacy system.
• Ran the Item Loader Workflow process to process errors and exceptions for Item loader messages.
• Worked on T&E workflow process and notified employees with automated email message.
• Worked on match exception process and notified users with email message about exception rules.
• Involve in testing of GL Background processes GL_LED_IMP and GL_JRNL_IMP.
• Developed Application Engine Processes to upload Vendor Conversions and Journal uploads
• Created JCL wrappers for SQR and application programs to be able to run on mainframe.
• Tested component interface to load express voucher data (ADD, UPDATE), Express Bill Entry (BI_ENTRY) from excel to peoplesoft (AP_VCHR_EXPRESS).

Client: Confidential,San Jose, CA Jan\'06 – Jan\'07

Project Project involved in the Implementation and Customisation of Managemnt System & Distribution Modules of PeopleSoft four core modules AP, AR, GL and AM in Peoplesoft Financials, and upgrading.
Role: Peoplesoft Functional Consultant.

Environment: People Soft Financial FSCM 8.4/8.0 (GL, AP, AR, BI, AM), People Tools (8.43), PeopleCode, SQR,Crystal Reports.SQL server,Quality center.

Responsibilities:

• Extensive involvement in developing custom SQR reports for the HR department.
• Worked on customizations, enhancements, desktop support/issues, Security views and performance issues.
• Developed site-specific Benefits Billing reports
• Customized online print functionality for benefits billing
• Assisted in prototyping and development phase for Benefits Admin
• Involved in Testing Life-Cycle from analyzing Business Requirements to developing Test Plans, Test Case, execution of Test Scripts and deployment of PeopleSoft 8.4 Financials Modules such as General Ledger, Asset Management, Billing, Accounts Receivable, and Accounts Payable.
• Developed the upgrade plan, Installed and upgrade PeopleTools, Executed and reviewed compare reports, Setup menu security, helped in Audit and clean-up databases.
• Modified existing customized pages and created new pages.
• Modified the PeopleCode in the various custom field events to reflect the functionality that earlier existed.
• Debugged various application engine programs that error out during the upgrade run.
• Reviewed and established disaster recovery requirements and plan, provided subject matter expertise across all technical areas of the projects, reconciled object and functionality decisions, Re-designed online customizations plan.
• Applied module-specific setup and conversions, Performed SQR, Crystal, COBOL, Application Engine, Query and nVision comparisons.
• Wrote Crystal Reports, PS/nVision reports using Query Manager.
• Involved in Migrating the Projects which contains customized objects like Records, Pages, and Component.
• Developed test case scenarios and created test scripts in Mercury Quality Center.
• Worked on EDI Manager for Account Payable. Involved in data mapping and setting up of action codes and event codes.
• Analyzed and made recommendations for customization of the inbound and outbound agent SQRs.
• Customized PeopleCode for the pages as per the requirements by the client using PeopleSoft Application Designer.
• Performed Extensive Functional, Integration, Regression & Configuration Testing.
• Developed new Crystal reports and new SQR Programs and customized existing Programs.
• Worked on data mapping, component interface for data conversion for Financial Implementation System.
• Did extensive work on customized SQRs and wrote new SQRs as per client’s requirements.

Client: Confidential,India May\'03 – Dec’05

Project Involved in the Implementation and Customisation of PeopleSoft applications
Role: Functional Tester

Environment: PeopleSoft Financials 8.4/8.0/7,PeopleTools 8.43, SQR, Unix, nVision, Crystal Reports,component interface,File Layout,Application Engine, DB2,Quality Center.

Responsibilities:

• Developed and Documented Test scenarios and Test cases in Quality Center 9.2 in accordance with the Business Requirements Documents and the Functional Requirements Specification documents.
• Involved in Agile testing process and Communicated daily with the Developers, the Business team members to address release issues, clarify technical and BAU items.
• Upon create the test case for every Enhancement would take a walk through with business user, TBA and development team.
• Conducted daily status meetings to present the QA testing efforts status to the business community.
• Involved in business & design walkthroughs and inspections.
• Responsible for performing Functional, Integration, Regression Testing by creating Scripts.
• Participated as a key member with the QA Team for Regression testing where day-to-day bugs were monitored.
• Also performed System End to End testing and Backend testing.
• Used HP Quality center for defect tracking and defect reporting.
• Prepared Requirement Traceability Matrix and mapping the Test Cases with the requirements using Quality center.
• Performed data driven tests to ensure application is running for different varieties of data to test different scenarios.
• Worked with appropriate team leaders to ensure quality of test deliverables & timely completion of individual test plans.
• Developed documentation for User Acceptance Testing and trained the users about the system.

Education:

• Bachelor of Science.