• Contributed to the development of the Onyx big data platform, successfully offered to one of Ministry in Indonesia• Development of the Ministry Application• Assisting in the development of the database section of the ministry application• Performed data cleansing and transformation from database sources (PostgreSQL and Oracle) using Python and SQL before migration to Apache Hive and indexing in OpenSearch• Designed an optimal database architecture, utilizing aggregated query results with Apache Spark to avoid excessive reliance on either Hive or OpenSearch, ensuring faster application performance• Scheduled all daily queries and aggregated results, totaling nearly hundreds, using Apache Airflow to build a streamlined pipeline• Implement big data analysis with results integrated into the application using Apache Spark and Apache Zeppelin• Creation of Football Player Statistics Dashboard for one of biggest football club in Indonesia• Retrieved weekly data from the Sofascore website using the available API• Inserted the collected data into the OpenSearch index for dashboard creation• Executed data transformation from the point of data retrieval to indexing in OpenSearch• Managed the entire process using Apache Airflow, except for the dashboard creation in OpenSearch• Development of the Onyx Big Data Platform in the R&D Team to enhance the functionality and performance

• Work at Telkomsel Orbit under PT Kinarya Alihdaya Mandiri to analysing, profiling, and segmenting the early customer life cycle: acquisition and retention phase• Querying data and produce action-able insights for business-user regarding sales/campaign/performance/behaviour of customers• Generating weekly report that encompass modem sales, internet package sales, as well as tracking the number of RGB subscribers and their ARPU. These reports play a crucial role in monitoring and comparing week-on-week and month-on-month performance• Continue the CVM (Customer Value Management) program: • CVM or Customer Value Management is a strategic approach aimed at managing the relationship between the company and customers with a focus on increasing customer value over time as well as to gain revenue and customer retention • Help campaign team by providing all whitelist Orbit customers • Release hundred type of internet package for customer based on their behaviour • Delivering report and analysing customers behaviour to get their personal and relevant offers as main component to prepare another Orbit project

1. Numeric Methods and System Computation2. Microprocessor System