Rufaro

RUFARO TUMBARE Experienced SQL, ETL and Application developer since 2015 and Scrum Master (CSM), aspiring to advance agile career pathway with a growing or highperforming company. Motivated to contribute a strong technical background with passion fordeveloping people and cross-functional teams in a challenging environment. EMPLOYMENT MIMECAST, Cape Town Data Engineer and Assistant Scrum Master Jan 2022 - current ● Collaborating with Business Analysts to understand business requirements specifications. ● Migration of Facts and Dimensions from SQL Server to Snowflake using DBT ● Created SSIS packages to extract, transfer and load data to data warehouse. ● Involved in the migration process from on prem SQL to AWS. ● Snow piping data from AWS S3 into Snowflake data lake staging tables. ● Maintenance and provide support to the users for the deployed packages. ● ● Data validation and testing using Redgate toolbelt. Assisting the Scrum Master to align and coach the team via facilitation of daily stand up, sprint refinement and planning. Participate and facilitate effective Sprint Retrospectives to implement actionable change and improvements to team efficiency. Assisting the Product Owner with Product backlog maintenance ● ● PROFILE 30 Days’ notice period Joburg, South Africa Unrestricted SA work rights linkedin.com/in/techsavvyrufaro [-]- SKILLS Snowflake, MS SQL DBT Hollywoodbets, Cape Town SSRS / SSIS / SSAS Business Intelligence Engineer Talend Oct 2023 - May 2024 ● Designing, development and maintenance of Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSRS and PowerBI. ● Responsible for the Creation of Stored procedures, dashboards, reports and ETL processes. ● Collaborates with BI Analysts to understand customer needs. ● Designs, develops, and tests BI solutions such as databases, data warehouses, queries and views, reports, and dashboards. ● Troubleshooting reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and/or reports. T-SQL, C# AWS, Power BI Coaching for Team Development Partnering with the PO QUALIFICATIONS Honors Degree: Information Systems (2015), Midlands State University, Zimbabwe Coronation Fund Managers, Cape Town SQL/SSRS Developer TRAINING Certified Scrum Master (CSM) Oct 2019 - Nov 2021 ● Developed Stored Procedures, Functions and Views to be used to supply the Data to theReports. Complex formulas were used to show derived fields and to format the data based on specific conditions. ● Created SSIS packages to extract, transfer and load data to data warehouse. ● Developed and maintained all client SSRS dashboards. ● Identifying new process improvement opportunities. ● Maintenance and provide support to the users for the deployed reports. ● Continuously interacted with BAs and end users to gather user requirements. ● Scheduling automatic delivery of SSRS reports using Active Batch. ● Removing Impediments for the development Team Kurtosys, Cape Town ETL Developer (SSIS Talend) Dec 2017 - Sept 2019 ● Created SSIS packages to extract, transfer and load data to data warehouse. ● Migration of Talend Projects to SSIS to decommission Talend. ● Created SSRS reports for package executions & logging from SSIS catalog. ● Developed ETLS using C# to interface with API’s ● Documentation of Talend to SSIS migration using Confluence. ● Provide 2nd line support to SSIS projects running in production as well as support for old legacy Talend projects. Omni Africa, Zimbabwe SQL Developer Jan 2015 - Sept 2017 ● Involved in the design and development of a database to house data from various data sources for all reporting needs SQL Server 2010. ● Create visualizations, including dashboards, flowcharts, graphs to relay business concepts through visuals to colleagues and other stakeholders. ● SQL Scripting and query performance tuning for the Data team. ● Creating and maintaining ETL structures from applications to consolidate client data to create holistic operational dashboard for management. ● Automated operations and SQL queries as required. Microsoft Certified Solutions Associate SQL Server (2016)