Md Shahidul Islam

Data Architect | BI Developer | ETL Developer

Talent

Edmonton, AlbertaMember since July 22, 2023

Hire this person

Send a job offer directly to this candidate

About

Data Architect and Analytics Leader with over 4 years of experience building enterprise data warehouses, implementing BI solutions, and driving data-based decision-making. Adept at data modeling, ETL processes, visualization, and guiding stakeholders to actionable insights. Knowledgeable in SQL, AWS data platforms, Power BI, and Agile delivery. Committed to leveraging data to empower data-driven decision-making and fuel business success.

Knowledge Area: Data Management and Processes, DBA, Relational and Dimensional Modelling technique, Enterprise Data Warehouse, ETL, Data Integration, Data Mining, Data Visualization and Reporting, Agile Methodology, Azure DevOps, SQL Database, Azure Data Factory, Azure Data Lake, Azure Synapse Analytics and Amazon web services (AWS).

Data Modeling Tools: Microsoft Office 365, MS BI Stack SSMS, SSIS, SSAS, SSRS, Power Pivot, Power Query, Visual Studio, Dax Studio, and GIS software (QGIS).

Programming Languages: SQL, T-SQL, DAX, M, MDX, Python, R, and C++.

RDBMS: MS SQL Server, Oracle, MySQL, Postgres, Azure SQL Database and Azure Synapse Analytics.

Data Visualization Tools: Power BI, Tableau, Google Looker Studio, and Excel.

PROJECTS:

Supply Chain Data Modernization – Client’s Project

Led stakeholder meetings to identify business requirements, define master data management protocols, and develop data governance policies.
Successfully implemented solutions in an agile, fast-paced, and constantly evolving environment.
Conducted thorough data analysis and stakeholder engagement activities to build an Operational Data Store (ODS) with Relational Data Modelling (3NF) and Enterprise Data Warehouse (EDW) in dimensional Data Modelling Techniques.
Created SQL Server Integration Service (SSIS) packages and wrote T-SQL scripts for extraction, transformation, and loading (ETL) of data from different data sources to ODS, ODS to a staging area, and subsequently to the data warehouse.
Built OLAP Cubes using SQL Server Analysis Services (SSAS) for multi-dimensional and Tabular analysis for business users. These cubes supported interactive dashboards and data visualizations for informed decision-making.

Building an Analytic Environment for Class Attendance Management Systems – Client’s Project

Engaged with a wide range of internal and external stakeholders to drive collaborative initiatives.
Designed and built an Enterprise Data Warehouse (EDW) using Ralph Kimball’s Dimensional Data Modelling Approach based on business needs.
Performed data cleaning and migration using ETL packages with Control Framework databases on MS SQL Server, leading to a 40% improvement in data utilization.
Provided technical insights on how the client can fully utilize their data by creating dashboards and reports in Google Looker Studio, Power BI, Tableau, and SSRS.

Sales and Procurement Data Integration and Analytics Framework – Client’s Project

Led end-to-end analysis, design, and development of Source to Target Mapping, Transformation, and Data Quality processes and conducting research.
Involved in the development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
Designed SQL Server Integration Service (SSIS) packages and wrote T-SQL scripts for extraction, transformation, and loading (ETL) of data from various sources achieving a data integration accuracy rate of 80% and reducing data loading time by 30%.
Developed and deployed SQL Server Analysis Services (SSAS) OLAP Cubes to support the various business areas within the organization.
Developed interactive dashboards and reports using Power BI, Tableau, and Google Looker Studio, on sales analytics, contributing to a 15% increase in sales revenue.

Experience

Data Architect and Analyst, Arap Technologies Inc, Edmonton | Nov 2022- Present

Led complete database lifecycle management including installation, upgrade, troubleshooting, migration, and security.
Demonstrated successful implementation of data governance, data analytics, data quality enhancement, and various other data management tools.
Conducted stakeholder analysis and requirements gathering sessions, aligning data with business needs.
Designed Conceptual and Logical data models for OLTP Operational Data Store (ODS) Database.
Implemented Physical Data models using Bill Inmon’s Relational Modeling Techniques.
Created Bus Matrix (composition of Business process, Granularity, Facts, Fact Tables, and Dimensions)
Designed and implemented Enterprise Data Warehouse (EDW) using Ralph Kimball’s Dimensional Modelling Approach.
Created and configured Staging, EDW, and Control Framework databases on MS SQL Server.
Designed ETL SSIS packages for data extraction, transformation, and loading across various sources.
Built data marts (Cubes) using SSAS based on Star and Snowflake schema.
Implemented server agent for automated data loading and scheduling.
Developed advanced dashboards and reports using SSRS, Power BI, and Tableau.
Created an Azure SQL Database server instance and configured settings.
Experienced database migration to Azure SQL Database service using Microsoft assessment tools.
Successfully designed and implemented an end-to-end data engineering solution on Azure, including data ingestion, transformation, storage, and analytics components.
Experienced in SQL querying and development spanning stored procedures, de-duplication, views, functions, and cursors
Developed advanced dashboards and reports using SSRS, Power BI, and Tableau.

Technical & Quality Control Analyst, Polytubes Inc., Edmonton |09/2019 – 10/2022

Worked closely with Plant Manager, QC Manager, Production Manager, and Subject-matter Experts, to identify use cases, objectives, and business requirements for different projects.
Demonstrated dedication to staying current with industry trends and Agile principles, ensuring a proactive and informed approach to project management.
Demonstrates strong skills in data analysis, forecasting, and performance measurement, essential for effective decision-making and strategic planning.
Demonstrated expertise in Power BI and Excel data modeling for the creation of comprehensive dashboards, enabling data-driven decision-making and effective visualization of complex information.
Created interactive dashboards and reports using Power BI and Excel, leading to a 20% improvement in data accessibility.
Developed visual reports and Key Performance Indicator (KPI) scorecards with various filtering options using Excel Power Pivot and Power BI.

Research Assistant, University of Alberta, Edmonton | 09/2011 – 02/2019

Regularly engaged in discussions with both internal and external supervisors, presenting research outcomes using relevant examples to bridge the gap between technical expertise and stakeholder understanding.
Designed, implemented, and maintained an experimental data recovery system using Bill Inmon’s Relational Modelling Techniques in the Microsoft SQL Server.
Conducted data migration operations by utilizing ETL (Extract, Transform, Load) packages in SQL Server Integration Services (SSIS).
Created visualizations like scatter plots, box plots, and histograms using Excel, Power BI, SQL, and Python.
Presented findings at both local and international conferences and contributed to peer-reviewed journals through publication.

Meteorologist, Bangladesh Meteorological Department (BMD) | 06/2008 – 08/2011

Collaborated closely with the Director, Deputy Director, and subject matter experts to collect and document business requirements, ensuring alignment with organizational goals and project objectives.
Hand-on experience in using SQL and Python scripting and querying to retrieve specific data sets from Oracle relational database to efficiently extract and manipulate data for analytical and reporting purposes.
Experienced in Geographic Information Systems (GIS) applications, specializing in the use of the QGIS tool.
Prepared monthly and yearly technical and data analysis reports to inform decision-making processes within the organization, providing valuable insights and data-driven recommendations.