We provide IT Staff Augmentation Services!

Senior Functional Consultant Resume

Kansas City, MO

SUMMARY:

  • A seasoned Business Analyst and PeopleSoft Functional Consultant with around 8 years of experience. Worked in various project phases and area starting from Requirements Gathering, Development, Upgrade, Conversion, Testing and Production Support.
  • Have worked in diverse domains of business involving Procure to Pay Modules - eProcurement, Purchasing, Procurement Contracts, eSettlement, Strategic Sourcing, Asset Management, Account Payables, General Ledger and Order to Cash Modules -Order Management, Billing, and Accounts Receivables.
  • Expert experience with People Tools: Application Engine, People Code, Page Design, Database Performance Monitoring and Application Designer, Workflow, PeopleSoft Reporting Tools XML Publisher, PS Query, Connected Queries, SQR and PeopleSoft Integration Tools EXCEL2CI, Component Interface.
  • Strong understanding of Agile and Waterfall SDLC methodologies .
  • Used Application Engine to perform background processing against the data.
  • Created new reports using SQR, XML Publisher and modified the existing ones as per the changes specified.
  • Created and customized SQR reports as per the requirements and scheduled them using Process Scheduler.
  • Experience in Business Requirements gathering, Fit-GAP analysis and writing Functional and Technical Specifications.
  • Expertise in writing PS Queries for creating reports.
  • 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 DQ.
  • Strong analytical skills to convert Functional design specifications into Technical Design specifications.
  • Excellent in problem solving and self-learning attitude and has clear understanding of business procedures and ability to work as an individual and also part of the team.

TECHNICAL SKILL SET:

ERP: PeopleSoft Financials (Account Receivables, Account payables, General Ledger) and Supply Chain Management (Order Management, Procurement Contracts, Purchasing, Strategic Sourcing, eProcurement, Asset management, Billing) 8.9/9.0/9.1/9.2

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, nVision, XML publisher, BI Publisher, QlikView, Tableau, Business Objects

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

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Senior Functional Consultant

Responsibilities:

  • The scope of work for this project is to upgrade their existing PeopleSoft FSCM 9.1 system to Peoplesoft FSCM 9.2 along with implementation of newly added requirements . Retrofit customizations and use any new functionality.
  • Responsible for Fit and Gap Analysis, Business requirement gathering, configuring the system, Designing functional and technical documents and creating Process flows.
  • Performed Initial Pass steps.
  • Worked on Procurement modules - EProcurement, Purchasing, Procurement Contracts, and Strategic Sourcing.
  • Documented new functionalities that are going to be used in the new system.
  • Prepared Configuration Documents using Setup manager for all the procurement modules - Configurations required for the existing features and also the configurations required for new features.
  • Implemented Change Request/Change Order process and Close short process.
  • Worked on setting up Buyer WorkCentre and Dashboards.
  • EProcurement Requisition workflow enhancements implemented.
  • Developed Test Scrips for TM1 and TM2, includes customizations, interfaces, and reports and prepared validation documents for the same.
  • Coordinate with technical team for resolving defects and changes.
  • Worked with Oracle on issues/bugs.
  • Coordinate with users for UAT, Document failures and provide re-testing.
  • Conducted In-class Training for Users on all the Procurement modules.
  • Provide production support for year-end close and all production functional issues.
  • Work with team of Developers and Functional consultants in End-to-End Go-Live Deployment.
  • Performed and validated conversions.

Confidential, Rosemont, Illinois

Environment: PS 9.0

Senior PeopleSoft Consultant

Responsibilities:

  • As part of business requirement (Indirect Spend) Implementing the Indirect Spend Procurement with the Ivalua technology (SAAS) will achieve to automate the AP Source-to-Pay process to limit the manual process and give the better reporting on the spend to operate the business.
  • Design and develop Invoice/Voucher/Vendor integration between IVLAUA PO system and PS Accounts Payable.
  • Gathered requirements from the users and made Design Documents.
  • Discussed Data mapping of Accounts Payable fields for the integration with users.
  • Created Functional Design document with the requirements gathered from user.
  • Created new AP records, pages and components using Application Designer according to the functionality.
  • Developed complex Inbound Interface to populate the AP Voucher tables from XML files.
  • Built a dynamic process for mapping data from XML file into PeopleSoft AP custom tables, which lets us have control over data flowing into the system.
  • Developed a new Application Engine to move data into Confidential Custom AP Voucher tables, which takes care of multiple validations along with custom error handling.
  • Involved in modification and fine-tuning of Application Engine, SQR programs.
  • Developed test cases, Document BR (Business requirements), Perform UAT, Document failures and provide re-testing (PTF).
  • Involved in resolving issues raised during SIT/UAT.
  • Involved in knowledge transfer and training.

Confidential, Greenwood Village, CO

Environment: PS 9.2

Senior Functional Consultant

Responsibilities:

  • Team lead on upgrading FSCM 9.0/9.2.
  • Gathered requirements from users and designing the Functional documents.
  • Configure PeopleSoft system for GL, INV, AR, AP, CM and P2P modules.
  • Designed and configured chart-fields, Modified and customized chart-field labels to suit business.
  • Configured Business Units, Ledgers and Ledger Groups .
  • Configured Journal Sources .
  • Designed and configured combination edits and closing rules .
  • Designed GL Journal approval workflow .
  • Created nVision Balance Sheet reports . Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units.
  • Configured new Allocations including Inter-Unit Allocations.
  • Configured ACH layout, payment source and pay-cycle steps.
  • Designed and configured payment handling codes and payment term timing codes .
  • Designed and configured vendor categories and withholding codes (1099)
  • Designed, configured and tested ACH and check payments.
  • Designed the reconciliation process from start to end in AP module.
  • Designed the dup checking functionality in AP module.
  • Handled technical requirements related to Expenses, Asset Management, Accounts Payable, General Ledger, Purchasing and Project Costing.
  • Developed various reports in PS Query, SQR in various modules like Account Payables, Billing and GL
  • Developed proficiency in Procure to pay business process particularly in Payables.
  • Developed several Queries for the Financial Reporting Purpose in AR, AP, and PO.
  • Worked on modifying the Billing invoice XML reports and created new billing templates for different countries.
  • Created job-aids to run jobs through Mainframe and ESP for other team members and new recruits.
  • Assisted in Fit and Gap Analysis, business requirement gathering, configuring the system, demo, test plans, resource allocation and issue allocation.

Confidential, Kansas City, MO

Environment: PS 9.2

Functional Consultant

Responsibilities:

  • People soft upgrade of Finance 9.1 to Finance 9.2.
  • Gathered requirements from users and designing the Functional documents.
  • Developed various prototypes and interfaces in AP and P2P as per business requirements.
  • Involved in Client Meetings for testing GL data loads based on various sources.
  • Developed a fresh interface for Multi-Currency transactions in AP and GL for customers on the Canadian side of the border.
  • Purchasing and eProcurement sourcing from inventory Business processes implemented.
  • Created a new Interface to migrate the Payment Information from Auto Integrate to PeopleSoft.
  • Worked on allocations/Ledger copy processes from Maestro.
  • EProcurement catalogues designed and implemented for purchasing and inventory items.
  • Created custom job schedules and jobs definitions using Maestro tools.
  • Worked with DBA/PS Admin teams in the process of resolving long running jobs/job schedules from Maestro tool.
  • Worked on production issues occurs on day to day basis and communicated with Business Teams and Users Effectively with updates while resolving issues.
  • Maintenance and Support of PeopleSoft financial applications along with non-production activities in GL module and Project Costing across multiple environments.
  • Involved in Technical Fit Gap Analysis by attending meetings with end user team.
  • Modified existing and wrote new PeopleCode to meet business requirements identified in fit gap analysis.

Confidential

Functional Internship

Responsibilities:

  • Created new records, pages and components using Application Designer according to the functionality.
  • Wrote PeopleCode 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.
  • Involved with Business requirements gathering, Fit and Gap analysis for GL, INV and PO modules.
  • Created new SQR Reports and modified the existing SQR reports Finance in AR, Billing, 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, AR, 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.

Hire Now