Manager Process
Resume:
SRIKANTH REDDY
SUMMARY
Over eight years of consulting experience in various aspects of Software
Development, Testing, Implementation and Technical Support of software
system with the past seven years focused exclusively in PeopleSoft
Financials/SCM/EPM. Expertise is in design, development, interfacing,
tuning, upgrade and maintaining large scale information systems. Proficient
in PeopleTools (version 7.6/8.4), Application Designer, PeopleCode, Query,
Process Scheduler, Import Manager, Integration Tools, Data Mover, Security
Administration, SQR, nVision and Crystal Reports.
EDUCATION
. MS in Computer Science
. BS in Electrical & Electronics Engineering
SKILLS SUMMARY
PeopleSoft Financials/SCM/EPM release 7.53 and 8.4/9.0 (Modules: Billing,
AR, GL, AP, KK, Project's and AM, PO, OM and IN, P&B), PeopleTools, SQR,
PeopleCode, Application Designer, Application Engine, Application Server,
Component Interface, Process Scheduler, Process Monitor, Data Mover, PS-
Query, nVision, Security Setup, Crystal Reports, Workflow, Configuration
Manager, SQR 3.0/4.0, Crystal Reports 6.0/7.0/9.0, XML Publisher,
PeopleSoft Query, Tree Manager, SQL Server 8 / 7 / 6.5 and Oracle
10g/9/8/7, DB2, C, C++, COBOL, SQL, PL/SQL, Windows 95 / NT / 2000, MS-DOS,
OS-390, UNIX, Sun Solaris, Ascential DataStage 7.5.
EXPERIENCE
Mar. '05 to Till Present VITA, Chester, VA
Consultant
. PeopleSoft 8.4/9.0 Financials (AP, AR, AM, PO, KK and GL), EPM 8.9
(Planning & Budgeting) Upgrade, implementation and support
. Worked as a Lead on the technical-side for some of the smaller
projects and as a hands-on developer for larger initiatives
. Worked with the vendor running change assistant and upgrade scripts
for Financials Upgrade from v8.4 to v9.0 MP6
. Good understanding of PeopleSoft business functionality, to help users
use the PeopleSoft application and perform and maintain their
transactions and do complete reconciliation.
. Helped the client with best practices in reporting and usage of new
reporting tools like XML Publisher.. etc delivered with the new Tools
version.
. Analyzed the existing processes and implemented and Setup the
functionality required by the client, and train users.
. Analyzed the processes and bottle necks in the current system and
suggest better designs to implement the changes, which would highly
improve the processing times and business needs with minimal
customizations.
. Designed and documented functional and technical specifications for
the client's needs
. Helped client enable budget checking in commitment control at the
Dept_id and Fund level
. Worked on Production support issues as to why the transactions fail,
and help users to rightly process the information in the system and on
time.
. Applied bundles and stand alone fixes
. Recommended various tune-ups to the client, modified processes and SQL
to improve performance
. Created and Analyzed App engine and PeopleCode trace files to modify
or customized delivered functionality
. Worked on customizing ETL's and running ETL jobs to make EPM v8.9
compatible with the new Financials upgraded version (9.0)
. Migrated customized ETL's from one environment to the other.
. Customized EPM related processes for client's Business needs
. Customized BP_EXP app engine process in EPM to create distributions in
chartfields in Financials.
. Assisted the users in setting up budgets each year. In the process,
checked for inconsistencies in the setup values and suggested the user
to in configuring the budget correctly.
. Developed new interfaces from scratch to import data from third party
systems into PeopleSoft
. Used Integration Broker to synchronize vendor information from
PeopleSoft to external agencies
. Wrote multiple component interfaces to import Purchase Orders,
Receivers from third party systems
. Led the team in creating file layouts and customizing AR_Dunning App
engine program to send emails to users on information regarding
dunning letter recipients and the amounts owed
. Customized the Journal import file layout to add custom fields
. Customized delivered application package PT_Branding to display the
User name and the database logged into to avoid confusion for the
users. Also created Watermarks for the PeopleSoft environments
. Implemented the Journal Voucher functionality to edit and correct the
chartfield information for vouchers already sent to the third party
system
. Involved in direct support to the users on Production issues related
to all the Financial modules
. Wrote an Application engine program and created a job definition to
release the temp tables held by the GLPPPost Process
. Led the team in designing and developing a new conversion program that
imports all Transitioned Assets which were added as a result of new
agencies integrated to the client
. Designed and implemented Workflow for Purchasing.
. Ran the conversion programs and tracked the asset flow during
Depreciation and distribution to GL
. Worked extensively on support issues related to vouchers and Matching
and Pay cycle processes. In the process, created new vouchers and
budget checked and posted them.
. Worked extensively on support issues related to Pending items, AR
Update and Payment Predictor. Applied bundles during the Upgrade
process to resolve upgrade related issues.
. Created and customized the reconciliation processes to reconcile the
data between GL and other Financial modules
. Modified various Aging Reports to reformat the report and add new
criteria
. Customized the Group Control page and GRP_AP table in AP to add a new
field called Batch Type to track groups sent to a third party system
. Led the team in implementing functionality to Import Voucher data from
external system to track Travel & Expenses of the employees and
compensate them
. Created database links between the external T&E system and PeopleSoft
V9.0, Oracle 10g database to interface information between PeopleSoft
AP and T&E
. Tested end to end functional flow of reimbursing expenses with the
users
. Enabled single sign-on to login to EPM and financials environments
easily. Used portal to see links related to EPM directly from
Financials.
. Received formal training from PeopleSoft Corporation to support the
client with non-peoplesoft related Budgeting modules and eventually in
the EPM modules(Budgeting, Business Planning)
. Performed the role of a security administrator to create and assign
new roles and permission lists to the users
. Involved in designing and planning with the Accounting and the
functional managers
. Worked with Database and system admin to resolve issues after a
database refresh
. Suggested System admin to clean up Web server cache to clean up
unwanted URL's that were removed in permission lists
. Worked with database admin to clean up corrupted segments in the
database
. Involved in designing and modifying test scripts during EPM
implementation and Financials Upgrade from v8.4 to v9.0
. Performed Unit testing after all development and worked with users and
Functional Lead during Integration testing.
. Created new test scripts when a new project and customizations were
implemented and suggested user on the expected results and the changes
that need to be anticipated. Made sure that all new customizations
were thoroughly tested from end to end i.e. creating transactions,
posting them and completing downstream processing and then send the
data to GL.
Environment: Windows NT, PeopleSoft Financials (8.4) SP1, (9.0) MP6, EPM
8.9, PeopleTools (8.43.10, 8.46.05, 8.49.13), SQR, SQL, PeopleCode,
Application Engine, Portal Technology, Component Interfaces, Crystal
Reports, Security Administration, Oracle 8i/9i/10g, Ascential DataStage 7.5
Nov. '04 to Feb. '05 GAF Materials Corp, Wayne, NJ
Consultant
. PeopleSoft 8.8 Financials/SCM (AR, BI, OM, IN) implementation and
support
. Developed and wrote multiple SQR's from scratch on multiple Database
platforms at the same time, interfaced from PeopleSoft OM and IN to
the third party system
. The SQR's dealt with InterUnit transfers as well as regular shipments
to end customers.
. Created online pages and menu definitions to maintain the control
tables and run control pages used by the SQR's
. Used Data Mover to run scripts and move data from one environment to
the other
. Wrote PeopleCode to schedule the SQR's directly from the Load
Maintenance pages depending on the business functionality criteria
. Customized the OM modules to automate Load_id creation when an order
is saved
. Created new orders and posted them into IN. Ran the reserve materials
process and generated Pick plan Reports. Increased item quantities
through Express Putaway to ensure there is enough quantity to be
reserved.
. Updating the Specification designs and strategies
. Wrote an Application Engine program to interface all production
details into a flat file
. Ran PeopleCode debugger on 2 tier to trace the results of the
Application Engine program
. Created indexes and modified SQR's to improve the performance of the
processes
. Interacted with the users and functional team
. Involved in Unit testing and complete integration testing with users
Environment: Windows NT, PeopleSoft Financials/SCM (8.8) PeopleTools
(8.45.06), SQR, SQL, PeopleCode, Application Engine, Portal Technology, SQL
Server and Oracle 9i
Aug. '04 to Oct. '04 Combe Inc., White Plains, NY
Consultant
. Implemented and supported PeopleSoft 8.8 SP1 Financials/SCM(AP, AR,
BI, GL, PO, OM and IN)
. Customized the BI_Entry component to look up the ID table with
Products. This would allow users to create Online Bills based on a
product
. Modified the SFS2003.SQR to print Bar codes for Lot Id's based on an
Item and Business unit
. Applied bundles to some of the delivered SQR's
. Customized the Recv_PO Component to auto assign Lot ID's during PO
Receiving
. Modified the Pick Plan Selection criteria to get details of all orders
for a Corporate Customer and for the date shipped. Modified the Page
to add the new criteria and fields and customized the INS6000.SQR for
reporting
. Used Integration Broker to send invoice information from PeopleSoft to
external system
. Wrote a lot of Peoplecode for customizing the applications
. Ran PeopleCode debugger on the portal to check the functionality
. Used the PeopleCode trace to check for the technical flow of the
application
. Worked on Query tools, to create new queries
. Wrote PeopleCode to update the Inspection status in Recv_Inspect page
based on the available status of the lot control information
. Worked on the Donavan Interface, this interface picked details from a
Legacy system as flat files and posted the information to the GL
Tables
. Customized invoices-US, Canada and International that came from
Billing to enhance the Business Functionality of the Client's Invoices
. Worked on a Go-Live Support role solving issues that came up during
implementation
. Involved in unit and system testing with Functional lead and users.
All customizations or new development were migrated only after a
satisfactory sign-off from the Users
Environment: Windows NT, PeopleSoft Financials (8.8) SP1 PeopleTools
(8.45.06), SQR, SQL, PeopleCode, Application Engine, Integration Broker,
Portal Technology, Crystal Reports, SQL Server
Feb. '04 to June '04 Broadcom Corporation, Irvine, CA
Consultant
. Worked on PeopleSoft 8.4 Financials/SCM(AP, AR, PO, T&E, GL, OM and
IN) Implementation and Support
. Strong knowledge of the PeopleSoft PeopleTools, PeopleSoft Portal
Architecture, SQL, and Application engine
. System enhancements experience in terms of customization, business
process improvement and implementation using PeopleCode; reports/Query
creation and modifications using PS-Query/SQR/Crystal and various
PeopleSoft tools
. Created customized Portal to request SQL Migrations to the DBA between
different environments
. Created new tables and pages to implement the business functionality
. Wrote PeopleCode to trigger email notifications to the DBA and the
requester once the SQL Migrations are requested and then completed
. Wrote PeopleCode to insert vendor phone and fax information into the
vendor tables directly from the Express Purchase Orders page
. Developed interfaces on both inbound and outbound to load data from a
legacy system into the PeopleSoft System
. Wrote Application Engine Programs to get Vendor Information, Purchase
Order information, Item information and to generate reports
. Used row sets functionality to get the information from the PeopleSoft
tables and load the scroll areas
. Used Component Interface & File Layouts in Application Engine program
to automate the Asset Entry process for adding new assets into
PeopleSoft
. Used PeopleCode debugger on the portal to check the functionality and
to trace and check for the technical flow of the application
. Created new Business functionality to enable QA to control Shippable
FAB and Assembly combinations of materials to Customers
. Designed, developed and tested the ability to generate voucher
payments in AP to external recipients for HR employee wage
garnishments. Added the extra functionality for the voucher batch
process to import payment messages from HR to AP for the garnishment
vouchers.
. Collected the requirements designed and implemented a custom interface
between AP and PAYROLL to accept employee reimbursements and cash
advances from AP and add to employee paycheck. Functionality includes
the ability to mark the vouchers with the Payment information from HR.
Also added the ability to void/cancel the payments. Configure and
troubleshoot Integration Broker and Application Messages in the
development process.
. Created new page and wrote peoplecode during Material Picking
Feedback, to control shippable combinations for the above
functionality.
. Entered new vouchers and ran the AP_PSTVCHR application engine to post
the vouchers, and ran the AP_PSTPYMNT application engine to Post the
payments
. Setup employees as Vendors and implemented workflow for expense
approvals
. Interfaced data from Expense module and created payments in AP to
reimburse employees for their expenses.
. Created new expenses and tested end to end processing of payment
creation and payment in AP
. Created new Crystal Reports to get information from Order Header And
Order Line tables to get Open and Pending Orders, which have not been
shipped
. Created new tables and pages to implement the business functionality
. Used Query tool, to create new queries
. PeopleSoft security setup in PeopleSoft 8.4. Worked on Security
profiles to create new Permission Lists and Roles, to assign it to the
users. Interacted with the users to find out the Access they need to
create new profiles
Environment: Windows NT, PeopleSoft Financials (8.4) PeopleTools (8.43.02),
SQR, SQL, PeopleCode, Application Engine, Component Interface, Portal
Technology, Crystal Reports, SQL Server
July '03 to Dec. '03 Ernst & Young LLP, Lyndhurst, NJ
Consultant
. Implemented and supported PeopleSoft 8.4(AR, BI, GL) Financials
. Customized AR update as per the design specifications for a Global
Financial Implementation System (GFIS). The customization was part of
the Project - Single Line Item in AR
. Customized User Defined Fields to display only as part of the Single
Line Item in AR
. Tested the AR Dunning and AR Overdue Application Engine processes to
see if they had any affect on the single line item in AR
. Ran the Application Engine Trace Files for testing the processes
. Setup Dunning methods, letter codes and deposit units for testing the
Dunning and Overdue application engine processes
. Customized the AR Balance Report (BARR0265) to modify the entry
amounts, base amounts as per the new distribution codes in single line
Item in AR
. Tested various reconciliation reports like (BGLU0207.BGLU0198,
BGLU0211, BGLU0212, and BARR0297 Etc) to find the effect of the
Single Line Item in the Reports
. Tested the Banking Interface (BARU0475) to validate and load data into
the AR Tables that came from the Local Systems as Bank Swift Files
. Tested the GL Business Units for the Canada bank configuration setup
. Created new Invoices and applied payments to the invoices using
different Worksheets. Ran the AR Update process to post the payments
for the invoices as part of testing the Single Line Item in AR
. Online customizations in the financial modules to implement new
functionality
. Pre QA testing to ensure that the customizations were working fine in
GFIS
Environment: Windows NT, HP-Unix, PeopleSoft Financials (8.4) PeopleTools
(8.42.07), SQR, SQL, PeopleCode, Application Engine, Portal Technology,
Component Interfaces, Crystal Reports, Security Administration, Oracle 9i
June '01 to May '03 California State University,
Mits, Inc., Cypress, CA
Consultant
. Developed interface that will be used to generate the flat file with
details of all checks for payment and cancellation. This was used for
the Bank Reconciliation by the Client
. Developed a conversion program for the Client which generates a file
that gives the information about the payment amount total on the
payment type like whether its the express check or other and also it
gives the total of the amount paid and the total of the canceled
checks on a day-to-day basis
. Worked on Query Tools, to create new queries and wrote new Crystals by
creating queries
. Worked on voucher origins, Voucher Build Criteria, Match rules etc.
. Performed development tasks using most Application Designer Tools
(Creating fields, Tables, Panel, Panel Group, Menu, Process
Definition, Access Groups, Security Administration, Object Security,
Query)
. Designed and created Panels, Tables, and Views through PeopleSoft
Panel and Data Designer& reviewed many modifications in coordination
with the teams
. Migrated PeopleSoft objects and projects across multiple development
test production and master databases
. Evaluating PeopleTools functions and test results to ensure
conformance to design requirements and point out design corrections as
necessary
. Developed and conducted a variety of tests to verify the
functionality, performance and accuracy of designs
. Used PeopleCode extensively for changing functionality and developing
new functionality
. Developed SQR's to Convert data coming from legacy system into
PeopleSoft System
Environment: PeopleSoft Financials (7.5), Application Designer, PeopleCode,
Query, Process Scheduler, Import Manager, Integration Tools, Data Mover,
Security Administrator, SQR, nVision and Crystal Reports, Oracle
TRAINING
. Introduction to EPM/EPM Warehouse Foundations Accelerated w/online
content through PeopleSoft Corp.
CERTIFICATIONS
. Brain Bench certified in PeopleTools v8.4
Contact this candidate