Peoplesoft Consultant/business Analyst Resume
Aurora, IL
OBJECTIVE:
Over 6+ years of experience as a PeopleSoft Financials/ SCM, HCM Techno - Functional Consultant. Experience in wide range of PeopleSoft Financials modules including Accounts Payable, Accounts Receivable, e- procurement, Asset management, Purchasing, Billing, General Ledger, Strategic Sourcing, Inventory, Cash Management, job cost Project Costing, e-supplier.
PROFESSIONAL SUMMARY:
- 6+ years of PeopleSoft FSCM Consultant/Business Analyst experience in PO, Purchasing, eProcurement, EDI, Order Management, Inventory, Accounts Payable, General Ledger, Accounts Receivable, Billing, Project Costing.
- Handled worldwide support, develop, trouble shoot of whole suits of PeopleSoft Financial and Supply Chain, which includes GL, AR, AP, Purchasing, eProcurement, Inventory, OM and BI for 8 different business entities from v.8.9., v.9.0, v.9.1, v.9.2.
- Working on PeopleSoft FSCM upgrade from 9.0 to 9.2 and providing technical development support to PeopleSoft HCM 9.1 and Worked on the implemented of payroll solutions with PeopleSoft Payroll and done strategic planning for payroll operations and initiatives for the client.
- Handled worldwide support, develop, trouble shoot of whole suits of PeopleSoft Financial and Supply Chain, which includes GL, AR, AP, Purchasing, eProcurement, Inventory, OM and BI for 8 different business entities from v.8.4, v.8.7, v.8.9. v.9.0.
- Experience in business-related project milestones such as in Requirements Gathering, Data Modeling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.
- Experience in PeopleSoft Financials 9.1/9.0/8.0 and used Application Designer, UNIX shell scripting, HTML/DHTML, People Code, SQR, Application Engine, Application Package, Crystal Reports, Integration Broker, Component Interface, JavaScript and Oracle (creation of complex SQL, Query optimization, creating database triggers, creation packages and procedures) from version 10/11g.
- Involved in design, development and testing of PeopleSoft modules General Ledger, Accounts Payable, Purchasing, eProcurement, e-Supplier, Strategic Sourcing, Asset Management, Account Receivables, Billing, Inventory and Order Management.
- Major project converting Data from Peoplesoft into EBS and worked closely with the business customers to create new customized BI dashboards.
- Involved in Fit-Gap analysis for PeopleSoft 8.9 to 9.2 Upgrade for HR, Benefits, Ben-Admin, Payroll, Security, ESS, MSS, e-Benefit, ELM and Pension Management.
- Expertise in all phases of the System Development Life Cycle including Requirements Definition, Data Conversion and System Implementation.
- Worked in FSCM module like Project Costing, Purchasing, Accounts Payable, Suppliers, Billing and Travel and Expense .
- Setup integration between CRM & FSCM using delivered EIP. Performed full data load as well as incremental sync. Proficient in administering Jobs in Process Scheduler
- Extensive knowledge of FSCM functional skills includes supply chain Procure to Pay and Order to Cash life cycles.
- Experience working with Tableau, Power BI to bring out meaningful data analysis, dashboard and reporting using FSCM and HCM customer data.
- Worked in Application upgrade from PeopleSoft 9.0 to 9.1 and People Tools upgrade from 8.50 to 8.54. Designed performance tuning for several Application Engine programs and SQRs in Account Payables (AP) Module.
- Worked closely with Business users in capturing requirements and creating Functional Design documents (BRD & FRD) and designing Technical Documents based on FRD.
- Worked on FSCM to identify the changes and enhancements done in AP, PO, e-Procurement, AR and Billing modules. Multiple projects and versions of PeopleSoft Financial modules moving to a single Instance of PeopleSoft FSCM 9.1.
- Advanced knowledge and experience which includes End-End Implementation, Upgrade, Legacy to PeopleSoft Conversion, Integration between PeopleSoft Finance and third-party system, Customization- Enhancement and Production Support in various PeopleSoft Financial ( FSCM ) applications.
TECHNICAL SKILLS
ERP Packages: Peoplesoft FSCM 9.2 & PUM 23, FSCM 9.1 and CRM 8.9.
Development Tools: Application Designer, People-code, application packages, application engine and approval workflow engine (AWE), fluid interface and portal.
Integration tools: Component interface and integration broker, file layout, excel to ci and application extension framework (AXF) 12c.
Reporting Tools: SQR, PS Query, XML publisher or BI publisher, n-vision, pivot grids, crystal reports and tree manager.
Administration tools: data mover, security administration, process scheduler, change assistant, PeopleSoft test framework (ptf) and phire.
FSCM Modules: Account Payable, account receivable, purchasing, inventory, general ledger, commitment control, travel and expenses, e-procurement, service procurement, strategic sourcing, billing, supplier contracts, project costing, deal management, cash management and cost management.
Operating Systems: Windows 10, 8, 7, XP, pro/2000/nt and UNIX.
Languages: C, C++, Java, SQL, PL/SQL, JCL, HTML and Excel Macros.
Databases: Oracle 12c, 11g, 10g, MS Access.
PROFESSIONAL EXPERIENCE
Confidential - Aurora, IL
Peoplesoft Consultant/Business Analyst
Roles and Responsibilities:
- Involved in requirements gathering, technical/functional design and testing file layouts for interfaces and Application Engine programs in AP, eProcurement, Purchasing and General Ledger modules.
- Worked on PeopleSoft FSCM upgrade from 9.1 to 9.2 as well and performed Production Support, enhancements and customizations of PeopleSoft FSCM 9.2. Configured Requisition, Purchasing, Payable, Project & Billing business unit in PeopleSoft FSCM system.
- Excellent knowledge of PeopleSoft Financials 9.2 modules, including Account Payables, General Ledger, Purchasing, ELM, Accounts Receivables, Billing, Inventory, Order Management, Asset Management, Project Costing modules as Functional Analyst .
- Involved in the production support for PeopleSoft General Ledger, AR, AP, eProcurement, AM, purchasing modules and had resolved issues and improved business process efficiency.
- Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM (PO, Inventory, e-Pro, BI, GL, AP, AR) Assisted in streamlining the SCM process as per requirements and anticipated deliverables.
- Handled worldwide support, develop, trouble shoot of whole suits of PeopleSoft Financial and Supply Chain, which includes GL, AR, AP, Purchasing, ELM, eProcurement, Inventory, OM and BI for 8 different business entities from v.8.9. v.9.0.
- Tested End to End Processes for Purchasing, eProcurement, ELM, Inventory, Asset Management, Lease Administration, Billing and Payables i.e. Procure to Pay, Replenishment to Purchase Orders, Requisition to Asset creation, Leases to Billing .
- Worked in PeopleSoft Finance modules like GL, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing.
- Trained State employees in Accounts Payable, Fixed Asset, Cash Management, Job Cost, Procure-to-Pay, Absence Management, voucher creation by testing various audit setup configuration scenarios.
- Worked on FSCM issue/tickets related to purchasing, Account Payable and General Ledger module. Field to Field mapping from Legacy Systems GP, MCF to Peoplesoft .
- Implemented multiple Interfaces to send and receive AM, PC an AP related data to and from various Intra-Company Groups. Egg: AM and PC accounting and transaction data to Tax group, AP Vendor data to Vendor Management group, AP data to SCM group, Pasay Interface files to Banks, Recon File consumption from Banks, etc.
- Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL.
- Created Research to billing custom interface during FSCM 9.2 upgrade and created Test Strategy for PeopleSoft 9.2 Upgrade.
- Provided subject matter expertise guidance for PeopleSoft SCM (OM, Inventory) existing functional and technical usage and additional customization recommendations for various strategic project needs.
- Supported Journal Generator process issues to format and distribute journals to GL in PeopleSoft Purchasing and Payables modules.
- Worked in PeopleSoft Finance modules like GL, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing.
- Developed XML Publisher Reports in 9.1 New Billing Invoices Templates, worked on order management, Billing, AR & Inventory including order to cash (OTC).
- Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL.
- Working on the development and realization of project plan for implementation of PeopleSoft Billing, General Ledger and Receivables.
- Working on the Inventory, General Ledger and Commitment Accounting with analytical and reconciliation skills for the project.
- Involved in Bank Reconciliation setup across AP, Cash Management and Treasury and setup & Troubleshooting AP, PO & Cash Management.
- Resolved build defects and implemented change requests, utilizing agile methods, for Asset Management, Billing, Contracts, Expenses, General Ledger, Payables, Project Costing, and Purchasing and Receivable PeopleSoft modules.
Confidential - McLean, VA
PeopleSoft Business Analyst
Roles and Responsibilities:
- Worked on FSCM to identify the changes and enhancements done in AP, PO, e-Procurement, AR and Billing modules.
- Researched the released notes for FSCM to identify the changes and enhancements done in AP, PO, AR and Billing modules.
- Worked as a business analyst overseeing all the FSCM modules - e-Pro, PO, AP, AM, PC, KK, GL, CM, travel and expenses (including mobile implementation) and Supplier Contracts.
- Upgraded PeopleSoft from FSCM 8.9 to 9.1. Worked on several reports relating to FSCM module sap, AR, PO, IN and GL relating to aging, vendors, matching, Stock Status and payments.
- Provided primary support to PeopleSoft Accounts Payable Provide secondary support to PeopleSoft Asset Management, General Ledger and SCM .
- Worked on several reports relating to FSCM modules AP, AR, PO, IN and GL relating to aging, vendors, matching, Stock Status and payments.\
- Performed research and study of the existing system tables and business processes. Also involved in the in- depth study of the customizations made in the GL, AP, AR, PO, INV modules.
- Applied customizations to online objects (Lease Management, Requisition Management, Purchasing, GL, Billing), converted custom Crystal reports to BI Publisher, applied Crystal customizations in 9.2 App Engines or BI Publisher such as Positive Pay, Cheque with Advice, AR & PO reports, etc.
- Designed and Developed Several Custom interfaces to AR, BI, PO, AM, Commitment Control, Inventory, AP and GL Modules.
- Implemented new PeopleSoft Financial Systems modules (Grants Travel and Expense, Receivables, Billing, Project Costing, Asset Management).
- Involved in testing the two independent workflows have been setup for two different business units in approval workflow for Purchase Orders and Requisitions.
- Research and evaluate business process, procedures and requirements as it relates to benefits utilization of PeopleSoft 9.1.
- Validated North American Payroll, Commitment Accounting/Labor Accounting, Time and Labor, Benefits Inbounds Out bounds data for On-cycle/off-cycle for Bi -weekly pay frequency.
- Work with the end users to resolve issues with contract activation, initial grants billing and amount allocation for amount-based contract lines.
- Worked as PeopleSoft Application Developer on Application Designer, Application Engines, People Code, XML Publisher, Page Designing, and Excel to CI, PS Query, Data mover, Component Interface and SQR.
- Added much efficiency to the delivered upgrade scripts and steps. These conversions involved multiple software applications (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, and Fixed Assets) across many databases.
- Implemented new PeopleSoft Financial Systems modules (Grants Travel and Expense, Receivables, Billing, Project Costing, Asset Management).
- Performed implementation related setup for PeopleSoft Accounts Payable, Cash Management, Treasury and Purchasing.
- Involved in the process of identifying the PeopleSoft Definitions used in the existing PeopleSoft HCM 8.8 application that will be impacted during upgrade process and documented the same
- Consulted FSCM team on best practices to implement Security Re-design and User Provisioning project ( FSCM 9.0), Served as lead PeopleSoft consultant for FSCM modules to assess the impact of COA changes
- Develop enhancements and customizations for FSCM modules include AWE using People Tools Components, Pages, Records, Menus, Folders and Nodes according to technical specifications.
- Worked on the General Ledger trial balance loads to Hyperion Enterprise from foreign and domestic GL 's using Microsoft Access.
- Worked on AP module and Customized the Journal Entry page, People Code in GL to store certain custom information. Customized the Ledger Inquiry and Journal Inquiry pages.
Confidential - San Francisco, CA
PeopleSoft Consultant/ Business Analyst
Roles and Responsibilities:
- Working on PeopleSoft FSCM upgrade from 9.0 to 9.2 and providing technical development support to PeopleSoft HCM 9.1 and Worked on the implemented of payroll solutions with PeopleSoft Payroll and done strategic planning for payroll operations and initiatives for the client.
- Designed and developed Commitment Account rules. Created Workflows for Long-term retro in Commitment Accounting. Created new IB Interfaces.
- Working on creating configuration architecture for PeopleSoft Billing, General Ledger and Receivables based on clients' requirements and expectations and Working on User acceptance testing for successful implementation of PeopleSoft project costing & vendor management system.
- Created Research to billing custom interface during FSCM 9.2 upgrade and created Test Strategy for PeopleSoft 9.2 Upgrade involved in creating reporting systems that identifies discrepancies between GL and payroll and worked on applying Tools patches and fixes for FSCM 9.2 application.
- Working on the development and realization of project plan for implementation of People-Soft Billing, General Ledger and Receivables and Working on the Inventory, General Ledger and Commitment Accounting with analytical and reconciliation skills for the project.
- Working on the budgets and expenses in PeopleSoft Financials, and specifically Commitment Control, Projects, and Grants and Coordinated the development effort, created custom programs, and managed the projects for the HR, Payroll and Finance groups.
- Involved in Bank Reconciliation setup across AP, Cash Management and Treasury and setup & Troubleshooting AP, PO & Cash Management and Analyzed, documented and advised commitment accounting, payroll regarding tax updates, and applied patches, and Tax updates.
- Conducted and assisted with FMS 9.2 training eProcurement, Purchasing, Inventory, Grants Management, General Ledger, Accounts Payable, Asset Management and Project Costing.
- Resolved build defects and implemented change requests, utilizing agile methods, for Asset Management, Billing, Contracts, Expenses, General Ledger, Payables, Project Costing, and Purchasing and Receivable PeopleSoft modules.
- Performed requirement gathering & analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
- Worked on primary contact for all production support related issues in FSCM system. Worked on project costing and technology cost allocations experience with strong project management skills.
- Responsible for PeopleSoft Financials Upgrade from application v9.0 to v9.2 and Applying the patches from PeopleSoft Financials 92 Image 02, Image 03 and Image 04 using PUM.
- Working with business analyst and senior management for PeopleSoft 9.2 upgrade Test Strategy and Created the Selenium Test Automation Strategy for PeopleSoft 9.2.
- Worked as PeopleSoft Application Developer on Application Designer, Application Engines, People-Code, XML Publisher, Page Designing, and Excel to CI, PS Query, Data mover, Component Interface and SQR.
- Added much efficiency to the delivered upgrade scripts and steps. These conversions involved multiple software applications (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, and Fixed Assets) across many databases.
- Implemented new PeopleSoft Financial Systems modules (Grants Travel and Expense, Receivables, Billing, Project Costing, Asset Management) and Performed implementation related setup for PeopleSoft Accounts Payable, Cash Management, Treasury and Purchasing.
- Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements. Developed Custom PL/SQL Stored Procedures and SQL loader to load Data in FAMIS from PeopleSoft Financial Database
Confidential
Business Analyst
Roles and Responsibilities:
- Drafting and maintaining the business requirements to ensure they are aligned with the technical and functional requirements.
- Developed process, procedures and training materials for the Kronos Cloud Hosted Operations team, this information was shared out to other Organizations and was housed at a central repository to be used for reference.
- Utilized technical ability to create, maintain, and support Kronos WIM Interfaces, advanced Crystal Reports, and stored procedures.
- Create and deliver overview and company specific presentation of Kronos application.
- Plan store labor based on sales forecasting engines, task standards and minimum hours-based labor.
- Involved in logging the Defects and Defect Reporting
- Updating the use cases, test scripts and test cases
- Conducted Test Scenario walkthrough with Onsite/Offshore development team and with Business .
- Assisted Project Management activities with the help of applications like MS Project and WebEx presentations to the Onsite/Offshore team.
- Extensively queried through SQL to check the database records.
- Suggested automation process improvements & engaged in framework enhancements. Code reviews and maintaining deliverable quality.
- Preparing the Deliverables such as Daily Status Reports & Weekly Status Reports.
- Created training material, quick reference guides and conducted training on all phases of the application
- Engaging with Client to gather the functional specifications and business rules.
- Preparation and review of Test Data, Test Scenarios, SIT Test Cases, Unit Test Cases and Reviews.
- Functioned as technical analyst and consultant to implement framework for automation.
- Test Design and Traceability Matrix for Test Coverage for Security Testing and Risk Management in Agile environment.
- Own product features and Manual test them through all possible angles.
- Defect analysis, troubleshooting and reporting.
- Engaged in framework enhancements, code reviews and maintaining deliverable quality.
- Process improvement on QA (Automation & Manual) activities.
- Tracking, managing and reporting the progress on a day to day basis.
- Attending daily Defect Meeting and Onsite/Offshore Handoff Meeting.