Kristopher (Kris) Hokanson Email & Phone Number

Pearland, Tx, Us

Pearland, Tx, Us

Houston, Texas, United States

Design and implement database architectures integrating data from multiple corporate repositories. Optimize existing SQL Server processes to increase reliability and performance.

Pearland, Tx

Principal consultant for all things SQL Server. Specializing in SQL Server relational database design and optimization as well as SSIS integration development. Also strong in SSRS report development and administration.

Houston, Texas Area

Sr. SQL Server managed services consultant handling all aspects of SQL Server from administration to development.

Develop and implement BI applications using all components of the Microsoft BI stack (SSIS, SSAS, SSRS, SQL Engine).

Administer all aspects of SQL Server used at Quantum (SSRS/SSIS/SQL Engine)Maintain, upgrade and develop new data transformations between oil & gas accounting and production systems to Oracle analytic and master data management tools.Develop, implement & improve SSRS reporting initiatives including migration of all reports from SSRS 2008 to SSRS 2012Monitor server utilization using Idera Diagnostic Manager and make resource allocation, schema design and code improvements based on observations

Developed ETL processes in SSIS importing data from dozens of disparate ERP systems into enterprise data warehouseBuilt and maintained all major forms of SQL Server replication for global distributionHeavily involved in several data quality and Master Data Management (MDM) initiatives using SQL Server Data Quality Services (DQS) and Master Data Services (MDS)Designed and implemented ETL packages for loading data warehouse data into SSAS cubesImplemented an SSIS auditing framework for monitoring historical data loads and trendsAssisted in development of SSRS reports running against corporate data warehousePresented several learning sessions on SQL Server best practices and advanced database design concepts both internally at NOV and at local SQL Server seminars

Developed and executed test cases for SQL Server management softwareManaged team of 3 QA engineers for the development of a new SQL Server security management tool Handled server and network administration for 20+ servers and networking equipmentWas involved in the successful release of more than a half dozen different products and versions including SQL Server backup (SQL Safe) auditing & logging (SQL Compliance Manager), security administration (SQL Secure) and server administration software (SQL DM)Implemented corporate intranet site using Microsoft SharePoint Coordinated testing performed by offshore outsourcing agenciesDeveloped TB sized test databases to be used by 12 person QA department

Designed, implemented and maintained multiple databases using Microsoft SQL Server containing 1,000+ tables and ranging from 200MB to 4GB in sizeRedesigned corporate accounting and job cost software to use SQL Server instead of Microsoft Access for data storageDeveloped ETL processes to move data seamlessly between estimating, job cost and accounting softwareProvided training and implementation support for Primavera scheduling softwareWorked with end users to develop custom reports for accounting and project management software using Sybase Infomaker and Crystal Reports

Developed customer support software using Visual FoxPro and Visual Basic with a SQL Server data storeDesigned and maintained SQL Server database for managing customer service call recordsBuilt and administered DTS packages for nightly import of customer call recordsAdministered all aspects of SQL Server including backups, index optimization and database developmentPerformed general IT support and network administration SkillsAll Windows Operating Systems SQL Server 7 – 2012 T-SQLSSIS SSRS SSASDTS Master Data Management Data Quality Services C++/C#/VB.net Microsoft Exchange QA practices & procedures

-Troubleshooting local computer and network issues. -Web development and updates using Macromedia Dreamweaver.-Upgrading network cabling.-Support of a Novell NetWare server.-Network OS migration from Windows 95/98/NT to Windows 2000.