Summary:

• Over 8.5 years of experience that includes Analysis, Design, and Development and Implementation of Business application system in PeopleSoft.
• Expertise in People Tools v8.5x/8.4x : Application Designer, Application Engine, People Code, File Layout, Component Interface, Workflow and Approval Workflow Engine, Application Packages, Component Interface, Process Scheduler, Security.
• Technical Expertise in Configuration, Customization and implementation of PeopleSoft Financials/SCM and HCM application.
• Involved in Fit Gap analysis and implementation requirement gathering.
• Good understanding of Application Server, Process Scheduler, and Web Logic server.
• Excellent skills in creating interface programs based on design specifications between Application System and PeopleSoft.
• Good Experience of working in Support Project and resolving L1, L2 and L3 issues.
• Reporting Tools Experience: PS Query, Data Mover, SQR and Crystal Reports, BI XML Publisher.
• Expertise in all implementation phases including Business Process analysis, FIT-GAP analysis, Design/Build, Data migration, Unit, Integration and End User testing, Cut-off strategy, Go-live and Post go-live support and maintenance.
• Excellent coding and debugging skills in Application Engine Program, Component Interface, People Code and SQR.
• Experience in PeopleSoft Internet Architecture and People tools.
• Strong Knowledge in PeopleSoft Portal Application.
• Experience in using integration tools like component interfaces for interacting within and outside PeopleSoft application.
• Strong database design and implementation experience with RDBMS - Oracle 9i, 10g, 11g and SQL Server 2005 and 2008.
• Accomplished in customizing modules based on organization needs and requirements.
• Knowledge of security administration for implementation of security.
• Excellent analytical, communication and problem solving skills.
• Strong in client interaction and interpersonal skills.

Skill Set:

• PeopleSoft Application: PeopleSoft Financials and SCM General Ledger, Accounts Payable, Purchasing, e-Procurement, Expense, Accounts Receivable, Billing .
• PeopleSoft Tools: Application Designer, Application Engine, People Code, File Layout, Component Interface, Workflow and Approval Workflow Engine, Application Packages.
• Administration Tools: Tree Manager, Process Scheduler, Change Assistant, Data Mover.
• Reporting Tools: SQR, Crystal Reports, PS Query, n-Vision, XML Publisher.
• Databases: Oracle 9i, 10g, 11g, SQL Server 2005, 2008, DB2.
• SQL Tools: SQL plus, Toad.

Experience:

Confidential

Responsibilities:

• Involved in Project Design, Implementation and Post Production Support.
• Interacting with the client to gather their initial requirements and the change requests.
• Have in depth Knowledge of AP, PO, ePro, AM, BI and GL Modules.
• Fixed Application Support issues.
• Have Good understanding of PeopleSoft PIA Architecture and have the ability to troubleshoot tier 2 and 3 issues.
• Developed components interface to load voucher Data.
• Developed and modified complex people code program to ensure page validations.
• Involved in Gathering and Analyzing requirements for interface from PTS to Accounts Payable.
• Prepared and delivered training materials used by both SIT and UAT testers during and post implementation.
• Prepared the Mapping template for the data conversion program.
• Involved in logging all the defects: code, documentation, Data issue, and environmental bugs in Quality Center.
• Worked with Oracle DBA's/PS Admin to identify and perform application tuning.
• Handled People Soft Code/Projects migration between non production and production environments for FSCM 8.8 and Finance 9.0.
• Resolved various batch job failures and made sure Jobs are running as per schedule.
• Debugged and tuned the performance of the AP/AR/BI Interface Process.
• Map ARIBA contracts data with PeopleSoft Procurement Vendors.
• Testing the AP, PO and Billing modules after People tools upgrade.
• Conduct Knowledge Transfer sessions with client support teams and end users.

Environment: PeopleSoft 9.2 Financials and Supply Chain Expense, Account Payables, Purchasing, e-Procurement and General Ledger and People Tools 8.53.

Confidential

PeopleSoft Consultant

Responsibilities:

• Core member of Production Support Team.
• Working as a Developer/Analyst in PeopleSoft Financials application version 9.0.
• Have in depth Knowledge of Following Modules: AP, PO, Epro, AM, AR, BI, KK and GL.
• Customizations as per user requirements in Accounts Payable, Purchasing and e-pro Module.
• Involved in Project Design, Implementation and Post Production Support.
• Interacting with the client to gather their initial requirements and the change requests.
• Developed and Modified Complex People Code to enforce page validations and to populated pages/components as per user requirements.
• Worked with App Messaging and Integration broker.
• Worked in UNIX Environments.
• Worked with Oracle DBA's/PS Admin to identify and perform application tuning.
• Handled People Soft Code/Projects migration between non production and production environments for HCM 8.8 and Finance 9.0.
• Resolved various batch job failures and made sure Jobs are running as per schedule.
• Have Good understanding of PeopleSoft PIA Architecture and have the ability to troubleshoot tier 2 and 3 issues.
• Have reviewed developer code and insured standard are being maintained.
• Created data Conversion program to load data in PeopleSoft Tables.
• Analyzed and troubleshoot various data issues, Application issues related to SQR, Peolecode, Application Engine, Workflow, security and configuration issues.
• Configured various legal entities for AP, PO, and AM Module.
• Refined and translated functional specifications into technical specifications for AP, PO and AM Modules.
• Developed new objects including records, views, panels, menus and process definitions.
• Involved in monitoring batch processes and fix it when needed by following change management procedures.
• Working with 24X7 production support environments.

Environment: PeopleSoft Financials/SCM 9.0 AP, PO, e-Pro,AM,AR,BI and GL and People Tools 8.50 , Application engine, File layouts, Component Interfaces, Unix,SQR, Process Scheduler, Crystal Reports and Integration Broker, Oracle 10g,HCM 8.8,Control-M.

Confidential

PeopleSoft Consultant

Responsibilities:

• Core member of Implementation Team.
• Involved in full life cycle from design to production support of successful implementation of FSCM release 9.1
• Interacting with the client to gather their initial requirements and the change requests.
• Refined and translated functional specifications into technical specifications for AP, PO, Expense and AM module.
• Configured chart-fields for AP, PO, Expense and AM modules.
• Developed test scripts and performed system testing of delivered functionality/client's customization by using the HPQC.
• Developed inbound interfaces for loading the concur third Party expense data into PeopleSoft system.
• Extracted data from PeopleSoft database to a file format specified in the design document for Active Projects and Managers for Concur System.
• Customized Print Portrait Invoices to support new expense layout.
• Developed new objects including records, views, panels, menus and process definitions using People Tools, People Code and Process Scheduler to support the Expense Interfaces.
• Created the several permission lists, roles and user profiles as per the Bus Structure.
• Created Accounting Entry and Journal Entry Template.
• Customized Dispatch Purchase order process as per the business requirement.
• Configure the Approval Framework -AWE for Purchase Order Approvals.
• Debugged and tuned the performance of the Expense Interface Process.
• Map concur expense data with PeopleSoft expanse and project modules.
• Testing security application with the client counterpart to setup various test scenarios and ensure no loopholes in the security
• Created various UNIX scripts.
• Conduct Knowledge Transfer sessions with client support teams and end users.

Environment: PeopleSoft 9.1 Financials and Supply Chain Expense, Account Payables, Purchasing, e-Procurement and General Ledger and People Tools 8.51 , Application engine, File layouts, Component Interfaces, Process Scheduler, Unix, Oracle 10G,HPQC.

Confidential

PeopleSoft Consultant

Responsibilities:

• Technical Member of Enhancement and support Team.
• Interacted with client to understand the new requirements, participated in the meetings to clarify functional designs.
• Developed and modified complex People code to enforce page validations and to populate pages/components as per the client requirements.
• Developed SQR's to load the data into PeopleSoft tables.
• Developed test scripts and performed system testing of delivered module functionality and client's customization by using the People Tools Test Framework PTF .
• Develop new customizations as per the business requirements.
• Performing customization in e-Procurement to transparently include inventory items.
• Modified the existing approval rule sets and business process maps for the Voucher Approval Workflow and created new route control profiles for this process.
• Designed Components Interfaces to Load Vendor and Item in PeopleSoft system.
• Configured AWE for Requisition Approval.
• Configured the Matching Exceptions Workflow, which sends notifications for vouchers that do not pass the matching.
• Used Excel to CI utility to load data.
• Created Ratable Revenue Recognition program for rate based, amount based and recurring contract lines for calculating revenue.
• Involved in monitoring batch processes and fix it when needed by following change management procedures.

Environment: PeopleSoft 9.0 Financials and Supply Chain Account Payables, e-Procurement, Purchasing, General Ledger and People Tools 8.50, Process Scheduler UNIX, Oracle 10g.

Confidential

PeopleSoft Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft version 9.1 and PeopleSoft Support.
• Preparing the Technical Design documents after analyzing the functional requirements.
• Researched the release notes for FSCM8.8/8.9/9.0/9.1 to identify the changes and enhancements done in AP, PO, e-Procurement, AR and Billing modules.
• Ran the Compare Reports for demo to demo and demo to copy of production so as to identify and apply the customizations after the new objects definitions are copied to the COP.
• Updated technical Design documents and fit gap documents with the latest changes.
• Develop new records, Pages, Components, Peoplecode, Application Engine Programs, and SQRs as part of new development.
• Developed Component Interface for ACH voucher upload.
• Retrofitted the file objects Crystals, SQR and N-vision and online objects People Code, App Engine as per the new functionality.
• Develop Test plan, Test Scripts and Test Cases for AP, PO, AM AR and Billing.
• Worked with Accounts Payable on Various customizations which involve Pay Cycle, AP Interfaces and AP reports.
• Assist user in user acceptance testing.

Environment: PeopleSoft 8.8 and 9.1 Financials and Supply Chain Purchasing, Account Payables, General Ledger, AR, and Billing and People Tools 8.48, 8.50, SQR, Process Scheduler ,PS Query, Crystal reports and Oracle 10G,TOAD.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft version 9.0 and PeopleSoft Support.
• Directly involved with business users for their functional and technical queries.
• Review configuration Reports to identify the changes.
• Prepared detail design documents, which include both functional specifications and technical design specifications for interfaces in General Ledger, Account Payables, Asset Management and Purchasing Modules.
• Modified customs SQR process and reports due to the changes in tables in versions 9.0.
• Developed SQRs and data mover Scripts DMS to migrate the data.
• Customized PeopleSoft delivered Crystal Check layout APY2021 Report.
• Developed custom Application Engine program in Payables to send an email to the employees regarding the payments being made, once the Pay Cycle process is run.
• Developed programs using File Layout, Application Engine and People Code extensively for the Import and Export of flat files and XML files.
• Customized workflow for Voucher, Vendor Pay cycle Approval processes.
• Involved in Vendor Audit reporting for the audits made on some vendor tables at the record level and Vendor Archiving process for maintaining history of the vendors.
• Worked on performance tuning of SQR, People Code, Application Engine and SQL Query
• Created public and private queries using PS Query to assist users in analyzing data quickly and easily.
• Worked on Data management SYSAUDIT/DDAAUDIT .
• Was involved in Post tools upgrade production Support.
• Have Reviewed developer code and insured standards are being maintained.
• Performed System and Integration testing after application of Bundles and Fixes.

Environment: PS FSCM Account Payable, Purchasing, General Ledger, AR, Billing and Asset management v8.8/9.0 and People Tools 8.48/5.0,SQR, Process Scheduler, SQL server 2008.

Confidential

PeopleSoft Consultant

Responsibilities:

• Core member of Production Support Team.
• Worked on FSCM issue/tickets related to purchasing, Account Payable and General Ledger module
• Created SQR to Upload Purchase Orders and Vouchers.
• Involved in designing the functional and Technical Specs for the Interfaces.
• Developed Application Engine to using File Layouts to transfer the data from Flat files to PeopleSoft tables.
• Modified crystal check layout and implement check-9 digit functionality.
• Developed SQR's for Positive payments and Canada Accruals.
• Developed program to load the CBRE invoice data into PeopleSoft tables.
• Fixed People Tools and Application Support issues.
• Modified People soft delivered App Engine to suite the Hewitt requirements.
• Involved in different phase of QA testing like unit testing, integration testing and Regression testing.
• Involved in running and scheduling Jobs Processes and Job Stream through Maestro and control-M.
• Working with 24X7 production support environments.

Environment: PeopleSoft FSCM Account Payable, Purchasing, General Ledger, AM, AR, Billing v8.4, v8.8.0 and People Tools 8.45, 8.48, Meastro, DB2, UNIX.

Confidential

PeopleSoft Consultant

Responsibilities:

• Core Member of the GH Implementation Project.
• Customized the Purchase Order dispatch print process as per client requirements.
• Developed a custom SQR to load the Receipts data into Receipt staging tables.
• Customized the Account Payables Payment Cancellation page so that all users can add payment messages and the user with administrative privileges only can cancel the payment.
• Modified Crystal Reports APY2021 and PVY4000 in e-Procurement as per client requirement.
• Customized various crystal reports in Accounts receivables.
• Customized Workflow for Change request in e-Procurement.

Environment: PeopleSoft FSCM 9.0 Billing, Purchasing, e-Procurement, Accounts Receivable, Accounts Payables and People Tools 8.48, SQR, SQL, Crystal Reports.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Involved in the Analysis, Design, Development, and Customization of PeopleSoft Application.
• Designed and developed conversion programs for Vendors and Items using Application Engine and File Layouts
• Assisted in setting up Account Payables and Purchasing Business unit options and configure user preferences.
• Developed and modified new Components, Pages and Records.
• Involved in Design, Development, Testing, Enhancement and Maintenance of PeopleSoft Financials for GL, AP and e-procurement, Modules.
• Customized the PO CNTRCT WF Application Engine to send emails to the Vendor's primary contact when Contract has expired or reached its monetary limit.
• Designed and Customized the Automatic Reconciliation page to provide details of the payments against Vouchers and Invoices.
• Involved in migration of projects to different database instances.
• Worked on Performance tuning of Various SQRs, SQLs and Application Engines Programs.
• Involved in data conversion from their existing legacy system to PeopleSoft System.
• Developed different custom reports by using PS Query and Crystal Reports.

Environment: PeopleSoft FSCM 8.9 Contracts, Purchasing, e-procurement, Accounts Receivable and Accounts Payables and People Tools 8.49, SQR, AE, Component Interfaces.

Confidential

PeopleSoft Consultant

Responsibilities:

• Technical Member of Support team.
• Reviewed the Functional design Documents and created Technical Design Based on FDDs.
• Involved in Customization of Components, Pages and Records.
• Developed various PS Queries in order to help the client day-to-day activity
• Created Vendor Conversion program to load data in PeopleSoft Vendor Tables.
• Extensively worked on Excel to CI utility to load data
• Created/Modified various crystal reports in AP.
• Developed new objects including records, views, panels, menus and process definitions.
• Created Index on queries for improving the performance.
• Wrote Complex SQL Queries using Joins, Unions and nested sub-queries.
• Involved in setting up new folders, registering new components etc.

Environment: PeopleSoft FSCM v8.8 Accounts Receivable, Accounts Payable, Billing, Purchasing, General Ledger and People Tools 8.45, SQR, Crystal Reports,PS Query, Control-M.