SUMMARY:

• Professional experience of 7 years in development and support of PeopleSoft 8.x/9.x Financial and Supply Chain Management module: Purchasing, e - Procurement, Account Payables, General Ledger, Asset Management, Billing, Accounts Receivables, Order Management, Inventory.
• Sound knowledge in enhancements and support of PeopleSoft FSCM 9.2 modules: Purchasing, e-Procurement, Account Payables, General Ledger, Asset Management, Billing, Accounts Receivables, Order Management, Inventory Commitment Control, Cash Management.
• Good Knowledge on PeopleSoft HCM 9.0 modules: Payroll, Time and Attendance, Employment Data and Workforce Administration.
• Expertise on Data mapping and Data Analysis between Legacy systems and PeopleSoft System.
• Expertise in writing functional specifications for business requirements and test cases.
• Expertise in creating PeopleSoft Technical Design Documents as per the business requirements.
• Expertise in PeopleSoft Concepts and related tools like Application Designer, People Code, People Tools, Application Engine, Integration Broker, Component Interface, PS Query, Process Scheduler, Security, Data Mover, SQR, BI Publisher, XML Publisher, envision and Excel to CI.
• Expertise in writing PS Queries for creating reports.
• Expertise in Workflow design and implemented effectively for various Change Order Approvals.
• Profound knowledge on SQL and RDBMS concepts such as Normalizations, SQL optimization and tunings.
• Sound knowledge on SQL Language Definitions i.e. DDL, DML and DQL.
• Contributed my part in several stages of system life cycle, including defining business requirements, interviewing end users, development, testing, conversion, end-user training and functional documentation.
• Excellent analytical, communication and problem solving skills. Very strong in client interaction and interpersonal skills.

TECHNICAL SKILLS:

ERP: PeopleSoft Financials and Supply Chain Management 9.1/9.2, 8.8

People Tools: Application Designer, Application Engine, Workflow, Component Interface, Integration Broker, People Code, AWE, Query, Process Scheduler, Data Mover, Security, File Layout, Application Messaging, Excel To CI.

Scheduling Tools: Process Scheduler, Control M, Tivoli, Zena

Languages: People Code, ASP 3.0, VB 6.0, HTML, VBScript, JavaScript, UNIX, Java, C/C++

RDBMS: SQL Server 7.0, 2000, Oracle 11g, 10g, 9i, 8i, 7.3

Administration Tools: Portal Administration, Object Security, Workflow, AWE and Query Security.

Reporting Tools: SQR, Crystal Reports 8.x, PS Query, envision, XML publisher, BI Publisher, QlikView, Tableau, Business Objects

Operating Systems: Windows NT 4.0/XP/2000/98/95, Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. Technical Consultant - PeopleSoft Finance

Responsibilities:

• Gave support for end users to create reports using PS Query and envision.
• Gathered requirements from users and designing the Functional documents.
• Contributed my part in automation of asset transfers by creating a specific Component Interface for transfers.
• Provided functional assistance to users in case of any difficulties for transaction processing.
• Designed the dup checking functionality in AP module.
• Designed the reconciliation process from start to end in AP module.
• Supported UAT for the development done by the off-shore team.
• Designed the envision report from scratch in General Ledger (GL) module for one of the GL month end processes.
• Resolved issues in Voucher Posting and Payment Posting (App Engine Processes).
• Designed the department and operating unit Excel to Component Interface’s (CI) in Asset management (AM) Module.
• Designed a custom interface which will accept files from other systems and create Journals into the PeopleSoft GL system.
• Assisted in Fit and Gap Analysis, business requirement gathering, configuring the system, demo, test plans, resource allocation and issue allocation.

Confidential, Chevy Chase, MD

Sr. Techno Functional Consultant - PeopleSoft Finance

Responsibilities:

• Gathered requirements from users and designing the Functional documents.
• Coordinated with legacy system consultants to comprehend the data volumes in AP, AR, GL modules and decide cut-off date for data migration.
• Performed record field mapping for delivered records.
• Worked extensively on issues related to Asset Management module.
• Customized various pages to include features for customer at Voucher level.
• Configured core tables for integration of AM module with other modules.
• Developed a fresh CI for users to run SQL for correction of wrongly entered data.
• Worked extensively on writing PS Queries for enabling various functionalities to the system.
• Worked on several development requirements like SQR report development and Page customization in AM module.
• Performed Asset maintenance - Asset Adjustments, Re-categorizations and Transfers. Retired and reinstated assets.
• Provided functional assistance to users in case of any difficulties for them to process transactions.
• Supported production team in resolving critical issues after development.
• Configured and monitored various operations in the system for better user experience.

Confidential, Omaha, NE

Techno Functional Consultant - PeopleSoft Finance

Responsibilities:

• Gathered requirements from users and designing the Functional documents.
• Involved in various activities of development life cycle like documenting, designing, developing and testing of Application Engine Programs.
• Worked extensively in creating new Pages, Components and making enhancements to existing pages by adding new features through Application Designer.
• Designed and setup entire Batch run for all the processes required on day to day basis.
• Designed performance tuning for several Application Engine programs and SQRs in Account Payables (AP) Module.
• Involved in customizations made to GL based on Payroll changes.
• Worked on day to day enhancements of the system and support for users especially in AP, AR, AM, GL modules.
• Worked extensively on critical AP, AR, GL related issues.
• Effectively used third party scheduling applications (Control M) for process scheduling.
• Worked extensively on issues related to Asset Management module.
• Prepared Business Functionality document of PeopleSoft so that new developers can easily understand functionality.
• Configured Accounting templates, Processing options, and Payable Options Payment terms for AP and GL.
• Tested Data and Reports.

Confidential, San Francisco, CA

Technical Consultant - PeopleSoft Finance

Responsibilities:

• Involved in Conversion programs from End to End and fine-tuned many conversion programs.
• Implemented the AWE for requisitions for PO module and Projects approval for Project Costing module.
• Involved in the Fit Gap Analysis in the beginning of the project and prepared the functional design documents for the Gaps.
• Prepared the Technical documents and sent for sign off.
• Worked with SYSAUDIT and DDDAUDIT reports in analyzing the data redundancy and identifying the inconsistencies and orphaned objects.
• Converted all the SQR’s programs to application programs.
• Created the new Crystal Reports as per the client requirement.
• Worked on QTP for the performance testing.
• Worked on retrofitting and reapplying the customizations in 9.1.
• Designed the data conversion programs in Application Engine for data conversion from for Purchase Orders, Receipts and Items, Commitment control, Projects.
• Modified existing custom envision reports.
• Developed an Enterprise Integration strategy for integrating HCM and Financial by Setting up the Gateway, Nodes, and Messages using Integration Broker.
• Involved in troubleshooting of Integration broker for integration of data.
• Involved in troubleshooting app engine program PO PO EMAIL.
• Developed new Workflow functionality for Change Order Approvals.
• Implemented Inbound and Outbound programs.

Confidential, New York City, NY

Technical Consultant - PeopleSoft Finance

Responsibilities:

• Created new records, pages and components using Application Designer according to the functionality.
• Wrote People Code for validating the data in the pages and for implementing the functionalities in the Application.
• Worked on developing Subcontract Automation Payments (Work Order) by integrating Recruitment and HR and Finance system for internal system Automation.
• Developed CI based Application engines for retrieving the data from Core HR Recruitment to create the Purchase Orders in Finance as part of Subcontract Automation Payments (Work Order).
• Created CIs for integrating and to sync the Recruitment system data with Finance system for Subcontract employees’ payment automation.
• Created new SQR Reports and modified the existing SQR reports Finance in AP, PO, AM, GL as per the user requirements.
• Created a customized workflow for category based approval in PO, Vendor approval.
• Prepared Technical design documents for corresponding functional documents.
• Prepared Unit testing documents, test logs and testing functionality of the reports based on given requirements.
• Worked on EXCEL to CI for the Item codes creation.
• Worked on AP, Purchasing, AM and Expanse in solving P1, P2, P3 and P4 in PO, AP, AM, Expanse Modules tickets.
• Created the CI based web service for the PO and Expanse modules for the mobile based approvals.
• Wrote various SQL queries for various operations on databases to accomplish user functionality.

Confidential

Jr. Technical Consultant - PeopleSoft Finance

Responsibilities:

• Involved in Creation/Development and Customization of Tables, Views, Pages, Components and Menus using Application Designer.
• Developed several Queries for the Financial Reporting Purpose in AP, PO & GL.
• Involved in setup like User Preferences & Banking Information.
• Worked on Excel to Component Interface for the Vendor Upload Process.
• Involved in the design of Audit functionality to create various records and implemented effectively.
• Created various New SQR Reports and modified the existing SQRs as per the client requirement.
• Development, Documentation, Design & Unit Testing of Application Engine Programs for FSCM as part of enhancements.
• Developed different custom reports using SQR to meet user specifications.
• Read to records and writing to the files by using the Excel files and App Engine.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.
• Used various normalization techniques for Database Normalization while temporarily administering the databases.