Abirafdi Gunawan
About Me
I am a person who has a strong willingness to excel in my field and is used to working
meticulously, as well as I always enjoy collaborating with others in a project, which
consequently I intend to make appropriate decisions that can contribute to the company and gain
security. I have done a number of data analysis cases in the real estate, finance, and retail
industry. I learned how to analyze data efficiently, create understandable dashboards, and
forecast future value based on time series. Moreover, I finished the Full Stack Data Analytics
program at RevoU for 3 months with acceptance rate <10% and achieved a score 90 out of 100.
Additionally, I became a data analyst coordinator who was responsible for extracting, analyzing
retail industry parameters, and forecasting. Our group also achieved the most active group in the
Final Project competition. Not only am I proficient in using data analysis tools (Excel, SQL,
python, and tableau), but also I am used to working meticulously and critically in facing cases in
order to give appropriate recommendations.
Education
Universitas Gadjah Mada
● Learning and comprehending statistical analysis such as probability, descriptive analysis, hypothetical analysis, time series forecasting utilizing Microsoft Excel and R. ● Learning and analyzing financial ratios from the transportation industry and comparing with relevant competitors in order to make investment recommendations.
RevoU
● Committing over 200 hours on online lectures (excluding assignments and final project) with instructors and mentors from tech industries for instance Tokopedia, XL Axiata Group, etc. ● Managed to learn the following analytical processes: o Defining business and problem statement o Gathering, extracting, and manipulating data using Microsoft Excel/Spreadsheet, SQL, and Python o Visualizing data and creating dashboard using Tableau and Looker studio o Comprehending and applying storytelling skills in order to deliver recommendations appropriately and effectively. ● Completing the program with an overall grade of 90/100 across all assignments
Universitas Gadjah Mada
● Learning and practicing end-to-end process to establish a start-up from market segmentation, selecting beachhead market, creating end user profile, calculating total addressable market, making persona profile, and creating mock up products. ● Learning and comprehending statistical analysis such as probability, descriptive analysis (ANOVA, regression), and hypothetical analysis utilizing Microsoft Excel and SPSS. ● Conducting undergraduate thesis on topic Design and Build of Data Acquisition System of Indoor Air Velocity In The Study Case of Building Management System At SMK Negeri 3Yogyakarta using Raspberry pi 3.
Work & Experience
Data Analytics Associate
RevoU
a. Understanding business problem ● Defining root causes on business problem of high number of bad applicants on credit applications ● Determining metrics to monitor and track current company’s performance based on applicants and debtors b. Data extraction ● Handling more than 600 thousands dummy data based on real world's complexity in finance industry using SQL BigQuery ● Utilizing basic SQL functions, aggregate functions, joins, CTE, windows function, date formatting, and subquery using SQL BigQuery c. Data cleaning and preparation using Python ● Working with more than 600 thousands data entries and carry out data cleaning, EDA, and data visualization using Python ● Implementing joining and aggregating using Python ● Implementing correlation analysis and cluster analysis using Python on 10 variables d. EDA and creating dashboard using Tableau ● Creating parameters, calculated fields, and visualizing exploratory data analysis in Tableau on more than 20 actionable metrics ● Visualizing current company’s performance on various business problems by designing, developing, implementing, maintaining, monitoring, and troubleshooting dashboard in Tableau e. Creating KPI dashboard for three different user’s level ● Defining metrics to show business performance for three different user’s level (CEO, product and operation manager, and collection team) ● Creating more than 8 charts with different time frame and filters in every user level f. Creating customer segmentation to improve marketing strategy ● Executing correlation analysis on 10 variables to determine which variables that were required to do segmentation ● Defined 3 customer segmentations using k-means clustering (elbow and silhouette method) ● Communicating segmentation result and findings to stakeholders by presenting report g. Forecasting the following year data using historical data ● Making forecast on 4 quarters in the following year to see the number of debtors ● Communicating forecast result and pattern findings to stakeholders by presenting report h. Creating impact analysis ● Implementing regression in order to see the distribution of applicants profile (high, medium, and low risk) as the impact of marketing strategy adjustment and the impact of application process handling duration ● Creating appropriate recommendation based on impact analysis to improve next year company’s revenue performance
Data Analytics Associate
RevoU
● Analyzing sales performance in Maven Toy Store ● Achieving the most active group in the Final Project Competition ● The dataset consists of 823,030 data recorded from January 2017 to September 2018, 35 products, 5 product categories, 50 stores, 29 cities, and 4 locations. ● Extracting and joining data from 4 separate datasets using SQL ● Analyzing parameters correlated to the retail industry such as ROI, Inventory Turnover Ratio, sales and profit trend, and transaction value in order to assess products’ sales performance. ● Forecasting the last quarter profit in 2018 using Python and Microsoft Excel to see whether the store achieved the 15% profit target. ● Designing, developing, monitoring, and troubleshooting dashboard in Tableau.
Instrument Engineer
South Pacific Viscose, PT. a Lenzing Group company
● Conducting daily sensor calibration and making report calibration results. ● Responsible for designing a measurement system of the caustic soda height in the caustic soda tank at wastewater treatment plant 2, which was unavailable before.
