Serah W. Karubi
Email: *****.******.***@*****.*** Mobile: +1-813-***-****
RESULTS DRIVEN DATA ANALYTICS PROFESSIONAL
Competent, innovative and high performing data analytics professional with a wealth of experience in diverse industries including Marketing, Health, Retail, Fintech and Insurance.
TECHICAL SKILLS
Python Tableau Alteryx Snowflake SQL server’22 Power BI Excel Power Automate Scrum Master
DATA ANALYTICS PROJECT EXPERIENCE
IZEA Worldwide: Data analysis of Influencer campaign marketing data (’20-’22) records; in order to predict influencer compensation for various social media campaigns depending on the follower count, likes, comments, views, engagements, reach and weighted pricings. Analyze the effectiveness of campaigns and providing an assessment of whether the clients will find their campaign successful or not. Use of python machine learning (Random Forest, SVM, Gradient boosting etc.) and Power BI for creation of dashboards (www.izea.com)
Texas Health and Human Services: Health data analysis using Alteryx, Tableau, PowerBI and Snowflake, cleanup datasets, parsing columns, sampling data and adding calculated fields. Created various tableau dashboards using action filters, various charts such as funnel, waterfall and butterfly, various maps, landing pages with navigation buttons etc. Created stored procedures in Snowflake and SQL server for various stakeholders. . (www.hhs.texas.gov)
LSINC: Direct-to-Object printer project data analysis using 717 customer sales leads and their geolocations, the project lay the groundwork for the entry of the company into markets in Europe and North America. Using KMeans and Hierarchical clustering algorithms, to provide recommendation to the company using visual maps and clusters of high potential economic cities to target. (www.lsinc.com)
Insurance: Customer Insurance data analysis to produce customer segmentation profiles using data clustering algorithms and scoring measures such as pandas, numpy, DBScan. KMeans, Hierarchical, one hot encoding, performed supervised learning to predict number of claims and claim amounts that potential customers will make for the subsequent year, given the previous year trends.
Health: Analyzed clinical data of 768 pregnant women using various machine learning techniques, and the key attributes that are likely to lead to onset of diabetes were found to be Glucose, BMI and age in the order of preference.
PROFESSIONAL PROFILE
IZEA Worldwide: Data Analytics and Strategy Intern: Jan 2022-Current
Data analysis of three years of influencer marketing campaign metrics and pricing executed on behalf of the company, to find out if their campaigns successful or not.
Predict the price of an influencer across various social media platforms
Time series forecasting across various social media platforms
Reports for high level and mid-level business teams for decision making
University of Alabama in Huntsville: Graduate Teaching and Research Assistant, May 2021–Dec 2022
Assist 2 College of Business lecturers in content creation for lecture notes, videos, grading and any administration work.
Data Research on the effect of pollutant emissions by manufacturing companies on public health indicators of chronic disease development in Texas using ArcGIS pro, R and Python programming.
Hello Tractor: Technical Project Manager, Mar 2019–Dec 2020
Ensure delivery of IT software projects of the Hello Tractor App and website using JIRA/JQuery, leading a team of 15 engineers located across the continent (Nigeria and Kenya).
Carry out daily scrum, UAT’s, SIT’s and Vendor management.
Account management of new and existing customer app builds and subsequent deployment with Vendors.
Kenswitch Limited: Project Manager, July 2017-Feb 2019
MS CRM/AX and several ATM switch project implementations with banks and PSP’s.
Document and prioritize business requirements, cleanup data and migration into the new system for comprehensive reports extraction using Power BI and SQL.
Tezza Business Solutions: Marketing Project Management Consultant, Nov 2015-Jun 2017
Brought on board key players to facilitate a key marketing and rebranding project worth KES 270 million for Cfc Stanbic Bank in Kenya and South Sudan.
Served as a Change Management Consultant with the Public Service Commission (PSC) to implement the outsourced ERP System. Gathered and analyzed business requirements and specifications and partnered with experts in diverse fields to design the final solution.
ACADEMIC PROFILE
University of Alabama, Huntsville ‘22: Master of Science in Business Analytics
Jomo Kenyatta University of Agriculture and Technology ‘07: Bachelor of Science in Computer Science Second Class Upper honors
Eastern and Southern African Management Institute ‘13: Master of Business Administration
MEMBERSHIP: Institute for Operations Research and the Management Science: Member number 1940424