Theme Colors

Pick a color

Usman Ghani Mughal

Data Enthusiast, Software Engineer
About me

Usman GhaniMughal

Data Enthusiast & Software Engineer

I'm an enthusiastic and diligent software technology professional. Having worked on a variety of projects around various domains equips me with the ability to adapt, enhance

and optimize towards quality solution delivery. I'm an equally exceptional performer under pressure with core focus at adhering timelines.

  • Name Usman Ghani Mughal
  • Birth October 27, 1996
  • City Islamabad
  • Email osmanghanimughal@gmail.com
  • Phone + 92 314 5270 917
  • Country Pakistan
Work Experience

Senior Data Engineer – Afiniti
Noc 2022 - Current

  • Creates Data Pipelines for prepareing US Demographics Data (Python | Airflow | Parallel Processing | REST API | MongoDB)
  • Build ETL and pipelines for US and Mexico PORT Data (Python | AirFlow | Multiprocess | SFTP | MongoDB

Big Data Engineer – The Entertainer
May 2022 - Nov 2022

  • Build ETL Pipelines using (Data Factory | Python | MySQL | Azure Synapse Analytics | Apache Spark)
  • Build Data Lake in AWS S3 and wrote ELT processes to integrate data from multiple sources. (Apache Nifi | Kafka | Hadoop | Hive )
  • Build Analytics Pipelines using PySpark.(AWS DataBricks | Spark | Amazon EMR | SalesForce)
  • Perform Data Modeling for DWH on Azure Synapse Analytics
  • Build scripts to automate the process of data quality checks.( Python)
  • Build AWS Lambda function which runs when another Data Bricks job pushed csv file into S3 bucket. (Python, AWS lambda)

Data Engineer – Afiniti
April 2021 - May 2022

  • Develop and Deploy Data Pipeline for multiple clients e.g. AT&T, T- Mobile, virgin media in US and UK. (AirFlow | MySQL | Mongo | AWS RedShift | Nifi)
  • ETL processes | Stored procedure | Feature engineering | Data Modeling.(MongoDB, MySQL | DWH | Nifi | Spark)
  • Build and optimize processes based on Multiprocess and Multithread in order to improve the efficiency of a process in controlled environment so we can manage QPS and use resources efficiently. (python | OS)
  • Data-Escrow Software : Programming model which assists with decreasing the expense and work on the effectiveness of a dataset in light of Cryptography, Encryption and Decryption utilizing SHA-256 in way that need to decrypt row by row utilizing individual decoding keys given by third party. (python)
  • Web Scraping Engines for acquiring publicly available data from multiple sources without getting blocked with acceptable QPS. (python)
  • Data Modeling and Data warehouse pipelines (MySQL | Redshift)

Full Stack Engineer – One Day Event
Feb 2021 - April 2021

onedayevent Wrote backend API using Node and Implement UI designs on React. Build payment system through electronic invoice, using stripe API. Reduced the page | data size and optimize the loading time. Fixed Bugs in the system.

Software Engineer & Data Analyst (Free Lance) - Fiverr
MAR 2019 - OCT 2020

  • Stock (Time Series) forecasting using deep learning (LSTM)
  • Heart Disease Classification using ML (Random Forest)
  • Retail Churn Prediction using ML (Random Forest)
  • Product Affinity Analysis using Apriori algorithm
  • Extract data from Pdf (retail invoices) using python
  • C++ program optimization based on memory management
  • assabuur.com Free Classified Adds Web App (PHP)

Professional skills

  • SPARK
    90%
  • KAFKA
    85%
  • HADOOP
    90%
  • HIVE | HUDI
    80%
  • AVRO | PARQUET
    80%
Big Data
  • Data Pipelines
    90%
  • Data Warehouses | Data lakes
    85%
  • (ETL | ELT) Processes
    92%
  • Data Modelling (Realational | NoSQL)
    83%
  • Data MANIPULATION (Numpy | Pandas | Matplotlib)
    92%
  • WEB SCRAPING
    95%
  • Machine Learning (Mlxtend | Scikit learn)
    75%
  • REST API
    95%
Data Engineering
  • AIRFLOW
    90%
  • AZURE DATAFACTORY
    85%
  • NIFI
    70%
  • BASH
    80%
ETL TOOLS

  • NODEJS
    90%
  • REACTJS
    85%
  • Angular
    70%
  • JQuery | Ajax
    85%
  • Design Patterns
    80%
Full Stack Development
  • Python
    90%
  • Javascript
    85%
  • PHP
    70%
  • Java
    80%
  • C++
    80%
Programming Languages
Education

BS Computer Science – COMSATS University Islamabad
Feh 2017 - Jan 2021

I took admission in CS with my own passion and through out the degree my focus was more towards the technical subjects for example PF, OOP, Data Structures, Data Bases, OS, CC etc. Selected Data Science as my majors in Which I have studied Data Analysis, Intro to Data Science, Data Warehousing and Data Mining and Computational Intelligence, Completed my BS with 3.14 CGPA BSCS TRANSCRIPT

Services

Data Pipelines (AirFlow|Luigi)
ETL Processes
Stored Procedure
Feature engineering
Data Modeling
(SQL, NOSQL)

Cloud Data Warehouses
(Amazon Redshift)
(Azure Synapse Analytics)
Data Lakes
(S3 | Delta Lake)
Web Scraping
(Scrapy|Requests)

REST API
(Python|Node)
Full Stack Development
(Node|React)
Machine Learning
Supervised(C|R)
Unsupervised

Big Data
(Spark | Kafka)
Automation
(processes | pipelines)
Cloud
(AWS | Azure)
My works


Courses


Data Modeling

  • Data Modeling with Postgres
  • Data Modeling with Apache Cassandra
Cloud Data Warehouses
  • Amazon Redshift
Data Lakes with Spark
  • Data Lakes
Data Pipelines with Airflow
  • Data Pipelines


Certificates



Contact Info

Islamabad
Pakistan

osmanghanimughal@gmail.com

Phone : +92314-5270917

Site : www.yoursite.com

Send me an email

Your message has been sent. Thank you!

Sorry your message can not be sent.

/

Usman Ghani

Data Enthusiast & Software Engineer