Data & Power BI

Challenges The company that I worked for had an interesting product. They had recently “acquired” a consultant provided reporting services to higher education institutions. The consultant custom transformed data files from the institutions, loaded them into an on prem database to perform transformations and imported the results into a power bi report. The report was then emailed or shared via powerbi service. The institution would then go back and forth with the consultant about to tweek the reporting bits....

May 3, 2020 · 2 min

Data & Azure

In 2018, I was involved in designing and building a workflow that would allow sharing data between multiple products of the same campany on a single enterprise platform. The company had an enterprise contract with Microsoft Azure, with almost all of their infrastructure built and deployed across regions in azure. Building this workflow using the tools available in azure was a no brainer. Stack azure-data-factory azure-kubernetes-services azure-functions dotnet-core node elasticsearch kanban OKRs azure-devops...

April 26, 2019 · 3 min

Emails & Serverless

I worked on a project that involved sending surveys to students enrolled in higher education degree institutions at end of the semester. serverless azure-functions storage queue micro-service scaling What were the challenges? We used a legacy windows service built on dotnet framework with a crusty cron job system built on top of Quartz to send emails The process was chunky and could not scale to the demands of the growing product This was a multi-tenant service however, issues in one tenant affected performance and quality of service offered to other tenants There were too many unknowns about if and when the emails would be delivered, this was more of a spaghetti implementation of the older service It lacked tools for internal support people and clients to manage expectations and achieve their goals Solution?...

February 27, 2016 · 4 min