Hermawan Petra

Hermawan Petra

System & Data Analyst, Programmer

Followers of Hermawan Petra1000 followers
location of Hermawan PetraJakarta, Jakarta, Indonesia

Connect with Hermawan Petra to Send Message

Connect

Connect with Hermawan Petra to Send Message

Connect
  • Timeline

  • About me

    AVP - Business Intelligence & Analytics @CIMB Niaga | Data Analytics | Risk | Tech Geek | Investor | Metaverse | Blockchain / Crypto | Digital Assets

  • Education

    • Universitas Bina Nusantara (Binus)

      1998 - 2002
      Bachelor's degree Information Technology 3.2

      Activities and Societies: Bina Nusantara Computer Club

  • Experience

    • PT Adicipta Inovasi Teknologi

      Nov 2002 - Aug 2005
      System & Data Analyst, Programmer
    • BNI Multifinance

      Jan 2005 - Jan 2007
      IT User Coordinator
    • Bank Negara Indonesia - Multifinance

      Aug 2005 - Oct 2007
      Database Administrator & Data Analyst

      Supervisor and System Analyst • Responsible to maintenance Financial and Accounting Core System (Oracle’s Finance System) - Industrial and Financial System (IFS) Application, a kind of ERP from Sweden.• Maintenance Core System Application and daily data transaction• Build and implementing DataWarehouse System for Management Reporting• Build and maintenance Management Information System• Conduct the team of Help Desk and Programmer• Training users and internal Help DeskOracle Database Administrator• Responsible for creating, maintenance Oracle Databases on Database Production and Database Datawarehouse Server• Responsible for Databases Security, Integrity of data, Data Conversion and Data Cleansing• Responsible for technical maintenance of database server (daily process, weekly backup process, etc) Show less

    • CITRAMAS ALFA SEJAHTERA - AUTHORIZED DEALER PANASONIC

      Nov 2007 - Oct 2009
      IT Manager

      • Responsible to Business Owner• Responsible for maintenance IT Environment at internal Office, Head Quarter and Branches (Network LAN / Internet, System, Computer and its peripheral, etc)• Conduct the Internet Technology team, selling PANASONIC products which is related to Internet Technology (IP Camera / CCTV System, PBX, Voice Mail, etc)• Learning dan research about PANASONIC technologies or another brand in Telecommunication and Security fields.

    • Bank DBS, Indonesia

      Nov 2009 - Nov 2014
      Corporate Banking : Strategic Planning & MIS - IT : Senior Data Analyst

      Corporate Banking Unit – Chief Operating Officer : Strategic Planning and MIS unit1. Responsible to COO Head & Corporate Banking Head2. Advisory for Corporate Banking Management and responsible to provide the financial / nonfinancial reporting to management3. Analyzing performance and achievement of DBSI Corporate Banking by consolidating allthe data / reports from systems and another supporting units4. Responsible for maintain DBSI data warehouse system and generating the regulatoryreporting automation using Statistical Analysis System (SAS) software as BusinessIntelligence and Data Mining system5. Responsible to maintain and troubleshoot 3G system, the MIS system for DBSI CorporateBanking Unit.6. Responsible to lead the system related projects/initiative for Corporate Banking UnitIT Application supervisor1 Responsible to IT Application Manager and IT Head2 Maintain the MIS system of the Bank and provide regulatory / ad hoc reports for anotherunits.3 Responsible for maintain DBS Dataware house system and the regulatory reportingautomation using Business Analytical Tools such as SAS base 9.1 & SAS Server AnalyticPro (SAS EG) 9.24 Responsible for maintain core banking system FINACLE 7.4 & FINACLE 10.25 Responsible for maintain surround / satellite applications such as IMEX (trading system),CBG & FNA system, DMS (Customer Statement Printing system), SIDHN (Sistem InformasiDaftar Hitam Nasional)6 Maintain environment for local applications (databases, servers, etc) and the regionalapplications troubleshooting by bridging users with the support team. Show less

    • JagoanInternet.com

      Jan 2011 - now
      Founder

      Get more updates, experiences and innovations with internet and its technologies!

    • PT Bank Tabungan Pensiunan Nasional Tbk

      Nov 2014 - Jul 2019

      Digital Banking (Jenius), Branchless Banking (BTPN WOW) and IT Internal Audit - Audit Planning Support (Remote Audit)• Responsible to IT Internal Audit Head & team Lead• Team Leader, supervising audit team & lead junior auditors• Performing the Digital Banking audit program in regular basis • Performing Integrated Audit (IT related) audit program in regular basis and some other IT related assessmentProvide the required raw data, process and performing data analysis in several environtment databases such as MS SQL and MS Excel (advanced macro & formula) Show less Designing, create and conduct the implementation of Internal Audit Dashboard, the first and complete user front end dashboard to support the auditor with preliminary analysis. Using TABLEAU and MS SQL technologies, enriching our local datamart and convert the big data into stunning visualization, with thousand of valuable meanings to supporting our auditor on their tasks. • Provide raw data & performing data analysis using SQL db and other supporting tools to supporting the auditor team• Designing, develop, implementing and socializing Internal Audit Dashboard, web based dashboard application which is developed using Tableau, Gephie, R and statistical technologies to visualizing bank wide data into management (helicopter) view and auditor view to supporting audit program • Maintaining the internal audit datamart ,our local SQL db data warehouse• Coordinating with related parties such as Analytics & Data Science team for enhancement & enriching our local data mart from enterprise / bank wide data warehouse Show less • Responsible to Performance Alignment & Budget Management (PABM) Head• Generate & monitor Key Performance Indicator (KPI) of Operations staff/unit in monthly, midyear and year end basis through Sistem Monitoring Kinerja (SMK).• Supporting & assisting Operations staffs in STAR Program to generate additional KPI. Coordinate with the related units as well (Komite STAR team) to calculating the STAR initiative points • Generate regular summary reports using Microsoft Powerpoint / Excel and its supporting materials (Performance related things) and being active to attend the weekly Operation Alignment meeting. • Develop & maintain workaround tools /applications / system to support the internal team and achieve the strategic initiatives from stakeholders.• Maintain (generating content & info), monitoring and supporting all collaboration / communication application related to Operations (Portal Operation, SAP-JAM/DiNas, ODS Update, etc ) • Responsible as care center management as well by generating / creating interactive content, discussion through any media (email, phone, SAP-JAM, etc) to supporting Operational team to be aligned / updated and deliver the best services for customers. • Responsible to lead any IT system development project (Performance related) and coordinate with the related units. Show less

      • Digital Banking Audit Lead - Internal Audit

        Nov 2017 - Jul 2019
      • Audit Planning & Support - Internal Auditor

        Oct 2016 - Nov 2017
      • Performance Management Head - Direktorat Operations

        Nov 2014 - Oct 2016
    • PT Bank Danamon Indonesia, Tbk.

      Jul 2019 - Jul 2020
      AVP - Analytics Audit & Development

      My main job role and target is to develop, implement and maintain continues audit dashboard application for Internal Audit Division using big data and visualization tools such as Tableau, SAS, SQL Server and IDEA. We also will do some improvements for auditors to get a better way doing audit in automation.

    • CIMB Niaga

      Jul 2020 - now
      AVP - Business Intelligence & Analytics ORM at CIMB Niaga
  • Licenses & Certifications

    • Audit Technique and Communication Skill

      AMERA Internal Audit Services
      May 2018
    • Expert Coaching Training

      Mar 2015
    • Bank Risk Management level 2

      KIRAN
      Aug 2013
    • Bank Risk Management level 1

      BSMR - Badan Sertifikasi Manajemen Resiko
      Apr 2013
    • Certified of Bank Internal Audit

      Lembaga Sertifikasi Profesi Perbankan (LSPP)
      Sept 2017
    • Python Quick Start

      LinkedIn
      Feb 2020
      View certificate certificate
    • Cyber Securities

      ITSEC Asia
    • 15 Secrets Successful People Know About Time Management (getAbstract Summary)

      LinkedIn
      Feb 2020
      View certificate certificate
    • Managing Conflict: A Practical Guide to Resolution in the Workplace (getAbstract Summary)

      LinkedIn
      Feb 2020
      View certificate certificate
    • IT Infrastructure Library V.3

      PT. NetTrain Informatika
      Nov 2011