Project Functional Consultant

Lakshmana Katram

201-***-****(C)

abm6vg@r.postjobfree.com

PROFESSIONAL SUMMARY

. 10 years of Experience in analysis, design, development and

implementation of computer software applications in the areas of

PeopleSoft Financials and Distribution

. Extensive experience in design and development of applications under

Unix, Linux, Win2000/98/95/NT and MSDOS environments. Excellent skills in

developing Client/Server applications

. 7 years of experience in PeopleSoft financials 7.5/8.0/8.1.6/8.4/8.8/9.0

Development, Customization and Production Support. Experience in

Financials with very strong technical expertise in, People Tools, People

Code, PS Query, PS/nVision and Crystal Reports

. Solid experience in Application Engine, Component Interface, Integration

Broker, Application Messaging, SQR, Crystal, nVision, PeopleCode,

Portal, AppDesigner

. Debugging existing pages, SQRs, Application Engine, Component Interface,

Messages, Comparing/Upgrading projects and migrating objects from

development to test and production databases

. Good Functional knowledge in Financial modules

. Developed Database applications using Oracle, SQL Server, and MySQL.

Strong knowledge of RDBMS

. Extensive experience in SQL, PL/SQL, Stored Procedures, Functions,

Triggers

. Extensive experience in developing test conditions and test scripts,

conducting system testing

. Knowledge in testing Performance, Load for Web and Client/Server

Applications

. Good analytical skills, trouble-shooting skills and high learning

aptitude. Adept at multi-tasking

Strong communications and inter-personnel skills. Innovative and

perfect team player

TECHNICAL SKILLS

ERP: PeopleSoft Financials (GL, AP, AR, AM, Project Costing, Contracts,

Grants, Commitment Control)

PeopleSoft SCM (BI, OM, INV, Purchasing, e-Procutrement)

7.02/7.5/8.0/8.4/8.8/8.9/9.0

PeopleSoft HRMS (HR/ Payroll/ Benefits/ Time and Labor)

GUI Tools: People Tools 7.06/7.5/8.12/8.4/8.44.08/8.45 (Application

Designer, Portal, Application Engine, Import Manager, Data

Mover, Process Scheduler, Tree Manger, Query Manager

Maintain Security, Business Inter Links, Application

Messaging, Portal

Reporting Tools: SQR 4.x/6.x, P/nVision, Crystal Reports

Languages: People Code, C, C++, Java, PL/SQL, SQL, and VB

RDBMS: Oracle 7.x/8.0/8i/9i, SQL Server 7.0, Sybase

Operating Systems: WINDOWS NT/95/98/2000/XP, Unix, Linux, Solaris

Web Technologies: JavaScript, Visual InterDev, Servlets, JSP, Hammock,

XML, CGI, Perl, HTML

Packages and Tools: Vision Click, MS Office, Cadence Tools

Networking Protocols: CSMA/CD, TCP/UDP, SNMP, OSPF, RIP, ATM

Versioning System: CVS, Visual source Safe, STAT

PeopleSoft Techno-Functional Consultant - Fannie Mae, MD

Duration: Sep.09 - Present

Environment: PeopleSoft Financials/SCM/HCM 8.4/9.0, AR, BI, AP, PO, AM, GL,

ePro, People Tools, SQR, PIA Architecture, WindowsXP, Oracle 10g, SQL,

PeopleTools 8.49, Crystal Reports, Remedy 6.03, STAT 5.4, Unix, Mainframes

Responsibilities:

. Resolving helpdesk tickets in AR, BI, AP, PO, AM, GL

. Designed inbound and out bound interfaces for multi family Mortgage

System to/from PS AR

. Created Unix Shell Script to transfer various files

. Created automated jobs

PeopleSoft Techno-Functional Consultant - Covance, NJ

Duration: Apr.08 -Aug.09

Environment: PeopleSoft Financials/SCM/HCM 8.9/9.0 PC, Grants, CA, AR, BI,

T&E, AP, PO, GL, Payroll, Benefits, Time and Labor, People Tools, SQR, PIA

Architecture, WindowsXP, Oracle 10g, SQL, PeopleTools 8.48, Crystal Reports

XML Publisher, ManageNow, STAT 5.3, Unix, Mainframes

Responsibilities:

. Developed interface program to load Grants date to Project Costing

. Resolving VAT related issues in AR, Billing

. Designed functional specs and Developed Archival process for PC Rates

. Configured new accounts, departments, operating units

. Configured VAT % changes for various Business Units in Billing

. Created accounting rules for new business units in Contracts, Billing

. Configured new rates according to the business requirements

. Designed and developed conversion scripts for Contracts, Project Costing,

AR, Billing, T&E (Expenses) modules.

. Configured new product groups

. Developed Component interface program to load market rates

. Created Application message, component interface, application engine

program to load 3rd party data (Accounts) into PS Financials, HCM

. Extensively worked on SOX (Sarbanes-Oxley) Remediation's

. Created update stas for PC_PRICING.

. Configured new payment terms, new calendars,

. Developed and Modified various crystal reports to print invoices like

CVBIPRIN, CVBIMAIHD

. Developed UAT test scripts for PC, CA, BI, AR, T&E, GL modules

. Supported CA, PC, AR, BI, T&E, AP, PO, INV, OM, GL

. Developed interface programs to interface HR to Finance

PeopleSoft Techno-Functional Consultant - Fannie Mae, VA

Duration: Jun.07 - Mar.08

Environment: PeopleSoft Financials/SCM/HCM 8.4/8.8 AR, BI, AP, PO, People

Tools, SQR, PIA Architecture, WindowsXP, Oracle 10g, SQL, PeopleTools 8.47,

Crystal Reports, Remedy 6.03, STAT 5.3, Unix, Mainframes

Responsibilities:

. Resolving helpdesk tickets in AR, BI, AP, PO, GL

. Extensively worked on Cash Processing

. Developed inbound and out bound interfaces for Reverse Mortgage System

to/from PS AR to handle seven new remittance codes in the Servicing

component. This includes configuring New Entry Types, Automatic Entry

Types, Distribution Codes and Remittance Codes.

. Created Unix Shell Script to transfer ACH file, Advice file, Bridge file

to Reverse Mortgage System

. Developed Auto Sys job to schedule the file transfer.

. Developed an inbound interface program from C&D to RSS. This includes

configuring New Entry Types, Automatic Entry Types, Distribution Codes

and Remittance Codes.

. Customized Return process to give details like BU, Remit Code, Cust ID,

Amount for C type, R type returns which are not loaded into RSS AR

system.

. Developed INT801R, INT961R program to interface LASER (Mainframes) and

Servicer, Investor Reporting System

. Created component interface programs to load AR data from other systems

. Created Unix Shell Script to transfer ACH file, Advice file, Bridge file

to LASER(Mainframes)/SIR Systems

. Developed Auto Sys job to schedule the file transfer.

. Customized various Permission Lists, Roles according to the business

needs

. Extensively used STAT to migrate Peoplesoft and other Objects between

PeopleSoft environments

. Extensively used Remedy for Helpdesk, Change Tickets, DB mods

. Extensively worked on SOX (Sarbanes-Oxley) Remediation's

PeopleSoft Techno-Functional Consultant - United Nations (UNDP), NY

Duration: Aug.06 - Jun.07

Environment: PeopleSoft Financials/SCM/CRM 8.4/9.0 GL, Projects, Grants,

Commitment Control, Contracts, T&E (Expenses), Treasury, AP, AR, BI,

PO,INV, OM, People Tools, SQR, XML Publisher report, PIA Architecture,

Windows2000, Oracle 9i, SQL, PeopleTools 8.46, Crystal Reports, MS Excel

Responsibilities:

. Customized PC_AR_TO_PC application Engine Program to pick Exchange Rates

according to Accounting Date to be in Sync with AR

. Involved in Fit Gap Analysis of Projects, Grants for upgrade from 8.4 to

9.0

. Developed XML Publisher report to perform data conversion and import data

from legacy system to PeopleSoft database

. Resolving Grants, Project Costing, Contracts configuration related

issues.

. Prepared functional specifications for the Diagnostic scripts for Grants,

Project Costing, Contracts, to proactively identify and resolve

production data issues.

. Resolving helpdesk tickets in Projects, Grants Commitment Control, AR,

BI, CA, T&E, AP, PO, GL

. Analyzing and Developing enhancements in Projects, Grants, Contracts,

Commitment Control

. Customized Projects Funding (Grants)page for various business

requirements

. Debugging the Application Engine programs PC_TO_KK, PC_AP_TO_PC,

PC_BD_TO_PC, PC_FUND_RES for various helpdesk tickets.

. Developed the custom process for Facilities and Administration

PeopleSoft Techno-Functional Consultant - BearingPoint, Foxboro, MA

Duration: Sep.05 - Jul.06

Environment: PeopleSoft Financials/SCM/EPM/HRMS 8.4/8.8 Projects,

Contracts, Grants, T&E (Expenses), AP, AR, BI, GL, PO, People Tools, SQR,

PIA Architecture, Windows2000, Oracle 9i, SQL, PeopleTools 8.44.08/8.45,

Crystal Reports

Responsibilities:

. Involved heavily in development of tech specification & analysis of

company's business rules

. Configured Analysis Types, Resource Types, Resource categories, Resource

Sub-Categories

. Created functional specs to load Grants data in to Projects

. Created Functional Specifications to calculate Billed Hours and Billed

Amount for Bearing Point Employees, Purchased Labor and Subcontractors.

This is a replication process to Pricing Engine

. Conducted Functional Analysis for Project module to find out

a. Discrepancies in Resource ID field in PROJ_RESOURCE and

CA_ACCTG_LINE_PC

b. Discrepancies in ECO, EFR (Fringe Rate) Analysis Types in

PROJ_RESOURCE and CA_ACCTG_LINE_PC

c. Discrepancies in Source Analysis Types and Target Analysis types in

Rate Template configuration

. Worked with technical specialists to translate functional specifications

into technical specifications

. Developed Revenue (Summary and Detail) Reports

. Developed a SQR report (ARXXDET.sqr) for Unapplied Cash

. Developed an Application Engine program (XX_AR_UPDCLN) to clean payments

for AR_UPDATE

. Implemented the process concerning data inputs from flat files to Core

AR/Billing tables for developing reports on Revenue & Expenses forecasts.

. Developed Extract programs for AR, BI, CA, T&E using SQR.

. Customized the Project Cost reports to include new Analysis types,

Resource Types, Resource Categories

. Designed functional Specifications for Defense Contract Audit Agency

(DCAA) Reports

. Designed Functional Specs for CPRI (Cost Plus Rate Impact) for

Government, Commercial Contracts

. Developed UAT scripts to test the reports

. Used EMP environment to test the reports

. Identified and solved the issues in integrating PO, AP with Projects and

T&E (Expenses), Contracts with Projects

. Prepared Test Scripts for PC, CA, BI, AR and GL both module specific and

integrated

PeopleSoft Techno-Functional Consultant - WCB, State of New York, Albany,

NY

Duration: Aug.04 - Sep.05

Environment: PeopleSoft Financials/SCM 8.8SP1/7.02 for Public Sector,

Grants, PC, CA, AP, AR, BI, GL, AM Inventory, Purchasing, People Tools,

SQR, PIA Architecture, Windows2000, AIX5.1/5.2, Sybase 12.5, SQL,

PeopleTools 8.44.08/8.45/7.06, Crystal Reports, Embarcadero Rapid SQL

7.2.1, Convoy/DM 3.7.2.3

Responsibilities:

. Involved in Peoplesoft Financials upgrade from 7.02 to 8.8.

. Implemented Accounts Receivable, Billing and Accounts Payable

applications

. Responsible for the implementation of AP Claims, AR CARS (WCB Billing

System) in PS 8.8

. Performed Gap Analysis and was responsible for finding the gaps between

the legacy systems and Peoplesoft Financial Applications

. Working with the Compare Reports

. Configuring the systems for AR, AP Claims and AR CARS (WCB Billing

System) Creating SETID's, Business Units, Record groups

. Involved in the setup of Receivables processing options such as Origins,

entry types, and entry reasons etc.

. Data mapping for Grants, PC, AR, BI

. Developed the scripts for F&A in Grants

. Re-engineering of AP Claims, AR CARS to change all the transactional data

keyed by SETID to Business Unit

. Maintained the pending item and posted item tables once the pending items

are posted in AR

. Analyzed and Customized all the Records, Pages, Processes, Reports

according to the Control and Transactional Data

. Setup of valid Special Fund and Program combinations and the rules for

use with AP Claims Case and Pay Requests; and Setup of a Department

Chartfield value to be used as the default value on Pay Requests

. Created a functionality to capture pay request information

. Designed and Developed Interface Program to Load Vouchers from AP Claims

and Created new SQR WCBVCUPD.SQR to update the vouchers with Case number

and Pay Request Number

. Developed AP Claims interface for 1099 Vendors.

. Customized the Payment Handling code according to the WCB rules

. Designed and developed various Processes to calculate Base Factors,

Assessment Calculations, Base Factor Adjustments, 5th Quarter Adjustments

using both App Engine and SQR

. Designed and Developed Interface Program to Load Pending Items from AR

CARS(Carrier Assessments )

. Designed and developed AP Claims to Treasury interface using SQR.

. Designed and developed AR CARS to IC interface.

. Created Accounts Tree for AP Pay Requests and migrate to other Databases

. Created Set Control Values and Record Groups

. Developed the FMIS Enhancements of various Processes, SRQ reports and

Crystal reports

. Customized the WCB Collections program in PS7.02 and upgraded to PS88.

This Programwill Interface FMIS, IC and Collection agencies. Proxy tables

were created to pass information between IC and FMIS Flat files will be

sent via FTP to the Collection agencies. Customized and upgraded the

WCBCOLL.SQR, WCBRCDB.SQR, WCBRCWC.SQR, WCBIC9100.SQR, WCBIC9101.SQR,

WCB9102.SQR, WCB9103.SQR, WCB9104.SQR, WCB9105.SQR

. Worked with SYSAUDIT and DDDAUDIT reports in analyzing the data

redundancy and identifying the inconsistencies and orphaned objects

. Performed Data Conversion Using Convoy Tool

PeopleSoft Techno Functional Consultant - Entertainment Publications, MI

Duration: May.04 -Aug.04

Environment: PeopleSoft Financials/SCM 8.4, AR, BI, AP, GL, PO, OM,

Inventory, Purchasing, and People Tools, SQR, PIA Architecture,

Windows2000, UNIX, Oracle9i, SQL, PeopleTools 8.43, Crystal Reports

Responsibilities:

. Customized Accounting Entries Report (AR50001.SQR) to add in the criteria

From Account, To Account, Customer Group, Product Group (Campaign),

Industry etc.

. Customized Payment Detail Report (AR20002), Aging Detail by Business Unit

(AR30003) to run the report by for Customer Group, Product Group and

Industry

. Designed functional Specifications and Developed SQR (Lockbox) interface

for the different Banks to load into the staging tables

. Customized the Order Management to Restrict the user from creating RMA

line for qty greater than shipped qty and make sure that total returned

qty is not greater than total shipped qty

. Customized Order Changes to not allow changes to the sales order lines

after the line has been released to ACCESS for fulfillment

. Created security for the AR, BI users

PeopleSoft Consultant - United Health Group, MN

Duration: Jan.04 - May. 04

Environment: PeopleSoft Financials 8.4, SCM - Projects, Contracts, AR, BI,

AP, AM, GL, PO and People Tools, SQR, PIA Architecture, Windows2000, UNIX,

Oracle9i, SQL, PeopleTools 8.41.03, Crystal Reports

Responsibilities:

. Involved in Data Conversion and loading of Customer tables like

CUST_DATA, CUST_BILLTO, CUST_SHEX-DT, CUST_CONTACT using SQR

. Customized the AR Lockbox Program for the new Lockboxes sent by the Prime

. Customized the AR250001 for the new requirements.

. Customized the Billing interface for new Franchise Customers.

. Customized the BI036UHC.SQR for handling the new Franchise Customer

modifications.

. Customized BI037UHC.SQC, BI038UHC.SQC, BI039UHC.SQC, BI054UHC.SQR,

BI055UHC.SQR, BI014UHCUHC.SQR, BI077UHC.SQR

. Customized the following online(Pages) changes to process the Franchise

customer

USERDEFINED1, INSTALLATION_AR, UHC_CUST_BILLGROUP, CUST_DEFAULTS.

Modified the record level peoplecode, page level peoplecode

Created new records, developed new peoplecode

. Customized the AR25001for Franchise Level Payment Processing. This

modification is to process the Franchise Payment file to load the lockbox

Program so that the Payment Predictor will apply the Payments correctly

for the expected results using the existing algorithm.

. Developed reports using both SQR and Crystal.

. Developed Application Engine program to load data into various staging

tables in customer interface, Invoice Interface.

. Extensively involved in debugging the peoplecode, SQR and Application

Engine.

PeopleSoft Consultant -Peoplesoft Corp. Pleasanton, CA

Duration: Nov.03- Jan.04

Environment: PeopleSoft Financials 8.4 - Contracts, Projects, AP, AR, AM,

GL, BI, PO and People Tools, SQR, PIA Architecture, Windows2000, UNIX, DB2,

SQL, PeopleTools 8.41.03, Crystal Reports

Responsibilities:

. Developed an Application Engine Program to load Business Units in to

Projects

. Developed an SQR to load data missing amendment numbers in a Renewal of a

contract

. Developed a conversion script for new fields added to the Contracts

tables

. Developed SQR and Crystal reports for Contracts module

. Trouble shooting of various process and reports

. In Contracts creating offering lines generated billing plans and revenue

recognition plans

. Trouble shooting and bug fixing of CRM sales to Fin Contracts

interface(App Message)

. Involved in migration of various objects from one database to another and

ran compare reports

. Extensively worked in trouble shooting of Application Engine programs

PeopleSoft Techno Functional Consultant -County of San Joaquin, Stockton,

CA

Duration: Aug.02- Nov.03

Environment: PeopleSoft Financials/SCM 8.4 for Public Sector, AP, AR, AM,

GL, BI and PO, Projects, Grants, People Tools 8.41.03, Portal, SQR, PIA

Architecture, Windows NT 4.0, UNIX, Oracle 9i, SQL, Application Engine,

File Layouts, Crystal Reports

Responsibilities:

. Extensively worked on attaching the developed projects to the Portal

. Developed Functional requirements for uploading data into Project cost

Application Table.

. Developed all the Outbound and Inbound Interfaces with Clearing House

using Application Engine, File Layout Objects and Peoplecode

. Resolving the help desk tickets in Grants

. Integrated all the interfaces with an external scheduler and fully

automated end-to-end between third party and PeopleSoft, without any need

for manual intervention

. Approached the Interface design with the least amount of customization to

existing objects within the application, thus keeping future maintenance

and upgrade efforts minimal

. Developed Application Engine Programs to load Vouchers from various

systems for refunds in to the Peoplesoft System.

. Running Budget checking (Commitment Control) process

. Involved in migration of various objects from one database to another and

ran compare reports

. Developed SQR for Warrant Reconsiliation for Schools and Special distr.

This SQR reads flat file provided by Keane Group containing the fields:

record_type, vendore_id, invoice_id, date, payment_terms, gross_amt and

load them into the staging tables SJ_VCHR_HDR_TAO, SJ_VCHR_LN_TAO

. Developed an SQR (SJAP502) to select vendor data and writes it to a file

00307-02

. Developed an SQR (SJAP503) to select vendor payment information for

Mental Health and writes in to 14311-01 & 4320-01 files.

. Worked with Maintain Security to give permissions and created roles based

on Role Queries.

. Created new custom interface which will load data from flat file into

Peoplesoft Account receivables tables (PENDING_ITEM, PENDING_DST,

GROUP_CONTROL)

. Modified SQRs that have been customized by Client to retrofit the

structural changes in version 8.4 and tested the SQRs using Process

Scheduler and SQRW.

. Developed AR Report's like AR-Payment Verification, Customer Statement,

Payment Detail, and Payment Reconciliation etc.

. Extensively worked with Application Engine, SQR, Crystal, nVision,

PeopleCode, Portal

. Extensively used Application Engine in Debug mode

Client: eSkill Corp, Lowell, MA

Project: Online Testing Application Development

Duration: Jan.00 -Mar.01

Role: Software Design Engineer

The eSkill Assessment Platform is a private-label Web-based solution

for creating job-based skill tests and tutorials that screen job

candidates and manage the knowledge of your internal workforce

eSkill's software is unique in being able to easily customize tests

combining multiple subjects - each at the appropriate skill level and

weighting - to fit a job description or other testing objective

Responsibilities:

. Involved in analysis, design, coding, implementation of software

modules

. Developed an application for eSkill for conducting the On-line

testing in various subjects

. Design of the Database in MSSQL Server/Oracle

. Creation of Tables, Views, synonyms, sequences, indexes

. Writing Complex queries using joins and Optimization of Queries

. Developed JSP/Hammock pages like Registration, login, profile,

Runtest, Answers etc.

. System Testing, Integration Testing, Data Testing

Environment: Hammock, Servlets, Log4J, Java, JSP, JDBC, JBuilder,

Oracle, SQL Server, JRun Servers, HTML, JavaScript, Visual source Safe,

AstraLoadTester, Winrunner

Excelcion, Inc Hyderabad, India

Project: Network Security Tool Development

Duration: Jun.98- Dec.99

Role: Software Engineer

Excelcion is a Network and Information Security (INFOSEC) company.

Excelcion, Inc delivers SigmaGuard Service on a minimum of two high

available Dell record-breaking high performance server appliances

running specially designed software with patent-pending technology and

co-managed. SigmaGuard contains a comprehensive and dynamic suite of

integrated network security software

Responsibilities:

I)

Involved in analysis, design, coding, implementation of software

modules of MySecureOffice

. Design of the Database in MySQL

. Creation of Tables, Views, synonyms, sequences, indexes

. Writing Complex queries using joins and Optimization of Queries

. Developed JSP pages like Email, Chat, RemoteFile Accessing, File

Upload, Address Book, Calendar, daily schedule to-do list, news etc.

. Created Sessions using JSP

. Used CVS extensively

. Self and Unit testing of different modules

II)

Developed a Web-based graphical tool using Perl to control SigmaGuard

remotely. It provides a one-to-one graphical interface to nearly every

service and action needed to maintain SigmaGuard. It is universally

accessible, because it only requires a web browser

. Involved in analysis, design, coding, implementation of software

modules

. Developed shell scripts to implement the Sigmaguard functionality

. Developed JSP pages like Login,

. Develoed modules to control SigmaGuard Users, Servers, System

Statistics etc.

. Involved in Installation and Maintenance of Linux (Mandrake6.0,

RedHat7.0, Caldera2.3)

. Tested the SigmaGuard. Creating the test cases in perl and running the

test cases

Environment: Linux, Java, JSP, PERL, KornShell, Apache, MySQL, OpenSSL,

CVS

EDUCATION

Masters in Computer Engineering

University of Massachusetts Lowell

References: Available upon request

Contact this candidate