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

Senior PeopleSoft Developer

Confidential

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

Senior PeopleSoft Developer

Confidential

• 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

Senior PeopleSoft Developer

Confidential

• 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

Senior PeopleSoft Developer

Confidential

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

Senior PeopleSoft Developer

Confidential

• 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

Senior PeopleSoft Developer

Confidential

• 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

Senior PeopleSoft Developer

Confidential

• 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