Abdelrahman Galal, Developer in Tartu, Estonia
Abdelrahman is available for hire
Hire Abdelrahman

Abdelrahman Galal

Verified Expert  in Engineering

Data Analyst and Developer

Tartu, Estonia

Toptal member since June 24, 2020

Bio

Abdelrahman is a multi-talented data analyst and engineer with solid technical skills. He delivers services that exceed the expectations of colleagues and end-users through a positive, well-organized, and structured work ethic. Backed by strong technical and analytical skills covering data science, data engineering, and machine learning involving Python and SQL, Abdelrahman is also capable of dealing with different cloud platforms such as GCP and AWS.

Portfolio

Research Institute
Python, Bash, Unix, SQL, Matplotlib
Alwefag
Oracle Development, Oracle Development, SQL Server, Apex, Oracle Development...
Oracle-managed Cloud Services
Linux, PL/SQL, SQL, Oracle Development, Oracle Database

Experience

Availability

Part-time

Preferred Environment

Toad, SQL Server Management Studio (SSMS), Oracle Application Express (APEX), Jupyter Notebook

The most amazing...

...project I've designed and implemented are data warehouses and exceptional data-quality checks.

Work Experience

Software Engineer

2020 - PRESENT
Research Institute
  • Built computational pipelines to process huge batches of data of different formats using Python, Bash scripts, and Nextflow.
  • Scheduled, tested, and ran the implemented pipelines on both HPC clusters and GCP.
  • Analyzed and visualized the results using different tools including Python visualization packages like Matplotlib.
  • Harmonized a massive amount of data from different sources and loaded them to one or more destinations using SQL and other integration services.
Technologies: Python, Bash, Unix, SQL, Matplotlib

Senior Data Analyst | Business Intelligence Consultant

2016 - 2019
Alwefag
  • Reviewed, designed, tested, and implemented monthly and quarterly sales reports using OBIEE, BI Publisher, Oracle Database, and SSIS as the ETL tool.
  • Implemented reports to monitor the performance of all departments based on specific KPIs and the KPI watch list.
  • Designed, built, and implemented reports to monitor stock, inventory, and purchase orders based on the Oracle ERP system.
  • Designed, built, and implemented reports to monitor salesmen, merchandising visits, and stock checks.
  • Performed data analytics and machine learning modeling using Python and special libraries like Pandas, NumPy, and Scikit-learn. In addition, implemented all of the department scorecards.
  • Designed and implemented a new web-based system for recruiting using Oracle APEX.
  • Participated in an Oracle EBS upgrade to 12.2.6 which involved executing and reviewing all legacy customizations.
  • Built APIs for OBIEE and EBS to communicate with legacy systems.
  • Created ETL jobs to load data from different sources (ERP, legacy) to the main data warehouse using SSIS.
  • Implemented many forums and transitional reports using Oracle BI Publisher.
Technologies: Oracle Development, Oracle Development, SQL Server, Apex, Oracle Development, SSIS, PL/SQL, SQL, Oracle Development, Oracle Database, Scikit-learn, NumPy

Business intelligence Consultant

2013 - 2016
Oracle-managed Cloud Services
  • Supported global customers during the implementation of their data warehousing and business intelligence environments.
  • Administrated Cloud OBIEE environments for many EMEA customers.
  • Installed new environments for customers.
  • Resolved customer issues through tickets and remote meetings.
  • Oversaw Oracle database and OBIEE performance tuning.
Technologies: Linux, PL/SQL, SQL, Oracle Development, Oracle Database

Back-up and UNIX Administrator

2012 - 2013
Etisalat
  • Developed the back-up database for both the Oracle and SQL server.
  • Oversaw the onsite installation of new equipment.
  • Created daily reports to monitor the execution of all back-up jobs.
Technologies: Cloud Engineering, Linux, Unix

Recruiting System

Gathered the recruiting cycle with the HR team. Designed the database schema, loaded data from the ERP system and implemented the website system using Oracle APEX.

Oracle EBS Upgrade

I redeveloped all the customized code to be compatible with the new EBS version.

Data Warehouse for Purchases

I met with business users, collected requirements, and built new data warehouse routines to populate the database with suppliers, purchase orders, purchase requests, and SKUs data. I then built reports and dashboards to visualize the data for decision-makers.

Oracle EBS Bulk Updates

Developed several Oracle EBS APIs to execute bulk updates on data (customer, item, and supplier data ) using PL/SQL.
2019 - 2021

Master's Degree in Information Technologies

University of Tartu - Tartu , Estonia

2011 - 2012

Diploma in UNIX Systems

Information Technology Institute (ITI) - Giza, Egypt

2006 - 2011

Bachelor's Degree in Communications and Electronics Engineering

Cairo University - Cairo, Egypt

JULY 2020 - PRESENT

Data Analyst Nanodegree

Udacity

Libraries/APIs

Pandas, NumPy, Matplotlib, Scikit-learn

Tools

Oracle Development, Oracle Development, Oracle Application Express (APEX), Oracle Development, Oracle Development, Oracle Development, Oracle Development, Business Intelligence Development, ArcGIS, Jupyter

Languages

SQL, Python, Apex, Python, Python, R, Bash

Platforms

Jupyter Notebook, Unix, Oracle Database, Linux, Docker

Storage

SQL Server, SQL Server, PL/SQL, SQL Server, SSIS, Oracle Development, GIS, PostgreSQL

Paradigms

ETL

Other

Data Science, Nextflow, Cloud Engineering, Oracle Development, Shell Scripting, Data Science, Data Analysis, Database Analytics, QGIS, Datasets, Software Development, OOP Designs

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring