ITERA - ETC
Home / Data Analytics

Data Analytics

EDW (Enterprise Data Warehouse) data analysis and warehousing system

Enterprise Data Warehouse (EDW) solutions are designed to build a centralized data analytics platform, helping organizations transform into a data-driven operating model. This solution overcomes the limitations of legacy systems (such as low performance and poor scalability) by applying advanced technology, ensuring fast processing speeds, high reliability, and the ability to integrate diverse data sources.

EDW (Enterprise Data Warehouse) data analysis and warehousing system

THE SOLUTION INCLUDES

  • SAP IQ

    As the primary database after comparison with Oracle Exadata and IBM Netezza

  • Data model

    Designed and optimized by TechMahindra to take full advantage of SAP's capabilities.

FEATURES OF THE SOLUTION

  • Superior processing speed

    SAP IQ processed data 10 times faster than Oracle Exadata and IBM Netezza in real-world tests.

  • Powerful data compression

    Reduced data size from approximately 1 PB (petabyte) of raw data to just 40 TB (after deduplication and compression).

BENEFITS OF THE SOLUTION

  • The solution significantly accelerated data processing, with SAP IQ delivering performance up to 10 times faster than the previous system, reducing report processing time from several hours to just a few minutes. In terms of storage capacity, the solution efficiently compressed data from approximately 1 petabyte of raw data down to 40 terabytes, resulting in substantial storage cost savings. Importantly, the solution completely overcame the limitations of the old system, becoming a stable and reliable data platform for the bank from 2014 to the present. The project's success was further recognized with the "Best Data Analytics Project in Vietnam" award from The Asian Banker in 2018.

Solutions for building a core securities system.

Core Securities solution is a modern securities trading platform developed to replace legacy systems at banks, helping banks' securities trading systems improve transaction processing capacity and meet the increasingly complex demands of the market. The solution inherits advanced technology from international partners, is optimized for the domestic market, and ensures high stability, speed, and security.

Solutions for building a core securities system.

FEATURES OF THE SOLUTION

  • Supports a wide variety of transaction types.

    Modern trading with a full range of securities types (underlying securities, derivatives, bonds) with fast transaction processing speeds, capable of handling large volumes.

  • Powerful system integration

    Seamless integration with Core Banking systems, the Vietnam Securities Depository (VSD), data migration, and certification testing with all three stock exchanges in Vietnam.

  • Security and compliance

    The multi-layered security architecture meets international standards and fully complies with the regulations of the State Securities Commission and the stock exchanges.

BENEFITS OF THE SOLUTION

  • Core Securities solutions help banks enhance their competitiveness through a stable, high-speed, and flexibly scalable securities trading system. With deep integration into the banking system and the Securities Depository Center, the solution optimizes clearing and settlement processes, minimizes risks, and improves customer experience. The system also ensures strict compliance with legal regulations, helping businesses avoid legal and reputational risks. Thanks to modern technology, the solution supports the automation of business processes, reduces operating costs, and increases work efficiency.

Data Lake/Lakehouse

Data Lake/Lakehouse

Lakehouse – a global enterprise data warehouse – is the data backbone that helps banks transform data into trusted products for reporting, operations, and AI.

The bank-wide unified data platform collects data in batches as well as in real time, processes it in layers of the lakehouse, stores high-quality data in the data warehouse, and organizes semantic layers with unified metrics. The platform supports business domain data products with self-service reporting systems, near-real-time queries, and data analytics using AI machine learning technology.

Data will be collected from all critical systems within the bank, as well as other linked sources, to enable comprehensive, multi-dimensional, accurate, and timely information aggregation and analysis. This is especially important during the transition of large, complex systems that require continuous operation, such as core banking and payment card systems, as well as ensuring a consistent, 360-degree view for customers at all times.

  • The platform is capable of receiving and integrating data from multiple sources using a variety of methods and formats.
  • Data is stored long-term in the modern Lakehouse architecture, optimized for processing and exploitation.
  • Data processing and transformation systems operate continuously – from standardization and aggregation to analytical modeling and the calculation of management metrics.
  • Simultaneously, the platform handles the management of master data, ensuring consistency and uniformity throughout the entire system.
  • Data governance includes metadata management, data quality, traceability, and data monitoring.
  • Integrating machine learning and artificial intelligence (AI/ML) platforms, the system offers advanced analytical capabilities, trend forecasting, and strategic decision-making support.
  • Finally, the visual data mining layer provides quick bulletin boards, intelligent reporting, and data query connectivity.
  • The entire platform is built on a robust, scalable storage infrastructure, along with backup mechanisms, information security, and multi-layered protection, ensuring that data is always safeguarded.

MIS/DW converter

This solution focuses on building, optimizing, or modernizing the entire data infrastructure and architecture to deliver accurate, timely, and comprehensive management information systems (MIS).

Data centralization

Data Centralization

Consolidating data from multiple source systems (ERP, CRM, specialized applications, etc.) into a single centralized data warehouse ensures consistency and reliability.

Data centralization

Decision Support

Transforming raw data into dynamic management information systems (MIS) reports, in-depth analysis, and predictive models helps management gain a multifaceted perspective, enabling timely strategic and operational decision-making.

Data centralization

Performance Optimization

Applying new technologies (such as Cloud Data Warehousing, Data Lake, and Data Mesh architecture) to improve query speed, process big data, and minimize operating costs.

ETC's Main Services

Data Architecture Consulting

Data Architecture Consulting

Assess the current situation and design an optimal MIS/DW architecture, including selecting a suitable technology platform (On-premise, Cloud: AWS, Azure, Google Cloud, OCI,...) and data model.

Data Warehouse Deployment

Data Warehouse Deployment

Develop an automated and efficient data extraction, conversion, and loading (ETL/ELT) process, ensuring data quality.

Modernizing the System

Modernizing the System

Transform outdated, low-performance MIS/DW systems into modern architectures that leverage the power of cloud computing and advanced data processing tools.

Developing Management Reports

Developing Management Reports

Build dashboards and reports (using leading BI tools such as Power BI, Tableau, Oracle Analytics, etc.) to meet the specific management needs of each department and leadership level.

Business Intelligence (BI) Systems and Big Data Analytics

This solution transforms Data Warehouses (DWs) into a competitive advantage, providing powerful analytical tools and techniques to uncover trends and insights hidden within data.

Business Intelligence (BI)

It provides data visualization tools and interactive dashboards, enabling end users to easily explore data and track business performance in real time (KPIs monitoring).

Big Data Analytics

Processing and analyzing large, complex datasets (Big Data) to find predictive models, segment customers, optimize supply chains, and detect fraud.

Forecast and Action

Develop Machine Learning and Artificial Intelligence (AI) models to make accurate business predictions and automate response actions.

ETC's Main Services

Setting up a BI platform

Deploy leading BI tools and connect to the Data Warehouse.

Building a Big Data platform

Deploying distributed platforms (or Cloud-native architecture for Data Lakes).

AI/ML Application Development

Develop and integrate forecasting models (e.g., demand forecasting, risk forecasting) into business processes.

Enterprise Service Hub (ESB) and API Management

This is the "central nervous system" that connects applications, partners, and services, ensuring the flexibility, scalability, and speed of the IT architecture.

OBJECTIVES & CORE VALUES

API Management

API Management

Transform business functions into reusable, tightly managed services (APIs) with security, throttling, and performance monitoring.

Flexible Integration (ESB)

Flexible Integration (ESB)

This allows legacy and new systems to communicate with each other without changing the code of each application, through standardized protocols and data formats.

Accelerate Digital Transformation

Accelerate Digital Transformation

Providing the infrastructure to quickly build and launch new digital products by integrating existing services (API Economy).


ETC's Main Services

Microservices Architecture Consulting

Microservices Architecture Consulting

We support businesses in transitioning from monolithic architecture to microservices-based architecture to accelerate development and deployment.

Setting up an API Gateway

Setting up an API Gateway

Build an API gateway to centrally manage access, security (OAuth, JWT), and monitor all APIs.

Implementing the Integrated Platform (ESB/Middleware)

Implementing the Integrated Platform (ESB/Middleware)

Set up an integration platform (e.g., Oracle Integration Cloud, Mulesoft, Apache Kafka) to handle complex and high-volume transaction flows.