BI Developer and Data & Reporting Analyst with 15 years in IT roles at Indonesia's Ministry of Finance and 3+ years building production dashboards for leadership and clients. Delivers end-to-end reporting solutions: extr…
BI Developer and Data & Reporting Analyst with 15 years in IT roles at Indonesia's Ministry of Finance and 3+ years building production dashboards for leadership and clients. Delivers end-to-end reporting solutions: extracting data from SQL Server and MySQL, building ETL pipelines in SSIS, Python, and Power Query, designing star-schema data models, and publishing executive dashboards in Tableau Server, Power BI, and Excel.
<p>Designed and built “BPPK dalam Angka”, the agency's official statistics dashboard on Tableau Server, delivering 68 visualizations across six menu categories for agency leadership and work units.<br>
Engineered the data pipeline behind it by integrating a MySQL learning database, a legacy database, and a SQL Server warehouse using SSMS, SSIS, and a Python ETL that reloads monthly without duplicate records.<br>
Improved dashboard performance by moving derived fields from Tableau calculations into the ETL layer.<br>
Built the Career Interest & Transfer Survey dashboard in Tableau, including a zone-based map sized by applicant count, with refresh automated through Power Automate, SSMS, and SSIS to support staff transfer planning.<br>
Delivered two room-booking solutions using Microsoft Forms, Excel, and SharePoint, letting users check availability before booking and reducing schedule conflicts.<br>
Developing a Tableau overview of the Ministry's organizational performance scores for 2025–2026.<br>
Manage, validate, and prepare learning data for reporting, analysis, and leadership decisions.<br>
Write MySQL extraction queries to fulfil data requests from other Ministry units.<br>
Enforce data governance and personal data protection by publishing only aggregated data on shared platforms.<br>
Author operations manuals and socialization materials for administrators and reviewers.<br>
Review dashboard designs for continuous improvement.<br>
Provide application and database support, including troubleshooting application connections to SQL Server.</p>
<p>Developed executive dashboards for the Ministry of Finance Executive Information System (EIS) in Tableau on SQL Server data.<br>
Prepared SQL queries and datasets.<br>
Aligned metric definitions and data quality with data owners across directorates.<br>
Built a state budget (APBN) dashboard in Power BI for the Directorate General of Budget using Power Query for transformation and DAX for indicator calculations.</p>
<p>Progressed through the government IT functional track (Pranata Komputer) over 14 years.<br>
Received promotions in 2022 and 2024.<br>
Developed leadership dashboards in Power BI to monitor training data and performance indicators.<br>
Used Power Query for data preparation and DAX for measures.</p>
<p>Delivered 24 paid dashboard engagements for professionals, SMEs, and corporate teams in 10+ sectors, mainly in Excel, Power BI, and Google Sheets.<br>
Owned the full delivery cycle as a solo consultant: data assessment, scope and pricing, build, versioned revisions, handover training, and post-delivery support.<br>
Built Power BI solutions with Power Query ETL, data models, and DAX.<br>
Built “paste and refresh” Excel dashboards for multiple business use cases.<br>
Built compliance and operations monitoring tools.<br>
Audited client data before building and reported issues with proposed fixes.<br>
Earned repeat business, including a petrochemical client with six paid iterations over three months.<br>
Kept all client data confidential and never reused it as portfolio material.</p>
نظام التوظيف التشغيلي المعتمد على الذكاء الاصطناعي أولاً، الذي يوحّد ويؤتمت دورة التوظيف بالكامل للمؤسسات الحديثة حول العالم.
د.جوب منطقة حرة ذ.م.م. 2026 © جميع الحقوق محفوظة
