Timothy Vanover Email & Phone Number

Greater Nashville Area, Tn

Managing Microsoft Sql Server servers, deployments, code reviews, TSQL performance issues, on call support, creating fail-over clusters, capacity planning, guidance to development teams, database architecture review.Research into Azure PAAS, Azure IAAS, Azure DocumentDB, PostgreSql, MongoDB, Couchbase. Wrote demos, explored scaling, high availability, and ease of implementation. Made recommendations to architecture group based off findings to implement MongoDB.Design of replication from 20 Sql Server databases to AWS Aurora through DMS for next generation of applications and services to have real time data from on site systems to new systems being constructed in the AWS cloud.

Nashville,Tennessee

Managing Microsoft Sql Server servers, deployments, code reviews, TSQL performance issues, on call support, creating failover clusters, capacity planning.

Nashville, Tennessee

Data Architect for Research• Researched server loads and query access for Data Warehouse and made recommendations to new san design• Altered SSIS Load packages for performance and better reliability when connecting to Oracle server• Upgraded data warehouse to SQL Server 2008 R2• Altered dynamic partitioning of the SSAS Cube for better performing mdx queries better suited to the business• Began task of managing various sets of imports and loads• Maintained and extended dimensions, measures, hierarchies in cube• Altered warehouse views to provide increased throughput for Reporting queries and cube build. Reduction in cube build times are now 40% faster. This also helped keep KeyNote reports in the 99% range providing more scalability.• Modified warehouse ETL steps to allow for faster recovery on cube builds when fails occur by segmenting problem areas to separate xmla. Cut recovery processing time by 12 minutes on very tight SLA.• Modified several under achieving reporting queries that use complex data between cube and oltp data for fast return of data to clients. This also helped keep KeyNote reports in the 99% range providing more scalability.• Engineered process to prebuild of large fact source/build tables during a synchronous workflow step to better utilize resources. This step cuts the time to build 5 major fact build processes by 50%. • Coauthored new data retrieval process that cut report runtimes down in many cases greater than 400% faster returns of the rendered reports.• Brought new PMA data mart creation run time from 18 hours to 21 minutes.

• Architected, lead team in implementation of successful new warehouse bringing disparate subject area information into single warehouse area mostly star schema dimensional model• Successfully created new warehouse in 12 months, surpassing performance, reliability and accuracy including 163 dimensions, fact, aggregates, and Xref tables with 60+ jobs of SSIS projects• Architected nightly loads with fail safe load methodology, exception logging, data scrubbing, exception handling, growth logging for space management• Designed hardware implementation for sox compliant Dev, QA, and Production environments and did continual growth analysis from daily load metrics to insure production hardware keeps up with business needs• Set up Source Safe, version control, Snapshot deployments• Created standards document, tsql templates, reviewed tsql code, SSIS, designed and managed projects for subject area implementations• Tutored and provided guidance for several teams on SQL Server 2005 and SSIS• Enabled systems and CMS reporting applications - Hedis, Lags, MMR, IVR, Provider Web Search, HMR, Claim Web Search, Executive Dashboard, IPort-HSConnect, Ascender, DXCoding, Vendor Exports, Enterprise Reporting to have single source of truth for all reporting• Provided 24/7 support for business• Designed specialized de-normalized dimensions for applications holding 12-120 million rows for instant query response• Continual analysis and rapid response on data quality from CMS files, vendor files, McKesson, Ezcap, Facets, MHC systems to insure clean accurate data• Maintained red book for data recovery and business continuity strategic planning and testing• Managed team through PBM replacement providing on time deliverables through 15 + associated enterprise projects• Wrote ETL in SSIS, DTS and created complex stored procedures containing Data Warehouse business logic.• Working through SQL Server 2005 to SQL Server 2008 R2 Upgrade

• Inherited data warehouse, released 7 iterations, updated code base to SQL Server 2005, architecting changes to aggregates, fact, dimensions, and DTS packages for current business needs and growing data. Defined hardware needs for future releases for Dev, QA, and clustered production environments. Updated data logic, loading logic, indexing, loading methodology to:o Provided less impact to source OLTP systemso Provided faster more dependable loads of data• Reengineered DTS load packages to SSIS• Updated stored procedures to new TSQL syntax for better maintainability and optimized for faster run times• Accurate data that exceeds Six Sigma standards for accuracy needed for KPI• Removed un-needed steps, objects, and a key generator database for faster throughput of data removing cross database joins• Implemented faster, more precise incremental loads for dimension and fact data used to build real time aggregates with greatly reduced load times• Implemented partitioning based on reporting and loading needs to allow best throughput based on reporting criteria• Assisted Racer development team in setting up test scenarios and architecture for partitioning of data in SQL Server 2005 environment• Team architecture and development for AIMEE system for Master File. This system was built to become the authoritative source for data in the enterprise for sub systems• Solution to replace poorly written stored procedures for load system with performance increases as much as 400-600% on joined tables with up to 246 million rows• Training developers conducting both training classes and one to one assistance• Wrote KPI Web ASP.Net 2.0 Web interface for Reporting Services 2005• Share Point Team site maintenance• Project management for all team projects• Team management responsibilities including bonus, three month, and annual reviews

Responsible for data warehouse, SQL Server development, Asp.Net applications, IVR System Architect and developer.

Maintainted SQL Server 2000 Database, corrected poorly written stored procedures decreasing runtimes by as much as 60%, wrote reports with Active Reports.

Education record

Hardware strategies, Sql Server 2012, Sql Server 2014 CTP2

Education record

San Francisco Washington Orlando Denver North Carolina

Sql Server Analysis Services 2008

Mcad, Mcsd For .Net

Activities and Societies: Award From Microsoft - Early Achiever for MCSD for .NetMicrosoft Courses: Microsoft Security Seminar 8005B 2710.

Mcsd, Mcdba, Mct, Microsoft Technologies

Microsoft Courses: Implementing a Sql Server 7.0 Database Administration for a Sql Server 7.0 Database Mastering Web Development.

Cis

Education record