Mohammed is available for hire
Hire MohammedMohammed Adil Mohiuddin
Verified Expert in Engineering
BI Developer
Brampton, ON, Canada
Toptal member since February 7, 2024
Bio
Mohammed is a senior BI developer with 6+ years of IT experience. He analyzes, designs, develops, tests, and implements ETL and BI solutions using data warehouse or data mart design, SQL Server, MSBI, and Power BI. He has worked independently and as a proactive team member on BI projects for manufacturing, software, finance, and business services. Notably, Mohammed has delivered end-to-end reports and dashboards that provided insights and improved processes for a large manufacturing facility.
Portfolio
Android Industries
SQL Server 2016, SQL Server 2012, SQL Server Integration Services (SSIS)...
Logan Consulting
Microsoft Power BI, SQL Server Analysis Services (SSAS), DAX, SQL Server 2012...
Moneris Solutions
Microsoft Power BI, Tableau, SQL Server Reporting Services (SSRS)...
Experience
- Microsoft Power BI - 6 years
- SQL - 6 years
- SQL Server Management Studio (SSMS) - 6 years
- SQL Server Reporting Services (SSRS) - 6 years
- DAX - 5 years
- SQL Server Analysis Services (SSAS) - 4 years
- SQL Server Integration Services (SSIS) - 4 years
- Microsoft Report Builder - 3 years
Availability
Part-time
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
BI Developer
2021 - 2024
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 2016, SQL Server 2012, 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, Data Reporting, Dashboard Development, SQL Server DBA
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
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), T-SQL (Transact-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 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
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
Tools
Microsoft Power BI, Microsoft Excel, Microsoft Report Builder, Power Query, Microsoft Word, Microsoft PowerPoint, Power BI Mobile, Jira, Visual Studio 2013, Visual Studio 2010, Visual Studio 2008, On-premises Data Gateway, Tableau, Crystal Reports, Microsoft Visio, Microsoft Access, SQL Server Profiler, Power BI Desktop, Power BI Report Server
Languages
SQL, T-SQL (Transact-SQL), Power Query M, C++
Paradigms
Business Intelligence (BI), OLAP, ETL
Storage
SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server 2017, SQL Server 2016, SQL Server 2014, PostgreSQL, SQL Server DBA, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), PL/SQL, MySQL, OLTP, SQL Server 2012, SQL Server 2008 R2, SQL Server Data Tools (SSDT)
Platforms
SharePoint, Salesforce, Azure, Microsoft Power Automate, Azure Functions
Other
DAX, MSBI, Data Visualization, Data Modeling, Interpersonal Skills, Communication, Data Science, BI Reporting, Business Requirements, Deployment, Dashboards, Data Analytics, Reporting, Data Reporting, Dashboard Development, Data Analysis, Database Analytics, Complex Problem Solving, Technical Documentation, Critical Thinking, Data Migration, ETL Tools, Excel 365, Data Warehousing, Warehouses, Azure Databricks, Azure Data Factory
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