Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nabil Karam

3610 Andre-Du-Bouchet, Laval,Quebec

Summary

Data architect and data engineering lead with 20+ years of experience in architecting and developing technical solutions. Expertise in Bigdata, Singlestore (Memsql), Greenplum, Db2, Python, Unix Shell Scripts, and Kafka pipelines. Excels in designing efficient data models and leading data pipeline integrations.

Overview

29
29
years of professional experience

Work History

Data Engineering Lead

Morgan Stanley
05.2015 - 12.2024
  • Developed database ETLs and reports for big data applications monitoring low-latency trading for equities and FX
  • Created interactive reports in Jupyter Notebook using Pandas, NumPy, NetworkX, and PyVis
  • Led efforts to build data pipelines, integrating various data sources into the Singlestore database
  • Led architecture and DBA tasks for Singlestore database at Morgan Stanley
  • Designed efficient data models, benefiting the overall system performance
  • Performed DBA tasks for both Singlestore and Greenplum databases
  • Developed a compression algorithm for the Greenplum database, reducing data storage size by 30%

IT Consultant: SQL Server DBA

IBM
07.2012 - 05.2015
  • Physical DBA support for Bank of Nova Scotia
  • Administered SQL Server databases
  • Tasks included creating new instances, clustering, mirroring, tuning, performance monitoring, managing indexes and locks, backup and restore and upgrades
  • Migrated SQL2005 instances to SQL2012
  • Migrated the local sql server backups to Tivoli Storage Manager (TDP)
  • Applied security healthchecks on the databases

IT Consultant: Integration Functional Analyst / Developer

Aveos
01.2011 - 05.2012
  • Integration Analyst and Developer for the migration to a new ERP at Aveos
  • Aveos (formerly Air Canada Technical Services) specializes in aircraft maintenance and repair
  • Created functional analysis documents to integrate applications (shop planning and supply chain) to the new Ramco ERP
  • Designed a deployment strategy for the ETL processes, jobs, applications and databases
  • Developed the back-end changes to integrate the applications with Ramco ERP using T-SQL, Stored Procedures, Triggers, SSIS and SSRS

DBA / Application support

IBM
05.2006 - 01.2011
  • Database Administration, programming and application support for National Bank Financial and Bank of Nova Scotia
  • Administered Sybase, SQL Server & DB2 databases for financial trading applications and for reports
  • Tasks included tuning, performance monitoring, managing indexes and locks, backup and restore, upgrades and db reorganization
  • Initiated and supervised Root Cause Analysis efforts for major problems
  • Developed new scripts to automate DBA tasks
  • Created new enhancements to the production deployment scripts and to the job scheduling systems using Perl, Python, Shell Prog and Tivoli

Software Consultant

Air Canada
05.2005 - 05.2006
  • Analysis and programming for modifications in the invoicing and accounting applications of the Netair product
  • Designed and implemented the database changes to setup the replication between two Informix databases on two servers
  • Designed and programmed the new changes for the invoicing and accounting applications

Senior Software Engineer

Eckerd Corporation
11.2002 - 05.2005
  • Analysis, design, programming and support for a variety of Pharmacy applications
  • Designed, programmed and implemented new applications and features for the online prescription refill at Eckerd.com using Java, SQL Server, and Websphere Application Server
  • Supported and programmed fixes for pharmacy applications running at the retail store servers and at the production servers using C, Java, Korn Shell Prog, Perl, PHP, DB2, Informix and Oracle

Senior Software Engineer

Lucent Technologies
06.1998 - 11.2002
  • Analysis, design and programming for the Lucent Internet Call Diversion (ICD) solution
  • ICD diverts dial-up Internet traffic from the local switches of Public Switched Telephone Network (PSTN) directly to the Internet Protocol (IP) network
  • Designed and developed the user interface to configure the ICD and to monitor the dial-up calls using Java, C/C++, Perl and Oracle
  • Designed and implemented database schemas using TimesTen in-memory database to configure and monitor the ICD

Software Engineer

Air Canada
01.1996 - 06.1998
  • Analysis and programming for the reservation system of flights and vacation packages
  • Design and programming in C for the display inventory, pricing and shopping modules
  • Created reports using Stored Procedures and Triggers to track the performance of the reservation agents and products

Education

Bachelor of Science - Electrical Engineering (BSEE), Telecommunications

Ecole Polytechnique De Montreal
Montreal, QC
1996

Skills

  • Databases
  • Sql
  • Singlestore (Memsql)
  • Greenplum
  • Sql Server
  • Oracle
  • Db2
  • Sybase
  • Programming Languages
  • Python
  • Unix Shell Scripts
  • Perl
  • C/C
  • Java

Timeline

Data Engineering Lead

Morgan Stanley
05.2015 - 12.2024

IT Consultant: SQL Server DBA

IBM
07.2012 - 05.2015

IT Consultant: Integration Functional Analyst / Developer

Aveos
01.2011 - 05.2012

DBA / Application support

IBM
05.2006 - 01.2011

Software Consultant

Air Canada
05.2005 - 05.2006

Senior Software Engineer

Eckerd Corporation
11.2002 - 05.2005

Senior Software Engineer

Lucent Technologies
06.1998 - 11.2002

Software Engineer

Air Canada
01.1996 - 06.1998

Bachelor of Science - Electrical Engineering (BSEE), Telecommunications

Ecole Polytechnique De Montreal
Nabil Karam