IMV’s Business Intelligence Empowered by AWS Data Management Solution
Established in 1996, International Minh Viet Joint Stock Company (IMV) is a prominent Vietnamese distribution company which specializes in Photo Imaging & Printing, Baby Care, Cosmetics, and Medical Imaging Systems. IMV has offices in all major cities with an expansive distribution network covering traditional, modern, and e-commerce channels. This allows IMV to broaden its presence and provide services to all 63 provinces in Vietnam. IMV’s ambition is to reshape Vietnam’s consumer landscape by providing top-quality products to end consumers, ultimately enhancing their modern, convenient lifestyle.
IMV used to grapple with a complex data landscape, in which data spread across diverse sources such as Oracle Database on AWS and numerous spreadsheets. This data fragmentation posed a significant challenge as it hindered the company’s ability to consolidate and access a unified view of the company’s data. Another pressing challenge for IMV was the heavy reliance on manual reporting processes, which not only consumed valuable resources but also introduced the risk of errors in reporting, posing serious implications for decision-making.
Furthermore, the former infrastructure of IMV lacked the scalability required to accommodate the growing volumes of data and the increasing demand for business intelligence and analytics.
Timeliness of insights was another critical challenge: its old setup could not provide the agility required for swift decision-making, potentially impacting IMV’s competitiveness in the market. As IMV continues its growth trajectory, such limitations of the existing current systems made it imperative for IMV to acquire a scalable, cost-effective infrastructure that could adapt to their evolving data needs without incurring excessive operational overhead.
SOLUTION - RENOVA CLOUD APPROACH
The focus of the IMV project was to build data lakes for processing data and transform them into comprehensive, insightful PowerBI reports, based on which IMV can make informed decisions that contribute to growth objectives. After careful consideration of IMV’s requirement and its existing IT infrastructure, Renova Cloud proposed a data management solution that relied on AWS Glue for Extraction – Transformation – Load (ETL); Amazon S3 for storing data; and Amazon Athena for querying necessary data needed by BI tools. Furthermore, Renova also employed AWS Glue Data Catalog for catalog management in order to achieve better integration between the selected AWS services.
The IMV solution was implemented in three phases with clearly defined tasks and deliverables. First, Renova Cloud set up a data lake for the client to store raw data ingested from their existing Oracle database hosted on Amazon EC2. Second, we aggregated this raw data to create a data source for Power BI, where raw data were duplicated and transformed into data types required by its destination processing tools. Finally, Renova used AWS Glue Crawler to determine schema, create tables, and write metadata in the AWS Glue Data Catalog. Based on this central metadata store, Amazon Athena would subsequently query processed data in S3 to create different views. As a result, Power BI would use the outputs from these views as a data source to build insightful data reports such as Marketing Reports, Sales MT Reports & Sales GT Reports, or Inventory reports.
As the region’s leading AWS partner, compliance with AWS best practices is always one of Renova Cloud’s top priorities when delivering solutions and the IMV project was not an exception. The overall architecture and operation of the IMV solution were fashioned and deployed in adherence with AWS Account Governance best practices such as informing the client’s team on when to use and not to use the root user for workload-related activities or activating MFA on the root account.
Client’s employee empowerment was also an important aspect of the IMV project thanks to the real-near-time alert mechanism based on pre-built workflows configured within AWS Step Functions. Specifically, In the event of any workflow step failure, a notification will be sent to the responsible administrator for immediate remediation. Thanks to this near real-time alert mechanism, the IMV team could proactively prevent unwanted interruptions when one or more elements could not make it to their intended destination.
- Thanks to the AWS Data Management solution, IMV could now gain valuable insights from existing raw data, enabling the company to stimulate growth and streamline operations
- The IMV solution operates on a serverless service, which allows IMV to minimize operational expense as they would only have to pay for what they actually used
- The sizing for AWS Glue and AWS Lambda was carefully studied and selected based on IMV’s estimated usage requirements to maximize ROI
Ngân hàng Thương mại Cổ phần
Joint Stock Commercial Bank successfully accelerated growth by migrating to AWSThe competitive digital race among banks is increasingly fierce, focusing on attracting technology-savvy customers. The commercial bank wanted to stay ahead of the competition and required scalable, reliable and cost-effective back-end infrastructure for rapid growth.Read more>
IMV’s Business Intelligence Empowered by AWS Data Management SolutionThe former infrastructure of IMV lacked the scalability required to accommodate the growing volumes of data and the increasing demand for business intelligence and analytics. Read more>
Vietnam’s Prominent E-wallet Migrated Its Two Most Critical Workloads to AWSThe E-wallet in question is one of Vietnam’s largest online payment platforms, developed and published by one of the most dominant technology players in the region. Read more>
F88’s Journey to a Secure and Centralized Data Management with AWS Cloud SolutionsEstablished in 2013, F88 stands as the forerunner network of secure lending in Vietnam, focusing on serving micro & small enterprises as well as individual customers. Receiving substantial financial support from renowned global Read more>
Greenfeed Data optimization solution with AWSGreenfeed's mission is to provide consumers with a clean food chain from farm to table with the 3F Plus process - FARM FEED FOOD. Read more>
RENOVA – STARTUP OI – SUCCESS STORYStartup Oi is a new social media and tech talent platform. Startup Oi has an ambitious goal to focus on professional needs of tech engineers and developers, building a digital community and connecting with job opportunities and tech events. Read more>
VIETCETERA – MIGRATION JOURNEY TO AWSFounded in 2016, Vietcetera is a first-of-its-kind multimedia digital platform producing editorial content along with video series and podcasts in both Vietnamese and English.Read more>
IMV – ON-PREMISE TO CLOUD JOURNEYInternational Minh Viet Joint Stock Co. is a distribution company which entails general trade, modern trade, as well as an e-commerce channel. Read more>
SmartPay Rehost and Replatform Migration on AWSSmartPay is an important contender in the Vietnamese payment apps landscape and experiencing growth with new vendors, partners, and users. Read more>
Pepsi Co Myanmar
Accelerate SAP S/4HANA Transformation With AWSPepsi Co Myanmar was looking to modernize their existing systems and launch a new platform for their users and applications utilizing the up-to-date technology solutions and choose SAP S/4HANA on AWS. Read more>
AWS Immersion Day with Nutifood GroupThe goal of this educational workshop was to empower N Group's IT team and leadership to confidently use the AWS platform for their benefit, and unlock new business opportunitiesRead more>
Serverless application implementation on AWS for Tadiran GroupTadiran is a leading technical and electrical appliances manufacturer company. Some of the company’s more famous product lines include batteries and air conditioners. Read more>
Scratchpay Security best practices and well-built architecture on GCPEvaluation and assessment of the existing GCP environment for best practices and well-built architecture methodologiesRead more>
UAB - Connect. Create. Change.
UAB BANK CLOUD NATIVE APPSAs a part of the modernisation and digitalisation strategy, UAB is expanding its services to build mobile apps for payment and e-Wallet purposes to serve the growing Myanmar consumer banking marketRead more>
Yoma Transformation to AWS CloudThe increasing demand for Yoma’s applications and business across different verticals requires to have a digital transformation journey with an effective migration to the cloud.Read more>
AQUA – Migration & CI/CDAQUA is able to improve operations as result of the migration and CI/CD on AWS as well as able to release new features faster with minimal time and disruption to the end users.Read more>
Sovigaz – migrating to AWSThe agility of the new infrastructure help Sovigaz to relieve the burden of on premise infrastructure management and limitations as well as access to advanced services offered on AWS platform. Read more>
Kaopiz’s Infrastructure AutomationAutomate the processes on AWS and create an environment to test new features to support the Development & QA team to deliver jobs faster, automated and without a deep level of experience and skills on AWS.Read more>
Navigos’ journey to the CloudAs part of the company commitment to it’s customers, it is essential to secure a robust disaster recovery process. Navigos’ application requires to have a fast and effective reaction in the disaster recovery scenarios.Read more>
Sabeco Case StudyHaving migrated to AWS, Sabeco is capable of quickly responding to increased traffic and services’ usage when necessary, making running marketing campaigns and launching new features less risky.Read more>
Nkid’s journey to the CloudNkid Group is running a number of Microsoft workloads in various environments including on-premises, local data center in Vietnam, Microsoft Azure and AWS.Read more>