Mohammed is currently unavailable
Mohammed Adil Mohiuddin
Verified Expert in Engineering
BI Developer
Cambridge, ON, Canada
Toptal member since February 7, 2024
Bio
Mohammed is a senior BI engineer with nine years of experience designing and modernizing enterprise analytics platforms using Power BI, SQL, and cloud data technologies. He specializes in building governed semantic models, optimizing large-scale datasets, and transforming legacy reporting environments into scalable, high-performance analytics solutions. Mohammed has delivered enterprise dashboards and self-service analytics used by hundreds of business users across multiple industries.
Portfolio
Three Five Two
BI Reporting, Microsoft Power BI, Microsoft Report Builder, SSRS Reports...
Canada Life
BI Reporting, SSRS Reports, DAX, Power Query, Tableau, SQL, Azure SQL...
Android Industries
SQL Server 2016, SQL Server 2012, SQL Server Integration Services (SSIS)...
Experience
- Power Query - 9 years
- Microsoft Power BI - 9 years
- SQL - 9 years
- Business Intelligence (BI) - 9 years
- Microsoft Report Builder - 9 years
- DAX - 8 years
- SQL Server Analysis Services (SSAS) - 6 years
- SQL Server Integration Services (SSIS) - 6 years
Preferred Environment
Microsoft Power BI, DAX, SQL, Microsoft Report Builder, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), Azure, MSBI
The most amazing...
...thing I've developed is an end-to-end dashboard for a large manufacturing facility, which became an exceptional tool for process improvement.
Work Experience
Power BI Expert | Senior BI Developer
2024 - 2026
Three Five Two
- Engineered end-to-end Power BI solutions encompassing semantic modeling, complex DAX measures, and performance tuning for enterprise-scale reporting.
- Designed and optimized Power BI semantic models following star schema best practices to support scalable analytics across large enterprise datasets.
- Built and maintained advanced RDL paginated reports for operational and regulatory consumption.
- Designed and optimized PostgreSQL views and materialized views, improving query performance and supporting scalable reporting and analytics use cases.
- Optimized slow Power BI reports using Performance Analyzer, DAX Studio, and query diagnostics, reducing report load times and improving user experience.
- Performed data validation and QA testing across source systems and BI outputs to ensure data accuracy, consistency, and reliability.
- Partnered with product owners and business stakeholders in Agile sprints to refine business requirements and user stories, resolve data issues, and deliver incremental BI enhancements.
- Implemented row-level security (RLS) and governance controls to ensure secure, role-based access to sensitive data.
- Developed automated API-based (REST/JSON) data pipelines using Python and Power BI to extract, transform, and centralize external application data, streamlining refresh processes and improving reporting efficiency.
Technologies: BI Reporting, Microsoft Power BI, Microsoft Report Builder, SSRS Reports, Report Definition Language (RDL), DAX, Power Query, PostgreSQL, Transact-SQL (T-SQL), REST APIs, Performance Analysis, SQL Views, User Documentation, Monday.com, SQL, Data Analytics, Reporting, Key Performance Indicators (KPIs), Business, Trend Analysis, RESTFul APIs, Dashboard Design
Senior BI Developer
2022 - 2024
Canada Life
- Designed and developed enterprise Power BI dashboards and semantic models supporting insurance operations and claims analytics, enabling business teams to monitor KPIs and operational performance.
- Built and maintained complex paginated (RDL) reports for operational and regulatory reporting across health insurance operations.
- Performed data extraction, transformation, and validation from large-scale data platforms, including Azure Databricks, SQL Server, and PostgreSQL, ensuring data accuracy and consistency for enterprise reporting.
- Integrated large-scale datasets from Azure Databricks, SQL Server, and SharePoint into centralized Power BI semantic models supporting enterprise reporting.
- Improved report performance by optimizing DAX measures, dataset modeling, and SQL queries for large insurance datasets.
- Developed Power Automate flows and Power Apps to enable interactive write-back and automated workflows.
- Supported CI/CD deployment pipelines, implemented RLS, and collaborated with business stakeholders to deliver self-service analytics promoting a single version of truth.
- Participated in Agile sprints to manage BI deliverables, promote reusable assets, and enhance collaboration across data teams.
Technologies: BI Reporting, SSRS Reports, DAX, Power Query, Tableau, SQL, Azure SQL, Azure Databricks, Microsoft Power Automate, Microsoft Power Apps, SQL Server Integration Services (SSIS), Microsoft Power BI, Microsoft Report Builder, Data Analytics, Reporting, Key Performance Indicators (KPIs), Business, Trend Analysis, Dashboard Design
BI Developer
2021 - 2022
Android Industries
- Gathered report requirements and determined the best solution to provide the results in either SQL Server Reporting Services (SSRS) or Power BI.
- Created effective Power BI visualizations and dashboards as per the requirements.
- Performed Power BI Desktop data modeling, which cleans, transforms, and mashes data from multiple sources. Developed calculated columns and measures using DAX in Power BI.
- Designed and developed ETL packages to import and export data from Microsoft Excel, SQL Server 2012, and flat files.
- Wrote complex SQL queries, stored procedures, triggers, views, cursors, and user-defined functions to implement the business logic.
- Built pipelines in Azure Functions utilizing linked services, datasets, and pipelines to extract, transform, and load data from various sources like Azure SQL, Blob storage, and Azure SQL Data Warehouse.
- Reduced the number of rows for joins using temp tables to aggregate data from various sources for different reports.
Technologies: SQL Server 2012, SQL Server 2016, SQL Server Integration Services (SSIS), Microsoft Power BI, DAX, SQL Server Analysis Services (SSAS), Azure, Microsoft Power Automate, Microsoft Report Builder, SQL Server Management Studio (SSMS), Power BI Desktop, Azure Functions, Jira, Power BI Report Server, Power BI Mobile, Communication, Interpersonal Skills, BI Reporting, Business Requirements, Power Query, Data Visualization, Data Analysis, Data Modeling, Technical Documentation, Deployment, Power Query M, Microsoft PowerPoint, Microsoft Word, Data Science, Critical Thinking, Complex Problem Solving, MSBI, On-premises Data Gateway, ETL, Dashboards, Business Intelligence (BI), Data Analytics, Reporting, ETL Tools, Excel 365, Data Warehousing, Warehouses, Azure Data Factory (ADF), Data Reporting, Dashboard Development, SQL Server DBA, Data Engineering, Python, SQL, Tableau, Key Performance Indicators (KPIs), Business, Trend Analysis, Dashboard Design
BI Developer
2019 - 2021
Logan Consulting
- Designed and developed tabular model cubes and dimensions using SQL Server Analysis Services (SSAS) 2012.
- Engaged in identifying and creating data sources and data source views in SSAS. Created dimensions and cubes and deployed them onto the server so managers could analyze the ongoing production support for the application as required.
- Delivered interactive reports customized for the business using Power BI Desktop.
- Developed transformations and loaded data from multiple sources into the Power BI dashboard. Wrote DAX queries and manipulated the multidimensional data in tabular model cubes.
- Built SQL Server Integration Services (SSIS) packages to import and export data from various sources using SQL Server Data Tools.
- Created database objects like tables, users, roles, stored procedures, and triggers.
- Tuned up and changed some of the existing SSRS reports as requested by the user.
Technologies: Microsoft Power BI, SQL Server Analysis Services (SSAS), DAX, SQL Server 2012, Microsoft Excel, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT), Power BI Desktop, SQL Server Integration Services (SSIS), Jira, Power BI Report Server, Communication, Interpersonal Skills, BI Reporting, Business Requirements, Power Query, Data Visualization, Data Analysis, Data Modeling, Technical Documentation, Deployment, Power Query M, Microsoft Word, Data Science, Critical Thinking, Complex Problem Solving, MSBI, ODBC, On-premises Data Gateway, Database Analytics, Data Migration, Dashboards, Business Intelligence (BI), Data Analytics, Reporting, PL/SQL, PostgreSQL, Excel 365, Data Warehousing, Warehouses, Data Reporting, Dashboard Development, SQL Server DBA, SQL, Key Performance Indicators (KPIs), Business, Trend Analysis, Dashboard Design
BI Developer
2018 - 2019
Moneris Solutions
- Engaged in planning, defining, and designing the database using erwin for business requirements and provided documentation.
- Designed SSIS packages to transfer data from various sources such as text, XML, Excel, and flat files to SQL Server 2012.
- Involved in building and maintaining SSIS packages to import and export data from various data sources in BIDS format based on the design data models.
- Wrote T-SQL queries and stored procedures and used them to build SSIS packages, SSRS reports, and Tableau visualizations.
- Tracked the execution time of T-SQL statements using SQL Server Profiler templates.
- Developed user interface reports using Tableau sheet objects, including list box, input box, buttons, text input, slider, bookmarks, and charts such as pivot or straight tables, pie, bar, and line.
- Created and scheduled tasks for data reloading and distribution in Tableau.
- Optimized all indexes, SQL queries, and stored procedures to improve software quality.
- Built traces using SQL Server Profiler to find and modify long-running queries as a part of performance tuning operations.
Technologies: Microsoft Power BI, Tableau, SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), SQL Server 2012, SQL Server Profiler, Power BI Report Server, MySQL, Communication, Interpersonal Skills, BI Reporting, Business Requirements, Power Query, Data Visualization, Data Analysis, Data Modeling, Technical Documentation, Deployment, Power Query M, Microsoft PowerPoint, Microsoft Word, Data Science, Critical Thinking, Complex Problem Solving, MSBI, OLAP, OLTP, Database Analytics, Data Migration, Dashboards, Business Intelligence (BI), Data Analytics, Reporting, PL/SQL, PostgreSQL, Data Warehousing, Warehouses, Dashboard Development, SQL, Key Performance Indicators (KPIs), Business, Trend Analysis, Dashboard Design
SQL BI Developer
2017 - 2018
Spretnost Services Pvt
- Involved in technical discussions and decisions for business requirements. Collaborated with business analysts and client and development teams.
- Migrated the reporting environment from Excel and SSRS to Power BI.
- Created clustered gateways for the Power BI environment for different connection modes.
- Contributed to database design and data modeling processes.
- Analyzed the data: quality, validating, and mapping to migrate data to the SQL Server database.
- Designed SQL Server database and tables with schemas, constraints, and views.
- Extracted data from Db2, VSAM, SQL Server: 2014, 2012, and 2008 R2, and CSV, Excel, and text files from client servers.
- Ensured constraints and wrote triggers or linked server scripts to apply the business rules. Handled performance tuning, backups, and user database restorations.
- Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers, and user-defined functions.
- Deployed reports and performed UAT in a multi-user environment. Created report server config files and ensured report security with keys.
Technologies: SQL Server 2008 R2, SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Power BI, Crystal Reports, Microsoft Visio, MySQL, SQL Server 2014, Salesforce, Communication, Interpersonal Skills, BI Reporting, Business Requirements, Data Visualization, Technical Documentation, Microsoft PowerPoint, Microsoft Word, Critical Thinking, Complex Problem Solving, MSBI, C++, Database Analytics, Data Analytics, Reporting, PL/SQL, PostgreSQL, Data Warehousing, Warehouses, Data Reporting, Dashboard Development, SQL Server DBA, SQL, Power Query, Business
Experience
Program Management and Governance
End-to-end reports and dashboards on resource management for the business, including reports with insights for leaders at different levels while maintaining confidentiality by making them accessible to specific audiences or applying row-level security.
These reports played a vital role in understanding the expenses vs. actual budget for various projects at different levels. It also helped the team leaders manage roles and responsibilities accordingly. There were discrepancies in the hours reported by the resources, causing inaccurate numbers in budget and expense. These were also handled through an autogenerated report with missing hours, emailed weekly to their team leaders.
These reports played a vital role in understanding the expenses vs. actual budget for various projects at different levels. It also helped the team leaders manage roles and responsibilities accordingly. There were discrepancies in the hours reported by the resources, causing inaccurate numbers in budget and expense. These were also handled through an autogenerated report with missing hours, emailed weekly to their team leaders.
Process Management
Power BI reports and dashboards for a manufacturing assembly plant. The reports provided insights on the takt time for each assembly module, resources being used, and the cost. This provided an excellent tool for the process engineering team to look at the data the way they would like and plan or work on the next steps accordingly.
Electronic Enrollment Project
This project included end-to-end reports and dashboards for different clients of a large healthcare insurance company, reducing the reporting time by at least 40%. I created various reports in this project, such as standard Power BI reports and dashboards, paginated reports, and reports to generate fixed-width files, letters, and ID cards. A lot of work that was being done manually by TAs got automated. My work also included deployment, implementing RLS, and auto-generating reports using Power Automate.
Skills
Libraries/APIs
ODBC, REST APIs
Tools
Microsoft Power BI, Microsoft Excel, Microsoft Report Builder, SQL Server Profiler, Power BI Desktop, Power BI Mobile, Power Query, Microsoft Word, Microsoft PowerPoint, Jira, Visual Studio 2013, Visual Studio 2010, Visual Studio 2008, On-premises Data Gateway, Tableau, Crystal Reports, Microsoft Visio, Microsoft Access, Power BI Report Server, Microsoft Power Apps
Languages
SQL, Transact-SQL (T-SQL), Power Query M, C++, Python
Paradigms
Business Intelligence (BI), OLAP, ETL, Report Definition Language (RDL)
Storage
SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, PostgreSQL, SQL Server DBA, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), PL/SQL, MySQL, OLTP, SQL Server Data Tools (SSDT), Azure SQL, SQL Views
Platforms
SharePoint, Salesforce, Azure, Microsoft Power Automate, Azure Functions
Other
DAX, MSBI, Data Visualization, Data Modeling, Technical Documentation, Interpersonal Skills, Communication, Data Science, BI Reporting, Business Requirements, Deployment, Dashboards, Data Analytics, Reporting, Data Reporting, Dashboard Development, Key Performance Indicators (KPIs), Business, Trend Analysis, Dashboard Design, Data Analysis, Database Analytics, Complex Problem Solving, Critical Thinking, Data Migration, ETL Tools, Excel 365, Data Warehousing, Warehouses, Data Engineering, Monday.com, RESTFul APIs, Azure Databricks, Azure Data Factory (ADF), SSRS Reports, Performance Analysis, User Documentation
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring