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

Ghassan Elnemr

Verified Expert  in Engineering

Bio

Ghassan is an experienced information technology professional with a Ph.D. in software engineering and expertise in networking and software development. 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, and database development and React, IoT, Linux, and Microsoft SQL Server projects.

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 years
  • Database Design - 10 years
  • JavaScript - 10 years
  • SQL Server 2012 - 6 years
  • Data Migration - 6 years
  • C++ - 5 years
  • ETL - 5 years
  • Excel 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.
  • Designed a solution for ETL based on Fivetran and Bigquery.
  • Implemented the data warehouse under BigQuery and built main reports using 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
  • Developed financial reports using Looker and BigQuery and built dynamic dashboards under 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.
Technologies: 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.
  • Built an app that collects the remote printer's status and counters using SNMP and 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. Supervised the data maintenance and extraction as well as constructing the new integrations with third parties.
Technologies: Oracle, MongoDB, Node.js, NoSQL, Data Engineering, Databases, Disaster Recovery Plans (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.
  • 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 & Design, Python, Linux, Databases, Web Development

Website Developer

2016 - 2017
ALLC International House Beirut
  • Created the website according to specifications.
  • 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.
Technologies: Microsoft Access, C#, .NET 4, JavaScript

Senior Software Engineer

2012 - 2013
Aheeva
  • Developed scripts for Asterisk call routing, IP telephony switching, and VOIP protocols.
  • Modified, wrote, and debugged the existing core Linux and C libraries.
  • Coded a data bridge with SugarCRM. Improved reporting by SQL query optimization and developed the chat module for call centers.
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.
  • Developed the core of a distributed university management system using C# and reflection. Enhanced the graphical library by adding XML support to graphical windows.
  • 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.
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. Integrated the GIS application in the dispatching software and implemented a high-performance search algorithm of resources based on multi-criteria.
  • Deployed a call center full solution and documented the processes. Used the incremental development model to serve additional customer requirements. 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.
  • 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. 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

https://github.com/GenericSystems/ghassan
A Node.js, Arduino, and MongoDB-based project to monitor the temperature in a server room. I designed the solution, configured the Arduino card and sensors, and calibrated and connected the components.

Data Clean-up for Marketing Department

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

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

An application that collects school data from different excel files, PostgreSQL and MySQL and consolidate them into a normalized model. Models are matched with a new software database that the school to import historical data into the new system.

IOT Projects Teaching

While teaching at the Lebanese University, I initiated my student in Business Intelligence and Tableau software. Students could extract data from many sources fed by sensors and analyze the data using Tableau to make recommendations. 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

An application that connects to Abbott Blood Analysis readers through RS232 to detect diseases through blood analysis for donors and patients. The application collects the readings, stores data in databases, and applies procedures to determine if a blood unit is safe.

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

Master's Degree in Software Engineering

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

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)

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, Optical Character Recognition (OCR), Veeam, DAX, Computer Engineering, Tableau Server, Network Design, Information Security Management Systems (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

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