Patrick Kankonda

Dynamic and motivated Business Intelligence Professional with a proven record 12 years of designing and implementing Database, Data Warehouse, ETL packages, Reports/Dashboard applications. Adaptable and transformational analyst developer with an ability to work independently, managing projects from concept to completion, utilizing scrum/agile methodologies in various industries.

Bachelor: Spec. in Business Data Analysis at EPHEC (2024-01 – Present)

Business Data Analysis Training – Developed strong skills in mastering tools to analyze and utilize data generated by organizational activities. Gained expertise in processing, cross-referencing, and transforming raw data into actionable insights, enabling informed and strategic decision-making. Currently strengthening skills in Business Data Analysis, Python, and Machine Learning – AI

• Developed strong skills in mastering tools to analyze and utilize data generated by organizational activities
• Gained expertise in processing, cross-referencing, and transforming raw data into actionable insights
• Currently strengthening skills in Business Data Analysis, Python, and Machine Learning – AI

Senior BI Consultant / SQL Server Trainer at Lampiris (2021-01 – 2023-12)

Maintained and evolved the Data Warehouse and DataMarts to support BI, self-service reporting, and management dashboards. Performed functional and technical analysis, data modeling, and T-SQL development. Designed and implemented ETL flows using SSIS and Wherescape.

• Maintained and evolved the Data Warehouse and DataMarts to support BI, self-service reporting, and management dashboards
• Performed functional and technical analysis, data modeling, and T-SQL development (tables, views, indexes, functions, schemas)
• Designed and implemented ETL flows using SSIS and Wherescape, published to SSISDB, and scheduled via SQL Agent
• Built Qlik Sense dashboards/reports, created unit tests for data quality, documented solutions in Confluence, and resolved DWH/ETL incidents

BI Developer at Touring (2016-01 – 2019-12)

Designed and developed ETL solutions with Talend Data Integration, integrating Salesforce and other operational sources into the EDW. Built and maintained Talend jobs with orchestration, context management, and error handling.

• Designed and developed ETL solutions with Talend Data Integration, integrating Salesforce and other operational sources into the EDW
• Built and maintained Talend jobs (joins, aggregations, file inputs/outputs), with orchestration, context management, and error handling
• Implemented PL/SQL procedures and functions on Oracle 12c, and designed universes (UDT) and reports (SAP BO Webi 4.2)
• Created unit tests for data integration, monitored ETL executions, documented processes, and supported optimization/migration of legacy ETL

Senior BI Developer at CESI (2019-01 – 2019-12)

Maintained and improved an existing BI platform, adding new features according to business requirements. Performed multidimensional modeling, created ETL with SSIS, and maintained SSAS cubes and the DWH.

• Maintained and improved an existing BI platform, adding new features according to business requirements
• Performed multidimensional modeling (Kimball), created ETL with SSIS, and maintained SSAS cubes and the DWH
• Developed dashboards and reports using Power BI and SSRS, and monitored daily ETL batches

Software Engineer .NET at Embassy of Mozambique (2019-01 – 2021-12)

Extended and maintained an application for visa processing and citizen registration. Designed the database (ERD, tables, procedures, triggers, indexes) in SQL Server and UI components in Visual Studio.

• Extended and maintained an application for visa processing and citizen registration
• Designed the database (ERD, tables, procedures, triggers, indexes) in SQL Server and UI components in Visual Studio
• Produced Crystal Reports, performed testing, documentation, and user training

BI Consultant, Software Developer .NET, Technical Support Consultant, Freelance Software Engineer at Embassy of Mozambique, Scotler, Numius, Red Kite Learning, Techcity (2006-01 – 2012-12)

BI Consultant (Scotler, Numius), Software Developer .NET (Red Kite Learning, UK), Technical Support Consultant (Techcity), and Freelance Software Engineer delivering reporting and database applications

• BI Consultant (Scotler, Numius)
• Software Developer .NET (Red Kite Learning, UK)
• Technical Support Consultant (Techcity)
• Freelance Software Engineer delivering reporting and database applications (SQL Server, Cognos, SSIS, Delphi, PHP)

Specialization in Business Data Analysis – EPHEC (2024-01)

Bachelor in Computer Science – ICET (1999-01 – 2002-12)