Moses Charles Matsina
Data Model and Implementation Analyst
Johannesburg
Overview
17
17
years of professional experience
2008
2008
years of post-secondary education
Work History
Data Modelling and Implementation Analyst
Absa - CIB
06.2022 - Current
- Develop statistical models, Using Base SAS, SAS Enterprise Guide, SAS data steps, SAS procedures, SAS SQL, SAS Viya and SAS Macros
- Data extraction and programming Using SAS Viya, E-guide, Base SAS, SQL, Hadoop and Hive
- Validates the quality of the data, quality assurance, unit testing, root cause analysis, raises incidents, where necessary and collaborate with data stewards to continuously improve on the quality of data
- Implementing PD, LGD and EAD models for Regulatory Capital and Impairments (IFRS9) models
- Proactively deal with data queries within the agreed turn-around times to resolve Business Intelligence enquiries
- Model monitoring and ensure best practice modelling techniques are in place and optimizing the existing model
- Ensure full model best practices, governance processes for modelling are complied with from model inception and build through to validation and signoff by completing all relevant documentation according to the Absa Model Risk Policy
- Delivered detailed documentation on implementation processes and procedures, facilitating knowledge transfer across the team
- Identified areas for improvement and implemented necessary changes, resulting in successful project completion
- Optimize SAS programs for better performance and scalability
- Assist in audits and data validation efforts
Data Analyst
Nedbank - RRB
07.2016 - 05.2022
- Work with stakeholders to understand business needs and translate them into analytical solutions
- Understand customer requirements and provide appropriate technical solutions
- Build and maintain strong relationships with internal clients, and recommend innovative solutions to business problems
- Translate data in the way that meets functional area specification
- Data extraction, clean data, deployment and programming Using Base SAS, SQL Server (SSIS)
- Data analysis, turning data into actionable insights and communicating result to stakeholders for decision making
- Proactively deal with data queries within the agreed turn-around times to resolve Business Intelligence enquiries
- Create reports of a strategic, tactical or operational using software tools such as PowerBI, SAS and Sql
- Identified areas for improvement and implemented necessary changes, resulting in successful project completion
- Ensure data accuracy and consistency across different systems
SAS Lead: Wipro Consultant
Absa
11.2015 - 06.2016
- Design reports of a strategic, tactical or operational nature as required in collaboration with stakeholders using E-Guide, SQL (SSIS, SSAS, SSRS) and SAS
- Continuous improvement and management of existing reports/dashboards, database and dataset
- Create SAS programs for data mining
- Program SAS data validation, checks data issues and listings to identify data discrepancies
- Write and optimize SAS programs (SAS Base, SAS Macro, SQL, SAS Enterprise Guide, etc.) for data processing
- Maintain and improve ETL (Extract, Transform, Load) processes for data integration
Business Intelligent Analyst
FNB - IPH Saving and Investment
03.2014 - 10.2015
- Extract, clean, and analyze large datasets using SAS and other BI tools
- Ensure client retention and satisfaction by delivering a service that is consistent, swift, seamless and error free
- Develop and maintain dashboards, reports, and data visualizations to present business insights
- Identify trends, patterns, and anomalies in data to support business strategy
- Translate Business Strategies into actionable goals and execute relevant BI projects / BI initiatives aligned to strategic objectives with specific performance measures and control systems to track progress and Using BI tools to create reports, dashboards and Microsoft office tools
- Automate data processes and reporting to improve efficiency
- Ensure data accuracy, consistency, and compliance with regulatory standards
Business Intelligent Analyst
FNB - Retail Forex Pricing and Analytics
09.2011 - 02.2014
- Utilize SAS tools (Base, Enterprise Guide, Visual Analytics, Macros) to analyze large sets of forex trading and pricing data
- Develop real-time dashboards and reports to track forex price movements, spreads, and trading volumes
- Identify key trends, anomalies, and market behaviors that impact retail forex pricing
- Assess the impact of competitor pricing, macroeconomic events, and regulatory changes on forex spreads
- Use SAS analytics to track and report on risk exposure, volatility, and order execution performance
- Support risk management teams by providing data-driven insights into potential market fluctuations and pricing anomalies
- Design, maintain, and optimize forex data warehouses and pricing databases
- Work closely with traders, risk managers, quants, and IT teams to enhance forex pricing strategies
- Provide ad hoc analysis and data-driven recommendations for senior management
SAS Developer
Absa - Group Information System
12.2008 - 08.2011
- Query data and data extraction and programming Using Base SAS, SQL and DI Studio
- MIS: Adhocs reporting and Report Building Using SAS, E-Guide, SQL, Excel and Power BI
- Develop custom SAS applications for data manipulation, forecasting, and decision support
- Work with SAS Data Integration Studio to build and optimize ETL pipelines
- Optimize SAS programs and queries to improve execution speed and efficiency
- Automate repetitive data processing tasks using SAS Macros and scheduling tools
- Support cross-functional teams with data extraction, analysis, and reporting
- Document processes, workflows, and best practices for knowledge sharing
- Enhance job scheduling and batch processing in SAS
- Ensure data quality, integrity, and governance across the organization
Business Intelligent Analyst
PBT Group
03.2008 - 11.2008
Education
B-Tech - Information Technology
Vaal University of Technology
Johannesburg, South Africa 01.2009 - 12.2009
N.D - Information Technology
Vaal University of Technology
Johannesburg, South Africa 06.2005 - 12.2008
Senior Certificate -
Shipungu High School
Limpopo12-2003
Skills
SAS (SAS DI Studio, SAS Enterprise Guide, SAS Viya, Base SAS, SAS LSF, SAS Macros, SAS Management Console)
SQL(SSIS, SSRS, SSAS, SQL Sever)
Documentation/technical writing skills
Self-starter
Team player
Verbal and Written communication skills
Time management
Hadoop (Hive)
Data visualization and Reporting(Oracle BI, QlikView, PowerBI, Excel)
Attention to detail
Data management
Data analysis
Stakeholder management
Teamwork
Problem-solving abilities
Time management abilities
Team collaboration
Data modeling
Personal Information
- Gender: Male
- Nationality: South African
Certificate Information
- SAS Certified Specialist: Base Programming 9.4, SAS Institute.
- SAS Advance Programming (In-progress), SAS Institute.
- SAS MACROS, SAS Institute.
- Credit Risk Management Solution, SAS Institute.
- Data Integration studio fast track, SAS Institute.
- Analytical Overview Reporting and Dashboard, Oracle institute.
Timeline
Data Modelling and Implementation Analyst
Absa - CIB
06.2022 - Current
Data Analyst
Nedbank - RRB
07.2016 - 05.2022
SAS Lead: Wipro Consultant
Absa
11.2015 - 06.2016
Business Intelligent Analyst
FNB - IPH Saving and Investment
03.2014 - 10.2015
Business Intelligent Analyst
FNB - Retail Forex Pricing and Analytics
09.2011 - 02.2014
B-Tech - Information Technology
Vaal University of Technology
01.2009 - 12.2009
SAS Developer
Absa - Group Information System
12.2008 - 08.2011
Business Intelligent Analyst
PBT Group
03.2008 - 11.2008
N.D - Information Technology
Vaal University of Technology
06.2005 - 12.2008
Senior Certificate -
Shipungu High School