SUMMARY:

• Over 10 yrs of experience in the field of PeopleSoft development, system analysis, design and implementation, Documentation and Testing of business application systems.
• Worked as Business analyst and functional lead over 5 years in PeopleSoft which include from requirement gathering using URD and documentation and doing fit gap analysis (current and future state), functional specification document (FSD) and business process flow and charts.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Identified use cases from the functional requirements, wrote use case specifications and created "TO - BE Business Process Workflow" diagrams (activity diagrams) in MS Visio.
• Extensive hands-on experience in UNIX/Oracle development environments with PeopleSoft Financials(FSCM)7.x, 8.x, 9.x (AP, GL, AR, Billing, eProcurement, Purchasing, AM, Project Costing, Expenses, Treasury, Inventory, Order Management.
• Extensive experience in Application Engine, PeopleTools, PeopleCode, SQR’s, Crystal Reports, Data Mover, Process Scheduler, Nvision, Component Interfaces and Integration Brokers.
• Experience in Upgrades and New Implementations, Conversions, Migrations, Interfaces and Reporting.
• Hands on experience on collecting requirements, Business Analysis, Gap Analysis, Configuration, testing, user training, performance and post implementation support.
• Also involved in creating test scripts and test cases for various project and executing these scenarios under testing tool application for Quality assurance.
• Experience in designing databases and client-server architectures, Performance Tuning and PeopleSoft Debugging. Created use case diagrams using MS Visio to show interaction between the actors and the use cases as well as to demonstrate the relationship between the use cases.
• Worked in PeopleSoft security including creating and managing user roles, permission lists, user profile management.
• Worked directly in support role dealing with Customers.
• Documentation of business processes and workflow.
• Configuration and Setup of key tables within the applications.
• Coordinate data migration for all for all new acquisitions.
• Ability to manage and participate at different levels on multiple tasks simultaneously, meet deadlines, and exceed goals in high-pressure situations .
• Strong writing, documentation, and speaking skills, with the ability to communicate ideas in both technical and user-friendly language.
• Utilize talents, skills, and knowledge in all assignments for the purpose of delivering excellent customer service.
• Guides preparation and delivery of services by seeking a thorough understanding of customer mission, goals, and values.
• Shifts easily among different technical and project roles as required by situation.
• Monitor installation of patches / upgrades / changes / enhancements including assessment on impact to the Finance organization.
• Maintain hierarchical rollup (master trees, alternate trees, department trees and account trees). Maintain elimination trees, consolidation trees, and elimination sets.
• Ability to maintain confidentiality and demonstrate discretion in handling sensitive information and data.
• Strong communication skills combined with a positive attitude make me a key team player.
• Demonstrated leadership ability to resolve issues, drive projects, and meet deadlines, motivated to develop successful solutions.

TECHNICAL SKILLS:

Applications: PeopleSoft Financials (FSCM), HRMS 7.5, 8.x, 8.0, 9.0, 9.1,9.2 (AP, GL, AR, Billing, AM, Inventory, Purchasing, Expenses, eProcurement, PC, GM, Order Management, Contracts and Treasury, Oracle E-Business Suite (EBS) 11i & R12 / Fusion Procurement Cloud / SupplyChain

Development Tools: Application Engine, PeopleCode, Application Designer, EDI Manager, Process Monitor, Upgrade Assistant, Workflow, Query ManagerAdministrative Tools: Process Scheduler, Data Mover, Import Manager, Security Administrator, Object Security, Tree Manager, STAT, Autosys, ODBC

Integration Tools: Application Engine, Component Interface, Integration Broker

Reporting Tools: PS Query, Crystal reports, nVision and SQR,XMLP

Databases: Oracle9i, 10G, 11G, SQL Server, DB2, MS SQL

Languages: C, SQL, PL/SQL, PerlScript, ShellScript, Vbscript, COBOL, Mainframe, HTML, XML

O/S and Administrator Tools: Windows NT/2000/XP, UNIX, LINUX, TOAD, SQL*Plus, SQL*Loader, MS Office, MS Project, Rational Suite Products, Visio

Additional Skills: Fit/Gap Analysis, Debugging, Application Tuning, Testing, Document Test Scenarios, Writing Functional/Technical Specs.

PROFESSIONAL EXPERIENCE:

Confidential

Functional Lead

Responsibilities:

• Configured Mobile Travel and Expense so that every employee can submit their expenses using Mobile device and approver can also approve the expense using mobile device.
• Established new reengineering business process for the use of the Project Costing module.
• Provide end user support for all financial modules.
• Provide consulting expertise to clients on Oracle E-Business Suite implementations and Oracle Fusion Procurement Cloud Implementations.
• Experience in creation of BI Publisher Reports; FRS ( financial reporting studio) Reports and OTBI ( Oracle Transactional Business Intelligence) reports in Oracle Cloud environment.
• End to End implementation experience in Oracle Fusion Cloud Technology (Finance and SCM Modules).
• Worked with application design and development from business requirements analysis through implementation in Oracle Cloud Financials including GL Daily Rates, Invoices, Payments.
• Experience in ADFDI, FBDI and Web Services in Oracle Cloud environment.
• Handle multicurrency accounting in financial applications and performed analysis on multi-currency for AP/GL reconciliation.
• Implementation and maintenance of systems that interface with ERP and support of expense application.
• Tracked spending and made corrections, additions and updates into PS Treasury Cash Management module, reconciled transactions and developed reports for Risk Manager's review.
• Helped business teams to perform testing or acceptance testing for post upgrade bug fixes in areas like Project costing, Grants Management, Billing, Accounts Payable, Order to Cash and expenses.
• Responsible for customization of purchase order, requisition activities pages in eProcurement.
• Commitment control and Entry event process support and monitoring and applying SQL fixes to rectify wrong entries.
• Configured the Treasury accounting to view, approve accounting transactions and Journal generation and post to GL.
• Provided the ability to do Treasury regular and draw down EFT, BAX and international SWIFT ACH/WIR transfers.
• Set up the bank reconciliation properties like BAI2 code mappings for AP checks/ACHs and Treasury ACHs and Wires to reconcile by Auto reconciliation.
• Converted legacy EFT/BAX fund transfer templates into Treasury templates.
• Development of various automated processes to update certain Peoplesoft tables to reduce the amount of data entry work using application engine and SQR.
• Perform Fit Gap Analysis based on the current and new PeopleSoft System for all the modules including GL, AP, eProcurement and Security in Financials using Agile methodology.
• Conducted user interviews, gathered requirements, analyzed requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Integration of Billing with third party systems and Contracts to create invoices and applying payments and managing the receivables.
• Used PeopleTools 8.53 for creation and modification of Process Definitions, Records, Pages, components to run Custom SQR's and Application Engine.
• Prepared PowerPoint presentation on how the functionality works for AP and Project Costing.
• Worked on setting up the business unit structures and product related configurations in Billing and Receivables like invoice templates, charge codes, distribution codes, interunit billing, chartfield combo rules, banking related configurations.
• Designed high level order to cash high level Architecture using order management, Inventory, Mobile Inventory, Cost Management modules .
• PeopleSoft Consultant / Business Analyst supporting the Project Costing and Customer Contracts implementation for Costco.
• AR/ Billing Functional consultant involved adding two additional Billing Business Units and transactions to the existing AR/ Billing system
• Duties will include the design, configuration, and testing of billing and receivables data.
• AR/ Billing SME assisting Lockheed Martin with an upgrade from 8.1 to 8.9. Duties include resolving issues related to the Contracts to Billing Interface, Billing Plans, InterUnit Billing, GL Accounting Entries, and AR Processing. configuring Billing for a new Legal Entities, currencies, custom tables and panels, products, and taxes; Testing new Billing configuration, Legal Entity configuration, use of Euro Currency, and custom Invoice presentation; and writing queries to better enable end users to analyze data and perform their duties.
• Spreadsheet uploads for Billing and AR Deposits, XML invoices and statements.
• Leading the Project Costing and Customer Contracts conversion meetings to discuss the best practice conversion approach from their current legacy system to PeopleSoft 9.2.
• Extensively worked on Travel and Expense module by making enhancement to the pages and processes as per the requirements.
• Worked with PeopleSoft Fluid UI in creating a completely responsive device independent design providing advanced user experience.
• Completed development, testing and worked as first point of contact in Inventory QSP interface files.
• Performed end to end testing of HRIS SOX application.
• Provided support for PeopleSoft 9.2 and Peopletools 8.53 upgrade.
• Provided post-production support for Expense module.
• Identified PeopleSoft Issues, opened case with PeopleSoft created Incident and applied patches to Vanilla Database and migrated the same to other environments after doing Compare Reports.
• Used database Hints in some of the process to improve the performance.
• Delegated work to off-shore team and performed as a lead in several projects.

Environment: PeopleSoft Financials(FSCM) 9.1, 9.2 (AP, PO, Inventory, AM, PC, GL, Expenses, GM, OM, Contracts, eProcurement, Treasury), People Tools 8.52, 8.53 PeopleCode, Application Engine, Crystal Reports, Nvision, SQR, Oracle 11G, Stat, Unix.

Confidential, New York

Business Analyst

Responsibilities:

• Understanding Business Requirements and verifying its feasibility in terms of PeopleSoft Application.
• Carried out full life cycle implementation of PeopleSoft FSCM modules (v8.8).
• Verification of development releases in PeopleSoft Applications and ensure that they adhere to SOX compliances.
• Deliver Functional Design documents for the Customizations, Interfaces and Reports.
• Created report specifications for the custom nvision Consolidated Balance Sheet & Income Statements report.
• Set up new Payables Business Units . Defined Table Set sharing, SetId and Record Groups.
• Configured AP matching rules , established AP accounts, distribution codes and set-up payment terms .
• Configured AP/GL modules for 3-way matching, Automatic Bank Recon Process for all orders, ACH and WIRE transfers with manual Pay-cycle approval by AP Manager before transferring to Treasury department.
• Troubleshot Journal Drill Down GL/AP when the Accounting Entry Definition is other than APDEFN.
• Defined and setup SET IDs. Defined GL Business units and setup GL security with Permissions Lists, User Roles and Profiles .
• Performed AP-GL reconciliation and created queries to check flag status to assist in future.
• Assisted in correcting Commitment Control Budget Journal Errors from Journal Entry-Lines pages.
• Performed matching validation between receipts, purchase orders, and invoices.
• Optimize the complete process Procure to Pay Cycle (PO, AP, AM and GL) and Order to Cash (BI, AR and GL).
• Provided support for Accounts payable inbound EDI files and Withholding/1099 processing.
• Configured and Setup GL Combo Edits for external Sub Ledgers integrated to PeopleSoft to ensure combination of Chart Field values and related accounts used together in accordance with our business rules.
• Responsible for the hands-on configuration of the Commitment Control and GL module.
• Implementation and support of workflow application for journal entry approval process.
• Implementation and support for client and vendor EDI interface process.
• Support Asset Management application.
• Worked with Accounts Payable, General Ledger, Cash Management on various customizations, which involves Positive Pay, Vendor Interface, Automation of journal entries, Service Fee Automation, Cash Reserve Priority.
• Involved in developing and customizing the reports using the tools PS Query, SQR, and XML Publisher reports.
• Worked with external systems interface/conversion of vendors, vouchers, Purchase orders, Electronic PO's, Receipts and Items.
• Queried PO tables like PO HDR, PO LINE, PO LINE SHIP, PO LINE DISTRIB, and PURCH ITEM ATTRIB for troubleshooting PO processes.
• Performed Asset maintenance - Asset Adjustments, Re-categorizations and Transfers. Retired and Reinstated assets
• Troubleshoot resetting of Asset Depreciation without deleting the entire Asset.
• Troubleshoot deleting of Asset Profiles.
• Troubleshoot changing the default (AM) depreciation during asset Re-categorization or retirement.
• Modified Asset Net Book Value Crystal (AMNB1000) report.
• Designed order management and inventory customizations to work with their highly customized manufacturing department.
• Conducted global support and trouble shoot for PeopleSoft 9.0 Order Management application.
• Reconfigured Inventory 9.0 module and implemented demand fulfillment from order management.
• Designed and developed a custom WorkFlow solution for RFQ approvals within the PO module.
• Designed test plans for AP Vendor related functionality like, Vendor Definition, One-time Vendor Definition, 1099 Vendor Definition, Inactive Vendor and Vendor Maintenance.
• Participated in creating test scripts and testing AP Interfaces like AP Positive Pay functionality.
• Conducted fit gap sessions, requirement gathering, process optimization 'AS-IS and TO-BE' sessions, Prototype Use-Cases to focus on 'cradle to grave' business transactions.
• Created the RACI (Reviewers, Approvers, Consulted and Informed) document so that all team members are aware of their responsibility. Also, worked on the change management procedures to facilitate communication and training.
• Co-coordinated the User Acceptance Testing (UAT) daily with the SME's to make sure that all the business requirements are addressed in the application.
• Developed testing strategy for implementation and development.

Environment: People Soft Financials(FSCM)8.8,9.0 (PO, AP, GL, AR, Order Management, BI and AM) ), People tools, Crystal Reports, Nvision, SQL, PS Query, Oracle 10G, Unix and Windows NT

Confidential, CA

PeopleSoft Developer

Responsibilities:

• Customized Project Activities page, added controls & PeopleCode to display All Activities \ Closed Activities \ Non-closed activities for the selected Project.
• Developed custom Interface using Application Engine programs to archive payment, voucher and vendor tables in AP.
• Modified Return Material Authorization reports in Order to Cash.
• Created custom crystal report for check printing for vendors in AP., created crystal reports for financial (FSCM) reports in GL.
• Used various trace options via Utilities \ configuration manager, and debug mode in app designer to fix various issues \ bugs of PeopleCode & Application engines.
• Wrote custom App engine programs to load bank information into treasury tables.
• Documented issues, test scenarios, wrote technical specifications.
• Used DMS, Import mgr, SQRs and SQLs for data migration and conversion tasks.
• Worked with the Users and the testing team, involved in discussing their issues and helped them out in finding the proper solutions for their requirements.
• Modified eProcurement punchout in eProcurement module.
• Modified PeopleCode for the eProcurement Module to default the accounting for all the custom chartfields.
• Developed workflow objects for eProcurement workflow
• Developed an SQR for PO Export interface that reads the data from PO tables and writes it to the staging tables that has been interfaced to third party.
• Developed the AP Discount Lost Crystal Report to keep track of the discount lost payments.
• Written People Code as per the requirement on different events to implement the business rules and validations.
• Designed and Developed Custom Adjustment processes for Accounts Receivable Customers balances. Created batch balance adjustments, batch Collections and batch Refunds.
• Designed and developed custom returned check Process to create Customer account adjustments.
• Customized AR AUTOMNT application engine program and added additional user-defined functionality.
• Customized AR PAYLOAD application engine program and added additional user-defined functionality.
• Created Query trees to group all the custom record definitions.
• Customizing pages, PeopleCode and Record definition for AR and BI modules.
• Customized Aging reports, Collections reports and Worked on Sales Journal report.
• Customized Customer reports, Product reports and Cash drawer reports in Order to Cash.
• Wrote SQR interfaces for conversion of AR data from legacy to PeopleSoft.
• Analyze setup*.sqc and other global SQCs for system compliance.
• Wrote\Modified both delivered & custom SQRs and ran them through the PIA.
• Created new permission list and roles for Technical Organization people.
• Updated the voucher tables in PeopleSoft so that the latest data is sent to the third party system.
• Wrote PL/SQL in Billing module to retrieve customer details from billing tables.
• Created ‘single-click’ report for printing Journal entry report in GL, which schedules the report to run on process scheduler and the report can be viewed with a hyper link right on the page., without going to the report manager.
• Involved in maintaining the development, test, production environments and moving objects from one environment to the other.
• Handled production support, resolved help desk tickets after go-live.
• Worked as a primary support for GL VB macros, performed all template and upload maintenance.
• Interacted directly with Customers in regards to template and upload development.

Environment: PeopleSoft Financials(FSCM) 8.0, 8.8, HCM (GL, Projects, AP, AR, BI, Expense, Purchasing, Treasury, eProcurement, Contracts and AM modules, Payroll, Recruiting, eBenefits, eRecruit, Time and Labor), People Tools 8.12, 8.17, 8.44, PeopleCode, Application Engine, Component interface, Integration broker, SQR, Crystal reports, Oracle 9i and Windows 2000.