Our Works

We are committed to continuous learning and research, to stay relevant and innovative.

Sraya App

Sraya is a Human Resources Information System (HRIS) designed to empower HR professionals and organizations of all sizes to streamline their employee management processes with efficiency and precision.

MandiriCuan App

MandiriCuan is our ultimate companion app designed exclusively for salesmen at bank companies. MandiriCuan empowers salesforce to efficiently record and validate data from UMKM and businesses that have joined the banking ecosystem.

DayCare App (Toddler School)

An essential app tailored for teachers to streamline toddler data management in schools and daycares. It simplifies lesson planning, subtopic creation, report generation, and task assignments, enhancing the educational experience with efficient technology and straightforward processes.

Kenari App (Mining)

This powerful app streamlines the recording of crucial data in mining operations, including maintenance records, E-Stop incidents, and K3 safety data. Kenari App empowers mining professionals to manage their operations efficiently and maintain the highest standards of safety and compliance.

Apta System Medical Record

A web desktop application for patient medical records, which is a comprehensive and secure digital platform designed to efficiently manage and organize patients' health information.

Palmtech (Oil Palm Company)

Transform palm oil operations with Palmtech! Seamlessly integrate weighbridge, grading, and lab results into one streamlined application. Enjoy real-time, centralized monitoring from anywhere with our robust local and cloud server integration.

Input Case Management App

Developing a web application for law enforcement — police, prosecutors, judges, and wardens — to integrate and trace case data from investigation to verdict. The system includes an analysis dashboard, streamlining data management and enhancing case tracking efficiency.

Bank Marketing Master Data

We created a robust ETL process for BANK's marketing team, generating comprehensive tables. This data pipeline integrates sources, providing up-to-date, structured information for effective campaigns and strategies.

Material Store's Data Warehouse

We developed a data warehouse to empower building material stores and distributors, providing accurate, actionable information. This tool supports management decisions and ensures continuous, reliable access to critical data for effective business operations.

Previous Page 3 of 6 Next

Routing Optimization

Routing optimization improves logistics by solving manual scheduling issues. This technology considers multiple factors to efficiently plan the number of vehicles and their departure times, avoiding scheduling conflicts and enhancing overall efficiency.

Raw Material Optimization

Manual production scheduling in factories is cumbersome and inefficient. Our solution automates this process: users upload a single file, and the web server generates optimized schedules based on predefined rules and sequences, ensuring efficient production and inventory management.

Planogram Detection

This web application extracts and processes photos from shop owner devices daily, using AI for object detection. It scores compliance with product display rules, rewarding shop owners who meet standards, ensuring efficient monitoring and incentive distribution.

Customer Personalization Survey

Do RFM analysis and segmentation for customer data. The product of this project is deployed in web app with dashboard for serving information and simulate how to target and how many customers for blasting messages.

Advanced Product Supply Forecasting

Predicting next year's weekly product supply needs by analyzing stock levels and air freight additions. Utilizing calculation formulas to project various scenarios, adapt forecasts with international team input, and display results in a Power BI dashboard for clear insights.

Pricing Dynamic

Simulate price impacts on revenue and margin using last year's retail data. Our web app dashboard predicts sales, revenue, and margin changes over time and by region, providing detailed insights into pricing dynamics and their effects.

Material Readiness Prediction System

Predicting tobacco material readiness by consolidating and analyzing data from multiple Excel files. The application processes inputs, calculates readiness, and segments results by region and responsible person, providing daily and weekly forecasts for streamlined material management.

Advanced Data Analytics with Snowpark

We have created a data analytics solution using Snowpark in Snowflake. This system enables exploratory forecasting and delivers in-depth insights and predictive analytics, enhancing decision-making with advanced data analysis capabilities.

Branch Recommendation and Review

We recommend sites for new branches by analyzing data on existing branch coverage and customer distribution. This ensures strategic placement that effectively serves the target area and maximizes customer reach.

Previous Page 1 of 2 Next

Residential & Landbank Dashboard

We created four key dashboards for executive reports: Residential Summary, Residential Detail, Landbank Summary, and Landbank Map. The Residential report analyzes sales components and market trends, while the Landbank dashboard tracks property availability, inventory, and management.

AS400 Data Interface via Tableau Server and HUE

OJK mandates no direct AS400 queries, so an interface through Tableau Server and HUE was developed. This AS400 project delivers summary information via Tableau dashboards, meeting requirements from Bank Mandiri's Head Office and Regional Offices, ensuring ongoing management utility.

Performance Evaluation Dashboard for Smartbranch

With new Smartbranch locations, Bank Mandiri needs to assess their performance. The dashboard tracks metrics for each branch’s digital services, including online and mobile banking. It scales to area and regional views, with data restricted to authorized users.

Previous Page 2 of 2 Next

Bank Marketing Master Data

We created a robust ETL process for BANK's marketing team, generating comprehensive tables. This data pipeline integrates sources, providing up-to-date, structured information for effective campaigns and strategies.

Material Store's Data Warehouse

We developed a data warehouse to empower building material stores and distributors, providing accurate, actionable information. This tool supports management decisions and ensures continuous, reliable access to critical data for effective business operations.

Enterprise Data Warehouse for Iron Factory

We created a data warehouse for iron factories using the Data Vault method on Azure SQL Server. This setup ensures seamless integration with Power BI, providing robust data management and insightful analytics for efficient business decision-making.

DIM Toolbox for Optimal Inventory Management

The DIM Toolbox calculates optimal Days of Inventory (DOI) for effective stock management. By integrating safety time, in-transit inventory, cycle time, and market factors, it provides precise DOI estimates, helping companies maintain predictable and efficient inventory levels.

RRP Exception Automation System

RRP Exception Automation streamlines repetitive tasks in RRP Exception reporting. It automates file synchronization from SFTP cloud, executes Python scripts, retransmits messages, notifies stakeholders, and logs activities, simplifying monitoring and enhancing efficiency.

Centralized Data Warehouse for Sustainable Forestry in Indonesia

We have created a complete data warehouse for the Ministry of Forestry in Indonesia, integrating data from multiple APIs and databases into a centralized repository. This solution streamlines data management and retrieval, enhancing the ministry's decision-making efficiency.

Data Automation System for Robocorp

We have developed a data automation system for Robocorp using Robocorp Python. This solution automates data extraction, transformation, validation, and reporting, improving data quality and efficiency. It supports Robocorp in delivering enhanced services through streamlined workflows.

Data Integration and Automation using Prefect

We have developed a data integration and automation system using Prefect, utilizing Prefect Python. This solution integrates data from APIs, databases, files, and web pages, automates tasks like cleaning and reporting, and enhances data reliability and productivity.

Lending and Funding DWH with Visualization

We developed a data warehouse for lending and funding data using SSIS and SQL Server. After building the warehouse, data is visualized with Tableau, providing clear insights into funds, loans, and balance sheets for better decision-making.

Page 1 of 1

High Availability Tableau Server Installation

We installed, configured, and monitored a three-node Tableau Server, ensuring high availability and scalability. This setup supports interactive data visualization with load balancing, enabling HA Development to deliver effective and reliable data insights.

Technical Support for Tableau Server Integration and Security

We provide technical support for Tableau Server maintenance, troubleshooting, and configuration, ensuring seamless connection with apps and databases in Client's environment. We configured and tested Kerberos for secure data connections, ensuring integrity, confidentiality, and access control across SQL Server, Oracle, and Hadoop.

IIS Stack Maintenance and Monitoring using Dynatrace

We integrated Dynatrace with the IIS stack to enhance software performance monitoring. This setup leverages Dynatrace's capabilities for detailed application insights, ensuring efficient management of IIS-based applications by automating performance tracking, issue detection, and optimization.

Integration of Azure DevOps and SonarQube

We integrated Azure DevOps and SonarQube to streamline software development and quality management. Azure DevOps handles planning, coding, testing, and deployment, while SonarQube analyzes code quality and security, automating code analysis and deployment for reliable software management.

Page 1 of 1

WBMS Web App

Developing a web application for seamless vehicle entry management at weighbridge areas, integrating QR code usage, portal management, and CCTV monitoring for enhanced control and efficiency.

Sraya App

Sraya is a Human Resources Information System (HRIS) designed to empower HR professionals and organizations of all sizes to streamline their employee management processes with efficiency and precision.

MandiriCuan App

MandiriCuan is our ultimate companion app designed exclusively for salesmen at bank companies. MandiriCuan empowers salesforce to efficiently record and validate data from UMKM and businesses that have joined the banking ecosystem.

DayCare App (Toddler School)

An essential app tailored for teachers to streamline toddler data management in schools and daycares. It simplifies lesson planning, subtopic creation, report generation, and task assignments, enhancing the educational experience with efficient technology and straightforward processes.

Kenari App (Mining)

This powerful app streamlines the recording of crucial data in mining operations, including maintenance records, E-Stop incidents, and K3 safety data. Kenari App empowers mining professionals to manage their operations efficiently and maintain the highest standards of safety and compliance.

Apta System Medical Record

A web desktop application for patient medical records, which is a comprehensive and secure digital platform designed to efficiently manage and organize patients' health information.

Palmtech (Oil Palm Company)

Transform palm oil operations with Palmtech! Seamlessly integrate weighbridge, grading, and lab results into one streamlined application. Enjoy real-time, centralized monitoring from anywhere with our robust local and cloud server integration.

Input Case Management App

Developing a web application for law enforcement — police, prosecutors, judges, and wardens — to integrate and trace case data from investigation to verdict. The system includes an analysis dashboard, streamlining data management and enhancing case tracking efficiency.

Page 1 of 1

Branch Recommendation and Review

We recommend sites for new branches by analyzing data on existing branch coverage and customer distribution. This ensures strategic placement that effectively serves the target area and maximizes customer reach.

Palm Oil Detection Classified by Ripeness

Creating a computer vision model that can classify oil palm fruits based on their ripeness levels (ripe, unripe, underripe fresh, underripe leftover, overripe), and perform fruit detection, tracking, and counting.

GPT + Enterprise Data with Azure OpenAI and AI Search

We develop ChatGPT-like experiences over your own data using the Retrieval Augmented Generation pattern. It uses Azure OpenAI Service to access a GPT model (gpt-35-turbo), and Azure AI Search for data indexing and retrieval.

OCR Technology for Invoice Data Extraction

Using OCR technology, our system extracts text and numbers from invoices, transforming them from physical documents into analyzable datasets. This enables efficient processing and analysis of invoice data for better insights and management.

Isochrone Maps for Points of Interest

Isochrone maps show areas reachable from a specific location within a set travel time. This tool helps users assess travel distances to hotels, restaurants, and other amenities, aiding in activity planning and optimizing travel time.

Forest Location App for Plantation Compliance

The Forest Location App identifies whether a plantation is within restricted forest areas as per forestry regulations. This tool ensures compliance by pinpointing the exact location of plantations to verify adherence to ministry guidelines.

Analyzing Population Growth with Geospatial Machine Learning

Using temporal population data, we apply machine learning to analyze population growth in specific areas through geospatial techniques. This approach provides insights into demographic trends and patterns, enhancing area-specific planning and decision-making.

Satellite Imagery Analysis for Palm Oil Tree Monitoring

Researching satellite imagery to detect and count objects in palm oil farms. Analyzing key features such as tree height and crown width to determine age and maturity, providing valuable insights for farm management and crop assessment.

Car Plate Recognition with Image Detection

We use image detection technology to identify and extract car license plates. This solution enhances vehicle identification accuracy by processing and analyzing images to accurately capture plate details.

Page 1 of 1

SAP ABAPER Support

Aptaworks collaborates as a supporting partner in SAP ABAPER operations, assisting Senior ABAPers in developing function modules and creating essential forms like material documents, Dialog Programs, and Smart Forms.

Fiori App Development

Aptaworks developing Fiori applications, leveraging their expertise to enhance user experience and streamline business processes through modern SAP Fiori technology.

SAP S4/HANA 2023 Cloud Private

Aptaworks as a strategic partner in the implementation of SAP S4/HANA 2023 Cloud Private, bringing expertise in SAP technologies to drive digital transformation and enhance operational efficiency across the organization.

Page 1 of 1