Data Project
Resume:
Durga
E-mail: *******.*****@*****.***
Ph: 346-***-**** PeopleSoft Techno/Functional Consultant
Professional Summary:
Over 6 years’ experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
5 years’ experience in wide range of PeopleSoft Financials/SCM modules including Accounts Payable, Accounts Receivable, Billing, General Ledger, Asset Management, Inventory, Expenses, eSettlements, Contracts, Project Costing, Purchasing and eProcurement.
Extensively worked with PeopleTools such as Application Designer, Integration Broker, Application Engine, PeopleCode, Component Interface, File Layout, Data Mover and Workflow.
Worked with reporting and analyzing tools such as XML Publisher, SQR and Crystal Reports. Used PS/Query and Tree Manager for reporting purposes to fulfill company’s specific needs.
Participated in all phases of ERP life cycle like Implementation, Conversion, Customization, Development, Production Support and Upgrade.
Experienced in troubleshooting SQR’s, Application Engine, Component Interface Programs, Performance related issues and creating complex reports using SQR, Crystal Repors and XML Pulisher.
Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
Experience in designing Test Cases and Strategies by following different QA methodologies.
Extensively worked on interfaces and conversions from legacy/third party systems to PeopleSoft.
Worked intensively with to implement Row Level Security, Creating Roles and Permission Lists
Experienced in the usage of HP Quality Center and STAT 5.3.1 tools.
Team player with excellent interpersonal communication skills and technical documentation skills.
Technical Skills
PeopleSoft Financials (9.1, 9.0, 8.9, 8.8, 8.4, 8.x 7.x)
Application Designer PeopleCode Component Interface
Application Engine File Layout SQR
XML Tree Manager Data Mover
PS Query Crystal Reports Performance Tuning
Integration Broker PL/SQL
Operating Systems
Windows 2000, 2003, NT, 98, XP
Databases
Oracle 11g/10g/ 9i/8/7.x SQL Server 2000/2005 DB2
Applications
General Ledger Accounts Payable Accounts Receivable
Purchasing Billing Inventory
Asset Management eProcurement Contracts
Project Costing Treasury eSettlements
Expenses
Education
Bachelors in Engineering - BEC, India
Masters from UHCL - Houston, TX.
Professional Experience:
GE HealthCare, Houston, TX (Sep’2016 – May’2017)
Role: PeopleSoft Techno Functional Consultant
Project: Production support for AR, AP, GL modules in Peopletools 8.48 and Peoplesoft 9.1.
Description: This client is Dynegy in Houston, TX. This project mainly involved Enhancements, Production Support, Integration, and Maintenance of PeopleSoft Financials modules like PO, AP, AR, Billing, Project Costing, General Ledger.
Responsibilities:
detailed test plans and technical documentation
Provided Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR’s & Online.
Worked on various SQL performance tuning tasks to reduce the execution time
Customized the delivered pages and Debugged the peoplecode and the SQR reports for the requested requirements for AP & AR Aging reports.
Customized various online pages according to the user needs
Customized GL reports and interfaces according to new Integration conversion rules
Customized Component Interface People Code to add extra functionality and validation
Worked extensively on Application Designer to modify the existing record definitions, pages, components and menus
Dell International Services, Bangalore, India (Apr’14 – Dec’15)
Peoplesoft Financial Techno/Functional Consultant
Project: Peoplesoft Upgrade 9.1 to 9.2 on Tools 8.51 to 8.54
Responsibilities:
Worked on Estimates and Reapplying customizations for Peoplesoft 9.1 Upgrade
Reviewed compare reports and analyzed what all customizations need to be reapplied for PO, AP, INV, EXP, GL and AM modules
Reapplied Customizations for AP, PO, GL, INV and EXP module and tested the functionality in 9.1
Retroffited Customizations done on POPO005 PO Dispatch SQR so that all customizations are brought forward to 9.1. Added New Customizations to Remove Schedule Line Totals, Print TAX amount only at the End of the PO & Print Page n of m on the Top
Implemented Interface to Load Perdiem and Expense Location data from IRS Per Diem File into Peoplesoft Expenses
Added EFT layouts for Additional bank layouts on FIN2025 EFT SQR and SQC programs
Implemented an Interface to Load Invoices from DCM system into PeopleSoft AP Voucher tables using File layouts and App Engine Program
Created a Process to Write off Payments at the end of Fiscal Year in AP
Resolved defects related to Void/Reissue Payments in AP
Customized the AP_APY2015 to generate Correct OverflowId’s for Expenses and Cash Advance Payments
AP: Developed a Conversion Interface to Load Vendors into Peoplesoft using Component Interface and Application Engine
Developed Interfaces between AP and Payformance for ACH Payments. Configured the Banks and Vendors with ACH Payment Type
AP: Customized Fin2025 EFT Process in SQR to Include EFT Format for Banco Santander
Added Custom code on the Catalog Trees on eProcurement Requisition Pages to show Buyer ID and Phone Number for Each Item on the Catalog Tree, also added Defaulting Logic based on Type of Requisition and hide unused tabs
Developed a Conversion Process to convert all Producer System Vendors into Peoplesoft.
Developed a new Application engine Interface to automate the Load of Billing Invoices into Billing Interface Tables.
General Ledger: Added the Functionality of Journal File Attachments on Journal Entry Pages
Configured the AWE (Approval Workflow Engine) for Expense Reports and Cash Advances
Created a Process to Write off Payments at the end of Fiscal Year in AP
Reapplied customizations after MP6 and Bundles 14 & 15 Application.
Customized the ePro Requistion Entry Panel to have buyer id and phone number on the Catalog Tree
Configured and tested Excel Upload for Voucher. Activated the Service, Service Operation and gave security to the user permissions to have access to the WEBLIB_AP and WEBLIB_XMLLINK
Integration Broker: Integrated Peoplesoft with MQSeries to send Expenses Data to Producer System. Copied the Jar Files into MQ client Directory and Configured the setenv command on webserver to include all the java class paths for MQ Series
Loaded Jar Files to use custom Encryption for Peoplesoft to MQSeries data security. Called java code from within Peoplecode to encrypt Credit Card Data sent to MQSeries Queue
Converted Expenses data from 8.9 to 9.1 and encrypted credit card numbers.
Implemented customization to allow Expense Administrator to Unmask Credit card numbers on Employee Update Profile page
Customized the EX_LOAD_VISA Application Engine to Load New Credit cards numbers into CC_CARD_DATA_EX and CC_CARD_MSK tables from Visa Card Transaction file with Level3 data.
Corrected Production issues related to AWE for Expense Report workflow in 8.9 prior to upgrade to 9.1
Environment: PeopleSoft FSCM 8.9/9.1 People Tools 8.49/9.1 (App Designer, Application Engine, PS Query, Integration Broker), PeopleCode, MQ Series, WSDL, Crystal Reports, Oracle 11g. & AWE (Approval Workflow Engine)
MindTree LTD, Bangalore, India (Jan’13 – Mar’14)
Peoplesoft Financial Techno/Functional Consultant
Project: Peoplesoft Finance/SCM Implementation.
Responsibilities:
Involved in gathering the functional requirements for the conversion of the AR/BI/PO/INV/ePro/GL modules from PS8.9 to PS 9.0 as a part of the CMFM project.
Was responsible for designing the technical documents based on the functional specifications.
Developed the conversion programs for the conversion of Customers, Customer Conversations, Bills, Items and Payments from PS 8.9 to PS 9.0
Developed the scripts to verify the validity of the converted data according to the functional requirements.
Designed and developed Vendor Import program to import vendor information from third party system to PeopleSoft Accounts payable using Application Engine, Component Interface and File Layout.
Used PS Query extensively to create custom SQL Queries to generate reports.
Extensively worked on various Billing Crystal reports.
AP Interface: Developed an Interface using application engine and file layout to extract payment feedback from Peoplesoft AP to load into an External Refund system.
SciQuest to AP Interface: Developed an Interface to Load Invoices into AP using Integration Broker
AP Bank Reconciliation: Developed a Process to Load Bank Statements into AP
AP: Customized the Voucher Entry Component. Added Received Date field that is populated based on the Invoice Scanned Image DateTime in ODOC and For Regular Entry Vouchers the Invoice Received Date is Required
Customized the AP Voucher Entry Distribution Grid to Capture Work From and Work To Dates for Service related Invoices
AP Payment Cancellation: Made the Payment Cancellation Comments Required and displayed the Comments on the Voucher Payments Tab
AP Positive Pay File: Developed a Custom Process that Extracts all Payments by Check Reference, Payee Amount, Check Date and Payee Name in a single File that will be sent to the Bank
Tested and resolved the Unique Constraint issue in the Replenish Inventory (IN_REPLEN_AE) process while processing multiple BU’s.
Validated the Customizations to the Shipping Inventory for processing stock depletion in the INV module.
Resolved the performance issue of the Inventory Demand Archive Process.
Troubleshot various Application Engine programs like PC_POADJUST and PO_PORECON to accommodate for data stuck after conversion.
Tested and validated the Picking Plan INS6000.SQR to print the orders in the sort of Business Unit, Demand Source, Source Business Unit, Order Number, Item ID, Storage Area and Storage levels.
Designed and developed the PPSFBI08 (Standard Invoice), PPSFBI10 (Property Damage), and PPSFBI13 (Consolidated Invoice) crystal reports.
Designed and developed the dunning letters PPSFAR06 (30 day’s) and PPSFAR07 (60 day’s dunning) letters as per client requirement’s.
Project Costing: Customized Project General Pages. Added AFUDC, Regulatory options and other custom fields on the User Fields Tab
Project Costing: Modified PC_AP_TO_PC application Engine to avoid duplicate entries in PROJ_RESOURCE table for Payments and Payment Cancellation rows
Customized PeopleSoft delivered Posted Voucher Listing Crystal report APY1020.rpt for AP module.
Developed a new interface using Application Engine to populate the quick voucher tables (PS_VCHR_HDR_QV, PS_VCHR_LINE_QV, PS_VCHR_PYMNT_QV, PS_VCHR_DIST_QV) from the input files, which in turn is used by the voucher build process AP_VCHRBLD to create PeopleSoft Vouchers.
Customized VCHR_EXPRESS1 page by incorporating Verizon Signature Authority Functionality to create and approve vouchers based on the amount levels.
Customized AP_MATCHING process to perform Matching validation among receipts, PO and invoices and a Match exception crystal report APY1090 to view the disputed values that are populated after running Matching process.
Modified the existing crystal reports to include the meta data on every page of the report that the FileNet uses to create RPT files of these reports.
Worked extensively in resolving the defects in various phases of testing of the application.
Customized the delivered Application Engine (BIPRELD) as per the Client’s requirement.
Worked on the Billing Invoice Retention custom Application engine (BI_INV_RET) which handles special characters in an invoice to create valid XML files.
Extensively worked on the AR_UPDATE to resolve the issue with the Posting of the converted payments.
Worked in the production support team to resolve SQR,Application Engine and Peoplecode issues
Environment: PeopleSoft FSCM 9.0 People Tools 8.48 (App Designer, Application Engine, PS Query) People Code, Crystal Reports, Oracle 10g & Quality Center
Navisoft Solutions PVT Ltd, Bangalore, India (May’11 – Dec’12) PeopleSoft Financial Techno/Functional Consultant
Project: Peoplesoft Implementation
Responsibilities:
Developed Purchasing Interface using File Layout, 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.
Developed an Application Engine which uses Component Interface while loading third party Billing System into PeopleSoft Account Receivables.
Generated AP Vouchers and populated the AP external interface staging tables (PS_VCHR_HDR_EC, PS_VCHR_LINE_EC, and PS_VCHR_DISTRIB_EC) with Inter Unit Billing Information from the PeopleSoft Billing tables.
Created a new AP 1099 Tax withholding report using PS/Query.
Modified APY2021 Check Copy Crystal Report so that it includes additional fields on the check copy.
Modified APY2027 Wire Advice Crystal Report according to the client requirements.
Created a Query to pull up number of AP invoices process per month
Developed an Interface to Load Credit Card Transactions into Expenses
Customized the Expense Report Entry Pages. Added custom validations and default logic on the panels.
Customized the Format Positive Pay process AP_APY2050 to skip the payments that are being void.
Created a customized SQR process, which reads the data from the input file, generated by the external system to load PS_VCHR_ACCTG_LINE and PS_PAYMENT tables for bank reconciliation.
Used Component Interface and accessed the Component VNDR_ID to keep the vendor information in synchronous with the third party generated automated email using People Code to send the vendor information to the auditor controller for approval.
Performed the Customizations to the Shipping Inventory for processing stock depletion in the INVENTORY module.
Performed the Customizations to the Item Balance by storage Location page for the INVENTORY module.
Worked on the Complex Application Messaging and Integration broker tools to synchronize the data between the Financial and HR Modules.
Worked on EDI Configurations transactions – 180 Return to Vendor Dispatch process,
810 – Vendor Invoice transactions, 850- PO Dispatch Process, 855- PO Acknowledgments & 856- Advance Shipment Notifications .
Prepared the proof of concept documents for Requisition sourcing - Inventory Demand, PO_Calc, PO_Create, and Sourcing Workbench in Purchasing.
Responsible for creating/maintaining Item Catalogs and setup Users for ePro.
Worked on development of complex reports for Asset Management and Inventory.
Involved in creating a process to build inventory demand which verifies the inventory table BU_ITEM_INV and then consequently checks the inventory availability and then a calculation process is developed to source it to a PO using Purchasing module.
Customized and validated the Packing Slip – INS6500.SQR not to print the Packing slips that were already printed and added additional functionality of reprint.
Worked on the development to automate the customer creation process in PeopleSoft from the PeopleSoft AP Vendor tables i.e. populate the customer tables with the vendor data.
Developed Component interface for Journal Entry Component for data input data from Third party systems of different file formats using file layouts and file objects.
Assisted in Production Support to meet the client requirements on Account Payables and Account Receivables.
Worked with ExcelToCI utility to import GL, AP, BI and Expenses configuration data.
Carried out Integration test, System test for Accounts Payable Interfaces and trained Business Users processing the interface voucher data.
Developed Test Cases, Test Scenarios and created Test data and executed tests in Quality Center 9.2
Environment: PeopleSoft 8.9(GL,Expenses,AP,BI,INV,PO, ePro),PeopleTools(8.46.08), App Designer, PeopleCode, Application Engine, Component Interface, Workflow, PS Query, SQR and Oracle 9i, Crystal 9.0.
Education:
Master of Science (Engineering Management), University of Houston-Clear Lake, Houston, TX May 2017.
Bachelor of Engineering (Electronics and Engineering Engineering), Bapatla Engineering College, Bapatla.
Contact this candidate