Joseph Hacking

Experience

1. Database Manager

   Satterfield & Pontikes Construction

   Oct 2009 — Present · Houston, TX, US

   I develop and improve workflow processes to assist employees in being more productive with their time.I manage data from system to system. I create reports and queries to analyze and understand data. • Develop Timberline Estimating concrete database and for self-perform work.• Develop and maintain 400+ Crystal reports for Viewpoint Vista software.• Improve internal workflows by connecting Excel to the Viewpoint Vista database via ODBC connections.• Develop, maintain, and troubleshoot transactional data processes and reporting for Delta Airlines project management on the JFK, LGA, and LAX airports, which spanned 10+ years and 8+ billion in construction work.• Develop BOSA processes for airport baggage handling/security construction department• Integrate process to send Vista subcontract data to Autodesk Trade Tapp• Develop Access database to read in Timberline Estimating estimate data and P6 Scheduling data. Then apply estimate budgets to scheduling activities and export budgeted data back into P6.• Develop Access database to process proposed Value Engineering budgets to the subcontractor, general contractor, and owner; while maintaining separate markups per entity. Reports were developed for each subcontractor’s new scope of work.• Develop “Monte Carlo Simulation” for a Conceptual estimate using historical from data Viewpoint Vista accounting system.• Develop Polynomial regression future cash flows (expenses and revenues) using historical data from Viewpoint Vista accounting system.• Implemented several software solutions • Manage User accounts and security profiles for Viewpoint Vista software.One maxim that has helped guide me in my efforts to help others is this:\"It\'s not the height of the mountain that wears you down, it\'s the grain of sand in your boot.\" I work to remove the grains of sand from the user\'s boots.