Alvian Pratama

A hardworking and motivated individual with foundational knowledge in Statistics, Data Analysis, and Business Management

Experiences

Business Intelligence

ADA Indonesia | October 2023 - Present

• Spearheaded the design and deployment of an integrated reporting solution in Looker Studio
• Architected scalable ETL pipelines using Supermetrics connectors, Google Sheets and Google BigQuery
• Collaborated with cross-functional teams across Southeast Asia to streamline weekly and monthly reporting processes

Junior Engineer

Shopee Indonesia | September 2022 - December 2022

• Worked as a full stack developer using Go (backend) and React (frontend)
• Created an online learning platform as a capstone project
• Improved efficiency on creating the learning platform using Typescript combined with React

Web Developer

PT. Dinamika Makmur Sentosa | October 2021 - April 2022

• Created a website for various business flows to manage tires using PHP Native
• Developed a systematic approach to organize and document the requirements of system
• Improved process efficiency by standardizing end to end project management workflow

Laboratory Assistant

Universitas Multimedia Nusantara | June 2019 - June 2021

• Teached the basics of Ms. Office (Word, Excel, PowerPoint), basics statistics (correlation test, normalization test, regression test) using R Language, basics of MYSQL (Create, Insert, Modify) using Laragon, and basics of PHP Native (PHP, HTML, and CSS)
• Participated in creating a test for the mid-test exam
  
  

Education

Bachelor of Information System

Universitas Multimedia Nusantara | 2018 - 2022

Relevant coursework: Statistics, Data Mining and Forecasting, Project Management, Principle of Data Analytics

Technical Expertise

Programming Language

• Java
• Golang
• Python
• PHP
• Javascript

Framework

• Airflow
• Spark

Tools

• Big Query
• AWS Athena
• Tableau
• Power BI
• Looker Studio