CURRICULUM VITAE

OF

Mr KHUTJO PHILLIP LEREMI

Address: No 217 Tricarrel Flat, 170 Jorissen Str, Sunnyside, Pretoria, 0002

Contact Number: 072-***-****

Certified SAS Consultant

ac4ssj@r.postjobfree.com

OBJECTIVES

My objectives are that I want to be productive and effective in the work place and in every job assignment I‘m given. I’m a team player, a good communicator and I’m not afraid of challenges. I also want to learn new things.

PERSONAL INFORMATION

Date of birth : 08 August 1982

Sex : Male

Identity number : 820-***-**** 088

Passport Number : 440670333

Nationality : South African

Languages : Sepedi, English (speak, read, write)

: Tshivenda, Isizulu (Speak)

Martial status : Single

Health : Excellent

EDUCATIONAL BACKGROUND

High School Attended : Gojela High School in Limpopo province

Matriculated 1999

Matric Subject : Sepedi (HG), English (HG), Biology

(HG), Physical science (HG), Mathematics (SG), Geography (HG) Senior Certificate

TERTIARY

Institution : University of Johannesburg

Program : National Diploma Computer System Engineering

Year of study : Completed (11/2002)

Student Number : 802007910

Subjects Passed : Programming I, II & III, Systems Analysis II, Software Engineering III, Computer Skills I, Mathematics I, II & III, Design Project III, Network Systems II & III, Operating Systems III, Digital Systems I, II & III, Electronics I & II, Logic design III, Microprocessor III, Digital Communication II, Communication skills I (Module A & B) and Electrical Engineering I and II

Current Studies : LDP (Leadership Development Programme)

Institution : GIBS (University of Pretoria)

Student Number : 302416

Future Study Interest : Data Scientist, Business Analysis and Data Modeling

Other Qualification

Institution : SAS institute

Qualification : SAS Base Programming (8.2)

Institution : Knowledge Integration Dynamics

Qualification : Micro strategy

Institution : Alicornio Africa

Qualification : Data Warehouse Concepts and Dimensional Modeling Techniques

WORK EXPERIENCE

1. Company Name : Nedbank PTY

Position : Operational Analyst

Year : 01 December 2013 to date

Current Skills : Netezza, SAS ETL(DI Studio), SAS Base

Projects : I play a due role of support and maintenance of production as well as development.

Responsibilities :

- Support and maintenance of production as well as development

- Delivering programme designs in accordance with risk and compliance requirements and by using the appropriate programming language

Reason for wanting to leave : The position doesn’t allow me to utilize my full skills set

2. Company Name : African Bank

Position : Business Intelligence Analyst Consultant

Year : 18 March 2013 to 30 Sep 2013

Skills : Netezza, SAS ETL(DI Studio), SAS Base

Projects : Optimizing SAS code to Netezza (Score Cards)

Responsibilities :

- 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

Reason for Leaving : Contract expired and lack of proper working resources

3. Company Name : MultiSoft

Position : SAS Data warehouse Consultant

Year : 01-July-2012 to 18 March 2013

Projects : MTN Commission IP

Responsibilities :

-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

-

Reason for Leaving : MTN cost cutting measures

4. Company Name : SEBASE

Position : SAS Data warehouse Consultant

Year : 01-February-2012 to 30- June-2012

Projects : Data Warehouse at Gauteng Department of Education

Responsibilities :

- 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

Reason for Leaving : Career Move

5. Company Name : Nedbank PTY

Position : SAS Data warehouse Developer

Year : 01-June-2006 –to-31-Janaury-2012

Courses : Data flux, SAS Integration studio

Projects

Project Definition

Date

Duties

Money Laundering Control Processing

01-June-2006 to 31 Oct 2006

Coding in Base SAS and sending accounts to be Unfrozen and Frozen, and as well Verifying Clients and Closing of Accounts

Channel Project

01 July 2006 to 28 Feb 2007

Reading Cobol files and storing them in SAS tables and Building Data Marts using ETL (DI Studio)

EDW Data Quality

01 August 2006 to 31 October 2006

Finding and reporting Data Quality issues in the EDW as well as Building Data Marts for all the records which have error using DI Studio and doing data cleaning using Data Flux

SACP

December 2006 to 30 March 2007

Create flat files for customer profitability project

Debt Manager

15 April 2007 to 31 August 2007

Creating Data Marts and view for the Debt Collector Department

ACLM

01 July 2007 to 02 September 2007

Registering of external Sources and reviewing jobs created to see if the are done according to specification. Building of the schedule and assisting in the testing process both UAT and IAT and to take this project into production

Current Accounts

01 September 2007 to 2nd Feb 2008

Reviewing jobs created to see if the are done according to specification. Building of the schedule and assisting in the testing process both UAT and IAT and as well to take this project into production

ACA

10 September 2007 to 15 February 2008

Registering of external Sources and reviewing jobs created to see if the are done according to specification. Building of the schedule and assisting in the testing process both UAT and IAT and to take this project into production

NCA

01 September 2007 to 31 December 2009

Reviewing jobs created to see if the are done according to specification. Building of the schedule and assisting in the testing process both UAT and IAT and as well to take this project into production. I had assist in the creating the report for SARB for the 3rd Quarter

Current Account Migration

02 December 07 to 31 May 08

This is phase 2 of Current Accounts. Reviewing jobs created to see if the are done according to specification and as well to build AR_X_CL job. Building of the schedule and assisting in the testing process both UAT and IAT and as well to take this project into production

Savings Phase 2

15 February 08 to 28 June 08

Filling in the GAP that where identified in the review process by the BA’s

Homeloans file registration

11 February 08 to 1st April 08

Registration of Homeloans using Binary files and DLGGEN layout

Classification Register loading

01 January 07 to date

Loading of classification register occurs at least 2 a week

Treasury

04 February 08 to 31 May 08

Assisting with the delivery of treasury project from source registration to Reviewing the jobs

Probe

4 February 08 to 31 May 08

POC of probe, proving that we can register and load probe files with out a problem

Personal Loans

4 February 08 to 31st March 08

Extracting, transformation and loading Personal Loans data into sor tables, assisting with UAT and IAT in qa and building of the schedule. Monitoring the Jobs in production

EVRS BI Migration

4 February 08 to 31st March 08

Extracting, transformation and loading EVRS data into sor tables, assisting with UAT and IAT in qa and building of the schedule. Monitoring the Jobs in production

Probe BI Migration

4 February 08 to 31st March 08

Populating the behavior rating for individual clients and companies

Operational Support

1 January 09 to 31-Jan-2012

Support and maintaining the data loading and integrity of the warehouse as well as given advice on how to solve issues that we pick up

Data Mart Development

1 June 2010 to 31-Jan-2012

Extracting data from the data warehouse and building mart for different users in the bank in different divisions

Responsibilities :

-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

Reason for Leaving : Career Move

6. Company Name : Knowledge Integration Dynamics (KID)

Position : Junior BI Consultant

Year : 01-December-2005 –to- 31-May-2006

Courses : Microstrategy 8, Informatica Essentials, Informatica Advanced, Datastage (Self Study)

Projects

Client

Project Definition

Date

Duties

Tiger Brands

Extraction, Transformation and loading of monthly data (Datastage)

25th Jan to-10th Feb 2006

Extraction, Transformation and loading of monthly data

MTN

Extraction, Transformation and loading of data for the Executive Dashboard(Informatica)

13th Feb to 31-May-2006

Extraction, Transformation and loading of data for the Executive Dashboard

Responsibilities :

- Data Cleaning, Manipulation & Transformation using Datastage and Informatica

- Developing and maintain executive dashboard to monitor sms and please calls

Reason for Leaving : Career Move

7. Company Name : Sasuka Channel

Position : Junior SAS Consultant

Year : 01-June-2005 –to- 30-November-2005

Courses : SAS 9 Management Console, SAS Enterprise Guide, SAS 9 Stored Processes, SAS 9 ETL Studios & SAS Enterprise Guide 3.0

Projects

Client

Project Definition

Date

Duties

Stats SA

SAS 9 Implementation & Migration

4th July to-21 July 2005

We had to install SAS9 on the server and migrate user from individual Workstation SAS to Server Based SAS. We also had to migrate user from SAS version 8.2 to SAS 9.

SAS Institute

SAS Kenya Airways (KQ) POC

12th Sep to 04th Oct 2005

I had to proof the capabilities of SAS on the following aspects ETL, BI and Analytics for KQ. I was responsible for the ETL part (Data Cleaning, Manipulation & Transformation). As well as Data Analysis.

Responsibilities :

-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

Reason for Leaving : Career Move

Responsibilities Nedbank :

-Delivering programme designs in accordance with risk and compliance requirements and by using the appropriate programming language

-Understand and documents client requirements and specifications

-Analyzing and making proposed design recommendations

-Program design

-Maintain and enhance existing applications

-Identify and resolve work obstacles and problems effectively by providing 1st level problem solving, support and service via call out and standby in line with policy and procedure

-Participate in the full testing cycle, including but not limited to unit testing, requirements testing and integration testing

-Ensure integrated testing by building test cases

-Documenting unit test results related to own work

-Participate in code reviews

-Capturing data

-Code contention management Working with a group to identify alternative solutions to a problem

-Working with a group to identify alternative solutions to a problem

-Root cause analysis

-Maintaining technical documentation

-Support and maintenance of production as well as development

INTEREST AND HOBBIES

Hobbies : Reading, listening to Music Watching Television and Movies

Sports : Playing Cricket

Skills

Software /Programs I Can use are as follows:

1.SAS 8.2 & 9.1.3 ( Base, DI Studio and EG)

2.Data flux (Profiling tool)

3.Control M Enterprise

4.LSF and Platform Scheduler

5.Informatica

6.Datastage

7.Microstrategy

8.Microsoft Word, Excel, PowerPoint, Access

9.Windows 95, 98, 2000, ME, NT 4.0 and XP

10.Rational Rose C++(UML for System Analysis)

11.Assembly Language (PIC 16F877 Microcontroller & Microprocessors 8086 and 8088)

12.Html and SQL

13.Altera Max +Plus 2(For PLA programming)

14.A+ and N+ (Self Studying)

15.Networking Skills (Planning, Installation, Maintance and Support)

16.Matlab (Mathematics Computer Program)

17.PC building, Upgrading and Repair

18.Linux Redhat 9.0 and Mandrake 9.2 operating systems

19.MySQL and PHP (Self Studying)

20.ASP/ASP.net and Visual Basic/VB.net (Self Studying)

21.C and C++ (OOP)

22.IT support and Maintance

ACHIVEMENTS

1. I represented the LIMPOPO Province in a competition Called MINQUIZ in 1998.

2. I received a merit award of R500.00 for getting 3 distinctions out of the 4 subjects that I was doing in the year 2001 (1st semester).

3. I was selected to be a Peer Tutor for Microprocessor III and Logic Design III in the year 2002

(2nd semester).

REFERENCES

1. Name : Mr J.D Harris Dewey (Lecturer (Logic Design 3)

Tel Number : (011-***-****

2. Name : Mr. Samuel Manyama (Ex-Co-Worker at Sasuka)

Tel number : 082-***-****

3. Name : Mr. Tiyani Sondlane (Co-worker at Nedbank)

Tel Number : 082-***-****

4. Name : Mr. Zuza Mkhize (Co-worker at Nedbank)

Tel Number : 073-***-****

5. Name : Mr. Thulani Mphanga (Co-worker at MTN)

Tel Number : 083-***-****

Contact this candidate