Ahmed Seoudy

Implemented complex SQL queries to generate IFRS report. Developed ETL pipeline using PowerCenter to generate Financial Inclusion for companies. Applied data cleansing from removing duplicates and insuring consistency using SQL. Wrote test scripts in SQL to test the data pipelines. Tuning and optimization of queries which ran daily to improve their performance. Scheduled and automated workflows that ran daily and monthly. Attended meetings with data lead and business team to discuss output of reports.

Core data modelling and analysis using SQL. Built data tool to facilitate data cleansing and statistical analysis using python libraries Built and maintained materialized views containing OLAP cubes using SQL. ETL using PowerCenter from various sources and loading in Teradata DWH. Support Marketing team throughout the promo creation process: 1) Pre-Analysis and customer identification 2) Target Segment Creation 3) Post Analysis for result Designed CVM data mart that ran daily containing 100s of KPIs.