SKILLS

PeopleSoft Technologies: PeopleTools 8.53, PeopleCode, Integration Broker, Workflows, Application Engine, Approval Workflow Engine AWE , Mobile Approvals, Secure Enterprise Search SES , Query manager, Tree manager, Process scheduler, Process Monitor, Configuration Manager, Data Mover, Component Interface, Import Manager, Forms, Alert framework,

Reporting Tools: SQR, PS Query, BI/XML Publisher, Connected Query, Pivot Grids, Crystal reports

PeopleSoft Modules: PeopleSoft FSCM 9.0, 9.1 and 9.2 Accounts Payables, eProcurement, General Ledger, Asset Management, Expenses, Purchasing Accounts Receivable PeopleSoft HRMS 8.9, 9.0, 9.1 and 9.2 Base Benefits, Benefits Administration, ESS MSS, Core HR PeopleSoft Interaction HUB 9.1 Unified Navigation, Content Management, Homepages, Workcenters, Dashboards, Pagelets

Others: PHIRE, PL/SQL and Oracle database, HP quality centre 9.2, Loadrunner, SharePoint, HTML, JavaScript

EXPERIENCE

Confidential

Senior PeopleSoft Developer

Environment: FSCM 9.2, HCM 9.2, PS Interaction HUB 9.1 People Tools 8.53

• Managed and Implemented all AWE workflows across entire FSCM 9.2 AM, GL, AP, EP and HCM 9.2
• Added custom requestor field on 'Regular Entry' page and modified delivered 'Request Batch Voucher' app engine in AP.
• Modified AP APY2055 Positive Pay Process in AP to work with BoA Accounts Reconciliation/Positive Pay.
• Configured the new 'Payment Request' feature in AP.
• Developed an interface to generate ePayables Payment file for PNC bank.
• Developed GL inbound and outbound interfaces with app engine and IB for ReconNet and Home Health
• Developed a Journal Entry form to allow users outside accounting to request Journals.
• Implemented Mobile Approval, Mass Approvals, Custom Workflows and PS Forms across FSCM and HCM environments.
• Enabled User Profile, Workforce and Department ID Sync between various environments using Integration Broker.
• Worked with Oracle to resolve bugs and test the latest fixes for Asset Disposal workflow.
• Added customization in AM to attach bond codes to assets.
• Added a custom 'Requisition type' logic in eProcurement to drive the workflow and business process.
• Configured eProcurement Role Actions.
• Added customization in eProcurement to have shipping priority at Line level along with header level.
• Enabled field level audits on chartfields and related core setup.
• Designed custom workflow Approver tables to store AWE routings.
• Configured unified navigation between HCM, FSCM and PeopleSoft Interaction HUB.
• Designed pagelets, workcenters, homepages, nav collections and deployed Secure Enterprise Search SES.
• Leveraged PHIRE to manage all project migration.

PeopleSoft Techno-Functional Consultant

Environment: FSCM 9.0 to 9.1 People Tools 8.48.14 to 8.52.08

• Gathered new requirements and converted existing 'Virtual Approver' workflow into the new 'Approval Framework Workflow', which offers more flexibility and a better user experience.
• Led several presentations to advice end users with new available 9.1 workflow functionalities and how they could be leveraged for the existing processes.
• Re designed Account Payables, Expenses and General Ledger workflows according to the new Approval Framework
• Re applied customization for AP and GL module for the upgrade.
• Updated all users PS queries for 9.1 and leveraged 'Process' queries for workflow. Enabled URL drill downs is queries to enhance user experience. Developed Connected Queries.
• Developed cutover application engines to continue old workflows in the new workflow after upgrade. Customized several delivered processes like Escalation process, 'AP request batch' voucher app engine. Enabled advanced workflow options like Escalation, Reminders, Reassign Approval, Pushbacks, Addhoc approvers/reviewers, mass reassign and mass approval.
• Created oracle cases to address some issues faced by the development team and the get resolution on some bugs.
• Resolved several delivered bugs in delivered workflow. Fixed the delivered EOAW AUDIT report with custom code.
• Added security customizations to Recurring vouchers.
• Configured AP setup at Origin level, BU/SETID Level and Control Groups level for the new 9.1.
• Worked with business analysts in documenting the new business process and training documentation for the end users.
• Conducted functional and technical trainings in BI publisher, Approval framework, PS forms
• Tested AP and GL for upgrade and logged defected in HP Performance Center.
• Used Load runner to test system stability and performance under extended load, average load and maximum load.
• Tuned performance for several critical custom SQL's without which the workflow process would not have gone live.
• Converted a custom report from Crystal to BI Publisher report.
• Used GL EXCL JRNL process to import spreadsheet vouchers into PeopleSoft.
• Enabled rich text in client's homepage pagelet to enhance the look and flexibility for the employee communication
• Customised Voucher Express component to push voucher to workflow as soon as they are saved.
• Resolved the error in which download grid to excel was stripping leading 0's by making changes to psappserv.cfg.
• Used Java.Land.Thread class sleep functionality to trigger delivered app engines in sequence instead of parallel to avoid database contention issues and to improve performance. Also enabled row level locking for table's tablespace.
• Changed PS Personalisation options to address the issue of inconsistent time zone information of several delivered pages.
• Worked on Integration broker, SQR's, Peoplecode and other online objects as a part of upgrade.
• Migrated workflow and PS forms setups using DMS scripts.
• Created PS forms for vender approval process and other simple business processes.
• Handled go live responsibilities for AP, GL batch processes and workflow, User queries, recurring contracts.

PeopleSoft Techno-Functional Consultant

Environment: FSCM 9.0 People Tools 8.51

• Integrated PeopleSoft with a 3rd party system to enable faster invoice processing. This enabled the client to take advantage of discount/payment terms in a timely and efficient manner.
• Worked on SQL server database and created queries for removal redundant data, data validation and for data conversion.
• Integrated AP with ARIBA using app engine and IB
• Developed integration code, application packages, application engines and SQR's to process the data from the 3rd party system.
• Modified AP SQR AP000021
• Tested the PeopleSoft integration with Ariba networks.

PeopleSoft Techno-Functional Consultant

Environment: FSCM 9.0, 9.1, HRMS 9.1 People Tools 8.49, 8.51

• Involved in Development, Enhancement, Testing and Production Support of PeopleSoft Financials and HRMS 9.1.
• Created multiple queries for end users in database and in PS query to help end users get the metrics and the data they needed without running complex reports.
• Made several functional requirements documents and technical design documents for reports and online enhancements.
• Developed a report to help the business units utilize the overstocked inventory other business units instead of making new purchase orders to suppliers. The report is ran everyday and helps reduce inventory and operational costs.
• Worked closely with the end users and developed a report with various metrics to measure the performance of the suppliers. These metrics help the managers make better purchasing decisions.
• Customized the Voucher Entry pages in AP.
• Customized the Vendor Withholding pages for the 1099 Vendors in AP.
• Customized PeopleCode in Application Engine Interface to create flat files sent to financials institutions in AP module.
• Modify the existing reports to ensure that they meet the changes in regulations in business units outside US.
• Applied online PeopleCode customizations and develop SQR/Application Engine batch programs for generating reports.
• Troubleshoot priority production support issues.
• Managed all migrations with PHIRE tool
• Development of customized Crystal reports in Purchasing and AP. Used Application Designer to create projects for development and migration purposes. Worked on Application Engine, PeopleCode and SQRs.

PeopleSoft Consultant

• Involved in upgrade of PeopleSoft SCM modules Order Management, Purchasing and Inventory and Financials modules GL, AR, BI, AP and AM from 8.9 to 9.1 while supporting PeopleSoft 8.9 Production Environment.
• Extensively used Application Designer to create projects for development and migration purposes.
• Create new Roles and Permission lists in Project Costing module.
• Customized various components and pages using Application Designer and PeopleCode.
• Applied extensive customization to the PO Dispatch.
• Created custom pages to include the Vendor Master table and Item Vendor tables.
• Created training manuals, presentations, and documentation templates for PeopleSoft v9.1 Asset Management, Purchasing, Travel and Expense, and Accounts Payable modules.
• Modify and develop complex queries using PeopleSoft Query tool.
• Developed and managed testing activities.

PeopleSoft Consultant

Environment: HRMS 8.x, 9.0, FSCM 9.0 People Tools 8.22 and 8.48

• Involved in design, development and testing of data conversion programs using Application Engine and Component Interfaces.
• Created Data Mapping specification documents, Design Documents and developed Application Engine, SQR Programs for Data conversion from Legacy systems to PeopleSoft System.
• Successfully implemented several PeopleSoft modules including Time and Labor, Core HR, Benefits Administration, eDevelopment, ePerformance ELM, ESS, MSS
• Completed impact analysis for the customizations in the new PeopleSoft environment.
• Analysed the Meta Data tables using application designer and oracle database to find customizations in the various PeopleSoft components and keep a track of them using Excel.
• Involved in post upgrade Unit and System level testing. Resolved bugs and errors which came from the upgrade.

Environment: FSCM 8.9, People Tools 8.49

• Extensively worked on Order Management and Inventory modules.
• Involved in Support and Customization of PeopleSoft Financials modules.
• Extensively supported GL module and AP module. Implemented Workflow Rules Roles for Workflow. Implemented routings using Route Control profiles for Workflow.
• Built new Queries and modified existing ones using PS Query for Accounts Receivables.

PeopleSoft Developer

Environment: FSCM 8.9, People Tools 8.49

• Used Application Designer to create projects for development and migration purposes.
• Used Application packages to create classes in order to take full advantage of the object oriented feature of peoplecode to handle data displayed on pages, data sent using messages, data stored in tables/work records etc.
• Extensively used Integration Broker to integrate and communicate with third party systems from peoplesoft applications
• Involved in requirements gathering, design and development of custom applications
• Used Utilities for creation of new messages in message catalog as per Business requirements.
• Used Application Designer to export, compare, and copy projects between different databases for upgrades and fixes.
• Wrote technical specifications for the developed objects.