Wagdy El-Sherbiny

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

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

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.
•参与系统需求收集和分析阶段.
• 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开发各种报告和仪表板.

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)是科威特的国家炼油公司. 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解决方案的一线支持人员, 协助石油工程师进行日常作业, overseeing troubleshooting data issues, 并帮助用户解释和理解报告数据. 我使用以下软件解决方案:集成可视化管理(IVM), Integrated Production Modeling (IPM), IFM, PROSPER, and Model Catalogue.

这个web应用程序管理所有科威特国民警卫队的车队操作. 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 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.

I illustrated the steps and procedures used for wrangling a real-world dataset known as WeRateDogs. WeRateDogs是一个幽默的推特账号，用评论给狗打分. I collected data from different resources, such as ZIP and CSV files, and queried the Twitter API to fetch data.