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
- 2021 : Build Smart Aquarium Based on IOT (Internet of thing) with Arduino, App Inventor, Php and Mysql
- 2021 : Build Customer Segmentation Using Machine learning Mini Batch K-Means and Business Intelligence (Phyton, SQL server, Power BI)
- 2014 : Build Learning Application Apps with Android Studio (Java)
- 2013 : Build Appraisal System using Php and Mysql
- 2004 : Create Ebook Multimedia with Macromedia Flash
- 2003 : Create student report application with Visual basic and Ms. Access