beBee background
Professionals
>
Skokie
Muhammad Usman

Muhammad Usman

Report Developer Analyst

Utilities / Energy

Skokie, Township of Niles, Cook

Social

About Muhammad Usman:

  • 8+ years of experience as a BI analyst/ Developer with extensive experience in data warehousing, and BI technologies with expertise in Azure, Power BI and Tableau for building, deploying, and managing applications and services through MS Data centers in Agile and Waterfall projects. 
  • Practical understanding of Data Modeling (Dimensional & Relational) concepts like star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Experience in Creating different visualization using standard charts (Stacked bar, waterfall chart, clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line and Clustered Column Chart, Map, Slicer, gauge chart) and Custom charts (scroller, tornado, sunky, word cloud visual and radar) in Power BI and Tableau according to the requirements.
  • Expert in MS Power BI and Tableau - Data design, data cleansing, scheduling the reports to users, managing data gateways, management using DAX language, Role level security access, granting permissions.
  • Expert at using Power BI tenants to control the PBI API’s extraction from the capacities. 
  • Proficient in data analysis and manipulation using SQL, Python, and R to extract, clean, and transform complex datasets for actionable insights.
  • Expert in creating interactive reports/ dashboards using Power BI, Tableau, and SSRS.
  • Expert in end-to-end implementation by using Azure Cloud from Data Lake to Synapse DB through Data Factory, Azure Analysis to do data modeling, and then using the cube in Power BI to improve performance. 
  • Experience in of Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements
  • Extensive database programming experience in writing POWER BI, User Defined Functions, Triggers, Views, Temporary Tables, and Indexes using various DDL and DML commands.
  • Developed customized Stored Procedures and Queries for data extraction, reports, and other client interfaces.
  • Implemented Power BI gateway different source to match analysis criteria and further modeling for Power Pivot and owner view.

Experience

  • 8+ years of experience as a BI analyst/ Developer with extensive experience in data warehousing, and BI technologies with expertise in Azure, Power BI and Tableau for building, deploying, and managing applications and services through MS Data centers in Agile and Waterfall projects. 
  • Practical understanding of Data Modeling (Dimensional & Relational) concepts like star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Experience in Creating different visualization using standard charts (Stacked bar, waterfall chart, clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line and Clustered Column Chart, Map, Slicer, gauge chart) and Custom charts (scroller, tornado, sunky, word cloud visual and radar) in Power BI and Tableau according to the requirements.
  • Expert in MS Power BI and Tableau - Data design, data cleansing, scheduling the reports to users, managing data gateways, management using DAX language, Role level security access, granting permissions.
  • Expert at using Power BI tenants to control the PBI API’s extraction from the capacities. 
  • Proficient in data analysis and manipulation using SQL, Python, and R to extract, clean, and transform complex datasets for actionable insights.
  • Expert in creating interactive reports/ dashboards using Power BI, Tableau, and SSRS.
  • Expert in end-to-end implementation by using Azure Cloud from Data Lake to Synapse DB through Data Factory, Azure Analysis to do data modeling, and then using the cube in Power BI to improve performance. 
  • Experience in of Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements
  • Extensive database programming experience in writing POWER BI, User Defined Functions, Triggers, Views, Temporary Tables, and Indexes using various DDL and DML commands.
  • Developed customized Stored Procedures and Queries for data extraction, reports, and other client interfaces.
  • Implemented Power BI gateway different source to match analysis criteria and further modeling for Power Pivot and owner view.

Education

  • Design, develop, and maintain dynamic reports and dashboards using Power BI, SSRS, and Tableau.
  • Create visually appealing and interactive dashboards and reports using Power BI and Tableau. This involves using DAX expressions, custom visuals, Tableau Calculated Fields, and the Power Query editor to transform and model data effectively.
  • Connect to SQL, Oracle, SharePoint, and cloud data sources, using Tableau Prep for data cleansing, transformation, and blending.
  • Designed and implemented Fabric Data Factory pipelines to extract, transform, and load (ETL) data from multiple sources (SQL, Azure Blob Storage, APIs) into Power BI for real-time analytics and reporting.
  • In SSRS (POWER BI Server Reporting Services), design paginated reports that cater to specific business needs, including parameterized, drill-through, and subscription-based reports. Manage report deployment and ensure they meet performance and usability standards.
  • Use POWER BI Server Management Studio (SSMS) to write and maintain efficient SQL queries that retrieve, manipulate, and aggregate data from relational databases. 
  • Developed performance metrics and reporting tools to track key performance indicators (KPIs) and monitor operational effectiveness.
  • Collaborated with cross-functional teams to translate business requirements into actionable data-driven insights and visualizations.
  • Optimize dashboard performance by extracting data, reducing query load, and implementing indexing while publishing reports on Tableau Server/Online for real-time collaboration.
  • Utilized Dataflows and Power Query within Fabric Data Factory to clean, aggregate, and optimize data before integrating it into Power BI dashboards for better performance and efficiency.
  • Querying and Optimizing data in Oracle Databases for enhanced performance.
  • Developed interactive Power BI dashboards by integrating data from SAP HANA, AWS Data Lake, and Oracle Workbench, enabling real-time decision-making.

Professionals in the same Utilities / Energy sector as Muhammad Usman

Professionals from different sectors near Skokie, Township of Niles, Cook

Other users who are called Muhammad

Jobs near Skokie, Township of Niles, Cook

  • Data & Reporting Analyst

    2 weeks ago

    First Chicago Insurance Company Chicago

    We are seeking the ideal candidate for our Data and Reporting Analyst opening.The Data and Reporting Analyst will work independently within the Product & Actuarial Department while collaborating with various other business departments to create multi-line front-end data reports a ...

  • Financial Reporting Analyst

    1 month ago

    Hogsalt Chicago

    Hogsalt is looking for a detail-oriented Financial Reporting Analyst to prepare financial statements, · support audits, and develop financial models that drive decision-making.We're an organization that makes people - our guests and ourselves - happy. · ...

  • Power BI Report Developer/SAP

    3 weeks ago

    ZonForce Technology Lisle

    The resource will provide technical reporting analyst services under the direction of International Financial with responsibilities including ERP Application Expertise Business Analysis Leadership Requirements Management Process Improvement Reporting Development Testing Leadershi ...

See jobs in Skokie, Township of Niles, Cook