- Optimize query performance(query cost) by changing query logic, using staging table or CTE, using indexes, select only required data, etc- Optimize existing data pipeline in Talend by simplifying components- Convert existing single-process flow from API into a batch process flow to improve data pipeline job execution time- Develop ETL data pipeline job- Data modelling for product enhancement- Migrate ETL data pipeline from Talend job to NiFi flowTools: Talend, SQL,… Show more - Optimize query performance(query cost) by changing query logic, using staging table or CTE, using indexes, select only required data, etc- Optimize existing data pipeline in Talend by simplifying components- Convert existing single-process flow from API into a batch process flow to improve data pipeline job execution time- Develop ETL data pipeline job- Data modelling for product enhancement- Migrate ETL data pipeline from Talend job to NiFi flowTools: Talend, SQL, PostgreSQL, NiFi, Java, Python, Linux Show less

• Install, configure, monitor, and maintain Greenplum Data Warehouse cluster.• Create a daily backup, restore, and housekeeping shell script for Greenplum. • Create a batch data pipeline and Cost Billing Dashboard in Google Cloud Platform (GCP) to track expenses and automate report to finance team.• Automate data ingestion & insertion from files in FTP Server to BigQuery (ETL).• Create a batch loading job from SQL Server to BigQuery using Python and Apache Airflow.• Monitor… Show more • Install, configure, monitor, and maintain Greenplum Data Warehouse cluster.• Create a daily backup, restore, and housekeeping shell script for Greenplum. • Create a batch data pipeline and Cost Billing Dashboard in Google Cloud Platform (GCP) to track expenses and automate report to finance team.• Automate data ingestion & insertion from files in FTP Server to BigQuery (ETL).• Create a batch loading job from SQL Server to BigQuery using Python and Apache Airflow.• Monitor and troubleshoot ETL jobs using Talend and IBM Datastage.• Built and simulate IOT streaming data pipeline from on premise to GCP to visualize data in real time.Tools: Python, GCP (BigQuery, Cloud Storage, Cloud Functions, Compute Engine, Pub/Sub, Dataflow, Looker Studio), VMware Tanzu Greenplum, Apache Airflow, PostgreSQL, MS SQL Server, Talend, IBM Datastage, Linux Show less

• Built an English & Indonesian Content-Based Recommender System for Sagara blog and Teknologi.id.• Utilize web scraping techniques to extract competitor’s website data for comparison and analysis.

GoTo Impact Foundation (previously Generasi GIGIH by Yayasan Anak Bangsa Bisa) is a development & training program created by Gojek to help accelerate digital transformation as well as make technology a carrier of positive change in Indonesia.In Data Analyst track, I learned about:• Introduction to data & roles in data career• SQL introduction & exercises, window function, and how to write an effective query• Statistics introduction & exercises, how to create an analysis… Show more GoTo Impact Foundation (previously Generasi GIGIH by Yayasan Anak Bangsa Bisa) is a development & training program created by Gojek to help accelerate digital transformation as well as make technology a carrier of positive change in Indonesia.In Data Analyst track, I learned about:• Introduction to data & roles in data career• SQL introduction & exercises, window function, and how to write an effective query• Statistics introduction & exercises, how to create an analysis document• Python introduction & exercises, Data Cleansing & Data Visualization in Python• How to make an effective Visualization Dashboard & exercisesTools:Google BigQuery, Google Data Studio (Looker Studio), Python, Google Colab Show less

• Maintain and cleanse Mailchimp database to efficiently reduce the cost and size of the database by 16%.• Derive actionable insights by conducting statistical hypothesis testing from Instagram data using Python.• Utilize web scraping techniques to extract competitor’s data from Instagram and Linkedin to create social listening dashboard for trend analysis.• Built data visualizations for business KPIs, events, and social media performance.• Install and maintain website analytics.

• Built data visualizations for business KPIs and social media performance.• Install and maintain website analytics.