Enhanced and modified consolidation of subrogation financial data into an Access database to Excel spreadsheets to enable financial forecasts of the US and Canada markets. Streamlined a 6 day process down to an efficient 2 day process which optimized man hours and costs significantly. Manage and pay collection vendors' fees through daily reporting to ensure fees are paid in an accurate and timely manner.Produce Accounting Daily Recaps of subrogation cash received using Excel spreadsheet and importing into JD Edwards accounting software for accurate and timely reconciliation.

Created, managed, and executed product plans, incorporating input from publishers, editors, sales, and marketing. In addition, monitored, evaluated, prioritized, and incorporated customer feedback into project plans and regularly scheduled enhancement releases. Identified performance gaps, and worked to resolution, developing with sales management strategies for product rollouts and key releases.

Designed systems for compiling nationwide sales and inventory data from corporate-owned refineries, terminals, and customer systems. Data was used to produce federal and state tax reports with unique specifications on a weekly and monthly basis.Worked with vendor to design front-end application meeting tax department's needs to extract Sales/Inventory data from SAP Sales/Distribution system for motor fuels excise tax reporting purposes. Collected requirements from state auditors in response to tax department need to download specific data for audit purposes on a continual basis. Extracted this data from SAP Sales and Distribution system and created electronic files. Audit criteria and deadlines were met with 100% on time compliance and without any financial penalties incurred.

As IT Analyst for major oil company tax department, automated the monthly state tax reporting for 7 states with unique reporting criteria. Gathered specifications and developed 7 MS Access databases that imported the state file. Designed tax reports in both paper and electronic formats to meet state specifications. This automation optimized costs and man hours significantly.

Programmer/Analyst for Warren Petroleum supporting their Accounting systems.