Manager Project

SUMMARY

> *+ years of experience in IT, PeopleSoft Financials/SCM modules like

General Ledger, Accounts Payable, Accounts Receivable/Billing, Expenses,

Asset management, Projects, Contracts, Purchasing, e-Procurement,

Inventory and PeopleSoft HCM (Core HR, Payroll, and Benefits) and ADP EV5

Enterprise HRMS system experience.

> Hands on Experience in Fit-gap analysis, design, development and

enhancement of PeopleSoft applications.

> Experienced in PeopleSoft ver8.4, 8.8, 8.9, 9.0, 9.1 Implementation,

Upgrade, Conversion strategy, Data Migration and Production support.

> Experienced in PeopleSoft upgrade, devising implementation methodology,

conversion strategy, production support, troubleshooting.

> Expert report writing skills using SQR, Crystal Reports, PS/nVision and

PS QUERY

> Development and customization using Application Designer, Integration

Tools, Reporting Tools, PeopleTools, Data Mover, and SQL Scripts.

> Worked Extensively on PeopleTools, People code, Application Engine, XML

Publisher, Component Interface, Integration Broker, File layouts, PS

Query, SQR, PS/nVision, Crystal Reports, Process Scheduler, and Oracle

PL/SQL.

> Extensively worked with XML Publisher, SQR reports in creation and

generation of organizational decision-making reports

> Experience also includes debugging and performance tuning of processes.

Well versed with Debugging tools like SQL trace, PC debugger, and AE

trace for troubleshooting.

> Have functional knowledge of various modules in PeopleSoft Financials

such as General Ledger, Receivables, Billing, Payables, Purchasing,

Inventory, Asset Management, Expenses, and Project Costing.

> Experience in C, C++, Data Structures through C and Oracle.

EDUCATIONAL QUALIFICATION

> Masters in Computer Science, Southern Methodist University, Dallas,

TX, USA during August 2005 - December 2007.

> Bachelor of technology in Computer Science and Engineering, Sri

Venkateswara University, Tirupathi, India during November 2000 - April

2004.

> PeopleTools Developer Certified Expert Aug

2008

> PeopleTools Advanced Developer Certified Expert Aug 2008

TECHNICAL SKILLS

Overview: PeopleSoft Financials (8.4/8.8/8.9/9.0/9.1), Application

Designer, PeopleTools, PeopleCode, Application Engine, Component

Interface, Security, Portal, Process Scheduler, PC Debugger,

Application Engine Trace, Trouble Shooting, SQR, Crystal

Reports, PS Query, Tree Manager, Patches/Fixes, Data Mover,

Definition Security, PL/SQL, Integration Broker, Upgrade

Assistant

Op Systems: Windows NT, UNIX

Databases: Oracle 11g/10g/9i/8/7.x, MS SQL Server6.5/7.0/2000/2005,

MySQL

Applications: General Ledger, Accounts Payable, Accounts

Receivable, Purchasing and Billing

Programming Languages: C, C++, PHP

Technologies: MFC (Microsoft Foundation Classes), ASP.NET

GUI Tools: Macromedia Flash, Adobe Photoshop

Web Tools: HTML, DHTML, XML, JavaScript, Dream Weaver,

FrontPage.

EXPERIENCE

Projects worked at ERP Analysts, Columbus, OH

Jan 2008 to Current

Client: Virginia Department of Transportation(VDOT), Richmond, VA

July'10 - Current

Role: Sr. PeopleSoft Techno Functional Consultant

VDOT is currently live on PeopleSoft Financials V6.0 and Implementing to

9.1. Applications involved are General Ledger, Accounts Payables,

AR/Billing, Expenses, Project Costing, Contracts, Purchasing, e-

Procurement. Worked with the Interface, Conversion, and Extension/Reports

team to gather all the requirements, developed Functional & Technical

designs and build successfully.

Responsibilities:

> Written technical design for Positive Pay file which sent to bank.

Involved in the meetings and gathered all the required information which

must send to bank to process the checks. Build the Positive Payment File

interface as per business needs.

> Developed Functional & Technical design for Utility Voucher Upload

process in AP module. Analyzed the how the current system (PS V6.0) is

working, and gathered all the necessity information for the Voucher

Upload interface by conducting meetings. Build the Utility Voucher Upload

process successfully.

> Written technical design for CDS Offset Inbound interface, which runs

before the Pay Cycle Manger process. Department of Taxation send files to

VDOT which must be loaded into the Payment tables.

Environment: PeopleSoft Financials/SCM 9.1 (GL, AP, AR/BI, PO, e-Pro,

Expenses, PC, Contracts), People Tools 8.50.08, Oracle 11g, Application

Engine, Integration Broker, SQR, PS/nVision, Crystal Report.

Client: OneWest Bank, Los Angeles, CA

Jan'10 - June'10

Role: Sr. PeopleSoft Techno Functional Consultant

OneWest Bank is currently live on PeopleSoft Financials 8.8 and upgrading

to 9.0. Applications involved are General Ledger, Accounts Payables,

Purchasing and Asset Management. Analyzed the customizations in current

system and reduced the keep list of customizations by using new delivered

functionalities in PeopleSoft 9.0. Also retrofitted the custom and

customized objects.

Responsibilities:

> Performed system assessment and fit-gap analysis, reducing amount of

customizations.

> Fixed the AM Business Unit Setup calendar issue, As the GL calendar runs

on daily basis where as AM Calendar must run on monthly basis. Tested the

overall AM process flow to check all the functionalities are working

properly or not.

> File attachment concept is implemented for Journal Entry page. Instead of

storing hard copies of the Journal files, Users can attach multiple files

of various types for journals. Validations are done accordingly so that

Manager, Audit people can also view the attached files for Journals and

can approve. This concept is delivered in PS FSCM 9.1 version.

> Performed clean-up of PS objects based on SYSAUDIT/DDDAUDIT report.

> Removed the PeopleSoft delivered SetID MODEL from all the control tables

as it was no longer in use and just carrying forward from past till now.

> Analyzed the current custom Bank Reconciliation process and suggested

steps to reduce the customizations where we can use delivered process.

> Retrofitted the Check-print crystal, Positive pay, ACH custom processes.

Tested all type of scenarios for check print and positive pay like

Stop/Void/Escheat payments.

> Involved in the Review of the upgrade Manuals, participated in the

preparation of assessment Plan for the upgrade, creating and configuring

copy of the Production Database and identification of the customizations

necessary for the upgrade.

> Implemented Work Flow to meet Business application needs in the

consistent way for GL, AP, PO for PeopleSoft 9.0

> Resolved production issues in the current system.

Environment: PeopleSoft Financials/SCM 8.8/9.0 (GL, AP, AM, PO), People

Tools 8.49, SQL Server 2008, Application Engine, Integration Broker, App

Message, PS/nVision, Crystal Report.

Client: US Oncology, Houston, TX

Nov'09 - Dec'09

Role: Sr. PeopleSoft Technical Consultant

US Oncology is one of the nation's largest cancer treatment and research

networks. US Oncology is currently live on PeopleSoft Finance 8.9 and

doing enhancements to PeopleSoft Project Costing, AP, AM, Purchasing

modules. Involved in analyzing the current system and suggested various

enhancements suitable to the client's environment.

Responsibilities:

> Analyzed the existing applications, design and evaluation of

customization, functional/technical specs development for the Enhancement

of current PeopleSoft applications.

> Worked on integrating PC to AM process, setup and maintenance of

activities, resource categories, and resource subcategories.

> Analyzed the current system of interfacing PC/GL/AP/PO/AM and suggested

recommendations for the enhancement of the application.

> Developed queries to identify any list or missing transactions from

interfaced modules.

> Did setup for PC to Time & Labor to capture capitalized labor

calculations in Project Costing module.

> Reviewed AM multiple books, tax book adjustments, book synchronization

and corrected the asset profile setup.

Environment: PeopleSoft Financials/SCM 8.9 (GL, AP, PC, AM, PO), People

Tools 8.47, Oracle, Application Engine, Integration Broker, App Message,

PS/nVision, Crystal Report.

Client: Georgia State University, Atlanta, GA

Apr'09 - Sep'09

Role: PeopleSoft Techno Functional Consultant

GSU is currently live on PeopleSoft Finance 7.5 and Implementing PeopleSoft

Finance 8.9. Also ADP EV5 is going to replace the PeopleSoft HRMS 8.8. I

involved in writing Interfaces, analysis, Re-applying custom changes,

Reporting, designing technical and functional specification documents, Test

support, Production support.

Responsibilities:

> Developed Technical Specifications and System Flows from the Functional

Requirements.

> Developed Purchasing Interface using 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.

> Created an audit report that shows accounting entries from subsystems

that were not distributed to General Ledger.

> Gathered Functional requirements, created Technical specification

document and developed an interface program using App Engine program &

File Layout, to load a pipe delimited flat file which will be available

from Bank of America having the Employee expense transactions. Interface

program reads the expense data from the flat file, loads into temporary

tables and ultimately loads into peoplesoft using EDI manager where the

interface program provides the output with another file which maps the

EDI manager to create Vouchers.

> Designed and developed Workflow to Approve Voucher Payments from Expense

Report based on the amount either to set the Voucher Status as Approved

or to route to the appropriate Managers for Approval.

> Retrofitted HR to GL Interface using SQR. Flat file comes from ADP EV5

which is related to Payroll information; the data is loaded into temp

tables and then did translations, validations later loaded into GL

tables.

> Designed and developed several Inbound/Outbound Application Engine and

SQR interfaces from ADP EV5 to PeopleSoft Financials system.

> Developed several reports using SQR and Crystal reports.

> Developed several application engine programs' to load data from flat

file using File Layout to GL tables and Vice-versa.

> Developed PS/nVision layouts & Report request for Income Statement

Report.

> Resolved issues that occurred in PeopleSoft workflow and security.

> Reduced application customizations to focus on use of delivered

PeopleSoft code and address business process changes for end-users

> Tested PS/nVision Reports and validate the conversion data.

> Complete and deliver system Configuration documentation, Technical Design

documents, Test Scenarios & Scripts, and Test/Training.

Environment: PeopleSoft Financials/SCM 8.9, HCM 8.8, (GL, AP, AR/BI, PO,

Projects, Grants, Expense), People Tools 8.48, Oracle, PL/SQL, SQR,

Application Engine, PS/nVision, Crystal Report, Component Interface, Work

Flow.

Client: University of North Dakota

Jan'08 - June'08

Role: PeopleSoft Technical Developer

Client UND are Upgrading the PeopleSoft finance 8.4 to 9.0. I involved in

Fit-gap analysis, Re-applying custom changes, Compare report analysis using

application designer and external tools, designing technical and functional

specification documents, Test support, Production support.

Responsibilities:

> Retrofitted customizations on top of delivered code in all the modules

(GL, AP, PO, AM, AR and BI) so that the code performs in accordance with

the functionality of the customer.

> Created design specifications for the changes needed for the existing

customizations.

> Worked on different Custom Accounts Payables SQR and People code Analysis

to meet the requirements.

> Identified and reapplied the custom invoice SQR report changes from 8.4

to 9.0

> Analyzed and retrofitted different SQR for Billing module such as print

changes that were introduced from these bundles.

> Worked on compare reports on Pages, Record People code and AE for Billing

module.

> Customized PeopleSoft delivered Crystal reports in Accounts Payable like

Closed Voucher, APY1010 Voucher Register.

> Developed GL Interface that loads data from various external systems 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

maintenance report and processed file report. Used various SQR

functions, Arrays, Trees, Views, Load Lookup & SQC (which handles various

Invalid Chartfield Combinations).

> Developed Custom SQR Reports like the Research report, Vendor Payments

listing report, cancelled check report etc.

> Written an application engine process to run against all the items

present in Master_Item_Tbl to get the Purchase Order details like PO_ID,

PO_DT, PRICE_PO, DUE_DT, PO_STATUS, VENDOR_ID, Quantity Received,

Receiver ID and Unit Price for each and every item and load them into

appropriate customized tables. Several reports have been run against the

tables.

> Involved in developing, inbound interface data conversion programs to

bring the data from legacy systems to PeopleSoft Purchasing Tables.

> Resolved the issue where the delivered invoice (BIGIVCPN) is restartable

if an issue like deadlocking occurs. The custom invoice (NIGIVCPN) does

not restart but instead fails on a 'cannot insert duplicate rows in

PS_BI_BILL_LST_TMP.

> Resolved the issue where the delivered invoice can generate multiple

invoice type (GM_GEN, GM_FIX, etc). The custom invoice abends when trying

to generate multiple invoice types.

> Resolved the issue where if a BIJOB03 fails in the BIIVC000 step, cleanup

is done on the 'stuck' rows and a new run control is set up, the

subsequent BIJOB03 will not generate an invoice in the NIGIVCPN step. It

updates the IVC_PRINT_FLG stating an invoice was generated but it will

not actually print the invoice. To print the invoice, the reprint must be

used.

> Did some custom changes for the Invoice Extract Process (BI_IVCEXT)

application engine based on the requirements.

> Involved in unit testing and given 24/7 Production Support.

Environment: PeopleSoft Financials 8.4/9.0, (Accounts Receivable, Billing,

GL, AP, PO), SQR, Application Engine, Crystal Report, Oracle

Cynosure Technologies LLC, Houston, TX

Apr 2006 - Dec 2007

PeopleSoft Developer, internship/CPT

Client: Sprint Nextel (Oracle - Implementation Partner), Overland Park,

Kansas

Responsibilities:

> Did analysis of bundles (B14), patches (MP3, MP5, MP6) and fixes to

determine the impact on the customizations.

> Worked on different Custom Accounts Payables SQR and People code Analysis

to meet the requirements.

> Customized Payables Crystal Checks.

> Worked on the Purchasing POPO005.sqr

> Customized the SQRs in Purchasing according to the needs of the client

(Dispatch of Purchase Order-POPO005.sqr and Request for Quotes-

PORFQ01.sqr)

> Designed, Developed & Tested an Interface to load Purchasing data from

Purchasing Net - a Third Party Purchasing System to PeopleSoft AP to

create Vouchers and also Load Asset Information to PeopleSoft AM.

> Worked on Production Support team monitoring the daily PeopleSoft

Purchasing module and processes.

> Perform Integrated testing with creating of PO's, dispatching PO,

Matching PO's, Setting up Vendors testing various forms of dispatching

PO's.

> Worked on compare reports on Pages, Record People code and AE for

Accounts Payables and Purchasing modules.

> Worked on FS_JGEN process.

> Added a Custom Step in Accounts Payables Voucher Build Application Engine

Program to set the SINGLE_PYMT_FLG in the PS_PYMNT_VCHR_XREF Table in

order for the checks to be printed in the Payee's Name instead of the

Vendor's Name for Single Pay Vouchers.

> Supported the regression testing team where merging of Nextel and Sprint

data is being implemented to fix any issues that needed technical

assistance.

> Supported UAT Team to resolve the defects and provided the necessary

technical assistance.

> Worked on the service desk system and given 24/7 Production support.

> Worked on Synergy Defect Tool to assign and solve the defects.

Environment: PeopleSoft Financials and SCM 8.9, (GL, AP, PO, AR, BI,

Inventory), SQR, AE, People Code, Crystal Report, Oracle.

Client: St. Petersburg College, Seminole, FL

Responsibilities:

> Involved in Designing, Developing and upgrading the reports in PeopleSoft

Financial module.

> Worked on various people tools such as App Designer, SQR, Crystal,

PS/nVision, Tree Manager and PS Query.

> Upgraded the hard coded PS queries, which are based on Fiscal Year and

Ledger group to make them run at any time.

> Upgraded the PS/nVision reports which are hard coded based on the Fiscal

Year and made them to run according to As of Date as input parameter.

> Created customized fields in app designer according to the requirement.

> Design and Developed a Crystal report for Purchase Order Line Report,

which takes 9 values as input parameters.

> Created various time spans in PS Financial for the purpose of using in

PS/nVision reports.

> Created a Job Process for Purchase Order Line Report. In this an SQR

process is designed and developed where it fetches the rows from

different records by join's and stores in a temporary record, by using

this temporary record the crystal report is generated.

> Worked on the Asset Management problem where the asset status was not

retired even though the asset was retired. Debugging was done to find out

the problem and resolved.

> Designed and developed PS/nVision report for Budget and Revenues by fund.

> Designed and developed detailed PS/nVision report for Budget and Revenues

by period taking YTD as time span and input parameter as of Date. And

based on run time values charts are generated.

> Designed and Developed PS/nVision Budget and Revenue Summary report for

different type of Funds for a particular Fiscal Year taking input

parameter as 'As of Date'.

> Upgraded the PS/nVision report for Lab and Fee Analysis according to

client requirement.

> Modified the run control pages in app designer according to the client

requirement. Designed and Developed Run control pages, components and

portal registry for some of the crystal reports.

> Created crystal report for Transaction details - Actual.

> Analyzed the commitment control for budgets and tested the data in

financial module.

> Involved in developing SQR process to move the values from records to

records.

> Created views and customized records in app designer for using in

particular reports

> Upgraded the PS/nVision report Monthly Organization Budget & Actual

(MOBUDA) status for a particular fiscal year where the scopes are

defined.

> Designed and developed a Budget Amendments report in Crystal based on

their requirements.

> Solved some issues in the Year to date trail balance PS/nVision report

where some fund values doesn't list anything and done changes according

to client requirement.

> Analyzed, Modified and Written PeopleCode to do some validations on some

pages based on the client requirements.

> Migrated Projects in different environments.

Environment: PeopleSoft Financials 8.9/8.8, (GL, AP, AR, PO, AM, Budgets),

SQR, PS/nVision, People Code, Crystal Report, and Oracle.

OSG Infotech, India May 2004 - Jul 2005

Role: PeopleSoft Consultant

Project: Involved in the implementation of PeopleSoft Financials and

Developing

Applications

> Involved in Design and Development of conversion programs using SQR for

transferring data from Legacy system to PeopleSoft Financials.

> Creation of new panels and customization of existing panels using

Application Designer, importing data into client database, generating

SQR's for reporting.

> Wrote custom Time and Labor SQR report which would print time and labor

spent on each project and its activities. Subtotal for each activity and

total for each project and grand total for the whole report.

> Used data audits for each and every modification made to the system.

> Responsible for creating and modifying Process scheduler job definitions,

creating new end user reports and the enhancement of PeopleSoft reporting

capabilities using the online and batch reporting tools.

> Built new business navigator to access the new panels taking care of

operator security. Attached the new panels to the Menus and implemented

security using Security Administrator.

> Troubleshooting various Crystal reports error message and adjusted the

registry settings, configuration manager settings and developed custom

reports using SQR and Crystal.

> Well versed in utilizing Debugger, tracing tools for trouble shooting

issues on PeopleCode, Application Engine and SQR's.

Environment: PeopleSoft Financials 8.4 (AP, AR), HRMS, People Tools 8.14,

People Code, SQR, Crystal and Oracle 8x.

Contact this candidate