Egypt

Data Engineering

Bachelor's degree

General Secondary School

Muhammad Salah ElOkda

Senior Data Engineer

Advanced data analytics

Database management

Pandas

Python

Airflow

Apache Spark

Introduce yourself, define mentoring expectations and goals. Learn and grow together.

General mentorship

Understanding factors that lead to a motivated team - recognition, communication and more.

Keeping team members motivated

Understand the process of training, motivating and directing your team members.

Managing people

Steps to building and maintaining a strong, cohesive and effective team.

Building an effective team

Learn the tips to successfully manage a team in a remote environment.

Managing a remote team

How to successfully prepare and position yourself for a job promotion?

How to get promoted

How to ask for a promotion and negotiate for salary raise?

Negotiating a job offer

How to think about design career paths and what progression looks like for designers?

Design career path

-Creating data pipeline for ingesting data from source systems to Autonomous Data Warehouse Talend Open Studio
-Develop ETL jobs using PL/SQL with stored procedures to feed the Data Warehouse
-Responsible on Administrating the data warehouse
-Data Security on Masking PII and PCI data
-User Access management to apply SAMA requirements
-Managing Data Warehouse and ETL server on Oracle Cloud Infrastructure OCI

-Instructing School and University students with OBM Technology about Introduction to Data Science.
-Provide Big Data using Hadoop training to WE schools

-Creating data pipeline for ingesting data from source systems in DB2 database to IBM cloud bucket using Apache PySpark and Airflow in Python
-Migrating an Ingestion pipeline from Datastage and shell scripts to Python and IBM DMT using SFPT, PGP Decryption, Extracting, Transforming with pandas, uploading files to IBM cloud storage, and Moving data to BigSql using IBM DMT
-Managing Docker image on RedHat Openshift to deploy the application and run on it
-Develop ETL jobs using PL/SQL with stored procedures to feed the Data Warehouse
-Using GITHUB as a version control for projects

Datastage ETL Performance tuning for the extraction team
Data Analytics in CVM with Promo Engine team to gather dump of data used in the promos and segment each customer with a suitable gift.
Gather requirements and translate them into technical requirements.
Build solutions to meet the business requirements.
Enhancing the existing ETL jobs.
Applying customer segmentations on offers and fees based on customers behavior. 
Delivery for Enterprise Layer by extracting data from source systems and loading it into models in the DWH.
Working on extracting data for ATL and BTL promos with agile methodology.

Manage the technical delivery of multiple projects on-time.
Managing Developers on ETL projects from requirements through delivery.
Provide planning, estimation, scheduling, prioritization and coordination of technical activities.
Identify and manage dependencies and downstream impacts of the project to minimize adverse effects on other projects.
Responsible for modelling the Data Hub.
Responsible for any administrative activities on the AIX servers for Informatica.
Generate a Data Catalog for the bank to track metadata from source systems to reports.
Configure DB2 client on AIX to extract data from IBM .AS400.

Working on Big Financial Data project to deliver data into specific formatting in files to the italian banking group Intesa Sanpaolo.

Working on site with Bank Du Caire.
Creating an Informatica environment on their new AIX development server.
Creating the essential services such as Domain, Integration Service and Repository Service.
Creating the metadata Service and then show the lineage of their legacy mappings from the source till the target databases.
Working as an ETL developer for the IFRS9 project for Bank Du Caire.
Working on ETL task for ATM transactions reconciliation to be automated.

• Data Overview, Industry Applications, Case Studies
• Understanding Big Data
• HortonWorks Data Platform
• Big Data architecture
• Storing and processing data with Hadoop
• Creating data using HDFS
• Data distribution and storage with MapReduce
• Access HBase/Hadoop data with Hive
• ZooKeeper, Slider, Knox
• Loading data with Sqoop
• Big SQL
• IBM Watson Studio

Working on Informatica Administration task for creating the metadata manager service for ADIB bank and run the lineage between a data source to PowerCenter mappings.

Middleware and Enterprise Service Bus training for exposing SOAP and RESTFUL web services using TIBCO Business Works.

Content of the training:
1. Introduction to AI and Machine Learning
2. Services of Watson 
3. NLP
4. Chatbots
5. Computer Vision (Visual Recognition)

Working on IFRS9 project for Credit Agricole Bank as an ETL developer on site with Data Warehouse team using Informatica PowerCenter tool.
Working on existing ETL mappings for the Bank.
Extract data from different sources to load it into their Data Hub then load it again into their Data Warehouse.
Working on OBIEE tool for Business Intelligence reporting.

Participated in the IBM blockchain Hackathon and my team won the first place for a food subsidy problem in egypt to stop the fraud and stealing.

Support on ETL projects with NCB in KSA remotely using Informatica PowerCenter for Data Archiving.

Developing a native android application in java for the showing the near hospitals and pharmacies or any healthcare related places.

Participated in TREE'15 workshop as an Android developer with an Android application called Escape. 
Escape was one of the top 3 apps in this year.

Muhammad Salah ElOkda🇪🇬

About Muhammad Salah ElOkda

Expertise

Sessions with Muhammad Salah ElOkda

What mentees say