We provide IT Staff Augmentation Services!

Peoplesoft Technical Consultant, Functional Consultant, Developer, Trainer And Business Analyst Resume

3.00/5 (Submit Your Rating)

Parsippany, NJ

SUMMARY:

  • 23 years with PeopleSoft consulting for Implementation, Upgrade, Application Design, Testing, Development, Reports, Interfaces, Providing Resolutions, Analytics, Project Management,, and Production Support
  • Order to Cash, Supply Chain, Billing, Contracts, Accounts Receivable, Accounts Payable, Cost Accounting (Goods Received not billed), Vendors, Customers, Order/Credit, OM Pricing, Buying Agreements, Purchasing (Contracts, Requisitions, Receipts, Drop Ship Orders), General Ledger, Travel and Expense, Asset Management (depreciation), Commitment Control, Project Costing, Inventory, Payroll, FSCM, HCM, and Commitment Accounting
  • Batch Processing, Process Schedulers, PeopleTools, Security, Component Interface, PeopleCode, Application Engine, Workflow, PeopleSoft Upgrades, SQR, Query/Crystal Reports, People Code, Application Designer, Application Engine, Component Interface, PS Security, Process Scheduler, PS/Query, Data Mover, Import Manager, Integration Broker, Process Monitor, Application Package, Workflow, Utilities (SQL Trace and People Code trace), SQR/SQC, Crystal Reports and nVision, Upgrade Assistant, Data Mover
  • Setup and configured one instance of database per business requirements creating business units, transactions, vendors, customers different for each individual trainee allowing trainees to perform tasks simultaneously during for AP, AR, BI, Inv, Order, PO
  • Trained IT staff in development and support business for BI, AP, AR, GL, PO, Order Management, Inventory, T&E
  • Developed process, page and reports page to manage cost accounting’s Goods Received Not billed for material and freight costs creating appropriate accounting per business requirements
  • Loaded GL accounting balances for implementation and for acquisitions
  • Loaded AR and customers open transactions for implementations and acquisitions
  • Loaded Open PO Contracts and Open Purchase Orders for implementations and acquisitions
  • Loaded Open AP vouchers for implementations and acquisitions
  • Loaded Inventory Items for implementations and acquisitions
  • Customized PS purchase orders to meet business requirements
  • Designed and developed PS billing invoices by working with business to meet requirements
  • Created functional design documents, created testing scripts, executed test scripts related to BI, AR, AP, PO, Inventory, Cost Accounting
  • Expert on Root Cause Analysis (RCA) and defect resolution with development of solution
  • Performed Fit Gap Analysis and designed and developed resolutions
  • Implemented security with Roles, Permission Lists, User Profiles, Portal Security, Folders, Content s and Definition Security
  • Debugging and performance tuning of processes, SQL trace, and Application Engine trace
  • Efficient custom application engines and SQRs for data conversion with validations from legacy to PeopleSoft records
  • Data Cleansing, Data Profiling and Data analysis
  • Implementation full Life - Cycle of PeopleSoft modules, BI, AP, AR, GL, PO, Order Management, Inventory
  • Designed/development per business requirements interfaces with legacy and third-party systems
  • Created interfaces between AP/AR and banks
  • Applied changes and implemented HR Payroll Tax updates
  • Created interfaces to/from Maximo asset software with PeopleSoft AP for vendors and payments
  • Created interfaces to/from FileBridge by Access AP cloud software with PeopleSoft including PO’s and payments
  • Developed Approval Workflow Process for transactions and data entry
  • Developed interfaces between PeopleSoft instances for dropships, orders, cost accounting and GL
  • Supported the IT and Finance team with GL Year End Close activities
  • Designed and configured the financial statements using nVision
  • Modified Available to Promise (ATP) to include what is currently on PO schedule
  • Modified customer and vendor pages to add user requirements for data entry
  • Customized 1099 pages for data entry and reporting
  • Developed automated AP payments for drop ship orders with consigned inventory
  • Modified AP Crystal check per user requirements including different logo printed for each company
  • Configured chartfield GL combination edits and added custom edits in AP/PO modules based on item and company
  • Modified billing creation capturing statistical code info for billing invoices from the orders, dropship and shipping details
  • Created 500+ PS queries per business requirements for modules AM, AP, AR, BI, GL, OM, PO, Cost Accounting, Inventory
  • Created or modified 200+ SQRs
  • Developed interface to custom OLAP cube reporting for purchasing
  • Setup and support business with AP Paycycle processing
  • Setup and RCA (Root Cause Analysis) for Integration Broker
  • Modified GL detail reports to include information from specific information from modules
  • Developed upgrade plans, executed and reviewed Compare Reports, applied Upgrade/Change Application steps, fixes and patches for the upgrade process, and performed production test moves
  • Prepared Business Requirement Document (BRD), Change Request (CR), As-Is, To-Be, Technical Design Document (TDD), Unit Test Plan (UTP), Defect Tracking, Effort Estimation, Issue Logs, IT team member reviews, and Status Reports
  • Code review and audit of systems
  • Expert on SetId and Table Set tables configuration and multi business units for each module
  • Configured GL, AP, PO, BI, AR, OM business units for implementation and acquisitions
  • PeopleSoft Order Management pricing setup, price lists, buying agreements with discounts and appropriate accounting
  • Expert on comparing PeopleSoft’s level defaulting/override logic for transactions and comparing to business needs (Fit Gap)

SKILL:

ERP: FSCM, PeopleSoft Financials v5-v9, HRMS v6-v8

Functional Modules: Financials - AP, GL, BI, AR, AM, PC, PO, OM, Inventory, Supply Chain, T&E, Payroll, Commitment Control, Cost Accounting AMAPARBICAGLINOMPCPO

People Tools v6 - v.8.54: Application Designer, Process Scheduler, Process Monitor, Data Mover, Workflow, People Code, PS/Query

Integration Tools: Component Interface, Application Messaging, File Layout, Application Engine, Integration Broker

Reporting: SQR, Crystal Reports, PS/Query, XML Publisher, nVision

Operating Systems: DOS, Windows 9x/NT/2000 Server/XP

Languages: SQL, PL/SQL, VB 6.0

Web Technologies: HTML, XHTML, XML, Web Services

Databases: Oracle, SQL Server, Sybase, Microsoft Access, MySQL

RDBMS Tools: SQL plus, TOAD, Query Analyzer

Other: Word, Excel, Visio, Power Point

PEOPLESOFT PROFESSIONAL:

Confidential, Parsippany, NJ

PeopleSoft Technical Consultant, Functional Consultant, Developer, Trainer and Business Analyst

Responsibilities:

  • Analyzed company and implemented PS role based security and loaded users
  • Multi PS instances and each instance had multi businesses with multi countries
  • Designed and developed specific multi AR business unit for users based on analysis of the business
  • Modified AR for new acquired companies to meet their specifications
  • Modified AR Credit to meet business needs to allow them to easily monitor and assess credit
  • Enhanced and develop PS Order (AR) credit approval process providing the business with a “review” condition as well as changes to pages for the credit mangers so that orders were not “held up” by the credit analysis
  • Designed with business and develop billing invoices to meet the needs of the companies
  • Modified build invoice application engines to capture invoice statistical data for Sales and Financial Analysis
  • Developed interfaces from banks to match payment information with payment predictor to invoices in AR allowing the system to match the payments to invoices in AR without user intervention
  • Loaded customers into the customer master for implementation as well as for acquisitions
  • Loaded inventory items into the item master for implementation as well as for acquisitions
  • Supported billing, Accounts Receivable, Accounts payment, Order Management, Purchasing, Asset Management, General Ledger, Cost Accounting, Project Costing while working on development needs
  • Developed and designed interface to FileBridge that allowed vendors invoices to be matched with POs and receipts
  • Developed interface from FileBridge of matched vndr and freight vndrs invoices to be loaded into PS AP vouchers and paid
  • Modified AP voucher pages for business for example FileBridge information to quickly tie PS AP voucher to FileBridge
  • Analyzed and developed interfaces to/from banks for vendor AP payments and payment verification
  • Loaded assets into PS AM with proper depreciation and GL accounting for implementation and acquisitions
  • Modified pages of customer master to include meet business specifications and for streamlined data entry
  • Meet with business for AR, Billing, Purchasing, Sales, Plants, and General ledger on a quarterly basses to review support tickets and prioritized development
  • Modified PS Order Management Credit Check to meet business needs for example included a status that would not stop the order but notify the business to do quick review of credit of the customer
  • Reconciled modules accounting with the general ledger for example the amount of receivables in AR for each company should match a specific chartfield combination in GL as well as depreciation in AM should match GL
  • Modified purchase order to meet business needs for example in roofing both bundles and squares needs to be listed on PO for roofing material
  • Setup GL combination edit rules, groups, and trees (combo data tbl) to capture incorrect chartfield combinations as well as change for acquisitions and added for business needs and subsystems AM, PO, AP, AR, Project Costing
  • Loaded GL journal transactions from acquisition balances and third party software like Maximo
  • Developed GL jrnl interfaces between three PeopleSoft instances, one instance had all GL jrnl transactions for reporting
  • Developed interunit costing for dropship items when the different inventory business units existed in different PS instances
  • Modified purchasing and AP to stop incorrect chartfield combinations for specific items so that the incorrect combination could not be on an approved PO or AP voucher
  • Created PS Queries for users so that they can quick check the data
  • Created application engine to create nVision reports for Cost Accounting
  • Created application engine to run processes in streamlined sequence and avoid data conflicts
  • Developed SQL scripts that would catch database data errors until a permanent fix was applied
  • Setup workflow for AP voucher and Purchase Order Approvals
  • Loaded vendors for implementation and acquisitions
  • Analyzed customer created a report for business looking for duplicates and inactive customers to be set to inactive
  • Developed Electronic Data Interface (EDI) for Advanced Shipping Receipts and PO Acknowledgment
  • Setup Personal Data, Accounting Entry Templates, Freight Terms, Reason Codes, Ship Via Codes, Ship to Locations, Units of Measure, Tax percentages for SUT and USE
  • Configured Integration Broker asynchronous messaging with SAP Ariba Procurement

Confidential, NC

Project Manager, PeopleSoft Technical Consultant, Functional Consultant, Developer, Trainer and Business Analyst

Responsibilities:

  • Developed Privilege License that could only be printed if the corresponding customer invoice was paid
  • Applied payroll updates
  • Loaded inventory for utilities
  • Trained, documented steps, and supported users for utilities cycle and physical counts
  • Modified purchase order to meet City’s requirements
  • Trained staff on purchasing including requisitions and purchase orders
  • Trained staff on PS commitment control accounting
  • Trained staff on processing vendor’s invoices with voucher and matching
  • Created reports for pre-cumbrances and encumbrances per business requirements to manage funds
  • Maintained combination edits
  • Created SQR financial reports
  • Applied updates to Financials and HRMS
  • Loaded and maintained users and their role security
  • Setup workflow approvals for requisitions and purchase orders

Confidential, Austin, TX

Assistant Project Manager, PeopleSoft Technical Consultant, Functional Consultant, Developer, Trainer and Business Analyst

Responsibilities:

  • Analyzed comptroller business designing PS multi-business unit environment
  • Trained functional and IT staff in PS purchasing commitment control accounting, pre-encumbrance and encumbrance
  • Modified purchase order SQR to meet business needs
  • Developed PS queries for requisitions (pre-encumbrances) for users to review by fund
  • Supported and help train TEA, Texas Agency, implementation of Financials 6.5
  • Setup and supported combination edits
  • Designed specifications to load assets
  • Trained staff on voucher and payment processing

We'd love your feedback!