SUMMARY

• Extensive experience that includes Analysis, Design, Development and Implementation of Business application systems in Peoplesoft.
• Technical experience in Configuration, Customization, and Implementation of PeopleSoft Financial/SCM Applications.
• Excellent working knowledge in People Tools Application Designer, Application Engine, Process Scheduler, SQR, Component Interface, File layout, PS query, SQL Programming and Crystal Reports .
• Involved in the fit gap analysis and implementation requirements gathering.
• Excellent skills, in creating Interface Programs based on design specifications between Application Systems and Peoplesoft. Skills in creating conversion programs from Legacy systems.
• Strong Data Migration/Conversion experience from legacy systems to Peoplesoft systems and SQL Performance tuning experience
• Experience in People Soft Internet Architecture PIA and People Tools.
• Strong knowledge in peoplesoft portal application.
• Experience in using Integration Tools like Component Interfaces for interacting with in and outside People Soft applications.
• Proficient in preparing complex reports using SQR, PS Query, nVision and Crystal reports.
• Uploading data from flat files to PeopleSoft tables using Application Engine and SQR programs.
• Experience in designing databases and client-server architectures and expertise in SQL tools.
• Accomplished in customizing modules based on organizational needs and requirements.
• Excellent analytical troubleshooting skills.
• Excellent communication and inter-personal skills

SKILLS

Peoplesoft Applications: PeopleSoft Financials and SCM General Ledger, Accounts Payable,

Accounts Receivable, Purchasing, Project Costing, Billing, Asset

Management, Inventory .

Peoplesoft tools: Application Designer, PeopleTools, PeopleCode, Application Engine,

File Layout, Component Interface, Security, Portal, Process Scheduler,

SQR, Crystal Reports, PS Query, Tree Manager, Data Mover,EDI.

Operating System: Windows NT, UNIX, Linux.

Databases: Oracle, SQL Server 2000/2005/2008 and DB2

SQL Tools: SQL plus, TOAD, WINSQL.

EXPERIENCE

Confidential

Peoplesoft Techno functional

Responsibilities

• Involved in peopletools testing, production support and enhancements testing.
• Involved in design analysis and documentation of the business process as required by the end users.
• Performed testing for financial modules AP, AR, PO, e-pro, AM and GL.
• Involved in unit, regression, system user acceptance testing for all the reports and processes developed.
• Worked on modifying an interface based on the effective dated logic. Have done complete Unite Testing, Integration Testing and UAT.

Confidential

Peoplesoft Consultant

Responsibilities:

• Involved in Fit-Gap Analysis. This was to define the client requirements in relation to the implementation of Peoplesoft Release 9.1 of the GL, AP, PO ,Epro AR.
• Developed new conversion programs, inbound and outbound interfaces using Application Engine, File Layout, and Component Interface and SQR tools. Set up budget definitions, source transactions, ledgers and trees.
• Assisted in Configuring the GL AP and PO modules in the financials environment.
• Documented and show-cased new and enhanced functionality introduced in the Release 9.1 of Peoplesoft GL, AP, PO and eProcurement as well as reporting capabilities.
• Change to delivered Recurring Voucher page to add Purchase Order Business Unit field BUSINESS UNIT PO to the Line level of the Contract page.
• Designed Developed Projects Inbound Interface by using an app engine program, file layout and email the error log of the interface to the business users.
• Analysis and development of Project Cost reports in SQR and Crystal.
• Designed and created several custom tables, pages, components using application designed and implemented security for the custom modules.
• Used Application Engine to transfer the data from flat files to PeopleSoft tables.
• Wrote test scripts and tested numerous developed programs for various modules like PO, AP, GL, AR more emphasis on purchasing module.
• Involved in User training for all the peoplesoft application modules.
• Post Implementation user support interacting with the users and with the Peoplesoft to resolve the issues, also worked on the high priority issues with Peoplesoft to resolve them in a day.

Environment: Financials 9.1 GL, AP, AR, Epro, Billing, Projects and Contracts , People Tools 8.51, People Code, Application Engine, Integration Tools File Layout, Component Interface, Application Messaging , SQL, SQR, EDI.

Confidential

Peoplesoft Consultant

Responsibilities:

• Involved in design analysis and documentation of the business process as required by the end users.
• Performed Fit-Gap analysis for proposed financial modules AP, AR, e-procurements, Expenses, ,AM and GL.
• Involved in mapping the legacy data with the corresponding PeopleSoft data.
• Perform Vanilla compare between production databases to a demo database to identify all of our customization Customized the Budget Journal page using People code.
• Developed conversion programs to load the data from external systems into PeopleSoft financials General Ledger, Accounts Payable modules and Expense modules.
• Set up budget definitions, source transactions, ledgers and trees.
• Developed New Autosys jobs to schedule the process of Monthly and Bi Monthly jobs and also customized the existing Jobs.
• Documented the Current State and Future State processes and customizations in the GL, AP and budgets to facilitate knowledge transfer and user training. Included in this documentation are fit -gap issues and their resolution.
• Developed custom SQR programs to validate inbound GL interface load files, convert the flat file to GL standard inbound flat file in the file layout object GL JRNL IMPORT format to load the journals into PeopleSoft through the Application Engine Program GL JRNL IMP .
• Developed new records, pages, components, peoplecode, application engine programs, SQRs as part of new development.
• Developed and modified complex Peoplecode to enforce page validations and to populate pages/components as per the client's requirement.
• Responsible for evaluating user requests for new or modified programs to determine technical feasibility, and Peoplesoft system compatibility.
• Involved in design of PeopleSoft reports, interfaces, conversions and customizations to assure business requirements are met
• Modified custom SQR processes and reports due to the changes in tables in new version.
• Designed and documented customizations involved at all levels like, pages, people code, SQR reports.

Environment: PeopleSoft Financials 8.9 AM, GL, AP AR, T E and Billing , People Tools 8.48, EDI,SQR, Application Engine, PeopleCode, nVision, Crystal Reports, SQL Server 2008,.

Confidential

PeopleSoft Consultant

Responsibilities

• Involved in Upgrade of PeopleSoft version 8.8.
• Developed an application in Inventory module for tracking and billing.
• Customized Bill Entry pages for pages as per the requirement and incorporated required functionality.
• Developed Application Engine using file layouts to transfer the data from flat files to PeopleSoft tables
• Developed Purchasing Interface using File Layout, Application Engine, and Component Interface, which loads data from flat file into staging tables while doing various data validations using AE Peoplecode and finally loads into PeopleSoft tables through Component Interface.
• Involved in design, development of Journal Entry Workflow.
• Customized the Journal inquiry page that would retrieve all journal lines that are associated with a Journal Id entered, regardless of the Business Unit.
• A modification was made to allow searching on the Match Manager page by PO Business Unit and PO ID. This speeds the tracking of match exceptions for all vouchers related to a particular Purchase Order.
• Designed and Developed Buyer Monthly Inventory Value Report and Vendor Monthly Inventory Value Report using nVision
• Worked with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, Pay Cycle, AP Processing, AP Interfaces, Refund Processing, AP Reports and AP Security.
• Designed 3 Custom Crystal Checks for University, Research Foundation and Health Center.
• Worked on Performance tuning of various processes.
• Worked with PeopleCode to have Customizations done to the Journal Entry Component as per OSU Requirements.
• Customizing crystal reports on AR Invoices by billing location, Open Invoices and Credit memos by billing point, open invoices and Open items, AR Balances by State and Country and Customer Activity. Etc.
• Created a report for the Accounts Receivable on pending items that runs and gives report periodically, that gives the list of all Pending Items, and Pending Payments.
• Developed an SQR program to load data from the legacy system tables into PeopleSoft Asset Management Loader tables.

Environment: PeopleSoft Financials/SCM V 9.0 AP, GL, PO, Epro, AR, BI, KK,EDI, , PeopleTools 8.50, People Code, SQR, Process Scheduler, Application Engine, PS-Query, Crystal Reports, Integration Broker, Oracle 10g.

Confidential

PeopleSoft Consultant

Responsibilities:

• Involved in upgrade of Peoplesoft Financial application from 8.4 to 9.0.
• Core member of Production Support team.
• Participated in analysis and configuration meetings.
• Reviewed compare reports to identify the changes.
• Developed new records, pages, components, peoplecode, application engine programs, SQRs as part of new development.
• Developed and modified complex Peoplecode to enforce page validations and to populate pages/components as per the client's requirement.
• Responsible for evaluating user requests for new or modified programs to determine technical feasibility, and Peoplesoft system compatibility.
• Involved in design of PeopleSoft reports, interfaces, conversions and customizations to assure business requirements are met
• Modified custom SQR processes and reports due to the changes in tables in version 9.0.
• Customized delivered SQR tax reports as per the business requirement.
• Worked on performance issues with AP, AR ,Epro and GL processes.
• Modified the interface programs and files due to the changes in Staging and interface tables in new version.
• Involved in developing complete bolt-on process as per the client's requirements.
• Involved in troubleshooting the paycycle and posting issues in production.
• Applied bundles and fixes to PeopleSoft using change assistant.
• Developed SQRs and data mover scripts DMS to migrate the data.
• Updated technical design and fit-gap documents with the latest changes.
• Involved in all phases of testing, and preparing test data.
• Assisted users in user acceptance testing.
• Developed SQL scripts to verify the test results and prepare test data.
• Analyzed and troubleshoot various data issues, application issues related to SQR, peoplecode, app Engine, work flow, configuration and security issues.
• Worked on security issues related to user security and object security.
• Followed standard documentation and issue escalation procedures.
• Written various Autosys scripts in Unix/Linux necessary at the time before and after the Autosys Box runs.
• Worked on an Enhancement for a Vendor Front End in the AP module to calculate the use tax for the vendors whenever a transaction occurs.

Environment: PeopleSoft Financials/SCM V 8.8/9.0 AP, GL, PO, AR, BI, Epro , PeopleTools 8.49, People Code, SQR, Process Scheduler, Application Engine, PS-Query, Crystal Reports, DMS, Integration Broker, Version Control, Security, Oracle Peoplesoft HRMS V 8.4 Payroll, Commissions , Autosys, Mainframes.

Confidential

PeopleSoft Consultant

Responsibilities:

• Technical member of Re-Engineering Project and Production Support Team.
• Developed new records, pages, components, peoplecode, application engine programs, SQRs as part of new development based on business requirements.
• Developed and customized People code to achieve the functionality and also for validations.
• Extensively worked with Application Designer to create the new record definitions, Views, new pages and adding the pages to components and menus, used PS query in developing queries and crystals and worked on other security access issues.
• Created Custom Reports using SQR for Inventory Module which gives the pick plan Report and also for the Express Issue.
• Designed and developed data conversion app engine program using file layouts for one time kick off that is used while the upgrading the peoplesoft in Contracts Module, to update various table based on the accounting date and a file uploaded respectively.
• Designed and developed custom Crystal report for Billing using a different Invoice format and new query, which involves creating many sub-reports and sections and groups as well.
• Created a page which involves different scroll levels, different filed types, record types, pop-up menus and custom run-control page.
• Created an App-Engine program for Projects Income/Activity Statement which takes different run-control values, based on which different report requests are created and and nVision report is submitted.
• Created a new nVision report layout and a new report is created based on the report request created from the app-engine program.
• Developed Application Engine using file layouts to transfer the data from flat files to PeopleSoft tables.
• Worked on Data Mover Scripts DMS to migrate the data.
• Resolved many production issues that occur on daily basis.
• Involved in setting up new folders, registering components etc.
• Developed multi level pages as per the requirement.
• Involved in all phases of testing.
• Developed test scripts and prepared test data.
• Developed SQL scripts to verify the test results.

• Migrated projects from Development to test environment.

Environment: PeopleSoft Financials/SCM V 8.8 IN, PC, TE, GL, PO, AR, BI , PeopleTools 8.47, People Code, SQR, Process Scheduler, Application Engine, PS-Query, nVision, DMS, Version control, Integration Broker, Crystal Reports, Security, SQL Server 2005.