Data Analyst Scientist

TEBATSO BRIDGET MADISA

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

0184

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

Cell:079*******

Cell2:072*******

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

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

CAREER OBJECTIVE:

Data Analyst and BI Analyst/ Data Scientist/Quantitative Analyst position requiring strong Analytical skills or Research within the Statistical discipline. CAREER SUMMARY:

2001 – 2005: Clapham high school (Matric)

2006 – 2010 (June): Bachelors (Hons.) Degree Majoring in Statistics and Economics)

2010 (Nov) - 2011 (May): Work and Travel USA

2011 (June) - 2011 (Dec): Assistant Researcher (University of Pretoria)

2012 - 2012 (Sept): Assistant Lecturer (University of Pretoria)

2012 (Oct) - 2013 (Sept): MSc. Statistics (Coursework): KU Leuven (Belgium)

2014: Statistical Analyst - One Month Volunteer (Impact International Research)

2014: Admin Assistant (National Research Foundation)

2015 - 2016: Student Researcher (Studentship) (CSIR)

2017: Tutoring students, Marking papers and freelance work.

2018: Data Science Trainee: Bytes Technology (Altron).

2019: Freelance work while lookin for employment.

2019 (Nov) - 2020 (April): Data Analysis/Insights: Cost Accounting: FNB

2020 (May): Research Proposal with Medical University of Southern Africa.

2021 (Aug) – 2021 (Nov): Data Modeller: Reverside contracted to ABSA

2022 (June) - 2023 (Feb): Senior Analyst (Data/BI Analyst): Broll Property Group

2021-2022: MSc. in Statistics (Dissertation)

2023 (May) - 2023 (Nov):

MSc. in Statistics (Dissertation) proofreading and Publication.

Proofreading and performing Statistical consulting for MSc students as a freelancer in order to provide them with the most possible statistical analysis they can use for their data. EDUCATION:

Matric (Clapham high school)

Bachelors (Hons.) Degree Majoring in Statistics and Economics (University of Pretoria) MSc. Statistics (Coursework): KU Leuven (Belgium)

MSc. in Statistics (Dissertation) (Medical University of Southern Africa) RELEVANT SKILLS AND ACCOMPLISHMENTS PROGRAMMING AND TOOLS:

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

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

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

• 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), Azure, MSSQL, MySQL

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

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

• SSIS, SSAS, SSRS

• 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 incredibly determined and a diligent worker. I am very much willing to learn from others. Have effective communication skills and computer skills. I consider myself competent, dependable, and responsible. WORK EXPERIENCE:

1. Developer: TransUnion (Temp) (Aug 2024 - Nov2024) Duties Included:

• Administering the process for requesting information from the big data Team and reporting to the Big Data Manager

on all the requests processed each month.

• Building and delivering key reports in Tableau and or any other TU preferred tool

• Assisting the TU Departments including but not limited to Marketing / ISG / Sales department with product

development utilizing the Data on Hive

• Assisting users in customizing and automating reporting solutions.

• Ensure accurate, compliant reports with business value are being delivered according to big data Reporting

Standards.

• Facilitation and alerting of Data Quality issues.

• Assist in the testing of new data sets

• Development, maintenance and automation of specialized reports.

• Creating Ad hoc reports by using appropriate tools

• Data analysis / profiling tasks.

Reason for Leaving: Temporary employment for project 2. Senior Analyst (Data/BI Analyst): Broll Property Group (Jun 2022 – Feb 2023) Duties Included:

• T-SQL on Azure, Microsoft server management studio to extract data from different databases for Analysis.

• Perform data cleaning and profiling before analysis (i.e.: dealing with missing data, correlations, duplicates etc.)

• Perform data transformations where needed for formality within data.

• Used a lot of CASE statements in T-SQL to formalize data.

• Training on T-SQL and Synapse was provided by me to call center agents on how to extract data.

• Pivot tables to analyse data for trend analysis.

• Formulae for calculations including if statements to extract specific data.

• Worked extensively with VLOOKUP’s and MATCH statements for mapping data from different spreadsheets.

• Weekly, Quarterly, and Monthly Reports by embedding SQL into Power BI or Excel.

• Dashboards – Weekly, Quarterly, and Monthly Reports/Dashboards for different clients.

• Power BI automated reports for specific clients upon request.

• Worked extensively with DAX in Power BI to create calculated measures and columns.

• Client engagement to acquire reports specifications and adjustments.

• Client engagement on updates.

• Ad hoc Queries on a daily for internal clients for data extraction and to find anomalies in the data.

Reason for Leaving: Contract ended. Looking for a better opportunity. Data Modeller: Reverside contracted to ABSA (Aug 2021 – Nov 2021) Duties included:

• Pivot tables to analyse data for trend analysis.

• Oracle SQL developer to extract data for Analysis.

• Perform data cleaning and profiling before analysis (i.e.: dealing with missing data, correlations, duplicates, etc.).

• Perform data transformations where needed for formality within data.

• Used a lot of casing statements in T-SQL to formalize data.

• Used Kibana to investigate anomalies and missing data.

• Formulae for calculations and if statements to extract specific data.

• Worked with VLOOKUPs for mapping data from different spreadsheets.

• Validations and BI testing for Absa Streams daily by verifying those different platforms has the same amounts for transactions.

• Client engagement on a daily basis to discuss missing transactions from different streams, locally and international banking

• Dashboards – Power BI for visualization only

• Kibana – extraction of data using indexes for specifically loan validations that are pending approval.

• Investigation of the reasons why they are still pending approval (Mainly due to missing documentations).

Reason for Leaving: 3 Months contract project helping with data extraction/data quality for the data modelling team.

Data Analysis/Insights: Cost Accounting: FNB (Nov 2019 – Apr 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 database to check if all the data available, run analysis to check for duplicates and missing data etc. for Data Quality.

• monthly ran 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 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 (Ad hoc queries) and or doing trend analysis.

Reason for Leaving: 6 Months fixed term contract filling in for an employee who was on Maternity Leave.

2. Data Science Trainee: Bytes Technology (Altron) (Jan 2018 – Aug 2018) The focus was on Python and R for analysis. Machine learning algorithms which comprised of Supervised and Unsupervised learning was used. 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 analyse 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 new software’s that deal with big data.

• KNIME – for data mining

• Spark – Python library for SQL

Reason for Leaving: Outsourcing company (Company finds you employment after the contract ends--not guaranteed)

5. Graduate Student: CSIR: (Apr 2015 – Dec 2016)

Master’s by research studentship.

Duties were for me to complete my research Proposal for my degree. I was an independent worker as mentioned in my motivation.

6. Administrative Assistant: National Research Foundation: 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 applications were captured and monitored for progress. We calculated the budget that was available and compared it to how much was needed using advanced Excel methods.

Reason for Leaving: Better Opportunity in terms of my Career Objectives, Joined CSIR. 7. Assistant Lecturer: University of Pretoria (Statistics) (Feb 2012 – Sept 2012) 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 were 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.

9. Assistant Researcher: University of Pretoria (Econometrics) (Jun 2011 – Dec 2011) Duties were assisting Lecturers on Research and basic computer editing of Documents. Drafting articles for the University of Pretoria work in progress Journal. Research was using time series analysis for forecasting economic data. Reason for Leaving: Student work while studying.

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