Requests
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
PWC Middle EastData Engineering Manager
Oct. 2023Egypt, Cairo Managed Development Team by supporting Development (Architecture- Coding-Pipelines) Project (Unilever)
• Led Engineers to work on requirements from a technical and business standpoint Project (Unilever)
• Gathered Business Requirements to create data processing specification documents for different regions Project (Unilever)
• Build database from scratch to serve as a data source point for supply chain operations Project (Unilever)
• Developed Spark SQL Scripts to Generate Base data for Supply Chain Operations Project (Unilever)
• Implemented PySpark and Spark SQL code for Multistop shipments to calculate lane distance for shipments Project
(Unilever)
• Acted as SME for Development team to ensure solid understanding for Client Business data Project (Unilever)
• Built Streaming Databricks Notebooks to process JSON files generated by API and built pipelines to process data from
Staging to Bronze Project (SSEN)
• Designed Medallion architecture for Oracle service Cloud and Oracle CRM integrations Project (SSEN)
1
• Followed best practice in writing PySpark and implementing reusable components techniques Project (SSEN)
• Worked with Metadata driven framework design approach Project (SSEN)
• Lead and develop a team of engineers, ranging from Graduates to senior Engineers
• Worked With Azure DEV -OPS to sync development work in production pipelines
• Coach, mentor, provide feedback, and led team by example
VOISBusiness insights Sr Lead
Mar. 2022 - Oct. 2023Egypt, Cairo Developed KPIs for Power BI Dashboards for monitor projects progress
• Migrated SAP System to AWS Redshift
• Developed Postgres SQL Scripts to create views similar to excel reports
• Refactored Procedures from Oracle to Redshift
• Performing data validation and data mapping
• Created dashboards to show each project in a group of projects to measure performance and capacity
• Maintaining Power BI Dataflows and Reports Refreshing Cycle
IKEA SAUDI ARABIASenior Data Integration Developer
Feb. 2021 - Mar. 2022Egypt, Cairo• Developed KPIs for Power BI Dashboards by creating DAX measures in SSAS and Power BI
• Designed data Pipelines in azure data factory to migrate data from server to a server
• Developed T -SQL Scripts to create complex calculations to show as KPIs on Power BI
• Designed an SSIS package to upload and process budget figures for IKEA food business
• Performing and documenting data analysis, data validation and data mapping
• Created dashboards to show in depth analysis for customer experience department
• Pulled data through APIs using python to cleanse and insert it into Data Lake and Datawarehouse
• Designed new Facts and Dimensions in Datawarehouse as per business need
• Applied transformations on large datasets in SQL and in Azure Fata Factory
• Applied Fixes in SQL code for Datawarehouse and its store procedures
AdvansysSenior ETL Developer
Aug. 2019 - Feb. 2021Egypt, Cairo• Designed SSIS Packages and developed T -SQL Scripts to perform financial calculation (reconciliation process)
• Deployed SSIS Packages using project deployment model to execute SSIS Packages on production environment
• Scheduled Jobs using SQL agent to execute T-SQL Scripts and SSIS Packages
• Developed T -SQL Scripts to Load CSV files to SQL data tables using Bulk insert
• Performed Testing on SSIS Packages and T-SQL scripts to ensure its accuracy and performance
• Used multiple data sources and destinations such as OLEDB, Excel and CSV
• Used Script task to modify Excel templates and to modify variables values
• Used Send Email Task to send to the end user Excel files and messages
• Created Documentation for Reconciliation process to describe each step in the process
First Abu Dhabi Bank (FAB)SQL Developer
Sep. 2017 - Sep. 2018Egypt, Cairo• Wrote complex SQL queries to fetch data utilizing inner/outer Joins, sub-queries, system functions and CTEs
• Wrote very Complex Store Procedures to implement business logic and to perform aggregation over datasets.
• Performed Automation to Generate FX Transactions and to Consolidate Product Codes
• Deployed Store Procedures and SSRS Reports in Production Environment
• Loaded Data from Flat Files Using bulk insert and SSIS Packages
• Created a Daily Package to Execute Oracle Store Procedures, transfer data and insert data into SQL Server
• Created Reports using SSRS for business units such as Trade Finance, Retail and corporate units
• Created Packages using SSIS to perform to Extract, transform and load data tables from Oracle to SQL Server
• Involved in Designing Database for projects (Tables Relationships & Datatypes)
• Documented ETL processes in functional design documents
• Created Reports using Crystal Reports for branches and regional office
• Involved in requirement gathering with Business Relationship managers and Business Users.
3
• Collaborated with business partners to obtain and discuss data requirements from a business standpoint.
• Analyzed datasets to ensure the completeness and the validity of the data
Bank Of AmericaSample Developer
Mar. 2016 - Jan. 2017United States, Charlotte• Wrote SQL queries to fetch data utilizing inner/outer Joins, sub-queries, and CTEs to extract records from SQL Server
Tables.
• Experience in creating Indexes, Views, Stored Procedures, User defined functions (UDF) and Triggers to ensure efficiency
and consistency of Microsoft SQL Server databases.
• Wrote Complex Store Procedures and User defined functions (UDF) to implement business logic and to perform
aggregation over datasets.
• Involved in reviewing SQL codes to ensure development best practices, proper code logic and code accuracy.
• Involved in extracting data from multiple sources such as SQL Server, Oracle, Micro-strategy, and Excel.
• Extracted data from Micro-strategy platforms to provide data for compliance tests.
• Designed Windows app in C#.NET to perform process automation employing Object Oriented Programming concepts
(OOP) such as encapsulation, inheritance, polymorphism, and abstraction.
• Designed abstract classes and interfaces to construct business logic using C#.NET.
• Successfully moved XML data elements from XML files to windows forms textboxes and vice versa.
• Worked with HTML to get data elements from SharePoint forms.
• Worked with Word, InfoPath, and Outlook Assemblies to implement different functionalities with C#.NET.
• Utilized Outlook classes in Visual Studio to send automated emails using C#.NET.
• Developed Excel formulas, lookups, and pivot tables to get certain details from large datasets.
• Involved in requirement gathering with sampling managers and test developers.
• Collaborated with business partners to obtain and discuss data requirements from a business standpoint.
• Conducted reviews on business documents along with datasets to ensure consistency and data sufficiency.
• Documented data mapping and transformation processes in functional design documents based on the business
requirements.
• Analyzed datasets utilized for compliance tests to ensure the completeness and the validity of the data.
• Performed data validation to ensure that no manipulation occurred on the data.
• Worked on sample development in various work-streams such as Global Financial Crimes, Global Technology and
Operations to provide statistical/non-statistical data samples for compliance tests.
• Wrote desktop procedures for production users to facilitate data extraction processes.
• Performed Quality Assurance on datasets and business documents to ensure consistency and process adherence to Bank
standards.
• Acted as a Scrum Master in Daily Scrum meetings to discuss challenges with team members and to suggest effective solutions
Intch is a Professional Networking App for the Future of WorkSee more people like Ahmed on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1027651 people
17
Consultant
16
software engineer
36
Product Owner @ CME Group
74929 people
17
BI Developer @ Trufla
18
IT consultant @ Neuro-gov
15
Head of Delivery and Operations @ Airnxt