Looking for a job

Sandy Aprilyanto

@sandyaprilyanto1

Marketing Data Analyst at PT Prima Tunggal Mandiri, reconciling sales data and building Excel reports to monitor performance.

Indonesia

Message

What I'm looking for

I'm currently open to remote Data Analyst opportunities.

At PT Prima Tunggal Mandiri, I monitor sales performance and outlet activity across three distribution depots to support sales analysis and marketing decisions. I analyze GWP, SAGA, and BCIWS program performance, reconcile data from Accurate and ODOL, and develop Excel reporting for sales, outlet, and promotional data.

Previously, I worked as a Data Analyst at Department of Communication and Informatics, where I developed a rainfall forecasting model and deployed interactive Power BI dashboards for regional budgets, commodity prices, and demographics. As an Application Developer intern at Department of Marine Affairs and Fisheries, Agriculture and Food, I developed a Java desktop application and implemented a MySQL database with SQL triggers and scheduled events.

Experience

Work history, roles, and key accomplishments

Current

Marketing Data Analyst

Current

PT Prima Tunggal Mandiri

Jun 2026 - Present (5 months)

Monitor sales performance and outlet activity across 3 distribution depots, supporting sales analysis and marketing decisions.

Analyze 3 marketing program areas GWP, SAGA, and BCIWS to track program execution and performance.

Reconcile data from 2 operational systems, Accurate and ODOL, to identify order and sales discrepancies.

Develop Excel-based reporting to consolidate sales, outlet, and pr

Data Analyst

Department of Communication and Informatics

Jan 2025 - Mar 2025 (2 months)

Weather Forecasting Model: Engineered an LSTM time-series model (Python, TensorFlow) to predict 30-day rainfall fluctuations, achieving a 6.01 mm MAE by optimizing Huber Loss for extreme weather anomalies.

Public Policy Dashboards: Extracted and transformed complex regional datasets to deploy 10+ interactive Power BI dashboards, accelerating data-driven decisions regarding Regional Budgets (APB

Application Developer

Department of Marine Affairs and Fisheries, Agriculture and Food

Aug 2024 - Dec 2024 (4 months)

Java Desktop Application: Developed a Java-based desktop application utilizing the MVC (Model-View-Controller) architecture to streamline the management and input process of auction, vessel, and retribution data.

Database Architecture: Designed and implemented a MySQL database to seamlessly manage auction transactions, vessel data, buyers, and retribution tariffs.

Data Integrity & Storage Optimi