Learn Data Skills
Beta
Umer Aziz

Umer Aziz

Data Analyst

Adlab Solutions | London

Technologies

My Portfolio Highlights

My New Workbook

Data Manipulation with pandas

My New Course

Introduction to Python

My New Workbook

Data Manipulation with pandas

Insights artist, transforming data into visually stunning masterpieces of knowledge.

My Work

Take a look at my latest work.

DataLab

Streamlined Data Ingestion with pandas

DataLab

Data Manipulation with pandas

DataLab

Investigating Netflix Movies and Guest Stars in The Office

DataLab

Streamlined Data Ingestion with pandas

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Azure Fundamentals AZ-900

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to Power BI
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

NuqtaSol | Jul 2020 - Jun 2023

Data Engineer | Production Support Engineer

As a Data Engineer, I provided specialized nightly support to Overstock.com, a US-based client, as part of an offshore team. My role encompassed leveraging technical proficiencies in SQL, Python, Bash scripting, and various ETL tools to ensure the seamless operation of their Data Warehouse ETL processes. I played a pivotal role in troubleshooting, root cause analysis, and optimizing ETL workflows, ensuring consistent data delivery and operational excellence. ● Supervision and training of new team members. ● Arranged weekly team meetings and automated process for developing monthly performance reports Optimized complex SQL queries to facilitate efficient data extraction, manipulation, and reporting. ● Utilized Python for automating routine data processes, enhancing ETL script performance, and streamlining migration-related tasks. ● Leveraged Bash scripting in tandem with Linux shell operations to automate routine tasks, streamline system processes, and enhance operational efficiency across data workflows. ● Supervised and optimized a vast array of tasks through Control-M Scheduler, effectively overseeing 3500+ jobs and ensuring timely execution. ● Spearheaded the pivotal transition of the data warehouse from Teradata to Google BigQuery on GCP, ensuring smooth migration, data consistency, and post-migration optimization. ● Regularly performed troubleshooting and root cause analyses on data-related issues for critical etl issues, guaranteeing data integrity and minimizing operational downtime.
Show More

My Education

Take a look at my formal education

Bachelors in Computer ScienceNational University of Computer and Emerging Sciences, Islamabad | 2020

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free