Muhammad Hassan

Industry: Insurance

Tools & Technologies: Power BI, Azure SQL, Azure Data Lake, Azure Data Factory

Responsibilities:

• Build and designed data warehouse from ground up.
• Developed Azure Data Factory pipelines to integrate data from different sources such as Azure Storage and Azure SQL into Cloud DWH.
• Used Mapping Data Flows in Azure Data Factory for data transformation.
• Parameterize Azure Data Factory linked services and datasets for dynamism.
• Configured schedule trigger for ADF pipeline execution
• Created interactive reports and dashboards in Power BI and used visualizations like matrix, pie, bar, tiles, gauge, donut chart, Filters, Parameters and publish on Power BI Service.
• Used row level security & workspace level security in Power BI to manage security and access rights.

Industry: Energy

Tools & Technologies: Azure Data Bricks, Azure Data Lake

Responsibilities:

• Developed and maintained data processing pipelines using Databricks' Apache Spark clusters for smooth and efficiently handling of large-scale data sets.
• Ingested Json/CSV/Parquet large datasets from Azure Data Lake Storage and analyze and process data as per user requirements
• Gather requirements from business users and translate them into scalable Databricks workflows.

Industry: Retail

Tools & Technologies: Azure SQL, Azure Data Factory, Azure Data Lake, Power BI, Azure Key Vault

Responsibilities:

• Worked through with the management to develop the ingestion and visualization processes for customers by implementing the best practices for security, monitoring, scalability
• Designed data ingestion and Transformation processes using Azure Data Factory to load data from different data sources.
• Parameterize ADF linked services and datasets for reusability
• Integrated Azure Key Vault for security management

Industry: Retail

Tools & Technologies: SQL Server, SSIS, Power BI

Responsibilities:

• Implemented star schema in Data warehouse to enhance performance and designed dimension and facts.
• Data Extraction from various data sources.
• Developed dashboards in Power BI Desktop and published on Power BI Server.
• Development of reporting objects like bar chart, line chart, gauge, key performance indicator, hierarchies, filters in accordance with requirements.
• Development of Measures and Calculated Columns in Power BI Desktop.

Industry: Manufacturing

Tools & Technologies: Power BI, SQL Server, SSIS, SSRS, Power Automate, OBIEE 12c, Oracle Database 10g

Responsibilities:

• Developed intelligence sharing reports/dashboards and providing company wide access to relevant data
• Developed SSIS packages to Extract, Transform Load (ETL) from staging layer to data warehouse on daily/weekly basis based on requirements
• Developed SQL scripts for data analysis and transformation
• Created visualizations using Power BI, OBIEE 12c like pie, bar, clustered, tiles, gauge, donut chart, Filters, Hierarchies, Parameters and publish online.
• Development of Calculated Columns & Measures in Power BI
• Used row level security and workspace level security in Power BI to manage security and access rights.
• Converting existing reports from OBIEE 12c to Power BI
• Digitized company SOPs approval mechanism using Power Automate