Siva Kalidindi 703-***-****
****.*********@*****.***
Summary:
Ten years of IT Experience and Eight Plus years experience in PeopleSoft Financials/SCM, EPM,HCM,
Student Admin, software design, development, and implementation experience, Professional expertise in using of
different PeopleSoft tools like PeopleCode, Application Designer, Application Engine, Component Interface, File
layout and SQR. Over two years experience in Java, Broad Vision, Servlets, and JavaScript, Working Experience in
Java Applets, JDBC, designing and development of web pages with HTML.
PeopleSoft Experience:
• Extensively worked as a Techno Functional consultant on PeopleSoft Financials/SCM (Account Payables,
Purchase Order, Account Receivables, General Ledger, Billing, eProcurement, Project Costing,
Asset Management, Inventory,Order Management), EPM,HCM, Student Admin for over 8 years.
• Strong experience in performing requirement analysis, project planning and design skills including
experience developing technical specifications from functional requirements.
• Experience in PeopleSoft Internet Architecture (PIA), People Tools and tools like Application Designer,
Application Engine, Component Interface, Integration Broker, Application Messaging, Import Manager,
Data Mover, Process Scheduler, Process Monitor, Work Flow and PeopleCode.
• Extensively worked on PeopleSoft reporting and Interfacing with SQR Reports, Crystal Reports,
PS/nVision, PS/Query, Tree Manager and EDI Manager.
• Involved in creating PeopleSoft Inbound/Outbound interfaces.
• Planning technical implementations, customization projects and upgrades, data conversion exercises and
release testing of PeopleSoft Financials.
• Extensively involved in providing security at various levels for different applications of Financials module
and to various users.
• Excellent interpersonal Communication Skills.
Skills:
ERP software PeopleSoft Financials/SCM 8.9, EPM 9.0,HCM 8.9, AP,PO,GL,
eProcurement, PC, Inventory, Order Management and Student Admin.
Products
Tools People Tools, PeopleSoft Security, Application Engine, Application
Messaging, Integration Broker, Process Scheduler, Process Monitor,
Configuration Manager, Import Manager, Integration Broker, Application
Messaging,File Layout, Component Interfaces, Data Mover, SQR, nVision,
Crystal Reports, Query,Quest STAT.
Operating System AIX, SUN Solaris 10, Linux, HP Unix, MS DOS, Autosys
Windows XP/2000/NT/98/95
Databases Oracle 10g, DB2, MS SQL server, MS Access
Languages C, C++. SQL, PL/SQL, Unix Shell and Perl Scripting,
Java, JavaScript, XML Web Services, HTML, DHTML
Education: Post Graduation -M.Tech (Computers) from Andhra University College of engineering,
Visakhapatnam.
Professional Experience
UNDP, NYC, NY. April 09 to till date.
Project: Contractual Reform
PeopleSoft HCM 8.9 & Financials 9.0
PeopleSoft Technical consultant
Responsibilities:
Involved in Payroll configuration changes to incorporate the new Contract types in different formulas.
•
Analyze and customized all the custom reports to incorporate the new contract types.
•
Customize the GP GL interface (UN_GP_GL_PRE) to add new Earning / Deduction Accounts for
•
Temporary Appointment contract type.
Customize the Earning Deduction Mapping page to add new Accounts for TA contracts.
•
Developed new interface (UNESTMTX), Process Estimated payments.
•
Analyze and customized all the custom PS Queries to incorporate the new contract types.
•
Developed the Leave balance and Activity report on Employee basis or for all Employees.
•
Run the Payroll process to identify, Calculate and finalize on different calendar Groups.
•
Involved in Testing to test the New Contract types in Hiring process and payroll process.
•
Environment: PS HCM 8.9 (Global Payroll, Benefits, Time and Labor), PS Fin 9.0 (AP,AR,GL,ePro)
People Tools 8.48, Application Engine, SQR, Oracle 10g, HP Unix, Web logic 8.1.0 Sp4,
Windows XP, BEA Tuxedo 8.1, STAT, Control M.
BIC- (Citi Reporting Core), Citigroup, Tampa, FL May 07 – March 2009
Peoplesoft 9.0 Financials & EPM Implementation
Peoplesoft Technical Consultant
Responsibilities
Responsible in Gathering the requirements by coordinating with the business users and analysts
•
for client and functional design of the mapping from the external source systems accounting
entries.
W orked on the Asset Management Mass Change Templates in Transfer of Assets within the
•
Business Units.
W orked on the conversion of Assets and loading them in the PS Asset Management system.
•
W orked on the Asset Management Depreciation Calculation process in debugging and resolving
•
a PeopleSoft bug with the help of PeopleSoft.
Developed a Suspense Journal Entry report for the suspended Journal Entries resulting from the
•
external Source system transactions.
Played the Major role in Designing, customizing and implementing the GL Journal Entry Approval
•
workflow for the client and later on trained the client about the same.
W orked in Peoplesoft Portal to customise the different pages.
•
into PeopleSoft GL using the Application Engine programs.
•
Developed the components to setup the Global Mapper (Mapping from Country to Global) and
•
Reporting Mapper (Mapping from Global to Reporting).
Developed the Components to setup Burst output files for reporting.
•
Developed the Burst Reports from Global to Reporting Marts.
•
Developed the Balance Sheet and Income statement report (BCCFR8) on account basis.
•
Developed Manage Adjustment Tax setup Page.
•
Developed Back Feed and CRC Feeds Process.
•
Developed the Data Mart Functionls Process.
•
Developed the Traceability process (Drill Back) from Reporting Marts to Local Marts.
•
Upload History Data loads in production data base with mart validations by using Ascential
•
DataStage ETL Tool
Developed the Process dependency control process to check the dependency of the process.
•
Involved in Data conversions in different environments.
•
Customize the Tree Load and Tree Flattener process to flattened the tree.
•
Design and development of Security Automation process to create the users, roles, permission
•
lists and authorize actions to access the different components in BIC project.
Developed the process BIC to BI cube Account setup process.
•
Used the Quest STAT tool for the version control an migration of PeopleSoft objects across
•
environments.
Involved in Unit testing and functional testing of different processes, reports and objects developed
•
in City Reporting Core project.
Environment: PS EPM 9.0 (Allocations, Data Marts and Burst, Average and Pool) Peopele Tools 8.48,
Application Engine,SQR,nVision, Oracle 10g, HP Unix, Web logic 8.1.0 Sp4, Windows XP, BEA Tuxedo 8.1,
STAT, Auto Sys, Ascential DataStage ETL Tool.
ITEC (International Truck and Engine Corporation),Lisle, IL Feb 07 – April 07
Peoplesoft Financial 8.9 Implementation
Peoplesoft Financial Technical Consultant
Responsibilities
Prepare technical design document for interfaces from Peoplesoft to BaaN.
•
Developed the interface Invoice information from Peoplesoft to BaaN.
•
Developed the Debit Memo outbound interface from Peoplesoft to IAC.
•
Customized the Accounts Payable stretched payment terms.
•
Developed outbound interface sends payment information to Citibank and IAC.
•
Responsible in Developing the Interfaces related to External Source systems accounting entries into
•
PeopleSoft GL using the Application Engine programs.
Support the production Issues in Account Payable and PO modules.
•
Customized reports related to Order management like Orders on Hold (OMC5210), which is a Crystal
•
Report & Sales Order (OMS1000), which is an SQR report.
Analyzed the Application Engine Programs and accordingly did the necessary changes in the
•
transformation expressions in the mappings of all the tables.
Customized PeopleSoft Delivered Inventory Business Process (Inter Unit Shipping Detail) and mapped to
•
internal mail users for Delivery status.
Production support in eProcuremnt and Account Payables modules.
•
Designed, Developed New Roles to receive Email from shipping information
•
Prepare the high level test script for developed and customized objects and does the unit test.
•
Resolve the defects in different phases of testing.
•
Environment: PeopleSoft Financials 8.9 (Account Payables, PO, AR,BI,GL, Inventory, Order
Management,eProcurement, Asset Management, Peopele Tools 8.47, Application
Engine,SQR,nVision, Oracle 10g,Sun Solaries 10, Web logic 8.1.0 Sp4, Windows XP,
BEA Tuxedo 8.1 FP 135, Control M.
Sprint Nextel, Reston, VA Jul 06 – Jan 2007
Peoplesoft Financial Upgrade 8.4 to 8.9
Peoplesoft Financial Technical Consultant
Responsibilities
Upgrade the peoplesoft application, customizations and enhancements for Project costing, eprocurement,
•
Purchasing, Account Payable, Asset Management and Allocation modules.
Prepare technical design document by using the Technical requirement specifications.
•
Customize the Accounting rules process (PSA_ACCTGGL) in project costing.
•
Setup the Excel to CI template to upload the Accounting rules in project costing module by using
•
PSA_ACCTG_SETUP_CI component interface.
W orked in Peoplesoft portal to cutomize the different pages.
•
Involved in customization of Allocation process Z_CLOH_ALLOC in project for business requirement.
•
Customize the AP_VCHRBLD on-line processes should be evaluated to incorporate the addition of the
•
Location field on the DISTRIB_LINE table.
Modify the PO_REQ_CREATE page by adding the CNRCT_ID and CNRCT_LINE_NBR fields.
•
Involved in customize the POPO0005 SQR process by business requirement.
•
Prepare the high level test script for developed and customized objects and does the unit test.
•
Resolve the defects in different phases of testing.
•
Environment: PeopleSoft Financials 8.9 (Project Costing, Asset Management, eProcurement, Purchasing,
Inventory, Order Management,SPro,AP,AR,BI,GL, Allocations,Peopele Tools 8.47, Application
Engine,SQR,nVision, Oracle 10g, Sun Solaries 10, Web logic 8.1.0 Sp4, Windows XP,
BEA Tuxedo 8.1 FP 135, Autosys,Remedy, Stat.
AIMCO Greenville, SC Mar 06 – June 06
Peoplesoft Financial Technical Consultant
Responsibilities
• PeopleSoft technical support for various Financial applications such as eProcurement, Account Payable,
Purchasing, Asset Management, Travel and Expense, and Mortegages Payable.
• Design and develop the AP centralization processes.
• Customize the peoplesoft delivered sqr process popo0005 for AP centralization process.
• Involved in costomization of peoplesoft deleivered pages according to client requirement.
• Customized requistition approval workflow.
• Maintenance of PeopleSoft tools and applications, change management for PeopleSoft.
• Produced deliverables to ensure quality and expectation standards were met.
• Design and develop the custom Mortegage payable module.
• Done Unit testing and System testing on all the customized applications in Test and Quality database
environments before it upgraded to the production.
• Involved in Unit, Integration and parallel testing.
• Executed the test cases, documented test results in test execution documents, and prepared the problem
log for all the bugs found. Interacted with the development team to report bugs and discuss the status of
bugs.
• Extensively worked with PS/Query to generate Crystal Reports, nVision Reports and also for debugging.
• Migrate the projects from dev to test and Production.
• Responsible for working closely with management team specialists to ensure that the final system meets or
exceeds all current service levels and reporting requirements.
• Production support in Account Payable and eProcurement Modules.
• Prepared the documentation in Peoplesoft change management for the resolved tickets in the production
support.
Environment: PeopleSoft Financials 8.4 (eProcurement 8.4,AP,PO,AM, Project costing
GL, Mortgage Payable, People Tools (7.5-8.4), SQR, SQL, People Code, Application Engine, SQR,nVision,
Oracle 8i, HP UNIX, Web logic 5.1.0, Windows 2000, BEA,Tuxedo, Autosys,Remedy, Stat, Test Director.
UMUC, College Park, MD Feb 2005 – Jan 2006
PeopeSoft Financials Technical Analyst
Responsibilities
• PeopleSoft technical support for various Financial applications such as GL, AP/PO, eProcurement,
eRequisition, Asset Management, Student Records and Student Financials.
• Involved in Upgradation from peoplsoft Financials 8.4 to 8.8.
• Maintenance of PeopleSoft tools and applications, change management for PeopleSoft.
• W ritten various SQRs to generate Class Enrollment Report, Enrollment Comparison Report, and
Enrollment Statistics Report to give comprehensive info to the management on enrollments.
• Developed a SQR to generate a report of paid and unpaid students. The SQR also reports the class
sections allocated to the paid students which enables the management to take appropriate decision. If
there is required number of students who paid, the management may decide to go ahead with the classes
as scheduled. If there is no required number of students who paid, the management may decide to cancel
the classes.
• Customized PeopleSoft delivered SQRs to make them suitable for three different university campus.
• Extensively Customized SQRs to generate a report of students, on the basis of their region, military and
non-military status. This report enables the management to design the course curriculum that meets the
needs of different student groups.
• Extensively worked on PeopleCode to customize delivered functionality in student records and Financial
aid.
• Produced deliverables to ensure quality and expectation standards were met.
• Integrated the Accounts Payable application with General Ledger, and Payroll to send and receive data.
• Unit testing and System testing on all the customized applications in Test and Quality database
environments before it upgraded to the production.
• Involved in Unit, Integration and parallel testing.
• Executed the test cases, documented test results in test execution documents, and prepared the problem
log for all the bugs found. Interacted with the development team to report bugs and discuss the status of
bugs.
• Extensively worked with PS/Query to generate Crystal Reports, nVision Reports and also for debugging.
• Created process definitions and attached the custom/modified SQRs, Crystal Reports, and nVision Reports
to the Process Scheduler to run those processes and reports from menu
• Migrate the projects from dev to test and Production.
Production support in Account Payable, eProcurement, Student Records and Student Financials..
•
Environment: PeopleSoft Financials 8.4,8.8 ( eProcurement 8.8, AP,GL, Student Records and Student
Financials), Peoplesoft HRMS, People Tools, SQR, SQL, People Code, Application Engine,
SQR,nVision, Oracle8i, UNIX, Web logic 5.1.0, Windows 2000, BEA, Tuxedo, Autosys.
Perot Systems Corporation, Dallas, TX. Jan 2004 – Dec 2004
PeopleSoft Financials Techno Functional Consultant
Responsibilities
Involved in full life cycle implementation in PeopleSoft General Ledger, Asset Management and
•
eProcurement.
Extensive configuration of eProcurement module for business needs, which includes Requestor, Buyer,
•
and Business unit related options.
Setup and testing of eProcurement module from Requisition to Pay with users.
•
End-user training of eProcurement module from Requisition to pay cycle.
•
Setup of delivered eProcurement workflow for testing purposes.
•
Catalog setup – Changed the category structure and setup a new internal catalog for users.
•
Security – Setup eProcurement roles and Permission lists based on Perot business needs.
•
Technical support for eProcurement Post implementation and training to end-users.
•
Receiving notification – Created an application engine program which notifies users if a Purchase Order
•
has not been received for 4,8,12, or 16 day’s after the due date.
Involved in complete Procure-to-Pay process through Purchasing, procurement and Payables
•
Performed matching validation between purchase orders, receipts and invoices.
•
Developed, coded, maintained Inventory, Stores and Purchases System.
•
Implementation of Projects, Inventory and Assets modules.
•
Development of new interfaces include Asset Management Cost Adjustment Upload Interface, interface
•
between CMIS and PeopleSoft Accounts Payable of Perot.
Administered security and provided training to the end-users.
•
Customized the PeopleSoft delivered work flow for approval of requisitions.
•
W orked with Registration Wizard to assign components and security to menus
•
Setting up of Depreciation attributes, schedules, prorate conventions, user defined methods.
•
Modified and deleted the pending Asset transaction i.e transaction on which depreciation calculation has
•
not been run.
Modified AMIF1000.SQR (Transaction loader) so that it populates the transaction date and accounting date
•
in open transaction, cost and depreciation records as specified in the AM05.SQR.
Setting up of the Requisition load program (PO_REQLOAD)
•
Involved in creating PO’s Using PO staging batch process (PO_POSTAGE)
•
Involved in creating PO Vouchers and running the matching process (AP_MATCHING)
•
Developed nVision reports in both Tabular layout format and Matrix Layout format
•
Involved in Production support for AP, AM and eProcurement modules.
•
Involved to prepare daily checkouts the processes that are running in CRON Jobs in HRMS and Finance
•
Applications.
Environment: PeopleSoft Financials/SCM 8.0 (eProcurement 8.0, eProcurement 8.8, Asset Management,
AM, AP, AR, GL, BI, Purchasing, Cost Management and Inventory), PeopleSoft HRMS, People Tools 8.20,
People Tools 8.42, Work Flow, Oracle 8i, Crystal Report 9, SQR6, Oracle, DB2, UNIX, Web logic 5.1.0,
Windows 2000, BEA Tuxedo, Autosys.
Verizone,Folsom, California Nov 2002 – Dec 2003
PeopleSoft Financials / SCM (AM, PC, GL, AP, PO, INV, Order Management, ePro)
Responsibilities
• Implemented application customizations and enhancements for Asset Management, Project Costing,
Accounts Payable and General Ledger modules.
• Creating New Pages and Components for various business requirements.
• Technical support for eProcurement Post implementation and training to end-users
• Customized various pages and modified Peoplecode to meet client’s business requirements.
• Development of custom Queries and reports using Nvision, Crystal and SQR per user request
• Customizing the PO Calc and PO Create Application Engine Processes to be able to run for Multiple
Business Units.
• Administered security and provided training to the end-users.
• Involved in Unit Testing and System / Cycle Testing.
• Modifying People code and running debugger, trace to fix issues.
• Legacy data conversion/translation and loading the data using SQR, PL/SQL.
• Support performance testing and provide subject matter depth to testing personnel in understanding
processes/on-line functionality.
Environment: PeopleSoft Financials / SCM 8.4, People tools 8.4, Oracle 9i, DB2, SQR V8.4, STAT, IBM/Unix,
Win NT/2000.
Duke Energy Charlotte, NC, USA Aug 2001 –Oct 2002
PeopleSoft Financials Technical Consultant
eProcurement
• Roundtrip between eProcurement and Bugs Eye (Requisite) technology.
• Business Document Exchanges – PO’s and Change Orders for outbound transactions. PO Response and
Acknowledgement documents for inbound transactions.
• Category Codes – Designed system to map between the UNSPSC codes and internal PeopleSoft category
codes. This system allows for Duke to capture their spend analysis data based on what end-users buy in
the company.
• W orkflow – Testing of workflow based on business requirements at Duke.
• Pcard – Users may purchase items from Pantellos with Pcards that have been setup for them. The Pcard
code is encrypted and sent to Pantellos on a PO via the MPC and can be viewed by the supplier.
Purchasing
• The business process for Duke changed from allowing only 1 schedule per line to multiple schedules per
line.
• Design and build of EDI Purchase Order transactions to Duke suppliers.
• Design and build of Purchase Orders via Fax and Email.
• Provided PeopleSoft Technical consultation on Scoping, Fit-Gap Analysis of Financials GL, AP, AR,
Purchasing and Billing.
• Integrated purchase orders originating in PeopleSoft Purchasing into PeopleSoft Projects
• Assist functional team leads in designing GL, Assets, Accounts Payables, Purchasing modules
Accounts Payable
• This is a new implementation for PO vouchers at Duke.
• Design and build of EDI voucher transactions from suppliers to PeopleSoft.
• System test of Voucher Build, Voucher Edit, and Matching after voucher transaction into PeopleSoft
occurred.
• Design, build, and system test of EDI Auto Bank Reconciliation process from Wachovia Bank.
Environment: PeopleSoft Financial/SCM 8.0, People Tools 8.20, Oracle 8i, Crystal Reports, SQR 4. Oracle,
UNIX, Web logic 5.1.0, Windows 2000, BEA Tuxedo.
Olsten Corp, Long Island, New York Jan 2000 - July 2001.
PeopleSoft Financials (GL, AP, AM, AR, Order Management, Billing, Purchasing, Inventory)
Responsibilities:
• Involved in Upgrading PeopleSoft Financials (GL, AP, PO and eProcurement) from 7.5 to 8.x. It includes,
People Tools upgrade and modules upgrade.
• Customizing pages in PeopleSoft 8.x using application designer and PeopleCode.
• Reports comparison between 7.5 and 8 and modification of reports and processes to run under 8.x and
testing the performance and output of new reports and processes.
• W orked as a PeopleSoft Developer on customizations and provided functional solutions for module
functionality enhancements, upgrade, providing production support, post implementation activities, reports
development, configuration issues and functional issues in the areas of PO, AP, OM, BI, AR, and also
include process specifications design and finalization, user interaction for issues resolution.
• W as part of the Design team for developing business process flows and interfacing requirements for a client
specific streamline process
Customizations include:
• Modified People Code to trigger change PO process when sales net unit price changes in sales order.
• Modified People code to prevent creating Purchase orders against Invalid contracts and Invalid site
locations for certain business units.
• Modified People code and Application Engine processes to trigger a change PO when the sales order
comments change.
• Modified People code to prevent purchase orders when the Budget info is non-available for the project ID,
Activity type, Analysis type, Resource type, Category and Sub-category.
• Identification and resolution of issues related to Projects integration processes with respect to PO, AP and
BI and other postproduction support issues.
• Develop Reports and Queries.
• Production Support in all distribution and financials modules.
Environment: PeopleSoft Financial/SCM 8.0, People Tools, Oracle 8i, Crystal Reports, SQR 4. Oracle, UNIX,
Web logic 5.1.0, Windows 2000, BEA Tuxedo.
McCreade Software (Asia) Pvt. Ltd, Bangalore May 1998 – December 1999
Software Engineer
Megameds.com
Description: Megameds is an online B2C virtual drug store. The system helps consumer to browse and select
Prescription drugs, Non-Prescription drugs, and other products by providing them the pricing and discount
information. The system keeps track of the selected item and pricing that apply until the purchased products ships
to make customer. It also computes shipping charges, taxes, and subtotal and then generates total for the order.
The system also provided Order Processing, Payment Handling, Health Information, Shopping Cart,
Shipping details, Billing Details, Coupons, Discount Information, Doctor details, Patient details and Powerful Search
Engine.
Responsibilities:
• Design the database for Visitor, Order Management module.
• Created Server side script for Visitor, Order Management module
• Validate the forms on client side using JavaScript
Environment: Windows NT, Broad Vision, Command Center, and Oracle 7.3.