Equnix Business Solution | an Open Source and Open Mind Company

STATE-OWNED CLIENTS

PT. Bank Mandiri (Persero) Tbk

Established in 1998, Bank Mandiri was merged from 4 state banks. As the largest national bank in Indonesia, Bank Mandiri always put forward the services, integrity, and high performance for every transactions that run. These services are a support points in the community's life infrastructure both socially and business. SMS Banking, Electronic Wallet, Social Aid Fund, Online Banking Transaction, and other services are the main services of Bank Mandiri in order to provide high accessibility to audiences.

Bank Mandiri realizes that the infrastructure supported by Open Source technology can improve the quality of service, mainly because it is also supported by the Domestic Component Engineering which is the spirit of Indonesia nowaday. Equnix present to brings comfort and tranquility in implementing Open Source technology, especially on the database side, named PostgreSQL. For enterprise level Bank, data integrity and high transaction-capable services are always a key determinant, so Equnix always strives to provide the best local support to keep it up.

Currently Bank Mandiri implements PostgreSQL on many of its main systems, one of which is the supporting applications Mandiri Online and E-wallet, supported by Local Maintenance Services Equnix, kept 24 hours a day, 7 days a week and 365 days a year. Equnix is always ready to deal with potential risks that may occur, ranging from telephone consultation to arrival for intensive improvement. Going forward, Bank Mandiri will continue to prepare the foundations for key and critical applications using PostgreSQL databases and Equnix is ready to provide a peace of mind for the data-backing infrastructure.

Telkomsel

Telkomsel is one of the biggest telecommunication companies in Indonesia. Operating since 1995 as part of Telkom Indonesia to provide cellular communication in Indonesia, Telkomsel has already had more than 150 million customers and covers around 288 international roaming in 155 countries by the end of 2007.

Equnix provided full Premium Maintenance Support for PostgreSQL implementation on 2 data centers in Telkomsel in 4 different instances using High Availability configuration within sites and between sites. PostgreSQL instances are used to support global Identity Management applications for critical services on Telkomsel. By using HA within site, when Master is down, Standby server will be ready anytime to take over the database services. And if the Main Site is down, Backup Site will take over the whole Production cluster and database access will be altered automatically to the promoted site.

PT Pelabuhan Indonesia II (Persero)

PT Pelabuhan Indonesia II (Persero),

PT. Pelabuhan Tanjung Priok (PTP)

Conveniently located in North Jakarta, Port of Tanjung Priok (PTP) is the busiest port in all of Indonesia. This port handles more than 30% of Indonesian non-oil commodities, alongside 50% of the entire flow of goods in/out Indonesia through this large port. Therefore Tanjung Priok is a barometer of Indonesia's economy.

The magnificent complete intermodal facility in the Port of Tanjung Priok is able to connect with the entire city in Indonesia. Having modern technology and facilities, Tanjung Priok has been able to serve ships of the latest generation which proceeds directly to various international trade centers (direct call).

PTP has been developing a Business Intelligence (BI) application to increase the ease of monitoring all data. Equnix is turning up to provide a Data Warehouse (Deepgreen) solution as a data storage medium used by BI applications. Deepgreen is a powerful Data Warehouse application where it can be proved that BI applications running on top of Deepgreen up to now have no problems either in terms of performance or others. This is the basis that PTP is satisfied with the services provided by Equnix.

PT. Kimia Farma Tbk.

PT Kimia Farma (Persero) Tbk, usually called Kimia Farma, has developed into an integrated health care company in Indonesia. Kimia Farma Healthcare business is supported by pharmaceutical manufacturing, research, and development, distribution and trading, marketing, pharmaceutical retail, as well as clinical laboratories and health clinics.

Equnix Team is present to provide solutions and specific optimizations for Kimia Farma's Point-of-Sale database. This database is used by Kimia Farma stores throughout Indonesia. The Equnix team implemented High Availability to support the database system to remain accessible. Equnix also provides several solutions related to applications so that they can access the database precisely which increases the performance of the application itself.

PT Kereta Commuter Indonesia (KCI)

PT Kereta Commuter Indonesia (KCI), a subsidiary of PT Kereta Api Indonesia, provides transportation services to commuters in Indonesia. In 2013, KCI implemented an electronic ticket system based on electronic money cards, which significantly increased the average number of passengers transported per day. However, with high traffic, KCI needed to maintain the E-Ticketing database to ensure the smooth operation of the electronic ticketing system. To achieve this, a comprehensive assessment of the system was necessary to identify areas for improvement and optimize future maintenance.

In December 2022, Equnix conducted an assessment of the entire existing system at KCI, from data entry through the gate to the central database (SOTC). The assessment revealed opportunities to increase efficiency in the current system, including data structure and topology. The assessment also identified problems such as a lack of archiving and housekeeping, issues with floating money data, and database corruption.

Based on these findings, Equnix proposed a solution with several stages to improve the system's performance and efficiency. The proposed improvements were prioritized to address critical issues and optimize the E-Ticketing system's operation. With the implementation of these improvements, KCI will be able to maintain its electronic ticketing system based on electronic money cards and continue to provide reliable and efficient transportation services to its passengers.

PT PLN (Persero)

PLN Mobile was launched to provide a convenient way for users to access PLN's services, including electricity, internet, repairs, and information on Public Electric Vehicle Charging Stations. Since its launch, the application has been downloaded by over 35 million users, making it one of the most widely used mobile applications in Indonesia.

To ensure that the PLN Mobile application can handle the large number of users and provide reliable services, PLN initiated an assessment of the system handled by the Expert: Equnix Business Solutions, PT, particularly on the database side. The assessment revealed several opportunities to optimize the performance and efficiency of the current system, including slow query optimization, data structure optimization, and INDEX optimization.

To address these issues, PLN implemented various stages of improvement, such as optimizing the database configuration and creating a new indexing strategy. PLN also introduced an OLAP database to manage old data, which helped to reduce the size of the OLTP database and improve system performance.

These improvements have resulted in a more stable and efficient PLN Mobile application, allowing PLN to provide better services to its users. The success of the PLN Mobile application has also demonstrated PLN's commitment to digital transformation and providing convenient and reliable services to its customers.