EXPERIENCE AND SKILLS SUMMARY

• Fourteen 14 years of 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.
• Project experience in developing and customizing PeopleSoft Human resources, Benefits and Payroll applications. Administered the operator security.
• Worked extensively on generating reports using SQR, Crystal Report.
• 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.

• Create the application engine process to calculate the Monthly and Daily financial Charge for customer based on their Financial terms and create the item Activity entries for those financial charges.
• Responsible to modify the open items, customer, Integration Broker message and VAT for multicurrency.
• Developed the Customer Service message to create the customer from third party system to peoplesoft and send the Customer information back to third party using the web services BIZTALK and XML message.
• Design and Developed the integration broker messages to get the invoice information from Third party system to Peoplesoft AR.

SOFTWARE: PeopleSoft Financial/SCM 9.1 AP, GL, PO, ePro, AR, PC, BI ,Integration Broker, BizTalk, Crystal Report, nVision, Oracle 11, People Tools 8.52, XML Publisher.

Senior PeopleSoft Developer

Confidential

I was responsible for the following

• Design and Developed the Aging Report, Dunning Letter, Voucher Register, Payment History by Payment, Detail Payment Register reports using SQR, Crystal report
• Design, mapping and developed the application engine program to AP Payment data from other applications to the PeopleSoft application tables. Client wants AP Payment history data to be converted to the PeopleSoft because client wants to retire the old system once they go live.
• Design and developed the ExcelToCI to upload the customers from third party system to PeopleSoft AR using the CUSTOMER, CUSTOMER MAIN CI interface.
• Developed the Application Engine conversion program to upload the open items using the component interface as a part of application engine interface program.
• Responsible to load the Open items using the application engine program with component Interface.

Senior PeopleSoft Developer

Confidential

I was responsible for the following

• Responsible to setup and configure the AWE for Journal Ledger entry approver.
• Retrofit the row level security for GL, AP and PO.
• Convert the archive payroll data into Payroll tables.
• Design and developed the ACH payment by email, modify the XML Publisher report PYMNT ADVICE and email subject text.
• Modified and retrofit the Positive payment output file for the Bank of America.
• Responsible to retrofit all the customization and enhancement for Asset Management module.
• Responsible to retrofit all the customization and enhancement for Commitment Control and GL modules.

Senior PeopleSoft Developer

Confidential

I was responsible for the following

• Responsible for asset conversion from Canadian Entity onPeoplesoft 8.4 to GPC Peoplesoft
• Developed the tech specs, mapping and developed the application engine program for asset conversion.
• Responsible to run the transaction loader to make sure asset has been loaded to application table and consolidate the depreciation, amount of asset and books.
• Responsible to create the new books for Canadian assets as part of the conversion.
• Design and developed the vendors conversion from Canadian entity to SP Richards GPC PeopleSoft 9.0
• Design and developed the daily interface for PeopleSoft Vendors because based on the business model.
• Design and developed the AP Payment conversion application engine program.

Technical Lead

Confidential

• Developed the ExcelToCI to upload the asset to the staging tables INTFC FIN, INTFC PHY A and fix the Transaction loader program to load the AM core tables.
• Modified the Component interface INTFC FINPHY SS A to add the necessary fields based on clients requirement.
• Modify the INTFC PRE AM 01 page so that client can modify the profile id and other fields before loading the data from AP/PO to Assets management.
• Developed the interface to upload the open items using the component interface as a part of application engine interface program.
• Developed the application engine program interface to upload the Customers from third party system.
• Responsible for go live support and resolve the production issue for first 30 days.
• Creates the Project costing, GL reconcile and PC, Commitment Control Reconcile views.
• Modify the AR invoice report using the XML Publisher.

SOFTWARE: PeopleSoft Financial/SCM 9.1 AP, GL, PO, ePro, AR, AM, PC, BI and Grants , Crystal Report, nVision, Oracle 11, People Tools 8.52, XML Publisher.

Senior PeopleSoft Developer

Confidential

I was responsible for the following

• Use the ExcelToCi spreadsheet to upload the Assets.
• Configure, design and Develope 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 Pay group 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 XML Publisher.
• 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.51

Senior PeopleSoft Developer

Confidential

• 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