Ichsan Saputra

I'm Data & Business Intelligence Engineer

About

I am a Data & Business Intelligence Engineer with experience in competitor research, Oracle database management, SQL development, PHP-based APIs, workflow automation, and enterprise dashboard development. I work across the complete data lifecycle—from collecting and validating operational data, designing database structures, and applying business rules, to presenting reliable insights through interactive dashboards for operational and management users.

Data & Business Intelligence Engineer / Dashboard Developer

Turning business data into reliable systems, automated workflows, interactive dashboards, and actionable insights.

  • Birthday: 06 Feb 1992
  • Blog: www.ichsanx.blogspot.com
  • Phone: +62-821-1234-2401
  • City: Jakarta, INA
  • Age: 34
  • Degree: Bachelor Degree of Informatics Engineering
  • Email: ichsan.saputra007@gmail.com
  • Current Activities: Building enterprise dashboards, managing Oracle-based data workflows, and developing business intelligence solutions

I combine business analysis and technical implementation to improve data consistency, visibility, traceability, and decision support.

Skill

Programming Languages & Tools

Hard Skills

Technical competencies applied across data, dashboard, database, API, and workflow projects.

Data & Database

Oracle DatabaseSQL DevelopmentPostgreSQLMySQL Data ValidationData CleaningData TransformationExcel / CSV Integration

Backend & Application

PHP BackendREST-style APIOCI8JavaScript HTMLCSSAuthenticationRole-Based Access Control

Business Intelligence & Analytics

Dashboard DevelopmentKPI MonitoringData VisualizationTableau Looker StudioPythonPandasCompetitor Research

Tools & Infrastructure

Git & GitHubDBeaverVisual Studio CodePostman ApacheLinuxDockerXAMPP

Professional Skills

Work capabilities that support collaboration, analysis, delivery, and decision-making.

Business Requirement Analysis
Problem Solving
Stakeholder Communication
Cross-Functional Coordination
Data Interpretation
Attention to Detail
Technical Documentation
Continuous Improvement
Time Management
Presentation & Reporting
HTML 75%
CSS 70%
JavaScript 65%
Microsoft Office Word 100%
Microsoft Office Power Point 90%
Python 75%
Tableau 75%
CorelDraw 74%
C++ 45%
Proxmox 50%
Json 45%
Next.js 65%
NestJS 68%
TypeScript 70%
Prisma 80%
PHP 72%
MySQL 75%
WordPress/CMS 70%
PhotoShop 80%
Microsoft Office Excel 100%
Microsoft Visio 95%
Oracle DB Management 55%
SAP 75%
Wonders Filmora 95%
Git 55%
TrueNAS 50%
PostgreSQL 85%
JWT 86%
RBAC 80%
Swagger 83%

Experience

Work Experience & Internship

PT. TELKOM INDONESIA

COMPETITIVE INTELLIGENCE SPECIALIST | DATA & BUSINESS INTELLIGENCE ENGINEER

Jakarta, Indonesia — APR 2025 - Present

Supports business analysis, competitor research, data management, dashboard development, and workflow automation for operational and management needs.

Job Desc:

  • Conduct competitor research and market analysis to support business strategy and product positioning.
  • Manage and validate business, operational, product, and competitor data from multiple sources.
  • Develop Oracle SQL queries for data extraction, transformation, reconciliation, and reporting.
  • Develop PHP-based APIs, application workflows, and enterprise monitoring dashboards.
  • Develop KPI, SLA, project monitoring, and product portfolio dashboards.
  • Translate business requirements into database structures, business rules, workflows, and dashboard components.
  • Support ad-hoc analysis, benchmarking, technical documentation, and management decision-making.

PT. TELKOMSEL

REPORT PERFORMANCE & ANALYTICS

Jakarta, Indonesia — DEC 2022 - DEC 2024

Working as a partner of TELKOMSEL company, by providing performance data support to officers and managers.

Job Desc:

  • Collect, manage data and report the performance of front liners (Grapary, 147, E-Care) weekly or monthly according to existing KPI targets.
  • Create sales reports starting from the area level, region to the lowest level, namely the name of the TSEL Grapary region itself.
  • Create TNPS (Transactional Net Promoter Score) reports to explore customer needs issues.
  • Standby if there is a data request needed by the Manager.
  • Coordination related to management through various data resources, between sub-directorates and units.
  • Analyze and evaluate and intervene from everything that has been done.

PT. TELKOM INDONESIA (Persero)

CRM IT DATABASE

Jakarta, Indonesia — JAN 2015 - DEC 2022

Working as a partner of TELKOM Group company, by providing performance data support to managers and senior managers.

Job Desc:

  • Collect data and create executive performance reports according to the specified KPI (Sales, Churn CAPS, Revenue, Collection, Add On CRL, Assurance, TNPS).
  • Collect data and create Billing Process reports (BP-1 & BP-2) Telkom starting from regional and witel segmentation.
  • Manage applications and collect data for business processes via PostgreSQL to update DAPROS (Data Prospects) which will later be consumed by CTB (Caring Territory Base) agents.
  • Synergize and coordinate related to data management between sub-directorates and units from various data resources.
  • Standby if there is a data request needed by the Manager, OSM (Operation Senior Manager), and VP (Vice President).
  • Analyze, evaluate and intervene from everything that has been done.

SUPPORTING LEADER CONTACT CENTER

Jakarta, Indonesia — AUG 2013 - JAN 2015

Working as a partner of TELKOM Group company, by providing reporting support to managers and senior managers.

Job Desc:

  • Collect data and create daily, weekly and monthly performance reports 147/108/107.
  • Create business process flow.
  • Coordination related to solving cases in services if there are findings.
  • Admin Web Knowledge Information System for Services Frontliner (147, Sosmed, Plasa).
  • Standby if there is a request for data needed by the Manager
  • Evaluate and intervene from everything that has been done.

PT. Media Prima

SUPERVISOR YELLOW PAGES

Jakarta, Indonesia — JUN 2010 - AUG 2013

Working as a partner of TELKOM Group company, by providing information services such as company address data and telephone numbers.

Job Desc:

  • Fully responsible for the performance of TL (Team Leader) and agents.
  • Make attendance of team leaders and agents.
  • Monitor, assess and motivate agents and Team Leaders in work performance to match existing KPI.
  • Coordinate with sales and book procurement parties according to existing stakeholders.
  • Make daily, weekly and monthly book distribution reports.
  • Evaluation and discussion with the team.

KANWIL DEPARTEMEN HUKUM DAN HAM DKI JAKARTA (DEPKUMHAM)

ADMINISTRATION

Jakarta, Indonesia — APR 2009

Internship Field Work Practice as Administrative Correspondence at DEPKUMHAM.

Job Desc:

  • Scheduling Letters.
  • Indexing Incoming Letters.
  • Forwarding Letters.
  • Distributing Letters.
  • Numbering Outgoing Letters.
  • Recapitulating Employee Absences.
  • Typing on a Computer.
  • Typing with a Manual Machine.
  • Receiving Guests from Other Agencies.
  • Receiving Telephones.

GIANT HYPERMART

SALES PROMOTION

Bekasi, Indonesia —FEB 2009

Internship Field Work Practice as Sales at GIANT HYPERMART.

Job Desc:

  • Checking the condition of expired goods or not.
  • Displaying goods to make them attractive.
  • Conducting Stock Opname.

Portfolio

Selected projects in data engineering, business intelligence, dashboard development, analytics, and software systems.

Education

  • Bachelor Degree — S1 (Information Technology, STMIK MERCUSUAR)

    After graduating from vocational high school in 2010, I pursued my passion for technology by enrolling at STMIK Mercusuar, majoring in Information Technology (Teknik Informatika). During my studies, I built a strong foundation in computer science, software development, database management, and web programming. Throughout the program, I also developed several projects that combined both technical and analytical skills, which later strengthened my professional direction toward data analytics and software engineering.

    Graduated: 02 August 2010 - 26 August 2014



  • WebHozz Training Center — Web Development Course (PHP & MySQL)

    Focused on PHP website creation, layout design, CRUD, and project implementation.

    Graduated: November 26, 2016



  • Coding Studio — Programming and Data Fundamentals

    Studied Python, SQL, Excel, and C programming for data and software solutions.

    Completed: February 11, 2025



  • Growia Academy — Data Analyst Certification Program

    Comprehensive training in analytics, visualization, and reporting using Python, SQL, Tableau, and Excel.

    Graduated: September 24, 2025



  • RevoU — Fundamental Software Engineering Course

    Learnt the fundamentals of front-end development and responsive design.

    Completed: February 28, 2025

Achievement

  • CERTIFICATE HOMELAB SERVER SERIES

  • CERTIFIED DIGISTAR CONNECT GOES TO ITS X ACADS : BOOST YOUR PROJECT MANAGEMENT SKILL

  • CERTIFIED BEGINNER & INTERMEDIATE LEVEL ON DATA ANALYST COURSE

  • CERTIFICATE WEBINAR PENGANTAR ANALISIS DATA

  • CERTIFICATE FUNDAMENTAL COURSE INTRO TO SOFTWARE ENGINEERING

  • CERTIFICATE FUNDAMENTAL ALGORITMA

  • CERTIFICATE FUNDAMENTAL PYTHON

  • CERTIFICATE EXCEL INTERMEDIATE

  • CERTIFICATE FUNDAMENTAL EXCEL

  • CERTIFICATE FUNDAMENTAL DATABASE MYSQL

  • CERTIFICATE FUNDAMENTAL DIGITAL MARKETING

  • CERTIFICATE WEB PROGRAMMING TRAINING

  • CERTIFICATE OF ACHIEVEMENT AWARD HIGHER LEARNING

  • CERTIFICATE PROGRAM VISUAL BASIC & MYSQL

  • CERTIFICATE TEKNISI KOMPUTER

  • CERTIFICATE ENTREPRENEUR TANDOMAS MANDIRI

  • CERTIFICATE PRAKTERK KERJA LAPANGAN DEPKUMHAM

Etc.

INTEREST

  • Read
  • Photo
  • Music
  • Paint
  • Film
  • Gym
  • Adventure
  • Running
  • Hiking

NON-ACADEMIC

  • 1st — Gitar Performance DKI-Jakarta
  • 2nd — Vokal Performance DKI-Jakarta
  • 3rd — Pencak Silat Tournament PSHT Jabotabek

ORGANIZATION

  • DKM Perumahan – Sekbend (2020–2025)
  • Karang Taruna – Sekbend (2010–2019)