SUMMARY

• 7 years of PeopleSoft Functional Business Analyst experience, working with AP, AR, PO, Procure to Pay, Project Costing/Assets, GL, Billing, Inventory, eProcurement, expenses, Workflow and Grants.
• Experience in PeopleSoft 9.1/9.0/8.9/8.8/8.4/7.5/6.0 , including PeopleTools, Security, PeopleCode, SQR, App Engine, Component interfaces, Integration Broker, Web services, XML Publisher, Crystal Reports, and nVision .
• Extensive experience in areas of development, implementation, support, upgrades and testing of commercial systems using PeopleSoft 9.1 (Financials, SCM, HRMS and Distribution Module), PeopleTools, PeopleCode, SQR/SQL, Crystal Reports, nVision, Oracle 10g,11g, PL/SQL, and SQL Server.
• Strong functional and support skills, familiar with the accounting structures for a variety of client markets and applications.Performed as liaison between IT and the operational business units.
• Strengths include: supporting customers; identifying goals and objectives of the business; configuration and troubleshooting existing configuration; re - configuration, testing; building configuration documents; and working closely with business stakeholders.
• Projects have involved upgrades, re-engineering, designing, mapping, new installations and troubleshooting.
• Roles: Functional Lead; Upgrade Lead, Designer, Re-engineering Lead, Assessment Lead, Training Lead and Help Desk 2000, Lead production support. Work flow lead 8.8 to 9.1, PeopleSoft Purchasing and Accounts Payables 9.2 and General Ledger 9.1 training using UPK format.
• Applications: Training & Development, PeopleSoft V7 - 9.1 FMS and FSCM, AP 9.2, PO 9.2, Project Costing 8.9/9.0, BI 8.4,GL 9.1, AR 8.9, Inventory 9.0, Workflow Setup, nVision 9.1, Grants 8.4, Security and Permissions 9.x, eProcurement 9.2, Expenses, Answers, Dash Boards and BI (business intelligence), Quality Help Center Testing tool.
• Business Analysis: Process mapping, implementations, fit/gap analysis, work-flow analysis, functional requirements definition, System process re-engineering, Configuration and Re-configurations, OBIEE .
• Upgrade: New functionality review, customization review, upgrade testing, post production support, training, re-configurations, Perform 7 upgrades, PeopleSoft Financial end-to-end business processes with sound technical know-how to support technical team.
• Experience in Analysis and documenting both requirements and design specs, Excellent communication, presentation, analytical and interpersonal skills. Plan and coordinate and organize activities to meet the schedule and budget.
• General Implementation: Process analysis and design specification, conversion strategy design and execution, security strategy generation and application, FIT/GAP documentation, end-user training / knowledge transfer, post-implementation support. Lead, mentor, act as PM and develop a team of analysts in requirements gathering, testing of systems to improve productivity and meet business objectives.
• Financials -GL, AP,AR, EX, KK, MFG, E-Procurement, Billing, Inventory, and Purchasing.
• PeopleSoft Internet Architecture, PeopleSoft FSCM, and PeopleSoft Security Design and configuration for 9.0
• Hands on experience in PeopleSoft 9.1
• In-depth exposure in PS 9.1 - Integration Tools including App. Engine, Component Interfaces, Integration Broker, XML Publisher
• PeopleSoft/Oracle Trained professional in AP,E-Pro, Purchasing and N-vision Reporting tool.
• Working knowledge with 3rd party scheduling tools
• Experience in up gradation of PeopleSoft Financials from 7.5 to 8.4, 8.0 to 8.8, 8.8 to 8.9, 8.8 to 9.0, 8.4 to 9.1 and 9.0 to 9.2
• Extensive experience in Oracle 11g/10g/9i/8i/7.x, PL/SQL and SQL Server.

TECHNICAL SKILLS

ERP: PeopleSoft Financials, Distribution, SCM, HCM; PS Version: 6.x, 7.1, 7.5x, 8.16, 8.17, 8.4, 8.8, 8.9, 9.0,9.1,9.2

Database: SQL Server 2008, SQL Server 2005, Oracle 11g, Oracle 10g, Oracle 9i.DB2.

Database Tools: Toad, SQL Plus, DB2 Client.

Programming Language: PeopleCode, and SQR, C, C++, Visual Basic, JAVA, SQL, PL\SQL

Applications: Adobe Photoshop, Paint Shop Pro, Microsoft Office, Microsoft Excel.

General Tools: Toad, SQL, Bugzilla, Quality Centre 9.2, RemedyForce

Tools: PeopleTools, Application Engine, PS Query, Integration Broker, Component Interface, Web Services, File Layouts, XML Publisher, PeopleCode, SQR, SQL, PL/SQL, Crystal Reports, N-vision

Operating Systems: Windows 7/ Vista/ XP / 2000/98, Unix, Linux.

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis, MN

PeopleSoft Functional /Business Analyst

Responsibilities:

• Worked on FSCM 9.2 and perform assessment business process and Validating requirements, Create and executed Account Payables, Expense, Purchasing and eProcurement implementation of PS 9.2.
• Perform and executed FIT/GAP analysis on above modules: AP, PO, ePro and Exp.
• Create and executed Account Payables, Expenses, Purchasing, and eProcurement Business Process Diagrams (BPDs) for display guide in workshops, using Set Up Manager to configure system
• Establish User Preferences for Account Payables and Purchasing categories, Establish Permissions and Roles for client staff Users and Suppliers
• Created and Configured Suppliers self-service access, Transfer knowledge on Work center portal usage, Create and executed configuration Guides for Account Payables, Purchasing, and eProcurement
• Create and executed Foundation documents for Account Payables, Purchasing, Expenses and eProcurement .
• Configure PO to AP two way and three way business process/ Procure to Pay,Identify and Insert all CEMLIs in a spread sheet to recognized during system build.
• Create and executed Training and Knowledge Transfer documents and guides, Providing best business practices in functional financials
• Create test script mapping sequences for Account Payables and Purchasing, Create and executed Conference Room Pilot (CRP) sessions for Business Process Alignments (BPA) work shops
• Gathering business decisions on design and structure, create 9.0 test scripts mapping to Account Payables and Purchasing/eProcurement
• Preparing and building AWE workflow structure for Account Payables and Purchasing
• Loading Inventory data into tables us Excel ToCI process (aka integration), Loading of Items, Item Categories and commodity codes using Excel ToCI process
• Mapping data from legacy to PeopleSoft, Perform knowledge transfer tasks of trouble shooting various issues
• Provided client with best practices, Established one on one communication with client SME, Attended Oracle classes eProcurement and Expenses.
• Created documentation for fit/gap analysis, configuration, testing and cutover processes,Created test scripts to test the web Punch Out from ePro to Sciquest marketplace and returning the cart from there.
• Performing Fit Gap Analysis and identifying gaps and to bridging the gap by retrofitting the client business process.
• Configured banking information and setup external bank accounts using Cash Management Module. defined Bank, Bank Accounts and Counter Parties in Cash Management to enable the payment processing and receivable processing for AP and AR Modules.
• Worked in Cash Management Module for the bank change project and did impact analysis on the processes and programs that would affect banking details.
• Coordinated with Banks to ensure that the check printing process works efficiently and ensure that the PeopleSoft checks are in compliance with the bank formats.
• Configured financial gateway in Banking Modules to enable ACH processing in PeopleSoft.
• Responsible for fit-gap analysis of Procurement modules, setup and enable ePro change order on the business unit leve.
• Provided Production support activities to trouble shoot ePro/PO batch processes right from budget checking the process to dispatching the POs.Monitored and Production supported 13 batch jobsets that ran every day.
• Assisted users in resolving issues with Journal Generation from sub-system to GL modules, created various nVision Reports in matrix and Tabular formats as per the year-end closing requirements.
• ConfiguredePro, General Ledger, Accounts Payable, PO modules as per the new requirement, configured allocation steps and assisted users in defining allocation definitions and allocation process in GL modules.
• Responsible for Workflow administration/maintenance for Procurement and Accounts Payable modules.
• Resolved issues encountered during batch process of AR update process for item posting into sub-ledger and subsequently into General Ledgers.
• Resolved various issues and created various queries in GL and AP modules, implemented ACH Payment method in their Accounts Payable Module.
• Participated as a Functional Analyst in Implementing vendor conversion and implementing ACH mechanism for payment processing
• Created various critical queries in Accounts Payable modules to identify if there are any data related omissions with regards to vouchers and payments information. These queries were helpful for users to identify any data integrity issues across various PeopleSoft tables.
• Preparation of Unit Test Plans, Test Cases and Traceability matrixes as a part of project implementation.

Confidential -NYC,NY

PeopleSoft Functional/ Business Analyst

Responsibilities:

• Performed testing in all phases and segments of the entire system. Trained and provided fit/gap for AP and GL staff on new 8.7 functionality.
• Performed analysis on Table Set Records; require reconfiguration for proper pointing to main SET ID, Performed research and re-configuration of Accounts Payable Pay cycle page.
• Built a custom Pay Cycle for Accounts Payables, Performed analysis on AP and GL Chart field string; require hiding or charting new field configuration.
• Upgraded General Ledger Workflow vs 8.4 to 8.8 functionally and technically, Reconfigured approvals on the App designer, Setup permissions and roles for GL and AP 8.6.
• Provided technical assistance, Established Suppress Zero amounts vouchers in AP pay cycle, Provided documentation on the use of attachments in all modules,Assisted training department, Performed analysis on operating process.
• Performed cleansing of vendor files, payments address, and open items,Created UAT Account Payable and Purchasing test scripts for five business units.
• Established/configured seed data in the accounts payable and purchasing UAT environment.
• Established/configured security login using UAT environment for users.
• Built Quality Center test scripts, Configured three accounts payables business units manually.
• Created and built Accounts Payables in/out interfaces for five business units.
• Established PO to AP two way and three way business process/ Procure to Pay, Performed analysis on AP and Project Costing design, configuration.
• Prepared PowerPoint presentation on how the functionality works for AP and Project Costing.
• Smoke tested Purchasing and Accounts Payables test scripts, Ensured work-flow working correctly in Accounts Payables based on FDA approvals.
• Set up/configured test data to be use in UAT environment for Purchasing and Accounts Payable users.
• Drafted resolutions to interfaces for Brokers, EDI, and Account Payables, Assisted on building custom report relating to Commitment Control reporting,Assisted/advised on deployment of Accounts Payables.
• Performed testing in all phases and segments of the entire system. Trained and provided fit/gap for AP and GL staff on new 8.5 functionality.
• Performed analysis on Table Set Records; require reconfiguration for proper pointing to main SET ID.
• Performed research and re-configuration of Accounts Payable Pay cycle page, Built a custom Pay Cycle for Accounts Payables.
• Performed analysis on AP and GL Chart field string; require hiding or charting new field configuration.
• Introduced the use of General Ledger 998 entire process, Acted as PeopleSoft Financials UPK Trainer for AP & GL 8.7.
• Upgraded General Ledger Workflow vs. 8.2 to 8.7 functionally and technically.
• Reconfigured approvals on the App designer. Setup permissions and roles for GL and AP 8.6.
• Provided technical assistance, Established Suppress Zero amounts vouchers in AP pay cycle. Provided documentation on the use of attachments in all modules.
• Design the processes for Creation of Asset class, category, books, Transfer of Assets for multiple business units, Retirement of Assets and Depreciation based in Written Down Value method.
• Assisted users in Spread-sheet Journal Uploads functionality to create journals in PeopleSoft GL.
• Designed and created complete configuration workbook for Consolidation / Close process. Worked with Chart Field configurations, Chart Field validation, combo edit checks in GL.
• Defined Ledger Templates, Ledger Groups and Speed Types for journal processing. Implemented the Journal Approval workflow, by approval amounts, using Virtual Approver.
• Implemented Automatic Journal Approval Process in PeopleSoft GL, Implemented PeopleSoft Allocations for allocating departmental expenses across multiple business units.

Confidential, Tallahassee, FL

Business Analyst

Responsibilities:

• Performed analysis and assessments on Inventory module 8.2, Recommended reconfiguration of the of security inventory 8.1.
• Led re-engineering process to configuring workflow process 8.3, Built business case regarding 4 individual warehouses providing separate permissions.
• Performed an assessment for use of delivered PeopleSoft notification, work list and email.
• Reconfigured Purchasing Items Attributes and Item Vendor allocation percentages.
• Reconfigured permissions and roles security, Performed reconfiguration of priority status for vendors.
• Provided, recommended closing of PO /INV closing processing, Prototyped and configured system for testing of the PO/INV closing processing.
• Established and recommended use of inventory work flow for transactions notifications, Tested work flow configuration for approval and notification only process.
• Led fit/gap process with SME: Accounts Payables, Purchasing, Asset Management, General Ledger, and Inventory from versions 8.3,8.2,8.1.
• Recommended reconfiguration of the General Ledger Chart field string, Led reengineering process to reconfigure matching process 8.1.
• Created 65 page New Functionality, Enhancements, Design and Re-engineering document for future system 8.20 enhancements.
• Recommended use of vendor sanctions for validation of valid vendor, Led prototype session in version financial 8.01 for new business/functionality and enhancements.
• Led meetings with subject matter experts in regards to new enhancements being the main focus.
• Established new reengineering business process for use of the AP, PO, GL, Inv and Assets modules.
• Established dropping legacy reports vs. 8.2 delivered reports for all modules future use.
• Identified replacements for customized functionality, Provided spreadsheet for table and record changes, deletions and additions.
• Identified areas of opportunity and recommendations/outlook, Provided a training guide for Inventory 8.2
• Provided copy of Purchasing and Accounts payable 8.3 test scripts, Acted as lead on 8.6 upgrade project for Accounts Payable, Inventory and Purchasing.
• Researched and analyzed current and potential system features and functions pertinent to company strategy and supported business function(s).
• Prepared analysis to use two-way matching going forward,Set up Pay Cycles using ACH payments.
• Set up pay cycles in PeopleSoft Accounts Payable, Tested pay cycle functionality for accuracy and errors.
• Analyzed current capabilities and usage trends to make informed recommendations as to how to improve the procure-to-pay process.
• Configure PO to AP two way and three way business process/ Procure to Pay, Ensured positive and effective working relationships with business process owners.
• Conducted fit gap sessions to solely identify a high-level difference between FMS version 8.3 and 8.1
• Provided, recommended closing of AP and PO closing processing,Prototyped and configured system for testing of the AP and PO closing processing.
• Prototyped a data set for retrieval by the Purchase Order Rollover Workbench, Prototyped how to close Requisitions, Purchase Orders, and Roll over processing.

Confidential - Hanover,MD

Business Analyst

Responsibilities:

• Responsible for gathering and analysing the new requirements from the Business users during the upgrade phase.
• Was involved in designing test strategy, test cases and scripts for Accounts Payable, Project Costing and Asset Management module.
• Was responsible for the integration of Accounts Payable and Project Costing Module with all the other modules and data reconciliation during upgrade.
• Was involved in setting up the new Business Units, configuring the Setup options and Business Units defaults for Accounts Payable, Project Costing and Asset Management modules.
• Worked on the integration of Accounts Payable with Purchasing, Project Costing, Commitment Control, GL modules and with 3rd Party applications like Oracle IPM, TEG etc.
• Worked on setting up the new Pay Cycle, Bank Configuration and their new file layout setup by co-ordinating with Bank and client.
• Worked on integration of Project Costing module with 3rd Party applications like Clarity timesheet and with other PeopleSoft modules Accounts Payable, Asset Management, Purchasing, Commitment Control and General Ledger modules.
• Created Functional design document and Excel to CI interface to upload the Project Transactions from Excel Sheet.
• Extensively involved with client in helping them to integrate the 3rd party products and interfaces with PeopleSoft and helped with the integration testing for these in PeopleSoft.
• Helping users to close out the Financial Applications during the month end, quarter end and year end.
• Responsible for creating new PS-Queries upon request from users and also made change to the existing queries as per new requirements.
• Involved in working with Business Users for tailoring the business process and suggesting the best business practices either by using delivered Business processes or customizations. The extensive interaction and brain storming sessions with users was appreciated by client.
• Involved in Research, Troubleshooting, Tracing and debugging batch processes.
• Worked extensively on AP/GL Reconciliation and month end reporting for AP/PC/AM/PO modules.
• Responsible to correct the data in Project Costing PROJ RESOURCE or other related tables before it can integrate with other modules correctly and job abends can be avoided.
• Worked on variety of Production issues like Unique Constraint errors, Invalid profile code, Incorrect Resource Category/Sub-category Combination, Asset ID missing, Budget checking errors and issues, Activity Code errors, Pay-cycle issues, Voucher Posting issues, AP/AM/PC accounting entry issues and various other month/year end issues.
• Worked on customizing multiple SQR and Crystal Reports to change the Bank File layout and other reporting needs.