Need Need
to to
10X 10X
your your
Data Data
Gameplay? Gameplay?
Let Let
me me
assist assist
you you
on on
your your
journey journey
in in
unveiling unveiling
these these
areas. areas.
ETL Development, Data Warehousing, and Data Migration
Efficiently process your data from datalake into datawarehouse in the most optimized structures through ETL process.
- Extract: Seamlessly ingest data from diverse sources.
- Transform: Apply advanced data modeling for actionable insights.
- Load: Store structured data in scalable warehouses.
Data Ingestion & Data Platform Development
Designing & developing robust collaborative systems for all of your data assets according to your workflow needs.
- Pipeline Builder: Streamline development with Dbt.
- Pipeline Scheduler: Orchestrate workflows using Airflow.
- Pipeline Orchestrator: Scale processes with Kubernetes.
Data Quality, Data Governance, and Schedule Optimization
Ensuring your data is reliable, consistent, and secure. By enhancing your data pipeline to accomodate 5 dimension of Data Quality.
- Availability: Maximize data uptime.
- Completeness: Fill in the gaps.
- Accuracy: Deliver high-quality information.
- Timeliness: Receive data when you need it.
- Consistency: Align data across systems.
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
Voluntary Projects
Bangkit Academy led by Google, Tokopedia, Gojek, & Traveloka
Bangkit Cloud Computing Tech Advisor
- Guiding two student groups (14 individuals) in understanding Bangkit's curriculum and their Capstone Projects
- Providing feedback, evaluations, technical support, and advice on the development of products or business ideas during their Capstone Project
Keluarga Mahasiswa Teknik Industri (MTI) ITB
Head of Professional Development Department
- Designed and fostered 2 divisions (Workshop Seminar Division & Alumni Talks Division) under the Professional Development Department
- Coached more than 20 staff & apprentices about project planning & project management with Airtable
- In total, managed to organize a national-level business case competition & 11 self-enhancement webinars attended by more than 500 participants
MTI Data Analytics Club
Vice President
- Arranged a workshop about data mining attended by more than 40 ITB undergraduatesOrganized a national-scale data analytics mini competition, participated by more than 40 students from all over Indonesia
Keluarga Mahasiswa Teknik Industri (MTI) ITB
Head Of Human Resources Department - Wisjul MTI ITB 2020
- Recruiting, Evaluating, and Managing more than 50 Wisuda Juli Staff
- Led Human Resources - Peer Evaluation & Customer Satisfaction Evaluation Projects
- Conducted mini workshop about "Brain Storming Technique with KJ Method"
IECOM 2020 (Industrial Engineering Competition by MTI ITB)
Fullstack Software Engineer
- Designed Industrial Finance Simulator for the Elimination Stage
- Made an Industrial Finance Simulator program, powered by VBA & Macro Excel
Will's Will's
fondest fondest
memory memory
fragments fragments
Memories Memories
are are
bound bound
to to
be be
made, made,
some some
to to
be be
cherished, cherished,
others others
to to
be be
shared. shared.
