Data Analyst
Resume:
Kelvin N Muriuki
801-***-**** *************@*****.*** 488 S 910 W, UNIT 104 Pleasant Grove, UT 84062 Education
Master of Statistics - Econometrics Jan 2019 - Dec 2020 The University of Utah Salt Lake City, UT
• GPA: 3.7/4.0
Bachelor of Economics and Finance Sep 2011 – Aug 2015 Kenyatta University Nairobi, Kenya
• GPA 3.7/4.0
Technical Skills
Data Analysis
The University of Utah Salt Lake City, UT
1. Using R:
• Stat 6969 Practical Data Science: Manipulating big data, statistical data modelling, data visualization, statistical cross validation, predictive modelling, data presentation and reporting using rmarkdown.
• Econ 6630 Applied Econometrics: generalized linear and nonlinear regression, single and multivariate regression, OLS, maximum likelihood estimate, causal inference and hypothesis testing.
• Econ 7801 Econometrics II: Linear and nonlinear univariate and multivariate time series model, Likelihood-based inference, hypothesis testing and model comparison, forecast evaluation, structural identification.
Project: “Time Series modelling with application to Kenya’s inflation data comparison of ARIMA models”. Used Univariate modelling technique to come up with the best ARIMA model used for inflation forecasting.
2. Using Stata:
• Econ 7590 Econometrics and Econ 7800 Econometrics I: statistical modelling and testing using endogeneity and instrumental variables, binary qualitative variables, multicategory qualitative dependent variables, limited dependent variables, panel data. Project, “ Household Choice of Healthcare Provider in Kenya” used unordered multinomial probit model to analyze the social economic and demographic factors. 3. Using SQL:
• Successfully completion of Stat 6969 project using the combination of both SQL and R skills
“The Midwest Demographic Analysis”.
Accounting
Brainsway Business College Nairobi, Kenya
• Statement reconciliation and reporting using sage, quickbooks and pastel. Work Experience.
Front Counter Assistant Oct 2019 – Present
The University of Utah Salt Lake City, UT
• Perform daily cash reconciliation and deposits
• Assist with data entry
• Provide parking and transit information to customers.
• Accept payments for parking permits and tickets.
• Answer telephone calls and respond to customer’s emails.
• Schedule appeals and appointments.
Junior Data Analyst Jan 2018 – April 2018
Sparks Assurance Nairobi, Kenya
• Structuring of large data set to find relevant usable information.
• Creating reports, analysis and presentation based on the recommendations.
• Data visualization to give a clear picture to the involved stakes.
• Managing assigned master data and collaborating with a team of analysts in creation, deletion and updates.
Credit Analyst /Controller Jan 2017 – Dec 2017
Melchizedek Hospital Nairobi, Kenya
• Preparing reports and assessing the degree of risk associated with individual insurance companies.
• Creation of revenue projections based on the past data (predictive modelling).
• Evaluating the financial status of clients both insurance and individual patients.
• Negotiate payment plans with different insurance companies and set up conditions.
• Improve and implement debt collection processes when they are any overdue payments and initiate legal procedures if necessary.
Problems Identified and Solutions.
• Monthly to daily updates of account statements.
• Effectively initiated business cycle meeting held at the beginning of every week.
• Effectively initiated the monthly meetings with the involved stakes from different Insurance Companies.
• Initiated revenue forecasting/predictive.
Benefit: Increased revenue collection by eleven million. Claim Administrator Sep 2015 – Jan 2017
Melchizedek Hospital Nairobi, Kenya
• Processing insurance claims ready for dispatch to different insurance companies.
• Managing and coaching the front counter team.
• Dealing with customers’ complains and appeals.
• Making sure claims are dealt with according to industry regulations. Problems Identified and Solutions
• Monthly to Weekly processing and dispatch of insurance invoices. This increased efficiency through attention to detail. Reduced invoices backlog and lost. Benefit: Reduction of lost invoices and attention to details reduced rejection rate by insurance companies. Leadership and Services.
President May 2017 – Dec 2017
Melchizedek Red Cross Nairobi, Kenya
• Organised healthcare awareness event at different towns within Nairobi. Provided free consultation and testing for diabetes and eyes.
• Liaised with Ngong Municipal Council in cleaning of Ngong Market.
• Successfully negotiated reduced hospital visit fee for children homes and care centers. Organising Secretary Sep 2013 – Sep 2014
Kenyatta University, Economics club Nairobi, Kenya
• Organised career fair within the University. Invited guest: Ipsos Synovate Human Resource Director, Melchizedek Hospital CEO, Rafiki Bank CEO.
• Organised event for tree planting. This help awareness to conserve environment within Kenyatta University Market.
• Organised corporate visit to National Treasury, Centum Investment Group.
• Initiated a plan that raised and contributed funds to children homes. Awards.
• Recipient of employee's prize of the year 2016 at Melchizedek Hospital. Increased salary payroll by 85%.
• Sponsorship for Leadership training program for being among the best 3rd year economics student at Kenyatta University.
• Recipient of economic prize for being the best 4th year student in game theory at Kenyatta University.
Referees
Dr. Paul Gachanja Dean - School of Economics
Kenyatta University
Contact Address: P.O. Box 43844, 00100 Nairobi
E-Mail: ********.****@**.**.**
Phone: 254 020-*******-** Ext.3620
Professor Haimanti Bhattachrya Professor, Economics Department The University of Utah
Contact Address: 322 S 1400 E Room 222
Salt Lake City, UT 84112
Email: ********.************@*********.****.***
Phone: 801-***-****
Mr Simon Karo Chief Executive Officer
Melchizedek Hospital
Contact Address: P.O. Box 200**-*****
Email: *****@**********.**.**
Phone: +254*********
Contact this candidate