Badges
Certifications
Work Experience
Data Analyst
Laku Emas Indonesia•  January 2022 - Present
• Investigated customer data in the database to utilize customer demographics using Python (Pandas, Seaborn) by data cleaning and an exploratory data analysis. The outcome are 3 main customer groups for product development and marketing approach. • Examined operational's timestamp data using GSheets to resolve time-consuming services. Analyzed transactional and behavioral from the database using GSheets (Vlookup, pivot, descriptive statistics) to generate insights, conclusions, and recommendations to speed up the services. Effected in 20% faster performance. • Communicated and collaborated with Finance and Marketing team to create insightful dashboards for monitoring. Transforming data using GSheets, and visualized using Google Data Studio. Presented the data visualization to Chief Operating Officer and other stakeholders who find the insights 50% faster (from 60 minutes to less than 30 minutes). • Designed Customer Profiling Analysis to give the most favorite product and a more well-targeted marketing campaign. Reducing 50% marketing cost. • Initiated Data Warehouse design using Google Big Query and ELT process using Airbyte and DBT to speed up data retrieval process up to 30% and reduce the load of OLTP Database. • Solved more than 15 data requests per month using intermediate queries (SQL) and functions (Excel). Networked with data stakeholders, so the request had completed in the most insightful ways.
Artifical Intelligence Content Creator
Ailima•  June 2021 - August 2021
Created 5 educational videos about Machine Learning Concepts (How Machine learned; Types of Machine Learning; Linear Regression; Non-Linear Regression; Classification) in 2 months, which was 25% more than average interns.
Consumer Loan Data Analyst
BCA•  November 2019 - February 2020
• Extracted consumer loan data from the data warehouse using SAP Business Object and SQL (querying). The results are 80% of extracted data are used for further analysis in Ms. Excel, and 20% for direct report. • Analyzed consumer loan data using Ms. Excel (Vlookup, groupby, descriptive statistics).
Education
State Polytechnic of Jakarta
Electrical Engineering, BAS•  August 2015 - September 2019
Thesis: Accomplished an Independent Component Analysis (ICA) model for separating silent chain sound and DC motor sound in audio wave data (.wav). The results were promising. It generated two audio files, and each file contains a dominant sound frequency of 700Hz (silent chain) and 1500Hz (DC motor).
Links
Skills
davidyohast has not updated skills details yet.