Alom

Associate manager

BRAC • Full-time

Mar 2020 - Present • 6 yrs 6 mos

Architect and maintain enterprise Snowflake data warehouses, and design Microsoft Fabric medallion (bronze/silver/gold) Materialized Lake View pipelines sourcing from Dynamics 365 Finance & Operations. Lead an end-to-end ERP-to-Snowflake data migration (legacy NetSuite system), building cleansing and transformation logic to consolidate financial data into a unified Snowflake warehouse. Design and support Databricks/PySpark transformation workflows alongside Snowflake ELT pipelines for large-scale data integration across multiple source systems. Built an automated Fabric data-validation framework in Python that connects to Lakehouse tables/MLVs, runs comparison queries, and generates branded HTML validation reports for QA sign-off. Manage ETL/ELT processes using Snowpipe, Streams, and Tasks for continuous, accurate data loading; optimize Snowflake performance through query analysis and workload tuning, reducing computing costs by 25%. Administer SQL Server and Azure SQL Database/VMs — installation, AlwaysOn Availability Groups, failover clustering, backup & recovery, and disaster-recovery planning. Enforce data security and governance through RBAC, encryption, and access-control policies across Snowflake and Azure environments; provide 24x7 support for critical production systems. Collaborate with data analysts and data scientists to translate business requirements into scalable data models, dashboards (Streamlit), and documented, production-ready solutions.