Modernizing the Oracle ODS Data Warehouse for SaaS flexibility with PostgreSQL on AWS

Imagine trying to keep up with the evolving needs of higher education institutions while ensuring your systems are cost-effective and scalable. This was the challenge faced by our client, a company providing a suite of software solutions for educational institutions. They needed to modernize one of their core components—an Operational Data Storage (ODS) system, which essentially served as a Data Warehouse for preparing data for BI (reporting), originally built on Oracle—by migrating to PostgreSQL in AWS. The primary goal of […]

Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)
Operational Data Management for a Global Biotech Leader

Our client, a global biotech company with a presence in over 80 countries and a workforce of 4,000 employees, depends on a complex IT environment that includes both on-premises and cloud-based components. This infrastructure supports everything from research and development to manufacturing and corporate operations, with SQL Server playing a pivotal role across various environments. Given the scale and criticality of their operations, the client required a partner who could not only manage and optimize their existing SQL Server infrastructure […]

Sergii Zymbytskyi, Oleksii Svitlychnyi
EDW to Azure Databricks Migration

ABCloudz recently completed a significant project migrating an Enterprise Data Warehouse (EDW) from an on-premises SQL Server 2014 to Azure Databricks for a leading global retailer operating 3,000 offline stores across 40 countries. This migration was essential for addressing physical server limitations and outdated technology that hindered data processing and storage capabilities. Embracing Big Data capabilities, our solution leveraged Azure Databricks to enhance the client’s data scalability and processing efficiency, directly impacting their ability to manage and analyze large data […]

Sergey Shtypuliak (DB Engineer), Oleksii Svitlychnyi (Technical writer)
Dusker Audio Integration with Sleepbar via BLE

This story is about our collaboration with Dusker, a renowned company dedicated to creating audio products that enhance bedtime experiences. Dusker’s Sleepbar v2.0 is a standout innovation in their product line. This advanced sleep speaker uses bone conduction technology to deliver audio directly through a pillow, making it ideal for listening to music, audiobooks, sleep sounds, and podcasts. It’s designed for comfort with no buds or wires, ensuring a peaceful sleep environment that’s particularly considerate for couples, as the audio […]

Oleksii Svitlychnyi
Firmware Development for a Smart Water Bottle

Immerse yourself in the technical intricacies of developing firmware that empowers a smart water bottle with a wide range of functionalities. This bottle’s purpose extends beyond merely tracking the user’s hydration level; it also timely reminds them to replenish their water intake. Equipped with a microcontroller and sensors, the bottle collects water consumption data and interacts with the user via a mobile application. While a detailed functional overview of this solution can be found here, this blog post will focus […]

Oleksii Svitlychnyi
Smart Water Bottle BLE Integration

In this blog post, we examine how a smart water bottle communicates with a mobile application using the Bluetooth Low Energy (BLE) communication protocol. The customer’s concept is designed to motivate users to maintain a healthy lifestyle by regularly consuming water and monitoring their hydration habits. A comprehensive functional overview of the entire solution is available here.   This post focuses on the technicalities of the BLE communication protocol as it facilitates interaction between the mobile app and the smart water […]

Oleksii Svitlychnyi
The Smart Water Bottle Solution

Imagine a bottle that does more than just hold water—a bottle that communicates with your smartphone, tracks your hydration levels, and nudges you towards healthier habits while conserving the environment. That’s the reality we’ve created with a solution that marries the simplicity of hydration with the complexity of technology. By integrating the bottle with iOS and Android apps using the energy-efficient Bluetooth Low Energy (BLE) protocol, users gain the power to monitor their daily water intake and, simultaneously, contribute to […]

Oleksii Svitlychnyi
Over-the-Air Device Firmware Upgrade via Bluetooth

We’ve developed a mobile app and web admin panel that allow a specialized headphone manufacturer for Heavy Metal enthusiasts to swiftly and conveniently deliver firmware updates for their headphones over the air. These headphones do more than just play music; they’re designed to precisely render sound, enhanced by continually evolving custom firmware for each model. How can users stay informed about the latest updates and improvements? This is where our expertise in wireless connected devices truly shines. We have crafted […]

Oleksii Svitlychnyi
Medical App with BLE Blood Pressure Monitor Integration

Explore our development of a BLE-enabled application that simplifies patient monitoring by directly syncing with wireless blood pressure devices, focusing on functionality and user-friendly design. A key feature of the application is its ability to synchronize with wireless medical devices. In this blog post, we will examine the process of establishing a connection with a wireless blood pressure monitor via Bluetooth Low-Energy (BLE) technology. This feature enables users to effortlessly collect data on their blood pressure readings without manual entry. […]

Oleksii Svitlychnyi
Low-Power Design Techniques and Methodologies

Discover the art of crafting energy-efficient IoT devices in this comprehensive guide, where we delve into optimizing Bluetooth connectivity for extended battery life, innovative voltage drop mitigation techniques, precise battery life calculation methods, and strategies for enhancing button and switch energy efficiency. As the digital world evolves towards more connected yet power-conscious solutions, understanding these key aspects becomes crucial for developers. While the specific examples and calculations you will encounter in this article are based on data from one of […]

Dmitriy Liukevych, Oleksii Svitlychnyi
Case Study: Fast and secure media content delivery with Amazon CloudFront and Lambda@Edge

This case study shows how ABCloudz engineering team resolved site performance issues using Amazon CloudFront and Lambda@Edge of AWS. Challenge Our partner iCleanse offers its clients the Swift UV devices, designed to disinfect hands and mobile phones. As the device disinfects a phone within 15 seconds, it simultaneously displays sponsored video content, generating advertising revenue. Businesses of any type can benefit from installing these disinfection stations, not only by reducing costs on traditional disinfection methods and aligning with green initiatives […]

Viacheslav Kim
FeNO Connected Medical Device Integration Solution

Learn how we supported a research institute in deploying and evaluating their innovative asthma treatment program technologically, through the integration of the chosen FeNO device into the application. Embarking on a mission to advance asthma treatment, a research institute developed new methodologies aimed at enhancing patient care. To validate these approaches in real-world settings, they initiated a study involving a group of asthma sufferers, intending to administer and evaluate a novel treatment cycle. Essential to their research was the accurate […]

Alexey Koryagin, Oleksii Svitlychnyi
Case Study: Boosting Online Building Materials Marketplace Performance with Amazon CloudFront and Lambda@Edge 

Our client aimed to develop an online marketplace for building materials, designed to manage intricate online transactions and ensure a top-notch global user experience, supported by stringent security and exceptional performance standards. This case study details how ABCloudz utilized Amazon CloudFront, coupled with Lambda@Edge for dynamic content delivery. By deploying CloudFront, we significantly reduced web application load times, which is directly linked to improved user satisfaction and higher conversion rates. This deployment addressed key technical challenges, such as high traffic […]

Viacheslav Kim
AWS Migration Competency Attained

Workload migration represents a pivotal milestone in the AWS customer journey, and our paramount focus is on facilitating a clear and seamless migration for our customers. Consequently, ABCloudz is thrilled to announce our recent achievement of the AWS Migration Competency, reaffirming our commitment to providing comprehensive and exceptional cloud migration solutions. What does this achievement mean for you? Attaining the Migration Competency sets ABCloudz apart as an AWS Partner with a proven ability to smoothly migrate clients of all sizes […]

Adam Robertson
Development of a Healthcare App for Allergy

Explore how our allergy management application enhances patient care through advanced medication tracking, symptom and environmental trigger monitoring. Our customer, a renowned pharmaceutical company, expanded their business model to include a “business-to-business” approach alongside their core drug and medical device production under their own brand. They started manufacturing medications for other medical providers and also offer them custom mobile application development to support specific patient treatment scenarios. To enable rapid and flexible app development, we created a low-code platform for […]

Alexey Koryagin, Oleksii Svitlychnyi

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?

ABCAssist