SUMMARY:

• 7+years of experience as PeopleSoft Financials Consultant for IT, business, and finance industries.
• 4 years of Experience in analyzing and resolving financial user queries in e Procurement, Account Payables, Account Receivable, General ledger, and Billing in PeopleSoft.
• Fluent understanding of PeopleSoft Financial Management process throughout lifecycle, including design, configuration, development, integration, testing, and deployment.
• In - depth project management experience working with clients, business partners, and end users.
• Extensive experience in PeopleSoft Analysis, Implementation, and Upgrade & Production support experience.
• Design, and development and testing of various PeopleSoft modules such as GL, Order to Cash process, Purchase Order.
• Involved in Test planning, developing and writing Test Plans, Test Scripts, and execution of Test Scripts and deployment of java-based Oracle web center operations board and PeopleSoft FSCM and HCM v 9.2 (implementation project) Implementing Oracle EPM Financials, Supply Chain and Campus Solutions applications of PeopleSoft EPM using Confidential Ascential and OBIEE Software.
• Resolved issues related to project budget, Project Trees, Commitment Control and contract rate plans.
• Proficient in the use of: vision, SQR, Application Designer, Data Mover, Import Manager, Maintain Security/ Security Administrator, Query/Crystal, Application Engine, People Code, Mass Change, Workflow & Database Agent, Message agent
• Responsible for Developing Interface and Data conversion for FSCM modules (AP, INV, OM, PO, iPro) using Component Interface, Application Engine, Excel to CI, File Layout.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered Crystal Reports and SQR Files.
• Customized eProcurement Purchase Orders and other reporting templates to modify company formats using PeopleSoft XML Publisher from crystal reports.
• Worked on configuration of FI sub-modules General Ledger (FI-GL), Accounts Payable (FI-AP) and Accounts Receivables (FI-AR).
• Experience in PeopleSoft production support, enhancements, and upgrades to existing and new PeopleSoft HCM and PeopleSoft CRM Customer Support.
• Expertise in PeopleSoft Implementation, Upgrades, Interfacing/ Reporting, Data Conversion and Troubleshooting.
• Generated Crystal reports for updating the status of Order Schedules, for Processing Inbound and Outbound transactions for order, for reporting all contracts and their status.
• Enhanced existing SQR’s to print invoices, purchase orders, price confirmations and request for quotes. Receiving Vendor, Item, Receipt Date and Receiving Log by Date, Item reports.
• Excellent experience as a technical consultant in People Tools such as Application Designer, Component Interface, People Code, Page Designing, Application Engine, Component Interfaces, Application Package, Application Messaging, Integration Broker, Data Mover, Integration Broker Administration, People Code Debugger and Application Security.
• Very strong in SQL's. Extensively worked with SQR, PeopleSoft Query in creation and generation of organizational reports.

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Peoplesoft FSCM Consultant

Responsibilities:

• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Design and developed the technical specification for any modification to the existing PeopleSoft object (SQR report, People code, application engine etc.) or to create any new object in PeopleSoft for any customization.
• Responsible for the daily support and maintenance of the PeopleSoft HCM 9.2 software system.
• Upgraded journal import process from PeopleSoft 9.0 to PeopleSoft 9.2 functionality.
• Tested the GL transmission reports along with the Accounting Transition team to submit GL transmission details from Intrepid/PeopleSoft to client's SAP system.
• Resolved inventory pick plan reports are not printing for few MSRs within the same business unit.
• Experience in analyzing and resolving financial user queries in e Procurement, Account Payables, Account Receivable, General ledger, Purchase Order and Billing in PeopleSoft.
• Created a Receipt Load process to load inventory fuel receipts from MMS and Maximo legacy systems to PeopleSoft.
• Establishing P-card security using different pages User profile roles, Register Procurement card role, Procurement access rights, Assign Proxies, Copy/Move Exceptions and Assign Speed Charts.
• Defining Card Holder Profile, define merchant category code (MCC) blocked, Define Visa transaction type codes, define procurement card mapping, set up procurement card load statement options, stage procurement card statements using PeopleSoft Integration Broker, Stage procurement card statements in a flat file format, Using the credit card data enterprise integration point (EIP), Stage procurement card transactions for voucher processing.
• Converted 3000 legacy vendors to AP Vendor Master. Involved in defining Approval Rule Sets for Purchase Order Approval in PO.
• Customized RMA SQR Report to display RMA transactions for internal and external locations in Inventory module.
• Fully responsible for Supporting the client for EPM Planning and Budgeting, FSCM Billing and AR, Purchasing, Accounts Payable, Asset Management, Commitment Control and General Ledger.
• Supported the multiple testing tracks, prepared summary of test results as well as involved in troubleshooting issues uncovered.
• Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units.
• Leading a team of two technical and 2 Functional consultants with hands-on implementation as a functional lead for Accounts Payable 9.2 and General Ledger 9.2modules. Designed and configured combination edits and closing rules.
• Designed AP Voucher approval workflow. Enhanced existing SQR’ s to print invoices, purchase orders, price confirmations and request for quotes.
• Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units.
• Used SCM Integrations to receive IB (Integration Broker) messages from Swiss Log and processed Purchasing, InterunitReceipts, Inventory Shipping, Inventory Adjustments, Inventory transfer. Worked on most critical issues such as Absence Management Balances, Multiple jobs.
• Managing absence event, take, adjustment and entitlement. Integration with payroll system.
• Having good experience managing time and labor like report time, create schedules, organize employee groups, approve time.
• Involved in the Absence Management implementation as a technical consultant.
• Responsible for designing and developing Aetna Eligibility and security interfaces using application engine program. These Interfaces send the FMLA, STD & LTD data, security level data of the qualified employees to Aetna.

Confidential, Phoenix, AZ

Peoplesoft Consultant

Responsibilities:

• Building application tables, pages, panels and reports to conform with global requirements
• Developing code for PeopleSoft financials modules and unique complex functions in accordance with business line
• Provide Finance functional conceptual training on e-Procurement module to team.
• Involved in the reviewing, writing & execution of Test cases pertaining to Workforce Administration, Payroll, e-Compensation, Variable Compensation, Benefits, Benefits Administration, e-Performance, Skills inventory and MSS/ESS.
• Keeping Inventory document for the client which gave the idea of all the objects used in project and the unused objects which could be discarded.
• Assisting in the planning and implementation of PeopleSoft application and tools
• As an HCM functional consultant, was engaged in data mapping and conversion activities related to Human Resources including Compensation; performance and Base Benefits in the initial phase and then leading to the Upgrade phase.
• Managed the internal reporting requests for various Peoplesoft Applications by developing and writing queries, architected and configured internet facing proxy and web servers for PeopleSoft apps.
• Maintenance of Accounts Payable & Accounts receivable and Cash management Records. Preparation of Journal, cash book and Bank book.
• Developed People code to create dynamic grids to populate Ledger information relating to budgets, encumbrances and actual from Finance and Student admin modules.
• Worked on Global setup of the manager (MSS) and employee self-service (ESS) based on the job codes, salary plan admin and grade for various countries. These also include their payroll currently setup and pre- retirement or termination reimbursement criteria.
• Facilitating Fit/Gap sessions to determine configuration and customized Benefits Administration (Benefit Programs, Benefit Plans, Benefit Events, Rates and Calculation Rules)
• Extensively used People Code, Application Engine, SQL and SQR. Custom Process using Application Engine which will generate outbound file from PeopleSoft.
• Responsible for the stabilization and support of a custom real estate services cash receipt, revenue recognition and payment application, written in People Code, designed to utilize and interface with PeopleSoft 9.1 Project Costing, Receivables, General Ledger.
• Worked on enhancements in recruit such making changes to the job application process by injecting additional pages as per the requirements.
• Wrote complex SQL Queries using joins, unions and nested sub-queries. Created index on Queries for improving the performance.

Confidential, McLean, VA

Peoplesoft Business Analyst

Responsibilities:

• Involved in design and development of conversion programs using SQR for transferring of data from legacy system to PeopleSoft.
• Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
• As part of PeopleSoft Financials and supply chain management (FSCM) team worked on implementation of General Ledger, Accounts Payable, Accounts Receivable, E-pro and Purchasing, Order Management and Inventory modules.
• Involved in testing the two independent workflows have been setup for two different business units in approval workflow for Purchase Orders and Requisitions.
• Developed conversion and interface programs using BIP and Application engine to load the PeopleSoft application tables from the legacy tables.
• Executed and prepared test scripts for Integration Broker (xml messages) to load data from third party systems to Accounts Receivables/Billing modules.
• Developed interfaces, reports and modified Peoplesoft Objects, Application Engine, People code, SQR, vision, Crystal Reports and provided technical support.
• Performed customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that is already in stock.
• Developed Purchasing Interface that loads data from flat file into staging tables while doing various data validations using Application Engine People Code and finally loads into PeopleSoft tables through Component Interface.
• Worked on several enhancement requests including changes to AR/express deposit pages, writing custom queries using the PS Query Tool, People Code changes, importing conversion Data, creating and configuring 3rd party Interfaces into and from PeopleSoft and out/in, to/from other systems.
• Developed interfaces, reports and modified Peoplesoft Objects, Application Engine, People code, SQR, vision, Crystal Reports and provided technical support.
• Performed customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that is already in stock.

Confidential

Business Analyst

Responsibilities:

• Built rapport with individuals across the business enabling me to understand how the bank works from trade reporting perspective (backend to frontend reporting).
• Analyzed derivatives product and provided quality assurance related to modeling & pricing.
• Facilitated JAD (Joint Application Development) sessions. Ability to identify and document critical requirements through analysis.
• Implemented distinct phases of Software Development Life cycle (SDLC) including Strategic Systems Planning, Designing, Programming, Testing, Documentation, and presentation to clients and preparing customer specifications as part of software technical requirements and Customer support.
• Performed planning and development of Test Plans, Test Cases and Test Scenario to meet product's business requirements.
• Collaborated with stakeholders to discuss the feasibility, profitability, and risk of the project and assist to develop project plan using Agile Methodology.
• Gathered detailed business requirements and deliver detailed business functional requirements specifications.
• Created UML diagrams such as Sequence Diagrams, Activity Diagrams and User Stories when needed.

TECHNICAL SKILLS

Peoplesoft: FSCM

General Leader: Accounting

Purchase Order: OBIEE

Billing: Accounts Payable

Accounts Receivable: Purchasing

Procurement: Inventory

Commitment Control: Outer Management

Project Costing: Contracts

Expenses: Assets Management

Data Mover: Application Upgrade