Data Analyst Python

Oneal Suwandi

404-***-**** ************@*****.*** /in/oneal-suwandi-6058b5134/ Atlanta, GA

EDUCATION

Georgia Institute of Technology Atlanta Jan 2016 – May 2020

● Bachelor’s Degree Major: Industrial Engineering Concentration: Data Science/Analytics EXPERIENCE

Data Analyst/Co-Founder, B2C E-commerce Startup (vtlstore.com), Jakarta Aug 2016 – March 2018

● Built a B2C e-commerce website with Python and SQL that generated more than $135,000 in annual revenue.

● Increased website traffic by 60% by analysing traffic data in Tableau to refine target audience.

● Cut shipping cost and transit time by 25% by optimizing shipping routes, packaging, and couriers.

● Created monthly performance reports using visualizations with Tableau to track sales and traffic growth. Technical Skills: Tableau, Python, SQL

Business Analyst Intern, Enchanting Sanitary Ware Co., Jakarta May 2014 - Aug 2014

● Defined KPI through analysis in Excel to identify a problem that was causing a decrease in annual growth.

● Increased market share by 30% by conducting competitor and industry research to identify expansion areas. Technical Skills: Microsoft Office (Word, Excel)

PROJECTS

Atlanta Zoo SQL Database Project, Georgia Institute of Technology, Atlanta Jan 2019 – May 2019

● Built 10 SQL Schema with multiple Keys, Cascades, and References as the back-end of a desktop application.

● Developed 30+ SQL queries with multiple Joins, Aggregate Functions, Group By, and Expressions to connect database. Technical Skills: SQL

Data Mining Script,E-commerce Startup (vtlstore.com), Jakarta Jan 2019 – March 2019

● Collected 1500+ pricing data from 10 vendors using Python (Requests and Pandas)that updates the lowest price.

● Increased sales by 100% over 1 month of implementation. Technical Skills: Python

Space Optimization Capstone Project, Peachtree Presbyterian Church,Atlanta Oct 2019 – Apr 2020

● Defined KPI using root-cause analysis to identify problems causing heavy congestion in the parking system.

● Established a data collection system using Excel (VBA and Macros) to collect traffic data from the past 6 months.

● Reduced average congestion time by 40% through modeling the client’s entire parking system in Simio and test potential solutions. Technical Skills: Microsoft Excel, Simio

Neural Network Machine Learning Project,Georgia Institute of Technology, Atlanta Aug 2019 – Dec 2019

● Trained a neural network in Python (Jupyter Notebook)using gradient descent algorithm to translate handwriting to computer text. Technical Skills: Python, Jupyter Notebook

VOLUNTEERING

Platform/Content Manager, GT Indonesian Student Association,Atlanta Aug 2018 – May 2019

● Redesigned UI of website and created monthly newsletters which increased website traffic by 50%

● Increased event attendance rate by 193% (from 231 to 447) through targeted advertisement. Technical Skills: Facebook Advertising, Google Analytics, HTML

Contact this candidate