Reading
Zuqhame Skosana
Data Specialist
Pretoria
Summary
Complex problem-solver with an analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
6
6
Certification
6
6
Industries worked for
Work History
Senior BI Developer
Momentum health
10.2023 - Current
- Senior Power BI Developer
- Developed and automated paginated reports for partner companies, enhancing efficiency and decision-making.
- Collaborated with data engineers and scientists to design and implement intelligent business solutions, driving data-driven insights.
- Built and maintained robust data pipelines, ensuring data integrity and accessibility.
- Spearheaded continuous improvement initiatives for reporting tools, optimizing performance and user experience.
- Leveraged AWS for cloud solutions, enabling scalability and cost-efficiency.
- Design and develop user-centric dashboards in Power BI, empowering data-driven decision-making.
- Document technical processes and data flows, ensuring knowledge transfer and project continuity.
BI Consultant
DataFlux
08.2023 - 10.2023
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Provided technical support for troubleshooting analytics and reporting issues.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Enhanced business decision-making by developing and implementing effective BI strategies.
- Generated ad-hoc reports to evaluate specific business requirements.
- Created dashboards to monitor and track key performance indicators.
- Leveraged visualization techniques, making it easier for stakeholders to understand complex patterns within their data.
Data Engineer | Snowflake Specialist
BMW Group
09.2022 - 10.2023
- Ingested data from various sources (primarily AWS S3 buckets) into Snowflake data warehouse using Python, ensuring data availability for analysis.
- Cleaned and tested data, guaranteeing quality and accuracy for decision-making.
- Developed and maintained insightful dashboards, empowering data-driven insights for the team.
- Documented processes and designed innovative strategies, streamlining workflows and fostering knowledge sharing.
- Authored comprehensive documentation on Confluence, promoting understanding and collaboration.
- Monitored Snowflake environment and AWS resources, proactively addressing potential performance issues.
- Applied Python for predictive analytics, uncovering trends, and informing strategic decisions.
- Designed SNS Topics and Lambda functions to automate data ingestion into the database, enhancing efficiency and data freshness.
- Collaborated with product and other teams, leveraging Snowflake to address their data needs.
- Debugged software, identifying root causes and implementing solutions, ensuring system reliability.
- Collaborated with system architects, design analysts, and others to understand business and industry requirements.
SQL Developer And BI Analyst
Autoboys
12.2021 - 09.2022
- Developed and maintained internal dashboards and reports using Power BI, Tableau, and other tools, empowering data-driven decision-making.
- Created insightful reports for external partners (insurance companies), fostering strong business relationships.
- Managed business requests and tickets, delivering timely BI solutions to address critical needs.
- Designed and implemented ETL processes, ensuring data accuracy and integrity.
- Extracted and transformed data using SQL (Transact SQL, MySQL, PostgreSQL), Pentaho Spoon, and Alteryx/Trifacta, preparing data for analysis.
- Built and tested robust business reports using SSRS, providing accurate insights.
- Delivered and maintained real-time dashboards, enabling stakeholders to monitor key business operations.
BI And SQL Developer
Growthpoint Properties
01.2021 - 12.2021
- Led project management efforts using Redmine, ensuring timely delivery and adherence to project goals.
- Crafted compelling visualizations and reports using Power BI, DAX, and Excel, translating complex data into actionable insights.
- Applied agile methodologies to facilitate iterative project development, maximizing responsiveness and flexibility.
- Developed APIs on MRI property leasing platform, enabling seamless data integration and automation.
- Collaborated with QA team to test business reports and dashboards, ensuring quality and accuracy.
- Skillfully utilized SQL to query and manipulate large datasets, driving efficient analysis and reporting.
- Optimized SQL queries for enhanced performance, supporting critical business decision-making.
Jnr Software Developer
Blanktech
12.2019 - 01.2021
- Developed Android applications, delivering engaging mobile experiences for users.
- Constructed websites, ensuring functionality and visually appealing design.
- Leveraged Trello for effective task management, ensuring project organization and timely delivery.
- Collaborated with cross-functional teams to deliver high-quality products on tight deadlines.
Computer Science Tutor
University Of Cape Town
02.2019 - 07.2020
- Helping students with Python and Java programming languages.
- Helped struggling and novice students with basic computer skills such as keyboarding and file management.
- Worked closely with students on specific class struggles, closely reviewing materials and assignments to offer targeted help.
- Assisted students in developing study skills and strategies.
Education
Bcom Information Systems Hons (part-time) -
University of Cape Town
01.2024 - Current
Bcom Information Systems And Computer Science - Computer Science
University of Cape Town
Cape Town, South Africa 03.2017 - 12.2020
Skills
MS SQLMySQLPostgreSQLSSMSSSRSTableauPowerBIDAXMicrosoft Excel
Snowflake
ETL ProcessingAlteryxSSISPentaho SpoonApache Kafka
AWS
Data Modeling
Database Management
Project Documentation
Data Warehousing
Python
Java
C#
ReactJs
NextJs
Code reviews
Web Programming
Agile Methodology Experience
Certification
Oracle Cloud Data Management - Certified Foundations Associate, Present, https://catalog.education.oracle.com/ords/certview/sharebadge?badgeId=E0D-085-0584
Personal Information
Nationality: South African
Extracurricular Activities
Tutor, Excel Uni
Interests
Gaming
Learning new sports
Timeline
Bcom Information Systems Hons (part-time) -
University of Cape Town
01.2024 - Current
Senior BI Developer
Momentum health
10.2023 - Current
BI Consultant
DataFlux
08.2023 - 10.2023
Data Engineer | Snowflake Specialist
BMW Group
09.2022 - 10.2023
SQL Developer And BI Analyst
Autoboys
12.2021 - 09.2022
BI And SQL Developer
Growthpoint Properties
01.2021 - 12.2021
Jnr Software Developer
Blanktech
12.2019 - 01.2021
Computer Science Tutor
University Of Cape Town
02.2019 - 07.2020
Bcom Information Systems And Computer Science - Computer Science
University of Cape Town
03.2017 - 12.2020