![Wagdy El-Sherbiny, Developer in Salmiya, Hawalli Governorate, Kuwait](https://assets.toptal.io/images?url=https%3A%2F%2Fbs-uploads.toptal.io%2Fblackfish-uploads%2Ftalent%2F1061480%2Fpicture%2Foptimized%2Fhuge-c5c4819db88ed0fb68038a8e0909e845.jpeg&width=524)
Wagdy El-Sherbiny
Verified Expert in Engineering
Data and Database Developer
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
Experience
Availability
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
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.
Full-stack Developer
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.
Teaching Assistant
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.
Experience
ADNOC Smart Wallet
https://smart.adnocdistribution.ae/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• 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
KNPC Petrol Filling Stations
Kuwait Digital Oil Field Project
Kuwait National Guard's Fleet Management
The Ford GoBike System
https://github.com/wagdySamy/DataAnalysisWeRateDogs Analysis
Skills
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
Education
Bachelor's Degree in Computer Science
Misr University for Science and Technology - Giza, Egypt
Certifications
Spark and Python for Big Data with PySpark
Udemy
HCIA-Big Data Course
Huawei Academy
AWS Machine Learning
Udacity
Data Analysis Professional Nanodegree Program
Udacity
Data Engineer with Python
DataCamp
MongoDB Basics
MongoDB University
Data Analysis Advanced Nanodegree Program
Udacity
Career Track Data Analyst with SQL Server
DataCamp
Big Data Introduction Course
Coursera
MCPS: Microsoft Certified Professional
Microsoft
Computer Science Diploma
Mansoura University
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