CANDIDATE HIGHLIGHTS:

• 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 knowledge in Oracle, MS SQL Server, PL/SQL Triggers, Procedures and Packages.
• Excellent communication and interpersonal skills.

TOOLS/SKILLS:

ERP: PeopleSoft Financials/SCM 8.0/8.4/8.8/8.9/9.0/9.1 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

EDUCATION:

BTech in Comp Sc from Indian Institute of technology, Kharagpur, India 2001

MS in Computing and Information Systems from Kansas State Univ, Manhattan, KS 2003

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Finance developer

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

PeopleSoft Developer

• This project has a total of 4 parts, 3 interfaces and a reconciliation process.
• Interfaces: Three interfaces were designed, developed and implemented. The first interface, the GAP Export process, was created to get the 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 then updating this temp table and finally to insert those data to PeopleSoft tables. Then the data had been processed through a series of verification and validation process. Finally, the peoplesoft data was put in an outbound file and kept in an Unix server from where the Vendor company can pick up the file.
• The second interface, the acknowledgement file, was an custom-built application engine process which was created to load the PeopleSoft tables from the inbound file sent by the Vendor company. Their data was processed through a set of verification and validation process before inserting into the appropriate PeopleSoft tables.
• Customized the AP Payables VCHR EXPRESS component.
• Corrected the Journal Loading SQRs, in GL General Ledger , when Ledger went out of sync because of Audit Codes
• Solved the issue of giving the wrong accounts in the vouchers AP Payables and realized after the voucher is posted to GL.
• Customized the 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 the image of the invoice.
• Solved the issue when the Voucher Build in AP Payables went to No Success because of the zero amount divisor.
• Worked Extensively with Component Interface, application messaging and App Engine
• The third interface, the monthly invoice file, was another custom-built application engine process which was created to load the peoplesoft tables from the inbound file sent by the Vendor company. This data was also processed through a set of verification and validation process before inserting into the appropriate peoplesoft tables.

Reconciliation part :

• An reconciliation application engine was built to do reconciliation of the monthly invoice data sent by the Vendor company with the Carmax data. Several validation and verification was done on both the vendor data and the Carmax data. The Write-off application engine was used as a part of this process to take care of minor difference in dollar amounts. The AR REFUND process was customized to do any refunds
• needed at the end of reconciliation. All the above application engines were built in AR.
• A custom Component Interface was designed, developed and implemented which would let the users to
• order all the initial materials needed when a new Carmax store is opened.

Production support role :

• Assisted the production support front-end personnel in resolving issue in eProcurement Favorite page which showed them error while the users tried to access some particular item data.

UAT support role:

• Assisted the users while they tested a newly built Payment Remittance process and heavily modified AP Paycycle process with the data they needed to test from Teradata database and making sure that those data are available in PeopleSoft tables as well.

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

PeopleSoft Developer

• Wrote Technical Design Documents for different requirements using the Business Requirement Document. Developed the requirements according to the Technical Design Document.
• Worked on eReceipts module and Rewrote the 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 with Business Analysts to get the Business process information for the 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 the New Inbound map VCHRBLD for EDI Loads for AP Payables .
• Customized the APY2021 Crystal for AP Accounts Payable
• Wrote the custom people code to check for the combo edits since we do not use the delivered Chatfield Edit in AP Accounts Payable .
• Created custom Vendor Inquiry page according to the user requirements. Payables .
• Modified the delivered search for items in e-procurement according to requirements.
• Solved the issues in Workflow, in GL General Ledger , when the workflow is not being routed to correct people.
• Created Archive process to remove older MRPs from the MRP tables for Material Request Page.
• Modified the MRP Post code to mark MRP's with CI errors as Errored but continued processing of other MRPs in batch.
• Performance Tuning of the delivered code to run more efficiently for Requisition Inquiry page.
• Tuned the modified code SQR to run more efficiently for parts search page.
• Tuned the delivered code to run more efficiently for receipt load page.
• Added PeopleCode so that TRANSACTION INV does not get loaded with DEPTID, ACCOUNT and DOCUMENT ID field values for a particular TRANSACTION GROUP 050 .
• Set up the eProcurement Approval workflow using AWE Approval Workflow Engine .
• Set up the Direct Connect Punch Out Vendors in eProcurement.
• According to the requirements, controlled dispatch of Purchase Orders from Procurement Contracts.
• Developed the App Engine, to load the Journal from a Flat file General Ledger .
• Involved in the Setup of Financials at Business Unit Level.
• Developed the requirements for tracking the 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 the Monthly Expense Reports for given Business Units in Inventory.
• Worked on T E workflow process and notified employees with automated email message.
• Configured Local node, remote nodes and setup the services and queues.
• Created Integration Broker to send the 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 the 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 the Purchase Order copy at the 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

PeopleSoft Developer

• Involved in the Focus Project Upgrade Implementation of AP, GL, Expenses, AR,Contracts and Billing modules with their integration with 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 the 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 the business requirements.
• Created buyer purchasing attribute where buyers can update certain fields instead of all on the Inventory Purchases.
• Was involved in administering the operator security, object security, Tree Manager and Query security.
• Responsible for auditing of different databases for clean up of users and make the system up-to-date.
• Involved in creating dummy user ids for testing the different pages and reports.
• Prepared Test cases and Test Conditions for Unit System testing of all Roles.
• Tested the Roles in different instances and documented the security procedures.
• Re-engineered the entire Security Structure system to debug bad Authorizations, thereby assigning only the 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 the workflow in Inventory when a new storage location is added.
• Customized the page STOR LOC INQ INV in Inventory according to User's specification
• Created custom InterUnit Expensed Issue page For Inventory according to the requirements
• Involved in Defining the 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 the 400 tables that are being converted across all the 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 the workflow for Service Vouchers AP , to be routed to different approvers based on the 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 the 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 the Journal Source Field will be display only for a group of people.
• Developed an AE program and component interface that loads the Voucher information from legacy into the Voucher tables.
• Configure and setup the User Profile, Role Maint, Delete User Profile, Delete Role, Role Sync Message EIP's between the Enterprise Portal and HR/FSM.
• Developed Approval Workflow Engine AWE for Change order in Purchasing.
• Set up the Direct Connect Punch Out Vendors in eProcurement.
• According to the requirements, controlled dispatch of Purchase Orders from Procurement Contracts..
• Configure and setup the User Profile, Role Maint, Delete User Profile, Delete Role, Role Sync Message EIP's between the Enterprise Portal and HR/FSM.
• Configured integration between SCM, CRM and HRMS and involved in the set up of local and remote nodes.
• This is one of the complex customizations where I have to customize many 1099/AP related delivered PeopleSoft Application Engines, Pages and Records to match the State's Business process and requires acute Accounts Payable knowledge since 1099 processing flow starts from AP 1099 Configuration and goes thru Vendor Setup, 1099 Withhold Setup, Voucher Creation, Voucher Posting, Pay Cycle, Payment Posting, Withhold 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.
• The objective is to be in full compliance with all Internal Revenue Service regulations and requirements including 1099 reporting and backup withholding.
• Wrote a program to read input text file and generate scripts for all the prompt fields of the records being converted.
• Worked with 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

PeopleSoft Developer

• 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 the hours/expenses entered for subcontractor employees.
• Solved the issue of Voucher Matching since the POs were forcefully closed before they were matched completely.
• Modified PORQ010.sqr to get the comments printed or not printed according to a check box.
• Fixed the AR PAYLOAD step which populated only the customer number and business unit as part of customer information, ignoring other fields.
• Developed a new SQR Report for tracking the Shipment Schedule.
• Set up the workflow for Requisitions. This will save a lot of time to create e-mail and explain the PO and copy the approval text to the PO.
• Developed a new Crystal Report to determine the Buying Agreement Expiration Details.
• Modified the Sales Order Report OMS1000 SQR to include the detailed information of the customer.
• Configured integration broker to publish data from HR Personal, Job, vendor to PeopleSoft Financial.
• Involved in setting up the Application messaging to synchronize the 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 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 the Business Process for GL journal approver based on the Dollar amount using Approval rule sets in Virtual approver.
• Worked on epro punch out setup.
• Fixed the 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 the details of the 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 the 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

PeopleSoft Developer

• Developed a SQR report c1ps31 captures all the journals posted since the last time the process was run and also pull the ledger balances as of that point in time.
• Developed an App. Engine report C1 HRDTRL that validates the 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 the 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 the Reports.
• Created a Purchase Summary Crystal report that incorporates the same logic and calculations as the delivered SQR performs.
• Excel Exports with data and Formats are carried out for further processing and PDF and HTML exports are done for Viewing and printing the reports.
• Customized change-load process that compares staged source record fields with the target record fields of the changed purchase order.
• Extensively worked with 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 the delivered SQR, nVision and Crystal reports.
• Used Process Scheduler for scheduling the 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

PeopleSoft Developer

• Involved in fit/gap analysis with the Functional Team of Purchasing and Inventory as a part of the preparation of documentation.
• Developed various recommendations and approaches addressing customizations for the client.
• Configured and customized the Approval workflow for PO requisition approval based on Supervisors and dollar amounts by creating new Route Control profiles.
• Customized the purchase order consolidation process to allow for consolidation based on the 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 the 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 the ORDENT FORM LINE page by adding the sorting option which enables grouping of similar items together on a PS Quote.
• Reformatted and Mapped the Lockbox Inbound file which is loaded into EC tables through Lockbox Load process.
• Developed File Layout Definitions and Application Engine program to upload the 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 the dollar amount lost for not paying the Invoices on-time to take advantage of the discount.
• Developed Various Custom reports according to client requirements using SQR, Crystal Reports for GL and AP.
• Customized the AP PSTPYMNT Application Engine process to create zero-dollar vouchers. Worked and setup procedures for Reconciliation process in AP. Was also involved in the 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

CANDIDATE HIGHLIGHTS:

• 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 knowledge in Oracle, MS SQL Server, PL/SQL Triggers, Procedures and Packages.
• Excellent communication and interpersonal skills.