Anik Dian

My work centers around designing and implementing data governance frameworks and enhancing data quality across systems using Ataccama. Partner with business stakeholders to define data quality use cases and translate them into scalable technical solutions using Ataccama. Collaborate with IT and cross-functional teams to establish data standards, governance policies, and data stewardship processes aligned with enterprise architecture principles.

Experienced in Extract, Transform, Load (ETL) processes using SSIS, Azure Data Factory (ADF), and Informatica PowerCenter, integrating data from multiple sources into enterprise Data Warehouses. Developed interactive Power BI reports, dashboards, and KPI scorecards, applying advanced calculations such as aggregate, date, logical, numeric, and string functions. Contributed to the migration of on-prem SQL Server and SSIS packages to Azure SQL Database.

Utilized a wide range of SSIS transformations including Lookup, Derived Column, Data Conversion, Conditional Split, Merge, Merge Join, Multicast, Sort, Filter, Union All, and Aggregate to build robust and scalable ETL workflows. Created, deployed, and scheduled SSIS packages using SQL Server Agent, and published analytical reports using Power BI for business stakeholders. Experienced in troubleshooting data quality, validation, pipeline failures, and performance issues within Azure Data Factory (ADF).