Application Support Engineer
2023 – 2026
PT Nawa Data Solution
Anti-money-laundering compliance platform for major Indonesian banks. AML, goAML, Case Management, PEP and Sipendar modules, with regulatory reporting to PPATK.
- Fixed transaction reporting logic on databases in the hundreds of millions of rows.
- Traced duplicate records back to a join-key mismatch, then turned the finding into a formal unit test document.
- Validated XSD schemas for suspicious transaction reporting.
- Cleaned a log table of roughly 145 million rows using batched deletes.
- Optimised SQL Server queries and SSIS ETL pipelines, and wrote sequence diagrams for a process parallelisation effort.