Syed Raza Abbas Email & Phone Number

Berlin, Berlin, Germany

Working in Marketing Technology team.Tasks include: - Enhancement of existing data pipelines as per the needs of Marketing Analysts and Data Scientists.- Improving the existing Data warehouse to accommodate current and future needs & performance.- Managing the migration of data pipelines from Data Intelligence team to Marketing Technology team's ownership.- Driving technical planning sessions in case of any new features & documenting the final plans. - Conducting technical investigations in case of data pipelines failure and proposing solutions.- Writing data quality checks.- Developing alerting and monitoring mechanisms.- Optimizing SQL queries. Technologies used:- SQL- Python- AWS Redshift- DBT- Airflow- Health checks- PagerDuty

Berlin, Berlin, Germany

Worked as a Data Warehouse Engineer in Marketing Technology team.

Lahore, Punjab, Pakistan

Worked as a Data Warehouse Engineer in Marketing Analytical and Steering team.

Lahore, Punjab, Pakistan

Worked on Dubizzle, Bayut, Profolio, Propforce & Zameen.com's related data. Tasks include: - Requirements gathering from BI team.- Designing of Data warehouse solution on AWS Redshift, including flat & hierarchical dimensions and relevant fact tables in ODL and ADL. - Developing data pipelines using Matillion.- Building dashboards for BI team and data auditing purposes. - Pushing data to ElasticSearch Indices. - Writing data quality checks.- Ensuring immediate notification in case of data pipeline failure by setting up alarms.- Optimizing SQL queries. - Preparing technical documentations for Business Analysts. Technologies used:- Python- SQL- AWS Redshift- AWS Lambda- Matillion- Elasticsearch - Periscope

Lahore, Punjab, Pakistan

Lahore, Punjab, Pakistan

Worked as a Data Engineer in Data Analytics department.Tasks included:- Creating data workflows on NiFi. - Creating/Modifying Airflow DAGs.- Creating/Modifying Lambda jobs. - Designing/Developing data pipeline solutions.- Ingesting files from multiple sources (SFTP, NFS, S3, APIs).- Dealing with multiple type of file formats (csv, xlsx, parquet, xml, JSON, zip).- Updating SQL queries as per business need. - Generating QA reports for auditing purpose.- Troubleshooting in case of failure in data pipeline. - Ensuring data quality throughout the ingestion and post ingestion process.- Preparing functional specification and use case documents. - Mentoring junior resources. - Client facing.Technologies used:- Python- SQL- SPARK- AWS Athena- AWS Lambda- AWS Step Functions- Apache Nifi- Apache Airflow

Lahore, Punjab, Pakistan

Worked as a Data Engineer on Big Data and Data Lake oriented projects.Tasks included:- Developing end-to-end data pipelines. - Writing connectors to hit APIs for data ingestion.- Handling pagination of data.- Dealing with structured & unstructured data.- Performing ETL jobs.- Data cleaning and transformation.- Data visualization.- Conducting POCs.- API testing.- Ingestion and Post Ingestion testing.- Client facing.Technologies used:- Python- SQL- SPARK- Postman- AWS Glue- AWS RDS- AWS Athena- AWS Quicksight- AWS Step Functions

Bachelor'S Degree, Computer Science, Cgpa: 3.59

- SEECS Principal Appreciation Letter for GPA 4.0 in 7th semester. - Merit based scholarship in 1st, 2nd, 4th and 7th semester.

A-Level, Physics, Chemistry, Maths, 2A* 1A

- Gold Medalist. - 100% merit based scholarship holder.