OnAsset Intelligence - IoT Data Collection With Snowflake and PowerBI

Azure IoT modernization with serverless architecture, cost savings, and Snowflake analytics enablement

Client
ChallengeModernize Azure IoT Architecture and Reduce Cloud Spend
Result55% Azure Cost Reduction and CI/CD-Driven IoT Architecture with Snowflake Analytics
TagsSnowflake, Azure, Big Data, .NET, JavaScript & TS, NoSQL, Energy & Transport

OnAsset, a global leader in IoT-based asset tracking, engaged TaylorMade Software to modernize its Azure cloud infrastructure and reduce ballooning operational costs. Their platform relied on legacy Function Apps and high-usage services such as CosmosDB, Redis, and Service Bus.

We transitioned Azure Function Apps from Node.js to TypeScript using the NX Narwhal monorepo pattern, improving modularity and maintainability. At the same time, we managed and supported legacy C#.NET Core APIs and Angular/AngularJS front ends to ensure platform stability.

To optimize cost, we implemented targeted alerting and usage caps across critical Azure services. As a result, monthly cloud spend was reduced from $100K to $45K, delivering a 55% operational cost savings.

We designed event-driven serverless architecture patterns for IoT telemetry processing and formalized Azure CI/CD pipelines for application and infrastructure deployments. These upgrades laid the groundwork for scalable, performant, and maintainable cloud infrastructure.

Our work concluded with the enablement of Snowflake-based analytics and PowerBI dashboards to drive long-term insight and reporting across IoT workflows.

Related Case Studies

Hannover Re - AI Contract Matching and Data Vault DevOps

Modernized reinsurance data operations with AI lookup, Data Vault 2.0 warehousing, and DevOps automation in Azure

Tags: Azure, Big Data, SQL Server, Python & AI, .NET, Financial

HD Supply - A Snowflake Case Study Highlighting Security, Governance and Compliance via RBAC Automation

Snowflake enterprise roadmap for RBAC, governance, disaster recovery, and SOX compliance

Tags: Snowflake, Big Data, GCP, Energy & Transport

Hertz - AWS Mobile and Web App Modernization Case Study

Modernized multilingual mobile and web apps in AWS, improving booking speed, UX, and developer efficiency with React

Tags: AWS, JavaScript & TS, Java, C++ & Embedded, Mobile, Retail

Building a Snowflake Pipeline for Citi

Self-service Snowflake automation portal with GitOps provisioning and onboarding workflows

Tags: Snowflake, AWS, Big Data, Financial, Java

Freddie Mac - Snowflake Snowpipe and Governance Case Study

Snowflake governance and CI/CD modernization with iData no-code pipeline, SSO security, and role-based integration on AWS

Tags: Snowflake, AWS, Java, Python & AI, Big Data, Financial, Public

American Airlines - A Case Study in Snowflake Data Lake Modernization

Automated Snowflake RBAC, workspace provisioning, and lifecycle management for enterprise users

Tags: Snowflake, Big Data, Azure, Python & AI, Energy & Transport

Worldpay - A FinOps Case Study with Snowflake Tableau

Snowflake Tableau cost monitoring system with chargebacks and business unit allocation

Tags: Snowflake, AWS, Java, Big Data, Financial

CostFirst - Building Anti-Fraud Capabilities with Snowflake

Snowflake and Azure-powered fraud detection and analytics modernization

Tags: Snowflake, Azure, .NET, Big Data, SQL Server, Financial, Health & Biotech