MUHAMMAD JUNAID UMER

Data Engineer | Python Developer

Message

Intro

Karachi, Pakistan

Data Engineer at ilmiya

ETL Developer at Kavtech Solutions (Private) Ltd

Studied Computer science and Software Engineering at International Islamic University, ISLAMABAD

Joined September 12, 2021

Skills

Languages

English

Intermediate

Urdu

Native or Bilingual

About

4+ years of experience in Data Engineering and Analysis having core expertise in Data Engineering, Python Scripts, API Integration, ETL Pipelines, Data warehouses, Power BI, Optimization of Databases and visualization. I got many job titles in previous years like SQL Data Processing Analyst, ETL Developer, Data Engineer, Data Analyst, DBA, and Python Developer. Tech Stack: - Python | SQL - Power BI - Pentaho | Informatica - AWS - MYSQL | PostgreSQL - Experience in Data warehousing with domain knowledge of telecommunications, Real Estate, and Fintech Based datasets. - Exposure to large data volumes database systems in PostgreSQL and MySQL. I have successfully delivered several Enterprise Data Management projects for Real Estates, Transactional Dataset I do have a working knowledge of the complete Data Engineering development life cycle. Including Requirements gathering, Development, Documentation and Testing. I have extensive experience in managing data integrations, business analytics and reporting using ETL tools that involve its integration using various APIs. I have good analytical & design skills, a focused approach, team player, hard working and professional attitude to work.

Experience

ilmiya

Jul 2022 – Present

Remote

Data Engineer

Kavtech Solutions (Private) Ltd

Nov 2020 – Present

Lahore, Pakistan

ETL Developer

- Analyzed the source system and was involved in designing the ETL data load. - Extensive SQL querying for Data Analysis and writing, executed, performance-tuned SQL Queries for Data Analysis & Profiling. - Worked in various transformations like Lookup, Joiner, Sorter, Aggregator, Router, Rank, and Source Qualifier. - Implemented documentation standards and practices to make mappings easier to maintain.

Johnsnowlabs.com

Jan 2022 – Jun 2022

Remote

SQL Data Processing Analyst

- Creating SQL Queries - Responsible for preparing the existing SQL platform for upgrades that were installed as soon as they were released. - Assisted in creating and presenting informational reports for management based on SQL data.

Techline

Jan 2020 – Nov 2020

Lahore, Pakistan

Data Analyst

- Extracting data from MYSQL and PostgreSQL database systems for the purpose of detailed analysis will provide the team valuable and relevant insights. - Validate and provide support for all Analyses using standard statistical methods. - Prepare and present a comprehensive report/summary of conclusions drawn from the analysis. - Identify patterns and develop predictive models on complex data sets

Education

International Islamic University, ISLAMABAD

Sep 2014 – Aug 2018

BS IN SOFTWARE ENGINEERING, Computer science and Software Engineering