Professional Summary:

• Over 11years' 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.
• 8years' experience in wide range of PeopleSoft Financials/SCM modules including Accounts Payable, Accounts Receivable, Expense, Billing, General Ledger, Inventory and Project Costing.
• 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:

• wPerformance Tuning w Integration Broker wAWE
• PeopleSoft Financials 9.1, 9.0, 8.9, 8.8, 8.4, 8.0
• Application Designer w PeopleTools wPeoplecode
• Application Engine w File Layout wComponent Interface
• Security Administrator w Object Security wXML Publisher
• Tree Manager w Process Scheduler w SQR
• PS Query w Crystal Reports w Application Messaging
• Workflow w PL/SQL wData Mover

Operating Systems:

w Windows 2000, NT w UNIXw Mainframe

Databases:

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

Professional Experience:

Confidential

Peopletools 8.52

PeopleSoft Technofunctional Analyst

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 Catalogapplication 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
• Helped in configuring the AP module for conversion and go live which included implementation of EFT payments.
• AP: Calculation and troubleshooting various issues with PayCycle 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 incorporate 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 chartfields.
• 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

Project Lead -Techno functional

The Relocation Request Enhancements form requires modifications to support the global relocation policy changes. To apply critical security that is currently missing with the transmission of sensitive, confidential HR data to our vendor.Real time notifications are also sent to the Manager and Employees about the completion of there Assignment.

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 over all quality documents for the Project
• Confidential is the Implementation of Buddy Functionality to assign a Buddy to the Incoming Employee. A good Buddy is a critical component to helping a new employee to become productive more quickly by helping with the operational training using email, where office supplies are located, etc. and becoming familiar with the company culture.
• A Real Time Notifications RTN are also implemented to inform Managers, Buddy, and to the Incoming Employees about the Buddy Assignment.

Responsibilities:

• As Technical Consultant, participated in the following activities.
• 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 services with 101,000 employees in 60 countries revenue of 60 billion, Cargill is the largest privately owned company in US. The current HR systems environment consists of the Tesseract Mainframe System that supports the United States HR, Benefits Payroll functions. Cargill also has many ancillary systems on multiple platforms to support manager employee self-service, training development.

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.

Confidential verifiable results. This project includes implementation, customization and SQR interface to the existing system. This project maintains the employee information and Benefit Administration using the HRMS and Benefit Administration modules.

Responsibilities:

• 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.

Confidential States based on total deposits. Key Bank is owned by KeyCorp which was formed in 1994. Key Bank has approximately 19,000 employees and 2.2 million retail, small business, and corporate and investment clients. Key Banks are located in 13 states. KeyCorp maintains business offices in 31 states.

Responsibilities:

• Wrote SQL and People Code for Benefits for data conversion and customizing the self-service pages as they requested.
• Responsible for customizing the benefit plan, benefit program, assign employees, foundation tables for processing the payroll and customizing ePayself service pages and templates of health plan, insurance plans, FSA, savings by using eBenifits to provide the two way communication between organization and its employees and give the flexibility for their employees to choose their convenient plans.
• Written Crystal Reports.
• Modified SQR Interfaces according to the Business Requirement and loading the entries from payroll
• 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.
• Testing, System testing and Acceptance testing.