Curriculum Vitae
Joevan Pramana Achmad
Media Social
Sebagai mahasiswa Sistem Informasi, saya aktif mengaplikasikan dan mengasah kemampuan dalam pengembangan back-end dan analisis data untuk memecahkan masalah kompleks. Saya memiliki fondasi kuat dalam SQL, Python untuk machine learning, dan analisis data, yang dilengkapi dengan sertifikasi seperti Google Cloud Data Analytics serta pengalaman dalam mengolah data skala besar (seperti pada proyek bersama PT Kimia Farma Tbk ). Tujuan saya adalah berkontribusi dalam menciptakan sistem teknologi yang efisien, cerdas, dan berdampak. Terbuka untuk diskusi, berbagai peluang, dan kolaborasi di bidang teknologi.
Sedang berjalan
Universitas Nasional
S1 • Information System • IPK 3.94
Mei 2025 - Juli 2025
Back End Developer
PT Asuransi BRI Life • Magang
1. Developed and maintained RESTful API endpoints using Node.js to support new application features and improve data retrieval processes.
2. Wrote and optimized complex SQL queries for the PostgreSQL database, ensuring data integrity and enhancing the performance of back-end services.
3. Assisted in designing and implementing database schemas for new modules within the company's core application.
April 2025 - Mei 2025
Project-Based Virtual Intern : Kimia Farma Big Data Analytics x Rakamin Academy
PT Kimia Farma Tbk • Magang
Participated in a project-based internship program in collaboration with Kimia Farma, focusing on real-world data analytics implementation using Kimia Farma’s transaction records from 2020 to 2023. The project aimed to support strategic decision-making by turning raw data into actionable business insights through data transformation and visualization.
Key Responsibilities and Accomplishments:
1. Performed data modeling and integration by combining transactional, branch, and product data using SQL in Google BigQuery.
2. Created a central analytical table kimia_farma_analysis that calculated:
• Net Sales by applying discount logic to product prices
• Gross Margin Estimates using tiered pricing logic
• Net Profit per transaction based on calculated margins
3. Ensured data accuracy and consistency across joins between kf_final_transaction, kf_kantor_cabang, and kf_product tables.
4. Built a comprehensive dashboard using Looker Studio, presenting:
• Year-over-year revenue comparison
• Top 10 branches by sales and transaction volume
• Branches with high ratings but low performance
• Geo map visualizing profit distribution by province
5. Applied BigQuery SQL techniques including CASE, calculated fields, conditional logic, and aliasing for clear and scalable queries.
6. Designed the dashboard to be interactive and filterable by year, province, and branch for better decision-making by management.
Media
April 2021 - Mei 2021
Internet of Things Intern
PT Jaya Konsultan Indonesia • Magang
- Building a digital clock using Arduino Uno integrated with an RTC module to maintain real-time accuracy.
- Developing an automated temperature monitoring system using DHT11 and DS18B20 sensors to enhance efficiency and accuracy in environmental temperature monitoring.
These experiences have strengthened my skills in microcontroller programming, sensor integration, as well as problem-solving and collaboration within technical teams.