SUMMARY

• Over 14 years of experience in PeopleSoft Technical and PeopleSoft Functional Financial/Supply Chain Management modules, emphasis on General Ledger, Accounts Receivable, Billing, Accounts Payable, Asset Management, Commitment Control, Purchasing, eProcurement, eSupplier, Strategic Sourcing, Treasury Management, it includes Application versions 8.9, 9.0, 9.1, 9.2 and tools version .
• Provided PeopleSoft consulting services by acting as subject matter expert and leading clients through the entire systems development lifecycle including Analysis, Upgrade, Interface Design, Reporting, Data Conversion, Configuration, Testing, Troubleshooting and Production Support.
• Proficiency with application design and data modelling, including in - depth knowledge of applications, interfaces, workflow, and report development using all technical tools provided by PeopleSoft: PeopleTools, People Code, Integration Broker, Application Engine, File Layouts, Data mover, Application Package, and Component Interfaces and Reporting Tools SQR, Crystal Reports, BI Publisher, PS/nVision and PS Query.
• Acted as a functional SME with the ability to analyze business processes and functionality to make recommendations in various processes of PeopleSoft Finance and Supply Chain Management modules.
• Experienced in gathering functional requirements & documenting designs and configuring the PeopleSoft system to meet each client’s unique business requirements with the solid understanding of setup tables and integration of all modules.
• Extensively involved in the design and development of various Inbound and Outbound interfaces using SQR, Application Engine programs, Integration Broker, Application Packages and File Layouts.
• Experience in Setup, Designing, coding and implementation of the requirements in PeopleSoft and supporting of the implemented modules.
• Worked independently on defining solutions for a mid to large size complex projects and/or contributed solutions of a different programs in a collaborative environment with a wide variety of stakeholders and users with the ability to multi-task, provide routine status updates to manager and stakeholders, and meet project deadlines in time and efficient manner.
• Experience in PeopleSoft Security, Approval Workflow Engine (AWE)
• High-level understanding on Server related activities.
• Have excellent oral and written communication skills. Has Excellent Problem-solving skills.

TECHNICAL SKILLS

• Application Designer
• Application Engine
• Security
• SQR
• Tree Manager
• App Packages
• Peoplecode
• Component Interface
• Excel to CI
• Integration Broker
• AWE
• PS Query
• Data Mover
• File Layout
• NVision
• XML Publisher
• General Ledger (GL)
• Accounts Payable (AP)
• Receivables (AR)
• Billing (BI)
• Commitment Control
• Expense
• Cash Management
• Project Costing
• E-Procurement
• Purchasing
• Strategic Sourcing
• Asset Management (AM)

PROFESSIONAL EXPERIENCE

Confidential, OR

Lead PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in requirement gathering, designing and development of the interface and the required components.
• Interacted with various Vendors and partners to understand the interfaces and gather the requirements. Performed Analysis on the requirement and documented the strategy and shared with all the partners.
• Created Function Design and Technical Design Document for Pay Calendar, Project Time Allocation, Interfaces for Payroll and Leave and Outbound Extracts.
• Performed Data Mapping between both the systems. Designed Setup pages for various required fields.
• Reviewed the Current interfaces between Peoplesoft Finance GL and Peoplesoft HR Payroll and designed new interfaces /Updation of old interfaces.
• The Project had nearly 36 outbound Extracts to be developed. I developed an Outbound Extract tool that could be used by all the extracts instead of developing separate programs for each of the Extracts.
• The Tool contains an online page where the user can provide the SQL, Record or the PS-Query. An option to Select the Output type as Fixed or Delimited and provide the format for each field based on the option selected.
• The Program developed uses the source and the format entered on the online tool and generates the file in a specified location in the specified format.
• Performed the Setup of Allocation Rules for splitting the Employee time across various Projects. The data is interface to Project Costing module.
• Developed Program to validate the Received payroll data to undergo Combo validation rules to mark them as valid or invalid.
• Created the Setup for Accounting Entry and Journal Template for passing the valid payroll entries to Journal Generator.
• Configured Fields on Accounting Entry page for Payroll using Page and Field Configurator for enabling and disabling of fields for various users.
• Designed and Developed XMLP Reports for Account wise Reversals, Actual and Accrual Entries. The reports is complex in nature where the columns and rows were dynamically hidden and the displayed columns moved across multiple tables based on the data.

Confidential, CA

Lead PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in planning, preparing, scheduling, designing, developing, retrofitting, reviewing, testing and migration preparation for Finance, from 9.1 to 9.2 and tools version from
• Lead the calls with Client Team, Vendors, Server Team for upgrade and Retrofit team and provided inputs on various issues regarding retrofit.
• Analyzed and Prepared a Structured plan to classify and retrofit thousands of objects that appeared on the compare report for various modules.
• Verified Compare reports including comparison through backend using PSCOMPSESSION and PSCOMPOBJDIFF validate to see if any objects can be marked as “Retrofit Not required”.
• Retrofitted the Portal registry structures and translate value through backend on PSPRMSDEFN, PSPRMSPERM, and PSXLATITEM.
• Created DMS scripts wherever it is required.
• Retrofitted several PeopleSoft objects and customizations on pages, processes, different reports in the new environment and ran compare reports and verified the data integrity between the environments by ensuring that all the affected objects are added to the project and master Project migration documents are updated properly.
• Reviewed the other team members retrofit activities and ensured that the logic of the program remains intact and ensured that every objects retrofitted in attached to a Project
• Updated and merged all the retrofit Projects into a single one for migration to other environments and compared the list of objects in App designer with compare report list through backend using PSPROJECT, PSPROJECTITEM tables to ensure that every object marked as Retrofit is retrofitted and included in the Project.
• Solved Testing, UAT and post Production issues and provided inputs to the client on functionality changes in 9.2.
• Integration points between different external systems (Power Plan for projects and combos; Bank integration for BAI statements, payment files, acknowledgments files, positive pay; and sub systems (AP, expenses) for exchange of data are considered, analyzed, validated and mapped accordingly for the interfaces and Integration broker web services setup to flow inbound and outbound between the systems. These integrations and several inbound and outbound interfaces are developed using app engines, file layouts and integration broker set ups and tested extensively and promoted to live environments.
• Used the Data Migration work bench tool by creating the Application Data set definitions to migrate the different allocations, accounting rules, chart fields, work centers configuration data between development environments, test environments, and ultimately to the production environment.
• Vendor self-service project (Accounts Payables): Provided all assistance needed to implement the vendor self-service project so vendors could register themselves online and submit their invoices without any manual intervention by one of the AP users.
• Configured mobile approvals for vouchers in Account Payable and in Expense modules for approving the expenses with the Fluid UI. Used Drop zones to add additional fields and customize fluid pages.
• Involved in the setup of the Work Centers for AP, GL.
• Modified the Allocation rules to make use of utilizing the new functionality of excluded values in Pool section to and tested the GL ALLOC process.
• Solved issues with requisition/PO change involving tables of CHNG RQST, CHNG RQST DTL, and PV CHNG RST DTL.
• Implemented Upload facility for requisitions in E-Procurement. Created Excel to CI to load data into the component REQUISITION LOADER and the table PO REQLOAD RQST to upload items as Special Items.
• Customized PO REQ LOAD App Engine program that loads data into requisition tables from the Stage for loading component.

Environment: PeopleSoft Finance and Supply Chain 9.2 and 9.1, People tools 8.56, nVision, People Code, App Engine, File Layout, Excel to CI, App Packages, Windows xp, SQl Server, Oracle.

Confidential

Sr. PeopleSoft Techno-Functional Consultant

Responsibilities:

• Acted as a functional and technical SME analyzing business processes and functionality making recommendations in various processes of PS FSCM and provided technical expertise throughout the implementation and support of the project
• Planned, Designed and Implemented the Invoice import process with third party vendor VWR and Grainger. This involved customization of Transformation program, handler, service operations of Integration Broker, and Application engines. Led the weekly calls with vendor and the client. Tested the complete activity and, documented the changes and provided the post production support.
• Integration Testing was performed on various EProcurement/PO/INV/AP processes such as Quick Source Requisitions, PO Dispatch, Process Receipts, Reservations, Putaway, Picking Confirmation, Depletions, Cost Accounting Entries, INV Journal Generate, Voucher post, Payment Post, Matching, and AP Journal Generate.
• Performed Integration with ARIBA through data transfer tool of ARIBA Integration tool kit for procurement services. Performed Setup of Integration Broker Node, Service, Service Operation, and Message, Created Event Handler people code, Customized Application Engine transformation program for cxml conversion to format the messages to be sent and unformat the messages received.
• Implemented Approval Process for E-Procurement Requisitions based on Line of Business and Department. Created New Approval Process with Stages, Paths and Steps and provided criteria for each step. Created the User List Setup with Role and SQL Definition as User List Source.
• Implemented the e-punch out setup in eProcurement that integrates Requisitions with third party Vendor VWR which helped the users to pick items directly from the vendor’s web site.
• Implemented and tested the Purchase Order Dispatch using Integration Broker that integrates Requisitions with Vendor VWR to help dispatch Purchase Orders automatically to the client without any manual intervention.
• Assisted in the mapping of multiple chart of account fields to be converted from legacy systems and numerous interfaces into PeopleSoft
• Reconciled, loaded, edited and posted multiple GL conversion files from legacy system into the PeopleSoft conversion environment. Troubleshooted and remediated file and load errors to enable successful posting to GL
• Configured new SetIDs, Business Units, Ledgers, Security, Procurement Controls, Banks, Vendors, Pay Cycles, Trees and other configuration to facilitate the addition of new entities into PeopleSoft.
• Configured the eProcurement requisitions departmental workflow using the AWE approval process by creating the necessary Transaction Registry, Transaction Configuration and Approval process Setup and User list Setup.
• Configured the Multi Currency setup at PO Business unit level and developed a custom interface for market rates combinations which were setup.
• Involved in Setup of Allocation Rules for Prorata based allocation for GL on various expenses to various Projects and Setup of Consolidation to consolidate the data into one BU.
• Performed Translation to convert data from one ledger group to other.
• Fixed Strategic sourcing export issues, Replicated the scenario, conducted meetings with client and product support and ensured that the system is working as per the design delivered by Peoplesoft
• Implemented the Payment request form that helps in creation of vouchers and Implemented the Supplier Request form for creation or changes to a Supplier which are part of the new 9.2 functionality.
• Worked on the integrations with HR system, credit card processing and receipt management.
• Configured batch processing of several jobs which runs on recurrence and some on adhoc basis
• Actively monitored several processes in process monitor and Integration broker queues/messages daily as part of support job and provided timely support for the outstanding issues and performance issue problems.
• Responsible for all the setups of withholding rules, types and category, withholding codes and other withholding flags on the supplier pages.
• Ensured that the Monthly Closing process is completed without any issues.
• Resolved several issues related to Requisition/PO change request, Interface data error issues, workflow issues, Journal/Ledger Integrity issues, nvision issues and varied other problems over the period of time.
• Created and maintained several Trees (Department, Project) for Structural based Reporting. Created a job to run Audit tree reports on daily basis to capture the invalid chart fields nodes that are not added on the tree
• Implementing Automatic Bank Reconciliation process and Bank Import from BOA ( Confidential )
• Used DMS scripts for moving configuration/transactional data between different databases.
• Performed Archival of AR and BI Modules through Archival Manager.
• Developed conversion programs for GL conversion to convert three years of historical data, journal activity and ledger balances from PeopleSoft 9.1 to PeopleSoft 9.2 system. The converted data is validated by business unit, account, fiscal and accounting period in the new system.
• Different SQR, Nvision reports are retrofitted as per the client needs and all of the Crystal reports are converted to BI publisher reports. AP checks with MICR fonts are customized as per client needs.
• Extensively involved in performance and SQL tuning throughout the upgrade process.
• Extensively involved in configuration of different Business units, Chatfield Combination rules, Allocations, Consolidations, bank setups, procurement options and common definition setups in AP, PO, INV, EX GL modules.
• Configured supplier approval workflow, voucher AWE approval and journal approval in AP and GL.
• Followed company policy and procedures throughout the project and maintained necessary documentation throughout the process.
• Provided necessary support post go-live to the users.
• Created training documentation and trained users on delta process changes and 9.2 functionality in multiple countries

Environment: PeopleSoft Finance and Supply Chain 9.2, People Tools 8.55,n-vision, People Code, App Engine, File Layout, Excel to CI, App Packages, Windows xp, SQl Server, Oracle, DB2 OS290.

Confidential

Sr. PeopleSoft Techno-Functional Consultant

Responsibilities:

• Working in the capacity of a Project Lead to support GL, AP, AR, AM.BI
• Performed Conversion using File Layout, Component Interfaces, Application Engine through Application Designer and Excel to CI for AR, AP, and AM. Loaded Data into staging tables for Vouchers, Assets and Pending Items. Tested and fixed issues with AMPS1000, AMIF1000 to upload data into Asset tables.
• Customized nVision Report Request page NVS REPORT RQST. The change was to ensure that there is a From and To Time Period for Nvision reports so that the Nvision report can fetch data from PS LEDGER with a range of Time spans.
• Created Interface to store and review Billing attachments with vendor IPM. IPM provides a document management system where documents can be stored, searched and viewed effectively by third party systems.
• Part of the Team responsible for Requirement, Design and implementation
• Completely Customized SQR AR Aging Report (AR3006 - Aging by Chartfield) to suit the needs of Confidential . Received appreciation for this from the client.
• Provided Support for the various projects that were implemented.
• Developed customized App Package program to generate Billing xml invoices

Environment: PeopleSoft Finance 9.1, People Tools 8.52, People Code, App Engine, File Layout, SQR Process, Windows xp, SQl Server, Oracle.

Confidential

Sr. PeopleSoft Techno-Functional Consultant

Responsibilities:

• Worked in the capacity of a Project Lead.
• Completed Retrofit of several PeopleSoft objects by analyzing the compare reports and comparing with the old and new versions of Demo and old production copy and fixing Peoplecode and SQL’s at record, component level. Retrofitted pages, processes, portal registry structures.
• Created Data mover Scripts and performed retrofitting through sql where for portal, translate values, service operation versions.
• Ensured that all the affected objects are added to the project and master Project migration documents are updated properly. Performed backend updates and deletes to projects to remove unwanted items from the project.
• Finding the new Functional areas of PS fin 9.0 that can replace customization.
• Verified and validated environment installation options, activation and configuration of AP, and PO, INV modules (i.e. Combination Editing, Duplicate Invoice Checking, Banking, Vendors, PayCycle Manager, ACH/EFT Payments, Positive Pay, Control Group Processing, Locations, Procurement Card, Workflows, etc.).
• Performed testing on Quick Source Requisitions, PO Dispatch, Process Receipts, Reservations, Putaway, Picking Confirmation, Depletions, Cost Accounting Entries, INV Journal Generate, Voucher post, Payment Post, Generate Journals, Editing and Posting of Journals.

Environment: PeopleSoft Finance 8.8, People Code, App Engine, File Layout, SQR Process, Windows 2000, SQ Server.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Solve Production issues relating to various modules such as GL, AP, AR, BI and AM.
• To solve the issues of having to continuously monitor processes that are running for more than an hour, created an App Engine Program
• Solved the issue with Asset depreciation entries.
• Resolved issue with groups not being picked up by AR UPDATE.
• Resolved Billing Summary Report Reconciliation issue.
• Solved issue with Journals not being picked up in Allocation
• Creation Application Engine program to delete unwanted Approval workflow requests lying with approvers
• Created SQR report to create a customer wise BI report.
• Prepared Data Scripts and transferring data through the Data Mover to production
• Provided Training to users and help them in using the module.
• Build the offshore Team to enable them handle PeopleSoft Projects.

Environment: PeopleSoft Finance 8.8, People Code, App Engine, File Layout, SQR Process, Windows 2000, SQ Server.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in the complete process starting from fetching of Opportunities from PeopleSoft CRM, using the opportunities to create Projects, Entering the contracts in the system, Search for Employees required for the Projects through Resource Management, Allocation of the Employees to the Projects, Maintenance of Timesheets, Generation of Worksheets for Billing, Transferring the data for original Billing module for invoicing, Publishing the Project - Deal data to CRM.
• Involved in development of interfaces with PeopleSoft HRMS and Syntranet systems.
• Perform Conversion using Application Engine Program, Component interface and File Layout to load date into the billing interface table using the data from Contracts, projects and timesheets.
• Provided the Validation Rules for Each page or Process to the Developers
• Developed upload facility for Customer Time sheets module.
• Enabled the users to understand the system and perform the UAT.
• Moved the Projects to Production Environment
• Prepared Data Scripts and transferring data through the Data Mover to production
• Provided Training to users and help them in using the module.
• Provided support for the modules.

Environment: PeopleSoft Finance 8.4 SP2, People Code, App Engine, SQR Process, File Layout, Windows 2000, SQ Server.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Implemented Cash Management system (Treasury) and Automatic Bank Reconciliation.
• Took the requirement from the users and presented them with the scenarios of Cash Management.
• Setup Integration between bank and the Peoplesoft system up by setting up Service operation, Message, Node, services and Routings. Conducted Stake holders meetings and ensured that the connectivity with the Bank system is accurate, Performed Mapping of each data field and ensured that the messages are transferred to and fro without any errors.
• Created the Treasury Business Unit (Treasury options)
• Created new Accounts for Treasury
• Updated Bank Accounts with Treasury information and Automatic Reconciliation options.
• Created Settlement instructions.
• Created Transfer Templates to be used for Bank transfer.
• Educated the users on Bank Statement Import, Reconciliation (Automatic), Cash Position Bank Transfer
• Used Settlement manager to review and approve the transactions.
• Performed the necessary Setup for creating the accounting entries and for transfer to GL.

Environment: PeopleSoft Finance 8.4 SP2, People Code, App Engine, SQR Process, File Layout, Windows 2000, SQ Server.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Implemented and Supported Expense and Commitment Control Module
• Developed workflow for expense module. Created Business Process, Activities and Route Control Profiles for approval workflow and setup paths and steps. Allocated Employees to various roles of Manager, Pre-Pay Auditor to route every expense to their manager and finally to the pre-pay auditor.
• Performed Conversion of Complete Employee Data to be uploaded into Peoplesoft system by standardization of various key fields, mapping of data to these fields and creating programs to upload data into the Employee component.
• Performed the Setup of Expense Types, Payment Options, Expense Roles, Accounting Entry options.
• Used Excel to CI to upload Project Data as a Project Chatfield.
• Created Peoplesoft Trees to structure Projects at different levels (Vertical wise, Sub Vertical wise, Project wise) Budgets are allocated at Vertical and Sub vertical Levels.
• Created Commitment Control Budget Definition, Budget Attributes
• Performed Upload of Budget Journals
• Implemented Security for Expense and Commitment Control.

Environment: PeopleSoft Finance 8.4 SP2 Commitment Control & Expense, People Tools, People Code, Windows 2000, SQL Server.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Developed Complex Allocation Rules through the Allocation module in PeopleSoft Finance
• Developed Translation Rules for converting from one ledger to the other.
• Checked the Allocation & Translation by development of nVision Reports
• Developed Reports through nVision.
• Developed of Interface between PeopleSoft Finance and Syntranet (In-House JAVA, ASP based application) for the transfer of Profit and Loss Data

Environment: PeopleSoft Finance 8.4 SP2 Allocations + GL, People Tools, People Code, nVision, SQR, Windows 2000, SQL Server.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Ensuring the Monthly closing activity is successful and is completed on time for all the Confidential companies.
• Ensuring that the GL and the sub modules are balanced, and no difference exists in the accounting entries during transfer to the GL module.
• Responsible for activities of opening and closing the Periods, Market Rates entry, Calendar Setup, Creations of New Accounts, Locations and Development Units
• Creation of combination Editing Rules that govern the entry of Accounting entries in GL
• Implementation of GL workflow for Confidential Ltd and Confidential International.
• Development of Reports for the users.
• Implementation of GL for every new Confidential Business Units.
• End user training about the system

Environment: PeopleSoft Finance 8.4 SP2 GL, People Tools 8.44, Workflow, PS-Query, Windows 2000, SQL Server.