Johan Simatupang

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