3 of 13

ABOUT ME

Hello, I’m Vivian

A seasoned professional with a unique background as an online shop owner, where I’ve honed my skills in strategic thinking, inventory management, and customer relations.

My journey includes a keen analysis of product popularity, aligning offering with consumer preferences, resulting in increased sales and customer satisfaction.

Proficient in SQL, Python, Tableau, analytical thinking, and communication, I bring a unique blend of business acumen and technical proficiency to contribute effectively to data analysis endeavors.

I am eager to contribute my diverse experience to data analysis, bringing a collaborative mindset and a proven track record of effective outcomes.

Download Resume

4 of 13

EDUCATION BACKGROUND

University of Sumatera Utara

Bachelor of Architecture

July 2012 - September 2016

RevoU

Full Stack Data Analytics

September 2023 - January 2024

Managed to learn analytical processes such as business problem statement, data gathering/ extraction/ manipulation using Spreadsheet, SQL & Python, visualizing data & insight using Tableau and data storytelling skills to deliver recommendation clearly and effectively.

5 of 13

WORK EXPERIENCE

Implemented a comprehensive data management system to meticulously maintain precise lineage records for breeding pairs. Successfully sold more than 33 puppies, showcasing a commitment to excellence in breeding.

Mac House

Dog Breeder

July 2017 - Present

Developed online shop operation, applying analytical thinking to conduct strategic planning resulting in a remarkable 40% monthly sales growth. Demonstrated the ability to translate data-driven insight into actionable strategies, contributing substantially to business success.

Leveraged data analysis of product demand, including insight from daily transactions around 400k IDR in the first month, to optimize inventory, shipping , and customer processes, showcasing a practical application of analytical skills in an e-commerce setting.

Mac Vapor

Online Shop Owner

Sept 2021 - Nov 2023

In interior design, I participated in team projects and successfully completed 2 projects. Applied visualization techniques using tools like Autocad and 3ds Max to enhance communication and presentation of design concepts

Managed 4 structural projects, specializing in robust warehouse structures. Utilized AutoCad to implement efficiency measures, reducing project timelines by 15% for timely delivery of high-quality structures.

Interior Design

Freelancer

Sept 2016 - June 2017

6 of 13

SKILLS & ABILITIES

Data Cleaning, pivot table, hypothesis testing and simple visualization

Data cleaning, convert data type, merge dataset, EDA, EDV, correlation, clustering

Data analysis, data visualization, interactive dashboard

Get more value from data with dataset and machine learning technique

Spreadsheet / Excel

Python

SQL

Data function, CTE, window function

Use a clear and simple language to explain data finding by using picture like charts and graphs to make it easy to understand

Tableau

Analytics

Data Communication

7 of 13

PROJECTS DATA ANALYTICS

2. Maven Toys Sales Analysis

Deck | Python Script | Tableau Dashboard

5. Query For Brazilian E-Commerce Dataset

SQL Query Script

4. RevoShop Performance Analysis

Python Script

3. Steam Game Performance Dashboard

Tableau Dashboard

*click on the content to be redirect to the page!

1. Credit Card Customer Churn Analysis

Deck | Spreadsheet | SQL Query SCript

8 of 13

1. Credit Card Customer CHurn Analysis

Background

The credit card company is facing a problem with customer churn. A significant number of customers are leaving their credit card services, which can negatively impact the company revenue.

Methodology

Set the objective > Determine data needed for research > Collected data for analysis > Cleaning raw data > Analysis cleaned data > Create charts and graphs to visualize and communicate data > Gave recommendation based on analysis result

Result

Targeted retention strategies for married customers and graduate education segment.
Tailored credit products for low-income earners.
Enhance Gold and Platinum card benefits for wider appeal.
Analyze competitors for improved value proposition.
Support and resources for responsible credit management.

Tools

Spreadsheet > to clean, and do correlation analysis
SQL > exploratory data analysis
Tableau > to analyze and visualize

Individual Project

Link to : Deck | SQL Script | Spreadsheet

*click on the content to be redirect to the link!

9 of 13

1. Maven Toys Sales Analysis

Background

The toy store market is significant in Mexico's retail industry, with consumer behavior playing a crucial role. The Mexican toys market follows global trends but is also shaped by unique local cultural influences.

Methodology

Result

Expand stores in airports and commercial areas.
Focus on high-profit categories like Art & Craft and Toys. Boost sales with promotions during holidays and counter summer drops with exclusive deals.
Keep safety stock for high-demand products and use automated alerts.
Bundle slow-moving items with popular ones for strategic inventory management.

Tools

Python > to clean, analyze and visualize data
Tableau > to analyze, visualize and make interactive dashboard

Link to : Deck | Python Script | Tableau Dashboard

Individual Project

*click on the content to be redirect to the link!

10 of 13

2. Steam Game Performance Dashboard

Background

The dashboard primarily serves the CEO of the STEAM game company, with occasional use by other department heads. Its purpose is to optimize business performance by providing valuable insights into gaming trends.

Methodology

Connect dataset > Relate the dataset > Choose metrics > Create calculated field > Set up filter > Create interactive dashboard

Result

Asia spends the most on games (291.6), while North America spends the least (288.4).
Paid games are preferred, but 9,046 users opting for free games still form a significant market.
On average, gamers play 213.6 hours, highlighting strong engagement with Steam games.

Tools

Tableau > to analyze, visualize and make interactive dashboard

Individual Project

Tableau Dashboard Link

*click on the content to be redirect to the link!

11 of 13

3. RevoShop Performance Analysis

Background

RevoBank in Europe partners with RevoShop, an e-commerce marketplace. In the last 6 months, a new credit card promotion has been implemented, earning 2.4 euros (2.4% margin) for every 100 euros spent on the RevoShop platform.

Methodology

Data cleaning > Data analysis (EDA & descriptive statistic) > Data Visualization (Line chart / Bar Chart / Pie Chart) > Clustering using elbow & silhouette technique > Get insight from analysis and visualization

Result

Promote to the young age category for new high spenders. For low-value customers, offer special discounts. Focus on personalized promotions and incentives to convert low-value customers into high-value ones. Implement new promo strategies for the most spending customers on RevoShop.

Tools

Python > to analyze, visualize and some library (numpy, pandas, matplotlib, statistic, etc)

Individual Project

Python Script Link

*click on the content to be redirect to the link!

12 of 13

4. Query For Brazilian E-Commerce Dataset

Background

As a data analyst for a Brazilian ecommerce company, we need to leverage the Olist Store dataset to get better insights. This data can guide decisions on product stocking, pricing, targeted marketing, and enhancing the overall customer experience.

Result

Number of unique customer
City that have a highest cancel order
Month with the lowest total order in certain city
Category with the highest number of buyer in 2018

Tools & Methodology

SQL > basic sql syntax, aggregate function, date format, join data, window function

Individual Project

Link to : Query Script | ERD

*click on the content to be redirect to the link!

13 of 13

THANKS!

Let’s Connects! Open to questions, opportunities, or just a friendly chat. Excited to connect with you!

vvvnagel@gmail.com

+62-813-7740-7525

www.linkedin.com/in/vivian-makmur

*click on the icon to be redirect to the link!