Data Analyst Front Desk

TEBATSO BRIDGET MADISA

*** ********* ****** *********,

Pretoria, 0184

Home: (012-***-****

Cell: 079*******

Cell2:072*******

*******.******@*****.***

******.*******@*******.**.**

ID: 860**********

CAREER OBJECTIVE:

Data Scientist/ Data Analyst/Quantitative Analyst position requiring strong Analytical skills or Research within the Statistical discipline.

EDUCATION:

2001 – 2005 Clapham high school

Subjects: Mathematics (HG), Physical Science (HG), Biology (HG), English (HG), Afrikaans (HG), Computer science (SG)

Highest level passed (2006-June 2010):

Bachelors (Hons.) Degree Majoring in Statistics and Economics 2006-2010: Bachelor of Commerce (Statistics): University of Pretoria Modules: Financial Accounting, Economics, Commercial Law, Business Management, Information systems 1(System analysis and design, programming with Visual Basic 2005)

Information systems 2 (Database design, systems architecture) Communication management

Statistics (Regression, Multivariate techniques, Sampling, Time Series Analysis, Forecasting techniques, Statistical Process Control) 2012-2013: MSc. Statistics (Coursework): KU Leuven (Belgium) Modules: Experimental Design, Structural Equations Modelling, Sampling Theory, Survey Methodology,

Basic Concepts of Statistical Modelling,

Linear Models: Regression Analysis and Analysis of a Variance Statistical Software’s

Statistical Consulting

Concepts of Bayesian Data Analysis

Concepts of Multilevel, Longitudinal and Mixed Models Multilevel Analysis

Total Quality Management

Generalized Linear Models

2021-2022- part-time (In Progress- completion November 2022): MSc. in Statistics

(Dissertation)

(Sefako Makgatho Health Science University)

RELEVANT SKILLS AND ACCOMPLISHMENTS

PROGRAMMING AND TOOLS:

• Access, PowerPoint, MS word, Pastel, SQL (T-SQL), MATLAB, VBA 2006, and SAS

(Statistical Analysis Software), SPSS (Statistical Package for Social Sciences): University of Pretoria)

• Advanced Excel (VLOOKUP’s, Pivot table, Cubes, Formulas, If-Statements, Graphics)

• SAS (Base SAS, SAS/STAT, SAS/Graph, SAS/IML, SAS/TES; Macros; Enterprise Miner; Enterprise Guide)

• R/RStudio, Python – Bytes technology --Altron

• SQL (T-SQL)

• MLwin, and Mplus, Lisrel, Win bugs, R (KU Leuven)

• Networkx, Neo4j, GraphX, Java, Json, Knime, Spark, NoSQL, Tableau, Power BI-DAX

(Bytes)

• Fluent in English, Tswana (Verbal and Written), and Afrikaans as a second Language.

• Member of the Public speaking team and Athletics (Matric)

• Mentor for first year students (University of Pretoria) LEADERSHIP: First team athletics and netball.

OTHER:

I am very determined and a hard worker. I am very much willing to learn from others. Have good communication skills and computer skills. I consider myself competent, reliable, and responsible. PROJECTS ACCOMPLISHED

The first project I was involved in is a research project in partial fulfilment of my BCom (Hons) degree. The research project involved me working as an individual under supervision. My topic was based on Repeated-Measures Designs, which is mostly associated with Behavioural sciences and meta- analysis. Repeated-Measures Designs involve measuring subjects more than once to determine statistically significant change over time. The designs can be effectively used in determining how effective certain medications are on certain people; or how effective rehabilitation is on certain people where the period variable is time. Statistical Analysis software such as SAS (Statistical Analysis Software), SPSS (Statistical Package for the Social Sciences) was used for analysis. The Second project I was involved in is a research project which was done in a group with two of the Master students from Philosophy faculty at the University of Pretoria. It was based on the out of sample forecasting ability of India’s Industrial production. Incorporation was Economics, Econometrics, Time-series Analysis and Data Mining. WORK EXPERIENCE:

1. Junior Analyst/Data Modelling: ABSA

From 10/08/2021-30/11/2021 (Contract ended—not renewable based on the project been finalised):

Duties included:

Oracle SQL developer to extract data for Analysis.

Pivot tables to analyse data for trend analysis.

Formulae in Excel for calculations.

Validations and BI testing for Absa Streams daily.

Dashboards – Power BI for visualization.

Kibana – extraction of data using indexes.

Reason for Leaving: 3 Months contract helping with data extraction for the data modelling team. 2. Data Analysis/Insights: FNB finance Costing division Johannes Matome:

From 25/11/2019-30/04/2020

Duties included:

Create, and amend stored procedures that run monthly. Ran the stored procedures monthly to pull data from different online platforms at FNB – finance division – costing purposes.

checking on the raw database to check if all the data available, run analysis to check for duplicates, missing data etc for Data Quality.

monthly run the stored procedure, extract data from different online platforms using T-SQL.

Perform trend analysis to discover any decrease/increase in the number of clients coming in or check for outliers.

Trend analysis and dashboards using Excel and using Power BI through exporting data from SQL.

Other reporting tool was SSRS.

Stakeholder/management meeting after analysis to discuss increases/decreases in trends. How to amend the stored procedure to increase clients on the online platform.

Daily duties extracting data from different databases and or doing trend analysis. Reason for Leaving: 6 Months fixed term contract filling in for an employee who was on Maternity Leave.

3. Big Data Analyst Trainee: Bytes Technology (Altron)– 8 Months fixed Traineeship Nafisa Abdool:

From 12/01/2018-31/08/2018

The focus was on Python and R for analysis. Machine learning algorithms which comprised of Supervised and Unsupervised learning was utilised. To model relationships and dependencies between the target prediction output and the input features, common algorithms used was Regression. For classification purposes, Naïve Bayes, K Nearest Neighbour, Decision Trees (with the use of KNIME) was utilized. Unsupervised learning algorithms for descriptive modelling and pattern detection, K-means clustering and Association rules we utilized.

NoSQL from the python library (PySpark) was used to extract tables from the database. Visualization techniques utilized were BI and Tableau. Informatica was utilized for ETL. To analysis social media data, graphX, networkX and neo4j was utilized. Training on Big data pipelines, Deep learning, TensorFlow and Teradata Studio was provided. The focus of my individual project was Spatial Analysis where I used geopandas, geoanalytics for cluster crime patterns in South Africa according to location using Python. Other:

90% data analysis and presentation.

Data Quality assurance through cleaning up data before analysis.

Performing analysis based on Statistical analysis, Machine Learning.

Used Python, R-Studio (SAS, SPSS) for analysis.

Machine Learning algorithms used was Supervised Learning and Unsupervised Learning depending on the business objective.

Worked on 65% of the python libraries for analysis.

Worked on knew software’s that deal with big data

- KNIME – for data mining

- Spark – Python library for SQL

Reason for Leaving: Outsourcing company.

4. Studentship: CSIR:

Dr. Pravesh Debba:

From 01/04/2015-31/12/2016

Masters by research studentship. Duties was for me to complete my research Proposal for my degree. I was an independent worker as mentioned in my motivation. 5. Internship: National Research Foundation: From 01/04/2014-30/09/2014. Duties were administration of grants. Application of grants were received from different universities. We capture them on the system and send them to the DA for evaluation. The accepted application was captured and monitored for progress. We calculated the budget that was available and compared it to how much was needed. Advanced methods of excel was utilised

Reason for Leaving: Better Opportunity in terms of my Career Objectives, Joined CSIR. 6. Quantitative/ Statistical Analyst: Impact International Research - Volunteer work Internship for one month from: 01/04/2014 – 30/04/2014 Professor Chiroro:

Duties were capturing data in SysPro, transferring data to appropriate software for analysis

(SAS/SPSS). Quantitative analysis on Social data from the department of social development was mostly used. Report writing on the findings of the data analysis were produced and presented.

Reason for Leaving: Volunteer work without Pay.

7. Assistant Lecturer: University of Pretoria (Statistics) From: 01/02/2012 – 30/09/2012

Mr Millard

Duties were marking and tutoring in Statistics department. Tutored first year and second year Statistics students with SAS, Regression analysis and Time series Analysis.

Tutoring in Regression Analysis was based on cleaning up the data before analysis. Exploratory analysis based on scatter plots was used to identify outliers. Multiple regression to find relationships between variables was used. Based on the regression analysis, determining the best model had to be identified. How to check for multicollinearity, heteroscedasticity, and serial correlation, how to correct for them was also part of the tutoring.

Time series tutoring was based on ARMA (Autoregressive models) and ARIMA

(Autoregressive integrated models). Checking for stationarity in time series models and correcting for non-stationary models.

All analysis was done using SAS and SPSS.

Reason for Leaving: Student work while studying.

8. Assistant Researcher: University of Pretoria (Econometrics) – 6 months Fixed Contract From: 01/07/2011 – 30/11/2011

Professor Gupta

Duties were mainly assisting Lecturers on Research and basic computer editing of Documents. Writing articles for the University of Pretoria work in progress Journal. Research was mainly using time series analysis for forecasting economic data. Reason for Leaving: Student work while studying

9. Receptionist: Fairmont Hotel Aventura Florida (USA) Work and Travel USA

From 30/11/2010-30/04/2011

Duties were accepting guest at front desk to check in. providing them with requested rooms and assisting them to their room.

Reason for Leaving: Work and travel opportunity as a Student. Completion of Studies upon Return.

Certifications: https://www.linkedin.com/in/tebatso-madisa-14250357/ Licenses & Certifications:

Applied Machine Learning in Python

Applied Text Mining in Python

Big Data Project: Capstone

Essential Design Principles for Tableau

Graph Analytics for Big Data

Introduction to Data Science in Python

Applied Plotting, Charting & Data Representation in Python

Introduction to Big Data

Big Data Integration and Processing

Big Data Modelling and Management Systems

Fundamentals of Visualization with Tableau

Contact this candidate