Hello, It's Me

Lian Wira

And I'm an ESG Data Intern

I build the data layer behind sustainability reporting — dimensional models, ETL pipelines, and the quality checks that make a number safe to publish. Currently doing that on OCBC Indonesia's ESG data mart, after a year of business intelligence work at Combiphar.

See My Work
Portrait of Lian Wira
About me illustration

About Me

원칙은 돌처럼 굳세고, 행동은 물처럼 부드럽다

ESG Data & Business Intelligence

Information Systems student at Multimedia Nusantara University, finishing in 2026. My work sits between the warehouse and the report: star-schema models, ETL/ELT pipelines, SQL, and the reconciliation checks that decide whether a figure is auditable. Outside the data desk I build web and Android products end to end.

ETL / ELTStar SchemaSQLSSISPower BIQlikPython
My Experience

Work Experience

Where the data work actually happened.

Aug 2026 — Present Current

Data Mart ESG Intern

OCBC Indonesia

Building and maintaining a centralised ESG data mart that turns fragmented sustainability data into reliable, report-ready information.

  • Design and maintain dimensional models (star schema) for ESG metrics across environmental, social, and governance domains
  • Develop ETL/ELT pipelines that pull core systems, customer master data, and third-party ESG providers into the warehouse
  • Write and optimise SQL for ESG and sustainability reporting, including regulatory disclosures
  • Implement data quality, validation, and reconciliation checks so reported figures stay accurate and auditable
  • Work with the Sustainability, Risk, and MIS teams to turn business and regulatory requirements into technical data specs
Data MartStar SchemaETL / ELTSQLSSISESG Reporting
Feb 2025 — Jul 2026

Business Intelligence Intern

PT Combiphar

A year and a half on the reporting side of a pharmaceutical business — sales, promotions, and the dashboards management actually opens.

  • Built and maintained Power BI and Qlik dashboards for sales and promotional analytics
  • Cleaned, validated, and integrated sales data with SQL and Excel
  • Analysed KPIs to support management decisions
  • Created and maintained the SFA dashboard plus daily sales and budget control reporting
  • Worked with business users to sharpen visualisations and cut manual reporting errors
Power BIQlikSQLExcelKPI Reporting
Sep 2025 — Dec 2025

Samsung UPP Ambassador Freelance

Samsung Indonesia

Represented Samsung's education programme on campus — running events, briefing students and faculty, and feeding what I heard back to the team.

Nov 2023 — Sep 2024

Part-time Barista

E+E Coffee & Kitchen

Bar work behind an espresso machine: drinks, service, and basic latte art, in the kind of pace that teaches time management faster than anything else.

Education & Certification

Multimedia Nusantara University (UMN)

Bachelor's degree, Information Systems

2022 — 2026

Certified Data Visualization International

PASAS Institute

Oct 2025 — Oct 2028

Sponsorship Coordinator

Feel d Flow 2024 & U-Love 2023 — proposals, packages, and partner outreach

2023 — 2024

Our Services

Web Development

Creating responsive and user-friendly websites tailored to your needs.

JavaScriptPHPLaravelMySQL

Business Intelligence

Transforming data into actionable insights for strategic decision-making.

DashboardKPIReporting

Mobile Development

Building intuitive mobile applications for both Android and iOS platforms.

AndroidJavaREST API

Data Analysis

Analyzing complex data sets to uncover trends and patterns.

PythonpandasSQL

Barista

Crafting the perfect cup of coffee with passion and expertise.

EspressoLatte ArtManual Brew

Latest Project

Websites and apps that are genuinely live and in use — every screenshot below was captured straight from the running site.

ombiboth.nicework.cyou
Ombiboth landing page with the chat widget in the corner
The Ombiboth chat panel open on a phone screen
Live · AI Web App

Ombiboth General-Knowledge AI Assistant

An Indonesian-language AI assistant that takes any question — science, history, technology, writing help, arithmetic — and answers it in plain language. The chat sits in a floating widget on the landing page, one click away from anywhere on the site.

  • React single-page app built with Vite; answers stream in as they are written and can be stopped mid-sentence
  • Conversations run as long as you like — older turns are compacted automatically, so the context never drops
  • Questions can carry images (up to five), resized in the browser before they are sent
  • A server-side proxy keeps the API key out of the browser; the transcript stays in local storage and clears in one click
ReactViteClaude APIStreamingREST APIResponsive
Visit Website The chat opens from the purple button in the bottom-right corner.
fortunacitramandiri.nicework.cyou
Home page of the PT. Fortuna Citra Mandiri website
PT. Fortuna Citra Mandiri website on a phone screen
Live · Company Website

PT. Fortuna Citra Mandiri IT Solution & Network Specialist

A public company profile site for an IT solutions provider in Jakarta — services, track record, client roster, FAQ, and an enquiry flow that hands the message straight to WhatsApp.

  • Fully bilingual (Indonesian / English) with a live language switcher
  • Eight service lines rendered from one data file, so content is edited in a single place
  • Client roster, FAQ accordion, and reveal-on-scroll animations
  • Contact form that composes the message and opens WhatsApp — no backend required
HTML5CSS3JavaScripti18nResponsiveSEO
Visit Website Screenshots were taken with the site's English mode switched on.
taxy.nicework.cyou
Taxy tax calculator home page
Taxy on a phone screen
Live · Web App

Taxy Indonesian Income Tax Calculator

Work out PPh 21 and PPh 23 in about half a minute. Enter a salary, marital status, and number of dependants, and the monthly tax, annual tax, take-home pay, taxable income, and effective rate all update as you type.

  • React single-page app built with Vite, talking to a Node API on Vercel
  • Accounts and saved calculation history behind token-protected endpoints
  • AI endpoints for chat, plain-language explanations, and projections
  • Education and FAQ sections citing the official rules on pajak.go.id
ReactViteNode.jsREST APIJWTVercel
Visit Website
maa.co.kr
Home page of the MAA artist management website
MAA website on a phone screen
Live · Company Website

MAA Artist Management, Seoul

The public site for a Seoul artist management company — roster, company timeline, and audition contact, laid out as a three-column editorial spread with a live Korea-time clock.

  • Nuxt (Vue) with server-side rendering, so every page arrives fully formed
  • Content managed in Strapi — the roster and timeline update without a deploy
  • Three-column editorial layout that folds down to one column on mobile
  • Naver site verification and Open Graph tags for Korean search and social
NuxtVueSSRStrapiHeadless CMS
Visit Website
aap — in development
Home page of the AAP artist management site
AAP site on a phone screen
In development · Company Website

AAP Artist Management, Seoul

The company profile site for the agency's rebrand: a bilingual front page carrying the roster, the business lines, and a single enquiry desk for casting, brands, and overseas requests.

  • Fully bilingual Korean / English, with the reader's choice remembered between visits
  • Roster and business lines rendered from one data file — edit in a single place
  • Portrait slots that fall back to a monogram until official photos are dropped in
  • Hand-written HTML, CSS, and JavaScript — no framework and no build step
HTML5CSS3JavaScripti18nResponsive
Not published yet — the screenshots come from the working build.
siauwlieapp.com
Front screen of the Siauw&Lie web app
Siauw&Lie sign-in screen on a phone
Live · Web App

Siauw&Lie Tofu Distribution System

An internal web app that runs a tofu distribution business end to end: pre-orders, confirmation, asset returns (tubs & cloths), price groups per customer, and billing — all in one dashboard.

  • Single-page app in vanilla JavaScript, backed by a Laravel REST API
  • Role-based access control, audit log, and data backup
  • PDF printing, QR codes, and a queued WhatsApp reminder flow
  • Built-in AI assistant to ask questions about the data
JavaScriptLaravelMySQLREST APIQRPDF
Visit Website Public access stops at the sign-in screen — the dashboard is for registered staff.
api.nicework.cyou
VinoWater water depot website
VinoWater website on a phone screen
Live · Android + REST API

VinoWater Refill Water Depot

An Android app for a refill water depot in Kalideres, Jakarta. Customers scan the QR sticker on their gallon to log every refill, collect loyalty progress, and pay straight from the app.

  • Native Android (Java, MVVM) with CameraX + ML Kit for QR scanning
  • PHP 8 + MySQL REST API running on my own hosting
  • Loyalty program (50 refills → 1 free) and Midtrans payments (QRIS / bank VA)
  • Admin gallon-tracking map built with Leaflet + OpenStreetMap
AndroidJavaPHP 8MySQLLeafletMidtrans
Visit Website Privacy Policy The Android app is currently in closed testing on Google Play.

Other Work

OnLi online store

OnLi — WhatsApp Store

Online catalog where every order continues straight in WhatsApp.

Archived · domain offline
Sales achievement dashboard

Sales Achievement Dashboard

Regional and channel performance, achievement vs target, and category breakdown.

Business Intelligence
Respecqt mobile app

Respecqt

Mobile app concept campaigning against bullying.

Mobile App
Data analysis in Google Colab

Python Data Analysis

Data cleaning and exploration with pandas in Google Colab.

Python · pandas
Barista working behind an espresso machine

Barista

Crafting the perfect cup of coffee with passion and expertise.

Espresso Bar

Data & Analytics

Data Warehouse for Raja's Shop

Star-schema warehouse built with Pentaho for ETL and Power BI on top, giving sales analytics across seasonal trends and marketing impact instead of one-off exports.

PentahoStar SchemaPower BI

Inclusive Economic Growth Dashboard

Tableau dashboard on GRDP per capita, unemployment, and health complaints from 2015 to 2021, comparing Western and Eastern Indonesia.

TableauPublic Data

Agricultural Productivity & Big Data

Random Forest and SVM in SAS and BigQuery to trace productivity shifts in Indonesian agriculture, with findings on irrigation, fertiliser use, and cropping efficiency.

SASBigQueryRandom ForestSVM

Academic Success Prediction

Decision Tree against SVM in Python to predict academic success and dropout risk, scored with cross-validation to check how well each generalises.

Pythonscikit-learn

Education Level vs Unemployment

Chi-Square test in R Studio on whether education level and unemployment rate are related across Jakarta.

R StudioChi-Square

XsoCoffee & Respeqt

Two Android apps built in Android Studio with Figma prototypes — one for coffee ordering with menu exploration, one for anonymous bullying reports.

Android StudioFigmaUI / UX

Contact Me!