Ghassan Elnemr, Developer in Beirut, Lebanon
Ghassan is available for hire
Hire Ghassan

Ghassan Elnemr

Verified Expert  in Engineering

Software Developer

Location
Beirut, Lebanon
Toptal Member Since
November 19, 2020

Ghassan is an experienced information technology professional with a Ph.D. in software engineering and expertise in networking and software development. 他设计了一个高密度接入点网络，将系统划分为许多vlan，以检测网络攻击，并开发了一个节点.. js、Arduino和基于mongodb的产品来监控服务器机房的温度. Ghassan is skilled in app, web, and database development and React, IoT, Linux, and Microsoft SQL Server projects.

WebsitesWeb DevelopmentData MigrationData EngineeringData VisualizationExcel ReportingData AnalysisLinuxSQLDatabase DevelopmentMySQLCMicrosoft SQL ServerJavaVB.NETCrystal ReportsExcel MacroVeeam

Portfolio

Addenda Holdings Ltd
Data Engineering, Business Intelligence (BI), MongoDB, Data Warehousing...
Sketchy
Looker, Google BigQuery, PostgreSQL, SQL, JSON, Data, Google Cloud...
Ibdaa MicroFinance
Oracle, MongoDB, Node.js, NoSQL, Data Engineering, Databases...

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...

...我开发的项目是一个基于XML和基于XML脚本的数据库存储的基于反射的WPF/ c#服务器.

Work Experience

Data Engineer

2022 - 2022
Addenda Holdings Ltd
  • 创建了一个基于Apache Airflow、AWS S3、AWS Athena、redshift和Tableau的数据仓库.
  • Designed a solution for ETL based on Fivetran and Bigquery.
  • 实现BigQuery下的数据仓库，使用Tableau构建主报表.
Technologies: Data Engineering, Business Intelligence (BI), MongoDB, Data Warehousing, 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
  • 使用Looker和BigQuery开发财务报告，并在Looker下构建动态仪表板.
  • Cleaned the data from cloud sources and synchronized the database with BigQuery. Written BigQuery views were to be included in Looker.
  • Migrated data from PostgreSQL to the cloud, filtered and merged the data within remote PostgreSQL servers, and the BigQuery database.
技术:Looker, Google BigQuery, PostgreSQL, SQL, JSON, Data, Google Cloud, Data Visualization

IT Project Manager

2019 - 2020
Ibdaa MicroFinance
  • Developed an app that monitors the server room. The application was written from scratch using Node.js, MongoDB, and Arduino.
  • Designed and developed a prototype for fintech solutions based on Oracle, Node.js, Angular, and Ionic.
  • 构建了一个应用程序，使用SNMP和Node收集远程打印机的状态和计数器.js, then communicates the collected data to an external supplier.
  • Managed the IT department, including a team of three, one database developer and two technical IT resources. 监督数据维护和提取，以及构建与第三方的新集成.
Technologies: Oracle, MongoDB, Node.. js、NoSQL、数据工程、数据库、灾难恢复计划(DRP)、Microsoft Power BI

IT Manager | Senior Developer

2013 - 2018
Wellspring Learning Community
  • Developed and maintained the web server and web content. Used DNN, HTML, JavaScript, CSS, Bootstrap and integrated them with a third-party school mobile application.
  • Prepared the data collected from various sources, including Excel, Textual, and custom applications, and imported it to a new school management system. Deployed and maintained the MSSQL 2012 database server.
  • 设计、安装、配置、监控和优化高密度接入点网络. 在Linux路由器上用Python编写程序，将网络划分为多个vlan，并检测中毒和网络攻击.
  • 管理由三个IT资源和一个开发人员组成的团队，将机构软件转换为新的解决方案. 履行IT管理员职责，监督数据可视化报表和编辑活动.
技术:Visual Basic for Applications (VBA)， Excel VBA, ETL, ETL实现 & Design, Python, Linux, Databases, Web Development

Website Developer

2016 - 2017
ALLC International House Beirut
  • Created the website according to specifications.
  • 将存储在Microsoft Access中的数据导入网站，并将网站链接到Microsoft Access数据库.
  • 修改了使用Microsoft Access编写的会计应用程序，并在客户端部分添加了一个web界面，以便用户可以输入他们的个人信息.
Technologies: Microsoft Access, C#, .NET 4, JavaScript

Senior Software Engineer

2012 - 2013
Aheeva
  • 为Asterisk呼叫路由、IP电话交换和VOIP协议开发脚本.
  • Modified, wrote, and debugged the existing core Linux and C libraries.
  • Coded a data bridge with SugarCRM. 通过SQL查询优化改进报表，开发呼叫中心聊天模块.
Technologies: C++, Linux, Crystal Reports

Team Leader

2011 - 2013
SPU
  • Analyzed the information system and wrote system requirements. Used UML to manage the analysis and design of the built software. Applied a value-driven, agile approach and created and maintained project plans using Microsoft Project.
  • Normalized the data from different departments and faculties, including data merging, filtering, pre-processing, and data mining of faculties data under Microsoft SQL Server.
  • 使用c#和反射技术开发了一个分布式大学管理系统的核心部分. Enhanced the graphical library by adding XML support to graphical windows.
  • 设计解决方案，并作为技术负责人负责软件设计和交付. 监督一个由五名开发人员和一名测试人员组成的团队从零开始构建UMS.
Technologies: ETL, ETL Implementation & Design, Agile, Microsoft SQL Server, XML, C#, Web Development

Senior Software Developer

2005 - 2006
Timeware
  • Implemented Java Server Faces (JSF) components using JBuilder and Tomcat.
  • Wrote dynamic school solution web pages using Java Servlets (JSP) scripts.
  • Created and maintained a new customized branch of JasperReports. Developed and optimized the reporting module of Timeware's solution.
Technologies: Linux, MySQL, Java

Technical Leader

2000 - 2005
Positron Public Safety Systems
  • Rewrote the dispatching software with C# and ComponentOne. 集成了GIS在调度软件中的应用，实现了一种基于多准则的高性能资源搜索算法.
  • Deployed a call center full solution and documented the processes. 使用增量开发模型来满足额外的客户需求. Led the testing team and assisted the QA team.
  • Developed plugins to link the third-party API. Linked the call-taking system to a legacy mainframe telecommunication system. Wrote extended MSSQL-stored procedures for integration.
  • 扩展了CAD服务器，并采用N-Ary树算法对推荐算法进行了优化.
  • 担任18人定制开发团队的技术总监，提出并开发公共安全资源调度解决方案. Deployed the solution in the city of Pamplona in the province of Navarra, Spain.
Technologies: ETL, Quality Assurance (QA), Microsoft SQL Server, C#, VB.NET

IOT Project: Heat Monitor for Server Rooms

http://github.com/GenericSystems/ghassan
A Node.. js、Arduino和基于mongodb的项目，用于监控服务器机房的温度. I designed the solution, configured the Arduino card and sensors, and calibrated and connected the components.

Data Clean-up for Marketing Department

一个数据库应用程序，由一组脚本组成，用于从两个Oracle数据库提取数据到合并的MSSQL数据库和PostgreSQL数据库. Data is cleaned through T-SQL stored procedures, then exported to a CSV set of files to be integrated in an external CRM.

MySQL <-> MSSQL Synchronization

该项目包括两个远程安装之间的完全实时同步，一端在Windows下运行MSSQL，另一端在MySQL上运行. 数据模型通过属于不同系统的记录之间的实时匹配进行检查和修改，其中MySQL中的事务转换为MSSQL中的一组事务.

Data Merge and Consolidation

An application that collects school data from different excel files, PostgreSQL and MySQL and consolidate them into a normalized model. 模型与一个新的软件数据库相匹配，学校可以将历史数据导入新系统.

IOT Projects Teaching

While teaching at the Lebanese University, I initiated my student in Business Intelligence and Tableau software. 学生可以从传感器提供的多个数据源中提取数据，并使用Tableau分析数据，提出建议. Data is stored in a PostgreSQL database on-premises.

Excel VBA

An Excel-VBA program that collects data from a MySQL database, fills datasheets and offers sending notifications via SMS to clients. Notifications are based on calculations made on Excel. The sending by email with graphs to partner companies is automatized.

Data Center Design

Design and implementation of a data center for Ewallet/fintech solution. This includes defining the components of the head office server room, networking connections, security considerations, and disaster recovery site.

Pharmaceutical Database

A database based on C++ and ISAM sequential files, indexed through a home-made algorithm to encrypt and manage medication data, and calculate the interactions of a prescription, taking into consideration the profile of the patient.

Blood Transfer Management

该应用程序通过RS232连接雅培血液分析阅读器，通过血液分析为献血者和患者检测疾病. The application collects the readings, stores data in databases, and applies procedures to determine if a blood unit is safe.

Toptal React Academy

Toptal React学院是一个独家学习计划，教React框架选择Toptal网络的成员. After a month of study, 所有毕业生的任务是完成30-40小时的期末项目，从头开始构建和交付React应用程序.

Statistics Dashboards for a NGO

由一组可视化报告组成的应用程序，在PowerBi下开发，用于分析与黎巴嫩难民有关的数据. 该申请旨在保护最弱势群体，并为遭受骚扰和袭击的妇女和儿童提供援助.

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

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

Paradigms

Database Design, ETL Implementation & Design, ETL, Database Development, Object-relational Mapping (ORM), Business Intelligence (BI), Agile, Automation

Platforms

Linux, Oracle, AWS Lambda, Amazon Web Services (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)

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, Information Security Management Systems (ISMS), Compliance, ISAM

Frameworks

.NET 4

1991 - 1996

Ph.D. in Software Engineering

INSA Lyon - Lyon, France

1990 - 1991

Master's Degree in Software Engineering

INSA Lyon - Lyon, France

OCTOBER 2021 - PRESENT

Toptal React Academy Graduate

Toptal, LLC

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

1

Share your needs

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

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring