EXPERIENCE AND SKILLS SUMMARY

• Twelve 12 years experience in Application development and design in ERP PeopleSoft Financial/SCM , Account Payable AP , Purchasing PO , GL, Asset Management AM , Project Costing, Contracts, Billing, Grants, ePro and Inventory, HRMS, Payroll, Benefits, Time and Labor, Recruiting, Expense, Absence Management , PeopleSoft SCM C, C , window 95/98/2000, Windows NT, UNIX, Oracle 7.3 8.x 10g, SQL Server, DB2, PL/SQL, Sybase.
• Proficient in new implementation of the PeopleSoft Financial, AP, GL, AM, Payroll , upgrading the application using the upgrade assistance tool and applying the different service pack and bundle to the existing PeopleSoft application.
• Proficient exposure of all phases of the system development life cycle including quality assurance. Thorough understanding in Database application development using Oracle 7.x, 8.x and 9i PL/SQL, Forms 4.5, Reports 2.5, Power Builder 5.0.
• Project experience in developing and customizing PeopleSoft Human resources, Benefits and Payroll applications. Administered the operator security.
• Worked extensively on People Tools Application Designer, Data designer, Panel designer, Menu designer, Process Scheduler, Operator Security .
• Worked extensively on generating reports using SQR, Crystal Report.
• Modified People Code for validations and manipulations, Used Application Reviewer for debugging and Application Upgrader to move objects from test environment to production environment.
• Proficient analytical and programming skills.

SOFTWARE AND LANGUAGES

APPLICATIONS:

PeopleSoft V 6.0, 7.0, 7.53, 8.0, 8.4, 8.8,9.0 and 9.1 , PeopleTools 8.51, 8.52 Financial, Account Payable AP , General Ledger GL , Purchasing PO , Asset Management AM , Inventory IN , HRMS, Payroll, benefits, Time and Labor, Student Financial and Student Record.

PEOPLE TOOLS:

Application Designer, Process scheduler, SQR/Crystal reports, Data Mover, Application Engine, Query Manager, configuration Manager, Workflow Administrator, application Upgrade, Application messaging, Integration Broker , EDI Manager, XML Publisher

PROGRAMMING LANGUAGES:

C, C , Pro C, HTML, COBOL, JAVA, ASP Active Server Pages .

DATABASE:

Oracle 7.x, 8.x, 8i, 9i, 10g , SQL Server, DB2

TECHNOLOGIES:

Object Oriented Design and analysis, Client Server.

OPERATING SYSTEMS:

MS-DOS, UNIX HP, AIX , Windows95/98/2000/XP and Window NT.

PROJECTS EXPERIENCE

Confidential

Senior PeopleSoft Developer

• Worked as Senior Consultant for upgrade from 8.8 to 9.1 of PeopleSoft FSCM Gl, AP, PO and adding the AR and AM module, HCM Module HR, Benefits BEN , Absence Management AM , Recruiting REC , Time and Labor TL , Expense and Payroll .
• I was responsible for the following
• Design and Developed the interface program to upload the Open items and Customer from third party system to PeopleSoft AR.
• Developed the ExcelToCI to upload the asset to the staging table and fix the Transaction loader program to load the AM core tables.
• Configure, design and Developed the AWE Workflow for Journal approval.
• Convert the archive payroll data into Payroll tables.
• Developed the sqr program to populate the absence paygroup field on the Job Table as needed.
• Design and developed the script to convert the Interview Location.
• Design and developed the procedure, script and program for legal question conversion for 9.1 recruiting module.
• Worked on the Timesheet customization related to maintain timesheet reporting data page and other prompt table based on the business needs.
• Customize the prompt table and view for correct Absence Paygroup Mapping.
• Developed the SQL script for W2 Employee consent process to setup automatically when we go live with 9.1.
• Responsible for conversion and validation of the data for Recruiting module and modified the recruitment letters for offer letter, deny and interview letter using the XMP.
• Responsible for go live production issue support.

SOFTWARE: PeopleSoft HCM 8.8 and 9.1 HR, BEN, TL, PAY,AM, EL,REC , FSCM GL,AP,PO,AM and AR ,Oracle 11, People Tools 8.52

Confidential

Senior PeopleSoft Developer

• Design and developed the Work order calendar, page and component. It display list of the work orders on a given day on Monthly calendar. It also has the link associated with each work order so it takes you the work order component associated with it.
• Confidential Senior PeopleSoft Developer
• Involved in new implementation of PeopleSoft Financial Module AP, GL, PO, ePro, AR, AM . I was responsible for the following
• Payment history Conversion, design and developed the application engine program to upload the Payment history data from old Lawson system to PeopleSoft.
• Design and developed the ExcelToCI for Project Id Chatfield's, speedchart fields and ship to location code upload.
• Design and developed the application engine process to reconcile the AP payment.
• Design and developed the OFAC interface for creating the vendors file and send to third party system to scan it and identify the illegal vendors.
• Developed the Excel to CI to upload the user preference set for PO and Requester.

SOFTWARE: PeopleSoft Financial/SCM 9.1 AP, GL, PO, ePro, AR, AM , Crystal Report, nVision, Oracle 11, People Tools 8.52, XMLP

Confidential

Senior PeopleSoft Developer

• It was a sort term project to resolve the 1099 vendors setup, payment issue and sent the IRS file for 1099 vendors and payment correctly for year 2011 once they go live with PeopleSoft that year. I have completed the following task to resolve the 1099 issue.
• Correct the setup for 1099 in PeopleSoft for year 2011 and train the AP core user, how to setup the 1099 setup in future.
• Clean data for 1099 vendors and payment information which were not converted correctly as part of PeopleSoft implementation.
• Setup and run all processed step by step to create the IRS file and print the copy B forms for 1099 withholding vendors.
• Create the manual for all 1099 withholding process step by step and train the users how create the IRS file and print the copy B form for Withholding Vendors.

SOFTWARE: PeopleSoft Financial/SCM 9.1 AP, GL, PO, ePro , Crystal Report, nVision, Oracle 11, People Tools 8.52, XMLP

Confidential

Senior PeopleSoft Developer

• Involved in a new implementation of Financial Module AP, GL, AM, PO, AR, PC, GR and BI for The Methodist Hospital. I was working as a senior PeopleSoft analyst and lead developer for all RICE objects new development, customization and testing. I am working with Methodist and PWC team for creating the Functional/Technical Specification, development and testing with users.
• I was involves in the following activities as a lead developer.
• Design the Technical specs for Capital Expenditure Report, AM GL Reconciliation report, Aging Report for AR, Project Costing CIP Balance Report, Custom Drill down Record for Nvision Report, Modified the Billing process interface CA BI INTFC not to process un-paid voucher for billing.
• Design the technical specs and develop the code for PO dispatch process POPO005.sqr and POXMLP process using the XML Publisher Tool.
• I am coordinating with developer's team in china and responsible for all code review and unit testing of the RICE objects Extensions/Reports/Workflow .
• Developed the application engine program to load/Convert the assets to the staging table INTFC FIN and INTFC PHYA tables and run the transaction loader process to load the assets to the application Tables.

SOFTWARE: PeopleSoft Financial/SCM 9.1 AP, GL, PO, ePro, AR, AM, GR, PC and BI , Crystal Report, nVision, Oracle 11, People Tools 8.51, XMLP

Confidential

Senior PeopleSoft Developer

• Design and developed the Demand Fulfillment interface for creating the material stock request in inventory module from third party application Siebel using the Integration Broker message, people tool and people code.
• Customized the ITEM SYNC message to remove the non-required fields and design the layout for Siebel team.
• Design and modify the PO dispatch process to attach the pdf file for Condition and Terms.
• Integrate the PeopleSoft AP/PO module with Vertex for Sales/Use Tax.
• Developed the interface for loading and Conversion the Storage location and Items balance for Inventory module.

SOFTWARE: PEOPLESOFT 9.0 FSCM AP, PO, ePro, IN Oracle 10g, SQR reporting utility, People Tool 8.49, Quest STAT 5.3.2, Integration Broker, People Tools utilities

Confidential

Senior PeopleSoft Developer

• Design and developed the ACH Payment process using the application engine people tool to send the Email notification for the Vendors. Developed the SQL script to update the ACH vendor's email.
• Re-engineer the AP to AM interface processes and clean up the Staging tables for old corrupt data which normally cause the issue. Also create the Job definition and schedule it run nightly.
• Modified the Pre-interface AMPS1000 application engine process to improve the performance.
• Worked on the Depreciation Calculation process issue and clean up the staging table and temp data table which normally cause to fail the process.
• Modified the PO Dispatch/Print POPO005.sqr report to display the vendor information, Requestor name , Email information correctly
• Responsible for migration of projects in different environments FDEV, TST, TRN and PROD .
• Responsible for installing, testing and coordinating with functional team for new fix and patch for Financial and HCM application.
• Modified the Month End closing processes to run automatically instead of user running them manually.
• Design, developed and modified the workflow for Dispose and Transfer Assets.
• Modify the workflow business process to change the email text, format amount and email notification user id after third level of approval.
• Design the Views and sqr report to show the Payroll data by earning code to PeopleSoft Treasury module.
• Design and developed the interface to create the Journal Entries in PeopleSoft GL from Account Receive systems.
• Design and developed the custom interface using the SQR utility to create the journal Entries in PeopleSoft GL module for drug transfers in third party application Oracle service database system .
• Responsible for production support of PeopleSoft Financial application AP, PO, GL, AM, TR and month end closing.

SOFTWARE: PEOPLESOFT 8.9 SCM Financial FSCM , AP, GL, PO, ePro, AM, Project Costing , PeopleSoft HCM 9.0 Benefits and Payroll ,Oracle 10g, SQR reporting utility, People Tool 8.48, Quest STAT 5.3.2

Senior PeopleSoft Developer

Confidential

• Working on the Howard University PeopleSoft Financial AP, GL, PO, ePro, AM, Grants, Project Costing, Billing team as a senior PeopleSoft Developer responsible for Fix and Patch, upgrade, enhancement and Production issues.
• Worked on the AP Matching, Budget checking and Journal Locked issues. And installed the patch to fix those issues.
• Customized the Crystal report to apy1099 to print the vendor and address correctly so that it show up properly in envelope.
• Worked on the PO Rollover process and developed the SQL scripts to update the PO HDR, PO LINE, PO LINE DISTRIB and PO LINE SHIP to update the PO closing and Match status.
• Worked on the application Engine PO POROLL1 to improve the performance. Modified the indexes on the PS VOUCHER and PO LINE DISTRIB table using the application designer Data Administration tools.
• Worked on the project costing process PSA ACCTGGL . This creates the accounting entries from PROJ RESOURCE table.
• Worked on Physical Inventory setup in asset management and responsible to create the extract using the Mass Change template. Modified the sqr program AMPI1000 for output and input layout to add the fields.
• Worked on the Budget check FS BP issue and create the script to reset the flag of vouchers which has IN PROCESS FLG 'I'. Identified the voucher in KK SOURCE HDR table and set the flag to pick up again for processing.
• Design and developed the interfaces for Student Refund Import and Parents Loan import for quick Pay using the SQR tools.
• Modified the Grants SF272 report. It was not calculating the Base Amount correctly for some contracts. Modified the Application engine GM EDI 2 SQL step to calculate amount correctly for this report.
• Design and developed the run control page using the application designer for Student refund and Parent Loan interfaces.
• Worked on the Data Conversion for 1099 vendors from Mainframe system to the PeopleSoft application table using the SQR, SQL scripting tools.
• Responsible for creating the 1099 file for IRS and printing the tax form for 1099 vendors and adjust the withholding. Developed the SQL script to mass update the 1099 flag on withholding tables and withholding voucher table.
• Fixed the 1099 withhold setup for vendors which came from mainframe as a part of conversion.
• Create the SQL script to mass update the manual entries for adjusting 1099 payment in PeopleSoft from mainframe system because we went live in the middle of the year so payment never exist in PeopleSoft to report 1099 for IRS.
• Responsible to migration of the PeopleSoft object and project from Development environment for Test, pre-prod and production environment using the PeopleSoft STAT tool.
• I have worked with user to get the functional requirement for Student refund and Parent Loan import interface. Prepared the technical design and developed the program using the SQR .Responsible for unit testing and migration from development environment to test, pre-prod and production environment using the Qwest STAT tool.
• Involved in completed implementation of the PeopleSoft included analysis, design, Technical Specification, development, system testing and production support after go live.
• Responsible for production support and creating the SQL script to resolved the production issue or any Data Issue.

SOFTWARE: PEOPLESOFT 8.9, 9.0 SCM Financial FSCM , AP, GL, PO, ePro, AM, Grants, Project Costing, Billing, Contract, Commitment Control , Oracle 10g, SQR reporting utility, People Tool 8.48, Quest STAT 5.3.2, Crystal Report X1

Confidential Senior PeopleSoft Developer

Working on the PeopleSoft implementation of Project Costing and Billing module. Design the technical document for their custom Journal Generator process. I have created new journal generator process FS JGEN to modify such a way that it creates the Journal Header and Line entries in the custom tables EE JRNL HEADER and EE JRNL LN so that EMP user will pick up these journal entries and do some derivation based on their rules. I have created the new process and modified the people code, SQL objects and also created the new tables.

SOFTWARE: PEOPLESOFT 9.0 Financial/FSCM Project Costing, Billing , Oracle 10g, SQR reporting utility, People Tool 8.48

Confidential

Senior PeopleSoft Developer

• Working on the Fannie Mae PeopleSoft Financial GL, AP, AM, PO and ePro production support team.
• Worked on the upgrade team for the Financial AP, GL and AM upgrade from 8.4 to 9.0.
• Modified the Tax Retirement Report AMTX3200.sqr to show correct business unit and assets on the Report.
• Worked on the post upgrade issues for Asset Management. There are some Assets which are created By PO RECVPUSH process again even though these asset already has been created.
• I have worked on the PO reconcile process which was not working properly. Developed the SQL script to fix the old data and closed the PO's which suppose to be closed.
• Responsible to create and setup the recurrence batch process using the people tools and AutoSys tools.
• Worked on the Journal post process which is not able to create the Reverse Journal Entries. Journal id loaded using the spreadsheet and not able to create the reverse entries.
• Modified the vendor staple to send the correct Item description and removed the 'staple:' text from the item description.
• Worked on the sqr modification to add the restatement period on the reports after the restatement entries moved to production.
• Responsible to manage all remedy tickets Help Desk, change Request and DBmode for PeopleSoft Financial GL, AP, PO, AM and ePro Production support team.
• Worked on the Journal Generator issue which is not creating the Journal line entries form account Payable.
• Worked on the Asset Management staging table PS INTFPRE AM, PS INTFC PHY A and clean up those asset which are in the error stage by writing the SQL script.
• Worked on the Asset Depreciation issue, there are some Assets which are not depreciated correctly. I have corrected in the application table with scripts.
• Worked on the post upgrade 8.4 to 9.0 issues like voucher build creating the duplicate payment received from inbound files received for payment, some voucher are on hold for payment and ACH pay cycle process is not able to pick them up for processing.
• Create the business process and modify the Activity definition and email description using the peoples tools 8.46
• Worked on the application message using the Integration Broker to sync the accounts and chartfields.

SOFTWARE: PEOPLESOFT 8.4 and 9.0 Financial-AP, GL. PO, AM and ePro, AR, Billing , Oracle 10g Enterprise Edition, SQR reporting utility, AutoSys tools for batch, UNIX, Remedy tool, people Tool 8.46, 8.48.14

Confidential

Senior PeopleSoft Developer

Working on the Restatement Team involved in the developing the Query for Daily Journal entries, Journal voucher information , Quarterly End balance for all accounts.

• Responsible to upload the Journal Entries into the PeopleSoft using the Excel spreadsheet and run the journal edit, posting and year end process.
• Developed the DM Script to load the SQL Server to Oracle Database. Client was migrating the SQL server database to ORACLE database. As a PeopleSoft developer I have developed the DM Script to move the data.
• As a part of the integration team involved to load the Operating unit and Account into the PeopleSoft.

SOFTWARE: PEOPLESOFT 8.0 Financial-AP, GL , SQL Server, Crystal Reports, SQR reporting, Oracle

Senior PeopleSoft Developer

Confidential

• Design and developed the ExcelToCI spreadsheet to load the assets from Citigroup to the Legg Mason Asset Management module using this utility. Also design and developed the required interface component for this utility.
• Worked on the issue regarding the depreciation Calculation process- some Assets are not calculating the depreciation calculation properly so I have identified the issue and resolved it by changing through the application.
• Involved in the people tools upgrade from 8.45 to 8.47 for PeopleSoft Financial. Responsible for all tools customization Tiff Surfer utility , compare report and security changes for new permission list or web libraries.
• I was responsible to start the process scheduler, application server and clean up the cache also create the procedure for refreshing the environment and developed the shell scripts to clean up the cache for process scheduler and application server.
• Modified the PO reports lmpop005.sqr for adding the multiple lines of PO header comments and requisition component for Header Requisition comments.
• Design and developed the interface using the SQR for Japan, Hong Kong, Taiwan and Australia for AP Payment Citi Bank interface for inbound and outbound files .
• Production support for the Legg Mason Financial module AP, GL, PO, AM and HRMS module. Also used the autosys Tools for batch scheduling.
• Create the OFAC interface and report. Which specially designed to load the data from Federal Government website and compare the vendor on the PeopleSoft database This compliance with the patriot's act, in an attempt to identify the potential terrorist vendor that may exist in PeopleSoft.
• Design and developed the workflow for the expense module using the peoples code and also developed the script to update the PeopleSoft database once the Expense receipts are scanned into PeopleSoft. Developed the Application engine program to send the email for the expense approver once the expense receipts received.
• Modified the PeopleSoft object for new enhancement and issues - Requisition workflow changes, adhoc approver changes, Post Payment, ACV process, AP Matching, PO workflow, 1099 file changes for IRS, Post Voucher process, performance issue regarding the Requisition, vendor and requisitions components changed, employee update process and citi invoice upload process.
• Worked on the production issues of HRMS and Financial modules and Integration broker Message from HRMS to Financial Module.

SOFTWARE: PEOPLESOFT 8.8 Financial-AP, GL. PO and AM, ePro and Billing , HRMS 9.0 Benefits, Payroll Sybase, Crystal Reports, SQR reporting utility, Autosys tools for batch, UNIX, Shell script,