Muhib Ullah Khan

This data analytics project reports on the performance of a famous car manufacturing brand and how it is competing with other brands in different European countries. In this project, I implemented the data ingestion process from landing to a raw zone, the raw zone to ODS, and finally from ODS to the data warehouse. I used Snowflake as the target data warehouse, DBT to write transformation scripts, and Azure services such as ADLS, Spark, or Databricks to implement data ingestion and data lake storage.

This real-time monitoring app refreshes every minute to visually represent the current status of machines working in a factory. I oversaw ingesting real-time data from IoT devices using Azure Event Hub, Spark, or Databricks, loading the data in a SQL database, and performing further transformations and aggregations to prepare the data for visual representation on the dashboard.

As a data conversion specialist, I worked on this SQL-based project. I communicated with business analysts to understand business requirements and then map source data to appropriate fields in the target database. Also, I documented data mappings and transformations required for conversion and wrote conversion scripts to extract, transform, and load data into the target database.

This machine-to-machine (M2M) service for eSIM users, usually companies, monitors and controls their devices connected to a telecommunication network. In this project, I oversaw automating the billing process so that when the real-time usage data would come in from all the connected devices, it could be processed through a series of scheduled SQL jobs and summarized in the form of an invoice. While working on this project, I was also able to identify and fix a bug in the code that was causing the company to lose hundreds of dollars per invoice for large customers.

This data analytics project for a restaurant visualizes the performance of its food delivery partners and analyzes factors affecting delivery on time. In this project, I oversaw designing a data mart and then loading the restaurant's data in it. I also created a Power BI dashboard for the client to quickly visualize how well the deliveries are going.