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, QC1996
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
Similar Profiles
VALARIE HUGHESVALARIE HUGHES
Wealth Management Associate, AVP at Morgan StanleyWealth Management Associate, AVP at Morgan Stanley
Raunak MotiwaleRaunak Motiwale
Associate, Syndicate Operations at Morgan StanleyAssociate, Syndicate Operations at Morgan Stanley
WILLIAM COOPER IIWILLIAM COOPER II
Financial Advisor at Morgan Stanley Wealth ManagementFinancial Advisor at Morgan Stanley Wealth Management
Punit AgarwalPunit Agarwal
Vice President at Morgan StanleyVice President at Morgan Stanley
Richard CranstonRichard Cranston
Owner at Entretien EnviroNet Inc.Owner at Entretien EnviroNet Inc.