Data Project

PROFILE

Senior BI/Big Data/AI specialist with a demonstrated expertise in data architecture, modeling/design, trend, prediction and impact analysis. International experiences in academic (research and development) and industry projects, fast-tracks and continuous improvement initiatives. Worked for several industries: finance, telecommunication, pharma, retail and education. Has a strong analytical background combined with a creative problem solving and computer programming skills.

Core competencies also include: Informatica MDM (Certified Informatica MDM Multidomain10 Specialist), analytics using SAS, R and Python and Tableau for the visualisation. Cloudera Hadoop framework (spark streaming, sqoop, flume, oozie, HDFS, Hive, cloudera manager), Salesforce, AWS, Project Management using MS project and MSOffice (Word, Excel, Visio, Access).

CAREER HISTORY

Collège Bois de Boulogne, QC, Canada Jun. 2019 -present

Part time Trainer – Adult Continuing Education

Big data and Hadoop Framework program (HDFS, Hive, Flume, Sqoop, Kafka, Oozie, Elasticsearch, Spark DStreams &Structured streaming- SparkSQL, pipelines)

AI (Recommender Systems, Fuzzy Logics, Genetic Algorithms), Machine Learning and Deep Learning (computer vision CNN, Natural Language Processing using MLPs, RNN, GAN) program with python and libraries (scikit-learn, Tensorflow, Keras)

Salesforce and developing applications (Apex, Visualforce, SOQL)

Financial Institution, QC, Canada Nov. 2018- Jun. 2019

Senior BI specialist/ Data and Solution Architect

Conversion project (National Bank of Canada):

Proposed an infrastructure solution that goes with the client's business needs, implementation needs and data security needs

Analysed the data models of the proposed solution

Reduced by 50% projects delivery time by automating the testing process (SqlServer 2016, T-SQL)

Implemented a POC for the address management (using fuzzy logic libraries in python)

Prepared the auditing plan

Collège Bois de Boulogne, QC, Canada May 2018-Nov 2018

Part time Trainer – Adult Continuing Education

Java Programming Course and Mysql Databases

Salesforce (Apex, Visualforce, SOQL and Integration)

Deloitte, QC, Canada May 2017- May 2018

Big-Data / AIM

Senior Solution Designer/ Business System Analyst

Was involved in several projects in an Agile working environment:

Integration Project in the cloud: BI/Data integration project from Zuora to NetSuite using Informatica Cloud: main responsible for the integration part

Hydro Quebec Project: BI/Data Integration (BI:Sqlserver 2014/DataVault data model): automated the testing process and prepared the project’s documentation using MSOffice (Visio, PowerPoint, Word and Excel)

CIBC Project: Hadoop/Big Data Ingestion (from RDBMS to HDFS) using Hadoop framework/Sqoop,

CIBC Project: Hadoop/Big Data Ingestion (log files using Flume and Oozie)

Aldo project: Design and Implementation of an Informatica Master Data Management (Oracle / Informatica MDM- Informatica Address doctor)

Collège Bois de Boulogne, QC, Canada Jan 2017-May 2017

Part time Trainer – Adult Continuing Education

Java Programming and Mysql Databases

BELL - Bell Mobility (BI & Performance) QC, Canada Sept 2013 - Jan 2017

Business Analyst - Data-warehouse specialist

Was involved in 100 BI integration projects of the Performance data of three vendors: Huawei, Nokia and Cisco

in an Agile working environment

Profiled the data and defined the solution (the data model for the Oracle Xdata warehouse using Erwin/Oracle Data Modeler/PL-SQL)

Defined star schemas and Slowly Changing Dimension (Type 2)

Prepared the design document for the ETL (informatica) and reporting team (Microstrategy and Tableau)

Reduced by 50% projects delivery time and increased the data quality by automatizing data analysis and modeling tasks using Python

Participated actively in providing new ideas/solutions for the processes’ continuous improvement

CGI Consulting, QC, Canada Jun 2011- Apr 2013

IMS-Health Nov 2012 – Apr 2013

BI Consultant (Extract Transform Load / DBA/ Reporting)

Was the main responsible for the modeling and implementation of the Cost-Drivers project using Oracle tools (Oracle/DBA/ETL/Reporting)

Created the data model for the data-warehouse (Star schema).

Developed the ETL programs (External tables and PL/SQL).

Developed the reporting queries (PL/SQL).

Applied Oracle tuning procedures to improve the queries’ performance.

Laurentian Bank (Deposit Insurance Corporation Program) Jun 2011 - Nov 2012

BI Consultant (Data Analyst /Testing Analyst)

Was the main responsible for the integration and functional testing of the Deposit Insurance Corporation Program: 7 projects as well as the UAT with the business partners

Developed Integration testing of 7 projects and conformity testing

Developed functional testing and supervise the ETL developers.

Developed cases testing

Supervised UAT with clients

Yellow Pages Group, QC – Canada Jun 2009 - Mar 2011

Performance Analyst - Customers service department Sept 2010 - Mar 2011

Managed the client service data in the SQLSEVER database.

Developed statistics and forecasting reports on productivity and performance for the customer service department (Montreal, Toronto, Vancouver) using .NET/#C

Developed dynamic web forms that indicate the client service employees’ performance.

Taxonomy Manager - Operations Jun 2009 - Sept 2010

Participated in the development of the Knowledge Base that described the electronic service department on the YPG wiki platform (Confluence)

AdTax project: improved the taxonomy of the key words

Improved the relevancy of the key words used by the Search Engine (Marketing Interface Project)

Improved the Campaigns Rejection Process: described and analyzed the process and proposed a solution to improve it.

Swiss Federal Institute of Technology (EPFL) – Switzerland Apr 2001 - Mar 2009

Database Laboratory

Research & Development/ Teaching Sept 2002 - Mar 2009

Worked on research projects (Architecture, Analysis, Modeling and Prediction) and had several scientific publications in international conferences/workshops:

Predictive Database Schema Evolution (Oracle tools)

Requirements Ontology (AI/Semantic Graph) (Java /OWL)

Data mining on a Schema Repository (clustering/association rules /linear and logistic regressions)

Multimedia Data Management for meetings (Oracle/SQL/PHP/HMTL)

Teaching activities (Databases, C++) and under-graduate students’ supervision

Artificial Intelligence Laboratory (Swiss Federal Institute of Technology) and Lausanne University- Mathematical Methods Department

Research & Development Apr 2001 - Sept 2002

Was the main responsible for the design and implementation of the CLAVIS’s project (Classification and Visualization of Textual Data/Perl/ MATLAB/algorithms: clustering: KMeans & hierarchical /ACP)

EDUCATION

HEC of Montréal – QC – Canada 2018

Certificate in Business Analytics

Modules included: Advanced statistics using SAS, R, Data visualization (Tableau), Data-mining, Web Analytics including Google analytics, Operations research, Markets’ analysis and segmentation

HEC of Montréal – QC – Canada 2015

Certificate in Project Management

École Polytechnique Fédérale de Lausanne (EPFL) 2009

Doctorat en Informatique

Thesis: Predictive Approach for Schema Evolution

University of Geneva, Switzerland 2001

Masters in Computer Science

Modules included: Data-mining, Machine Learning, Artificial Intelligence, Mathematics for engineers, Telecom networks, Neural Networks, Compiling, Systems programming, Operating systems/Unix/Linux, Databases, Programming languages (JAVA, C++, PERL, PYTHON, SCALA…).

Final Year Project (Dissertation): Indexing Textual Databases – in order to improve the search within the textual databases, develop an indexing tool based on an online dictionary database.

Contact this candidate