PROFESSIONAL SUMMARY:

• Over 11 years’ experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
• 8 years’ experience in wide range of PeopleSoft Financials/SCM modules including Accounts Payable, Accounts Receivable, Expense, Billing, General Ledger, Inventory and Project Costing.
• Has working knowledge of retrofitting the customizations during upgrades(8.9 to 9.1, 8.8 to 9.0, 9.0 to 9.2)
• Strong PeopleSoft technical skills include PeopleTools (Application Designer, Peoplecode, Application Engine, Component Interface, Process Scheduler, Query, Data Mover, Security Administrator and Definition Security), SQR (Inbound and Outbound Interfaces), and Crystal Reports.
• Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade. Applied PeopleSoft Patches, Bundles.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Knowledge on app server configuration, PIA, Process Scheduler, web server.
• Excellent troubleshooting and problem - solving skills.
• Team player with excellent interpersonal communication skills and technical documentation skills.

TECHNICAL SKILLS:

PeopleSoft Financials (9.2,9.1, 9.0, 8.9, 8.8, 8.4, 8.0)

Application Designer PeopleTools(8.5x) Peoplecode

Application Engine File Layout Component Interface

Security Administrator Object Security XML Publisher

Tree Manager Process Scheduler SQR

PS Query Crystal Reports Application Messaging

Performance Tuning Integration Broker AWE

Workflow PL/SQL Data Mover

Windows 2000, NT UNIX Mainframe

Oracle 11g/10g/9i/8/7.x MS SQL Server DB/2

General Ledger Accounts Payable Accounts Receivable

Purchasing Billing Inventory

Asset Management Project Costing Expenses

Order Management eProcurement Treasury (Cash Management) PO

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

PeopleSoft Techno functional Consultant

Responsibilities:

• Extensively worked on PeopleSoft eProcurement, Purchasing and Inventory which enables suppliers to enter invoices and review invoices and payments.
• Worked on this design document that has covered the details of the following major processes such as supplier enablement business process, purchase order acknowledgement business process, advanced shipment notification business process, and supplier account review business process
• Worked for the client whose external users access the PeopleSoft Catalog application thru custom web link of the client, and the mode of communication with eProcurement teams for sending catalog source file is email
• Modified the existing Matching Exceptions Notification Workflow process is to notify the concerned department based on the matching exception rule type instead all buerys and suppliers whose Agreement option is selected.
• Involved in upgrading of FSCM 9.0 to 9.2 along with streamlining of customizations and testing of all new 9.2
• Involved in the PeopleSoft Upgrade Project for Project Costing, OM, INV, PO, AP, AR, BI, Commitment Control and GL Modules.
• Helped in configuring the AP module for conversion and go live which included implementation of EFT payments.
• Worked with conversion of Crystal Reports to BI Publisher
• Worked with DDD Audit and Sys Audit Reports to find the inconsistencies between Peopletools record and Index definitions, also to identify orphaned objects.
• Worked with the Peoplecode debugger to debug the online PeopleSoft pages.
• Worked with the PeopleSoft Search Engine (SES)
• AP: Calculation and troubleshooting various issues with Pay Cycle Manager, Payment posting
• As a part of the AP outbound interface developed the custom SQR & SQC programs for creating the payment files in EFT & ACH format
• AP: Developed an Interface using SQR, which would help users to Load the External Voucher Data from spreadsheet into a flat file, so that it can be processed by the EDI manager, which is used to load the data into VCHR HDR STG, VCHR LINE STG and VCHR DIST STG tables.
• Customized the VCHR EXPRESS page in AP to in corporate the custom fields in all the different kinds of vouchers
• Created test plans and performed functional testing to make sure the business requirements are delivered as expected
• Trained the testing team and Business Analysts by providing the Step by Step process for testing the new enhancements and interfaces
• PO: Developed Inquiry pages to show ASN and POA Information which will be navigated from Requisition life cycle.
• Made sure that the Journal Edit process ran without any errors and cleared the existing errors in the log by mapping to the right chart fields.
• Designed and developed multi level approval workflow process for requisitions, purchase order and for material stock request etc. and suggested modification for dispatch process(POPO005), requisition print report etc.

Confidential, Santa Clara, CA

Project Lead -Techno functional

Responsibilities:

• Modified People Code according to Business Rules as a part of development.
• Modified the Department Tree for Departmental Security and Organizational Charting using PS Tree Manager.
• Customized PeopleSoft Delivered SQR reports in Hiring & Benefits Modules.
• Developed conversion programs in SQR to move data from the Legacy system to existing PeopleSoft tables.
• Developed new queries using PS/Query to replace some delivered SQR’s.
• Created run control panels for SQR’s and scheduled them on process scheduler to generate reports and flat files.
• Debugged, updated and modified existing SQR programs.
• Wrote SQR programs to upload Flat file information into People Soft database for HR & Benefit tables.
• Used Process Scheduler and Process Monitor for running SQR, background Processes like DDDAUDIT and SYSAUDIT.
• Capturing the design details for implementation. Discussing the various issues and functional details, which needed to be incorporated in to the system.
• Handling requests from the Client for development of new Functionality or systems or modification of the existing programs or any other subsystem that are essential for supporting ongoing business of the Client
• Worked with automated leave management process using time and labor module.
• Preparing the design document with the required changes.
• Preparation of Project Document, File Layout Templates and test cases.
• Taken the ownership to look at the overall quality documents for the Project

Confidential, Santa Clara, CA

Techno functional consultant

Responsibilities:

• Studied the Client Business processes
• Capturing the design details for implementation. Discussing the various issues and functional details, which needed to be incorporated in to the system?
• Handling requests from the Client for development of new Functionality or systems or modification of the existing programs or any other subsystem that are essential for supporting ongoing business of the Client.
• Development and Project Technical Support
• Report Writing Development using SQR
• Developed PJC’s to schedule SQR’s
• Preparation of unit Test cases and Test Plan (CTP)
• Manual testing and Acceptance testing.
• Participated in meetings with HR process Owner to finalize requirement and freeze the scope of project.
• Coordinated with user groups and testing team to facilitate the necessary testing for the specific SQR’s, performance issues and also involved in communicating with the user groups, help desk resource to solve the production problems or issues.

Confidential

Technical consultant

Responsibilities:

• Created & modified Fields, Records, and Pages as per the Client requirements.
• Created Application Engine Program for Payroll interfaces.
• Created technical designs and scripts using Peoplecode and SQR’s for Payroll and Base Benefits Modules.
• Used Process Scheduler and Process Monitor for running Application Engine background Processes like DDDAUDIT and SYSAUDIT.
• Created run control records & run control pages for SQR’s to schedule them on process scheduler and generate reports & flat files.
• Writing SQL statements for database updates for daily transactions, running batch processes in Oracle.
• Developed I/O interfaces for Time & Labor data with 3rd party vendor (API). Worked closely with the Executive Staff, Technical Support team, Functional Reps and Trainers to ensure a successfully implementation of PeopleSoft HRMS/HCM 8.0. working closely with the functional requirements team in the development of the detailed Functional Requirements document followed by the development of the Conversion Strategy and Technical Specification documents using an extraction, data transformation and load strategy using SQL/SQR programs, and Data Mover scripts for loading and unit testing the required PeopleSoft HR, Benefits and North American Payroll tables.
• Conducted the walk through for reviews to meet the Specification.
• Created custom queries for end users to use on PS Query.
• Generated a SQR Report for the Employees details.
• Involved in writing New SQR programs for generating reports & flat files.
• Scheduled and modified SQR programs.
• Created & Customized Fields, Records, Views, Pages, Components and Menus as per the client’s requirements.
• Modified People Code according to Business Rules as a part of development.
• Modified the Department Tree for Departmental Security and Organizational Charting using PS Tree Manager.
• Customized PeopleSoft Delivered SQR reports in Hiring & Benefits Modules.
• Developed conversion programs in SQR to move data from the Legacy system to existing PeopleSoft tables.
• Developed new queries using PS/Query to replace some delivered SQR’s.
• Created run control panels for SQR’s and schedule them on process scheduler to generate reports and flat files.
• Debugged, updated and modified existing SQR programs and Crystal Reports.
• Wrote SQR programs to upload Flat file information into People Soft database for HR & Benefit tables.
• Used Process Scheduler and Process Monitor for running SQR, Application Engine background Processes like DDDAUDIT and SYSAUDIT.
• Worked on SQL Trace and PeopleCode Trace.
• Scheduled and Modified SQR Reports.