Professional

Summary

A Professional with 12 years of experience in information systems, 8 years of PeopleSoft Functional user/analyst and 12 years of accounting experience. Possess excellent project management skills. A responsible professional, who takes initiative and has strong analytical and computer skills.

Technical

Summary

PeopleSoft 8.4, 8.9 and 9.1, PeopleTools 8.48,PeopleSoft Project Costing , Commitment Control, Accounts Receivable, General Ledger, Accounts Payable , Billing, Customer Contracts, Supplier Contracts, Grants, CATI System Athena , Microsoft Access, SQL, Microsoft Project, Microsoft Excel, UNIX, Relational Databases, PeopleSoft nVision, AS400, Oracle 10g, ImagNow, SharePoint, Oracle R12 Procure to Pay, Oracle Discoverer

Experience

Confidential

Present APPLICATION AND DATA ADMINISTRATOR

• Supporting all Supply Chain department's information systems
• Supporting SharePoint, Oracle Financials, ImageNow and IASTA Sourcing
• Developing reports utilizing Oracle Discoverer
• Implementing upgrade to Oracle R12 for iProcurement

Confidential

PROCUREMENT CONSULTANT

Leading the implementation of PeopleSoft 9.0 eProcurement module and PCards for several State agencies

Confidential

PROCUREMENT CONSULTANT

• The creation of scenarios and scripts for system integration testing
• The configuration of Supplier Contract module
• The creation of functional specs for the creation of queries and reports
• The mapping and verification of legacy system data to PeopleSoft 9.1 Supplier Contract module Contracts
• The extensive testing of customizations within the Supplier Contract module

Confidential

PEOPLESOFT FUNCTIONAL ANALYST

• PeopleSoft functional analyst and liaison between finance area and technical staff and consultants. Functional user knowledge of AP, GL, AR, Grants, Projects, Customer Contract, Billing, Commitment Control and Supplier Contract modules.
• Conduct training for accounting staff in the use of Accounts Receivable, Customer Contracts and General Ledger
• Develop training manuals for Grants Management, Accounts Receivable and Revenue Recovery areas which utilize PeopleSoft Grants, Billing, AR and Customer Contract modules
• Participated in UAT for Projects, AR, Grants, Billing, GL and AP
• Configuration of GL, Grants, AR, Projects, Customer Contracts, Billing and Commitment Control and Suppler Contract PeopleSoft modules
• Assumed the role of consultants for State of Indiana's largest agency FSSA after implementation
• Implemented the conversion to PeopleSoft
• Configured various modules of PeopleSoft AR, Grants, Customer Contracts, Billing, Commitment Control, Project Costing, Accounting Rules, Supplier Contracts and Combo Edits, etc.
• Implemented Grants module including conducting training and developing training materials
• Maintenance of accounting rules
• Developed and modified queries utilizing Query Manager
• Developed and modified nVision reports
• Updating mapping tables
• Participated in fit gaps for Projects, Grants and Billing modules
• Developed policy and procedures for Accounts Receivable and Recovery areas
• Subject Matter Expert for customized federal draw process developed within PeopleSoft
• Project lead for Federal grants management utilizing a customization of PeopleSoft Grants module
• Solved GL issues related to journals and commitment control issues
• Recorded and solved Altiris help desk generated tickets

ACCOUNTANT

• Managed four accountants and five clerical staff members of the Accounts Receivable and Federal Funding Finance areas
• Responsible for receiving, tracking and reporting of all federal grants
• Reconciliation of general ledger and bank accounts
• Responsible for all wire transactions and banking transactions for State agency
• Administrator of internally developed Accounts Receivable system
• Administrator of internally developed Federal grants draw system
• Administrator of internally developed Recovery system
• Ad hoc reporting from internally developed systems
• Prepared and submitted Federal quarterly and annual reports 209, 272 and A133
• Calculated average number of check clearance pattern days CCP days for federal draws
• Managed the drawing of federal funds and performed grants management
• Development of Access transactional database for the tracking of outstanding Child Support checks
• Reconciled General Ledger and bank account

ACCOUNTANT

• Responsible for accounts payable, billing, updating billing databases, journal entries and reconciling general ledger accounts and bank statement utilizing PeopleSoft 8.4
• Processed Accounts Payable through pay cycle within PeopleSoft 8.4
• Developed and modified queries utilizing Query Manager
• Developed summary Excel spreadsheets using PeopleSoft query data
• Performed General Ledger journal entries
• Reconciliation of General ledger and bank account within PeopleSoft 8.4
• Verified other employees AP vouchers for accuracy
• Processed and updated billing within mainframe environment for telecommunication services
• Developed Access database for tracking telecommunication and data services billing to all State of Indiana agencies

Confidential

PROGRAMMER

• Responsible for creating databases using industry specific software and writing programs for market research surveys utilizing industry specific software in a UNIX environment
• Programmed and modified market research surveys for telephone interviewing utilizing CATI Athena software based on client specifications
• Developed and modified web-based market research surveys
• Created data output files based on data collection from the CATI programs developed
• Exercised good time management to assure multiple projects were completed simultaneously and on schedule
• Consistently reviewed programming against specifications to ensure data integrity for analysis

Confidential

BUDGET/CONTRACT SPECIALIST

• Responsible for reporting utilizing Access database and Excel spreadsheets, purchasing all Information Systems Department equipment, contract administration, budget preparation and accounts payable
• Purchased information technology equipment and services
• Developed Access transaction database to track purchase orders and balances
• Developed Excel spreadsheets to record budget transactions for IT area of college
• Prepared and negotiated contracts with vendors in preparation for budgeting process
• Processed invoices, purchase orders and credit memos for Accounts Payable area
• Developed annual budgets and capital budgets
• Developed monthly management reports for IT area expenditures and capital budget

Confidential

SUPPLY COORDINATOR

• Responsible for creating an inventory system using Access and Excel, purchasing all Medical and Office supplies for hospital, accounts payable, and contract negotiations
• Utilized purchasing contract group to assure supplies were obtained at the most competitive prices
• Performed inventory management for all hospital supplies and equipment
• Created purchase orders and matched to vendor invoices
• Developed spreadsheets to perform quarterly inventory and provide billing information to insurance companies
• Billed hospital patients utilizing an internal system within a AS400 environment
• Reduced purchasing costs by negotiating a just-in-time delivery contract with a new vendor

Confidential

OFFICE MANAGER

• Responsible for full-charge bookkeeping, payroll, budget preparation and administrative functions
• Supervised four clerical staff
• Recorded all transactions using QuickBooks
• Prepared payroll, cut payroll checks, completed and filed quarterly federal payroll reports
• Prepared monthly financial reports and presented to board of directors
• Prepared annual budgets and requested federal dollars from the Department of Education
• Prepared ad hoc financial reports for clients and management
• Management of the building, grounds, and personnel issues

Confidential

CSR TECHNICIAN/ACCOUNTS PAYABLE

• Responsible for purchasing, accounts payable and inventory management for surgical area
• Purchased medical supplies for surgery center
• Performed inventory management of medical supplies
• Negotiated with vendors for the purchase and delivery of medical supplies
• Performed accounts payable functions for payment of invoices