
Ghassan Elnemr
Verified Expert in Engineering
Software Developer
Beirut, Beirut Governorate, Lebanon
Toptal member since November 19, 2020
Ghassan is a software engineer with expertise in AWS cloud architecture, Python development, and database engineering. He designs scalable solutions using RDS, Redshift, Lambda, and DynamoDB, and builds dashboards with Power BI and Tableau. He integrates SQL-driven pipelines, machine learning models, and Git-based workflows using GitHub and GitLab to deliver secure, data-driven applications.
Portfolio
Experience
- SQL - 20 years
- Python - 7 years
- BigQuery - 5 years
- ETL Implementation & Design - 5 years
- AWS IoT - 4 years
- Dashboard Development - 4 years
- Looker - 3 years
- Microsoft Power BI - 2 years
Preferred Environment
SQL, Amazon Web Services (AWS), Google BigQuery, Redshift, PostgreSQL, Amazon Athena, Amazon RDS, Python, Claude, Artificial Intelligence (AI)
The most amazing...
...thing I've built is a serverless Amazon Athena analytics system with Python and dashboards, which reduces reporting time from hours to seconds.
Work Experience
Database Developer
ProStrategy-Colman LTD
- Reverse-engineered the MS SQL stored procedures stored in the Azure SQL Database.
- Translated to PostgreSQL stored procedures the MS SQL data tables, views, and stored procedures.
- Optimized the pipelines to pull the data and create new snapshots.
- Used Azure Scrum boards for task management and GitHub for code management, including PRs/Pulls, merges, and conflict resolution.
Senior Developer
That's Mine Pty Ltd
- Created an interface to pull data from the Spotify website and migrated pages from BigCommerce to Spotify.
- Reverse-engineered the legacy MS Access database and adjusted VBA scripts.
- Added new tables and views to integrate with Spotify.
Power BI Engineer
Rootz Research LLC
- Maintained the existing platform and reverse-engineered the developed dashboard.
- Tracked and fixed reports with the existing Power BI report.
- Added DAX formulas, imported data, and cleaned data.
Data Engineer
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.
Database Developer
Local Muscle LLC
- Visualized the data using Power BI, adjusted existing reports, created links between reports, and added new reports.
- Adjusted formulas created with DAX, corrected errors, and enhanced with new user requirements.
- Built reports using Power BI, created an extension showing the data as a cube, using a Python extension.
Data Engineer
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.
IT Project Manager
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.
IT Manager | Senior Developer
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 into a new school management system. Deployed and maintained the MS SQL 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's software to a new solution. Fulfilled the role of IT administrator and supervised the activities of data visualization reports and editing.
Website Developer
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.
Senior Software Engineer
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.
Team Leader
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.
Senior Software Developer
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.
Technical Leader
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.
Experience
Automation Engineer
Toptal React Academy
IoT Project: Heat Monitor for Server Rooms
https://github.com/GenericSystems/ghassanData Clean-up for Marketing Department
MySQL – MS SQL Synchronization
Data Merge and Consolidation
iOT Projects Teaching
Excel VBA
Data Center Design
Pharmaceutical Database
Blood Transfer Management
Statistics Dashboards for a NGO
Education
PhD in Software Engineering
INSA Lyon - Lyon, France
Master's Degree in Software Engineering
INSA Lyon - Lyon, France
Certifications
Toptal React Academy Graduate
Toptal, LLC
Skills
Libraries/APIs
Node.js, API Development, Pandas, PySpark, React, Puppeteer, Social APIs
Tools
Crystal Reports, Tableau, Microsoft Excel, Microsoft Access, Apache Airflow, BigQuery, Looker, Microsoft Power BI, AWS Glue, AWS Command Line Interface (CLI), Power Query, Erwin, Excel 2013, Google Analytics, Amazon Athena, Mathematica, GitHub, GitLab CI/CD, GitLab, Jira, Zephyr, n8n, AWS Step Functions, Claude
Languages
C, Python, C++, C#, XML, Java, VB.NET, SQL, JavaScript, Transact-SQL (T-SQL), Excel VBA, Python 3, YAML, Visual Basic for Applications (VBA), Snowflake, HTML, JavaScript 6
Paradigms
Database Design, ETL Implementation & Design, ETL, Database Development, Object-relational Mapping (ORM), Business Intelligence (BI), Agile, Automation, REST, Test Automation
Platforms
Linux, Amazon Web Services (AWS), Oracle, AWS Lambda, AWS IoT, Docker, Azure, Arduino, BigCommerce, Google Cloud Platform (GCP)
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, Database Administration (DBA), Amazon DynamoDB, Database Replication, Redshift, Amazon S3 (AWS S3), Database Migration, Oracle 11g, On-premise
Frameworks
.NET 4, Apache Spark
Industry Expertise
Accounting
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, Web Scraping, Scripting, 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, Dashboard Development, Data Build Tool (dbt), Database Optimization, Data Quality, Computer Engineering, Tableau Server, Network Design, Information Security Management Systems (ISMS), Compliance, ISAM, Dashboards, Branding, 2D Visualization, Finance, Fintech, Internet of Things (IoT), Machine Learning, Amazon RDS, API Integration, Documentation, Spotify, Zoho Mail, Fivetran, QA Automation, Test Automation Frameworks, Financial Systems, Firewalls, Networks, Infrastructure, Database Schema Design, CI/CD Pipelines, Looker Studio, ELT, Scraping, Data Scraping, Browser Automation
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring