Peoplesoft

Vikram Reddy Ph #

571-***-****

**********@***.***

Summary of Experience:

. 8 years of Functional and Testing Experience of PS (PeopleSoft)

General Ledger, Accounts Payables, Purchasing, Accounts Receivables,

Billing, Inventory, Order Management, Project Costing, Payroll, PS

Benefits Administration, eBenefits, ePay, Time and Labor, Manager,

Employee Self Service configuration and Security configuration

testing, processing.

. Excellent knowledge of PeopleSoft Financials modules, including

Account Payables, General Ledger, Purchasing, Accounts Receivables,

Billing, Inventory, Order Management, Asset Management, Project

Costing modules as Functional Analyst and Tester.

. Expertise in various Inventory functionalities such as Fulfillment

Process, Inventory Replenishment, Par Inventory Management, Inventory

interface to external systems like Atpar.

. Created customized End User classes in UPK for General Ledger,

Accounts Payables, Inventory and Purchasing.

. Provided direct PS Inventory knowledge transfer to clients.

. Implemented PeopleSoft's eProcurement module, which includes automated

requisition workflow and vendor catalog punchout functionality

. Experience with Manual and Automated testing such as Regression, Black

Box, White Box, Positive, Negative, System, Integration and UAT.

. Experience with generating Bank Payment Files through Financial

Gateway.

. Expertise on Vendor Conversions.

. Defined activities required for Functional Testing, System Testing,

Parallel Testing, Integration Testing and User Acceptance Testing.

. Complete understanding of Quality Assurance Lifecycle (QALC), QA

Methodology and QA Strategy including Software Development Lifecycle

(SDLC)

. Expertise in requirement gathering, fit/gap analysis, configurations,

interfaces.

. Strong experience in End to End module Testing and Integration Testing

with PeopleSoft and Third Party Tools.

. Experience working as a Team Lead and coordinate with Client and

Offshore Teams.

. Knowledgeable in Integration tools like Integration Broker, Component

Interface and Business Interlinks.

. Strong Analytical skills and a team player.

Technical Summary:

ERP: PeopleSoft Financials/SCM (GL, AP, PO, PC, AR, BI, AM, T&E, INV, Order

Management, eprocurement).

Tools: PS Query, Application Designer, Security Administration, Process

Scheduler, People Code, Remedy, Stat,

Manager, PS/nVision, Component Interface, Application Engine, Integration

Broker, Web Services, EDI, SQR, Crystal Reports.

Testing Tools: Load Runner, Win Runner, Test Director, QTP, HP Quality

Center, XML, Rational Testing Tools, Incidental Logs

Database: Oracle, Informix, DB2, Sybase, MS SQL Server

OS: Windows, UNIX

Educational Qualifications:

Masters in Information Systems - University of Northern Virginia -

Virginia, USA

Bachelors in Electronics and Communications - Jawaharlal Nehru

Technological University - India

Detailed Experience:

Broadcom Corporation, Irvine, CA

PeopleSoft Consultant (Production Support)

Sep 2014 to Present

. Worked on PeopleSoft Financials Modules AP, GL, PO, BI, OM

. Created PS queries per user requests.

. Performed support for General Ledger, PS Security, Accounts Receivable

and other financial modules by answering questions, providing user and

offshore team training, resolving issues and identifying the root

cause of the problems

. Defined an approach to Query Security in PS 9.0 and created a new role

for developers to separate 2 tier access to Application Designer from

creating a Public Query in Production environment.

. Provided resolutions to various Service Incident Reports (SIR's)

through investigation and analysis of the problem with users,

correction, testing and implementation of the modifications to the

design, code or processing using PeopleSoft Tools, PeopleSoft Code,

SQR and other PeopleSoft products.

. Involved in Facilitating meetings, process mapping, and knowledge

transfer.

. Coordinated with AP and GL and other concerned modules to resolve and

sustain data integrity.

. Extensively worked with Remedy tool to track the tickets and solve the

issues

. Performed backend SQL updates for data as per user requirement.

. Extensively worked on Scheduling Queries for user as per their need.

. Provided on call support to handle Production Support issues and

resolved all the tickets as per the SLA's defined by the client

teams.

. Proving online support to the users across the Globe.

. Extensively worked on SQL Server to pull the data for reconciliation.

. Tested ACH and check payments with Bank of America

Environment: PeopleSoft FIN 9.1, People Tools, Oracle9i, SQR, Application

Engine, EDI, Remedy, Integration Broker, PeopleCode, AP, GL, PO, OM, HP

Quality Center, Crystal Report, UNIX, Windows, STAT

Acxiom Inc., (HCL America), Conway, AR

PeopleSoft Functional Consultant

Jun 2014 to Aug 2014

. Worked on PeopleSoft Financials Modules AP, GL, PO

. Configured new Business Units across all modules as per Business need

( AP, GL, PO, AR, BI )

. Configured Business Units, Ledgers and Ledger Groups

. Configured new Allocations including Inter-Unit Allocations

. Configured ACH layout, payment source and pay-cycle steps

. Converted Ledger Balances for prior two years to the new PeopleSoft GL

. Configured Locations, Calendars, Asset Books and created AM Business

Units

. Involved in creation of functional test scripts and use cases for all

the navigation of PeopleSoft Financials and SCM particularly Accounts

Payables. Worked closely with Technical team and handled the documents

needed to them.

. Coordinated with AP and GL and other concerned modules to resolve and

sustain data integrity.

. Involved in end to end testing of AP Business process like Voucher

creation, Voucher posting, Pay Cycle process, Payment Posting Process

in AP module.

. Configured VAT Defaults and VAT Service Treatment Setup

. Developed Functional Designs and templates for Voucher upload, Vendor

Upload.

. Extensively worked with user to get required data to load into

PeopleSoft

. Tested from end to end scenarios for new Business Units, from creating

a requisition till GL

. New banks setup as per Business requirement

. Performed planning and data conversion activities

. Test cases are developed according to requirements and executed

accordingly.

. Involved in Setup, Configuration and Testing of Voucher Spreadsheet

Import/Export process for different Business Unit.

. Created Test Cases and Test Plans for testing of Voucher Build Process

and reviewed the errors.

. Involved in end to end testing of Vendor, Updating Vendor Information

and In activating vendor in AP module based on the client

requirements.

. Involved in end to end process from creating vouchers to dispatching

the payments through Financial Gateway

. Good understanding of financial gateway.

. Supported UAT for end to end testing of AP, GL modules.

. Involved in Defects resolution for AP module and documented the

results.

. Actively supported the AP processing in the post Go-Live Period by

resolving Defects and other Production related issues.

Environment: PeopleSoft FIN 9.2, People Tools, Oracle9i, SQR, Application

Engine, EDI, Integration Broker, PeopleCode, AP, GL, PO, AM HP Quality

Center, Crystal Report, UNIX, Windows, STAT, Remedy

CBRE Inc., TX

PeopleSoft Functional Analyst

Aug 2013 to Jul 2014

. Conducted fit/gaps, developed table setup and configuration, performed

data migration, created design documentation.

. Performed Fit-GAP analysis to gather requirements for AP

implementation

. Involved in Testing the Custom Inbound and Outbound Interfaces

. Worked on Setup and Configuration of AP, PO, GL modules

. Developed user roles and security

. Involved in executing Scripts in HPQC

. Defined Asset Categories and created Assets Accounting Entry Templates

. Configured depreciation schedules

. Tested Asset Net Book Value Crystal (AMNB1000) report.

. Tested Depreciation (AMDP2300) by Fiscal year report

. Extensively involved in testing Bank Payment Files using Financial

Gateway to dispatch the payments.

. Defined and setup SET IDs. Defined GL Business units and setup GL

security with Permissions Lists, User Roles and Profiles

. Performed planning and data conversion activities

. Developed Functional designs for dispatching the payments through

Financial Gateway for around 15 Countries.

. Create test plans for System and Integration testing, Regression

Testing, User Acceptance Testing

. Log defects and track the defects in Quality Center

. Developed a customized Sepa Layout as per Banks requirement.

. Worked on Designing Payment Layouts as per country requirements.

. Extensively used excel to CI for Vendor Upload and Voucher Upload.

. Created Vendor Conversion design as per business need for different

countries

. Extensively involved in creating Vendors and Vouchers

. Involved in end to end process from creating vouchers to dispatching

the payments through Financial Gateway

. Involved in working with the Managers to get the requirements for Test

Plans and Test Case building.

. Involved in final Integration Testing of AP modules with third party

systems and other PeopleSoft modules.

. Created the general and detailed Functional and Technical

specification documents based on the requirements.

Environment: PeopleSoft FSCM 9.1, People Tools, Oracle9i, SQR, Application

Engine, People Code, AP, GL, PO, AM, HP Quality Center, UNIX, XML

Alliance Data, TX

PeopleSoft Analyst

Sep 2012 to Aug 2013

. Conducted fit/gaps, developed table setup and configuration, performed

data migration, created test scripts and design documentation.

. Participated in writing detailed Test Plans, Test Cases, Use Cases,

Test Strategies and Functional specifications based on the

requirements from the clients meetings

. Involved in Testing the Custom Inbound and Outbound Interfaces

. Developed user roles and security

. Involved in creating and maintaining Item Catalogs and User setups.

. Setup Procedures for Chartfields, Items, Item Categories, Vendor,

Return to Vendor for eprocurement.

. Worked on PO close, PO recurring voucher.

. Developed Desk References and SOPs

. Automated requisition to voucher workflow for several business units

and third-party agencies

. Worked on developing Inventory Projection report as per business need.

. Wrote Test cases, Test Scripts for System testing, Integration Testing

and UAT.

. Developed Governance procedures as per line of business need.

. Established user preferences for procure to pay end users.

. Provided end user support for purchasing

. Involved in executing Scripts in HPQC

. Involved in working with the Managers to get the requirements for Test

Plans and Test Case building.

. Wrote Test Strategies and Test Plans for testing PO delivered

processes.

. Involved in final Integration Testing of PO modules with third party

systems and other PeopleSoft modules.

. Created the general and detailed Functional and Technical

specification documents based on the requirements.

Environment: PeopleSoft FSCM 9.1, People Tools, Oracle9i, SQR, Application

Engine, PeopleCode, AP, GL, PO, HP Quality Center, UNIX

Verizon Wireless, NJ

PeopleSoft Functional Analyst Upgrade ( 8.4 to 9.1 )

Jun 2011 to Sep 2012

. Created custom UPK Content for User training. Trained & supervised

staff on becoming successful UPK Developers.

. Taught Purchasing UPK lessons to Users on how to create:- Requisitions

- Online and batch, Requisition change requests, Requisition Sourcing,

Purchase orders - Online and batch, Purchase order change orders,

Purchase order dispatch, Requisition reconciliation, Purchase order

reconciliation, Returns to vendors, Procurement analysis and

Reporting.

. Taught Inventory UPK lessons to Users on how to create: - Receiving

and putaway, Consigned inventory management, Replenishment, Stock

request creation, Material reservations, Picking, Shipping, Par

inventory management, Material usage and reconciliation, Inventory

accounting.

. Setup and create Change Orders in Purchasing.

. Ability to analyze SQR, PeopleCode, Application Engine, Application

Messaging

. Configured the online POA (Purchase Order Acknowledgements) business

process in eSupplier connection.

. Purchase Orders were configured correctly to be dispatched to supplier

using either Print/ Fax/EDX/Phone/Email in Purchasing using EDI.

. Create PS Queries

. Involved in Defects resolution and documented the results

. Setup Build Inventory Demand, PO_Calc, PO_Create, and Sourcing

Workbench in Purchasing.

. Matched vouchers with all purchase order and receiver details, and

generated payments without waiting for invoices, using the Evaluated

Receipt Settlement matching process

. Wrote queries to:

. Mimic the Consigned Inventory report with additional fields

displayed such as Voucher ID, Accounting Date, Receipt Number,

Voucher Source, Vendor ID, and Vendor Location which are not

shown on the PeopleSoft delivered report.

. Display the on-hand quantities for both owned and non-owned

items with the storage areas for each item along with their

respective vendors.

. Involved in creating New Accounting Rules, New Distribution Types,

Distribution Codes and Distribution sets to enter the accounting

entries.

. Integration Testing was performed on various eprocurement/PO/INV/AP

processes such as Quick Source Requisitions, PO Dispatch, Outbound

File Publish, Process Receipts, Reservations, Order Release Request,

Picking Confirmation, Depletions, Cost Accounting Entries, INV Journal

Generate, Voucher post, Payment Post, Matching, and AP Journal

Generate.

Environment: PeopleSoft FSCM 9.1, People Tools, Oracle9i, SQR, Application

Engine, PeopleCode, AP, GL, PO, HP Quality Center, UNIX, Windows, STAT,

Remedy,

Kaiser Permanente, Pleasanton, CA

PeopleSoft Functional Test Analyst/Sub-Lead Upgrade (8.9 to 9.0 )

Jun 2010 to Jun 2011

. Worked on Peoplesoft Financials Modules AP, GL, Supply Chain Modules

PO, INV, Epro and other Peoplesoft modules like Treasury (Cash

Management & Deal Management) and EPM

. Provided analysis and documented models through business process

reengineering for successful integration of business functions and

technology.

. Used Iteration Testing Methodology to test the system.

. Involved in Setup, Configuration and Testing of Voucher Spreadsheet

Import/Export process for different Business Unit.

. Created Test Cases and Test Plans for testing of Voucher Build Process

and reviewed the errors.

. Involved in end to end testing of Vendor, Updating Vendor Information

and In activing vendor in AP module based on the client requirements.

. Worked in Cash Management(Banking, PD & CD Bank Statements,

Reconciliation Statements, Cash Position (CPW), Fees & Transfer,

Settlements, Treasury Accounting)

. Helped design proof of cash report.

. Worked on end to end Deal Management (Capturing Deals, Processing

Deals, Confirming Deals, and Administering Deals).

. Good understanding of financial gateway.

. Created Test Strategies and Test Plans for testing of Voucher Entry

and Vendor Withholding pages in AP module.

. Involved in writing Test documentation for testing of the following in

AP module - Business Units, Journal and Ledger Templates.

. Involved in Testing the configuration and setup of the following in AP

module - Bank Setup, Pay cycle Manager, Sales, Use Tax, Matching and

Withholding.

. Involved in Integration Testing of Voucher Creation, Voucher Posting

and Payment posting processes in Accounts Payable module and validated

the input and output data.

. Worked on end to end testing of delivered workflow in PeopleSoft AP

Module such as Voucher Approval Workflow and Matching Exception

workflow.

. Worked on creating custom Roles, Permission Lists and User Profiles in

PeopleSoft Security and tested them as per the client requirements.

. Supported UAT for end to end testing of AP, GL modules.

. Created Test Plans and executed them and documented the results in MS

excel sheet.

. Involved in Defects resolution for AP module and documented the

results.

. Involved in Integration Testing of Pay cycles to see the data going to

Deduction Tables and Withholding tables.

. Actively supported the AP processing in the post Go-Live Period by

resolving Defects and other Production related issues.

. Involved in documenting the test results using MS word and excel. The

results were discussed with the client and manual validation was

performed to verify the results.

Environment: PeopleSoft FIN 8.9, People Tools, Oracle9i, SQR, Application

Engine, EDI, Integration Broker, PeopleCode, AP, GL, PO, HP Quality Center,

Crystal Report, UNIX, Windows, STAT, Remedy, .

Freddie Mac, McLean, VA

Senior PeopleSoft Functional Analyst

Jan 2010 to June 2010

. Designed and developed the Application Engine/File Layout Programs

conversion program to retrieve the legacy data from the STATS

Application

. Monitoring and support of daily and nightly GL Batch runs for the

journal processing.

. Support for the functional staff in resolving day to day user queries,

finding validity of the user issues

. Worked with stakeholders to implement the process recommendations

prior to go-live.

. Developed user roles and security.

. Assisted large buyer and supplier organizations with the

implementation of electronic catalogs and eProcurement processes

. Implemented PeopleSoft's eProcurement module, which includes automated

requisition workflow and vendor catalog punchout functionality

. Established user preferences for procure to pay end users.

. Automated requisition to voucher workflow for several business units

and third-party agencies.

. Developed detailed training materials and quick guides and provided

training to finance and end users on procure to pay functionalities.

. Developed customization to track vendor categories and developed

queries to utilize data collected in vendor file for deliverable

supplies & services and government certifications.

. Provided end user support for purchasing and payables.

. Provided support to functional lead in general ledger and commitment

control.

Environment: PeopleSoft FIN/SCM 8.9, PeopleTools, SQR, Application Engine,

EDI, PeopleCode, AP, GL, AR, BI, PO, INV, OM, eprocurement, Time and

Labor, Win Runner, Test Director, Load Runner, QTP, Ration Test Manager,

Rational Robot, Rational Clear Quest, Crystal Report, UNIX, Windows,

Tesseract, STAT.

MTA, NY, NY

PeopleSoft Functional Consultant

Apr 2008 to Dec 2009

. Worked on Setup and Configuration of AP, PO, GL, AR, BI, eprocurement

and INV modules.

. Develop and execute test plans with the testing team using Mercury

Testing tools.

. Created Test Plans and Scripts to Test all the delivered Interface

Process in AP, GL, PO and other Financials and SCM modules.

. Analyzed and tested various processes like Voucher and Voucher Build,

Voucher Approval Workflow, Vendors and 1099 process, Pay cycle and

Check Print process.

. Conducted UAT Testing sessions for Testing of Purchasing processes

like Requisition creation, Requisition and PO Approval and other

processes in PO module.

. Worked with the development and application expert to Test the user

and system requirements.

. Created unit test plans, system test plans and integration test plans

for CLIENT PeopleSoft systems.

. Developed interface test plans for legacy interfaces to include AP, PO

and GL modules.

. Involved in migrating code to appropriate servers after the code is

changed for enhancement or bug fix.

. Conducted regression testing of customizations, downstream process

flow testing of interfaces, patches, bundles.

. Involved with writing functional specifications for customizations.

. Involved with writing test plan for Go-Live checklists.

. Developed and customized reports according to client requirements

using SQR and Crystal Reports.

. Completed a detailed Fit-Gap Analysis Document for Buyer eProcurement

and Content Management products

. Involved in mission critical testing support during System Integration

Testing period for GL, Expenses, Purchasing and AP modules.

. Developed numerous queries and reports for data analysts.

. Worked on to propose Test solutions and approach re-design or system

functionality for PeopleSoft Financials and SCM modules.

. Involved with the testing team to setup test scripts for new

functionality like custom Interface processes to load Vouchers and PO

to load in PeopleSoft.

. Involved in Integration of Workflow, testing of email notification for

AP, PO, INV, AM and GL modules.

. Writing SQLs using PS Query to ensure the validation before go-live

and after go-live for AP and PO modules.

. Involved with the writing test scripts and executing them for AP, GL,

PO and other Financials modules.

. Developed data maps for migrating customer data from legacy system to

PeopleSoft.

. Provided support in resolving data integrity issues associated with

various processes.

. Modified queries for reports in PS Query.

. Developed user training documentation and user manuals.

. Reviewed and modified existing report specifications and worked with

technical team for enhanced and more productive reports.

. Worked on to created Test Plans for Payroll Master Report which

calculates the earnings, deductions and taxes for every period and

have the numbers calculated for QTD and YTD. It also shows the

employees personal information and payroll information.

. Provided Production support and query reports

Environment: PeopleSoft FIN/SCM/HRMS 8.8/8.4/8.3, AP, GL, AR, BI, PO, INV,

OM, eprocurement, T&E, HR, PeopleTools, SQR, Application Engine,

PeopleCode, EDI, Integration Broker, Ration Test Manager, Rational Robot,

Rational Clear Quest, Win Runner, Test Director, Load Runner, QTP, Clear

Quest, SQR, UNIX, Windows 2000, Crystal Reports, STAT.

Digerati Systems

PeopleSoft Intern

Apr 2007 to Apr 2008

. Worked on writing test case scenarios.

. Develop and execute test plans with the testing team using Mercury

Testing tools.

. Recorded all the testing results.

. Involved in configuration of Accounting entry templates

. Involved in setups of new Business Units.

. Worked on Creating Vendors

. Involved in creating Vouchers, making Payments.

. Involved in writing queries under Query manager

Environment: PeopleSoft FIN/SCM/ 8.8/8.4/8.3, AP, GL, AR, BI, PO, INV,

eprocurement, T&E, HR, PeopleTools, SQR, Application Engine, PeopleCode,

EDI, Integration Broker, Ration Test Manager, Test Director, Load Runner,

QTP, Clear Quest, SQR, UNIX, Windows 2000, Crystal Reports, STAT.

Contact this candidate