Usama Abbas Email & Phone Number

Riyadh, Saudi Arabia

• Rewaa enables you to track your inventory, sales, finance, and all selling processes offline and online, all through synced inventory and sales reports which come classified by period and branches.
• Extracted data from several sources, including ZohoCRM, GoogleAds, GoogleAnalytics, GoogleSheets, Meta, Snapchat, LinkedIn, TikTok, and Twitter, utilizing Fivetran.
• Collaborated with the Marketing, Sales, Finance and Customer Success teams, collected requirements and translated them into reports and dashboards using dbt and Metabase.
• Designed, developed and tested different SQL queries and optimized them using different techniques.
• Optimized the performance of the most utilized dashboard by over 90%, leading to a substantial reduction in load time from 13 seconds to under 1 second.
• Improved data consistency and enhanced stakeholders’ confidence by standardizing metrics definitions across all data models.

Singapore

• Cialfo, a Singapore-based company fostering connections among students, counselors, and educational institutions, aims to make education universally accessible.
• Designed and implemented a comprehensive ETL pipeline, leveraging Spark, Airflow, and SQL, to load and transform data from diverse databases into Data Lake on Amazon S3.
• Achieved an 80% boost in pipeline efficiency by optimizing ELT to ETL pipeline using EMR and Spark.
• Collaborated with Machine Learning engineers in crafting feature extraction pipelines for diverse ML models, utilizing SQL, Athena, and Airflow.
• Demonstrated leadership by instituting pipeline monitoring via Slack, ensuring real-time notifications for the team.
• Successfully migrated the feature extraction pipelines from Airflow + Athena to Snowflake.

Pakistan

• Orchestrated seamless data pipelines, ingesting data from diverse sources like GoogleAds, Microsoft, LinkedIn, Mixpanel, and Salesforce into Databricks via PySpark and Delta Lake.
• Generated meaningful reports and dashboards for diverse business stakeholders utilizing Databricks.
• Enhanced the data migration process (Full to Incremental) from DynamoDB to Databricks, incorporating data updates captured by Kinesis Fireshose.
• Automated the creation of infrastructure using AWS CDK.

• Employed reverse engineering and web scraping techniques to extract datasets (CSV, JSON, XML) from various Real Estate platforms, transforming them into a centralized data lake on Amazon S3 using Python and AWS Glue.
• Upheld data accuracy and reliability by validating datasets using GreatExpectations on AWS Lambda.
• Played a key role in data analysis and analytics across multiple projects, fostering effective collaboration with stakeholders.
• Improved the efficiency of the Amazon Redshift Data Warehouse by identifying and rectifying the absence of best practices.
• Led a team of DevOps engineers in establishing the infrastructure for a Data Lake project using Terraform.

Master Of Philosophy - Mphil, Computer Science

Bachelor'S Degree, Computer Software Engineering