Learn Data Skills
Beta
Shadrack Yawe Kizza

Shadrack Yawe Kizza

Certified

Data Engineer

Komhar Services

Technologies

My Portfolio Highlights

My New Certification

Data Engineer Associate

My New Certification

SQL Associate

Data-driven and Mathematics enthusiast, making the impossible possible.

My Certifications

These are the industry credentials that I’ve earned.

SQL Associate

SQL Associate

Data Engineer Associate

Data Engineer Associate

Other Certificates

Microsoft Microsoft Certified Azure Fundamentals

Microsoft Microsoft Certified Data Fundamentals

Microsoft Microsoft Certified: Azure Data Engineer Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Komhar Services | Nov 2023 - Dec 2024

Data Engineer

1. Collaborated with the development team to transition intricate data pipelines from Informatica to Azure Data Factory (ADF), successfully migrating data from various data sources (SQL Server, Oracle, flat files) to Snowflake. 2. Redesigned workflows and optimized data transformation logic to leverage ADF capabilities, ensuring seamless migration while preserving data accuracy and performance. 3. Created parameterized workflows for deployment, increasing development efficiency and reducing manual intervention. 4. Leveraged Azure DevOps (ADO) for code versioning, pull requests, and collaborative code reviews, ensuring streamlined and organized code management. 5. Collaborated with the System Integration Testing team and client to troubleshoot and debug error pipelines, ensuring data consistency, accuracy, and alignment with business requirements. Conducted root cause analysis for pipeline issues, implementing preventive measures to ensure ETL stability and reliability. 6. Resolved performance and complex logic issues in the ETL process, identifying bottlenecks and optimizing critical paths of data transformation. Enhancements included optimizing SQL queries for Snowflake, data partition strategies in ADF, and combining transformation scripts reducing latency between ADF activities. 7. Collaborated with the development team to migrate workflows from IBM Cognos to dbt and Snowflake, enhancing system integration, performance, and efficiency in data processing and analytics. 8. Collaborated with the development team and clients to design, develop and deliver proof of concept (POC) projects to demonstrate the feasibility of migrating to modern data technology tools such as transitioning data workflows from legacy ETL tools (Informatica, IBM Cognos) to modern data platforms (dbt, Databricks, ADF).
Show More

Allied Systems Group | Sep 2022 - Oct 2023

Data Engineer

1. Designed and implemented advanced analytics solutions in Power BI, utilizing predictive models with regression analysis, anomaly detection, and Key Influencer visuals to identify business drivers and forecast trends. I also configured drill-through functionality to enhance interactivity and provide granular insights. 2. Performed advanced regression analysis through integrating python and its pandas’ library in PowerBI, bridging data science and business intelligence to deliver actionable insights. I demonstrated scenario-based analysis using "What-If" parameters and custom tooltips to improve report user engagement. 3. Managed Power BI deployment pipelines to streamline report development and deployment processes, ensuring smooth transitions between testing, QA, and production environments. I configured deployment rules, integrated on-premises gateways, and automated workflows to maintain data accuracy and security. 4. Implemented Row-Level Security (RLS) based on organizational hierarchies to protect sensitive data and ensure compliance. 5. Designed real-time alerts using Data Activator in Microsoft Fabric and PowerBI to notify sales managers of underperforming personnel, facilitating timely interventions, and enhancing accountability. 6. Developed and displayed advanced data modelling techniques using Power Query and DAX, including joins, pivoting, and unpivoting transformations to reshape and analyse data. 7. Designed dashboards, Power BI apps, and custom themes to standardize reporting while adhering to branding guidelines. 8. Delivered workshops and demos on key Power BI features—such as Quick Measures, regression analysis, RLS, and deployment pipelines—fostering a data-driven culture across the organization. 9. Configured trusted workspaces within Microsoft Fabric to enable secure connectivity while maintaining strict access control, facilitating collaborative data access for analytics and reporting without compromising sensitive information.

Techsoft Group LLC | Sep 2021 - Aug 2022

Data Engineer

1. Collaborated with Architects to design data models that meets our business stakeholders current wants and anticipates their future business data and analytic needs. 2. Collaborated with our Offshore Team to design and configure rapid ingestion of raw data sources into our Azure Data Lake for better availability and uptime. 3. Implemented seamless data migration processes on the azure platform through creating Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse. 4. Collaborated with our Offshore Team to model and test an application that manages all day-to-day activities of a business from a centralized point to reduce costs, handle employee time entry, on boarding and issue tracking, among others. 5. Leveraged PowerBI to create interactive reports and dashboards for our downstream consumers and data analytical teams through connecting to the SQL server. 6. Developed SQL queries to analyze and interpret data to identify trends, patterns and opportunities for businesses.

My Education

Take a look at my formal education

Bachelor of Statistics, Mathematics and Statistics  · (January 2021 - JanuaryMakerere University | 2024
Self-help development program The Mentorship Class | 2020
High School Diploma, Mathematics Economics Geography  · (FebruaryKing's College Budo | 2019

About Me

Shadrack Yawe Kizza

I enjoy using data to solve real problems, ask the right questions, and turn complex numbers into clear, useful insights. I am always learning and looking for better ways to use data to help people and businesses make smart decisions.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free