Johan Simatupang

Johan Simatupang

Data Warehouse - Business Intelligence Consultant

Followers of Johan Simatupang687 followers
location of Johan SimatupangWest Java, Indonesia

Connect with Johan Simatupang to Send Message

Connect

Connect with Johan Simatupang to Send Message

Connect
  • Timeline

  • About me

    Co-Founder at Fit•Nest

  • Education

    • APKI

      -
      Fitness
    • APKI

      -
      CFT
    • Regina Pacis

      -
    • STT TELKOM

      2001 - 2006
      Information Technology

      Study Information Technology

  • Experience

    • PT Summitra Solusindo

      Aug 2006 - Mar 2008
      Data Warehouse - Business Intelligence Consultant
    • Perdana Consulting

      Apr 2008 - Feb 2018

      Manage User and GroupsCreate Xcelsius Dashboard Role : SAP BW/BO ConsultantSAP Version : ECC 6.0, Netweaver 701, SRM 7.0, SAP BO 3.1Functional and technical detail- Modelling the dataflow.- Extract the data from the source system.- Testing and validating the data extracted.- Create Process Chains to automatically extract the data.- Develop and Creating Query Report.- Develop Xcelsius Dashboard Role : SAP BW ConsultantSAP Version : ECC 6.0, Netweaver 701, SRM 7.0Functional and technical detail- Modelling the dataflow.- Extract the data from the source system.- Testing and validating the data extracted.- Create Process Chains to automatically extract the data.- Develop and Creating Query Report. Role : SAP BO ConsultantSAP BO Version : SAP BO EDGE 3.1Functional and technical detail- Modelling the data.- Extract the data from the source system.- Testing and validating the data extracted.- Develop and Create Xcelsius Dashboard. Role : SAP BW ConsultantSAP Version : ECC 6.0Functional and technical detail- Modelling the dataflow.- Extract the data from the source system.- Testing and validating the data extracted.- Create Process Chains to automatically extract the data.- Develop and Creating Query Report. Role : Data ConversionSAP Version : ECC 6.0Functional and technical detail- Legacy data analysis and cleansing and develop program.- Develop Data Conversion Program.- Preparing input data for data conversion.- Data conversion from Legacy System to SAP System.- Develop and Creating Report for data Conversion. Role : Data Migration and Data ConversionSAP Version : ECC 6.0Functional and technical detail- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration. Role : Data ConversionSAP Version : ECC 6.0Functional and technical detail- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration. Role : Data ConversionSAP Version : ECC 6.0Functional and technical detail- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration. Role : Data MigrationSAP Version : ECC 6.0Functional and technical detail- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration. Role : Data MigrationSAP Version : ECC 6.0Functional and technical detail:- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration. Role : Data MigrationSAP Version : ECC 6.0Functional and technical detail:- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration. Role : Data MigrationSAP Version : ECC 6.0Functional and technical detail:- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration. Role : Data MigrationSAP Version : ECC 6.0Functional and technical detail:- Legacy data analysis and cleansing and develop program.- Preparing input data for data Migration.- Data migration from Legacy System to SAP System.- Develop and Creating Report for data Migration.

      • SAP BO Consultant

        Apr 2008 - Feb 2018
      • Garuda Indonesia ECC Re-Implement

        Jan 2012 - Apr 2012
      • Bank Mandiri e-Procurement Enhancement

        Aug 2011 - Dec 2011
      • Universitas Islam Indonesia

        Oct 2010 - Apr 2011
      • Transformation PT. Latinusa Project

        Jul 2010 - Aug 2010
      • Implementation Project SAP-RMCA Telkom Indonesia (TREMS-TiCARES) Divre 7 Kawasan Indonesia Timur

        Oct 2009 - Jun 2010
      • Implementation Project SAP-ERP Semen Gresik Group (SINERGI) Semen Padang

        Sept 2009 - Nov 2009
      • Project Allignment SAP-RMCA with CRM Telkom Indonesia (TREMS-TiCARES) Divisi Enterprise (Dives)

        Jul 2009 - Sept 2009
      • Implementation Project SAP-RMCA Telkom Indonesia (TREMS-TiCARES) Divisi Telkom Flexi (DTF)

        Jul 2009 - Aug 2009
      • Rollout Project SAP-RMCA Telkom Indonesia (TREMS) Divre 6 Kalimantan

        Jan 2009 - Mar 2009
      • Rollout Project SAP-RMCA Telkom Indonesia (TREMS) Divre 1 Sumatera

        Nov 2008 - Jan 2009
      • Rollout Project SAP-RMCA Telkom Indonesia (TREMS) Divre 2 DKI Jakarta

        Jul 2008 - Oct 2008
      • Rollout Project SAP-RMCA Telkom Indonesia (TREMS) Divre 5 Jawa Timur

        Mar 2008 - Jul 2008
      • Rollout Project SAP-RMCA Telkom Indonesia (TREMS) Divre 4 Jawa Tengah

        Apr 2008 - Jun 2008
    • Garuda Indonesia

      Apr 2012 - Jun 2013
      SAP BPC Implementation

      Functional and Technical Detail :- Develop Input Form and Report for SAP BPC 10 NW- Develop Business Process Flow- Develop Script Logic

    • PT.Pertamina (Persero) - PGE Dashboard

      Apr 2013 - Dec 2014

      PGE Dashboard :- Gather User Requirement- Design Database Table, View and Stored Procedure using SQL- Build Data Model Using Universe Designer- Build Dashboard Mock Up- Build Dashboard Using Xcelsius PHE Dashboard : - Gather User Requirement- Design Database Table, View and Stored Procedure using SQL- Build Data Model Using Universe Designer- Build Dashboard Mock Up- Build Dashboard Using Xcelsius- Build Mobile Dashboard SPC Dashboard :- Gather User Requirement- Design Database Table and View using SQL- Build Data Model Using Universe Designer- Build Dashboard Mock Up- Build Dashboard Using Xcelsius CFO Dashboard :- Gather User Requirement- Build Dashboard Mock Up- Build Dashboard Using Web Intelligence- Make Dashboard Schedule

      • SAP BO Consultant

        Jun 2014 - Dec 2014
      • SAP BO Consultant

        Sept 2013 - May 2014
      • SAP BO Consultant

        Jul 2013 - Aug 2013
      • SAP BO Consultant - CFO Dashboard

        Apr 2013 - Jun 2013
    • PT.Pertamina (Persero) - Corporate Dashboard

      Nov 2015 - Jan 2017
      SAP BO Consultant

      - Gather User Requirement- Design Database Table, View and Stored Procedure using SQL- Build Data Model Using Universe Designer- Build Dashboard Mock Up- Build Dashboard Using Xcelsius- Build Mobile Dashboard

    • PT. Pelindo 1

      Feb 2017 - Oct 2017
      SAP BO Consultant

      - Gather Requirement- Mock Up Design- Dashboard Design

    • Fit•Nest

      Oct 2017 - now
      Co-Founder
    • Collega Inti Pratama, PT

      Feb 2018 - Jul 2018
      Manager BI & DWH
    • Accenture

      Jul 2018 - Feb 2019
      SAP BIBO Consultant
  • Licenses & Certifications

    • SAP Certified Support Associate - Incident Management with SAP Business Objects

      SAP
      Feb 2012
    • SAP Certified Application Associate - SAP BusinessObjects Business Intelligence Platform 4.1

      SAP
      May 2015