Curriculum Vitae

Berikut Pengalaman kerja dan Project yang pernah di lakukan

 Employment History

1) Bank Woori Saudara, TBK, Nov 2023 – Now

Work Description       :

  • Develop PL/SQL for ETL and Reporting Purpose
  • Maintenance Oracle Databases (backup, restore, partition, index,tuning)
  • Create and Monitoring ETL Process

2) PT J Resources Nusantara TBK, Data Analytic Specialist (Sep 2023- Agustus 2024)

 Work Description       :

  • Analysis Business Process for data warehouse purpose
  • Build Datawarehouse and datamart with SQL Server and Azure.
  • Create Business Intelligence Report with Power BI.
  • Maintenance Dashboard Business Intelligence in Qlik View.

3) Panin Bank, TBK, ETL and Datawarehouse Developer. (Sep 2013 – Sep 2022)

 Work Description       :

  • Build data warehouse, ETL process and report with Oracle Warehouse builder (OWB) and Oracle databases for Financial, Funding, Lending, Guava, Obligation and Credit Cards Data.
  • Build data warehouse, ETL Process and reporting with Informatica and PostgreSQL databases for PSAK and Risk Management Data.
  • Build data warehouse, ETL Process and reporting with SSIS SQL SERVER and SQL Server databases for Sales Management Data.
  • Build data warehouse, ETL Process and reporting with Talend for Regulatory BI Reporting Department.
  • Build DataMart Customer Profile using SSIS, SQL SERVER and Power BI
  • Create ETL Process and Report using PL/SQL, Stored Procedure and Excel Spreadsheets for other division.
  • Create automatic or schedule Job for ETL and reporting process windows Batch/Shell and Jenkins.

4) .PT QNB Indonesia TBK. MIS (Management Information System). Sep 2009 – 2013

 Work Description       :

  • Building data warehouse/datamart from data source which different format (dbf,textfile,excel) to databases SQL Server use Sql Script, DTS and foxpro programming.
  • Create Business Intelligence Report used IBM Cognos.
  • Create report (excel format) with Foxpro programming and VBA Programming
  • Create Schedule Jobs use windows Batch/Shell Script for all Datamart/Datawarehouse and reporting Process.           

5) Masterdata Kharisma Mandiri , System Programmer. July 2008 – June 2009

Work Description        :

  • Developing and Customize Application software using using Visual Foxpro and Sql Server databases, such as
    • GL module
    • Sales Order
    • Purchase Order
    • Return Order
    • Delivery Order
    • Inventory Management
  • Troubleshooting, Implementation, and training system.

6) PT Purwadhika, Programmer.  June 2006 – June 2008

Work Description        :

  • Create Application Software using using Visual Foxpro and Sql Server databases, such as
    • GL and Finance Module
    • Sales order
    • Purchase Order
    • Return Order
    • Delivery Order
    • Inventory and Product Management
    • Material and spare part Management
    • Car and motor Services
    • Certification
  • Troubleshooting, Implementation, and training system.    

Project