Netpulse Fitness IoT AWS Cloud Platform/Data Architecture Optimization and BI Reporting

Netpulse, now part of EGYM, is a media and data services company focused on delivering dynamic, interactive products and experiences to active lifestyle consumers. It delivers the leading personal media and workout tracking platform to health and fitness facilities.

Netpulse was running its business on Amazon AWS using a hodge-podge of technologies that were not well thought out. Workout data generated on fitness equipment all around the world transmitted back to the company's application servers on AWS, where mobile app users could interact with it. The system was unstable and not scaling well; an architectural overhaul was past due.

The company's COO brought RhinoSource in to review the technical infrastructure and investigate the major system performance and stability problems that were frustrating customers.

After a thorough review, RhinoSource implemented transformational best practices for AWS Cloud infrastructure management with the help of AWS partner ClearScale, producing significant improvements in system security, stability, performance and scalability.

RhinoSource then rebuilt the company's legacy MySQL databases using MariaDB clusters with cached storage — an order-of-magnitude improvement in query performance, with better protection for customer PII alongside it.

Next we migrated the poorly performing, difficult-to-scale legacy MongoDB document databases onto horizontally-scalable, zero-downtime DataStax Enterprise Cassandra and Spark clusters, far better suited to the growing volume of time-series IoT data arriving, and allowing the company to meet its SLAs.

To meet internal marketing reporting requirements, RhinoSource implemented Zoho Analytics for marketing dashboards, which required developing Pentaho ETL processes to populate the Zoho Cloud data warehouse from disparate operational databases.

Finally, RhinoSource developed dashboards and reports analyzing the company's AWS spending and identifying areas of waste — savings that ran to tens of thousands of dollars per month.