Ph: 505-603-4675 Kishore Katta

[email protected] ERP- Technical Consultant

Annapolis. MD

Experience Summary
Roles Certified PeopleSoft Technical Consultant with over 15 years
 Interface/Conversion Lead of extensive PeopleSoft FSCM, HCM, Campus Solutions
 Senior Technical Consultant implementations and FSCM upgrade experience for public
 Lead Developer sector including extensive design, development, testing,
 Upgrade Specialist technical team management and developer training. Worked
 Procure To Pay specialist extensively on FSCM Procure to Pay modules along with
 Technical Lead interfaces, conversions, bolt-ons and technical support with
strong functional experience with integration of Financials and
HCM along with end user training for transactional data entry.
Industry Experience
 Government Agency/Public Sector
 Financials/HCM/Campus Solutions Technical Proficiency:
 Higher Education  PeopleTools
 Supply Chain Management  Application Engine
 People Code
Education  Component Interfaces
 SQL/SQR
 Bachelor of Science, Engineering,
University of Madras  AWE
 BI Publisher
 Diploma in Advanced Computer
Science  Web Services
 Excel to CI
Training/Cerifications  Integration Broker
 Crystal Reports
 Peoplesoft Certification - 2003  Stat 5.6.4/SharePoint
 Application Engine Certification  VB, Aspx, .net
 Oracle 10g/11g and SQL Server 2010
 Windows 7, UNIX
Module Experience:
 Accounts Payable
 AR/Billing
 Purchasing/ePro Employment History:
 General Ledger  Consultant for State of DE – Jul-2014 to Present
 Commitment Control (KK)  Consultant for PA Treasury – Jan-2014 to Jun-2014
 Project Costing  Consultant for State of DE – Jan-2013 to Dec-2013
 Grants Management  Cherry Road Technologies - Oct-2010 to Dec-2012
 Asset Management  MAXIMUS, Inc – Aug-2002 to Sep-2010
 Campus Solutions  P.B Systems, Inc – Jun-1998 to Jul-2002
 HR/Payroll/T&L

Page 1
Ph: 505-603-4675 Kishore Katta
[email protected] ERP- Technical Consultant
Annapolis. MD

Project Experience

Client: State of Delaware Jul-2014 to Current

Role: FSCM 9.1 Techno Functional Consultant
Environment: PeopleSoft FSCM 9.1, Tools 8.51

GL/AP, PO , AR/Billing - Techno Functional role.

 Enagaged with State of DE as a Techno Functional consultant assisting with

requirements gathering,technical analysis, design, development, testing, end user training
and trouble shooting production issues.
 Design and Develop custom Interfaces between Peoplesoft FSCM and external
organizations.
 Monitor Nightly batch jobs and resolve any issues related to batch jobs, resolve Application
issues, resolve Data issues and work with DBA team.
 Provide production support including issue resolution in a timely manner and perform
functional analysis and estimates for enhancement requests.
 Perform complete lifecycle testing and document the code changes and perform tuning for
slow running processes.
 Provide functional end user training on new requirements, data entry and technical
assistance.
 Functional knowledge of PeopleSoft General Ledger, Accounts Payable along with,
Purchasing, eProcurement, AR/BI, Project Costing and Contracts.
 Designed, configured and tested ACH and check payments with PNC/Bank of America.
 Proficient with PeopleSoft Tools, Integration tools and Change management
 Strong in PSQuery,SQL and SQR skills.
 Working experience in People code, Application Package, Component interface, Integration
Broker, and AWE.
 Experience with ACH layout, payment source and pay-cycle steps, payment handling codes
and payment term timing codes.
 Experience with Vendor categories and withholding codes (1099).

Client: Commonwealth of PA Treasury Jan-2014 to Jun-2014

Role: Lead Technical Consultant
Module(s): GL, AP, Deal Management, Fiscal Review (Custom)
Environment: PeopleSoft FSCM 9.1, Tools 8.52
Treasury department for Pennsylvania primary objective is to implement Peoplesoft ERP with AP,GL and
a custom bolton module(FR) to audit the invoices/payments scheduled by AP and Journals within GL.

I was engaged on this project to design and develop custom work bench to make the payments land
within Fiscal Review module for auditing the pending invoices/payments by different roles/levels.

 Designed and developed custom Interface to select the payments randomly to the work
bench for fiscal review and approvals.
 Designed and developed components for workbench to transfer the Invoice/Payment details
across different roles based on approver actions(Approve, Deny, Approve with exception).

Page 2
Ph: 505-603-4675 Kishore Katta
[email protected] ERP- Technical Consultant
Annapolis. MD

 Developed BI Publisher reports (Query and XML Source) for the Invoice approval history.

Client: State of Delaware Aug-2011 to Dec-2013

Role: Upgrade Technical Consultant
Module(s): GL/KK, AP, PC, GM , AM, AR/BI, PO/ePro
Environment: PeopleSoft FSCM Upgrade v8.9 to 9.1/Tools v8.51
Delaware ERP Upgrade Project was initiated on Aug-2011 with Go-Live target of Oct-2012.
Upgrade involved Financials & HCM from v8.9 to 9.1 along with tools Upgrade from 8.49 to 8.51
As an Upgrade technical lead consultant for Financials, I coordinated with the Upgrade Strategy &
technical tasks involved in the Project Plan. 9,1 Upgrade went live in Oct-2012. Currently working on
applying Maintenance Packs and Post production support.

 Re-apply 8.9 Customizations to 9.1 Development.

 Defect Analysis & Resolution during each test phase.
 Identify testing areas for every test move(Defects, Customizations, Re-Applies, Batch Schedules)
 Involved in testing Req to Check, GM/PC Projects, Awards, Contracts, Budget Finalization.
 SYSAUDIT/DDDAUDIT/Compare Report Analysis & Cleanup efforts.
 Manage/Track Service Requests with Oracle Support.
 Analyze & Test Oracle Patches.
 Design/Develop/Unit test 9.1 Development Requests
 Configured Setup Manager – Implementation tasks to generate DMS Scripts.
 Developed Audit Triggers and Audit reports for Security components.
 1099 – Development/Technical Support for CYR 2011.
 Developed Year end closing and Re-organization of Chartields for Grants module.

Client: State of Delaware Nov-2008 to Jul-2011

Role: Technical Lead/Conversions Lead/Lead Developer
Module(s): GL/KK, AP, PC, GM , AM, AR/BI, PO/ePro
Environment: PeopleSoft FSCM v8.9/Tools v8.49
Delaware ERP Project implementation was scheduled between Jul-2007 through Jul-2010.
I was engaged as a Interface/Conversion Lead for Financials and within 6 months of task completion,
I was promoted as a Technical Lead for the Project. I was involved with the assignments below.

 Developed Conversion Strategy, designed documents, File Layouts, Data Mapping and Conversion
Programs (Vendors, GL Chart fields, Balances, Projects, Project Activities, Grants, CFDA, Assets, AR
Pending Items and Customer Contracts) for Financials using Application Engine and Component
Interfaces.
 Developed interfaces between Financials and the organizations (Payment Voucher Inbound,
Positive Pay Outbound, IV Inbound, BAI, NACHA Inbound, PCard Inbound, PO Items Inbound and
Vendor Outbound ).

Page 3
Ph: 505-603-4675 Kishore Katta
[email protected] ERP- Technical Consultant
Annapolis. MD

 Assumed Technical Lead role for Financials 8.9 Implementation.

 Managed and followed through all technical assignments and took ownership of customer issues.
 Produced weekly status reports; provide updates to the Project Management.
 Engaged in Post-Production support between Aug-2010 through Jul-2011.
 Designed & Developed 1099 Interface to import transactions from external orgs.
 Involved in FYR – Closing and Re-organization development/testing.
 Developed Pcard website to access State Expenses( http://pcard.accounting.delaware.gov)

Client: State of New Mexico Aug-2005 to Oct-2008

Role: Conversions Lead
Module(s): AP, PO, AR, PC, GM, GL, KK, HR and Benefits
Environment: PeopleSoft HCM v8.9, Financials v8.8 and Tools v8.45

 Involved in analysis, design and development of Data Conversions for

o HR, BN and Payroll modules.
o AP, PC, GL, Grants, Inventory.
 Led, tracked and reported all Conversion efforts.
 Coordinated with State leads on legacy data extract efforts, environment control and maintenance
issues.
 Involved in System support, troubleshooting analysis and fixes.
 Designed and Developed work for modifications and reports.
 Resolved defects and coordinated with GSC cases during Post Go-Live support.

Client: State of North Dakota Aug-2002 to Jul-2005

Role: Technical Consultant
Module(s): Recruitment & Admissions, Student Records, Student Financials,
Financial Aid, Grants Management
Environment: PeopleSoft Student Admin/Financials v8.0

 Involved in analysis, design and development of all Data Conversions for Student Admin modules.
 Involved in System support, troubleshooting analysis and fixes. Designed and Developed work for
Grants modifications and reports.

Client: MCI WorldCom

Role: Technical Consultant
Module(s): Payroll, Time & Labor, Benefits
Environment: PeopleSoft v7.5

 As a Technical Consultant he was involved mainly in the implementation and customization of the
tasks related to (Payroll, Time & Labor, and Benefits) sub-modules of PeopleSoft 7.5 Version.
 Involved in Design and Development of Conversion Programs using SQR for transferring of data
from Legacy System to PeopleSoft.

Page 4
Ph: 505-603-4675 Kishore Katta
[email protected] ERP- Technical Consultant
Annapolis. MD

 Involved in troubleshooting the problem areas in setting up HR tables that serve as the foundation
of HR system and in producing HR reports.

Client: University of Phoenix

Role: Technical Consultant
Module(s): Student Administration
Environment: PeopleSoft v7.3

 Developed SQR programs to convert student record data, grades

data and payments data.
 Developed wrappers to batch process Term Activations and Mass Enrollments.

Client: Hewlett Packard

Role: Consultant
Module(s): HP Open view Registration
Environment: ASP, HTML, Visual Basic 5.0, Formula One, SQL Server 6.5, VBScript,
JavaScript, IIS 4.0, and Win NT 4.0

 Designed and developed HP OP enview website for the express purpose of registering HP Open
view support products, enabling customers to register for Standard or Premium Support and
Regenerate Support Certificates.
 Designed and developed OLAP inbound interface Process to automate the purchase orders import
to the database.
 Extensively involved in the customization of web enabled front-end design and backend process
development for Registration Support.

Client: Modus Media International

Role: Developer
Module(s): Supply Chain Management
Environment: PowerBuilder, Visual Basic,SQL Server 6.5

 Performed Development & Support work for SUN Password delivery services (SUNPDS tool is a 2-
tier desktop PB application designed and developed for SUN call center users.)
 Developed Active-x objects using Visual Basic to invoke 3rd party business objects (DLL’s) and
retrieves node locked and concurrent user license codes.
 Designed and developed windows for reporting and invoicing transactions involved for inbound,
outbound, email and fax methods.
 Developed Stored Procedures to execute the command line utilities in order to validate, read,
write and evaluate Sun enabler codes and associated product information.

Page 5
Ph: 505-603-4675 Kishore Katta
[email protected] ERP- Technical Consultant
Annapolis. MD

Page 6