Years of experience: 22
United StatesIT
Trust Score
Exceptionally trusted; proven professional excellence.
Bill's Career Path
Nov. 2021 -Mar. 2024
RevGen PartnersSenior Technical Consultant
Denver, Colorado, United StatesProvided data engineering services for a local technology focused consulting firm
• Maintained legacy SQL Server system for client during transition to cloud-based data system
• Analyzed and constructed data sets for telecommunications companies considering program mergers
• Developed Matillion jobs to transfer data from DB2 database to Snowflake platform
• Created multiple stored procedures ...
Aug. 2017 -Oct. 2021
GuidehouseSenior Consultant
Boulder, CO, USAProvided data engineering services for the energy sector (utilities) servicing portion of a multi-national consulting firm
• Created multiple AMI databases in SQL Server, Hive, and Snowflake using client-provided utility data
• Supported migration of Energy practice's databases from SQL Server to Snowflake
• Designed and implemented numerous SSIS packages for ETL processes on existing and new...
Nov. 2010 -Jun. 2017
RadianSr. Business Intelligence Data Analyst
Denver, ColoradoProvided data science and analytical solutions for the mortgage backed security industry
• Created reporting dashboards in MicroStrategy, utilizing URL API for formatting and exporting reports and passing parameters through hyperlinks
• Developed and managed SQL Server data structures for mortgage industry and loan servicer performance data
• Automated Servicer Relations consulting packages u...