SUMMARY

• Over 10 years of extensive IT experience in Analysis, Design, Development, and Implementation of Client - Server and ERP Applications.
• Over 9 years of experience in Upgrade, Support, Customization and Implementation of PeopleSoft Financials 9.1/9.0/8.9/8.8/8.4/8.0 (General Ledger, Account Receivables, Account Payables, Asset Management, Billing and Expenses), SCM (Order Management, Inventory and Purchasing).
• Demonstrated experience in analysis and documentation of various PeopleSoft Security.
• Procedures and Maintenance as per Sox compliance (Sarbanes-Oxley compliance).
• Expertise in PeopleSoft Development tools (Application Designer, Application Engine, Data Mover), Integration tools (Integration Broker, Component Interface, Application Messaging, Business Interlink, Workflow), Administration tools (Upgrade Assistant, Security, Tree Manager), and Reporting tools (SQR, Query, nVision, Crystal Reports).
• Working noledge in Oracle, MS SQL Server, PL/SQL Triggers, Procedures and Packages.
• Excellent communication and interpersonal skills.

TECHNICAL

ERP: PeopleSoft Financials/SCM 8.0/8.4/8.8/8.9/9.0/9.1/9.2 (GL/AR/AP/AM BI/EXP/PO/INV/OM)

PeopleTools: 8.4x/8.5x (App. Designer, App. Engine, Integration Broker, Component Interfaces, PeopleCode, Upgrade Assistant, Data Mover Workflow, Security, Tree Manager, Configuration Manager)

Reporting Tools: SQR, Crystal Reports, XML Publisher, PS/nVision

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, MS-DOS

Databases: Oracle 9i/10g/11i, SQL Server 7.0/2000, Teradata

Languages: C, C++, Visual Basic 6.0, SQL, PL/SQL, HTML, DHTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis MN

PeopleSoft Finance developer

Responsibilities:

• Retrofit previous customizations and integrations from 8.9 into 9.2 FSCM vanilla database for modules including BI, AR, GL, PO, Grants, Banking, AP, T&E.
• Completed miscellaneous enhancements and resolved defects using PeopleTools 8.53 using Application Designer, Application Package, Component Interface, BI Publisher.
• In Billing WorkCenter, resolved teh error message when teh New Window link is pressed.
• Created a custom XML Publisher UMGMABIN for Grants process from teh crystal report of teh same name.
• Created teh Run Control page for a custom process UM ACH Origination File Load process (UMFTR018) which is used for loading Bank Statements so that teh File Path and File Name of inbound file and Post Process FIle Directory is configurable on teh Run Control page.
• Modified a custom process UMFTR018 so that teh inbound file is archived and File Path and File Name of inbound file and Post Process FIle Directory's configurable values are used.
• Modified custom App Engine UMFCA011 to update teh address type so that it matches wif teh address types in HR.
• Modified teh My Wallet Detail page so that labels are consistent when teh page is accesses via Expense Report and Employee Self-Service.
• Added some custom message on Regular Voucher entry page.
• Modified custom BI publisher template UMFAR203.rtf in AR which was used for viewing teh online payment deposit so that certain fields does not get wrapped. Also fixed teh currency formats of several fields.
• Retrofit expense report EXC4500 so that users can view and print dis bar coded report.
• Retrofit Add PO page so that it shows all teh warning message while trying to delete teh PO lines which were copied from Requisition.

Environment: PeopleSoft FSCM 9.2, PeopleTools 8.53, People Code, Application Engine, Integration Broker, SQR, Component Interface, PS Query.

Confidential, Atlanta GA

PeopleSoft Finance developer

Responsibilities:

• Created Web Service (Integratin Broker), to load teh items into peoplesoft, where teh source is Appian software.
• Created a custom Application Engine to Create teh items from one SETID to another as teh target SETID is teh one that teh users will shop online.
• Created Outbound Report for teh list of Exceptions when Item Sync Runs.
• Created Outbound Report for teh list of validation that teh file failed when loading teh items from Appian
• Created Custom Page as a place holder for teh Requisitions that are going to be Sourced.
• Customized teh delivered App Engine PO REQSORC to pull teh Requisitions from teh custom run control page instead of using teh delivered Run control page parameters.
• Setup teh Integration Broker and written teh Application Package peoplecode to create items and Kits sent from third party(Appian).
• Modified teh custom Crystal to include various parameters, like Bar Code, Registration Number, etc., on teh Invoice.
• Created custom Application Engine to Create teh Entries to INTFC PROJ RES (PC INTFEDIT will load teh PROJ RESOURCE table) table by pulling teh data from teh Billing.
• Created Custom Application Engine to load teh INTFC ACT GEN (PC INTF GEN will create teh Project Activities).
• Created Matrix nVision report to list all teh amounts of expense, revenue, benchmark for teh customers, from teh Projects Costing.
• Created Matrix nVision report to list out all teh revenue, expense amounts nPloded by Account and Department from detailed Ledger.
• Created Matrix drilldown nVision report nPloded by Period, for teh Account-Dept amounts. (General Ledger(GL))
• Created Custom Scripts to Load Categories, Item Groups, Product Groups.
• Created a custom Application Engine to add teh categories to teh Catalog tree as there are hundreds of categories newly created.
• Modified teh POPO005(PO Dispatch) to show more attributes, from Items, on teh pdf.
• Created custom inbound Application Engine to load teh Staging tables of EDI Orders as teh Orders are sent to client via a flat file.
• Modified teh delivered Application Engine OM BACKGRND, for Reprice, as to consider teh quantity of pervious orders to get teh correct discount tiers.
• Modified teh Online re-pricing for an Order as to consider teh quantity of pervious orders to get teh correct discount tiers.
• Modified teh delivered SQR OMBILL as teh Quantity of teh Schedule line of teh order is split to multiple rows.
• Created a custom Application Engine, as an inbound process, to load teh Shipping Instructions, which comes 2 days delay after teh real Purchase Order is created.
• Modified teh Delivered App Engine Depreciation(AM DEPR CALC) as there are some Performance issues.
• Modified teh Delivered App Engine AMPS1000 process to Consolidate teh assets based on teh custom field in teh Receipt entry.

Environment: PeopleSoft FSCM 9.1, PeopleTools 8.52, People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, Oracle, PS Query.

Confidential, Richmond, VA

PeopleSoft Developer

Responsibilities:

• dis project TEMPhas a total of 4 parts, 3 interfaces and a reconciliation process.
• Interfaces: Three interfaces were designed, developed and implemented. Teh first interface, teh GAP Export process, was created to get teh data from Teradata tables to PeopleSoft tables using a custom application package that consisted of inserting PeopleSoft data to a Teradata global temp table, and tan updating dis temp table and finally to insert those data to PeopleSoft tables. Tan teh data had been processed through a series of verification and validation process. Finally, teh peoplesoft data was put in an outbound file and kept in an Unix server from where teh Vendor company can pick up teh file.
• Teh second interface, teh acnoledgement file, was an custom-built application engine process which was created to load teh PeopleSoft tables from teh inbound file sent by teh Vendor company. Their data was processed through a set of verification and validation process before inserting into teh appropriate PeopleSoft tables.
• Customized teh AP (Payables) VCHR EXPRESS component.
• Corrected teh Journal Loading SQRs, in GL(General Ledger), when Ledger went out of sync because of Audit Codes
• Solved teh issue of giving teh wrong accounts in teh vouchers (AP(Payables)) and realized after teh voucher is posted to GL.
• Customized teh Regular entry voucher page in AP(Payables) to put some hidden fields so that a third party tools(Imaging) can use those fields to get teh image of teh invoice.
• Solved teh issue when teh Voucher Build (in AP (Payables)) went to No Success because of teh zero amount divisor.
• Worked Extensively wif Component Interface, application messaging and App Engine
• Teh third interface, teh monthly invoice file, was another custom-built application engine process which was created to load teh peoplesoft tables from teh inbound file sent by teh Vendor company. dis data was also processed through a set of verification and validation process before inserting into teh appropriate peoplesoft tables.

Environment: PeopleSoft FSCM 9.1(AP,AR,GL,AM,PC,ePro,PO,Expenses) People Tools 8.51 People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, XML, STAT, Publisher, Oracle 11g, PS Query.

Confidential, Georgetown, KY

PeopleSoft Developer

Responsibilities:

• Wrote Technical Design Documents for different requirements using teh Business Requirement Document. Developed teh requirements according to teh Technical Design Document.
• Worked on eReceipts module and Rewrote teh process to make it as one process instead of separate steps.
• Worked on Item Inquiry and Corrected code to include all transaction groups and sort properly and include correct status.
• Implemented PeopleSoft 9.1 Security as per Sox Compliance.
• Involved in design, development and testing of Permission lists, users, Roles and assigned roles to users for diff Business units.
• Worked wif Business Analysts to get teh Business process information for teh custom built pages and Custom Records for Query.
• Involved in Query and Reports Security design, development and testing.
• Involved in generating Security and Auditing Reports at different Department-wise.
• Analyzed teh New Inbound map VCHRBLD for EDI Loads for AP (Payables).
• Customized teh APY2021 Crystal for AP(Accounts Payable)
• Wrote teh custom people code to check for teh combo edits since we do not use teh delivered Chatfield Edit in AP (Accounts Payable).
• Created custom Vendor Inquiry page according to teh user requirements.(Payables).
• Modified teh delivered search for items in e-procurement according to requirements.
• Solved teh issues in Workflow, inGL (General Ledger), when teh workflow is not being routed to correct people.
• Created Archive process to remove older MRPs from teh MRP tables for Material Request Page.
• Modified teh MRP Post code to mark MRP’s wif CI errors as “Errored” but continued processing of other MRPs in batch.
• Performance Tuning of teh delivered code to run more efficiently for Requisition Inquiry page.
• Tuned teh modified code (SQR) to run more efficiently for parts search page.
• Tuned teh delivered code to run more efficiently for receipt load page.
• Added PeopleCode so that TRANSACTION INV does not get loaded wif DEPTID, ACCOUNT and DOCUMENT ID field values for a particular TRANSACTION GROUP ("050").
• Set up teh eProcurement Approval workflow using AWE (Approval Workflow Engine).
• Set up teh Direct Connect (Punch Out) Vendors in eProcurement.
• According to teh requirements, controlled dispatch of Purchase Orders from Procurement Contracts.
• Developed teh App Engine, to load teh Journal from a Flat file (General Ledger).
• Involved in teh Setup of Financials at Business Unit Level.
• Developed teh requirements for tracking teh reassignment history of worklist items.
• Involved in complex cross module Conversion of Contracts from (Projects/Activities) to 9.1(Contracts).
• Developed a custom Application Engine and XML Publisher to generate teh Monthly Expense Reports for given Business Units in Inventory.
• Worked on T&E workflow process and notified employees wif automated email message.
• Configured Local node, remote nodes and setup teh services and queues.
• Created Integration Broker to send teh Voucher Information to IBM Imaging system.
• Responsible for supporting key financial processes such as Year-End/Month-end close, Combo edit rules, spreadsheet journal imports.
• Configuration of Integration Broker, defining Gateway, creating and configuring nodes for HR and Finance.
• Created Application Engine programs using PeopleSoft File Layout, imported data from external files (.csv, .xml) to PeopleSoft Tables.
• Built custom Application Engine programs to stage expense and time entries to PC EMP RES TM table that is to be pulled into Projects.
• Configured and customized teh Approval workflow for PO requisition approval based on Supervisors and dollar amounts by creating new Route Control profiles.
• Modified Report EXC9000 that which summarizes all payments by vendor, payment bank account, payment date, and employee ID.
• Written App Engine to create Bill Plan Events, Revenue Plan Events, Prepaids and Prepaid Bill Plans for provided Projects and activities
• Involved in printing teh Purchase Order copy at teh desired FAX machine.

Environment: PeopleSoft FSCM 9.1, People Tools 8.51 People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, XML, STAT, Publisher, Oracle 11g, PS Query

Confidential, Los Angeles, CA

PeopleSoft Developer

Responsibilities:

• Involved in teh Focus Project (Upgrade & Implementation) of AP, GL, Expenses, AR,Contracts and Billing modules wif their integration wif AP, GL.
• Involved in different phases of QA Testing like Unit Testing, Integration Testing and Regression Testing.
• Worked on loading contracts data from legacy systems to PeopleSoft contracts to create contracts.
• Wrote complex SQL Queries using joins, unions and nested sub-queries. Created index on Queries for improving teh performance.
• Written peoplecode to default deptid based on peojectid for all new contracts and existed contracts.
• Modified People soft objects like Pages, views and PeopleCode according to teh business requirements.
• Created buyer purchasing attribute where buyers can update certain fields instead of all on teh Inventory Purchases.
• Was involved in administering teh operator security, object security, Tree Manager and Query security.
• Responsible for auditing of different databases for clean up of users and make teh system up-to-date.
• Involved in creating dummy user ids for testing teh different pages and reports.
• Prepared Test cases and Test Conditions for Unit & System testing of all Roles.
• Tested teh Roles in different instances and documented teh security procedures.
• Re-engineered teh entire Security Structure system to debug bad Authorizations, thereby assigning only teh required access for uses.
• Involved in Redesign, Development and testing of Permission lists, users, Roles and assigned roles to users for diff Business units.
• Set up teh workflow in Inventory when a new storage location is added.
• Customized teh page STOR LOC INQ INV in Inventory according to User’s specification
• Created custom InterUnit Expensed Issue page For Inventory according to teh requirements
• Involved in Defining teh Reservation and Backorder Rules for Inventory
• Developed different custom reports using PS Query and Crystal Reports.
• Wrote a SQR program to generate around 2500 SQL scripts for Data Integrity (Translate and YES/NO field types) validation for all teh 400 tables that are being converted across all teh modules.
• Involved in customizations of pages, components and PeopleCode related to all Financials & SCM modules.
• Modified application engine (PO CCLOAD) according to USbank file layout format for expenses module.
• Created new application engine program for expense module to update cc trans line and cc trans dist tables based on GL account codes.
• Designed and developed teh workflow for Service Vouchers(AP), to be routed to different approvers based on teh requirements.
• Involved in modification and fine-tuning of delivered SQR reports.
• Designed and developed inbound interface to load employee expenses from TravelPlus system into Account Payables module to create vouchers.
• Wrote a program to create Sub-Contractor file based on teh hours/expenses entered for subcontractor employees.
• Created an outbound file using Application Engine and Filelayout to send Purchase orders to vendors that are approved and flagged as “EDI”.
• Created new SQR invoice report for government customers to accommodate additional data elements.
• Created a custom SQR to make some pre-updates to item loader EC tables before running item loader price list process
• Customized Journal Entry Component so that teh Journal Source Field will be display only for a group of people.
• Developed an AE program and component interface that loads teh Voucher information from legacy into teh Voucher tables.
• Configure and setup teh User Profile, Role Maint, Delete User Profile, Delete Role, Role Sync Message EIP’s between teh Enterprise Portal and HR/FSM.
• Developed Approval Workflow Engine(AWE) for Change order in Purchasing.
• Set up teh Direct Connect(Punch Out) Vendors in eProcurement.
• According to teh requirements, controlled dispatch of Purchase Orders from Procurement Contracts..
• Configure and setup teh User Profile, Role Maint, Delete User Profile, Delete Role, Role Sync Message EIP’s between teh Enterprise Portal and HR/FSM.
• Configured integration between SCM, CRM and HRMS and involved in teh set up of local and remote nodes.
• dis is one of teh complex customizations where me has to customize many 1099/AP related delivered PeopleSoft Application Engines, Pages and Records to match teh State’s Business process and requires acute Accounts Payable noledge since 1099 processing flow starts from AP 1099 Configuration and goes thru Vendor Setup, 1099 Wifhold Setup, Voucher Creation, Voucher Posting, Pay Cycle, Payment Posting, Wifhold Posting, 1099 Report Post, Creation of IRS File, Journal generation of accounting entries and printing of 1099 Forms.
• Created JCL wrappers to run batch jobs.
• Teh objective is to be in full compliance wif all Internal Revenue Service regulations and requirements including 1099 reporting and backup wifholding.
• Wrote a program to read input text file and generate scripts for all teh prompt fields of teh records being converted.
• Worked wif business users to resolve data validation errors.
• Involved in Performance Tuning of SQL scripts using Explain Plan, Indexes etc.

Environment: PeopleSoft Financials 9.0/9.1(AR,BI, AP, PO, AM, GL, epro, INV,CA, Project costing, Ex), PeopleTools 8.50/8.51, SQR, XML Publisher, Application Engine, Component Interface, PeopleCode, Workflow, STAT, Integration Broker, DB2, mainframe

Confidential, Pleasanton, CA

PeopleSoft Developer

Responsibilities:

• Handled BI, AR, AP, PO, GL, CA and Inventory production issues.
• Designed and developed inbound interface to load vendor’s data from Oracle Financials system into Ajilon custom PeopleSoft tables.
• Developed outbound interface to send GL Actuals and Budgets data in a pipe-delimited file.
• Wrote a program to create Sub-Contractor file based on teh hours/expenses entered for subcontractor employees.
• Solved teh issue of Voucher Matching since teh POs were forcefully closed before they were matched completely.
• Modified PORQ010.sqr to get teh comments printed or not printed according to a check box.
• Fixed teh AR PAYLOAD step which populated only teh customer number and business unit as part of customer information, ignoring other fields.
• Developed a new SQR Report for tracking teh Shipment Schedule.
• Set up teh workflowfor Requisitions. dis will save alot of time to create e-mail and explain teh PO and copy teh approval text to teh PO.
• Developed a new Crystal Report to determine teh Buying Agreement Expiration Details.
• Modified teh Sales Order Report OMS1000 (SQR) to include teh detailed information of teh customer.
• Configured integration broker to publish data from HR (Personal, Job, vendor) to PeopleSoft Financial.
• Involved in setting up teh Application messaging to synchronize teh User Profiles in FSCM and HR.
• Created custom email messages to notify employees about their expense report status.
• Tuned CA BI INTFC AE for better performance.
• Involved in creating a process to build inventory demand which verifies teh inventory table BU ITEM INV and tan consequently checks teh inventory availability and tan a calculation process is developed to source it to a PO using Purchasing module.
• Customized teh Business Process for GL journal approver based on teh Dollar amount using Approval rule sets in Virtual approver.
• Worked on epro punch out setup.
• Fixed teh AR UPDATE process which did not insert values into PENDING ITEM when an item is created via a payment worksheet.
• Developed interface for loading early payoff and late remit fees from SBO, while loading pending items in AR.
• Wrote new SQR to report Cost by BU report to get all teh details of teh items for all business units.
• Worked extensively on application engine programs like Payment Predictor, Receivable Update of AR and Voucher Posting, Payment Posting, Matching of AP.
• Customized teh POP0005.sqr for printing Purchase Orders.
• Involved in customizations of pages, components and PeopleCode related to all Financials & SCM modules.
• Created Messages, Message Channels, Message Nodes and modified People code in Publish/Subscribe methods.
• Involved in setting up local node and external nodes in HRMS and FMS.
• Resolved Billing and AR month end close issues.
• Modified invoice print programs for specific requirements.
• Developed a program to load Project Resource table from AR item tables.
• Tuned PS queries and several programs reducing processing times from hours to minutes.

Environment: PeopleSoft Financials 8.8/9.0(Account Receivables, PO, Billing, Account Payables, General Ledger, Project Costing, Inventory), PeopleTools 8.49, SQR, Application Engine, Component Interface, PeopleCode, Workflow, Integration Broker, Oracle 9i/10g, HP-UX.

Confidential, Richmond, VA

PeopleSoft Developer

Responsibilities:

• Developed a SQR report c1ps31 captures all teh journals posted since teh last time teh process was run and also pull teh ledger balances as of that point in time.
• Developed an App. Engine report C1 HRDTRL that validates teh Total Journal Header and lines sent in a flat file.
• Developed C1 TXCLD.SQR that reads data from Flat File Containing AR Items information and loads into PS tables PS Group Control and PS Pending Item.
• Worked on setup procedures for Bank Reconciliation Batch process in AP and scheduled teh batch through CONTROL-M.
• Configured Pay Cycle Manager for Helix vendor Group in AP.
• Developed Mass change template definition to transfer and retire Assets in PeopleSoft Asset Management.
• Implemented formula based Groping and Sorts in teh Reports.
• Created a Purchase Summary Crystal report that incorporates teh same logic and calculations as teh delivered SQR performs.
• Excel Exports wif data and Formats are carried out for further processing and PDF and HTML exports are done for Viewing and printing teh reports.
• Customized change-load process that compares staged source record fields wif teh target record fields of teh changed purchase order.
• Extensively worked wif SQLExec, RowSet, RowScrollSelect, ScrollFlush, SortScroll, ActiveRowCount and corresponding Functions using PeopleCode, etc. to perform database manipulations.
• Involved in debugging various PeopleCode events and functions in resolving technical & functional issues.
• Used Debug Utilities to trace PeopleCode and to create Message Catalog tables.
• Designed and developed various types of SQR reports (Pivot, Tabular, Chart and OLAP Query Reports) used by various User Groups.
• Customized teh delivered SQR, nVision and Crystal reports.
• Used Process Scheduler for scheduling teh processes for custom-built procedures like SQR Reports, PS Jobs, and Crystal Reports.

Environment: PeopleTools 8.47 (GL, AP, AM, PO AR & Billing), Application Designer, PeopleCode, Application Engine, PS/Query, Data Mover, Crystal Reports, PSnVision, SQR, Oracle 9i, Windows 2000, CONTROL-M Scheduler

Confidential, Allen, TX

PeopleSoft Developer

Responsibilities:

• Involved in fit/gap analysis wif teh Functional Team of Purchasing and Inventory as a part of teh preparation of documentation.
• Developed various recommendations and approaches addressing customizations for teh client.
• Configured and customized teh Approval workflow for PO requisition approval based on Supervisors and dollar amounts by creating new Route Control profiles.
• Customized teh purchase order consolidation process to allow for consolidation based on teh Ship To locations to accommodate vendor requirements.
• Transferred vendor data from legacy systems, MMS, to PS Vendor tables using Component Interface, Application Engine and provided access through online pages.
• Customized teh record object VENDOR TYPE and added new Xlat values so as to differentiate a particular group of vendors for whom TIN modification id required.
• Customized teh ORDENT FORM LINE page by adding teh sorting option which enables grouping of similar items together on a PS Quote.
• Reformatted and Mapped teh Lockbox Inbound file which is loaded into EC tables through Lockbox Load process.
• Developed File Layout Definitions and Application Engine program to upload teh legacy Item Master data from a formatted flat file into PeopleSoft STAGED INF INV staging tables.
• Wrote a custom SQR report - DISCOUNT LOST, for identifying teh dollar amount lost for not paying teh Invoices on-time to take advantage of teh discount.
• Developed Various Custom reports according to client requirements using SQR, Crystal Reports for GL and AP.
• Customized teh AP PSTPYMNT Application Engine process to create zero-dollar vouchers. Worked and setup procedures for Reconciliation process in AP. Was also involved in teh setup of Pay Cycle Manager in AP.

Environment: PeopleSoft Fin/SCM 8.4(GL, AP, AR, PO, INV,CA and OM), PeopleTools 8.4, SQR, Oracle 9i, HP-UX, Windows NT 2000