SIYABULELA MBI

Client: RMB Investment Banking Division

Role: IT Business Analyst

Duration: Current

• Duties: Executed ad-hoc query improvements within Oracle SQL server.
• Consolidated stakeholder needs into comprehensive requirements.
• Managed client relationships through regular check-ins and updates on project progress.

• Developed rule based models using SAS enterprise guide
• Utilized Power Bi to develop dashboards.
• Sourced and transformed data.
• Developed ETL processes to pull data from Teradata to MSQL Server.
• Facilitated effective stakeholder engagement.
• Building NCA KRI dashboard (Prescription, Cost of credit, Induplum)
• Building Immigrations model

• Created detailed visualizations using Power Bi for data analysis.
• Performed data analysis to validate reporting accuracy.
• Communicated key report findings to stakeholders effectively.
• Refined report development for FinCrime KYC/CDD.
• Developed comprehensive Power BI dashboards for foreign nationals.
• Utilized data visualization tools to effectively communicate business insights.

• Maintained Power BI reports to ensure timely reporting
• Created comprehensive dashboards using Power BI.
• Utilized SAS Enterprise guide to develop rule-based models.
• Wrote and maintained queries using TSQL.