SIBONGINKOSI MOYO

• Managed vendor relationships, resulting in streamlined communication, timely delivery of services, and cost savings.
• Led team of developers to successfully deliver high-quality software projects on time and within budget constraints.
• Championed adoption of cloud-based technologies to scale applications efficiently while maintaining security compliance standards.
• Increased application stability by regularly monitoring performance metrics, addressing bottlenecks proactively to minimize downtime occurrences.
• Enhanced data visualization quality by implementing customized Tableau dashboards for clients.
• Streamlined reporting processes through development of user-friendly Tableau workbooks, resulting in improved business decision making.
• Optimized data analysis efficiency with creation of automated Tableau extracts and schedules.
• Boosted report accuracy by conducting thorough data validation and cleansing using SQL queries.
• Developed custom calculations and parameters in Tableau, enabling more sophisticated analysis capabilities for users.
• Developed comprehensive project plans for successful OBIEE implementations, ensuring on-time and on-budget completion.
• Delivered hands-on training sessions to users, empowering them to effectively utilize full potential of their newly implemented OBIEE systems.
• Assisted clients in creating comprehensive documentation for their OBIEE systems, including user guides, technical specifications, and data dictionaries.
• Streamlined data migration processes by developing custom scripts, reducing downtime during system upgrades.
• Increased data retrieval efficiency by designing optimized views tailored to specific reporting needs of various departments within organization.
• Analyzed existing SQL queries to identify opportunities for improvements.
• Designed and developed customized extract, transform and load (ETL) applications per client specifications.

• Liaised with client to understand their business and reporting needs, including identification of critical metrics and KPIs.
• Extensively used Tableau Architecture required to build and prototype dashboards to provide insights into operations of business function.
• Developed rich interactive visualizations integrating various reporting components from multiple data sources,
• Designed, developed, views and stored procedures to meet data management and data integration objectives.
• Designed, implemented and maintained ETL processes using SQL Server SSIS.
• Developed interactive dashboards with drill-down capability.
• Identified and resolved problems/issues concerning data accuracy and data integrity.

• Created interactive dashboards using Power BI,SSRS and Tableau
• Developed packages and extracted data using SSIS from OLTP to OLAP and SSIS Packages from development server to production server.
• Experience creating SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Developed SSAS cubes using Multidimensional(MDX) and Tabular(DAX).
• Created various value section in Parameters list, designing cascading parameters, matrix dynamics and more features in Tableau and SSRS.
• Developed Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using Tableau/SSRS.
• Embedded Power BI reports on client CRM system.
• Used Power BI Desktop, SSRS and Tableau for building dashboards and reports.
• Worked on SQL Profiler, Tuning Advisor in SQL 2016 to increase performance of reports. Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Environment: MSSQL Server 2014 Developer Edition, Visual Studio 2012, SSMS, SQLServer Integration Services (SSIS), SQL Server Reporting Services (SSRS),Tableau Desktop,Team Foundation Server.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Inspected fire and security alarm systems for both commercial and residential customers.

• Liaised with client to understand their business and reporting needs, including identification of critical metrics and KPIs.
• Extensively used Tableau Architecture required to build and prototype dashboards to provide insights into operations of business function.
• Developed rich interactive visualizations integrating various reporting components from multiple data sources,
• Designed specs for BI front end applications including dash boards & reporting, considering appropriate data flow and capture.
• Designed, developed, optimized complex stored procedures to meet data management and data integration objectives
• Designed, implemented and maintained ETL processes using SQL Server SSIS
• Designed, implemented and maintained SSAS OLAP cubes
• Developed interactive dashboards with drill-down capability
• Developed spreadsheet-based reports and data extracts with Excel and PowerPivot
• Identified and resolved problems/issues concerning data accuracy and data integrity
• Developed business oriented data dictionaries
• Provide input into technical architecture and data warehouse technology stack
• Provided maintenance support through SQL query tuning and optimization
• Participated in agile development teams, including interacting with both business analysts and end users to come up with well performing and scalable solutions