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.