SUMMARY

• Excellent working noledge of the PeopleSoft Internet Architecture and the flow of data exchange between various FSCM modules.
• In - depth proficiency of functional and technical noledge, 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 noledge 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.
• Diverse experience in different types of testing like Integration, Functional,Product, Performance, Regression, System Testing, Back End Testing, User Acceptance Testing (UAT) and end-to-end testing.
• 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.

TECHNICAL SKILLS

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:

Confidential, CA

PeopleSoft Consultant(Testing/coordinator)

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

Responsibilities:-

• Developed Test plans, Test cases and create test data and executed in HP ALM 11.0 for ePro,PO,Inv,AM
• 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.
• Also done Backend Testing by using SQL.
• 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.
• Used HP ALM extensively to Plan, Monitor and maintain the testing process.
• 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.
• Upon create the test case for every Enhancement would take a 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.

Confidential, Dover, DE

PeopleSoft Consultant(QA)

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

Responsibilities:-

• Involved in analyzing the requirements and finalizing the scope of the testing process.
• Responsible for creating test cases and test plans to test all possible corners of the system
• Involved in testing GL, AP, AR, PO, AM, Project costing and ePro modules.
• Tested Maintain 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.
• Manually tested all the individual PeopleSoft Pages for correct functionality.
• Tested Payment Predictor functionality for loading the Bank Checks through Lockboxes and running the Payment Predictor Process in AR module
• 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 on QC.
• Created Manual for QC 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

Confidential, Southfield, MI

PeopleSoft Tester

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.
• Tested customized 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.
• Tested 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.
• Tested 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.

Confidential . Chicago, IL

Functional Tester.

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.
• Worked extensively on SQR, Crystal Reports, PS Query and App Engine Programs.
• Involved in testing of all AM and AR Corning reports to remove custom chart field.
• 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

Confidential, Indianapolis, IN

Peoplesoft Consultant(QA)

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

Responsibilities:-

• 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).

Confidential, San Jose, CA

Peoplesoft Testing 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.

Confidential

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.