Rufaro Desderiol Email & Phone Number

Cape Town, Western Cape, South Africa

Responsible for consolidating data from isolated data sources into one centralized DWH to support analytics and business insights

Cape Town Area, South Africa

Coronation Fund Managers Data-warehouse Project Identifying and implementing internal process improvements while automating manual processes.• Migration of Cognos Analytics Reports to SSRS in order to decommission Cognos• Scheduling automatic delivery of SSRS reports using Active Batch• Work with stakeholders including the internal data team to assist with data-related technical issues and support their data infrastructure needs.• Reformulating existing frameworks to optimise their functioning• Ensuring the Datawarehouse tallies with Oracle Flexcube at day end

City Of Johannesburg, Gauteng, South Africa

Report Development: Create, design, and develop reports using tools like SQL Server Data Tools (SSDT) or Report Builder. Createqueries to retrieve data from various data sources and design the report layout, including tables, charts, graphs, and visual elements.Data Modeling: Creating appropriate queries or stored procedures to fetch data for the reports.Report Design: Working on the visual appearance of the report. Format data, choose fonts, colors, and styles, and arrange elements to create a coherent and user-friendly report layout.Parameter Configuration: Set up parameters that allow users to filter, group, and customize the data displayed in the reports. Ensure that parameters are correctly linked to data sources and queries.Expression Writing: Writing expressions in SSRS for customizing calculations, conditional formatting, and dynamic content in the reports. Create calculated fields, control visibility, and implement various functionalities.Testing and Debugging: Before deploying reports, thoroughly test and debug them to ensure accuracy, reliability, and optimal performance. Verify data, layout, and interactivity elements

Cape Town Area, South Africa

Coronation Fund Managers Data-warehouse ProjectIdentifying and implementing internal process improvements while automating manual processes.• Migration of Cognos Analytics Reports to SSRS in order to decommission Cognos• Scheduling automatic delivery of SSRS reports using Active Batch• Work with stakeholders including the internal data team to assist with data-related technical issues and support their data infrastructure needs.• Reformulating existing frameworks to optimise their functioning• Ensuring the Datawarehouse tallies with Oracle Flexcube at day end

Cape Town Area, South Africa

Specialising in the designdevelopmentenhancement and maintenanceof the ETL product for the Data Team.Participated in the migration of projects and code to a newly designed SSIS and CI framework and platform. Responsible for technical aspects, such as development, data quality, QA and technical support. • migration of c.50 Talend ETL projects/code to a newly designed SSIS and CI framework and platform.• Established best practices and coding standards across the SSIS framework.• Set up CI and automated project builds using TeamCity, Octopus and BitBucket• Initiated SSIS projects in the 2016 SQL SSISDB Catalog with specific environment variables.Talend Platform for Data ManagementSQL Server, SSIS, SSRSAgile, Scrum, Jira, ConfluencetSQL and Unit testing frameworkRedGate, GitHubOctopus, TeamCity

Johannesburg Area, South Africa

Providing technical support for the database environmentAssessment of database performance and the identification of problem areasETL Packages SSRS Reports for ETL PerformanceImplementing operational automationReport development using SSRS Visual Studio up to 2012Stock movement reports and inventory levelsSales reps performance reportsDeveloping various retail reports on request from different department including the finance and planning departments

Mutare Zimbabwe

• Development of software applications using VB.Net and SQL Server database • Installing and testing new versions of the DBMS• Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)• Contribute to one-on-one and/or small group training with clients regarding reporting, software and data• user support for various software applications • User support for various software applications• Update and maintenance of the existing website using PHPImplementing operational automation

Mcse: Business Intelligence, It

Activities and Societies: MCSE: Business IntelligenceMCSE: Business Intelligence

Bachelor Of Science (B.Sc.) Honors, Information Systems