Khutjo Leremi

Data Discovery and Provisioning of various systems Creation of Donodo Views Amending of Ab Initio jobs Data Discovery and provision of OPS Risk related projects IFR9 Project GBM and Flexi Data Sourcing and loading to ADW

Doing Gap analysis on IFRS9 Producing STTMs and SQL codes for Developers Amending exisiting data models

Producing SASRIA reports on the monthly basis Assisting with data quality in the organization Developing regulatory reports Ensure that the Prima source files are read correctly Develop programs for reading DTS files Develop programs for reading Evolve files and reports Assist in the Business Analyst work when needed Produce IDS and SAICB reports for Bryte Development of GWP report for Bryte Assisting in developing Data Quality strategies and KPIs

development - Delivering program designs in accordance with risk and compliance requirements and by using the appropriate programming language - Find faults and batch bottlenecks

- Data Cleaning, Manipulation & Transformation using SAS - Building data quality checks in the process especially around ID numbers - Assisting in developing scorecard process - Removing any inefficient code that may cause delays in SAS and Netezza processes - Convert stable SAS code to Netezza

- Running of month end commission - Investigating commission related issues - Amending the current running commission code and IP Diagram - Developing and Providing test data for convergence - Developed the CMRB deltas

- Data Cleaning, Manipulation & Transformation using SAS - Developing Logical and Physical Models of the warehouse - Assisting fellow team members with understanding the data structure - Conducting meeting with data owners to understand the history and structure of the data

- Data Extraction, Manipulation & Transformation - Data quality and cleansing - Data Analysis - Building of test cases by manipulating the data - Working with Business Analysts to verify and correct specifications - Development of ETL and BI processes - UAT and IAT processes - Assisting in User training and providing access to test area - Involved in handover process between Developers and Business Analysts as well as between developers and Production team - support and maintenance of production

- Data Cleaning, Manipulation & Transformation using Datastage and Informatica - Developing and maintain executive dashboard to monitor sms and please calls

- Data Cleaning, Manipulation & Transformation - Producing Business Intelligence reports - Installation of SAS 9 and setting up of its environment - Creating and adding of Users into SAS 9 environment