Jeffrey Wijaya

Skills

SQL, MySQL, PostgreSQL, ETL/ELT, Data Cleaning, Data Validation, Data Quality, Python, Google Colab, Matplotlib, Data Visualization, Flourish, Microsoft Excel, PivotTables, Power Query, Microsoft Excel, Microsoft Word, Figma, PPT.

About

I’m Jeffrey Wijaya, a data-driven analyst who ships clean pipelines and decision-ready dashboards. At PT Bank Danamon Tbk (IT Financial Control Analyst Intern), I maintain CAPEX/OPEX data and rebuilt a manual refresh into a one-click Excel Power Query pipeline with validation and basic logging, cutting cycle time from 3 hours to 15 minutes (~92% faster) and making the process auditable and handover-friendly. Previously at Indonesia’s Ministry of Foreign Affairs, I contributed end-to-end to the Gastrodiplomacy Information System (requirements → design → dashboards → maintenance) and engineered MySQL data flows (clean/insert/delete with checks). I also supported Indonesianist and SIDE websites, handling PostgreSQL cleaning, insertion, deletion, and integrity validation for profile and indicator datasets. To support issue monitoring (incl. Trump-era tariff topics), I built and visualized metrics such as Change Rate Index, Daily % Change in Exchange Rate to USD, and Industry Index using Python (pandas) and Flourish; I’m equally fluent in Excel pivots for multi-country historical currency/economic series, ranking Top-10 via dynamic queries. Toolset: SQL (MySQL/PostgreSQL), Python, Excel/Power Query, Flourish, data modeling/validation. Focus: reliable, auditable data products that stakeholders actually use.