Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Mueen Fazlul

Missisuaga,Canada

Summary

Results-driven Data Analyst with over 10 years of expertise in the MSBI (Microsoft Business Intelligence) stack, including SSIS, SSRS, and SSAS. Demonstrated proficiency in data analysis, data modeling, and data warehousing concepts. Skilled in building interactive dashboards, data visualization, and writing optimized SQL queries to drive data-driven decision-making. Experienced in Microsoft BI technologies, with a strong focus on ETL development, reporting automation, and analytical solutions to deliver actionable insights to management and stakeholders. Well-versed in MSBI Suite (SSIS, SSRS, SSAS), Power BI, and SQL Server, complemented by a solid background in working with relational databases such as Oracle, DB2, and Netezza. Adept at designing scalable data models, implementing SCD techniques, optimizing T-SQL scripts, and developing ETL pipelines to enhance data processing, visualization, and enterprise reporting capabilities.

Overview

16
16
years of professional experience

Work History

Data Analyst

Obsitech Intelligent Technologies
04.2023 - 11.2024
  • Designed and developed SSIS ETL packages to extract, transform, and load (ETL) data from heterogeneous sources such as SQL Server, Oracle, and flat files into data warehouses.
  • Implemented Slowly Changing Dimensions (SCD) Type 1 & Type 2 in SSIS to manage historical data changes in the data warehouse.
  • Developed and optimized T-SQL queries, stored procedures, and views for efficient data transformation, cleansing, and validation in SQL Server.
  • Created complex SSRS reports with drill-through, drill-down, sub-reports, and parameterized filters for enhanced data visualization and reporting.
  • Designed and optimized SSRS dashboards to deliver real-time business insights using data from multiple sources.
  • Integrated SSIS with SQL Server Agent to automate scheduled ETL processes for data warehouse updates and incremental loads.
  • Used SSIS to perform data profiling, cleansing, and validation to ensure data integrity before loading into staging and production environments.
  • Developed SSIS packages using Script Tasks and Conditional Splits to handle complex data transformations.
  • Designed and implemented data partitioning strategies in SQL Server to improve query performance and optimize large data warehouse loads.
  • Created fact and dimension tables in a star schema for optimized reporting and analysis in a data warehouse environment.
  • Utilized SSIS logging and event handling mechanisms to capture execution statistics, errors, and debugging information for ETL monitoring.
  • Tuned T-SQL queries and indexing strategies to optimize report performance and ensure efficient data retrieval in SSRS.
  • Developed SSIS packages for incremental data loading, handling CDC (Change Data Capture) to track and process only changed records.
  • Designed security models in SSRS, implementing row-level security (RLS) to restrict access to sensitive data based on user roles.
  • Worked on performance tuning of SSIS packages by optimizing data flow transformations and minimizing memory-intensive operations.

Project Lead Consultant

Datamatics Global Services LLC
07.2022 - 01.2023
  • Led the end-to-end migration of SAP BO 4.1 reports to SSRS and Power BI for Dubai Islamic Bank, ensuring optimized performance and seamless transition.
  • Designed and implemented SSIS ETL packages to extract, transform, and load (ETL) data from multiple sources, including SQL Server, Oracle, and flat files, into data warehouses.
  • Developed SSIS data pipelines to automate data integration processes, incorporating data cleansing, deduplication, and validation techniques.
  • Designed and optimized SSRS reports with parameterized filtering, drill-down, and drill-through functionalities to provide interactive business insights.
  • Played a key role in converting SAP BO 4.1 reports and queries into SSRS, leveraging T-SQL, stored procedures, and SSAS data models for improved analytical capabilities.
  • Built and optimized SSAS multidimensional and tabular models, implementing aggregations, hierarchies, and calculated measures for advanced reporting and analysis.
  • Ensured seamless data validation by collaborating with end-users to reconcile migrated reports and validate business logic consistency.
  • Developed complex SSIS packages using Lookup, Merge Join, and Conditional Split transformations to support Slowly Changing Dimensions (SCD) Type 1 & Type 2 for historical data tracking.
  • Designed and deployed Power BI dashboards integrating data from SQL Server, SSAS, and Excel, enabling data-driven decision-making across various departments.
  • Created and optimized T-SQL queries, stored procedures, and functions to enhance report performance and improve data retrieval efficiency.
  • Implemented security measures in SSRS, including role-based access control (RBAC) and row-level security (RLS), to protect sensitive financial data.
  • Designed and automated SSIS ETL workflows with SQL Server Agent to enable scheduled data refresh and incremental data loads.
  • Led the optimization of SSRS reports by implementing indexing strategies, partitioning techniques, and query performance tuning.
  • Collaborated with business stakeholders to gather reporting requirements and translate them into actionable insights using SSIS, SSRS, SSAS, and Power BI.

Data Analyst

Dubai Islamic Bank
04.2018 - 06.2022
  • Documented effective and replicable methods for extracting data from different sources and organizing structured datasets for various departments in the bank.
  • Developed and optimized SSIS ETL packages to extract, transform, and load (ETL) data from Oracle, DB2, Netezza, and Intellect System into SQL Server Data Warehouse for reporting and analytics.
  • Collaborated with stakeholders to identify business needs, data sources, and reporting requirements for financial, risk, and operational analytics.
  • Extracted and transformed data using T-SQL and SSIS from various relational databases and staged it in the enterprise data warehouse to support business intelligence initiatives.
  • Designed and deployed SSRS reports, including paginated reports, drill-through, and parameterized reports, to support financial and operational reporting needs.
  • Created interactive dashboards in Power BI, incorporating advanced DAX measures, drill-downs, slicers, and KPIs for enhanced visualization and decision-making.
  • Built and optimized SSAS tabular models, implementing calculated columns, hierarchies, and row-level security (RLS) to facilitate self-service analytics.
  • Developed universes using the Information Design Tool in SAP BI 4.1, converted WebI reports into SSRS and Power BI, and scheduled reports for top management.
  • Played a key role in Noor Bank Migration with Dubai Islamic Bank, including the testing, conversion, and development of legacy reports into SSRS and Power BI within the Dubai Islamic Bank Environment.
  • Conducted exploratory data analysis using SSIS and SQL Server, identifying patterns, trends, and inconsistencies before data was loaded into analytical models.
  • Validated data for system upgrades (DB2, Intellect System) and coordinated with stakeholders and business analysts to ensure accurate migration and reporting.
  • Designed and automated SSIS ETL workflows to facilitate incremental loads, implement Slowly Changing Dimensions (SCD) Type 1 & Type 2, and optimize data movement.
  • Integrated SQL Server databases with external applications using SSIS to ensure seamless data exchange between banking applications and reporting systems.
  • Scheduled and monitored automated SSIS jobs to refresh reports, ensuring timely and accurate data availability in SSRS and Power BI.
  • Optimized Power BI Datasets using aggregations, calculated columns, and DAX measures to enhance report performance and efficiency.
  • Developed and maintained SSRS reports with drill-through and sub-reports, ensuring structured and interactive reporting experiences.
  • Provided training and support to end-users on managing automated workflows and navigating Power BI & SSRS reports efficiently.
  • Collaborated with stakeholders to gather reporting requirements, define data models, and prioritize SSIS, SSRS, and Power BI development efforts.
  • Integrated Power BI with Microsoft Azure services, such as Azure SQL Database, supporting large-scale data processing and analytics.
  • Monitored user activities and enforced security policies to ensure compliance with regulatory standards and maintain data integrity across SSRS, SSAS, and Power BI reports.

Power BI Developer

Dicetek LLC
12.2016 - 03.2018

Data Analyst

HTP Global Technologies
05.2015 - 12.2016

SAP Business Intelligence Consultant

ICICI Prudential
05.2014 - 05.2015

Business Objects Developer

Vinculum Group Ltd
10.2013 - 03.2014

Software Engineer

Ninemind Software Solutions Pvt Ltd
05.2009 - 10.2013

Education

Bachelor of Technology - Electronics And Communication

Jawaharlal Nehru Technological University
05.2008

Skills

  • Data Analyst
  • Power BI
  • SAP Business Intelligence
  • SSRS
  • Azure Data Factory
  • Databricks
  • SSIS
  • Data Lake Store (Gen 2)
  • Data Factory
  • Pyspark
  • MS SQL
  • Azure SQL
  • Netezza
  • Oracle
  • DB2

Languages

English
Full Professional

Timeline

Data Analyst

Obsitech Intelligent Technologies
04.2023 - 11.2024

Project Lead Consultant

Datamatics Global Services LLC
07.2022 - 01.2023

Data Analyst

Dubai Islamic Bank
04.2018 - 06.2022

Power BI Developer

Dicetek LLC
12.2016 - 03.2018

Data Analyst

HTP Global Technologies
05.2015 - 12.2016

SAP Business Intelligence Consultant

ICICI Prudential
05.2014 - 05.2015

Business Objects Developer

Vinculum Group Ltd
10.2013 - 03.2014

Software Engineer

Ninemind Software Solutions Pvt Ltd
05.2009 - 10.2013

Bachelor of Technology - Electronics And Communication

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Mueen Fazlul