Agatha Prastika Kusumaningrum

A Portfolio of Aspiring Data Analyst

Hi! I'm Agatha

An adaptive team-player with analytical thinking and target-oriented based who possessing 3 years of solid sales experiences across 7 different areas (Java and Sulawesi) in the FMCG company.
Proficient in translating business challenges and gathering data analysis into practical solutions to achieve desired outcomes.
Actively pursuing professional development of data analytics in Google Data Analytics and Full-Stack Data Analytics Revou.

Skills

Hard Skills:
SQL
Python (library: Numpy, Pandas, sklearn, matplotlib)
Microsoft Excel/ Spreadsheet
Tableau
Looker Studio


Soft Skills:
Collaborative
Critical Thinking
Problem-solving
Data Communication

Experiences

Virtual Assistant at Andreaswidi Architectural Photography
January 2023 - present

Projects Handling:
- Perform simple financial analysis simulation of operational cost projection
- Project arrangement for architectural building photo session with Pemprov Jawa Barat
- Responsible for distribution of More or Less book, collaborative project with Atelier Riri and Tedanesia


Head of Area Sales at PT. Mayora Indah Tbk
October 2016 - October 2019

Projects Handling:
- Creating sales achievement dashboard using Pivot Table on Microsoft Excel
- Forecasting to ensure stock readiness every month
- Calculate cost simulation on scale up the capacity of the warehouse by manipulated warehouse layout using Microsoft Excel
- Rerouting the most efficient sales and delivery routes supported by analyzing data using Pivot Table in Microsoft Excel
- Perform cost simulation and tactical strategic for handling near expired over-load stock using Microsoft Excel

Education


Full-Stack Data Analytics
RevoU
2023
Grade: 98.5 / 100

- Learning how to define business questions, clean data, interpret the data, visualize the data, gather insights, and give recommendations using Spreadsheet/ Excel, SQL, Python, Looker, and Tableau.
- As a Team Lead on Final Project learned to lead troubleshooting with the team to provide the best recommendations
- Chosen as First of Top 3 Performers from over 70 student in the Python Competition


Bachelor of Chemical Engineering
Universitas Sebelas Maret
2012 - 2016
GPA: 3.43 / 4.00

Projects

Here are some of the projects I have worked on while pursuing my knowledge in data analytics

Spreadsheet: Marketing Campaign of Fast-food New Menu

Analysis for testing several marketing campaigns for a new menu by introducing it at randomly selected markets and tracking the weekly sales

SQL: Retention Behaviour of Clothing E-commerce

Finding retention behaviour and increasing retention rate in clothing e-commerce

Python: Indonesian Mutual Fund Start-up Campaign

Dissect thematic campaign based on user preference using cluster analysis and utilize prediction analysis in campaign effectiveness

Tableau: Strategic Revenue Based Dashboard in E-commerce

Creating a strategic revenue dashboard for E-commerce CEO with several filter for easier use

Looker Studio: Transaction Dashboard in E-commerce

Creating a transaction revenue dashboard for E-commerce CEO with several filter for easier used

Group Project: Portuguese Hotel Booking Analysis

A project lead by me to analyze the possibility of gaining revenue based on hotel booking

Let's connect!