ETL | Data Warehousing | Data Platforms
Crafting Intelligent
Building and optimizing data pipelines, warehouses, and cloud-based platforms for efficient data processing and analysis
Loading...
About Me
William is a Full Stack Data & Platform Engineer whose had several experiences in both developing & maintaining data platforms. He's experienced in creating Data Ingestion, Data Warehouse, Pipeline Orchestration, and Data Quality & Governance. He specialized in cloud data & platform migration, feel free to reach out for business inquiries.
Education & Certification
Institut Teknologi Bandung (ITB)
Industrial Engineering Major - Bachelor of Applied Science (BASc)
Google Cloud
Professional Data Engineer (PDE)
- Design data processing systems
- Ingest and process the data
- Store the data
- Prepare and use data for analysis
- Maintain and automate data workloads
Some Quantifiable Achievements
- 2+
- Years of Experience
- 1000TB+
- Annual Processed Data
- 10+
- Data Source Aggregated
- 2+
- Certification & Awards
Experiences
Traveloka
Data Engineer - Data Warehouse Engineer
- Developed a custom script for Google Ads and Google Hotel API ingestion, reducing memory overhead by 75%
- Maintained data quality and governance through custom alerts, data remodeling, and BigQuery slot optimization, improving Traveloka’s data delivery timeliness from 60% to 100% in 4 months.
- Conducted an internal training program on Big Data and Data Warehousing with over 25 participants
- Developed, managed, and maintained thousands of data pipelines & ingestions for Flight, Train, Bus, Pricing, Marketing, and User Platforms
Shopee Ltd
Software Quality Assurance Automation Engineer - Marketplace
- Developed automation scripts and managed over 200 test cases for user marketplace logistics (MPL), marketplace orders, and user order lists in Shopee's iOS App using the XCUITest framework in Objective C
- Created more than 10 test cases for user identification features in Shopee's Android App using the UiAutomator and Espresso frameworks in Java
- Led final live regression testing for Marketplace Logistics (MPL), New Payment Channel Integration (MPP), User Cart, and Seller Wallet features, ensuring app reliability by executing over 250 regression test cases weekly
Sea Ltd
Junior Software Engineer - Digitalent
- Participated in the Digitalent program, a full-stack web development training course covering various technologies used by Shopee Pte Ltd
- Led a team of 5 developers to create a simple e-commerce app in 2 months, utilizing Golang+Gin for the backend and Typescript+React for the frontend. Implemented OAuth, Redis Caching, CI/CD Pipeline, and Cloud Deployment
- Developed simple e-wallet and restaurant booking apps using the same technology stack
- Organized a DigiTalk event on SeaTalk chatbot development, attended by over 100 participants
PT VISIONET INTERNASIONAL (OVO)
Business Intelligence Intern - Core Platform
- Worked on end-to-end data migration process from the on-premise server into the new Google Cloud Platform (GCP)
- Developed Cross-Platform Task Dependency feature on Airflow using REST API to streamline job scheduling BAU
- Created Python-based Email Blast feature on Airflow
- Conducted User Requirement Analysis, Data Modelling, ETL processes (BigQuery, Hive, Impala), developed dashboards (Tableau, Google Data Studio), and managed job scheduling (Airflow)
PT Paragon Technology and Innovation
Master Data Management Intern
- Assisted the MDM team in migrating over 50,000 B2B and B2C customer records from various databases to a new ERP system by designing & implementing data preparation procedures
- Developed a VBA-based consumer data preparation tool that cut data preparation time by up to 75%
- Collaborated with the MDM Team to standardize more than 15,000 product production routing data spread across 4 different factories
PT Cipta Wijaya Mandiri
Human Resource Business Partner Intern
- Worked out the 360-degree annual employee KPI (Key Performance Indicator) calculation project
- Conducted on-hand counseling on filling KPI surveys for over 1200 company employees