Senior Data Analyst
OllKom Group
Total years of experience :5 years, 3 Months
- Worked Independently.
- Wrangled and Cleaned Data.
- Cleaned Inconsistent Records.
- Analyzed Influencers Marketing Data.
- Visualized data with: Plotly, Matplotlib and Seaborn.
- Made decisions based on data.
- Prepared Reports.
- Performed ETL operations and combined data from 2 sources Twitter and Kaggle into one central repository (DWH).
- Utilized Airflow DAGs to schedule tasks and automate data pipelines.
- Created SubDAGs and Custom Operators.
- Connected Airflow to AWS.
- Managed Redshift clusters for Data Warehousing.
- Used PostgreSQl and Apache Cassandra for Data Modeling.
- Leveraged PySpark to perform big-data processing.
---------------------------------------------
⇨ Client Review: ★★★★★
"Mahmoud did a great job and helped me with my big data project with Twitter Scrapping, Apache Spark, Apache Airflow as well as ELK Stack mainly ElasticSearch and Kibana"
⇨ Long-term SNA project to help Amber Heard against bot-like operations:
- Analyzed 6 platforms: Reddit, Instagram, YouTube, Twitter, Facebook, Change.org.
- Processed data using: Python, NumPy, Pandas and Jupyter Notebooks.
- Visualized data with: Plotly, Matplotlib and Seaborn.
- Did some NLP work to help in the analysis.
- Used the Postman API to classify text.
- Performed a multilingual threat analysis.
---------------------------------------------
⇨ Separated the analysis work into 4 parts:
1- Date/Time Analysis:
- Investigated Peaks (year, month, date, and hour) of accounts creations and posts.
- Created HeatMaps to show all the years in a single graph.
- Spotted weird activities like many posts or comments against Amber within just a few minutes/hours of the account’s creation.
- Identified bot-like activities like accounts posting or commenting twice in the exact same second.
2- Users/Accounts Analysis:
- Investigated the accounts' activities like the top posted accounts.
3- Posts/Comments Analysis:
- Posts/Comments with the most likes and replies.
4- MultiLingual Threat Analysis:
- Detected the language of the text in a new column.
- Translated all text into English.
- Reported the accounts that threatened to kill Amber.
---------------------------------------------
⇨ Client Review: ★★★★★
"Mahmoud is a great team leader and with communication. He studied Reddit which was a high volume of Data Analysis Reports. Machine Learning, R, and Python are used for Social Network Analysis. He went above and beyond with the exploratory analysis to look at the accounts, and numerous insights not previously explored in SNA on Reddit"
Job Description:
-----------------
(Non-Rotating Drill Pipe Protectors)
Mainly used to reduce torque and drag while drilling especially in highly-deviated, deep wells.
Responsibilities:
--------------
⇨ On the rig:
- Made up the protectors
- Monitored the protector's condition at each and every trip to replace the damaged ones.
- Provided daily technical reports to my managers including current depth and operations, BHA, drilling parameters (HL - WOB - Slack/ Pickup/ Rotating Wt. - RPM - ROP - Torque), mud properties and mud circulating parameters.
⇨ In the workshop:
- Refurbished the protectors and tools as needed to maintain their functionality.
- Operated a forklift to handle boxes and other equipment.
---------------------------------------------
My First Job (Jack-Up - Offshore Rig):
-------------------------------------------
⇨ I spent approximately 140 days on Shelf GSF-141:
- Within that period, I spent about two months collaborating with the HALLIBURTON MWD team:
- Gained valuable knowledge and skills in MWD/LWD fundamentals, including:
- The ability to build a Pulser and mitigate vibrations.
- Collaborated with Baker Hughes fishing engineers for two months and witnessed approximately 33 fishing runs using various fishing tools, including fishing magnet, string magnet, jars and pulser subs, tapered mill, string mill, ITCO SPEAR, overshot, and boot basket.
- Gained extensive experience in the SCHLUMBERGER Wireline Perforation unit
- Witnessed PICO-Mud-Engineers tests and learned a lot from them.
- Assisted in the company-man office, ensuring the driller applied the pre-set plan and helping with the drilling daily report (DDR).
Grade: V.G with a degree of honor and Excellent Graduation Project
