Hi, I’m Dan Zoeller

My passion and focus is cloud development. I have spent the past five years of my nineteen year career helping companies build scalable solutions in Microsoft Azure. I have worked on some massive Azure projects (some 7000+ retail locations depend everyday on Vigil Trends which I pioneered) and I’ve worked on some small projects where cost-cutting and agility were the goal. I can honestly say - I love ALL of the Azure projects I’ve worked on!

What Can I Do For You?

Admittedly, there are many things that I am not very good at; like dancing, baking or writing legibly, just to name a few. But when it comes to technology and software development there are several areas that I really shine! Particularly, I have a knack for working with big data, visualizing data, designing dashboards, and creating rapid prototypes. These are the areas I’ve devoted myself to study and to continually improve in; and they are also the areas that I can be of the best use to you!

 

Tech Skills

 
azure.png

Microsoft Azure

 
csharp.png

C# / .NET

 
sqlserver.png

SQL Server

 

What Have I Done Lately

 

  • Created a SQL Synapse data warehouse solution that houses over 5 billion rows of data and provides on-demand Analytics and Machine Learning reports

  • Integrated Azure Cosmos DB, Function Apps and Service Bus to create a system health dashboard for a video management product

  • Implemented Azure Streaming Analytics, Event Hub, and SignalR to create a real-time Point Of Sale notification system

  • Integrated data from an HR system, a cash safe system, and a Point of Sale system to create a custom store safe-count dashboard using Azure Function Apps and Cosmos DB

  • Created an employee risk dashboard using Azure Machine Learning and Function Apps

 
 
minimal.jpg

My Philosophy

 

I believe in solving problems with the simplest approach possible.  Fancy and complex tools can be fun but if a problem can be solved without them, then that's the way it should be done.  I believe that an intuitive, unified, pleasant user experience is, at least, just as important as the technical design of any software.  I am truly delighted any time I can help a customer see their data in new ways using custom data visualizations and business intelligence. I believe that software should be built in an affordable manner; scaling up a solution should only be done when necessary and appropriate.

 
 

Education

 
 
ballstate.png

Ball State University // 2012

MBA

iwu2.png

Indiana Wesleyan University // 2001

B.S. - Computer Information Systems

Featured
Azure SQL Synapse: 5 Billion Rows of Lessons Learned
Azure SQL Synapse: 5 Billion Rows of Lessons Learned

I wanted to share my experiences and highlight the things that I found most valuable while creating a Dedicated SQL Pool instance in Azure that is used by one of my clients to query and analyze over 5 billion rows of data. This is not a comprehensive list of the capabilities or best practices for Azure Dedicated SQL Pool. This is more of list of things that got me my best bang for my buck.

Azure Functions vs Web Jobs vs Cloud Services
Azure Functions vs Web Jobs vs Cloud Services

So you have a web app up and running in Azure and now you need to do some background work that’s related to your new web site but it definitely doesn’t belong in the web app itself. This could be anything from importing data, to sending out subscription emails, to updating cached data, or running database maintenance.

You may be wondering, with so many viable options at your fingertips in Azure, what is the best and most cost effective way to get work done? You want to strike the balance between having something that’s powerful enough to grow if it needs to grow but you don’t want to incur a bunch of unnecessary costs right out of the gate by choosing too much power!

Easiest Way To Import Excel Files in C#
Easiest Way To Import Excel Files in C#

The task at hand for me was that I needed to import and transform several different Excel formats into an existing SQL user table. The formats were not guaranteed to always be the same and I needed a way to quickly add new formats without writing a bunch of new code each time.

Up and Running with Azure Event Hubs
Up and Running with Azure Event Hubs

This past month I finally had a business case that called for Azure Event Hubs to be part of my overall solution to a real-world problem.  Up until this point I was always able to get by mostly with plain old Table Storage Queues and sometimes Service Bus Topics, but the business case I started working on this past month involved sending many megabytes of information from potentially thousands of devices around the clock.

Paging Results with DocumentDB
Paging Results with DocumentDB

DocumentDB is a great NoSql database engine for working with big data.  One thing that was difficult to implement though was an intelligent way to page through the results.  In this article I will show how I used a combination of caching at the client side of my app along with utilizing continuation tokens from the SDK response to build a decent paging mechanism for big data queries using DocumentDB.