Ghassan Elnemr, Data Migration Developer in Beirut, Beirut Governorate, Lebanon
Ghassan Elnemr

Data Migration Developer in Beirut, Beirut Governorate, Lebanon

Member since July 8, 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.
Ghassan is now available for hire

Portfolio

Experience

Location

Beirut, Beirut Governorate, Lebanon

Availability

Part-time

Preferred Environment

SQL, APIs, C++, Microsoft SQL Server, C, MySQL, Node.js

The most amazing...

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

Employment

  • Data Engineer

    2021 - 2021
    Toptal Client (Medical Online Education)
    • 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
  • 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, Arduino, Node.js, NoSQL, Data Engineering, Databases, Disaster Recovery Plans (DRP)
  • 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 Development, ETL Implementation & Design, Content Management Systems (CMS), Python, Linux, MSSQLCE, Web Server Development, Firewalls, Security, Networking, Databases, Web Development
  • Web Site 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
  • 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, SugarCRM, 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 Development, ETL Implementation & Design, Agile, XMPP, Windows Presentation Foundation (WPF), 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, JasperReports, JSF, 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), Public Health, GIS, Microsoft SQL Server, C#, VB.NET

Experience

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

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

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

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

Skills

  • Languages

    C, C++, C#, XML, Java, VB.NET, SQL, JavaScript, T-SQL, Excel VBA, Python, Visual Basic for Applications (VBA)
  • Libraries/APIs

    Node.js, React
  • Tools

    Crystal Reports, Tableau, Microsoft Excel, Microsoft Access, Apache Airflow, BigQuery, Looker, Erwin, Excel 2013, Microsoft Power BI
  • Paradigms

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

    Linux, Arduino, Oracle
  • 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, Data Lakes, AWS DynamoDB, Database Replication, Redshift
  • 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, 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, Computer Engineering, Tableau Server, Network Design, Information Security Management Systems (ISMS), Compliance, ISAM
  • Frameworks

    .NET 4

Education

  • Ph.D. in Software Engineering
    1991 - 1996
    INSA Lyon - Lyon, France
  • Master's Degree in Software Engineering
    1990 - 1991
    INSA Lyon - Lyon, France

Certifications

  • Toptal React Academy Graduate
    OCTOBER 2021 - PRESENT
    Toptal, LLC

To view more profiles

Join Toptal
Share it with others