Kyle Thompson Email & Phone Number

Cincinnati, Oh, Us

Boston, Ma, Us

Cincinnati, Oh, Us

- Responsible for designing, building, improving, and maintaining financial reporting from disparate data sources.- Spearheaded migration effort to replace on-premise SQL data warehouse with new cloud data lake and warehouse utilizing tools such as Fivetran, dbt, and Google BigQuery.- Implemented multiple ETL pipelines connecting numerous data sources such as Salesforce and Zuora. - Designed and built complex star/snowflake models using extensive SQL scripting including stored procedures, UDFs, and dbt macros.- Administered multiple BigQuery projects including handling granular permissions across teams and managing service accounts.- Worked closely with Python developers to enable scheduling of full data pipeline using REST APIs such as dbt and Power BI.- Maintained and supported the legacy on premises SQL Server 2012 data warehouse and processes using SSIS and stored procedures while creating a decommission roadmap for retirement.- Evaluated and selected new data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration.- Created a new reporting environment using SQL views for replicated Salesforce data to facilitate end user ad hoc analysis and report replication.- Provided continuous code review for analysts on team while also running training sessions for the larger Finance organization.- Supported BI initiatives such as a Power BI rollout, creating reports, and administering SSRS.

- Expanded responsibility for Microsoft SQL Server logical and physical database design, implementation, maintenance, security, and performance tuning.- Migrated production databases from SQL Server 2012 to a 2016 clustered virtual environment to provide highavailability, increased performance, and scalable capacity.- Implemented new database disaster recovery plan using Basic Availability Groups between the primary datacenter and the colocation site to reduce recovery time in the event of an outage.- Optimized the performance of slow T-SQL queries and stored procedures by using DMVs, SQL Server Profiler,execution plans, and the Query Store to create new or alter existing indexes.

- Performed data analysis, data modeling, ETL development, and database administration for the company’s growing datawarehouse/business intelligence platform.- Helped to design, create, and implement the company’s new Enterprise Data Warehouse.- Developed,implemented, and maintained SSIS packages using SSDT, VSTS, and T-SQL scripts to develop ETLprocesses that included data validation, integrity checks, and logging.- Deployed Power BI and on-premise data gateway allowing users to access on-demand dashboards.- Maintained and administered SSRS along with creating and updating numerous reports.- Assisted in several infrastructure projects including a SharePoint rollout, backup solution POC’s, hardwareupgrades and migrated fifteen servers to a clustered virtual environment to provide high availability and failoverservices.

Cincinnati, Oh, Us

- Performed technical and functional support in the areas of ERP development and administration, Citrix administration,server maintenance, database administration, process mapping, system testing and development, security access, andtraining.- Successfully implemented SharePoint 2010 Foundation server to replace outdated intranet site.- Performed database administrative tasks such as configuring nightly backup/restore procedures, creating viewsand stored procedures, and designing cluster configuration.- Helped to rollout Dell KACE appliance for global adoption creating a unified ticketing system, patchingapplication, and inventory catalog.

Cincinnati, Ohio, Us

- Supported Active Directory, Exchange spam filtering, system maintenance and user support.- Worked IT Help Desk and collaborated with IT technicians for global ticket escalation.- Supported and maintained global network communications.- Project work included implementing a new cryptographic server and updating SOP documentation.