Wagdy El-Sherbiny,科威特哈瓦利省Salmiya的开发商
Wagdy is available for hire
Hire Wagdy

Wagdy El-Sherbiny

Verified Expert  in Engineering

Data and Database Developer

Location
科威特哈瓦利省Salmiya
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, 包括设计和实现, 他管理过软件项目,并为重要客户工作过, such as ADNOC, Emarat, KNPC, and KOC. Wagdy是数据管道方面的专家, 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,数据库,数据工程,数据分析,敏捷...
MDC (Management Development Center)
Active Server Pages (ASP), ASP.. NET、Windows服务、Web服务...
北京科技大学
c#, c++,数据结构,操作系统,教育,通信...

Experience

Availability

Full-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, 按产量计算,它是世界第12大石油公司.

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.
  • 领导中型项目从范围定义到执行和实施.
  • 与跨职能团队合作解决问题, 确定适当的数据源, extract data, 并开发集成信息传递解决方案.
  • Designed, implemented, 维护不同类型的数据库管理系统(dbms), 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, 如Oracle企业资源规划(ERP), SAP, 与顾客忠诚度管理(CLM).
  • 参与设计和实现一个数据仓库, data marts for analysis, data mining projects, 以及对现有BI系统实施变更.
  • 使用SSIS工具从各种资源中收集数据, 按照数据整理周期存储和交付清理后的数据以供数据分析, 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. 发票生成时间从6小时减少到20分钟.
  • Identified the key reports and dashboards to satisfy the client’s requirements and developed different kinds of reports like parameterized reports, ad hoc reports, 以及使用SSRS和Power BI向下钻取和钻取报告.
  • Troubleshoot data issues, 分析和纠正错误和性能日志, made backup routines, 准备系统部署和升级. Trained various business unit teams on the effective use of processes, tools, and resources.
Technologies: Azure SQL, C#, C#.. NET,数据库,数据工程,数据分析,敏捷, SQL Server报表服务(SSRS), SQL Server集成服务(SSIS), Microsoft Power BI, Qlik Sense, Oracle, PL/SQL, T-SQL (Transact-SQL), Microsoft SQL Server, PostgreSQL, Python

Full-stack Developer

2012 - 2014
MDC (Management Development Center)
  • 参与了Rhazes解决方案的开发,包括所有的医疗, 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.
技术:活动服务器页面(ASP), ASP.. NET、Windows服务、Web服务, Crystal Reports, SQL, Microsoft SQL Server, HTML, CSS, C#

Teaching Assistant

2012 - 2014
北京科技大学
  • 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.
  • 与计算机科学领域的变化和发展保持同步.
Technologies: c#, c++,数据结构,操作系统,教育,通信, University Teaching, Algorithms, Applied Mathematics, Statistics, Databases

ADNOC Smart Wallet

http://smart.adnocdistribution.ae/
ADNOC分销公司是阿联酋领先的零售加油站运营商. ADNOC钱包使ADNOC加油站支付快捷方便. 它是完全安全的,并跟踪ADNOC加油站的日常支出. 它包括加油、购物、更换润滑油和洗车. 此外,客户可以在一个账户中注册多辆车或受益人.

I was the software engineer who participated in and developed all objects related to the data area, 包括触发器等数据库, stored procedures, jobs, data warehouse, pipelines, and reporting. 我创建了一套系统,包括以下内容:

•卡片管理系统(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, 以及个性化智能卡的卡片打印系统, vehicle depot system, and invoicing.

Emarat石油公司加油站管理服务

http://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. 在这个项目中,我做了以下工作:

• Implementing and customizing a turnkey solution to meet the company's station management and retail services needs.
•参与系统需求收集和分析阶段.
• Analyzing and compiling components needed for data migration and integration with various systems, such as Oracle ERP, NCR, and NAMOS.
•开发数据迁移工作流,将数据迁移到使用SSIS的新系统.
•建立差异化定价体系和NCR折扣.
•使用SSRS和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. 我执行了需求分析, 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, 与Oracle ERP和NCR系统的数据集成, in addition to building modules related to managing users permissions and system setting and data backup routines.

科威特数字油田项目

我在科威特参与了第一个数字油田(DOF)项目, using Petroleum Experts (PETEX) technology to enhance the oil well production and operations by providing frameworks and dashboards for decision-makers. 我是PETEX解决方案的一线支持人员, 协助石油工程师进行日常作业, 监督数据问题的故障排除, 并帮助用户解释和理解报告数据. 我使用以下软件解决方案:集成可视化管理(IVM), 集成生产模型(IPM), IFM, PROSPER, and Model Catalogue.

科威特国民警卫队的舰队管理

这个web应用程序管理所有科威特国民警卫队的车队操作. As a software engineer, I oversaw gathering requirements, analyzing the client's needs, 并为团队提供详细的设计文件. 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

http://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条记录,这些记录具有描述乘车的属性, 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是一个幽默的推特账号,用评论给狗打分. 我从不同的资源收集数据, such as ZIP and CSV files, 并查询Twitter API来获取数据.

Languages

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

Storage

Databases, SQL Server报表服务(SSRS), PL/SQL, PL/SQL Developer, Oracle PL/SQL, SQL Server集成服务(SSIS), PostgreSQL, NoSQL, MongoDB, Azure SQL, Microsoft SQL Server, HBase, Apache Hive, Database Administration (DBA), Database Modeling, SQL Server分析服务(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, 多维表达式(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通信框架(WCF), Hadoop, Spark, ASP.NET

Platforms

Oracle, Apache Kafka

2008 - 2012

计算机科学学士学位

埃及吉萨科技大学

MARCH 2021 - PRESENT

大数据的Spark和Python

Udemy

NOVEMBER 2020 - PRESENT

HCIA-Big Data Course

Huawei Academy

JULY 2020 - PRESENT

AWS Machine Learning

Udacity

MAY 2020 - PRESENT

数据分析专业纳米学位课程

Udacity

MAY 2020 - PRESENT

Data Engineer with Python

DataCamp

FEBRUARY 2020 - PRESENT

MongoDB Basics

MongoDB University

JANUARY 2020 - PRESENT

数据分析高级纳米学位课程

Udacity

AUGUST 2019 - PRESENT

职业轨迹数据分析师与SQL Server

DataCamp

MARCH 2019 - PRESENT

Big Data Introduction Course

Coursera

JUNE 2017 - JUNE 2020

MCPS:微软认证专家

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

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2

Choose your talent

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

开始你的无风险人才试验

与你选择的人才一起工作,试用最多两周. 只有当你决定雇佣他们时才付钱.

Top talent is in high demand.

Start hiring