Abdelrahman Galal
Verified Expert in Engineering
Data Analyst and Developer
Tartu, Estonia
Toptal member since June 24, 2020
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
Experience
- SQL - 7 years
- Oracle Database - 6 years
- ETL - 5 years
- Oracle Cloud - 5 years
- Data Analysis - 5 years
- Data Science - 4 years
- Python - 4 years
- Pandas - 3 years
Availability
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
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.
Senior Data Analyst | Business Intelligence Consultant
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.
Business intelligence Consultant
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.
Back-up and UNIX Administrator
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.
Experience
Recruiting System
Oracle EBS Upgrade
Data Warehouse for Purchases
Oracle EBS Bulk Updates
Education
Master's Degree in Information Technologies
University of Tartu - Tartu , Estonia
Diploma in UNIX Systems
Information Technology Institute (ITI) - Giza, Egypt
Bachelor's Degree in Communications and Electronics Engineering
Cairo University - Cairo, Egypt
Certifications
Data Analyst Nanodegree
Udacity
Skills
Libraries/APIs
Pandas, NumPy, Matplotlib, Scikit-learn
Tools
Oracle E-Business Suite (EBS), Oracle Business Intelligence Applications (OBIA), Oracle Application Express (APEX), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle SQL Data Modeler, Toad, Oracle BI Publisher, Microsoft Power BI, ArcMap, Jupyter
Languages
SQL, Python, Apex, Python 3, Python 2, R, Bash
Platforms
Jupyter Notebook, Unix, Oracle Database, Linux, Docker
Storage
SQL Server 2012, Microsoft SQL Server, PL/SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Oracle Cloud, PostGIS, PostgreSQL
Paradigms
ETL
Other
Data Science, Nextflow, NetBackup, Oracle Application R12 EBS, Shell Scripting, Data Analytics, Data Analysis, Database Analytics, QGIS, Datasets, Software, OOP Designs
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring