Curriculum Vitae
Jonathan Patrick Pardamean
Portfolio
Urban and Regional Planning fresh graduate with strong leadership in community-based initiatives and hands-on experience in regional planning projects. Proven ability to lead teams, delegate tasks effectively, and coordinate with diverse stakeholders, including government agencies and local communities. Skilled in delivering practical spatial solutions using ArcGIS and SketchUp, with foundational training in AutoCAD, SQL, and Python to support data-driven and sustainable development goals.
April 2025
Universitas Brawijaya
S1 • Perencanaan Wilayah dan Kota • IPK 3.44
Oktober 2025 - Oktober 2025
Surveyor
Dinas Perhubungan • Part Time
1. Gathered critical field data through surveys to evaluate parking site performance, revenue collection, and operational inefficiencies
2. Quantified vehicle ingress and parking types within designated areas through direct observation and data
collection
Agustus 2025 - April 2025
GIS Analyst
PT. Sagamartha Ultima • Magang
1. Conducted economic analysis to assess the development potential of North Hulu Sungai Regency.
2. Identified and categorized land use based on proximity to educational, health, religious, commercial, and service facilities.
3. Performed regional and global issue assessments through physical spatial analysis (slope, topography, geology, soil type, geomorphology, climatology, hydrology) using ArcGIS
4. Created detailed Land Capability Unit (SKL) maps and reports using ArcGIS for spatial planning purposes.
5. Supported data-driven decision-making for regional development through spatial data visualization and thematic mapping
Agustus 2025 - Agustus 2025
Big Data Analytics
PT Kimia Farma Apotek • Magang
- Conducted business performance analysis of Kimia Farma (2020–2023) using BigQuery and Google Looker Studio.
- Imported, cleaned, and integrated 4 datasets (transactions, inventory, branches, products) into BigQuery using SQL query for analysis.
- Developed an analysis table containing key business metrics: nett sales, nett profit, and ratings.
Designed a performance dashboard on Google Looker Studio visualizing revenue trends, branch & provincial performance, customer ratings, and profitability distribution.
- Delivered actionable insights & recommendations, including branch optimization, regional growth strategy, and service quality improvement.
Media
April 2025 - April 2025
Surveyor
Bappeda Jawa TImur • Part Time
1. Conducted interviews with domestic and international tourists to gather data on tourism infrastructure in East Java.
2. Conducted market research on accommodation pricing in East Java's tourism areas
3. Collected data on tourist expenditure in East Java through interviews.
September 2025
Data Analytics Job Simulation
Forage • 68b6f9db5e08a032f02fa054
* Completed a Deloitte job simulation involving data analysis and forensic technology
* Created a data dashboard using Tableau
* Used Excel to classify data and draw business conclusions
Media
Agustus 2025
SQL for Data Analysis : Beginner MySQL Business
Udemy • UC-40dd0e84-da4f-4ea5-9581-07ccc70c7f5e
- SQL Intro & MySQL Setup
- SQL Database Fundamentals
- Analyzing Data from Single Tables with MySQL
- Analyzing Multiple Tables via MySQL JOINS
Media
Juli 2025
SQL Course
Progate • 32908d01szsisy
Kursus ini mencakup fundamental SQL mengenai dasar untuk memanipulasi database.
Media
Juli 2025
Python Course
Progate • f0e6ae83t0fay3
Kursus ini mencakup fundamental Python untuk pengembangan software.