Robert Hurwitz, BI and Database Developer in Jacksonville, FL, United States
Robert Hurwitz

BI and Database Developer in Jacksonville, FL, United States

Member since January 24, 2021
Robert is a seasoned technology professional, having worked for 15+ years across roles ranging from application development, BI development, DB administration, solutions engineering, architecture, and technology leadership positions. At Direct Care Innovations, he reduced CPU utilization by 40% by improving application logic, rewriting stored procedures, and restructuring the databases' indexing strategy. Robert brings a pragmatic approach to technology and data challenges businesses face today.
Robert is now available for hire

Portfolio

Experience

Location

Jacksonville, FL, United States

Availability

Part-time

Preferred Environment

Windows, SQL Server Management Studio, T-SQL, SQL, Azure SQL

The most amazing...

...improvement I've made was reducing cloud compute costs by 20% while simultaneously improving performance by 50%, resulting in a 1-year ROI of more than 2,000%.

Employment

  • Director of Database Development

    2021 - PRESENT
    Direct Care Innovations
    • Optimized database performance by reducing CPU utilization by 40% over three weeks by improving application logic, rewriting stored procedures, and restructuring the databases' indexing strategy.
    • Reduced Azure spend by 20% by rightsizing PaaS resources.
    • Managed the development of data reporting capabilities within the organization to deliver value added services and new reporting functionality within the SaaS product.
    Technologies: SQL Azure, Azure, Azure PaaS, SQL Server DBA, Azure Data Factory, Data Warehouse Design, Data Modeling, C#, SQL, Business Intelligence (BI), Data Architecture, ETL, Databases, Data Pipelines
  • Technology Solutions Manager

    2016 - 2021
    Step Up For Students
    • Implemented 3rd-party solutions and designed integrations with in-house systems using REST APIs, Azure Logic Apps, Azure Storage, and Azure Data Factory.
    • Developed target state architectures along with intermediate transition architectures for data solutions, allowing for implementation and integration across business processes.
    • Led rapid response initiatives to deliver solutions to unexpected industry needs related to Covid-19, resulting in new revenue stream opportunities.
    Technologies: Azure Data Factory, APIs, C#, REST, Business Process Automation, Azure, SQL Azure, SQL Server Integration Services (SSIS), ETL Development, Data Modeling, SQL, Solutions Architecture, Business Intelligence (BI), Data Architecture, ETL, Databases, Data Pipelines
  • Senior Database and Business Intelligence Administrator

    2010 - 2015
    Step Up For Students
    • Designed and implemented high availability database solutions using a combination of SQL Server tools and virtualization.
    • Designed and executed the data mapping and migration from the existing MySQL database into a new SQL Server database schema using SSIS and custom T-SQL ETL processes.
    • Delivered ETL processes utilizing SSIS to stage, process, and load data into the Data Warehouse used by Analysis Services (SSAS) and other reporting tools.
    • Developed SSAS cubes using MDX calculations and SSAS tabular models to perform complex analysis.
    Technologies: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Power BI, Dimensional Modeling, Data Warehousing, Database Replication, High Availability Disaster Recovery (HADR), C#, ASP.NET Web Forms, ASP.NET MVC, SQL Azure, SQL Server DBA, Data Warehouse Design, ETL Development, Data Modeling, SQL, Business Intelligence (BI), Data Architecture, ETL, Databases
  • Database Administrator III

    2011 - 2011
    Black Knight
    • Administered and responsible for the performance, availability, and recoverability of 20+ servers and 100+ TB of databases.
    • Developed daily monitoring procedures using PowerShell.
    • Migrated several large databases (1TB+) between data center locations.
    • Managed troubleshooting and resolution of transaction log shipping and mirroring failures.
    Technologies: SQL Server 2008 R2, Database Replication, Database Clusters, Log Shipping, SQL Server DBA, Disaster Recovery Plans (DRP), Performance Tuning, SQL, Databases
  • Software Developer

    2005 - 2010
    Florida Virtual School
    • Designed and developed database schema for new functionality including tables, views, functions, and stored procedures.
    • Led the organization and execution of software testing and the release of software and database solutions.
    • Led the implementation of transactional replication of data to be used for reporting.
    • Developed reporting solutions using T-SQL, Reporting Services, and Integration Services.
    Technologies: ASP.NET Web Forms, Stored Procedures, SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Database Replication, SQL Server DBA, ETL Development, Data Modeling, C#, SQL, ETL, Databases

Experience

  • Performance Optimization (Development)

    A performance optimization project for a client reaching the limit of their Azure infrastructure. I performed a full systems analysis of the application front end, services, and database back end, cataloging high numbers of dependencies on Azure SQL requests. I resolved several logic issues resulting in N+1 database calls by refactoring entity framework and LINQ queries in the application, as well as optimization stored procedures and the UI.

  • Student Information Data Warehouse (Development)

    I led the design and development of an enterprise data warehouse in the education industry. I was responsible for the warehouse's modeling following the Kimball DW/BI lifecycle methodology, along with the ETL processes to integrate various systems of record. This warehouse and its reporting tools supported deep analysis into the performance of students and schools to provide unique recommendations for individual students.

  • Business Process Outcome Prediction (Development)

    I led the design of a predictive data mining structure using decision trees to determine the outcome of a manual business process using user-supplied input data, along with engineering features based on external data providers. This enabled the business to automate an expensive and time-consuming process, while increasing the auditability of manual workflow.

Skills

  • Languages

    SQL, T-SQL, C#, C#.NET
  • Paradigms

    Dimensional Modeling, Business Intelligence (BI), ETL, Scrum, REST, Kimball Methodology
  • Platforms

    Azure, Windows, Azure PaaS
  • Storage

    SQL Azure, SQL Server DBA, SQL Server Reporting Services (SSRS), Database Replication, SQL Server Management Studio, SQL Server 2008 R2, Databases, SQL Server Integration Services (SSIS), Data Pipelines, Azure SQL, SQL Server Analysis Services (SSAS), SQL Server 2005
  • Other

    Data Warehouse Design, Data Modeling, ETL Development, Data Warehousing, High Availability Disaster Recovery (HADR), Data Architecture, APIs, Solutions Architecture, Azure Data Factory, IT Systems Engineering, Scrum Master, Scrum Coaching, Business Process Automation, Azure Web Jobs, Indexing, Decision Trees, Data Mining, Stored Procedures, Database Clusters, Log Shipping, Disaster Recovery Plans (DRP), Performance Tuning
  • Frameworks

    Windows PowerShell, ASP.NET Web Forms, ASP.NET MVC
  • Libraries/APIs

    LINQ, Entity Framework
  • Tools

    Microsoft Power BI, Azure App Service

Education

  • Associate's Degree in Electrical Engineering
    2004 - 2007
    University of Central Florida - Orlando, Florida, USA

Certifications

  • Certified Scrum Master
    MAY 2019 - MAY 2021
    Scrum Alliance
  • MCPS: Microsoft Certified Professional
    NOVEMBER 2009 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others