🌎 Available for opportunities

Hi, I'm Fikra Asyrafi

Geological Engineering Graduate & Data Analytics Enthusiast

Analytical, adaptable, and detail-oriented professional with strong problem-solving skills. Experienced in processing complex datasets with Excel, SQL, Power BI, and Python. Passionate about turning raw data into strategic insights.

3.15
GPA / 4.00
5+
Certifications
5+
Research Projects
Portrait illustration of Fikra Asyrafi, a geological engineering graduate and data analyst

About Me

A glimpse into my background, personality, and what drives me.

I am a Geological Engineering graduate from Institut Teknologi Bandung (ITB) (GPA 3.15/4.00) with a strong foundation in analytical thinking and problem-solving. From conducting geological research across West and Central Java to evaluating regional feasibility using geospatial analysis, I developed a passion for processing complex datasets and translating them into actionable, data-driven decisions.

Beyond technical rigor, I bring proven leadership and organizational adaptability. As Household Manager for the Geological Engineering Student Association at ITB, I designed and implemented a systematic inventory tracking workflow—overseeing 573 assets and managing 73 lending transactions with a 100% loss-free track record—sharpening my focus on operational efficiency and meticulous record-keeping.

Today, I channel that analytical background into data analytics and business intelligence. By combining domain problem-solving with tools like Python, SQL (PostgreSQL), Power BI, Microsoft Excel, and QGIS, I build dashboards, analyze trends, and help teams make informed strategic decisions.


✈ My Hobbies & Interests
🌎

Field Researcher

Geological fieldwork across West & Central Java

📈

Data Analyst

Python, SQL, Power BI, Excel

🗺

GIS Enthusiast

Spatial analysis with QGIS

🎉

Leader

Managed logistics & events at ITB

💬

C1 English

EF SET Score 62/100 — Advanced

📚

Lifelong Learner

5 Udemy bootcamps completed

Technical & Soft Skills

A curated set of tools and competencies I bring to every project.

💻 Programming & Query

Python Object-Oriented Programming PostgreSQL SQL Task Automation Scripting

📊 Data & Analytics

Data Analysis Data Visualization Analytics & Reporting Microsoft Excel (Advanced) Microsoft Power BI Reference & Structuring

🗺 Geospatial & Research

QGIS Multi-Criteria Analysis Spatial Planning Field Survey Technical Report Writing

👥 Professional & Leadership

Communication Team Management Time Management Attention to Detail Mail Merge Automation MS Word (Advanced)

Work Experience

Research, leadership, and hands-on analytical work across diverse environments.

Household (Logistics) Manager

Mar 2023 – Dec 2023

Geological Engineering Student Association, Bandung Institute of Technology — Bandung City, West Java, Indonesia

  • Designed and implemented an organized inventory data-recording system, supporting operational efficiency across all departments.
  • Systematically managed and recorded a total of 573 items.
  • Monitored asset lending traffic 73 times while maintaining a 100% safe track record — zero reports of damage or loss.

Head of Publication, Documentation, and Videography in HMTG "GEA" ITB July Graduation 2022

Jun 2022 – Aug 2022

Geological Engineering Student Association, Bandung Institute of Technology — Bandung City, West Java, Indonesia

  • Directed and motivated a production team through cross-functional collaboration to guarantee the seamless documentation and publication of a large-scale student association graduation event.
  • Orchestrated end-to-end project execution, maintaining highly effective communication and strict adherence to operational timelines.
  • Successfully delivered 100% of project outputs (9 publications, 609 photos, 2 videos) in compliance with internal Service Level Agreements (SLA) within a tight 1-week operational turnaround

Projects & Research

Selected work demonstrating analytical thinking, geospatial expertise, and coding skills.

🔗 View All Projects

🗺 Sumedang Geotourism Mapping

Comprehensive geospatial analysis of Mount Tampomas region using QGIS. Applied multi-criteria assessment in Excel to produce a quantitative site feasibility evaluation supporting spatial planning decisions.

🔎 Karangsambung Field Study

Collaborative geological field research in Kebumen Regency. Collected and validated primary spatial data, synthesized complex field datasets, and produced detailed technical reports for regional historical interpretation.

💻 Python Automation Projects

A series of Python automation scripts built during the 100 Days of Code bootcamp, including task automations, OOP-based programs, API integrations, and scripting tools to streamline repetitive workflows.

📊 Business Intelligence Dashboards

Built interactive Power BI dashboards for business performance tracking, combining data modelling and visual storytelling to translate raw datasets into executive-level reports and actionable KPI views.

📊 Excel Analytics Projects

Two end-to-end Excel workbooks: 979 Indeed salary records analyzed with INDEX/MATCH, pivot tables, what-if raise scenarios, and VBA macros; plus 7,814 BLS grocery & gas price records with composite-key lookups, SLOPE/INTERCEPT regression, and Goal Seek.

💻 Blog Capstone & ⚽ Euro Football App

Two full-stack web projects built with Node.js, Express, and EJS. The Blog Capstone ("Random Notes") features persistent JSON storage and RESTful routing. The companion Euro Football app pulls live data from API-Football for standings, fixtures, and player search — later converted into a static site hosted on GitHub Pages.

🎬 Pixar Films & 🏦 Bank Churn (SQL)

Two PostgreSQL projects: a relational database of all 28 Pixar films queried with joins, CTEs, and window functions to analyze box office and awards history; plus a Bank Customer Churn analysis cleaning 10,000 messy customer records to uncover retention risk factors across demographics, products, and engagement.

🌐 Personal CV Website

This very website — a fully responsive personal portfolio built with semantic HTML5 and vanilla CSS, demonstrating front-end fundamentals, design thinking, and attention to accessibility best practices.

📋 Inventory Management System

Designed and maintained a systematic inventory data-recording system for the Geological Engineering Student Association at Bandung Institute of Technology. Tracked 573 items and 73 lending transactions, achieving a 100% safe record with zero losses over a 9-month period.

Education

Formal degrees and continuous self-directed learning.

🏫

Bachelor's Degree — Geological Engineering

Bandung Institute of Technology (ITB)

2020 – 2026  |  GPA: 3.15 / 4.00

Certifications & Training

🎉

EF SET English Test — C1 Advanced

English First  |  Score: 62/100  |  June 2026

🐍

100 Days of Code: Python Pro Bootcamp

Udemy  |  May – July 2026

📄

Master Microsoft Word: Beginner to Advanced

Udemy  |  June – July 2026

📊

Microsoft Power BI Desktop for Business Intelligence

Udemy  |  December 2025 – January 2026

💾

The Complete SQL Bootcamp: Zero to Hero

Udemy  |  December 2025

📈

Microsoft Excel: Beginner to Advanced

Udemy  |  November – December 2025

Achievements

🏆 Best Staff Member — GAMAIS CUP 2021, Relations Division

Selected as Best Staff Member in the Relations Division at GAMAIS CUP 2021, organized by the Islamic Student Family (Keluarga Mahasiswa Islam) of ITB. Recognized for consistent contributions in managing communication, negotiation, and partnerships with external parties, and for proactively initiating strategic outreach that contributed to the successful publication of the event series.

Get in Touch

I'm open to full-time roles, freelance projects, research collaborations, or just an interesting conversation. Feel free to reach out through any channel below.


Currently based in Indonesia — available for remote or on-site work worldwide.