Ghassan is available for hire
Hire GhassanGhassan 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. 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
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
Experience
IOT Project: Heat Monitor for Server Rooms
https://github.com/GenericSystems/ghassanA 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.
Skills
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
Education
1991 - 1996
Ph.D. in Software Engineering
INSA Lyon - Lyon, France
1990 - 1991
Master's Degree in Software Engineering
INSA Lyon - Lyon, France
Certifications
OCTOBER 2021 - PRESENT
Toptal React Academy Graduate
Toptal, LLC