Shakeeb Shaik, Developer in Toronto, ON, Canada
Shakeeb is available for hire
Hire Shakeeb

Shakeeb Shaik

Verified Expert  in Engineering

Bio

Shakeeb, a certified Microsoft Power BI data analyst, is a performance-driven professional with five years of experience in Microsoft Business Intelligence (MSBI), Power BI, and Oracle SQL. With a robust technical background, he has demonstrated proficiency in analyzing complex processes and devising innovative solutions within dynamic cross-functional environments, including those at Broadridge Financial Solutions and TD Bank Group.

Portfolio

Owens Corning - Customer Center of Excellence
Microsoft Power BI, Data Analysis, Dashboard Development, Reporting...
Broadridge Financial Solutions
Power Pivot, Power Query M, ETL Tools, Microsoft Power BI, Excel VBA, SQL...
Canadian Tire Corporation
Business Intelligence (BI), Microsoft Power BI, SQL, T-SQL (Transact-SQL)...

Experience

  • Microsoft Power BI - 6 years
  • BI Reporting - 5 years
  • Data Visualization - 5 years
  • Data Analysis - 5 years
  • SQL - 5 years
  • T-SQL (Transact-SQL) - 5 years
  • Dashboards - 5 years
  • SQL Server Integration Services (SSIS) - 3 years

Availability

Full-time

Preferred Environment

Jira, Visual Studio Code (VS Code), Git, Business Intelligence (BI), BI Reporting, Dashboards, Microsoft Power BI, SQL, SQL Server Integration Services (SSIS), Excel 2016

The most amazing...

...work I've done was developing a Power BI model for financial reporting of P&L and headcount.

Work Experience

Power BI Expert | Data Analyst

2024 - 2024
Owens Corning - Customer Center of Excellence
  • Developed a dashboard by building complex data modeling as there are multiple data sources.
  • Completed the project within the given deadline without any supervision.
  • Provided recommendations, which played a key role in developing the reports.
Technologies: Microsoft Power BI, Data Analysis, Dashboard Development, Reporting, Data Visualization, Dashboards, Communication, Complex Data Analysis, Key Performance Indicators (KPIs), Complex Models, Business Analysis

BI Developer

2022 - 2024
Broadridge Financial Solutions
  • Defined project scope, gathered business requirements, conducted analysis, and documented findings.
  • Developed a Power BI model used for financial reporting of P&L and headcount. Created Power BI visualization of dashboards and scorecards (KPI) for the finance department.
  • Implemented DAX time-intelligence functions "same period last year," "previous year," and "previous quarter" to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
  • Used Power Query/Query Editor for data transformation per the reporting needs. Created a data model in Power Pivot by establishing the relationship between the tables.
  • Developed complex programs in PL/SQL, writing stored procedures, indexes, and views. Created a Power BI drill-down and drill-through charts with KPIs and reports showing Top N metrics.
  • Integrated custom visuals based on business requirements using Power BI desktop and implemented dynamic row-level security (RLS) on the Power BI service cloud.
  • Conducted performance tuning and optimization of SQL queries to improve query performance and reduce runtime. Extensively worked on enhancements and performance issues of the existing data import processes.
  • Designed, developed, and tested an ETL strategy to populate data from multiple source systems using SSIS. This included creating SSAS tabular mode cubes to support analytical processing and improve reporting efficiency.
  • Imported data into Power BI using various ETL methods, including SQL Azure, Direct Query, RESTful API generators, and Azure Databricks.
  • Applied Power BI skills to seamlessly connect and analyze data from SharePoint, enhancing data-driven insights. Facilitated dynamic reporting, contributing to informed decision-making processes.
Technologies: Power Pivot, Power Query M, ETL Tools, Microsoft Power BI, Excel VBA, SQL, Microsoft Office, QlikView, Data Modeling, Data Analysis, DAX, Microsoft Excel, SharePoint, BI Reporting, Data Analytics, Reporting, Business Intelligence (BI), Dashboards, Data Warehousing, Data Engineering, Data Visualization, ETL, Excel 365, T-SQL (Transact-SQL), Jira, Azure Data Factory, Microsoft SQL Server, Data Reporting, Data Science, Dashboard Development, Dashboard Design, Power BI Desktop, Analytics, Excel Expert, Microsoft Report Builder, BI Reports, Databases, Sales Reports, CSV, APIs, Azure, Azure Databricks, Communication, Complex Data Analysis, SSAS Tabular, Visual Basic, Key Performance Indicators (KPIs), Snowflake, Complex Models, Business Analysis

Power BI Developer

2021 - 2022
Canadian Tire Corporation
  • Started this project from scratch to understand dashboard requirements, gather info, create a TDD based on FDD, and study existing databases to ensure all required data is available to create a data model within Power BI.
  • Created Golden Datasets on Power BI Service to avoid "Data Set Silos" and created different environments for Dev QA/prod environments with the help of Workspace.
  • Implemented DAX time-intelligence functions in the same period last year, previous year, and previous quarter to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
  • Used and created various visualizations in reports like scatter plots, box plots, Sankey charts, bar graphs, Gantt charts, trend lines, and waterfall charts, allowing end users to utilize the full functionality of the dashboard.
  • Managed access to reports, dashboards, and data for individuals using user roles. Published reports to Power BI service and provided access to the required users.
  • Involved in creating complex ad hoc reports, sub-reports, linked reports, drill-through report models, and drill-down reports. Performed transformations like pivoting, unpivoting, and splitting of the columns using Power Query.
  • Performed query folding using Power Query to filter data from the data source server and worked with different ERPs like Microsoft Dynamics and SAP SuccessFactors.
  • Managed a Power BI portal, including data refreshes, user management, and setting up a gateway data refresh. Published reports to Power BI service, provided access to the required users, and implemented row-level security.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), and temporary tables to support Power BI reports.
  • Wrote T-SQL procedures to generate DM scripts that modified database objects dynamically based on user inputs. Responsible for data analysis and loading data from the data feed into a data warehouse.
Technologies: Business Intelligence (BI), Microsoft Power BI, SQL, T-SQL (Transact-SQL), Microsoft Access, Power Pivot, Power Query M, Microsoft Excel, SQL Server Integration Services (SSIS), Data Modeling, Data Analysis, DAX, Data Reporting, Data Science, Dashboard Development, Dashboard Design, Power BI Desktop, Analytics, Excel Expert, Microsoft Report Builder, BI Reports, Databases, Sales Reports, CSV, Testing, Communication, Complex Data Analysis, Visual Basic, Key Performance Indicators (KPIs), Complex Models, Business Analysis

Power BI Developer

2018 - 2021
TD Bank Group
  • Created Power BI dashboards and reports for business users using DAX and visuals. Designed app workspaces in Power BI service for sharing and administering reports and dashboards.
  • Developed complex dashboards and reports using advanced Power BI features such as advanced DAX calculations, groups, variables, parameters, filters, and custom visualizations.
  • Wrote Transact-SQL (T-SQL ) scripts and procedures to generate data manipulation language (DML) scripts that modified database objects based on inputs.
  • Worked on custom visualizations like multi-slicker, hierarchy slicer, and DAX expressions, including filters, aggregates, and mathematical functions. Provided end-user support for Power BI reports.
  • Involved in designing, developing, and testing the ETL strategy to populate the data from various source systems like MySQL, Oracle, and flat file feeds using SSIS.
  • Created data visualizations using various visual objects such as line charts, bar charts, treemaps, single cards, KPIs, maps, pie charts, and custom visuals. Interacted extensively with business users to gather requirements and analyze user needs.
  • Prepared reports using MS Excel (VLOOKUP, HOOKUPS, PivotTable, macros, and data points) and created process flow charts, presentations, and defect management using Jira, Visio, PowerPoint, and MS Excel.
  • Designed and developed data warehouse and business intelligence tools using a multi-dimensional model–star schema. Used different control flow tasks and data flow tasks to create SSIS packages.
  • Designed, developed, and tested various Power BI for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
  • Utilized C# scripting in collaboration with SQL development to optimize database queries, enhancing data retrieval efficiency and contributing to streamlined workflow as an SQL developer.
Technologies: Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Excel VBA, SQL, Power Pivot, Power Query M, ETL Tools, Microsoft Office, Data Modeling, Data Analysis, Data Manipulation Language (DML), T-SQL (Transact-SQL), Microsoft Excel, BI Reporting, Data Analytics, Reporting, Business Intelligence (BI), Dashboards, Data Engineering, Data Visualization, ETL, Excel 365, DAX, Jira, Microsoft SQL Server, Data Reporting, Dashboard Development, Dashboard Design, Power BI Desktop, Analytics, Excel Expert, Microsoft Report Builder, BI Reports, Databases, Sales Reports, CSV, Communication, Complex Data Analysis, Key Performance Indicators (KPIs), Complex Models, Business Analysis

SQL Developer

2015 - 2017
Sands Instrument
  • Created, maintained, and analyzed a wide variety of reports/Excel spreadsheets for senior management. Oversaw departmental software drive/files.
  • Extracted data from heterogeneous systems like Oracle, SQL Server, Excel, and CSV files for performing business operations and applying rules.
  • Exported and imported data from a flat file, CSV file, and Excel to and from an SQL Server database using SQL Server Integration Services (SSIS).
  • Developed ETL processes from various heterogeneous data sources like Access, Excel, and CSV, as well as flat files using connectors, tasks, and transformations provided by SSIS.
  • Demonstrated excellent skills in developing SSRS reports with functionality such as drill down, drill through, and parameters. Involved in automating SSIS packages using SQL Server Agent Jobs.
  • Exported and imported data from flat file, CSV file, and Excel to/from SQL Server database using SSIS. Created tabular, list, and matrix reports and wrote queries to perform drill-down operations in SSRS.
  • Used various report items like tables, sub-reports, and charts to develop the reports in SSRS and upload them into Report Manager.
  • Utilized C# scripting in collaboration with SQL development to optimize database queries, enhancing data retrieval efficiency and contributing to streamlined workflow as an SQL developer.
  • Showed working experience in BI solutions (ETL and reporting) using SIS and T-SQL programming using DDL, DML, and DCL commands for various business applications.
Technologies: Data Analysis, SQL, SQL Server Integration Services (SSIS), BI Reporting, Data Analytics, Reporting, Business Intelligence (BI), Dashboards, Data Warehousing, Data Engineering, Data Visualization, ETL, Excel 365, DAX, T-SQL (Transact-SQL), Microsoft SQL Server, Data Reporting, Dashboard Design, Power BI Desktop, Analytics, Excel Expert, BI Reports, Databases, CSV, Communication, Complex Data Analysis, SQL Server Reporting Services (SSRS), Business Analysis

Data Migration Project

Reports and dashboards were migrated from QlikView to Power BI. As a Power BI developer, I redesigned, built, and created reports from scratch while migrating from the QlikView reporting tool to Power BI.

QHSE Project

Quality Health and Safety Environment is a monitoring dashboard for the health hazard activities and training certifications of the organization's employees. I built the dashboard, which helps management identify the key factors affecting the safety of personnel in the field.

Redesigning and Rebuilding a Data Warehouse

The data warehouse that was in use was not functioning properly, with too much run time for data warehouse nightly jobs and slower performance of the queries. A new data warehouse was redesigned and rebuilt from scratch by using star schema data modeling and incremental loading ETL strategy.

I played an important role in the project with proper planning, designing, and testing of the project.

Dashboard Creation

As a Power BI developer, I worked on creating a unifying dashboard for different metrics for Owens Corning's data analytics team. This dashboard pulls data from different resources like Sales CRM, SAP, and the Power BI semantic model. It is specifically designed for the senior managers of the team.
2017 - 2018

Master's Degree in Computer Science

Lambton College - Ontario, Canada

2011 - 2015

Bachelor's Degree in Computer Science

KL University - Andhra Pradesh, India

MAY 2024 - PRESENT

Power BI Data Analyst Associate

Microsoft

Tools

Microsoft Power BI, Power Pivot, Microsoft Excel, Microsoft Report Builder, Power BI Report Server, Jira, Git, Excel 2016, Microsoft Access, Figma, Power BI Desktop

Languages

SQL, Power Query M, T-SQL (Transact-SQL), Excel VBA, Visual Basic, Visual Basic for Applications (VBA), Data Manipulation Language (DML), Snowflake

Paradigms

Business Intelligence (BI), ETL, Testing

Storage

Databases, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft SQL Server, SSAS Tabular

Platforms

QlikView, SharePoint, Visual Studio Code (VS Code), Azure, Amazon Web Services (AWS)

Other

Data Modeling, Data Analysis, DAX, BI Reporting, Data Analytics, Reporting, Dashboards, Data Visualization, Excel 365, Data Reporting, Dashboard Development, BI Reports, Sales Reports, CSV, Communication, ETL Tools, Microsoft Office, Data Warehousing, Data Science, Complex Data Analysis, Azure Analysis Services, Data Engineering, Azure Data Factory, Dashboard Design, Analytics, Excel Expert, APIs, Azure Databricks, Key Performance Indicators (KPIs), Complex Models, Business Analysis

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