About Me

Hi I am Syafniya Zilfah ,
I’m a Data Analyst with a strong interest in big data and business intelligence. I focus on applying statistical methods to transform data into actionable insights that drive smarter business decisions.

I primarily work with SQL, Python, Looker Studio, Power BI, and Metabase for data processing, analysis, and visualization. I also have a creative background in design, using Adobe Illustrator and Clip Studio Paint to enhance how data stories are communicated.

With a combination of analytical skills and creative thinking, I’m passionate about translating complex data into clear, impactful visuals that help businesses grow.

Download CV

Programming Skills

SQL

65%

Phyton

68%

35%

Other Skills

Tableau

60%

Metabase

65%

Looker Studio

85%

Power BI

60%

Clip Studio Paint

50%

Education

Sepuluh Nopember Institute of Technology, Indonesia

2018 - 2022

Bachelor of Statistics, Faculty of Science and Data Analytics, with a GPA of 3.44 out of 4.0

During college, I joined an organization under the Statistics Student Association at Sepuluh Nopember Institute of Technology called the Statistics Computer Course. I served as an HRD staff member for over a year. In this organization, we also had a program where every member took turns mentoring fellow students who wanted to learn about computer programming.

I was also involved in a department event called the Statistics Fair (Pekan Raya Statistika), where I worked as a graphic designer responsible for creating Instagram feed designs. Outside of these formal roles, many of my friends who were active in the Statistics Student Association often came to me for advice and discussions about their design work, even though I wasn’t officially part of that organization. I enjoyed these discussions, as they allowed me to exchange ideas and sharpen my creative thinking.

Working Experience

Data Analyst - Sinergi Ayu Semesta

July, 2024 — Now

During my time at PT Sinergi Ayu Semesta, I’ve been deeply involved in optimizing data workflows and building tools that connect data to real business needs. One of my early contributions was developing automation for the warehouse team, converting shipment receipts from PDF to structured Excel data using Python. This significantly improved accuracy and efficiency for managing daily e-commerce sales on platforms like TikTok and Shopee.

I also built multiple dashboards in Looker Studio to help sales managers track performance and assist the customer service (CS) team in reducing product return rates. Seeing the impact of data-driven decisions on day-to-day operations became a key motivation for me.

As the CRM division was introduced, I shifted my focus to customer lifecycle analytics, handling metrics like AOV, GMV, and CLTV while leading the migration of dashboards to Metabase for better operational reporting.

With no centralized database at the time, I also managed routine updates of reports across teams, ensuring every department had reliable and actionable insights. I even went a step further by developing an ARIMA-based B2B forecasting model to support long-term sales strategies, filling in gaps where our BI tools fell short.

I’m passionate about turning messy, fragmented data into clear insights that drive action — not just reporting numbers, but helping teams make better decisions every day.

Data Entry & Analyst - Little Joy Indonesia

August, 2023 — December, 2023

During my time at the startup, I was responsible for laying the groundwork in several key areas of data processing. One of my primary contributions was automating the conversion of raw e-commerce sales data into a format compatible with jurnal.id, streamlining the uploading process and reducing manual work.

Alongside this, I developed visual dashboards that showcased sales distribution and customer insights across product categories. These visualizations provided the warehouse, business, and R&D teams with actionable information for better planning and decision-making.

I also led a project to monitor toddler growth while consuming our products under controlled doses. The project involved two treatment groups and aimed to evaluate the effectiveness of our product offerings.

In addition to technical tasks, I supported the finance team by organizing financial data, improving the efficiency of cash inflow and outflow reporting, and contributing to smoother financial operations.

Data Analyst Intern - Qiscus

October, 2022 — April, 2023

Here, I'm sharpening my SQL skills even further. Additionally, I'm using different tools compared to my previous internship, unlocking new experiences.

Although I'm still dealing with sales data, I've come to understand that companies operating in different fields will have different data flows as well.

Data Analyst Intern - Smartfren

August, 2021 — February, 2022

The place where I first got to know and learn about SQL, data visualization, and started from scratch with mentors is where I feel this role is a combination of things I love - involving data, visuals, discussions, and presentations. But I realize that I still have a lot to learn.

Even though I interned here for 6 months and worked on 2 use cases, the learning I gained has shaped my career goals.

During my internship here, I've exchanged knowledge by providing insights on forecasting using Minitab.

Machine Learning Student - Google Bangkit 2021

Feb, 2021 — June, 2021

Bangkit Academy is an exclusive career readiness program initiated by Google and supported by leading Indonesian tech companies, including Tokopedia, Gojek, and Traveloka.

Designed to equip students with in-demand skills and industry-recognized certifications, Bangkit offers three interdisciplinary learning paths: Machine Learning, Mobile Development, and Cloud Computing. The curriculum focuses on technical mastery, soft skills development, and English communication, preparing participants for successful careers in the tech industry.

As part of the Bangkit Academy program, I participated in a Capstone Project as a final requirement for graduation. The project was carried out in teams of six members, with two participants from each learning path (Machine Learning, Mobile Development, and Cloud Computing). Each team selected a theme aligned with real-world problems, and we also received guidance from industry mentors throughout the development process.

My team chose the health sector, focusing specifically on the issue of stunting prevention. We developed a mobile application designed to detect the nutritional content of foods for pregnant women, breastfeeding mothers, and toddlers, addressing the critical first 1000 days of a child's life—a crucial period for preventing stunting.

I was responsible for the Machine Learning aspect of the project. I implemented YOLOv3 (You Only Look Once version 3) as our object detection model because of its ability to detect multiple objects in an image simultaneously. Since there was no readily available dataset for Indonesian foods, we collected and labeled the dataset ourselves as a team.

One of the challenges we faced was that calculating nutrition requires knowing the weight of the food, while our image data alone wasn't sufficient for that purpose. To solve this, we added an input feature allowing users to enter the estimated weight of the food manually.

Beyond food detection and nutritional analysis, the app also featured:
- Personalized menu recommendations based on the user’s budget
- Educational content about nutrition, maternal and child health, and stunting prevention
- This project taught me not only technical skills but also the importance of collaboration, time management, and adapting solutions to real-world limitations.

Teaching Assistant - Sepuluh Nopember Institute of Technology

Feb, 2022 — June, 2022

Teaching data exploration analysis courses every week contain 40 students.
Provide and assess the results of student assignments.
Guide the course of the class and answer questions from students regarding the course material.

I also developed my public speaking skills and discovered that speaking in front of an audience isn’t intimidating at all — it’s actually exciting. What I once thought was fear turned out to be just a mental barrier, and overcoming it gave me more confidence to express my ideas clearly.