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, 包括设计和实现, 他管理过软件项目,并为重要客户工作过, 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
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, 按产量计算,它是世界第12大石油公司.
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.
- 领导中型项目从范围定义到执行和实施.
- 与跨职能团队合作解决问题, 确定适当的数据源, 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.
Full-stack Developer
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.
Teaching Assistant
北京科技大学
- 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.
- 与计算机科学领域的变化和发展保持同步.
Experience
ADNOC Smart Wallet
http://smart.adnocdistribution.ae/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• 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
KNPC Petrol Filling Stations
科威特数字油田项目
科威特国民警卫队的舰队管理
The Ford GoBike System
http://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报表服务(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
Education
计算机科学学士学位
埃及吉萨科技大学
Certifications
大数据的Spark和Python
Udemy
HCIA-Big Data Course
Huawei Academy
AWS Machine Learning
Udacity
数据分析专业纳米学位课程
Udacity
Data Engineer with Python
DataCamp
MongoDB Basics
MongoDB University
数据分析高级纳米学位课程
Udacity
职业轨迹数据分析师与SQL Server
DataCamp
Big Data Introduction Course
Coursera
MCPS:微软认证专家
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
开始你的无风险人才试验
Top talent is in high demand.
Start hiring