Hi, I’m Amanda Rizki

I’m an Undergraduate Statistics Student at Diponegoro University, driven by a curiosity to uncover insights and create data-powered solutions. As an aspiring Data Analyst and Business Analyst, I’m passionate about turning information into strategies that inspire growth and smarter decisions.

Explore my portfolio to see how I bring data to life.

See My Work Download My Resume Get in Touch

About Me

Profile Photo

Hello! I’m Amanda Rizki, a final year Statistics student at Diponegoro University with a deep passion for data and statistics, especially in data analysis and business analysis. I am driven by curiosity to uncover insights, identify patterns, and turn complex data into clear, actionable strategies that support effective decision-making and business growth.

Throughout my academic journey and hands-on experiences, I have developed strong skills in data processing, visualization, and statistical modeling. I am proficient in using tools such as Python, R, SQL, SPSS, Tableau, Looker Studio, and Microsoft Excel to solve real-world problems, build dashboards, and present findings in a way that is both insightful and impactful.

Beyond technical expertise, I have honed my leadership, communication, and teamwork abilities through various organizational roles, competitions, and internships. I am accustomed to collaborating with diverse teams, delivering results under deadlines, and communicating complex analyses to both technical and non-technical audiences.

I am a detail-oriented, analytical, and adaptable individual who thrives in dynamic environments. With a commitment to continuous learning, I am eager to contribute my skills and enthusiasm to data-driven projects that create value and inspire innovation.

Software Proficiency

Microsoft Office Suite

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

Statistical Analysis

SPSS

Minitab

Eviews

R

Python

PostgreSQL

Visualization

Tableau

Looker

Editorial

Canva

Figma

My Skills

Hard Skills

  • Data Processing & Analysis
    Python (Pandas, NumPy), R, SQL, SPSS, Minitab, Eviews

  • Data Visualization
    Tableau, Looker Studio, Microsoft Excel (Pivot Table, Charts)

  • Database Management
    MySQL, PostgreSQL

  • Statistical Modeling
    Regression Analysis, Hypothesis Testing, Time Series Analysis

  • Reporting & Presentation
    Microsoft PowerPoint, Canva, Figma

  • Web Basics
    HTML, CSS, basic JavaScript

Soft Skills

  • Analytical & Critical Thinking
  • Problem Solving
  • Attention to Detail
  • Time Management
  • Communication & Data Storytelling
  • Leadership & Team Management
  • Teamwork & Collaboration
  • Initiative & Proactive
  • Public Speaking
  • Adaptability
  • Learning Agility
  • Decision Making

Education

Diponegoro University

S1 Statistics | GPA: 3.87/4.00

August 2022 - Present

Currently pursuing a Bachelor’s degree in Statistics at Diponegoro University with an outstanding academic record. Actively engaged in academic activities and consistently completing assignments while developing professional skills through organizational involvement, internships, and competitions.

SMAN 1 Pati

Natural Sciences | GPA: 91.87/100

July 2019 - May 2022

Completed high school education at SMA Negeri 1 Pati, demonstrating strong academic performance and active engagement in various learning activities. Developed organizational and technical skills by serving as Head of the Website Department in OSBIT and contributing as a member of PASUS, supporting community service and extracurricular programs.

My Projects

BUILDING AN ETL PIPELINE: DEKORUMA E-COMMERCE DATA

End-to-end data pipeline project to extract e-commerce product data, perform cleaning and exploration with Pandas, and load the processed dataset into a PostgreSQL database for further analysis.

CUSTOMER PERSONALITY ANALYSIS

A data-driven project to understand customer demographics, purchasing behaviors, and campaign responsiveness. This analysis provides actionable insights for designing targeted marketing strategies and improving customer engagement.

DATA WAREHOUSE FOR SALES ANALYSIS

This project implements an end-to-end ETL pipeline and Data Warehouse design for The Look, a fictional e-commerce platform. The solution uses PySpark, PostgreSQL, and BigQuery SQL to enable comprehensive sales data analytics.

RETAIL TRANSACTION DATA PIPELINE AUTOMATION

This project implements a complete ETL (Extract, Transform, Load) automation pipeline for a retail transaction dataset using PySpark, Apache Airflow, and MongoDB.

BEACH VS MOUNTAIN PREFERENCE ANALYSIS

An interactive data mining project analyzing individuals’ vacation preferences between beach and mountain destinations. Explored relationships between demographic factors (education level, gender), favorite seasons, activities, income, and vacation budgets. Presented insights through interactive charts to identify patterns in travel choices.

TRAFFIC ACCIDENT DASHBOARD

Developed a comprehensive dashboard visualizing traffic accident data over time. Included analysis of crash frequency by date and hour, key contributing factors to severe injuries, and the impact of road and weather conditions on accident rates. Enabled users to explore trends and identify critical safety insights.

Work Experiences

Trade Marketing Intern Circle Java

Indosat Ooredoo Hutchison Semarang

March - May 2025

Designed data-driven infographics, analyzed customer and sales data to extract actionable insights, and prepared performance reports to evaluate promotional effectiveness in a telecommunications environment.

Internship

BPS Kabupaten Pati

January - February 2025

Analyzed statistical datasets, generated reports and visualizations, and supported the preparation of survey summaries and official publications in compliance with statistical standards.

Lecturer Assistant

Diponegoro University

August - December 2023

Facilitated assistance classes, delivered additional explanations of course material, and supported students’ preparation for midterm and final examinations.

Organizations

Produktifkuy

Produktifkuy

Vice Manager of CEO Analyst

January 2025 - Present

Joined Produktifkuy, a personal development and productivity platform, as a CEO Analyst Intern prior to advancing to Vice Manager, where I was responsible for leading and executing flagship programs attended by over 500 participants. In this role, I planned, implemented, and evaluated various initiatives to improve productivity skills, supervised daily operations, monitored performance metrics, provided feedback to team members, and reported progress directly to the CEO.

BEM FSM Universitas Diponegoro

BEM FSM Universitas Diponegoro

Vice Head of Student Welfare

February 2024 - January 2025

Served as Vice Head of Student Welfare after initially contributing as a staff member, supporting the development of student assistance programs and scholarship dissemination. In the leadership role, I managed academic support initiatives benefiting more than 3,000 students, coordinated administrative workflows, facilitated cross-department collaborations, and conducted regular performance evaluations to ensure effective program delivery.

UDF

Undip Debating Forum

Training and Competition

January 2024 - December 2024

Delivered over 20 weekly training sessions as part of the Training and Competition division, focusing on debate techniques, critical thinking skills, and competition readiness. Additionally, I developed comprehensive training materials, managed event schedules, and oversaw registration and logistical support for debate tournaments throughout the year.

Committees

SCDay 2024

Scholarship and Career Day 2024

Steering Committee

March - September 2024

Led strategic planning and cross-functional coordination to deliver impactful scholarship and career programs. Contributed to promotional campaigns and managed stakeholder relations.

DSF 2024

Diponegoro Science Festival 2024

Public Relation

May - September 2024

Developed public communication strategies to enhance event visibility and stakeholder engagement. Coordinated media relations, including press releases, social media campaigns, and sponsor collaborations.

Suksesi 2024

Suksesi Himasta 2024

Head of Event Organizer

September - December 2023

Led planning and execution of 4 major events for the leadership election, including serving as MC and moderator. Successfully managed the voting process and coordinated all logistical aspects.

ODM 2023

ODM FSM 2023

Staff of Facilitator Division

June - August 2023

Guided new students through orientation activities by designing training materials, delivering presentations on campus life and academic regulations, and developing assessment systems. Ensured effective participation and provided assistance to support smooth adaptation throughout the entire program.

Scholarship and Career Day 2023

Scholarship and Career Day 2023

Staff of Event Division

September - October 2022

Scholarship and Career Day was a seminar and expo designed to inspire students to pursue scholarships and explore future career opportunities. Prepared event materials, schedules, and logistics for the program, and supported the MC, moderator, and speakers to ensure seamless event delivery.

Statisticare

Statisticare

Staff of Event Division

May - September 2023

Statisticare was a community service program organized by Statistics students of Diponegoro University to support children in local orphanages. Contributed to planning and executing social outreach activities, including donations and educational sessions at Benthlehem and Ar-Rodiyah orphanages.

Other Experiences

MC LT

Master of Ceremony

Leadership Training BEM FSM 2023

MC KD

Master of Ceremony

Kampanye Dialogis Suksesi Himasta 2024

MOD FNP

Moderator

Fit and Proper Test Suksesi Himasta 2024

sospro

Social Project

LKMM-D Fakultas Kedokteran 2023

Pengabdian Dosen

Volunteer

Lecturer Community Service Program

Statisticare

Facilitator

ODM FSM 2023

Certifications

Certification 1

Certified Data Analyst

Hacktiv8

Issued: 23 May 2025

Mastered Python and SQL for data processing, developed ETL pipelines with Airflow, and applied advanced data visualization techniques to deliver actionable insights.

Certification 2

SQL Intermediate

HackerRank

Issued: 27 June 2025

Validated intermediate SQL skills including complex joins, unions, and sub-queries. Demonstrated ability to design and optimize advanced relational queries.

Certification 3

SQL Basic

HackerRank

Issued: 27 June 2025

Certified foundational SQL capabilities covering simple queries, table relationships, and aggregators to retrieve and summarize data effectively.

Certification 4

Python Basic

HackerRank

Issued: 27 June 2025

Certified basic Python proficiency, including Scalar Types, Control Flow, Strings, Collections and Iteration, Modularity, and Object-Oriented concepts.

Certification 5

Problem Solving Basic

HackerRank

Issued: 27 June 2025

Assessed core problem-solving skills using fundamental Data Structures (Arrays, Strings) and Algorithms (Sorting, Searching). Proven ability to implement efficient solutions to programming challenges.

Let's Connect!

Feel free to contact me for any inquiries, discussions, or collaborations.