Patrick Kankonda

o Python – Udemy. o Azure Data Factory – Udemy. o PowerShell 7 Essentials – Udemy. o Nederlands voor Anderstaligen – NT2. o Advanced Power BI – DAX – Udemy.

General context: SQL Server Trainer. Organization: Abylsen – Brussels. Activities / Deliverables: - SQL Server 2019 Installation and Configuration. - SQL Server Management Studio 18 installation. - Create an SQL training material. - Training for employees on SQL Data Definition Language and Manipulation queries (DDL/DML). o Create schema, Table, Stored procedures, functions, and Triggers. o Select … o Insert … o Update … o Delete … Environments: Windows 10, SSMS 2018, SQL Server 2019.

General context: Resolve DWH request in DataMart, produce reports and monitor Daily execution of DWH Organization: LAMPIRIS - Liège Activities / Deliverables: - Functional and Technical analysis. - Create new SQL Server objects such as tables, views, indexes, functions, schemas. - Write SQL queries using Transact SQL. - Designing ETL solution using SQL Server Integration Services and Wherescape. - Managing, investigating and solving incidents on Database and ETL. - Publish, schedule ETL solutions using SSDT and SQL Agent jobs. - Monitor daily ETL Jobs executions for DWH. - Create report using Qlik Sense - Create versioning with SourceTree / git. - Document the solution on confluence web tool. Environments: Visual Studio 2015, SQL server 2014, Windows Server 2012, Desktop Windows 10, Qlik Sense, Confluence, Slack, SourceTree, SSMS,Wherescape, Jira.

- Functional and Technical analysis: UML technique. - Database design and creation of database objects. - Implementing Stored procedures, Functions, triggers and Indexes (Transact SQL). - Designed and created a User Interface (Visual Studio 2019). - Application testing - Designed reports using crystal Reports. Environments: Visual Studio 2017, SQL server 2017, Desktop Windows 10.

• Designing ETL solutions using SQL Server Integration Services. • Create new SQL Server objects such as tables, views, indexes, functions, schemas. • Managing, investigating, and solving incidents. • Maintain and correct existing stored procedures, views, functions when needed. • Maintain the existing DWH database and the multidimensional cube. • Publish, and schedule ETL solutions using SSDT and SQL Agent jobs. • Create Dashboards and reports using Power BI. • Monitor daily ETL executions. • Used tools: SSMS 2017, SQL Server 2014, SQL Server Data Tool 2017

esigning ETL (E-LT) solution using Oracle data integrator 12c. • Analyze and designing semantic layer using BO Universe design tool. • Designing reports using SAP WEBI 4.2 from universe (BO –Universe Design Tool). • Implementing Stored Procedures using PL/SQL • Monitor ETL executions by checking the logs and notification emails in prod envinronment. • Writing complex SQL Queries for reports from ODS layer (Oracle 12 database). • Migration of sunopsis towards Oracle Data Integrator 12c. • Using Power Designer tool for database modeling.

• Developing database solutions. • Multidimensional modeling (Star schema: Determining Dimensions and Facts) • Implementing Stored Procedures using T-SQL • Writing complex SQL Queries. • Designing and implementing an ETL solutions using SSIS. • Writing documentation using EA. • Writing reports using SSRS. • Designing Tabular Cube using SSAS. • Team foundation server as Versioning tool

- Developing Planning Application 5YP. - Multidimensional modelling (Star schema: determining Dimensions and Facts) - Physical model with MS Visio 2010 - Implementing Stored Procedures using T-SQL - Designing and implementing an ETL solution using SSIS (loading 5YP DataMart from contributor db) - Creating macro to automate ETL process, data publishing and application versioning. - Implementing Cognos Framework manager - Migrating BO XI catalogue (universe) to Framework manager. - Designing reports with Cognos Report Studio

• Loading data on Ms SQL 2008R2 using SSIS from Access 2003 application • Writing Software Requirements Specification • Designed and created a User Interface for a new application (VS 2008) • Writing code using VB.Net (Visual Studio 2008) • Writing T-SQL Queries (T-SQL) • Application testing • Used Tools Environment: VS 2008 Excel 2003, SQL Server 2008, and Windows server 2003.

• Multidimensional modeling (Star schema: determining Dimensions and Facts) • Functional and Technical analysis • Physical modeling (Erwin data modeler) • Implementing Stored Procedures, Functions and Triggers using T-SQL • Implementing Indexes using Transact-SQL • Writing complex SQL Queries • Loading data on SQL 2005 using SSIS from DB2 db, flat files and Excel files. • Writing script using VB.NET 2.0 • Creating jobs to automate ETL process • Implementing Unit Tests (T-SQL) • Implementing Cognos Framework manager (Metadata modeling) • Designing reports with Cognos Query Studio • Testing and writing technical documentations • Used tools Erwin Data Modeler, BIDS 2005, Cognos 8 Framework Manager, Cognos 8 Query Studio,MS SQL Server 2005 Enterprise Edition and Windows Server 2003

• Creating and implementing an internal web service for unresolved adsl issue using php and SQL Server • 3rd Line ADSL Support Technician • Classified and solved all customer issues about ADSL products • Installed and configured windows OS and new hardware • Configured xDSL modem • Trained new Technical Support Agents • Used tools People Soft, BSCS, xDSL Synchro Tool, Calendra, Windows Server 2003

• Functional and Technical analysis : UML technique • Database design and creation using SQL Server 2005 (Transact SQL) • Implementing Stored procedures, Functions and Indexes (Transact SQL) • Designed and created a User Interface (Delphi 7) • Designed reports using Rave Reports • Application testing • Used Tools Environment: Delphi 7, MS Visio, Windows Server 2003, SQL server 2005 Standard