Mohammed Nabeel Email & Phone Number

Led and delegated tasks to offshore consultants after gathering requirements from cross-functional teams.Developed executive dashboards in Power BI Desktop using table, matrix, bar, card, gauge, and slicer visualizations.Formulated complex SQL queries to fetch data from various tables in remote databases using joins and database links, and formatted results into comprehensive reports while maintaining logs.Created stored procedures for data transformation and worked extensively with Azure Synapse for various transformation needs during data loading processes.Utilized advanced DAX measures to create reports and dashboards in Power BI.Leveraged Azure DevOps to track team progress and manage tasks.Incorporated Power Apps visuals into Power BI Desktop for enhanced interactivity.Implemented various data transformations available in Power BI Query Editor.Modified existing data marts by adding fields from Dynamics 365 to Azure Synapse using complex SQL queries.Maintained and updated existing published Power BI content to reflect changing business needs.Designed and developed paginated reports with complex layouts, sub-reports, and drill-through actions for detailed data insights.Conducted data analysis and modeling to ensure accurate and reliable data sources for published Power BI reports.Customized paginated reports with headers, footers, and page numbers for professional presentation and easy navigation.Used DAX Studio to optimize DAX performance.Configured permissions for workspaces and apps to ensure data integrity.Trained end-users on how to use complex reports and pin visuals to create self-service and informative dashboards in Power BI Service.Implemented drill-down, drill-through, bookmarking, and hyperlink features in Power BI reports.Created automated Excel reports connected to the data warehouse using macros and VBA.Ensured data accuracy by performing rigorous data validation checks from both data marts and Dynamics 365 data.

New York, United States

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment.Used Power Apps visuals in Power BI desktop.Created various dashboards in the Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.Developed SQL Queries to fetch complex data from different tables in remote databases using joins, and database links and formatted the results into reports, and kept logs.Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

New Jersey, United States

Gathering requirements from stakeholders and creating complex SQL queries on Impala as per business needs and developing L3 tables.Performed all sorts of ETL and metrics aggregations at the report level in Power BI using power query and M-code.Built the relationship between various data sources in Power BI and transformed the data based on requirements.Created new columns and DAX measures and applied business rules to color code the metrics.Developed rich visualizations like donut charts, pie-chart, bar graphs, staked area charts, etc.Written several DAX queries using inbuilt functions in Power BI like dynamic calendar and customized it.

St Paul, Minnesota, United States

Created SSIS process design architecting the flow of data from various sources to target.Use DDL and DML for writing triggers, stored procedures, and data manipulation.Developed Power App form and Automated Hazardous waste Pickup system using Microsoft Flow.Create different SSRS Reports based on the user’s requirements. All kinds like ad-hoc reports, Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Gridsusing SQL Server Reporting Services (SSRS).Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.Troubleshoot any kind of data issues or validation issues.Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.Design the ETL framework for the data load into FRY Tables.

Texas, United States

Strong experience in writing stored procedures, functions, and triggers in MS T-SQL building the packages, Testing, and implementing in the production server.Redesigned and tuned stored procedures, triggers, UDF, views, and indexes, and was successfully able to increase the performance of the slow-running queries. Experience in Developing and Publishing Reports in SQL Server 2013 using SSRS (SQL Server Reporting Services).Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients.Experience in creating advanced chart types, visualizations, and complex calculations to manipulate the data as per business needs through Power BI.Experience in publishing Power BI reports of dashboards in the Power BI server and scheduling the dataset to refresh for upcoming data in the power BI server.

India

Implemented Complex business logic with User-Defined-Functions, Index Views and also created User-defined Data types, Clustered & amp; Non-clustered Indexes.Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases.Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views, and other T-SQL code and SQL joins for applications following SQL code standards.Developed and maintained multiple Power BI dashboards/reports and content packs.Involved and worked in designing and developing the ETL flow that will update the data structure related to Target Oracle tables using SQL Server Integration Services (SSIS).