Data Analyst

ADEL

Namibian citizen based in Windhoek, Namibia.

Profile

Data Scientist with background in socio-economic research, consumer market research and applied statistics in the finance-, public enterprise- and energy industries. More than three years of hands-on experience in developing strategy and methodology for solving complex applied problems using R, Python, Excel and SPSS. Experience in leading cross-functional teams in the pharmaceutical and research industries for the past nine years. Core Skills

Programming Skills (SQL, Python, R, KNIME, Neo4j) Endurance Statistical Analysis Strategic Thinking

Data Wrangling Problem Solving

Data Visualization & Communication Collaboration

Data Intuition Prioritization and organization

Machine / Statistical Learning Adaptability

Work Experience

Geka Pharma, Windhoek, Namibia October 2016 – current Data Scientist / Cost Accountant

• Monitor and maintain cost prices and selling prices of 10 000 SKUs in one of the only Pharmaceutical Wholesalers in Namibia.

• Design diagnostic reports alerting managers of critical issues within their departments, e.g. reports to measure when stock levels reached critically low levels, or when a buyer was about to place an order for the wrong quantity.

• Advise top management about strategic decisions in terms of stock holding or movement.

• Lead a small agile team consisting of the IT Manager and pharmacists in an ERP system change.

• Run monthly reports for accounting department.

• Present findings from complex data and analyses to non-technical audiences. Key Achievement:

• Created value by automating existing reports into a BI tool, by collaborating with the IT Manager. Creating additional reports to track functions within the business, e.g. to detect when products that were out of stock were received; detect when a certain product within a warehouse runs out of stock; to keep track of critical/high value medicine to prevent stock-outs. These reports help the business function optimally when utilized by the different functions within the team. Technology/tools used: R, SQL, Excel, SpagoBI, ACS Embrace, OpenRefine Vision Africa Research Services, Windhoek, Namibia January 2014 – September 2016 Research Executive

• Managed, planned, and executed qualitative and quantitative market research projects for companies in the FMCG market, banking sector, among others, e.g. Milward Brown, Nielsen, TNS, KFC, Namibia Breweries, Namib Mills, several telecommunications companies, and banks.

• Conducted experiments such as taste tests for new flavours of soft drinks and beer.

• Provided stakeholders with strategic analysis and recommendations by means of client-facing presentations as well as detailed reports.

• Lead large teams of supervisors and interviewers to conduct national research projects such as media- and consumer- usage surveys (flagship product of the company).

• Lead smaller teams of interviewers to conduct e.g. customer satisfaction surveys, mystery shopping.

• Data cleaning and manipulation, data analyses, report writing, facilitation of focus group discussions. Key Achievement:

• Was promoted to senior research executive and was offered shares in the company.

• Added value by commitment to getting projects done on impossible budgets. Technology/tools used: Experimental Design, Excel, SPSS, Word, Power Point, SWOT analysis ADEL

Survey Warehouse, Windhoek, Namibia January 2012 – December 2013 Statistician

• Constructed a Financial Literacy Indicator for the Ministry of Finance, in cooperation with GIZ (German Agency for International Cooperation), to measure programmes implemented in Namibia to uplift the economic situation of the poor.

• Designed questionnaires to measure the effectiveness of international aid programmes in Namibia, e.g. USAID’s programmes in lowering maternal and infant mortality rates in Namibia.

• Provided stakeholders with strategic analysis and recommendations by means of client-facing presentations as well as detailed reports.

• Sampling design for research projects in the socioeconomic field and training of enumerators on sampling procedures

(Design included calculation of margin of error for reporting purposes).

• Used multivariate analysis e.g. principle component analysis (PCA) to perform dimensionality reduction, multivariate regression analysis.

• Feature engineering to build a financial literacy indicator.

• Used behavioural-, attitudinal- and engineered knowledge features to create a financial literacy indicator.

• Data cleaning and manipulation, data analysis, report writing.

• Mainly worked with behavioural and socio-economic data.

• Compiled proposals to clients regarding quasi-experimental designs. Key Achievement:

• Development of the Financial Literacy indicator that would be used by the Ministry of Finance and GIZ to measure progress in Financial Literacy in future, starting in 2012. Technology/tools used: Principle component analysis (PCA), correlation analysis, multivariate regression analysis, SPSS, Excel Freelance Data Scientist 2012 – current

Project: Performance Management in Public Enterprises 2019 Outcome: Provided statistical consultation and technical analysis to a strategic analyst to build an indicator to measure performance management in Public Enterprises for the Ministry of Public Enterprises of Namibia. This indicator would then be used to help make clear assessments of and comparisons between public enterprises over time. Industry / Company: Ministry of Public Enterprises & GIZ (German Agency for International Cooperation) Technology/tools used: SurveyMonkey, Excel, Word, statistical analysis (PCA, correlation analysis, Cronbach’s Alpha) Project: Financial Capability 2018

Outcome: Conducted the data cleaning, feature engineering, data analyses and report writing of the Financial Capability study that sprouted from the Financial Literacy study of 2012. Recommendations were made to inform stakeholders how to improve their programme to be more effective.

Industry / Company: Ministry of Finance & GIZ (German Agency for International Cooperation) Technology/tools used: SPSS, Excel, Word, statistical analysis (PCA, correlation analysis, multivariate regression analysis, Cronbach’s Alpha)

Project: Customer Experience Tool 2016

Outcome: Assisted the MD of Afrox Namibia, (the largest gas supplier in Namibia) in developing a tool to measure customer experience in his company by applying Cronbach’s Alpha to determine the variables of importance. Industry / Company: Energy, Afrox Namibia

Technology/tools used: Cronbach’s Alpha, Excel, Word, statistical analysis Education

UC San Diego, California, USA • Graph Analytics for Big Data 2018

(Online: Coursera) • Machine Learning with Big Data 2018

• Big Data Integration and Processing 2017

• Big Data Modeling and Management Systems 2017

• Introduction to Big Data 2017

UC Davis, California, USA • SQL for Data Science 2018

(Online: Coursera)

Stellenbosch University • Bachelor of Commerce (Hons) in Statistics 2011 Stellenbosch, South Africa • Bachelor of Commerce in Economical Science 2010

Contact this candidate