Samuel Willyanto Email & Phone Number

South Jakarta, Jakarta, Indonesia

• Created ETL processes for synchronizing data via APIs, ensuring up-to-date and accurate data transfer.• Developed automated ETL pipelines for client transactions between two different APIs, facilitating seamless data exchange by retrieving purchase orders from one API and posting sales orders to another.• Enhanced existing ETL pipelines with robust logging mechanisms, simplifying error detection and maintenance by storing temporary invoices when failures occurred.• Conducted R&D on n8n, exploring its potential to trigger actions via webhooks and expand automation capabilities.

South Jakarta, Jakarta, Indonesia

• Maintained and monitored ETL pipelines for a major client with over 70+ distributors, ensuring seamless data flow and integration using Pentaho Data Integration.• Developed ETL pipelines for new distributors, ensuring scalable integration with the existing system.• Optimized ETL pipelines by implementing global variables, streamlining future maintenance efforts.• Automated ETL processes using Apache Airflow.• Gained hands-on experience in infrastructure management, including Linux environments and Docker Container.• Worked with PostgreSQL and gained foundational knowledge in Google BigQuery.• Implemented exception handling in ETL processes to automatically send email notifications for errors caused by data anomalies or other issues.• Developed Docker images for running Pentaho on VPS, ensuring consistent and scalable deployments.