We provide IT Staff Augmentation Services!

Peoplesoft Techno Functional Consultant Resume

Washington, DC

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience with strong Techno - Functional experience in PeopleSoft with hands on experience in Requirement/Data Analysis, Fit/Gap Analysis, Customization, Upgrade, Testing, End User and Maintenance of PeopleSoft FSCM and HCM applications (8.9 and higher) for full life cycle implementations.
  • Excellent understanding of functional aspects of various FSCM/HCM modules in PeopleSoft - Purchasing, eProcurement, Inventory, Asset Management, Lease Administration, Accounts Payable, Commitment Control(Budget), Billing, Project Costing, Accounts Receivable, Cash Management, Travel and Expense, Order Management, General Ledger and Integration with General Ledger in FSCM and Payroll for North America, Absence Management and Time and Labor in HCM.
  • Technical experience in working with People Tools - Application Designer, Application Engine, People Code, Process Scheduler, PS Query, File Layout, Excel to CI, PeopleSoft Security.
  • Served as a finance/supply chain functional lead for PeopleSoft system upgrade from 8.9 to 9.1.
  • Experience in cross platform integration of PeopleSoft with various legacy system (IBM Mainframe, Ariba, Maximo, Coupa, SIM, Verient, Captiva, Falcon, Ascent, iValua, Concur).
  • Good understanding of PeopleSoft Internet Architecture and Table Setup.
  • Strong SQL skills, ability to write and execute advance SQL on Oracle and MySQL server database.
  • Firm knowledge of different methodologies of SDLC including Agile and Waterfall. Attended a workshop/ in Agile conducted by CCPace.
  • Strong knowledge in Test Automation - configured and developed automated test scripts in PeopleSoft Test Framework.
  • Proficient at writing Test Plans and Test Strategies and strong working experience in ALM, ClearQuest and JIRA .
  • ISTQB Certified Tester . Extensive experience in Functional, System Integration, Regression, User Acceptance and Security Testing.
  • Excellent experience in Documentation, End-Users and Knowledge transfer .
  • Domain experience in Healthcare, Banking, Mortgage and Insurance .
  • Excellent work experience in Microsoft Office Suite - Excel, PowerPoint and MS Access.
  • Key strengths include teamwork, adaptability to technology and role, time-management, commitment, excellent analytical and problem solving skills.

TECHNICAL SKILLS:

ERP Package: PeopleSoft FSCM 8.9/9.1/9.2 HCM 9.1/9.2

People Tools: Tools v 8.48/8.53/8.54/8.55

FSCM Modules: Purchasing, eProcurement, Inventory, Asset Management, Lease Administration, Accounts Payable, General Ledger, Billing, Commitment Control, Project Costing, Travel and Expense, Accounts Receivable, Cash Management and Order Management

HCM Modules: Payroll for North America, Absence Management and Time and Labor

Languages: C, C++, Java, MS Visual Studio

Database: Oracle 9i,10g & 11g, MySQL

Operating System: Windows NT/ XP/Vista/7, Linux, Unix

Testing Tools: HP Quality Center, PeopleSoft Test Framework, IBM Rational ClearQuest Microsoft Test Manger, Send Master, JIRA

PROFESSIONAL EXPERIENCE:

PeopleSoft Techno Functional Consultant

Confidential, Washington, DC

Responsibilities:

  • Subject Matter Expert for Accounts Payable & Asset Management module.
  • Working closely with the business on an end-end solution right from gathering business/functional requirements, prioritizing the requirements, creating functional specification document and performing fit gap analysis.
  • AP Functional Lead for PeopleSoft tools upgrade from 8.5 .15 version for fluid user experience and cloud management.
  • Trouble-shooting production issues and collaborates with technical resources to research issues and finds solutions by analyzing PeopleCode and PS configurations. Fixed PeopleSoft defects in pay cycle process for Employee and Supplier payments.
  • Writing SQL Query using Toad database management tool for Oracle DB to validate invoice processing for purchase orders, payment creation, wire load, supplier management, journal balancing, AP month end reconciliation, month-end accounting entries to the General Ledger.
  • Implementation testing and Deployment of change requests/enhancements/defect fixes for PeopleSoft Accounts Payable in Production Environment.
  • Writing PeopleSoft Query using PS Query Manager for adhoc AP team report requests and BI Publisher.
  • Maintaining backlog issues in JIRA, prioritizing the issues, functional UAT testing of all the PeopleSoft enhancements, preparing Business shakeout plan and testing along with Customers in production environment for monthly releases related to Accounts Payable, Supplier Management and General Ledger modules.
  • Regression testing of all PeopleSoft Accounts Payable functionalities along with sophisticated software customizations implemented to suit the business need of the organization.
  • Designing and testing all the workflow rules for Voucher Approval workflow in PeopleSoft and modifying the existing workflow rules for match exception escalation using AWE workflow as per the business requirements.
  • Functional Support/Integration testing of Oracle PeopleSoft with third-party tools and services - iValua /ProcureOne for PurchaseOrder processing, TCM for secure outbound/inbound file transfer, Falcon for ACH payment processing, Federal Reserve for P&I payment data, Ascent for CRTS Multifamily invoices through Integration Broker and BlackLine for GL Reconciliation.

Environment: Oracle PeopleSoft 9.2 FSCM, People Tools 8.55 (PeopleCode, Application Engine, Component Interface, AWE (Approval Workflow Engine), SQR, Crystal reports, PS Query, Integration Broker), Captiva, Concur, Falcon, Ascent, iValua, SQL Developer and Toad for Oracle 12.8 for Database Management, HP ALM Quality Center and PeopleSoft Test Framework for testing, IBM Rational Clear Quest for defect tracking, JIRA for backlog tracking and project management functions (Kanban/Scrum)

FSCM Modules: Accounts Payable, Purchasing, Asset Management and General Ledger

PeopleSoft Techno Functional Consultant

Confidential, Richmond, VA

Responsibilities:

  • Subject Matter Expert for Accounts Payable, Supplier Management and General Ledger modules.
  • Worked jointly with end-users to identify system inefficiencies, documented technical specifications and assist developers with technical design.
  • Created adhoc queries utilizing SQL, TOAD and PeopleSoft Query to perform data analysis.
  • Involved in various brainstorming sessions with the functional users to discuss the specifications required for PS-Coupa Integration.
  • Created and updated user access per approved access requests including roles and permission lists.
  • Resolved defects to AP custom and delivered definitions that were discovered during system and integration testing by researching causes of problems with online processing.
  • Provided go-live production support to resolve issues identified by users for PeopleSoft-Coupa Integration.
  • Created all deliverables documents from User requirements, Design documents, Test plan, Test scripts and Test Summary report.

Environment: PeopleSoft 9.1 FSCM, People Tools 8.53 , SQL Developer, Version One, SIM, Coupa, Verient, JIRA

FSCM Modules: Accounts Payable, General Ledger and Travel & Expense

PeopleSoft Functional/Business Analyst

Confidential, Parsippany, NJ

Responsibilities:

  • Subject Matter Expert for procure to pay (P2P) and order to cash (O2C) process.
  • Functional support on finance modules - Purchasing, eProcurement, Inventory, Accounts Payable, General Ledger, Commitment Control, Billing, Accounts Receivable, Order Management - dropship orders, multi currency, contracts, Ariba integration, Maximo integration, fulfill orders, lockbox, credit processing, T&L integration with HCM, Siplast/Sealoflex integration to GL.
  • Prepared detailed business process document for procure to pay including business customizations.
  • Coordinated all phases of testing, including test plan creation, data conditioning, script creation, execution and re-testing.
  • Configured chart of accounts, journal source, accounting entry definition, journal templates, credit hold and pay cycle.
  • Coordinated with the user and technical team in identifying and resolving defects in customizations.
  • Utilized IBM Rational ClearQuest for Defect Tracking.
  • Designed and developed automated test scripts in PeopleSoft Test Framework and r eviewing technical test results for completeness.

Environment: PeopleSoft 9.2 FSCM HCM 9.2, People Tools 8.54 , SQL Developer, Microsoft Test Manager, PeopleSoft Test Framework, IBM ClearQuest , Maximo, Ariba, Team Tracker (Release Management)

FSCM Modules: Purchasing, eProcurement, Inventory, Cost Accounting, Accounts Payable, General Ledger, Billing, Commitment Control, Accounts Receivable, Travel and Expense and Order Management

HCM Modules: Payroll for North America and Time and Labor

PeopleSoft Business Analyst

Confidential, Minneapolis, MN

Responsibilities:

  • Subject Matter Expert for Asset Management & Accounts Payable module.
  • Responsible for providing general PS Finance systems subject matter expertise to user and technologies partners.
  • Liaison between business and technologies partners on functional/testing issues.
  • Provided functional support on finance modules - Asset Management, Accounts Payable, Commitment Control and General Ledger - multi-currency and multi-book processing, PSAP integrated with Ariba, VAT processing within PeopleSoft financials, budget validation, nVision/XML reports, Asset Maintenance.
  • Conducted Requirement Gathering sessions with business end users to determine the functional and technical requirements and to estimate the effort levels to complete the deliverables under the scope. Prepared functional/test conditions based on the business requirements.
  • Configured PeopleSoft Test Framework for new terminal servers and trained technology partners on how to use PTF.
  • Configured the Payables according to the global multi-currency requirements.
  • Created Asset Profiles, Asset Categories and configured user defined Depreciation Method, Capitalization Limits in Asset Management.
  • Designed, developed and executed manual scripts and automated scripts using Quality Center and PTF.
  • Supported data cleansing activities - SQL Backend support by creating and running scripts in SQL/PS Query.
  • Performed System thru UAT test execution including validation, documentation and sign off.

Environment: PeopleSoft 9.2 FSCM, People Tools 8.54 , SQL Developer, Toad, HP Quality Center, PeopleSoft Test Framework

FSCM Modules: Asset Management, Accounts Payable, Project Costing, Commitment Control and General Ledger

PeopleSoft Techno Functional Consultant

Confidential, New Jersey

Responsibilities:

  • Implemented and identified changes in PeopleCode for various validations as required by the business process.
  • Designed, developed and implemented various conversion/interface programs - Extracting data from Oracle Applications, designing the Flat File Layout by conducting Field Mapping, developing Fields, Record Definitions, Pages, Sub Pages and Components based on the business requirements.
  • Performed fit gap analysis with the client to gain understanding of the current business process and recommending applicable PeopleSoft solutions based on decisions and discussions with upper management.
  • Involved in setting up PeopleSoft tables.
  • Worked closely with customers for open issues and project prioritization.
  • Provided primary support for eProcurement, Purchasing, Inventory and Asset Management modules - Production issues/ Bug fixes.
  • Troubleshoot new GL Interface file and reporting (nVision/Crystal) issues.
  • Customized many pages related to Time and Labor, NA Payroll and Expense modules.
  • Extensively used SQL and PL/SQL for creating stored procedure and Database Triggers.
  • Created views on major tables as per the client requirement.
  • Have been involved in building and deployment of the applications by using build tools like STAT.
  • Coordinated with several users/oracle teams for PeopleSoft bugs/ Production issues.

Environment: PeopleSoft 9.1 FSCM HCM 9.1, People Tools 8.53 , STAT, SQL Developer Tool & Oracle 10g Database

FSCM Modules: Purchasing, eProcurement, Inventory and Asset Management

HCM Modules: Payroll for North America, Absence Management and Time and Labor

PeopleSoft Functional Analyst

Confidential, New York

Responsibilities:

  • Worked with customers to identify and implement best business process improvements.
  • Responsible for analyzing and validating data from various PeopleSoft third party systems.
  • Created ad-hoc user reports using BI Publisher.
  • Involved in resolving several data issues as a part of production support by creating and running scripts in SQL/PS Query.
  • Provided Production support for PeopleSoft finance modules (Accounts Payable, Accounts Receivable, Cash Management, General Ledger and Billing)
  • Resolved production issues in AP, GL mainly in Pay cycle and Journal generator process.
  • Provided support for ChartField maintenance - Configure ChartField values/Combo Edits.
  • Troubleshot issues related to new GL Interface file, reporting and automatic/manual bank reconciliation. Applied PeopleSoft Trace in process definitions, ran, analyzed and debugged the trace files.
  • Defined Permission Lists, Roles and assigned appropriate roles to user profiles to allow authorized access to view/update data as a part of PeopleSoft Security support.
  • Utilized IBM Rational ClearQuest for Defect Tracking.
  • Coordinated Offshore-Onsite team activities.

Environment: PeopleSoft 9.1 FSCM, People Tools 8.53 , IBM ClearQuest , SQL Developer Tool & Oracle 10g Database

FSCM Modules: Accounts Payable, General Ledger, Billing, Accounts Receivable and Cash Management

PeopleSoft Functional/Business Analyst

Confidential, California

Responsibilities:

  • Functional/Test Lead for PeopleSoft Upgrade from 8.9 to 9.1.
  • Identified over 1000 test conditions from the existing test scenarios to create test scripts for performing system integration and user acceptance test for PeopleSoft system upgrade.
  • Identified and developed test scripts for custom and delivered functionalities and processes in Asset Management, Lease Administration, Inventory, Purchasing and eProcurement modules.
  • Identified and developed test cases for deferred defects in 8.9 which are relevant to the Business process and executed various test cases for integration between PS and 3rd party applications using Application Engine, Excel-To-CI and Integration Broker.
  • Designed, developed and executed automated test scripts in PeopleSoft Test Framework.
  • Performed Requirements Traceability Matrix/Test Coverage for the upgrade.
  • Coordinated and assisted Users during UAT testing for Asset Management customizations.
  • Worked in all phases of test cycle including test estimation, test planning, test designing, scripting, execution and identifying/ reporting defects.
  • Conducted internal review for all deliverables of peers starting from test estimates/analysis phase to test closure.
  • Prepared user-testing and materials for finance modules.

Environment: PeopleSoft 8.9/9.1 FSCM, People Tools 8.48/8.53 , HP Quality Center, SQL Developer (Tools) & Oracle 10g (Database), PeopleSoft Test Framework

FSCM Modules: Asset Management, Lease Administration, eProcurement, Purchasing, Inventory, Commitment Control, Billing, Accounts Payable and General Ledger

PeopleSoft Test Analyst

Confidential, California

Responsibilities:

  • Responsible for Test Requirements, Test Design, Test Scripts and Test plan preparation based on the Functional Specification, Technical Specification and Solution Design documents.
  • Worked closely with business/functional users for gathering test requirements on the enhancements identified and provided Estimation based on the complexity of testing and prepared Test documentation as per client standards.
  • Tested Service Requests/Track work (Roll out in a new region across the organization)/ Enhancements related to Asset Management, Lease Administration, Billing, Accounts Payable, eProcurement and Purchasing Modules.
  • Developed and executed various test cases for interface programs between PS and non-PS (Mainframe, ARCHIBUS, AMCO, VERTEX etc) applications using Application Engine, Excel-To-CI and Integration Broker and also End to End and Regression test cycles.
  • Interacted with the end users while performing the Acceptance testing and trained them in the new functionality whenever a new build was developed.
  • Designated Subject Matter Expert Offshore based on my functional knowledge demonstrated in Asset Management module.
  • Presented ‘Offshore’ Understanding of major customizations to clients and improved client confidence to allocate competitive work involving complex architecture to offshore.
  • Organized and provided internal knowledge transfer to all peers for every project deliverable completed successfully and prepared Weekly Status Report for project deliverables.

Environment: PeopleSoft 8.9 FSCM, People Tools 8.48 , HP Quality Center, SQL Developer (Tools) & Oracle 10g (Database)

FSCM Modules: eProcurement, Purchasing, Inventory, Asset Management, Lease Administration, Commitment Control, Billing, Accounts Payable and General Ledger

PeopleSoft Functional Tester

Confidential, California

Responsibilities:

  • Responsible for creating and executing test cases for various functionalities of different PS Financial and Supply Chain Management modules (Asset Management, Lease Administration, eProcurement, Purchasing, Inventory, Accounts Paya ble, Billing and General Ledger).
  • Executed Interface using Application Engine, Excel-To-CI and Integration Broker, Integration, System, Security, End to End and Regression test cycles.
  • Created and executed test cases for various delivered and customized functionalities in Asset Management module (Asset Creation/ Disposal, Depreciation, Asset Adjustments, Re-categorizations and Transfers, Retired and Reinstated assets etc)
  • Executed and coordinated with clients for Legacy files (Mainframe) End to End testing. Tested jobs in Mainframe and transferred output file securely from remote server to client’s server using WinSCP.
  • Tested End to End Processes for Purchasing, eProcurement, Inventory, Asset Management, Lease Administration, Billing and Payables i.e. Procure to Pay, Replenishment to Purchase Orders, Requisition to Asset creation, Leases to Billing.
  • Interacted with Subject Matter Experts to identify the scope of testing, share analysis results and confirm scope of testing.
  • Defects are logged and tracked in HP Quality Center.

Environment: PeopleSoft 8.9 FSCM, People Tools 8.48 , HP Quality Center, SQL Developer (Tools) & Oracle 10g (Database)

FSCM Modules: Asset Management, Lease Administration, eProcurement, Purchasing, Inventory, Commitment Control, Billing, Accounts Payable and General Ledger

Hire Now