Information Systems — Airlangga University
Surabaya, Indonesia · 2026
Data
Analyst

Dafa Fajar Bagaskara

ETL Pipelines · Industrial Data Processing · Dashboarding

Scroll
01

Featured Experiences

Bayer
Bayer
Feb 2026 — Now
● Active

Digitalization Intern

Bayer Indonesia

Interning as a Digitalization Intern in the Production Engineer division, contributing to digital transformation initiatives by collecting and consolidating industrial data from multiple sources, performing preprocessing on real-world industrial datasets, and designing end-to-end Power BI dashboards from requirements gathering with stakeholders through to full implementation. Also developing internal PowerApps applications to digitize business processes and reduce resource consumption such as paper usage. Progress and outcomes are regularly presented in monthly stakeholder review meetings to ensure continuous improvement and alignment with project goals.

Data AnalysisData ETLDashboardStakeholder Communications
Jasa Raharja
Jasa Raharja
Oct — Dec 2025
✓ Completed

Data Engineer
& Analyst Intern

Jasa Raharja

Developed a Python-based automation tool to extract insurance data from multi-format PDFs into structured Excel files, incorporating data processing pipelines to standardize inconsistent source formats and prepare clean, analysis-ready datasets, reducing manual data handling workload.

Data ETLPythonAnalytical SkillsDetail Oriented
Develop Indonesia
Develop Indonesia
Mar 2025 — Jan 2026
✓ Completed

Associate of Training
& Development

Develop Indonesia

Contributed to the end-to-end development of a professional Excel training program for 30+ participants, covering curriculum design, speaker coordination, and technical preparation to ensure smooth execution.

Research SkillsEvent PlanningTeamwork
PENGMAS
PENGMAS
Mar — Jun 2025
✓ Completed

Analyst Expert Staff
PENGMAS 2025

HIMSI Airlangga University

Contributed to research and material development for a community service program equipping 60 high school students with business competition fundamentals, covering Business Case, Business Plan, and Business Model Canvas. Assessed participants' BMC outputs using a structured rubric developed collaboratively with the team.

Research SkillsProblem SolvingMicrosoft Office
02

Featured Achievements

1st
Place
SurabayaDev · October 2025

Developer Battle

Data Analyst — Multi-Stage Competition

Served as Data Analyst in a multi-stage competition covering data cleaning, exploratory analysis, and insight-driven design. Analyzed clothing sales data and informed UI/UX decisions that led the team to 1st place.

44%
Outerwear revenue share — key insight driving UI decisions
3
Competition stages — cleaning, EDA & insight-driven design
#1
Final ranking out of 20+ competing teams
03

Featured Projects

Data ETLDashboardingStakeholders Communication

QA Performance Dashboard
End-to-End Data Pipeline & Visualization (Bayer)

From requirements to delivery — designed Bayer's QA Performance Dashboard by integrating multi-source data pipelines, enabling the QA team to shift from manual tracking to data-driven decision-making.
Data MiningPythonSentiment Analysis

Aspect-Based Sentiment
Analysis on iPhone Reviews

Identifying most praised and criticized iPhone 13/14 features, comparing user sentiment, and tracking improvements across generations.
PythonTableauStreamlitSQL

E-Commerce Analysis
& Dashboard

Full-cycle analysis: data collection, cleaning, EDA, and visualization — delivered as an interactive Streamlit dashboard with actionable recommendations.
SQL/ Python/ Power BI/ Tableau/ Spreadsheet Tools/ Analytical Thinking/ Critical Thinking/ ETL Pipelines/ SQL/ Python/ Power BI/ Tableau/ Spreadsheet Tools/ Analytical Thinking/ Critical Thinking/ ETL Pipelines/