Wagdy El-Sherbiny, Developer in Salmiya, Hawalli Governorate, Kuwait
Wagdy is available for hire
Hire Wagdy

Wagdy El-Sherbiny

Verified Expert  in Engineering

Data and Database Developer

Location
Salmiya, Hawalli Governorate, Kuwait
Toptal Member Since
April 18, 2022

Wagdy is a senior data and database engineer with over eight years of experience with data-related and real-time mega projects. Highly proficient in SQL, databases, and data warehouses, including designing and implementing, he has managed software projects and worked for significant clients, such as ADNOC, Emarat, KNPC, and KOC. Wagdy is an expert in data pipelines, data analysis, and Python and focuses on understanding clients' needs and designing and developing state-of-art solutions.

Portfolio

Diyar United Company
Azure SQL, C#, C#.NET, Databases, Data Engineering, Data Analysis, Agile...
Management Development Center (MDC)
Active Server Pages (ASP), ASP.NET, Windows Services, Web Services...
Misr University for Science and Technology
C#, C++, Data Structures, Operating Systems, Education, Communication...

Experience

Availability

Part-time

Preferred Environment

Data Engineering, Databases, Data Warehouse Design, Python, Data Analysis, NoSQL, SQL, PostgreSQL, MongoDB, ETL Tools

The most amazing...

...thing I've developed is the self-service payment and operation station used by ADNOC in the UAE, the world's 12th largest oil company by production.

Work Experience

Senior Data Engineer

2014 - PRESENT
Diyar United Company
  • Collaborated with the project management team to analyze and consolidate request requirements to improve the decision-planning process and meet project deadlines.
  • Led medium projects from scope definition to execution and implementation.
  • Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data, and develop integrated information delivery solutions.
  • Designed, implemented, and maintained different kinds of the database management systems (DBMSs), such as Oracle, Microsoft SQL Server, Microsoft Azure SQL, and PostgreSQL.
  • Analyzed and compiled an itemized list of components needed for data migration or integration with various systems, such as Oracle Enterprise Resource Planning (ERP), SAP, and Comarch Loyalty Management (CLM).
  • Participated in designing and implementing a data warehouse, data marts for analysis, data mining projects, and implementing changes to existing BI systems.
  • Used the SSIS tool to gather data from various resources, follow the data-wrangling cycle to store and deliver cleaned data for data analysis, and develop a customized pipeline for data ingestion and loading from an external system.
  • Built a fast and reliable invoicing system that efficiently processes millions of transactions and integrates with the Oracle ERP or SAP system. Reduced the invoice generation time from six hours to 20 minutes.
  • Identified the key reports and dashboards to satisfy the client’s requirements and developed different kinds of reports like parameterized reports, ad hoc reports, and drilldown and drillthrough reports using SSRS and Power BI.
  • Troubleshoot data issues, analyzed and corrected error and performance logs, made backup routines, and prepared system deployment and upgrades. Trained various business unit teams on the effective use of processes, tools, and resources.
Technologies: Azure SQL, C#, C#.NET, Databases, Data Engineering, Data Analysis, Agile, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft Power BI, Qlik Sense, Oracle, PL/SQL, T-SQL (Transact-SQL), Microsoft SQL Server, PostgreSQL, Python

Full-stack Developer

2012 - 2014
Management Development Center (MDC)
  • Participated in developing the Rhazes solution that includes all the medical, clinical, and administrative modules needed to manage and operate a hospital in a smooth and user-friendly way.
  • Developed SCHOOLIZER software used to efficiently manage all the systems and processes related to running any educational institute.
  • Troubleshot and fixed the production issues related to an e-learning system called MUST.
Technologies: Active Server Pages (ASP), ASP.NET, Windows Services, Web Services, Crystal Reports, SQL, Microsoft SQL Server, HTML, CSS, C#

Teaching Assistant

2012 - 2014
Misr University for Science and Technology
  • Managed, planned, and prepared the learning materials and courses related to computer science for different classes and levels.
  • Used different educational methods to promote a positive learning environment and organized group work projects and brainstorming sessions.
  • Set requirements for the different assessments and kept records of the students' development.
  • Kept up to date with changes and developments in the field of computer science.
Technologies: C#, C++, Data Structures, Operating Systems, Education, Communication, University Teaching, Algorithms, Applied Mathematics, Statistics, Databases

ADNOC Smart Wallet

https://smart.adnocdistribution.ae/
ADNOC Distribution is the UAE's leading operator of retail fuel service stations. ADNOC Wallet makes ADNOC service station payments quick and easy. It's fully secure and keeps track of everyday spending at ADNOC service stations. It includes refueling, shopping, lube change, and car washes. In addition, customers can register multiple cars or beneficiaries to an account.

I was the software engineer who participated in and developed all objects related to the data area, including databases such as triggers, stored procedures, jobs, data warehouse, pipelines, and reporting. I created a set of systems, including the following:

• A card management system (CMS).
• A comprehensive centralized software solution providing our clients with a user-friendly interface that integrates tightly with other back-end and external systems, such as customer management, beneficiary management, token management, transaction management, system settings, BI reports and dashboards, differential pricing, notification management, ERP integration, loyalty system, e-vouchers, coupons, data migration, and card printing system that personalizes smart cards, vehicle depot system, and invoicing.

Emarat Petroleum Company Station Management Service

https://www.emarat.ae/businesses/fleet-payment-solutions
Emarat is a multi-channel power and energy company with a network of service stations and fuel depots across Dubai and the Northern Emirates. In this project, I worked on the following:

• Implementing and customizing a turnkey solution to meet the company's station management and retail services needs.
• Participating in the system requirement gathering and analysis phases.
• Analyzing and compiling components needed for data migration and integration with various systems, such as Oracle ERP, NCR, and NAMOS.
• Developing a data migration workflow to move data into a new system using SSIS.
• Building a differential pricing system and NCR discounts.
• Developing various reports and dashboards using SSRS and Power BI.

Kuwait E-passport

I collaborated with a team to design and implement a set of reports and dashboards for executives and operation users of Kuwait’s Ministry of the Interior e-passport system. I performed requirements analysis, made system designs, oversaw implementation, and drafted documentation. Also, I created numerous processes using Microsoft BI tools to develop and implement a data warehouse and designed an SSIS package that extracts citizen data from an SQL Server database using lookup transformation and the Foreach Loop container. Finally, I built dashboards to demonstrate the overall performance of the passport printing center.

KNPC Petrol Filling Stations

The Kuwait National Petroleum Company (KNPC) is Kuwait's national oil refining company. As a software engineer, I participated in building a turnkey solution for retail service stations from scratch to meet KNPC's business needs and operations. I participated in all of the systems development lifecycle (SDLC) to build a centralized solution that manages customers' profiles, consumption, transactions, invoicing, loyalty points, e-vouchers, pre-printed vouchers, and data integrations with Oracle ERP and NCR systems, in addition to building modules related to managing users permissions and system setting and data backup routines.

Kuwait Digital Oil Field Project

I worked on the first Digital Oil Field (DOF) project in Kuwait, using Petroleum Experts (PETEX) technology to enhance the oil well production and operations by providing frameworks and dashboards for decision-makers. I served as the first line of support for the PETEX solution, assisting petroleum engineers during daily operations, overseeing troubleshooting data issues, and helping users interpret and understand report data. I used the following software solutions: Integrated Visualisation Management (IVM), Integrated Production Modeling (IPM), IFM, PROSPER, and Model Catalogue.

Kuwait National Guard's Fleet Management

This web application manages all the Kuwait National Guard's vehicles fleet operations. As a software engineer, I oversaw gathering requirements, analyzing the client's needs, and providing detailed design documents to the team. I worked closely with the development team to design and implement the database's objects and the Windows Communication Foundation (WCF) service to provide the front-end developers with the required info for a web app. Also, I managed the production deployment activities and troubleshooting issues and conducted training and user acceptance testing (UAT) sessions for end-users.

The Ford GoBike System

https://github.com/wagdySamy/DataAnalysis
The Ford GoBike System dataset contains information about individual rides made in a bike-sharing system covering the greater San Francisco Bay area. There are approximately 183,400 records with attributes in the dataset that describe rides, including start station, end station, and duration.

WeRateDogs Analysis

I illustrated the steps and procedures used for wrangling a real-world dataset known as WeRateDogs. WeRateDogs is a humorous Twitter account that rates dogs with commentary. I collected data from different resources, such as ZIP and CSV files, and queried the Twitter API to fetch data.

Languages

SQL, Python, C#, C++, C#.NET, T-SQL (Transact-SQL), Scala, Active Server Pages (ASP), HTML, CSS

Storage

Databases, SQL Server Reporting Services (SSRS), PL/SQL, PL/SQL Developer, Oracle PL/SQL, SQL Server Integration Services (SSIS), PostgreSQL, NoSQL, MongoDB, Azure SQL, Microsoft SQL Server, HBase, Apache Hive, Database Administration (DBA), Database Modeling, SQL Server Analysis Services (SSAS)

Other

Data Warehouse Design, PL/SQL Tuning, Data Engineering, Data Analysis, ETL Tools, ELT, Data Wrangling, Big Data, Azure Data Factory, Software Engineering, Data Structures, Operating Systems, Algorithms, Artificial Intelligence (AI), Neural Networks, Streaming, Machine Learning, Data Visualization, PETEX, DAX, Data, IIS, Analysis, Teamwork, Team Management, Data & Backup Management, Data Modeling, Production, Deployment, Software Troubleshooting, Troubleshooting, Education, Communication, University Teaching, Applied Mathematics, Statistics, Windows Services, Web Services, Linear Regression, Multidimensional Expressions (MDX), Star Schema, Big Data Architecture

Libraries/APIs

Pandas, Matplotlib, NumPy, Twitter API, PySpark

Tools

Microsoft Power BI, Qlik Sense, Flink, Flume, Apache ZooKeeper, SQL Server BI, Oracle ERP, Crystal Reports

Paradigms

ETL Implementation & Design, Agile, Business Intelligence (BI), MapReduce, ETL, User Acceptance Testing (UAT)

Frameworks

Windows Communication Framework (WCF), Hadoop, Spark, ASP.NET

Platforms

Oracle, Apache Kafka

2008 - 2012

Bachelor's Degree in Computer Science

Misr University for Science and Technology - Giza, Egypt

MARCH 2021 - PRESENT

Spark and Python for Big Data with PySpark

Udemy

NOVEMBER 2020 - PRESENT

HCIA-Big Data Course

Huawei Academy

JULY 2020 - PRESENT

AWS Machine Learning

Udacity

MAY 2020 - PRESENT

Data Analysis Professional Nanodegree Program

Udacity

MAY 2020 - PRESENT

Data Engineer with Python

DataCamp

FEBRUARY 2020 - PRESENT

MongoDB Basics

MongoDB University

JANUARY 2020 - PRESENT

Data Analysis Advanced Nanodegree Program

Udacity

AUGUST 2019 - PRESENT

Career Track Data Analyst with SQL Server

DataCamp

MARCH 2019 - PRESENT

Big Data Introduction Course

Coursera

JUNE 2017 - JUNE 2020

MCPS: Microsoft Certified Professional

Microsoft

SEPTEMBER 2014 - PRESENT

Computer Science Diploma

Mansoura University

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