Muhamad Agustiar Falahi

Muhamad Agustiar Falahi

Data Analyst
Malaysia
English, Indonesian (Bahasa)
Contract On-site

نبذة عني

Data Analyst and Business Intelligence professional with 9+ years of experience across SQL development, reporting, analytics, ETL, and data engineering, including approximately 5 years in dedicated BI and analyst roles. …

الخبرة

Data Engineer

Gojek Tokopedia · Jakarta , Jakarta , Indonesia
Jan 2025 - Jul 2025 · 5 أشهر

<ul><li>Migrated analytical datasets from Google BigQuery to Alibaba MaxCompute using Python, Pandas, PyArrow, and Parquet-based transfers, validating schema consistency and data integrity.</li><li>Orchestrated migration workflows with Apache Airflow and Docker, using GitLab CI/CD for repeatable deployments.</li></ul>

Data Engineer

Prudential Life Assurance Indonesia · Jakarta , Jakarta , Indonesia
Apr 2024 - Aug 2024 · 4 أشهر

<ul><li>Rebuilt legacy Greenplum-to-Excel reporting workflows in BigQuery and Power BI, translating SQL logic across platforms while preserving reporting requirements.</li><li>Reconciled migrated report outputs against legacy data and followed CAB-governed production release procedures to maintain reporting consistency.</li></ul>

Senior BI Developer

Prudential Life Assurance Indonesia · Jakarta , Jakarta , Indonesia
Jul 2020 - Mar 2024 · 3 سنوات 7 أشهر

<ul><li>Owned end-to-end BI reporting for PruWorks, delivering 15–20 operational reports across claims, actuarial, reinsurance, accounting, and membership for a platform serving 100+ corporate clients and 300,000+ insured members.</li><li>Led migration of the reporting layer from PostgreSQL to BigQuery, rewriting SQL queries and reconciling outputs with source data to maintain reporting continuity.</li><li>Designed four daily reporting refreshes around OLTP performance constraints, moving infrequently used reports to on-demand delivery to reduce unnecessary processing.</li><li>Developed a parameter-driven SSRS reporting solution to filter multiple date columns with one user input; documented the approach and obtained CAB approval.</li><li>Led cross-regional data mapping between PruWorks and Prudential Hong Kong’s FISERV platform, covering 50+ tables and 200+ fields with Business Analysts and Product Owners.</li></ul>

SQL Developer (Financial Data Analyst)

Traveloka · Jakarta , Jakarta , Indonesia
Dec 2018 - Apr 2020 · 1 سنة 4 أشهر

<ul><li>Supported Finance and FP&A reporting using SQL, Holistics semantic models, and Domo ETL workflows, providing data for financial analysis.</li><li>Monitored data refreshes, investigated upstream schema changes, and optimized SQL queries to improve reporting reliability, refresh performance, and compute efficiency.</li></ul>

Application Support

MNC Kabel Mediacom · Jakarta , Jakarta , Indonesia
Jan 2017 - Dec 2018 · 1 سنة 10 أشهر

<ul><li>Supported production applications and CRM/billing operations, performing approved MySQL data corrections, troubleshooting service issues, and conducting pre-release QA in a 24/7 operational environment.</li></ul>

Junior Consultant

Praisindo Teknologi · Jakarta , Jakarta , Indonesia
Jan 2016 - Dec 2016 · 10 أشهر

<ul><li>Supported investment-system migrations for Maybank, BNP Paribas, and CIMB, conducting module testing and user acceptance testing (UAT) through go-live.</li></ul>

المهارات

Power BI SSRS Domo Plotly PostgreSQL BigQuery SQL Microsoft SQL Server T-SQL MySQL Star Schema Dimensional Modeling Data Marts Data Reconciliation Report Validation Business Rules Python Pandas Apache Airflow Parquet dbt DuckDB Streamlit Pydeck Google BigQuery Alibaba MaxCompute PyArrow Docker GitLab CI/CD Greenplum Excel Holistics ETL SQL Data Engineering Reporting Analytics
الإبلاغ عن هذا الملف الشخصي؟