SUMMARY

• Over 8.5 years of experience dat 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 wifin and outside PeopleSoft application.
• Strong database design and implementation experience wif 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.

TECHNICAL SKILLS

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.

PROFESSIONAL EXPERIENCE

Confidential

Techno Functional Consultant

Responsibilities:

• Involved in Project Design, Implementation and Post Production Support.
• Interacting wif teh client to gather their initial requirements and teh 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 teh 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 teh Mapping template for teh data conversion program.
• Involved in logging all teh defects: code, documentation, Data issue, and environmental bugs in Quality Center.
• Worked wif 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 teh performance of teh AP/AR/BI Interface Process.
• Map ARIBA contracts data wif PeopleSoft Procurement Vendors.
• Testing teh AP, PO and Billing modules after People tools upgrade.
• Conduct Knowledge Transfer sessions wif 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 wif teh client to gather their initial requirements and teh change requests.
• Developed and Modified Complex People Code to enforce page validations and to populated pages/components as per user requirements.
• Worked wif App Messaging and Integration broker.
• Worked in UNIX Environments.
• Worked wif 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 teh 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 wif 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 wif teh client to gather their initial requirements and teh 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 teh HPQC.
• Developed inbound interfaces for loading teh concur (third Party) expense data into PeopleSoft system.
• Extracted data from PeopleSoft database to a file format specified in teh 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 teh Expense Interfaces.
• Created teh several permission lists, roles and user profiles as per teh Bus Structure.
• Created Accounting Entry and Journal Entry Template.
• Customized Dispatch Purchase order process as per teh business requirement.
• Configure teh Approval Framework -AWE for Purchase Order Approvals.
• Debugged and tuned teh performance of teh Expense Interface Process.
• Map concur expense data wif PeopleSoft expanse and project modules.
• Testing security application wif teh client counterpart to setup various test scenarios and ensure no loopholes in teh security
• Created various UNIX scripts.
• Conduct Knowledge Transfer sessions wif 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 wif client to understand teh new requirements, participated in teh meetings to clarify functional designs.
• Developed and modified complex People code to enforce page validations and to populate pages/components as per teh client requirements.
• Developed SQR’s to load teh data into PeopleSoft tables.
• Developed test scripts and performed system testing of delivered module functionality and client’s customization by using teh People Tools Test Framework (PTF).
• Develop new customizations as per teh business requirements.
• Performing customization in e-Procurement to transparently include inventory items.
• Modified teh existing approval rule sets and business process maps for teh 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 teh Matching Exceptions Workflow, which sends notifications for vouchers dat do not pass teh 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, Boston

PeopleSoft Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft version 9.1 and PeopleSoft Support.
• Preparing teh Technical Design documents after analyzing teh functional requirements.
• Researched teh release notes for FSCM 8.8/8.9/9.0/9.1 to identify teh changes and enhancements done in AP, PO, e-Procurement, AR and Billing modules.
• Ran teh Compare Reports for demo to demo and demo to copy of production so as to identify and apply teh customizations after teh new objects definitions are copied to teh COP.
• Updated technical Design documents and fit gap documents wif teh 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 teh file objects (Crystals, SQR and N-vision) and online objects (People Code, App Engine) as per teh new functionality.
• Develop Test plan, Test Scripts and Test Cases for AP, PO, AM AR and Billing.
• Worked wif 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 wif business users for their functional and technical queries.
• Review configuration Reports to identify teh 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 teh changes in tables in versions 9.0.
• Developed SQRs and data mover Scripts (DMS) to migrate teh data.
• Customized PeopleSoft delivered Crystal Check layout (APY2021) Report.
• Developed custom Application Engine program in Payables to send an email to teh employees regarding teh payments being made, once teh Pay Cycle process is run.
• Developed programs using File Layout, Application Engine and People Code extensively for teh Import and Export of flat files and XML files.
• Customized workflow for Voucher, Vendor & Pay cycle Approval processes.
• Involved in Vendor Audit reporting for teh audits made on some vendor tables at teh record level and Vendor Archiving process for maintaining history of teh 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 teh functional and Technical Specs for teh Interfaces.
• Developed Application Engine to using File Layouts to transfer teh 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 teh CBRE invoice data into PeopleSoft tables.
• Fixed People Tools and Application Support issues.
• Modified People soft delivered App Engine to suite teh Confidential 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 wif 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 teh GH Implementation Project.
• Customized teh Purchase Order dispatch print process as per client requirements.
• Developed a custom SQR to load teh Receipts data into Receipt staging tables.
• Customized teh Account Payables Payment Cancellation page so dat all users can add payment messages and teh user wif administrative privileges only can cancel teh 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 teh 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 teh PO CNTRCT WF Application Engine to send emails to teh Vendor’s primary contact when Contract TEMPhas expired or reached its monetary limit.
• Designed and Customized teh Automatic Reconciliation page to provide details of teh 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 teh 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 teh 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 teh 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.