• May 2019 - Present

Project: Automation DatawarehouseClient: Telkomsel (Indonesian Telecommunication Operator) Mei 2019 - December 2021● Build and manage databases for storing, processing, analyzing data using PostgreSQL & SQL Server● Collect raw data from various formats (csv, excel,text, database table & JSON) and from various sources (FTP, sFTP, oracle DB, Hadoop DB, Sybase DB, MySQL DB, MySQL server DB, click house DB & PostgreSQL DB ) ● Perform data parsing and cleansing: formatting data_type, removing duplicate data, removing trailing/leading characters, etc.● Combined raw data from various sources into desirable data.● Build cluster DB for the data source, data processing, and datamart. ● Build automation to backup DB for every month. ● Perform data aggregation in SQL: grouping, sum, max, min, join, union, etc. ● Build automation using scheduler agent for : collecting data from various sources, cleansing data, combining data, and aggregating data. So all processes done by scheduler agent● Build Automate ETL (Extract, Transform, Load) processes using python script, Pentaho, SSIS and Apache Airflow.● Perform data verification,data comparison and data validation.● Make automation reports daily and hourly and monitoring reports with integration between excel and SQL Server● Make system monitoring for data quality with Telegram blast message Show less

• May 2021 - Jul 2021

Project : Map Visualisation and Monitoring Performance RadioClient : Telkomsel (Indonesian Telecommunication Operator) Mei 2021 - Juli 2021● Build table, view, function and procedure contains PostGIS function● Build a strong query to fulfill requirement client● Combined raw data from various sources into desirable data.● Perform data aggregation in SQL : grouping, sum, max, min, join, union, etc. ● Build Automate ETL (Extract, Transform, Load) processes using python script● Perform data verification ,data comparasion and data validation.● Make system monitoring for data quality with Telegram blast message Show less

Technical Support Engineer

• May 2017 - May 2019

Project : Technical Support Telkomsel Network Division Client : Telkomsel (Indonesian Telecommunication Operator) Mei 2017 - Mei 2019 ● Collecting Data Radio Network using each tools ● Reporting KPI Performance, Accessibility, Retainability, and Productivity (Daily, Weekly, Monthly) ● Create stored procedure and function from the database server (SQL Server 2012) to do query results for every regular report ● Data validation for all technology and all vendor Project : Technical Support Telkomsel Network Division Client : Telkomsel (Indonesian Telecommunication Operator) Mei 2017 - Mei 2019 ● Collecting Data Radio Network using each tools ● Reporting KPI Performance, Accessibility, Retainability, and Productivity (Daily, Weekly, Monthly) ● Create stored procedure and function from the database server (SQL Server 2012) to do query results for every regular report ● Data validation for all technology and all vendor