Luc Milot Email & Phone Number

Montréal, Québec, Canada

• Contribute to the integration, transformation and consolidation of data from various structured and unstructured data systems into structures suitable for the creation of analysis solutions.Develop Python and VBA.
• Python
• Excel VBA
• PowerQuery
• PowerShell
• Jira, Confluence, GitHub

Montréal, Québec, Canada

• Leader in how to use spark databrick in python. Develop techniques and prototype with spark technology, and development of the base of a unified information model. The prototype is a success, time to leave the full.
• Python
• Spark
• Spark SQL, Datasets, and DataFrames
• GraphX (Graphframs): processing graphs
• PySpark: processing data with Spark in Python

Région De Montréal, Canada

• Develop all level for all kind of request for change: DBA, Stored Procedure, SSIS, SQL coding, Performance
• Create Powershell program to extract information from XML export of SSIS job to build meta data table containing the information used by the SSIS dtsx file.

Longueuil

• DBA for the datawarehouse.
• Develop reports and dashboards
• Build a modelisation and integration framework (in powershell), allowing to integrate different source into the corporate datawarehouse, bypassing SSIS coding.
• Use BIML and C# coding to store SSIS parameter in meta control table.

Montreal, Canada Area

• Bi-Analyst
• Define and elaborate data model
• Development of complex SQL code
• Assist and guide in the development of Data Stage and SSIS code
• Validate data quality Data Analyst
• Discover insights from massive amounts of structured and unstructured data

Région De Montréal, Canada

• Design and develop SQL Server Report Service report
• TansactSQL development

Région De Montréal, Canada

• Business Analysis of requirement and process
• Business process modelling and data low diagram
• Integrate business processes between multiple projects and business domains
• Modeling of business process

Montreal

• Define principles and methodologies of the data enterprise architecture
• Define a reference framework for the enterprise architecture meta model and insure its implementation
• Develop a method and a tool to integrate enterprise architecture artefacts, allowing the development cycle of the agile method to integrate itself in the TOGAF ADM cycle, as being a user and a contributor
• Modeling of the enterprise architecture
• Deploy and maintain the enterprise architecture referential
• Conversion, integration and consolidation of corporate information linking functional projects and business domains

Montreal

• Define principles and methodologies of the enterprise architecture
• Define a reference framework for the enterprise architecture meta model and insure its implementation
• Modeling of the enterprise architecture
• Deploy and maintain the enterprise architecture referential
• Conversion, integration and consolidation of corporate information linking functional projects and business domains at the corporate program level
• Communicate architecture information to all stakeholders of the enterprise across functional projects and business domains

• Define principles and methodologies of the enterprise architecture
• Define a reference framework for the enterprise architecture meta model and insure its implementation
• Modeling of the enterprise architecture
• Deploy and maintain the enterprise architecture referential
• Communicate architecture information to all stakeholders of the enterprise across functional projects and business domains
• Establish the requirement for the building of a link between the EUP/RUP method and the enterprise architecture, to insure integration of the development cycle of the Agile method with the ADM TOGAF cycle

• Build specifications for the pilot project of rebuilding of in house systems, providing for the functional integration of legacy systems with the new business requirements
• Work in the pilot project of rebuilding the in house systems, as an expert in central system expert in Db2 databases, VSAM file systems and application systems integration
• Create conceptual and logical models
• Develop the specification for the ETL environment at project level using the tool IBM Data Warehouse Center, defining a plan of action with business objective and details on what work is to be done
• Data mapping and conversion for the ETL environment
• Maintain the execution of the ETL production environment

• Act as a technical expert to solve performance problems experienced by application and databases in large systems
• Build specification for the application and databases performance project
• Build opportunity analysis for the evolution of the BI systems
• Data integration and consolidation between different ODS
• Application and databases optimisation
• Creation and administration of test databases

• Within this small company, my role was encompassing everything that had a relation with data. Architecture, administration and reports. Also we had a takeover from another company, and I was responsible of creating.
• Develop the architecture of an ODS (Operational Data Store)
• Install and administrate the COGNOS(OLAP) BI tool
• Build BI report with COGNOS Impromptu and Powerplay
• Architecture, modeling and creation of databases (OLAP et OLTP)
• Data modelling

• My first mandate was to help internal audit in establishing a detail report on the data quality in the operational systems using DB2My second mandate was to use my expertise in SQL to write complex report within the.
• Analysis and creation of SQL to satisfy the business rules and data quality
• Define business rules from user specifications
• Advise on modeling and building the enterprise data warehouse

• Elaborate and build the performance analysis group, doing comparative study between different tools and analysing different systems. I also develop tools and methodology to insure the vitality of the performance group.
• Project management of the creation of a corporate tool
• Analyse and create SQL
• Optimise access to DB2 MVS database
• Data exploration
• Impact Analysis

• Participate in a integration study of the CN operation system into the German system analyzing the database technical specifications and needs of resources
• Study functionalities, business rules and technical specifications and needs of application systems, computers and networks.
• Consult on database issues across project groups, providing guidance and direction.
• DB2 performance and SQL tuning.
• Participate in modeling of the databases

• Support database in a large DBMS 7X24 mission critical high volume environment
• Define business needs
• Conceptualize solutions
• Analyze, code, implement and integrate large scale systems
• Conduct studies pertaining to development of new information systems to meet current and projected needs.
• Develop test strategies and implement them.

Data Scientist With Python, Data Science

IBM Cognos Analytics - Author Reports Advanced (v11.0) - SPVC (J4059G Data Scientist with Python – Certification DATA CAMP in progress (12.

Education record

• April: 2020 : MongoDB_101_Getting_Started : 3T Software Labs

Education record

• April: 2020 : M001: MongoDB Basics - MongoDB University