Analytics Engineer

• Sep 2015 - Present

Responsibilities: • Plan, create, coordinate, and deploy Data Solution. • Create & Execute best practices for ETL process. • Create & Execute DWH modeling • Create Report based on requirement • Perform analysis of Data • Monitor the systems and integrity and maintenance as required. Project: 1. PT Bank Perkreditan Rakyat Karyajatnika Sadaya (Data Warehouse & Business Intelligence 09/2015 – 02/2016) > ETL : IBM Datastage Infosphere, SQL > BI : IBM Cognos Analytic > Database : IBM DB2 > OS : Redhat Linux 2. Card Bank, Inc (Data Warehouse & Business Intelligence 10/2016 – 05/2017) > ETL : Pentaho Data Integration, SQL > BI : IBM Cognos Analytic > Database : IBM DB2, PostgreSQL > OS : Redhat Linux 3. Card MRI Rizal Bank, Inc (Data Warehouse & Business Intelligence 07/2018 – 12/2018) > ETL : Pentaho Data Integration, SQL > BI : IBM Cognos Analytic > Database : IBM DB2, PostgreSQL > OS : Redhat Linux 4. Card SME Bank, Inc (Data Warehouse & Business Intelligence 03/2019 – 09/2019) > ETL : Pentaho Data Integration, SQL > BI : IBM Cognos Analytic > Database : IBM DB2, PostgreSQL > OS : Redhat Linux 5. PT Bank CTBC Indonesia (Antasena – Regulatory Reporting 09/2019 – 04/2020) > ETL : Pentaho Data Integration > Database : PostgreSQL, SQL Server, Teradata > OS : Redhat Linux, Windows Server 7. PT Bank BTPN Tbk (Master Data Management 05/2020 – 08/2020) > ETL : Talend Big Data, SQL, Stored Procedure > Database : Hive, SQL Server, Oracle > OS : Redhat Linux 8. PT Bank BTPN Tbk (Loan IQ Finastra & Doka Ng Trade Finance Implementation 04/2021 - 01/2023) > ETL : Airflow, Talend Big Data, Python, SQL, Stored Procedure > BI : Tableau > Database : Hive, SQL Server, MySQL > OS : Redhat Linux 9. Bank SBI Indonesia (Antasena, SLIK – Regulatory Reporting 02/2023 - 06/2023) > ETL : Talend Data Studio > Database : SQL Server 10. Bank Sahabat Sampoerna (ODS Fraud Management System - Present) > ETL : Talend Big Data > Database : Postgresql Show less