William Varner Email & Phone Number

Englewood, Colorado, Us

Irving, Tx, Us

Senior Software Engineer - Sr ETL Database Developer/SSIS Developer with Builders First Source Maintains data storage and access by evaluating, designing and implementing company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes code for database access, modifications and construction of ETL, stored procedures and reporting queries. Within the established guidelines and instructions I perform my daily job functions autonomously, while reporting to my manager.

Denver, Co, Us

The SQL DBA / Database Developer / ETL Developer role within People (human resources or HR) Insights/Analytics Team, I design and ensure the integrity of complex data sets, compile and produce an effective reporting environment, generate insight, and help draw conclusions and recommendations about the business using people data.

Denver, Co, Us

The sole DBA, charged with the database application infrastructure in support of numerous business offices and facilities across North America and Canada. I was also very instrumental in installing, configuring and securing servers in accordance with industry standards and best practices. Recognized as an expert in ISS, complex troubleshooting, and business continuity, I achieved the following contributions:• Delivered real time ETL data load, aggregating from Oracle-based JDE/JWS servers into data warehouse.• Designed and implemented remote Disaster Recovery Operations using mirroring and AlwaysON.• Performed all maintenance patches and upgrades from SQL2008R2 and SQL2012 to SQL2016. • Managed 15 SQL Servers with over two terabytes and +500 databases on remote hosted servers and VM’s for all subsidiaries in North America and Canada. • Designed and wrote monitoring tools and scripts for tracking SQL Server performance and security - utilizing industry best practices and following the practice of least privilege.

Oakland, California, Us

As part of a Quality Population Analytics team, we conceptualized a new data mart in Health Catalyst. My role was to continuously generate a Monthly Automation Schedule for increased organization. My notable contributions in this role included:• Formulated storage procedures as well as SSIS/SSRS and T-SQL packages purposed to influence major decisions and standardize gap calculations in adherence to numerous NCQA HEDIS measures. • Maximized regional analytical efforts and drafted T-SQL scripts for continuous data extraction/aggregation.• Participated in Kaiser’s CAHPS membership survey to help obtain Kaiser certification in Colorado.

Denver, Co, Us

I briefly conducted extraction, presentation and analysis of health care information in close partnership with senior officers and key stakeholders. My notable contributions included:• Created and troubleshot new/existing databases and SQL Server Reporting Services (SSRS).• Design, develop, test and implement a database schema for storing parsed HL7 messages.• Constructed both a T-SQL based generic Alert Notification and HL7 message notification systems.• Collaborated with IT and business staff to gather all necessary requirements, clarify requests, and deliver a variety of analytics and reporting solutions.• Partnered with senior executives to translate Key Performance Indicators (KPI) to improve management tactics.

Mclean, Va, Us

Accountable to daily loads, tuning, maintenance, security and support of Air Reserve Personnel Center (ARPC) SQL Server 2014 database system – I oversaw user accounts, database performance, daily maintenance, backups, and any necessary system recoveries. My notable contributions included:• Successfully migrated to SQL Server 2014 High Availability (HA) Cluster SQL Server databases – rewriting SSIS/DTS jobs and deprecated T-SQL code.• Customized databases, SSRS Reports, and index optimization scripts. • Systematically automated file transfers between ARPC HQ and MilPDS for customized SSIS ETL jobs.

San Diego, Ca, Us

Consulting for Robert Half Technologies as a SQL Server DBA. Performed consulting work for Event Network in San Diego on their Microsoft Dynamics CRM and NAV systems.

Houston, Texas, Us

Tasked with security installations and mitigation, I serviced 750,000 Windows based computers with oversight of classified/unclassified networks, including remote repairs. My notable contributions included:• Created automaton tools to properly scan and install security patches on +750,000 computers daily.• Conducted performance tuning via SQL query optimization, SQL Profiler/Trace, DMV queries, table index monitoring, and fragmentation detection/rebuilding/reorganizing.• Achieved SLA goals with daily maintenance and monitoring of SQL jobs and performance reporting.• Constructed scripts to automatically update fleet wide workstation data.• Developed SQL tables, queries and SSRS reports to identify machines eligible for Windows 7 upgrade.

San Diego, Ca, Us

As Database Administrator/Sr. Programmer Analyst), I led our Wireless Business Solutions Unit, which included the supervision of six Programmer Analysts. My notable contributions in this role included:• Completely transformed data warehouse, designed SQL reports, supported Account Reconciliations, and resolved billing anomalies. • Performed system backups, restorations, recoveries, re-engineering, architecture, upgrades, failsafe load support, index management, fragmentation and statistical analyses.As Sr. Technical Support Specialist/Sr. Engineer (1995 - 2008), I commanded dynamic and time sensitive technology-related services in the Enterprise Services Division. My notable contributions in this role included:• Promoted from Technical Support Specialist to Senior Technical Support Specialist, Engineer, Senior Engineer, and Senior Programmer Analyst as a result of excellent job performance.• Led Wireless Business Solutions Unit with command of six Programmer Analysts.• Performed data architecture, design, management and analysis for OmniTRACS, a satellite-based locating and messaging product for trucks and non-mobile equipment.• Transformed a 6Tb HA clustered SQL Server 2005 environment into an Oracle 10GR2 data warehouse environment, rewriting 175 stored procedures into packages, as well as porting 150 databases, 375 ASP web pages and multiple applications.• Performed backups and restorations in a High Availability Clustered environment with remote Disaster Recovery.• Re-engineered and normalized the data warehouse for the transition from SQL Server 2000 to an HA clustered SQL Server 2005 solution - which required rewriting of multiple DTS packages.• Charged with daily index management, SQL report creation, Billing/Account Reconciliation tool development, and utility engineering for NOC Operations.• Crafted solutions purposed to compare, analyze, calculate distances, speed for 6M positions on 250,000 devices for satellite communications systems.

Dublin 2, Ie

I worked in Minneapolis in PRA Solutions area in the CSCOE. Running PRA software and writing scripts on Solaris workstations.

Washington, Dc, Us

United States Navy (Ret), Pacific Network Administrator and Operations Supervisor PDP-11 and PC Networks running Pathworks.Served a distinguished 16-year career in the United States Navy as an ADP Network Security and Network Administrator, Operations Supervisor, Aircraft Sensor Instructor, and Aircraft Acoustic Sensor Operator/Analyst.