Gary Ricks Email & Phone Number

United States

Austin, Texas, US

Various short term consulting roles from May 2015 - November 2015

Coppell, Texas, US

Created system of managing customer support cases using Outlook and Excel VBA. Analyze all aspects of data analysis and reporting for national customer care group. Find and develop automation techniques to improve processes. Develop metrics to support world class customer operations center.

Austin, Texas, US

Contract position - SQL Database Reporting

• Facilitated transfer of data to MySQL database from Excel allowing for web based access to customers and listings.
• Developed and implemented website for review of databases
• Modified Access database to create invoicing. Changed code in several queries - total time to complete process went from over 10 hours to under 5 minutes

• Contacted each applicant for patient navigation training and confirmed interest in attending
• Designed and setup SalesForce.com database for company.
• Developed and implemented weekly reporting using Excel and Access

Round Rock, Texas, US

• Developed and implemented mobile website for company.
• Facilitated transfer of data to PHP/MySQL database from MS Access allowing for web based access to customers and listings.
• Introduced concept of daily email using Constant Contact email solution.
• Maintained statistical analysis of website activity including number of visitors, actual length of time on site per visit, and produced charts on a daily basis showing trends and current activity from key words using.
• Developed and implemented Microsoft Excel Workbook to enter current inventory level for Parts division. Workbook was developed to save, create text file, and submit file to website using Excel macro capabilities.
• Management of IT department and Graphic Design department.

• Developed and implemented website to host baseball tournaments.
• Site was created using PHP and MySQL.
• Tournament directors were given a menu driven web application to allow teams to register, schedule those teams, and then input scores for the tournament.
• Innovative concepts included sending all scores entered to parents and coaches as text messages and automatically displaying teams registered.

Updated Sam Bass Baseball website

San Antonio, Texas, US

• Developed and implemented Microsoft Access database application to monitor all current project efforts in Underwriting Staff area. Integrated Access application with Microsoft Outlook for status updates. Application.
• Introduced concept of screen scraping to work with legacy systems. Application would highlight, copy, and store information from the mainframe system in a screen driven database application.
• Developed and implemented application to monitor underwriter statistics
• Introduced and maintained automation of underwriting area metrics
• Monitored daily activity levels of underwriters using mainframe data. This data was extracted nightly using an automated process, and was processed in five minutes the next morning

• Worked with sales representatives on technically oriented accounts to increase the customer’s understanding of our products.
• Evaluated the customer’s technical requirements and translated those needs to the sales representatives.
• Diagnosed and solved technical issues with wireless software applications

Round Rock, Texas, US

• Developed and maintained application to monitor purchase order activity
• Monitored and reported on daily statistics from purchase order activity
• Facilitated employee training sessions on purchase order tracking application
• Developed and implemented application to monitor account receivable balances
• Maintained analysis and reporting for account receivable balances
• Introduced automation of collection and order processing metrics