SUMMARY:

• Fifteen (15) 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), People Tools (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, West Falls Church, VA

Responsibilities:

• This Upgrade have different phases, First phase we upgrade the Tools to 8.55 and Oracle database 12c.
• People Tools 8.55 does not support the Crystal reports so we need to convert the about 80-85 reports from to BI Publisher Reports for all business unit.
• I was lead for converting/retrofit of all Crystal reports to BI Publisher Reports for all business units.
• Responsible for Initial fit gap session with each business unit and identify the resources and co-ordinate sign off, testing and final approval for reports development.
• Lead the offshore development team and defined the strategy for development and security as per guideline from client Confidential .
• Responsible to develop the critical reports and code review for offshore development.
• Responsible for testing to make sure all report BI reports also work on 12c database.
• BI Reports developed for workforce admin (Head count report from BU and location, Employee Salary History, Employee Job history, Employee paycheck Earn etc.)
• BI Reports developed for Benefits and Payroll (Trainee Advancement Report for each area, FROI Form report, OSHA’s 300 and 301 Form reports, Pay Change, Termination Report etc.)

SOFTWARE: PeopleSoft HRMS 9.1, PeopleSoft HRMS (Payroll, Benefit, Workforce Admin), Oracle 12c, SQR, People Tools 8.55

Senior PeopleSoft Developer

Confidential, Houston TX

Responsibilities:

• Responsible for converting/retrofit of all Crystal reports to Bi Publisher Reports (Voucher Register, Payment History, Payment Register reports, Payment Advice).
• Retrofit the interface and message between student Financial and GL using the integration broker.
• Responsible for retrofit the customization for Account Payable AP, AM, GL and PO modules.
• Design and Developed the custom application engine program modified the 1098T form template to change the address to fit in the envelope.
• Modified the page, which allow the student to view all statements.
• Modified the Sponsorship Authorization form to add the chart fields and UTHealth account on the page and add the people code for the validation of these fields.
• Modified the views for custom DIRXML student component to show the student academic career information correctly.
• Design and Developed the equation engine program to calculate the Supplemental Designated Tuition fee for Resident and non-residents.
• Modified the Medical Insurance extract for student to include the auditing Terms using the SQR.
• Completed the Fluid User Interface from Oracle on Rel 8.55
• Design and Developed the Fluid page and component for Student Self Service
• Developed different Tiles and Tiles Wizard on fluid homepage for Student Self Service

SOFTWARE: PeopleSoft FSCM 9.2, PeopleSoft CS 9.0/9.2 (SF, SR, SA, Financial Aid), Oracle, SQR, People Tools 8.55

Senior PeopleSoft Developer

Confidential, Madison WI

Responsibilities:

• Design and Developed the Open Item interface from legacy system to PeopleSoft Account Receivable.
• Modify the existing Dunning letters to add business unit and State logo.
• Worked on the overdue application engine (AR OVRDUE) program to modify the calculation for overdue amount and financial charge on items.
• Developed the voucher inbound interface to load the voucher into the staging tables.
• Responsible to requirement gathering, design, development and unit testing for Payroll Extract Interface.
• Design and Developed the Great West Outbound interface (Deferred Compensation provider).
• Developed the Conversion program for direct deposit from state Legacy system to the PeopleSoft using the SQR and application engine.
• Modified recruitment letters for offer letter, deny and interview letter using the XML Publisher. This modification involved the State logo and subject text on the letters.
• Design and Developed the ExcelToCI spreadsheet using the component interface to upload the PeopleSoft HR budget Tables.

SOFTWARE: PeopleSoft HCM 9.2 (AB, BN, EP, HR, PY, TL, EL, RS), Oracle 11, SQR, People Tools 8.54, BI Publisher.

Senior PeopleSoft Developer

Confidential, Houston, TX

Responsibilities:

• Responsible for retrofit the customization for Account Payable (AP), AM, GL, PC and PO modules.
• Design and Developed the Aging Report, Dunning Letter, Voucher Register, Payment History by Payment, Detail Payment Register reports using SQR, Crystal report and XML Publisher reporting tools.
• 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 for retrofit the customization for Account Payable (AP), AM, GL, PC and PO modules.
• Responsible to modify the open items, customer and VAT for multicurrency changes.
• Design and Developed the integration broker messages to get the invoice information from Third party system to PeopleSoft AR.
• 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.

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

Senior PeopleSoft Developer

Confidential, PA

Responsibilities:

• 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 Confidential 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, Smyrna, GA

Responsibilities:

• Responsible for asset conversion from Canadian Entity on PeopleSoft 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 Confidential (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.

PeopleSoft Technical Consultant

Confidential, Albuquerque, NM

Responsibilities:

• 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, Montpelier, VT

Responsibilities:

• Use the ExcelToCi spreadsheet to upload the Assets.
• 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 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.
• Developed the Payroll interface to extract the payroll data for other systems.

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, VA

Responsibilities:

• 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 p set for PO and Requester.

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

Senior PeopleSoft Developer

Confidential, Richardson, TX

Responsibilities:

• Correct the setup for 1099 in PeopleSoft for year 2011 and train the AP core user, how to setup the 1099 setup in future.
• Modified the Copy B Report for 1099 vendors.
• 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

PeopleSoft Developer

Confidential, Houston, TX

Responsibilities:

• 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, Melbourne, Florida

Responsibilities:

• 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, The Woodlands, TX

Responsibilities:

• Design and developed the Confidential Payment process using the application engine people tool to send the Email notification for the Vendors. Developed the SQL script to update the Confidential 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