Data & Backend Engineer

Zulvan Avivi Akmal Firdaus

Data and Backend Engineer focused on building and optimizing data pipelines and automating ETL and reporting workflows for finance, actuarial, and investment teams. Comfortable owning solutions end to end — from requirements and SDLC documentation to deployment — across SQL, BigQuery, Talend, SSIS, and Power BI, with a background in backend development and scalable APIs.

zulvanavivi@gmail.comlinkedin.com/in/zulvan-avivigithub.com/superziper

Work Experience

NTT Data

Jakarta, Indonesia

ETL Developer — SMBC Indonesia

Dec 2022 – Jun 2024
  • Implemented ETL solutions using SQL Server Integration Services (SSIS) and queries through SQL Server Management Studio (SSMS) to automate data integration tasks and streamline data flows
  • Collaborated with business analysts and stakeholders to gather requirements, analyze data sources, and define ETL specifications
  • Developed and maintained documentation for ETL processes, including technical specifications, data mappings, and process workflows
  • Provided support and troubleshooting for ETL jobs, resolved production issues, and performed root cause analysis to prevent recurrence
SSISSSMSSQL ServerETL

Associate Data Engineer — Bank Danamon

Jun 2024 – Jul 2025
  • Provided support for users on their regulatory reporting, debugging errors and ensuring every data pipeline correctly executed
  • Decided which part of the data pipeline needs to be fixed when an error or change request happens, through log reading and SQL queries
  • Maintained and enhanced the current data flow to ensure seamless data integration in both big data (Talend) and server-level databases (SSMS)
  • Supported the creation of SDLC documentation on projects and RCA documents when issues happen
TalendSSMSSQLBig Data

Prudential Indonesia

Jakarta, Indonesia

Finance Data Engineer

Current
Jul 2025 – Now
  • Deliver and maintain data solutions for the finance, actuarial, and investment teams across the full SDLC, from requirements gathering and stakeholder discussion through deployment, documentation, and maintenance
  • Serve data for internal and external reporting through Power BI dashboards, SSRS reports, and automated file generation, sourcing from Google BigQuery and MS SQL Server
  • Automated monthly financial statements previously prepared manually in Excel, streamlining the finance team's monthly close
  • Automated recurring journal uploads to the SUN general ledger system, replacing a manual file-preparation process and reducing room for error
  • Improved the performance of a slow legacy dashboard by re-architecting how its data is processed and delivered, significantly cutting refresh time
  • Provide ad-hoc data extraction and analysis to support finance, actuarial, and investment stakeholders
Power BIBigQuerySSRSSQL Server