Ghassan Elnemr，黎巴嫩贝鲁特的开发者
Ghassan is available for hire
Hire Ghassan

Ghassan Elnemr

Verified Expert  in Engineering

Software Developer

Location
Beirut, Lebanon
Toptal Member Since
November 19, 2020

加桑是一位经验丰富的信息技术专业人士，拥有博士学位.D. 在软件工程和网络和软件开发方面的专业知识. He designed a network of high-density access points that segmented the system into many VLANS to detect cyber attacks and developed a Node.js, Arduino, and MongoDB-based product to monitor the temperature in server rooms. Ghassan is skilled in app, web, 数据库开发和React, IoT, Linux, and Microsoft SQL Server projects.

WebsitesWeb DevelopmentData MigrationData EngineeringData VisualizationExcel ReportingData AnalysisLinuxSQLDatabase DevelopmentMySQLCMicrosoft SQL ServerJavaVB.NETExcel MacroCrystal ReportsVeeam

Portfolio

Addenda Holdings Ltd
数据工程，商业智能，MongoDB，数据仓库...
Sketchy
Looker, Google BigQuery, PostgreSQL, SQL, JSON, Data, Google Cloud...
Ibdaa MicroFinance
Oracle, MongoDB, Node.js, NoSQL，数据工程，数据库...

Experience

SQL - 20 yearsDatabase Design - 10 yearsJavaScript - 10 yearsSQL Server 2012 - 6 yearsData Migration - 6 yearsC++ - 5 yearsETL - 5 yearsExcel Reporting - 3 years

Availability

Part-time

Preferred Environment

SQL, MySQL, Node.js, Amazon Web Services (AWS), Google BigQuery, Linux, Apache Airflow, Web Services, Redshift, PostgreSQL

The most amazing...

...project I've developed was a reflection-based WPF/C# server based on XML and database storage of XML-based scripts.

Work Experience

Data Engineer

2022 - 2022
Addenda Holdings Ltd
  • Created a data warehouse based on Apache Airflow, AWS S3, AWS Athena, redshift, and Tableau.
  • 设计了一个基于Fivetran和Bigquery的ETL解决方案.
  • Implemented the data warehouse under BigQuery and built main reports using Tableau.
Technologies: 数据工程，商业智能，MongoDB，数据仓库, Data Architecture, Google Analytics, Snowflake, Tableau, Amazon S3 (AWS S3), Amazon Athena, AWS Glue, AWS Lambda, Apache Airflow, Python, JSON, Elasticsearch, DAX, Power Query, Data Visualization

Data Engineer

2021 - 2021
Sketchy
  • Developed financial reports using Looker and BigQuery and built dynamic dashboards under Looker.
  • 清理来自云端的数据，并使用BigQuery同步数据库. 写入的BigQuery视图将包含在Looker中.
  • 将数据从PostgreSQL迁移到云端, 过滤和合并远程PostgreSQL服务器中的数据, and the BigQuery database.
Technologies: Looker, Google BigQuery, PostgreSQL, SQL, JSON, Data, Google Cloud, Data Visualization

IT Project Manager

2019 - 2020
Ibdaa MicroFinance
  • 开发了一个监控服务器机房的应用程序. 该应用程序是使用Node从头编写的.js, MongoDB, and Arduino.
  • 设计并开发了基于Oracle、Node的金融科技解决方案原型.js, Angular, and Ionic.
  • Built an app that collects the remote printer's status and counters using SNMP and Node.Js，然后将收集到的数据传递给外部供应商.
  • Managed the IT department, including a team of three, 一个数据库开发人员和两个技术IT资源. Supervised the data maintenance and extraction as well as constructing the new integrations with third parties.
技术:Oracle, MongoDB, Node.js, NoSQL，数据工程，数据库, Disaster Recovery Plans (DRP), Microsoft Power BI

IT Manager | Senior Developer

2013 - 2018
Wellspring Learning Community
  • 开发和维护web服务器和web内容. Used DNN, HTML, JavaScript, CSS, Bootstrap并将其与第三方学校移动应用程序集成.
  • 准备从各种来源收集的数据, including Excel, Textual, and custom applications, 并将其引入新的学校管理系统. 部署和维护MSSQL 2012数据库服务器.
  • Designed, installed, configured, monitored, and optimized a network of high-density access points. Wrote programs with Python on Linux routers to segment the network into many VLANS and detected poisoning and cyber attacks.
  • Managed the team of three IT resources and one developer to switch the institution software to a new solution. Fulfilled the role of IT administrator and supervised the activities of data visualization reports and editing.
Technologies: Visual Basic for Applications (VBA), Excel VBA, ETL, ETL Implementation & 设计，Python, Linux，数据库，Web开发

Website Developer

2016 - 2017
ALLC International House Beirut
  • 根据规范创建网站.
  • Imported data stored in Microsoft Access into the website and linked the website to the Microsoft access database.
  • Modified the accounting application written with Microsoft Access and added a web interface to the client portion so users may enter their personal information.
技术:Microsoft Access, c#， .NET 4, JavaScript

Senior Software Engineer

2012 - 2013
Aheeva
  • Developed scripts for Asterisk call routing, IP telephony switching, and VOIP protocols.
  • 修改、编写和调试现有的核心Linux和C库.
  • Coded a data bridge with SugarCRM. Improved reporting by SQL query optimization and developed the chat module for call centers.
技术:c++， Linux, Crystal Reports

Team Leader

2011 - 2013
SPU
  • 分析信息系统，编写系统需求. 使用UML对构建的软件进行分析和设计管理. Applied a value-driven, 使用Microsoft project创建和维护项目计划.
  • 对不同院系的数据进行规范化处理, including data merging, filtering, pre-processing, 在Microsoft SQL Server下对院系数据进行数据挖掘.
  • Developed the core of a distributed university management system using C# and reflection. 通过向图形窗口添加XML支持增强了图形库.
  • Designed the solution and act as the technical leader in charge of the software design and delivery. Supervised a team of five developers and one tester to build the UMS from scratch.
技术:ETL, ETL实现 & 设计，敏捷，Microsoft SQL Server, XML, c#， Web开发

Senior Software Developer

2005 - 2006
Timeware
  • 使用JBuilder和Tomcat实现Java Server Faces (JSF)组件.
  • 使用Java servlet (JSP)脚本编写动态学校解决方案网页.
  • 创建并维护JasperReports的一个新的定制分支. 开发和优化Timeware解决方案的报告模块.
Technologies: Linux, MySQL, Java

Technical Leader

2000 - 2005
Positron Public Safety Systems
  • 用c#和ComponentOne重新编写调度软件. Integrated the GIS application in the dispatching software and implemented a high-performance search algorithm of resources based on multi-criteria.
  • 部署呼叫中心完整解决方案并记录流程. Used the incremental development model to serve additional customer requirements. 领导测试团队，协助QA团队.
  • 开发链接第三方API的插件. 将呼叫接收系统连接到遗留的主机电信系统. 编写扩展的mssql存储过程进行集成.
  • Extended the CAD server and optimized the recommendation algorithms using N-Ary tree algorithms.
  • Acted as the technical director of the custom development team of 18 developers to propose and develop a solution for public safety resources dispatching. 在西班牙纳瓦拉省的潘普洛纳市部署了该解决方案.
技术:ETL，质量保证(QA)， Microsoft SQL Server, c#， VB.NET

物联网项目:服务器机房热监控器

http://github.com/GenericSystems/ghassan
A Node.js, Arduino, and MongoDB-based project to monitor the temperature in a server room. I designed the solution, 配置Arduino卡和传感器, 并校准和连接组件.

市场部数据清理

A database application consisting of a set of scripts that extracts data from two Oracle databases to a consolidated MSSQL database and a PostgreSQL database. 数据是通过T-SQL存储过程清理的, 然后导出为CSV文件集，以便集成到外部CRM中.

MySQL <-> MSSQL Synchronization

The project consists of the full real-time synchronization between two remote installations running MSSQL under Windows on one side and MySQL on another. Data models were examined and modified with the real-time matching between records belonging to different systems where a transaction in MySQL is transformed into a set of transactions in MSSQL.

Data Merge and Consolidation

一个从不同的excel文件中收集学校数据的应用程序, PostgreSQL和MySQL整合成一个规范化的模型. Models are matched with a new software database that the school to import historical data into the new system.

IOT Projects Teaching

在黎巴嫩大学任教期间, 我开始学习商业智能和Tableau软件. Students could extract data from many sources fed by sensors and analyze the data using Tableau to make recommendations. 数据存储在本地的PostgreSQL数据库中.

Excel VBA

一个Excel-VBA程序，从MySQL数据库中收集数据, 填写数据表并提供通过短信向客户发送通知. 通知是基于在Excel上进行的计算. 通过电子邮件向合作伙伴公司发送图表是自动化的.

Data Center Design

电子钱包/金融科技解决方案数据中心的设计与实现. 这包括定义总部服务器室的组件, networking connections, security considerations, and disaster recovery site.

Pharmaceutical Database

一个基于c++和ISAM的数据库顺序文件, 通过自制算法索引，加密和管理药物数据, 并计算处方的相互作用, 考虑到病人的情况.

Blood Transfer Management

An application that connects to Abbott Blood Analysis readers through RS232 to detect diseases through blood analysis for donors and patients. 应用程序收集读数, stores data in databases, 并应用程序来确定血液单位是否安全.

Toptal React Academy

The Toptal React Academy is an exclusive learning program that teaches the React framework to select members of the Toptal network. After a month of study, all graduates are tasked with completing a 30-40 hour final project to build and deliver a React app from scratch.

Statistics Dashboards for a NGO

An application composed of a set of visualization reports developed under PowerBi to analyze the data relative to the refugees in Lebanon. The application aimed to protect the most vulnerable population and provide assistance to women and children who are victims of harassment and assaults.
1991 - 1996

Ph.D. in Software Engineering

INSA Lyon - Lyon, France

1990 - 1991

软件工程硕士学位

INSA Lyon - Lyon, France

OCTOBER 2021 - PRESENT

Toptal React Academy Graduate

Toptal, LLC

Libraries/APIs

Node.js, Pandas, React

Tools

Crystal Reports, Tableau, Microsoft Excel, Microsoft Access, Apache Airflow, BigQuery, Looker, Microsoft Power BI, AWS Glue, AWS CLI, Power Query, Erwin, Excel 2013, Google Analytics, Amazon Athena

Languages

C, Python, C++, C#, XML, Java, VB.NET, SQL, JavaScript, T-SQL (Transact-SQL), Excel VBA, Python 3, Visual Basic for Applications (VBA), Snowflake

Paradigms

数据库设计，ETL实现 & Design, ETL, Database Development, Object-relational Mapping (ORM), Business Intelligence (BI), Agile, Automation

Platforms

Linux、Oracle、AWS Lambda、亚马逊网络服务(AWS)

Storage

MySQL, MongoDB, Microsoft SQL Server, Database Modeling, NoSQL, Database Architecture, SQL Stored Procedures, SQL Server 2012, PostgreSQL, Data Pipelines, API Databases, Databases, SQL Server 2010, JSON, Data Lakes, Elasticsearch, Google Cloud, Amazon DynamoDB, Database Replication, Redshift, Amazon S3 (AWS S3)

Frameworks

.NET 4

Other

Software Development, Data Modeling, Data Architecture, CSV, Reporting, Excel Reporting, Data Migration, Data Engineering, Data Visualization, Data Analysis, Excel Macros, Disaster Recovery Plans (DRP), CSV File Processing, Reports, Websites, Web Development, Web Services, Data, Artificial Intelligence (AI), Google BigQuery, APIs, Quality Assurance (QA), Data Cleaning, Data Cleansing, Big Data, Complex Data Analysis, Data Analytics, Data Warehousing, Data Warehouse Design, OCR, Veeam, DAX, Computer Engineering, Tableau Server, Network Design, 资讯保安管理系统(ISMS), Compliance, ISAM

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

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

Top talent is in high demand.

Start hiring