Summary:

• Over Seven years of 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 and HRMS 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 .
• Strong knowledge in peoplesoft portal application.
• Experience in People Soft Internet Architecture PIA and People Tools.
• Strong Data Migration / Conversion experience from legacy systems to Peoplesoft systems and SQL Performance tuning experience
• Excellent skills, in creating Interface Programs based on design specifications between Application Systems and Peoplesoft. Skills in creating conversion programs from Legacy systems.
• Involved in the fit gap analysis and implementation requirements gathering.
• 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

Skill Set

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.

Operating System: Windows NT, UNIX, Linux.

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

SQL Tools: SQL plus, TOAD, WINSQL.

Education: Bachelor's in Computer Science, JNTU, India.

Experience:

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 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.
• 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, Billing, Projects and Contracts , People Tools 8.51, People Code, Application Engine, Integration Tools File Layout, Component Interface, Application Messaging , SQL, SQR.

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, 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, AR, BI, KK , 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
• Followed standard documentation and issue escalation procedures.
• Worked on security issues related to user security and object security.
• Analyzed and troubleshoot various data issues, application issues related to SQR, peoplecode, app Engine, work flow, configuration and security issues.
• Developed SQL scripts to verify the test results and prepare test data.
• Assisted users in user acceptance testing.
• Involved in all phases of testing, and preparing test data.
• Updated technical design and fit-gap documents with the latest changes.
• Developed SQRs and data mover scripts DMS to migrate the data.
• Applied bundles and fixes to PeopleSoft using change assistant.
• Involved in troubleshooting the paycycle and posting issues in production.
• Involved in developing complete bolt-on process as per the client's requirements.
• Modified the interface programs and files due to the changes in Staging and interface tables in new version.
• Worked on performance issues with AP, AR and GL processes.
• Customized delivered SQR tax reports as per the business requirement.
• Modified custom SQR processes and reports due to the changes in tables in version 9.0.
• 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 , 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.
• Developed multi level pages as per the requirement.
• Involved in setting up new folders, registering components etc.
• 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.

Confidential

PeopleSoft Consultant

Responsibilities:

• Created Custom reports using SQR for Accounts Receivable module, which gives the Aging report by Bill Types and aging details and summary for regular bills and Expense bills
• Modified Peoplesoft objects like Pages, views and PeopleCode according to the business requirements.
• Part of production support and on-call team.
• Developed Test Plans, Test Scripts and Test Cases for Billing and AR.
• Involved in different phases of QA Testing like Unit Testing, Integration Testing and Regression Testing.
• Migrated projects from Development to test environment.
• Involved in setting up new folders, registering components etc.
• Developed custom run control page, which allows the users to run and view the reports from the same page.
• Developed multi level pages as per the requirement.
• Developed custom peoplecode functions to avoid redundant code.
• Developed Data conversion application engine program using file layouts.
• Developed data conversion documents and mapped fields from legacy to People Soft.
• Designed and developed technical design documents based on functional specifications.
• Involved in data conversion from their existing legacy systems to PeopleSoft system.
• Developed configuration documents and migration documents.
• Participated in Analysis and configuration meetings.
• Modified existing component interface to upload user profiles in to the database using Excel to CI utility.
• Developed and modified complex Peoplecode to enforce page validations and to populate pages/components as per the client's requirement.
• Developed new records, pages, components, peoplecode, application engine programs, SQRs as part of new development.
• Involved in the analysis, design, development and customizations of Peoplesoft application
• Created index on Queries for improving the performance.
• Wrote complex SQL Queries using joins, unions and nested sub-queries.
• Developed different custom reports using PS Query and Crystal Reports.
• Modified security settings after gathering requirements from user groups to determine security structure.

Environment: PeopleSoft Financials/SCM V 8.9 AP, GL, PO, AR, Billing , PeopleTools 8.47, People Code, SQR, Process Scheduler, Application Engine, DMS, PS-Query, nVision, Crystal Reports, Security, Oracle.

Confidential

Peoplesoft Consultant

Responsibilities:

• Interacted with users during Fit-gap session Design and Implementation phase for requirement gathering and to finalize Design specifications.
• Created Accounting Periods, created users, assigned Roles and Permissions to users, completed unit testing to ensure that the customizations work as per requirements.
• Designed ChartField mapping from Legacy System to PeopleSoft.
• Configured additional ChartFields such as Cost Center, FERC Code etc.
• Designed and configured complex ComboEditing rules and assigned to Sub-Systems such as AP, PO and AR.
• Designed and Implemented nVision Reports for the Enterprise.
• Configured Closing rules including Interim Closing for the Enterprise.
• Constructed queries to reconcile AR to General Ledger.
• Integrated with AR and Order management.
• Interacted with the Technical Team in fixing and troubleshooting problems during implementing and development as well fixing bugs / patches.

Environment: PeopleSoft Financials 8.8, GL, AP, PO, AR, BI, Crystal Reports, nVision, Query, Oracle 9i, Windows 2000, Application Designer, PeopleCode, Integration Broker, Application Engine, SQR, Crystal Reports, Integration Broker, PS/Query, n/Vision