• Learned and used IBM InfoSphere DataStage & Neteeza which are ETL tools for writing SQL queries to tally customer survey records received and sent from various systems and sources.

Saved $25,000 in unneeded cellular wireless expenses for the years 2010-2013. Continued to monitor, control, and maintain cellular wireless expenses. Used XIGO TEM software, as well as MS Excel and MS Access to assist in the monitoring of expenses. Create and run reports from Data Warehouse information at Verizon, AT&T, Bell Mobility, and Rogers Wireless using the vendor report writers to download information into MS EXCEL and MS Access for tracking usage and $ spend/expenses of user cellular and wireless data devices using Pivot Tables, Formulas, Functions, etc. Always searching for and implementing Cost Savings & Recovery dollars.Primary point of contact for all Blackberry and cell phone devices for 1000 plus users for a multi-million dollar company diversified in manufacturing & distribution of advanced turf and ornamental fertilizer. This includes BlackBerrys, Androids, iPhones, iPads, and Tablets. Manage device phone, text, and data plans, Purchase (Procure), Move, Add, Delete, Order, Manage, Upgrade, warranty replacements, device troubleshoot, etc. for all devices.• Extensive knowledge of telecom contracts, products, services, and invoices.• Analyze complex telecommunication expenditures against inventory to ensure compliance with vendor contracts to reduce unnecessary/erroneous expenditures. • Maintain an accurate inventory of all Telecom devices, circuits, numbers, and equipment. • Review monthly telephone charges including fees, taxes and other charges via the vendor’s automated billing system. • Worked with department representatives, employees, and vendors to resolve any billing, service or equipment issues that develop. • Audit voice and data invoices for past due balances, late fees, 3rd party charges and any unnecessary charges. Coordinated the research and dispute of these charges as necessary. • Establish professional working relationship directly with vendor and end-users to resolve issues and claims in an accurate and timely manner

Key intelligent business reporting systems and software analyst, as well as IBM iSeries (AS/400) system administrator for plastic model manufacturing, hobby supply, and distribution business with over $ 4 million in inventory and 20,000 active mail-order and wholesale customers. Maintain iSeries status and integrity of file data. Current release of iSeries operating system 6.1. Software used was Order Power order management and E-Commerce software by CSI Florida. Responsible for the management and planning of all technology needs including iSeries AS400, PC’s, Servers, Printers, etc. Also responsible for ensuring that all reasonable security and data safety procedures were developed, implemented and sustained across all platforms.• Handled extensive data gathering/extraction, and data manipulation; extracted raw data from systems for analysis and reporting to support the sales division, inventory, purchasing, GL, AR, Warehouse Management, In-House Call Center, etc.• Table/File optimization for enhanced data gathering, while also saving $8,000 in hard disk upgrades• Data Gathering for Call Center Metrics, Customer Information, Item Pricing, and other pertinent data for Call Center and Web Order Management.• Translate business requirements into intelligent business reports/analytics for financial decision making using Crystal Reports 2008, SQL, and other query tools for finance, sales, inventory, purchasing, manufacturing, G/L, and A/R to replace legacy system reports. Reports included variance to budget, cost analysis, and percent of gross profit margins.• Create new business reports as required and automate the creation of regular reports.

Serving as a key liaison between multi-state, multi-plants, dairy manufacturing distribution business groups and information technology, gathered data, analyzed data, implemented, and maintained business software for dairy manufacturing, warehousing, and distribution businesses. Supported users, documented gathered information, and maintained current multi-plant, multi-state, dairy manufacturing and distribution ERP System. Travel to dairies to work conversion efforts of new ROSS or DMS ERP system. Perform analysis of data conversion specifications from existing legacy systems to new ERP system. Supported users in conversion and parallel tests; confirmed results. ROSS and DMS ERP systems including Order-To-Cash, Procure-To-Pay, Route Settlement, A/R, G/L, Inventory, Purchasing, Manufacturing & Costing.• Collaborated with users, staff members, and other business analysts to develop requirements, perform analysis; prepare specifications, design systems, test applications and implement new programs and systems into production. • Improved business requirements by building processes to analyze user requests for feasibility. Assessing project hours to provide innovative yet practical solutions to facilitate change while verifying root cause and effect relationship. • Trained and supported users on new ROSS USA and/or DMS ERP system and other software applications.

New Mexico Beverage was the Miller Beer Distributor for the State of New Mexico. Subsequently sold to the Maloof Family and merged Coors and Miller brands under one warehouse. Since sold to Admiral Beverage companyResponsible for the management and planning of all technology needs including iSeries, AS400, telephone (wired and wireless), PC s, networks, Servers, printers, etc. Responsible for ensuring all reasonable security and data safety procedures were developed, implemented, and sustained across all branch locations. Extensive Data Gathering for Business Intelligence Report Writing for Finance, Sales, Purchasing, and Inventory using Excel, Access, SQL, and Crystal Reports. Cost Analysis, Budget Analysis, Data Modeling for tables used in purchasing requirements for the beer industry. Later converted/ETL these tables to DB2 for the IBM AS400/iSeries.Managed projects, personnel, and performed business analysis for the IT department of a Miller and Coors Beer beverage warehouse and distribution company doing $130 million dollars in gross sales. Purchased, Implemented, managed hardware, software, and network systems for the organization to include four branch warehouse locations. Hands-on of cash reconciliation of route driver invoices to ensure A/R balancing and inventory cost objectives were met.