Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Civilstatus
Languages
Accomplishments
Timeline
Generic
UMAIR IQBAL

UMAIR IQBAL

Neunkirchen,Saarland

Summary

Over 9 års erfaring med dataanalyse, data warehousing og Business intelligence Udvikler. Varieret erfaring inden for IT-branchen (bilindustrien, jernbanetransport, finansielle tjenester, forsikring og sundhedspleje). Ansvarlig for at arbejde med ETL-udviklere og dataanalytikere for at identificere, udvikle og implementere løsninger til at udtrække og integrere data til og fra datalagre og data marts til rapportering, beslutningsstøtte og analyse. Omfattende erfaring med cloud-tjenester. Dybt kendskab til hele SDLC (Software Development Life Cycle).

Overview

14
14
years of professional experience
6
6
years of post-secondary education
6
6
Certifications

Work History

Lead Data Analyst Engineer

Tech Developers
Ingolstadt
7 2024 - Current
  • Responsible for developing, deploying, and maintaining BI interfaces, including data visualization tools, data analytic, and reporting software
  • Also involves in transforming data into insights that drive business decisions.
  • Customized statistical models based on specific client requirements, enabling tailored solutions that drove positive outcomes.
  • Reduced manual errors in budget forecasting through the implementation of an automated financial modeling system.
  • Deep Implementation of Spark architecture, including its core components (Spark SQL, Spark Streaming, Spark MLlib, etc.).
  • Proficiency in designing and optimizing Spark jobs for performance, including techniques like partitioning, caching, and tuning.

Business Intelligence Developer

National Express Rail GmbH
09.2022 - 06.2024
  • Actively worked with Business Partners and Designers to get the Requirements and create High level Application Design
  • Prepared Dashboards using calculations, parameters in Tableau and Developing POWER BI reports that provide clear visualizations of various industry specific KPIs
  • Creating/Maintaining DWH as well as Designing Data pipelines
  • Developing Scripts and Reports related to MS SQL Database and MS Power BI
  • Being member of BI Team responsible for designing, defining, maintaining, and Analyzing ETL Process
  • Optimizing and Deployment of different processes via Azure ADF and MS SQL Scripts
  • Creating New Reports and maintaining old Reports and Daily process in MS Power BI.

Software Engineer in Database

ASTRUM IT (Siemens Healthcare GmbH)
10.2021 - 03.2022
  • Developing Applications based on CT scan Pattern machine Data
  • Being member of Software Development Team responsible for designing and defining ETL Process
  • Designed and Developed the Framework Manager models using stored

Software & Database Engineer

Buchbinder Autovermiettung(Europ Car Mobilty GmbH)
02.2019 - 03.2021
  • Developing Applications from scratch as well as Module Based Development
  • Being member of software Development Team responsible for assessing software requirements and implementation
  • Analyzing and debugging intensive code.

BI Software Engineer

Brain o Tech IT Solution
01.2015 - 12.2018
  • Requirement Specification Documentation
  • Source qualitative data from primary or secondary sources, interpret data accurately, analyze the results, and draw reports from the insights gained Hands on with databases and data mining techniques in a business environment
  • Data Modeling from scratch and from existing models
  • Use reporting tools to create and deliver dashboards and reports to stakeholders from technologies SSIS, SSRS
  • Data Normalization and Process optimization in DWH (Data warehouse)
  • Implementation of SDLC (Software Development lifecycle Process)
  • Testing and Deployment of variety of Phases in Application Development UML Design Modeling of modular process and change logs
  • Worked with REST API.

Freelance Trainee Software Engineer

24/7 Logistics Company
04.2011 - 10.2012
  • Working alongside the Team of web developer to deliver optimum performance of clients' Application
  • Preparing presentations and keeping clients up to speed with the development process
  • Developing web code
  • Auditing websites and reporting any performance issues within Team
  • Writing Test Cases using AAA approach
  • Fixing Bugs as per user Requirements
  • Coordinate with Testing and Deploying Team
  • Address main Application Performance issues in order to fix them.

Education

MSC in Business Innovation and Management - Business Innovation and Management

Steinbeis University
06.2024 -

MSC in High Integrity Computer Systems (Not completed) - undefined

Frankfurt University of Applied Sciences
03.2013 - 12.2014

BSC Computer Science - Computer Science

University of Karachi
01.2008 - 12.2011

Skills

SQL Expertise

ETL development

Data Quality Management

Data Modelling

Dashboard creation with MicrPower BI

Azure Cloud Services

Pipeline Development and Maintenance

Scala

Apache Spark

Python Programming

Advanced analytics

Machine Learning

Devops

Agile

Amazon Web services

MS Excel and Power Point

Certification

Diploma in Software Development, 11/2011

Personal Information

Nationality: German

Civilstatus

Single

Languages

English
Advanced (C1)
German
Advanced (C1)
Arabic
Intermediate (B1)
Urdu
Bilingual or Proficient (C2)
Danish
Beginner (A1)

Accomplishments

  • Resolved product issue through consumer testing.
  • Documented and resolved Pipeline issue which led major Performance enhancement.
  • Achieved Architectural success by completing 3 tier development pattern with accuracy and efficiency.
  • Achieved Technical Yearly Timetable Implementation via Data flows and ETL process enabled with XML shredding and extracting with accuracy and efficiency.
  • Supervised team of 4 people staff members.
  • Used Microsoft Power BI to develop and do tracking Key Performance Indicators.

Timeline

MSC in Business Innovation and Management - Business Innovation and Management

Steinbeis University
06.2024 -

Business Intelligence Developer

National Express Rail GmbH
09.2022 - 06.2024

Software Engineer in Database

ASTRUM IT (Siemens Healthcare GmbH)
10.2021 - 03.2022

Software & Database Engineer

Buchbinder Autovermiettung(Europ Car Mobilty GmbH)
02.2019 - 03.2021

BI Software Engineer

Brain o Tech IT Solution
01.2015 - 12.2018

MSC in High Integrity Computer Systems (Not completed) - undefined

Frankfurt University of Applied Sciences
03.2013 - 12.2014

Freelance Trainee Software Engineer

24/7 Logistics Company
04.2011 - 10.2012

BSC Computer Science - Computer Science

University of Karachi
01.2008 - 12.2011

Lead Data Analyst Engineer

Tech Developers
7 2024 - Current
UMAIR IQBAL