At Fisclouds, I proposed data warehouse framework solutions for data lakehouse projects on Google Cloud. I designed integrated ODS, DWH, and data mart workflows, including reruns, rollbacks, archival, monitoring, and restoration from Google Cloud Storage to BigQuery.
I also led and managed DWH and data engineering teams, coordinating with infrastructure, data governance, and PMO teams. I developed VBA scripts to generate SQL for Dataform and DDL from Excel, and prepared FSDs, TSDs, and DWH development guidelines.
At NITYO INFOTECH, I created and enhanced data models for ODS and EDW environments, analyzed data mapping requirements, and designed data mart tables and query mappings for ETL developers. For AIA Indonesia projects, I worked on customer experience and reporting data marts, and helped establish mapping requirements and documentation standards.
At PT. Emerio Indonesia => NTT, I progressed from Senior ETL Developer to Technical Lead and Team Lead and Assistant Project Manager. I completed ETL work from requirements gathering through golive and PVT for projects at Standard Chartered Bank and Coca Cola Amatil Indonesia, and managed teams of ETL specialists and mixed-discipline project members.
