Analyst

Ms Asanda Mxawuka

E-mail: *******@*****.***

Mobile: +27-71-97-56-175

Identity Number: 850-***-**** 087

Gender: Female

Race: Black

Education

Tertiary Institution: University of Fort Hare (Completed in 2011)

BSc Honours (Applied Statistics)

Major Modules Completed:

Multivariate Statistical Methods Time Series Analysis

Research Methodology Random Effects Modeling

Applied Multivariate Statistics Fixed Effects Modeling

Tertiary Institution: University of Fort Hare (Completed in 2010)

BSc (Computer Science and Statistics)

Major Modules Completed:

Networking Operating Systems

Java Software Engineering

Advanced Statistics 1A Introduction to Applied Statistics 1B

Advanced Mathematical Statistics 2A Introductory Applied Statistics 2A

Secondary School: Sandi (Completed in 2004)

Matric Subjects Completed:

English, Xhosa, Mathematics, Physical Science, Biology, Agriculture

SAS Courses Completed (2012):

Programming1

Programming2

SAS Macro Language1

SAS SQL1

SAS Certification Review – Base

SAS Enterprise Guide

SAS Enterprise Guide: ANOVA, Regression and Logistic Regression

Statistics1: Introduction to ANOVA, Regression and Logistic Regression

Applied Analytics Using SAS Enterprise Miner

Accessing SAS from Micro Office Application

SAS Web Report Studio

Personalizing the SAS Information Delivery Portal

Creating Information Maps Using SAS

Stored Processes

SAS Platform Administration Fast Track

Creating and Administering Scorecard Projects

Work Experience

[Analyst] (May 2013 – Present)

[Discovery Health] (Sandton, Johannesburg)

Duties:

• Writing SQL queries to extract the data for the Hospitals, Specialists and Pharmacies from netezza tables and PL SQL tables.

• Running daily and monthly reports.

• Exporting the data into excel.

• Summarizing the data in Excel using pivot tables.

• Plotting graphs in excel to compare total paid for specific specialists.

• Converting PL SQL scripts to Netezza

• Sending the data to Forensics department for auditing.

[SAS Trainee] (February 2012 – January 2013)

[SAS Institute] (Houghton, Johannesburg)

SAS Graduate Development Programme Trainee. Trained in various SAS core areas including SAS Data Management, SAS Business Intelligence, SAS Analytics, SAS Platform Administration and SAS Strategy Management. Skills acquired:

• Extracting data using SAS software

• Using SAS programming to produce reports

• Producing report using SAS software (SAS Enterprise Guide)

• Producing reports with SQL

Also acquired soft skills through client meetings, project meetings and workshops.

Skills

Netezza, PL/SQL, Visual Basic, Java, C++

MS Office (Excel, Word, PowerPoint), Basic Statistical Analysis using SPSS, SAS

Analytical Reports, Design Presentations, Ability to work in a group

Achievements

SAS:

SAS Certified Base Programmer for SAS 9 – (2012)

References

Miss M. Makua - Consultant, SAS SA - (011-***-****

Mr. T. Nkosi - Researcher, CSIR - (082-***-****

Mr. I. Jubane - Lecturer: University of Fort Hare - (040-***-****

Contact this candidate