Download PDF

Galang Adhi Nugroho

EDW - IBM Cognos BI - ESRI ArcGIS Specialist

Summary

Having over 7 years of experience working on Business Intelligence and Datawarehouse. Strong proficiency in the full life cycle Business Solution Development in Analysis, Design, Develop and Impelement.

Strong knowledge in DB Concepts, BI Concepts, DW Concepts, SQL, Integration, OLTP, OLAP, Dimensional also Normalize Relational Databases, Reporting and Analytics.

I have worked as BI/DW Architect to help people organize their data in a way that easy to understand.

Now, I am working as BI Reports and Analytics to help people decided what suitable for their organization.

Experiences

Apr 2016 Present

Management Information System Officer

PT Bank Muamalat Indonesia Tbk.

As an MIS Officer my responsibilities are:

  • Maintain existing Information System (Data, Integration, Report, Model, Process, Performance and etc) 
  • Perform data analysis for generating reports on periodic basis
  • Analyze business information to identify process improvements for increasing business efficiency and effectiveness
  • Provide strong reporting and analytical information support to management team
  • Generate and distribute management reports in accurate and timely manner
May 2011 Mar 2016

Business Intelligence Consultant

PT Magna Solusi Indonesia

As a Business Intelligence Consultant my responsibilities are:

  • Definition of strategies and roadmaps to implement Business Intelligence solutions
  • User requirements gathering, design, modelling and implementation of leading Business Intelligence Solutions
  • Designing and implementing Technical and Operational Architectures
  • Designing and implementing ETL, Data Integration, Data Quality, Data Conversion, Data Modelling and Data Architecture
  • Generate and distribute management reports in accurate and timely manner

Tools and Competencies

DB

  • Microsoft SQL Server
  • DB2
  • ORACLE
  • PostgreSQL
  • IBM Netezza

 

ETL

  • Microsoft SQL Server Integration Services - SSIS
  • IBM Datastage
  • IBM Change Data Capture for Datastage - CDD

 

Reports, Dashboard and Analytcs

  • Microsoft SQL Server Reporting Services - SSRS
  • Microsoft SQL Server Analysis Services - SSAS
  • Microsoft Power BI - PBI
  • IBM Cognos BI and Analytcs
  • Tableu Desktop
  • ESRI ArcGIS

Projects

Dec 2017Present

Muamalat Geospatial Information System (MGIS)

PT Bank Muamalat Indonesia Tbk.
  • Description : Spatial Analytics and Imagery for Muamalat Core Banking (MCB) 
  • Role : 
    • Project Manager
    • Technical Lead
  • Responsibility : 
    • User requirement
    • Analyze functional design
    • Prepare technical documentation 
    • Coordinate internal and third parties/vendors
    • Developing project scopes and objectives
    • Test
    • Deploy
  • Database  
    • IBM  Netezza
    • PostgreSQL
  • Tools : ESRI ArcGIS Software 
  • Server : Windows Server 2012
Jun 2017 Nov 2017

Muamalat Chief Finance Officer Report and Dashboard Project

PT Bank Muamalat Indonesia Tbk.
  • Description : Dashboard and Analytics for Chief Finance Officer 
  • Role : BI Reporting and Analytics 
  • Responsibility : 
    • User Requirement
    • Analyze Functional Design
    • Prepare Technical Design
    • Develop
    • Test
    • Deploy
    • Support
  • Database : IBM Netezza 
  • Tools : IBM Cognos Analytics 11
Nov 2015May 2016

AHM BI Customer Analysis

Astra Honda Motor
  • Description : Customer Dashboard and Analytics for Business 
  • Role : 
    • Technical Lead
    • BI Developer and Support
  • Responsibility : 
    • User Requirement
    • Analyze Functional Design
    • Prepare Technical Design
    • Develop
    • Test
    • Deploy
    • Support
  • Database : Microsoft SQL Server 2012 
  • Tools : Microsoft Power BI
Sep 2015Nov 2015

BI CCAI

Coca Cola Amatil Indonesia
  • Description : Business Intelligence for CCAI Dept
  • Role : BI Developer and Support
  • Responsibility : Develop Data Warehouse and BI using Microsoft BI Technology with Web Apps
    • Analyze Functional Design
    • Prepare Technical Design
    • Develop
    • Test
    • Deploy
    • Support
  • Database: SQL Server 2014
  • Programming Languages : SQL Programming (T-SQL)
  • Programming Tools : SQL Server, SSIS, SSAS, SSRS
  • Server : Windows Server 2014
Mar 2015Aug 2015

Sari Husada Generasi Mahardika Clone Project (SGM Clone)

Sari Husada Indonesia
  • Description : Custom Hybrid Web App with Data Warehouse and Business Intelligence for SAP SSD
  • Role : BI Developer and Support
  • Responsibility : Develop Data Warehouse and BI using Microsoft BI Technology with Web Apps
    • User Requirement
    • Analyze Functional Design
    • Prepare Technical Design
    • Develop
    • Test
    • Deploy
    • Support
  • Database : SQL Server 2012
  • Programming Languages : SQL Programming (T-SQL) and ASP.NET
  • Programming Tools : SQL Server, SSIS, SSAS, SSRS
  • Server : Windows Server 2012
Dec 2013Feb 2015

SAP THEMIS TAICHI Project (BI THEMIS Danone)

Danone Water China
  • Description : Data Warehouse and Business Intelligence for SAP SD, FI, MM, PP (Core system)
  • Role : BI Developer and Support
  • Responsibility : Develop Data Warehouse and BI using Microsoft BI Technology
    • Analyze Functional Design
    • Prepare Technical Design
    • Develop
    • Test
    • Deploy
    • Support
  • Database : SQL Server 2008 R2
  • Programming Languages : SQL Programming (T-SQL)
  • Programming Tools : SQL Server, SSIS, SSAS, SSRS
  • Server : Windows Server 2008
Sep 2014Feb 2015

SAP THEMIS GANESHA Project (BI THEMIS Danone)

Danone AQUA Indonesia
  • Description : Data Warehouse and Business Intelligence for SAP SD, FI, MM, PP (Core system)
  • Role : BI Developer and Support
  • Responsibility : Develop Data Warehouse and BI using Microsoft BI Technology
    • User Requirement
    • Analyze Functional Design
    • Prepare Technical Design
    • Develop
    • Test
    • Deploy
    • Support
  • Database : SQL Server 2008 R2
  • Programming Languages : SQL Programming (T-SQL)
  • Programming Tools : SQL Server, SSIS, SSAS, SSRS
  • Server : Windows Server 2008
Mar 2013Nov 2013

SAP THEMIS SHINKANSEN Project (BI THEMIS Danone)

Danone Japan Co Ltd
  • Description : Data Warehouse and Business Intelligence for SAP SD, FI, MM, PP (Core system)
  • Role : BI Developer and Support
  • Responsibility : Develop Data Warehouse and BI using Microsoft BI Technology
    • Analyze Functional Design
    • Prepare Technical Design
    • Develop
    • Test
    • Deploy
    • Support
  • Database : SQL Server 2008 R2
  • Programming Languages : SQL Programming (T-SQL)
  • Programming Tools : SQL Server, SSIS, SSAS, SSRS
  • Server : Windows Server 2008
Sep 2012Dec 2012

Supply Chain Planning Application

Danone AQUA Indonesia
  • Description : Data Warehouse and Business Intelligence for Supply Chain Planning Department
  • Role : Developer
  • Responsibility : Developed Data Warehouse and Develop Report using Microsoft Technology
  • Database : SQL Server 2008
  • Programming Languages : SQL Programming (T-SQL)
  • Programming Tools : SQL Server, SSRS, SSAS
  • Server : Windows Server 2008
Aug 2012Sep 2012

Business Intelligence Portal AQUA Project (AQUA BI PORTAL)

Danone AQUA Indonesia
  • Description : Data Warehouse and Business Intelligence for Secondary Sales Data
  • Role : Support Team
  • Responsibility : Developed & Supported Data Warehouse of BI Portal, Develop ETL Process
  • Database : SQL Server 2000
  • Programming Languages : SQL Programming (T-SQL)
  • Programming Tools : SQL Server, DTS, VB Scripts
  • Server : Windows Server 2000
May 2011Aug 2012

Time Attendant System Project

Unilver Indonesia
  • Description : Web Services
  • Role : Develop and Support System
  • Responsibility : Develop and Support Time Attendant System Web Application
  • Database : SQL Server 2000
  • Programming Languages : SQL Programming (T-SQL) and ASP.NET
  • Programming Tools : SQL Server, VB Scripts
  • Server : Windows Server 2000

Training And Seminar

  • Business Intelligence Training by Microsoft
  • .NET MVC 4 : Internet Application Training by Microsoft
  • 7 Habits Seminar
  • Self Development and Leadership Skills by Magna Solusi Indonesia
  • ILDP Training : Driving Team Productivities by PT Bank Muamalat Indonesia Tbk. 

Education

20072011

Bachelor

Bina Nusantara University

Faculty of Computer Science and Information Technology

20042007

Senior High School

SMA Negri 26 Jakarta
20012004

Junior High School

SMP Negri 1 Bekasi
19952001

Elementary School

SD Islam Al Husna Bekasi