Data Analyst - Logistic & Verification

• Dec 2022 - Present

Became the Subject Matter Expert (SME) in terms of data for logistics, collection points, and verification business units, from data ingestion, maintenance, tracking, and reporting. • Automated logistics, collection points, and verification KPI metrics performance tracking and reporting by using dashboards and reports in Metabase and Tableau. • Collaborated with the Data Science team to predict and simulate strategic locations for collection points in Bandung Raya, then visualized them in Metabase using BigQuery SQL and Apache Airflow. Managed to help the operation team to open new 50 Collection Points. • Created self-service analytics for the logistics team to simplify their calculation process by combining multiple data sources into a single source of truth for logistics-related data in Metabase using external data ingestion through DBT (Data Build Tool), Apache Airflow, and BigQuery SQL. • Helped the logistics teams to plan their operation expansion in Jawa Tengah by providing them with a geographical heatmap dashboard in Tableau and insights from the dashboard. • Automated COD (Cash on Delivery) payment reconciliation tracking and reporting for the logistics and finance teams in Metabase using external data ingestion through DBT (Data Build Tool), Apache Airflow, and BigQuery SQL. • Designed, ran, and analyzed an A/B test experiment, alongside the product and logistics teams, to test the effect of removing delivery fees in deliveries with 3-day SLA to ATV (Average Transactional Value). • Created and reviewed trackers for data quality sanity check using Metabase Pulse. • Scheduled data models using Apache Airflow. • Delivered various ad-hoc request analyses (trend analysis, cohorts, etc) correctly for stakeholders. Show less

Data Analyst

• Jul 2022 - Dec 2022

• Helped the partnership business team track and monitor P2P channeling performance to fintech partners using BigQuery SQL and GoogleData Studio (Looker).• Supported a cashback campaign by tracking and reporting the number of eligible customers and their eligible amount of cashback usingBigQuery SQL, DBT (Data Build Tool), and Gsheet.• Monitored, analyzed, and reported the performance of monthly payroll services through BigQuery SQL and Gsheet. Gaverecommendations to stakeholders on ways to reduce the outflow amount to other banks right after payroll.• Created and maintained datamarts required by the partnership business team with BigQuery SQL using Extract-Transform-Load (ETL)process through DBT (Data Build Tool), Gitlab, and Apache Airflow.• Delivered ad-hoc request data correctly using BigQuery SQL and Gsheet for stakeholders. Show less

Credit Risk Analyst Intern

• Jun 2021 - Jun 2022

• Monitored and reported daily Liquidity Coverage Ratio (LCR) and Net Stable Funding Ratio (NSFR) by leveraging data using MSSQL andExcel.• Created monthly credit vintage analysis report using MSSQL and Excel.• Helped to automate credit risk monitoring in a dashboard using Google Data Studio and BigQuery SQL.• Assisted POC backtesting for credit risk assessment done by vendors using Python and Excel.• Assisted in creating a multivariable linear regression model to predict PD for PSAK71 reporting using Python and Excel. Show less

Treasurer

• Nov 2020 - Nov 2021

Laboratory Assistant at Laboratorium Fisika Dasar

• Aug 2019 - Nov 2019

Laboratory assistant at elementary physics laboratory, which responsible of overviewing and guiding practician throughout lab activities, giving instructions, explaining theories, also reviewing and grading their reports. Laboratory assistant at elementary physics laboratory, which responsible of overviewing and guiding practician throughout lab activities, giving instructions, explaining theories, also reviewing and grading their reports.