Portofolio

Berikut Pengalaman kerja dan Project yang pernah di lakukan

 Employment History

1) Panin Bank, TBK, ETL and Datawarehouse Developer. (Sep 2013 – Present)

 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.

2) .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.           

3) 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.

4) 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.    

5) Asistama Nugrama Solusindo, Technical Consultant . Feb 2005 – May 2006

Work Description        :

  • Create Application and Report for Plantation Company using Magic Developer
  • Troubleshooting, Implementation, Installation, and training system.

Project