SUMMARY

• Over 10 years of experience working as a PeopleSoft Technical Consultant in various domains.
• Extensively used People Tools like Application Designer, People Code, Application Engine, PS Query Manager, PeopleSoft Security, Process Scheduler, Process Monitor, Component Interface, File layout, Application Messaging, Configuration Manager and Data Mover
• Involved in the Implementation, Customization, Testing and Troubleshooting, Reporting, Production Support and Maintenance of PeopleSoft Applications.
• Involved in Developing, Debugging, Troubleshooting and Testing of SQRs, XMLP and People Tools like Application Engine and People Code.
• Have good understanding of Functional and Technical aspects of various modules in both PeopleSoft HCM - HR, Payroll, Base benefits and Time & Labor and also Financials and Supply chain (GL, AP, PO and IN).
• Extensively worked with Application Designer to develop or modify record definitions, pages, components and menus.
• Provided training to our team in Confidential on XMLP Reports to generate Addendum reports for CMP Project.
• Worked with PeopleSoft Security for creating User profiles, Roles and Permission lists.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Proficient in generating various SQR Reports, XMLP Reports, and Created corresponding Run Control Pages
• Extensively worked on reporting system for AP and PO using XMLP, SQR and some GL repots using nVision.
• Designed and developed data conversion reports and Inbound/Outbound Interfaces to facilitate the transfer of data from Legacy System to PeopleSoft system using Component Interface, SQR, Application Engine and File Layout.
• Trained our team members in XMLP including Translations.
• Updating various release documents and other project related documents.
• Ability to manage multiple priorities effectively without affecting the quality of the process
• Flexible and can work effectively independently or as part of a team
• Strong problem solving, analytical skills, good verbal, written communication and presentation skills and ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS

ERP Package: PeopleSoft HCM 9.1/9.0/8.9/8.8. PeopleSoft Financials 9.1/8.8/8.4

People Tools: Tools v 8.50/8.49/8.46/8.42.

DBMS: DB2, Oracle 8i/ 9i/ 10g.

PeopleSoft Development Tools: Application Designer, People Code, Application Engine, Application Package, PSQuery, PeopleSoft Security, Process scheduler, File Layout, Component Interface, Application Messaging, Data Mover, Tree Manager and Configuration Manager.

Reporting Tools: PS Query, SQR and PeopleSoft XML publisher.

Programming Languages/Tools: SQL, OLQ, VSAM, PL/SQL, C, JCL, COBOL, Java, MS Office and Access.

Scripting: UNIX Shell scripts, Pearl scripts.

Version Tools: Rational Clear case.

Debugging Tools: SQL Trace, Application Designer Interactive Debugging, AE Trace.

Operating Systems: Z/OS, UNIX, Linux, Windows9x/2000/XP, MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Senior PeopleSoft Developer

Responsibilities:

• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HCM for OIS & JDS offender information systems.
• Prepare technical design with the finest details of the technical changes required.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed Record definitions, Pages, Sub Pages, Components, Menus and Component Interfaces for various projects like CTP detail Project, Separates Project, Felony level Sentencing Project and High Risk Offender monitoring Project.
• Created various reports using XML Publisher to provide details on Beds assigned to Offenders, Details on High risk Offenders, Monitor offenders in every facility.
• Created Component Interfaces to load the bulk data from Excel to CI for High Risk and Low risk Offender details in Juvenile systems for records JDS LWRSK OFF TBL, JDS HGRSK OFF TBL based on requirements. Developed security for these pages which allows DOC or COA to update these pages and allow display to others.
• Created Record definitions as OIS CTP COMMTRN, OIS CTP SENTNCE, OTP CTP COMITMNT for CTP detail project and load data using Excel to CI with Component Interface OIS CTP DET CI as per requirements.
• Designed and developed custom interface for Juvenile system using Application Engine to load offender data into offender staging tables as per business requirements.
• Modified Visitor detail people code to allow only one Emergency contact detail updated and modified general custody inquiry people code with new felony levels to allow new sentencing changes.
• Worked on Component Interfaces and File Layouts to read inbound files and manipulating the PeopleSoft tables.
• Modified Application Engine OIS OFNRCV FAC AE to include offenders in their new facilities PNC, RDC, RTC and ISF and update PS JOB with new facility details.
• Created Roles and Permission on CTP detail OIS CTPDET PG to allow DOC or COA to update the CTP details and display to others.
• Migrated people soft objects like Records, Queries, Connected Queries, Components, Menus, Report definition from OISDEV to OISQE and OISSUP and created new offender data in OISSUP to allow other environment users to test the functionality.
• Created App Engine process OIS OFNTRNST AE to load staging tables with transferred offenders from one facility to other and update TRANSFER STATUS, RCVD FLAG flags accordingly.
• Modified Offender dashboard to include new tables, pages and people code to Monitor flags on High risk offenders and generate reports using XMLP based on facility.
• Created XMLP Reports using PS Query which pertain to offenders who currently occupy a segregation bed. Any location defined in OIS may run the report for their location. DOC and COA users may run a combined report i.e. more than one facility.
• Wrote SQL’s to add new Offense Citation codes and new facilities to development, test and production environments.
• Modified SQR’s JDS COMTMNT DET.SQC to generate reports on D.O.C Commitment Summary for all offenders in every facility with Intake status/ Discharge type, County and court with severe Offense details.
• Documented all the changes done in OIS and JDS systems for development and maintenance projects.
• Used File Layout Definition to get data from the legacy system to JDS people soft tables to update sentencing details on Parole board.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• Multiple types of files were extracted from legacy main frame systems and compared to implemented OIS Offender system. This required logic to handle various differences in the files as well as understanding of the layout of the OIS system tables.
• Worked on Production support to fix Data, Modify People code, App engine batch process and XMLP issues.
• Modified Record level People Code, page level People Code, component level People Code to include new sentence calculations based on Felony class levels.
• Analyzed business requirement and prepared technical specification to include new felony levels on sentencing changes, modify visitor information to allow only one Emergency Contact information.

Environment: - PeopleSoft Financials 9.1, People Tools 8.51, Application Designer, People Code, Process Scheduler, PS-Query, XMLP, SQL Navigator, Application Engine, Oracle 11i, MS Excel, Unix, Windows NT/2000.

Confidential, Pittsburg, PA

Senior PeopleSoft Developer

Responsibilities:

• Prepared the Functional and Technical design documents for implementation of projects based on business specifications as per the requirement.
• Designed and developed Record definitions, Pages, Sub Pages, Components, Menus and Component Interfaces for Pickup and deliveries based on Business requirements.
• Created Component Interfaces to load the bulk data from Excel to CI for Pickup & Delivery for Primary Service Area based on requirements.
• Developed security for these pages which allows Field officer or above to update these pages and display for others.
• Created Record definitions for Delivery and Pickup pages and wrote people code to include few validations like selecting or adding Primary service area based on Deptid from search record.
• Worked on Component Interfaces and File Layouts to read inbound files and manipulating the PeopleSoft tables.
• Provided training on XML publisher includes translation to French to our team.
• Worked on various security issues on production environment and Customer facing environment (MGBA).
• Provided support for Workforce Gateway applications in creating contracts using person request and elections based on different type of contracts for Canada Model Project.
• Worked in development and customization of complicated portal pages using multiple level scrolls and derived records.
• Customized HR, payroll menus, enquiry pages as per the user requirement so that user can view more information.
• Worked on designing and developing nVision layouts/reports for Addendums with flex, Service Coverage and Fuel Cost Indexes
• Involved in acquiring specifications from Business users to develop Addendum dashboard setup and generating reports using XMLP based on Addendum codes both in English and Canadian French.
• Modified record people code to new contracts between drivers or helpers and Administration officers and also verify approval process for Canada Model Project (CMP).
• Modified Addendum dashboard, Tables and pages to include elections for Canadian contracts and print Addendum reports using XMLP to reflect appropriate rates and PSA’s.
• Worked on security issues like adding roles and permission list to users and pages.
• Worked with production support team during the Bi Weekly Payroll process to fix any problems for the Paycalc process and nightly batch process.
• Worked on Employee PF and Pension Data transferred from Payroll. Employee PF loan details are maintained. Loans Interest calculation, Ledger Processing, Settlements, and loan recoveries.
• Conducted meetings with the Business Users and the testing team and involved in discussing their issues and helped them out in finding the proper solutions for their requirements.
• Modified App engine ZG QLINSTR AE for Canada to allow instructors to include new qualifications.
• Created SQR reports ZG CAN SPDLY.SQC, ZG CAN SUMARY.
• SQC for every employee based on department and company to calculate shipment and delivery details and provide their summary reports.
• Fixed Translation issues in French, Addendum setup on XMLP while generating reports in both English and Canadian French.
• Modified App engine ZG CHKGD USR AE to validate good standing contracts and notify contracts to renew their contracts based on expiry date for both US and Canada.
• Worked in developing and customizing complicated Portal Pages using multiple level scrolls and derived records.
• Prepared the documentation for the changes done for development and maintenance projects.
• Modified Person request people code to in corporate FLEX elections based on start date of contract for every quarter for existing and new contracts
• Migrated people soft objects like Records, Queries, Connected Queries, Components, Menus, Report definition and XLIF from CDASDEV or CDASNEW to CDASSUP and create new contracts in CDASSUP to allow other environment users to test the functionality.
• Tuned the performance of the SQR reports using SQL, Stored Procedures and Temp Tables. Documented internal processes, procedures.
• Modified Component people code COURSE SESSN TBL to include courses for both US & Canada and assign to both existing and new instructors.
• Wrote App Engine process to create new Entities and contracts in various tables like ZG CTS CONTR WA, PS JOB, PS CTS CONTRACT and terminate Old contracts based on ’Pending Final Check’ status.
• Modified Person request pages to include FLEX, BSP and Time off elections.
• Work involved analysis of functional specification and preparing technical specifications based on the given Canada Confidential functional specification.
• Attended client meetings and gave presentations of the work done and resolve any critical production support issues.
• Identified the functional Gaps, Customization lists, Impact analysis of customizations.

Environment: - PeopleSoft HCM 9.1 (Payroll), People Tools 8.51, Application Designer, People Code, Process Scheduler, PS-Query, Connected-Query, XMLP, SQR, SQL Navigator, Application Engine, Oracle 11i, MS Excel, Unix, Windows NT/2000.

Confidential, Cincinnati, OH

Senior PeopleSoft Developer

Responsibilities:

• Understand the functional requirements and prepare High level technical design describing the technical changes need to be done.
• Interact with Business Analyst for functional clarifications.
• Prepare technical design with the finest details of the technical changes required.
• Design, Develop and unit test the code as per the technical design. Prepare test plans. Prepare migration requests.
• Debug and troubleshoot technical problems that arise. Present a demo to the user explaining the customizations.
• Provide handoff to QA and support team about the customizations.
• Designed and developed PeopleSoft objects like records, pages, components, menus, Application engines, File layouts.
• Worked extensively with oracle SQL.
• Designed and developed custom Voucher Upload interface using Application Engine Technology to load vouchers into voucher staging tables satisfying the business rules.
• Developed a new Component Interface to create vouchers for travel expense records from third party system.
• Implemented the approval workflow engine process to integrate the customer payment and expenses work flow process for billing system.
• Understood the entire processing and setup of Bank Reconciliation in PeopleSoft and helped Business Analyst in the requirements phase to implement Bank Reconciliation under banking module. Designed and developed custom interfaces to read, validate and load the Bank statement files(called Statement Billing files) into PeopleSoft system.
• Implemented a custom payment method called Vendor Card Payment as demanded by the requirements. Involved in requirements phase to help BA with technical expertise. Designed and developed interface using SQR for creating payment files, transmitting the files to external banking system and capturing audit information of the transactions in the file. Implemented view attachment functionality in the audit page using Peoplecode for viewing the generated file from the page.
• Designed and developed a SQR for creating electronic payment file (fineft98.SQR) in the new ACH CTX format for external bank. Modified the delivered TNE format (fineft88.SQR) to meet the business requirements. Wrote SQRs to capture the audit information of the TNE and ACHCTX files generated when interfaces are run.
• Responsible for designing nVision layouts, scopes, and related PeopleSoft Trees using Tree Manager to meet all GL reporting requirements in a multi-ledger/ multi-currency global implementation of PeopleSoft GL 9.1
• Designed and developed custom inbound and outbound interfaces using Application engine for processing files from/to External purchasing systems using Application engine. The inbound files included PO information, Receipts information, and Invoice information whereas the outbound files included Vendor information, Chartfield information, etc.
• Good debugging and troubleshooting knowledge on interfaces like AP Voucher Build (AP VCHRBLD) and PayCycle processes (AP APY2015).
• Integrated the Expense management system used for creating employee travel expense records with the PeopleSoft system in order to have vouchers created for the expense records in PeopleSoft and their payments done. Designed and developed many batch programs using UNIX shell, perl scripts and Application engine as part of the integration.
• Resolved various production support tickets.
• Helped Business Analyst in requirements phase with the technical questions that arose while gathering requirements and always provided the best solutions.

Environment: PeopleSoft Finance 8.8, 8.4, PO, AP, GL, People Tools 8.45, SQR, UNIX shell scripting, Oracle 9i.

Confidential, Dayton, OH

Senior PeopleSoft Developer

Responsibilities:

• Participated actively in implementation, customization and testing of various PeopleSoft Financial modules likeGeneral Ledger, Accounts Payable and Purchasing.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists
• Involved in customizing the delivered pages, components, menus, record definition based on business requirements.
• Worked in PO and AP modules for conversion of vendors.
• Participated in design ofautomatic vendor creationprocess to support customer refund integration.
• DevelopedTrial Balance, Vendor Information reportsusing SQR in GL and AP.
• Customized Accounts Payable reports likeLN APY2050, LN APY3020etc.
• Worked on Set-up with thePurchase Order Workbenchto select various Purchase Orders.
• TroubleshotLN POP1805 processto identify and resolve issues like inconsistent printing of ‘Vendor contract details’.
• IntegratedExpenses with GLto post liabilities, payments etc.
• ExecutedTest Scriptsfor unit testing PO functionality like ‘Requisition Loader’, ‘Purge Requisition Load Request’, etc.
• Performedmatching validationbetween receipts, purchase orders, and invoices.
• ‘UpdatedGeneral Ledger’by manually adding a target Ledger to each ADB definition (for accommodating numerous enhancements to theAverage Daily Balances process)
• Queried PO tables likePO HDR, PO LINE, PO LINE SHIP, PO LINE DISTRIB, and PURCH ITEM ATTRIBfor troubleshooting PO processes.
• Designedtest plansfor AP Vendor related functionality like,Vendor Definition, One-time Vendor Definition,1099 Vendor Definition, Inactive Vendor and Vendor Maintenance.
• Participated in creatingtest scriptsand testing AP Interfaces like APPositive Payfunctionality.
• Used File Layout Definition to get data from the legacy system to people soft tables.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table
• Developed weekly status reports, reviewed configuration, developed test scripts, reviewed test results and resolution of issues during a PeopleSoft upgrade from version 8.9 to 9.0 project.
• Managed enhancement phase of the project by prioritizing multiple enhancements, including the development, testing, documenting, moving configuration and setup to production and communication to users.
• DefinedSummary Ledger ChartFieldsto be used in Summary Ledgers for most commonly used Summary Reports.
• Used different Microsoft tools in managing projects during my experience.
• Used share point to share the project details while coordinating with other teams. It worked better during production support in reducing number of tickets on production issues.

Environment: - PeopleSoft Finance 8.8, People Tools 8.45, Windows XP, SQR, PS Query, UNIX shell scripting, Oracle 9i

Confidential, Philadelphia, PA

PeopleSoft Developer

Responsibilities:

• Worked in Design, Implementation and Testing of PeopleSoft HRMS for HR, Payroll and Time & Labor.
• Reviewed functional requirements for the reports, identified gaps, and delivered gap analysis.
• Created technical specifications based on approved functional specifications
• Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists
• Created new SQR programs like Confidential and HRIS Premiums Interface.
• Customized lockbox SQR program AR250001 to read the input file and transfer data to populate 5 staging tables namely AR LOCKBOX EC, AR DEPOSIT EC, AR IDCUST EC, AR PAYMENT EC, and AR IDITEM EC.
• Used File Layout Definition to get data from the legacy system to people soft tables.
• Used Application messaging to receive Purchase order information from a Legacy system and create PO’s in PeopleSoft.
• Developed a custom page in Commitment Control to capture and budget check third party transactions.
• Developed a Cash basis accounting system to meet client requirements since delivered PeopleSoft only supports Accrual based accounting.
• This custom process separates the accrual and cash entries generated from AP, AR & GL and posts the entries into a separate ledger in GL.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Provided continuous support for the Functional team in resolution of numerous other technical issues that arose during the implementation.
• Prepared technical documentation for every project and their release versions.
• Developed an application engine program to create security interface file with all terminated employees information after each pay period and sent to the information security department.
• Developed complex SQR reports and SQCs to suit the business requirements of the company using PeopleSoft XML Publisher.
• Developed SQR reports that displays leave accrual information by leave plan and employee.
• It includes information such as plan year eligibility hours, Carryover hours earned year-to-date, hours taken year-to-date, and remaining leave balances.
• Developed various PS queries in order to help the client day-today activity.

Environment: - PeopleSoft Finance 8.8, PO, AP, GL, People Tools 8.46, Application Designer, People Code, Process Scheduler, PS-Query, XML Publisher, SQR, SQL plus, Application Engine, Oracle 9i, MS Excel, Windows NT/2000.

Confidential

Peoplesoft Developer

Responsibilities:

• Prepared functional and technical specifications for Asset Management which shows the NBV (Net Book Value) of the different asset categories being written to a space delimited format sequential output file. Collected information from the users and compared the legacy system balance sheet pointers with the AM asset categories.
• Written a program which reads voucher line data for special chicken items that have been purchased within a period for a particular BU.
• The item multiplier (from master item table) is multiplied by the sum of the voucher quantity for a given DeptID / Item combination.
• Prepared functional and technical specifications for Project Costing which moves the Actual Spending costs from Projects to Lucernix.
• Collected information from the users and the existing JCL COBOL programs and written to a fixed length output file.
• Written a SQR report which shows stores that have on hand inventory quantities outside an allowable tolerance for the period and the tolerances differ by brands.
• Written an APP Engine interface which produces text files that contain inventory confirmation or inventory error email messages.
• Wrote a App Engine interface which moves the Projects Actual Costs and AP Vendor information to Lucernix (third party system)
• Customized the AP to AM App Engine by modifying to NOT send dollars from AP to AM if the charge is related to a project that will send assets to AM.
• Written AP to AM Custom App Engine Batch program.
• This App Engine program updates the Interface type, Transaction code, Asset Class, Category in Interface tables after the AM interface tables have been populated with AP data.
• Customized the existing Projects Transactional Crystal report to show only the AP approved Vouchers being sent to PC daily after the PC AP TO PC app engine process is run.
• Designed a SQR report which captures potential incorrect inventory transfer Journal entries for each store by period. The report lists details for both the sending and receiving store of the transfer.
• Generated a report using SQR to display the error data in the file sent by the carriers by comparing with the system tables.
• Written a Component Interface which moves the Approved Budget Set Data from Lucernix (third party system) to PS Project Costing.
• Wrote a App Engine program which does the Excel to AM Upload for the new assets, retired assets and the impaired assets.
• Written a Conversion program to update the location codes in the DEPT TBL with the store locations which are in the Legacy system.
• Written a SQR interface to extract the property loss data for Projects and Charges each period and is sent to INFORM which is a outside vendor.
• Created JCL wrappers for the Capitalized Assets and the Asset Categories NBV and sent the data to the output data sets.
• Developed a SQR multiple report which shows the new assets added and merged during the previous period by deptid and operating unit.
• Developed a SQR interface to create journal entries in GL for estimated depreciation of closed Projects that have not interfaced actual depreciation to GL.
• Written a SQR report which shows the list of fully depreciated assets for the previous closed period.
• Created a App Engine interface which extracts various asset information and Net Book Value for all Capitalized assets creating fixed-length format sequential output file which is being sent to Lucernix.
• Wrote a SQC which accesses the Deptid-Operating Unit tree structure (LEGALENTITY tree) to derive the operating unit based on the business unit and the deptid being passed to the SQC.
• Written DB2 stored procedures to retrieve Lease data, CAM and property tax exposures to calculate the required asset reserves for all the stores.
• The data is retrieved from SLIM database (SQL server) and placed in Microsoft Excel Closed Store Reserve Model.
• Performed customizations of Project Costing Module like graying out and adding fields as per the business requirements.
• Debugged the complex issue of PS Project Delivered Report (PCPL2000.sqr) not returning any data by loading PS PC RPO using APP Engine program PC RPO.
• Modified the PeopleCode as per the business rules laid down by the client.

Environment: PeopleSoft Financials 8.4 (Project Costing, Asset Management, General Ledger, Accounts Payable, Inventory), Application Designer, PeopleCode, Application Engine, PS/Query, SQR 6.0, SQC, DB2,COBOL,SQL Server, nVision, SQL, Win 2K Server, UNIX, DB2,OS/390