Experience

• 

  Imperial bank

  Jan 2013 - Mar 2013

  Treasury intern

  - Providing financial market research and reporting to the head and treasury manager. This included daily stock market performance and currency trading ideas.- Foreign exchange sales. I performed currency transactions for various bank clients and companies. This involved finding best prices for currency and filling up orders- Treasury sales and transactions data entry. Maintain entries to the treasury blotter. This involved getting FX transaction reports every hour from different branches across the country and compiling into a blotter for reporting. Show less

• 

  Alternative agency. kenya -"building brands of the future"​

  Jan 2014 - Jul 2018

  - Coordinated and closely worked with the account management and business development team to come up with new digital products for current and new clients.- Worked with account management teams to create media buying strategies and budgets. - Implemented digital data collection strategies and reporting for different media buying campaigns. This included tooling for collecting data from google analytics and DSP providers and routing the data to visualization tools and using tools like R & Python to scrape tweets for data analysis.- Social media and Digital media reporting. This involved collecting, gathering, analyzing and preparing dashboards for day to day media and campaigns- Worked with an account management team to develop digital media demand generation strategies. Some of the companies include Internet Solutions, AAR, Jumia Party, Pernod Ricard etc.- In charge of coordinating and running digital customer surveys for clients. This included finding cost-effective and digital survey collection methods.- Run demand generation and digital sales campaigns. This included researching and implementing CRMs, DMPs and CDPs- Managed eCommerce sites for clients. Including and not limited to Jumia Party Kenya, Greenspoon Kenya- Digital transformation of client sales processes in the digital landscape. This included implementing tools technologies such as augmented reality and beacon technology.- Responsible for the Agencies digital transformation. This included moving the organization to productivity tools etc.- Run research and experiments on various tools. I introduced the concept of CDPs and DMPs within the agency. This lead to a reduction in reliance on CRMs- Grew media buying to a full demand generation department as opposed to just promoting posts on social media. - Responsible for training account managers and business development teams on new digital technology and tools. This also involved preparing a case for client adoption Show less - Financial management and planning for the company. This involved drafting up spending budgets and cash flow budgets for the company.- Managing investments and other financial instruments for the company. This involved selecting investable assets for the company including and not limited to shares and unit trust.- Receivables management and collections. Including but not limited to following up with clients for payments- Payables management. I ensured that all supplies of Alternative were paid and the company did not have any long-dated payable- Financial reporting and internal auditing. Coordinating with external auditors to make sure all financial reports were done and delivered in a timely manner.- Statutory filing and reporting. Ensure that all taxes and other statutory payments were done Processing employee payroll. Ensured that payroll was processed in time- In charge of procurement of Insurance for the company. This included medical and equipment insurance- Financial reporting to management and the board of directors. The main responsibility was making sure that the company directors and management were informed of the financial health of the company Show less - IT management. I ensured that the company sourced for the right laptops, coordinated repair of office IT equipment and internet connectivity- Accounting, petty cash management and bookkeeping. I was responsible for maintaining expenditure, receipts and petty cash flow - Collecting receivables and taking care of payables to suppliers. This was included but not limited to paying digital media influencers- Procurement of office assets and food for the employees.- Filing statutory requirements. This included but was not limited to VAT, NSSF etc- Supporting digital analytics and reporting roles. This involved data mining of Facebook and twitter insights to present to clients- Coordinated administrative procedures and systems.Including but not limited to the planning team excursions, cordinating taxi schedules. Show less

  • Digital Transformation & Innovation Manager

    Jun 2017 - Jul 2018

  • Head of Finance and Accounting

    Jan 2016 - Jun 2017

  • Accounting and Office Administrator

    Jan 2014 - Dec 2015
• 

  Wongachi farm - tissue culture banana farm

  Jun 2014 - Jun 2017

  Project & farm manager

  - Sourcing tissue culture banana seedlings from India. This involved looking for suppliers and coordinating importation and payments to suppliers.- Sales of over 100k tissue culture banana seedlings across western Kenya.- Coordination and planning with county governments of western Kenya who order most of the tissue culture banana seedlings.- Coordinating transport and delivery of tissue culture seedlings across western Kenya- Managed clearing and forwarding of imported tissue culture banana seedlings. This included taking care of all import tax, kephis certification and excise duty- Finance, accounting and bookkeeping of the whole project. This involved filing taxes, maintaining financial records and remittance of employee salary and farm worker payments- Procurement of farm equipment and farm inputs. This included bulk sourcing of farm inputs e.g. fertilizer, planting papers, planting nets from Nairobi and making sure they are delivered to the farm.- Managed a total of 60 employees including farmworkers.This involved making sure HR issues are taken care off, procurement of NSSF and NHIF.- Business development and marketing of the Tissue culture banana seedlings to county governments in western Kenya- Ensuring farm certification from Kephis and the county government. This involved coordinating with officials for farm visits, seeds and soil testing Show less

• 

  Apollo agriculture

  Aug 2018 - Sept 2022

  - Providing clean, tested, documented and transformed data. Data marts that summarized various business processes to allow more business users to be comfortable with SQL.- Building and maintaining reports and interactive dashboards in Tableau, Periscope and Redash.- Version controlling, testing and continuous integration of analytics code base inside dbt (data build tool)- Training users on how to use various BI tools. This included Tableau, Redash, Periscope, data marts and writing basic SQL.- Maintaining data documentation & definitions. This involved setting up dbt documentation on GitLab pages for the internal team.- Setting up dbt. This involved setting up test and production schemas, the project layout, database credentials.- Setting up CI/CD for the ditto project. This included setting and maintaining the gitlab ci file to take care for testing, debugging and running dbt project and deploying dbt docks- Monitoring and maintaining the ETL process. Updating the Stitch integration, debugging and monitoring errors- Prototyping a python based tool for logging database row difference between production and analytics database.- User and resource management of BI tools. Providing and setting up users in the analytics database, setting up users in Tableau and other visualization tools.- Prototyping new tools to solve analytics infrastructure problems. This included testing tools like Meltano for ETL, dbtvault a Data Vault 2.0 framework built on top of dbt, Singer an open-source tool for database replication, Splitgraph for data ingestion and modelling.- Building quick tools for data entry. This included building and maintaining an inventory system based on Typeforms and Retool for tracking warehouse and inventory transactions.- Using integration tools like zapier to connect data entry tools to the production database Show less

  • Software Engineer

    Sept 2021 - Sept 2022

  • Data and Analytics Engineer

    Aug 2018 - Sept 2021
• 

  Alternative agency. kenya -"building brands of the future"​

  Jan 2019 - Jun 2020

  Cloud & data engineer consultant

  - Design and implementation of data collection, analytics and deployment of tools for social and digital data science- Implementation of data build tool (dbt) for modelling google ads, google analytics and social media data- Implementation of ecommerce and website event tracking with google tag manager- Analyzing digital data and providing insights to community and account management team- Data analytics of social media data and google analytics data using google bigquery- Creating and setting up python scripts in aws instances for data mining and streaming the data to aws dynamo db for analysis.- Setting up Foresight a social media sentiment analysis tool. This involved creating python scripts in aws lambda for twitter data extraction to aws S3, setting up AWS Glue for processing and transforming the data and dumping it to Redshift and setting up aws Quicksight for visualization- Implementing, managing & maintaining Apache Unomi, a customer data platform for collecting and storing user events- Connecting Apache PredictionIO to Apache Unomi for prediction ecommerce user behavior- System Design, Deployment and Maintenance including maintaining digital ocean cloud servers- Installation and maintenance of different data warehouses and data lakes i.e. S3,Dynamo etc- Set up and installation of Piwik analytics engine as an alternative to google analytics. This involved setting it up in production and integrating the analytics js script with client websites- Deployment of Meltano for data ingestion from facebook ads and google analytics, Apache airflow for workflow management of the ETL process.- Installation and setup of Apache Superset as the main business intelligence tool- Prototyping of Apache Unomi a CDP and Apache PredictionIO prediction engine and testing this on sample websites. Show less

• 

  Abojani

  Jul 2019 - Sept 2019

  Analytics engineer

  Learning and working under an MBA student to deliver an alternative credit scoring service based on SMS data. I was mainly involved in analytics and setting up the infrastructure to deliver the model as an API service, and:- Project planning and management. Created a project plan and updated this on Trello. Setting up version control environment and coordinating with software team for the provision of required resources.- Business Intelligence development. Developed dashboards in power bi to visualize credit performance - Data analysis of defaulter data and SMS data using Python and SQL- Analyzing text data to obtain meaningful features for credit modelling- The prototype of a credit scoring machine learning model based on SMS data- Using Flask framework to deploy the machine learning model as an API service and testing with the software development team- Data mining and cleaning of SMS data for analysis- Data modelling of mined SMS data using dbt (data build tool) and python to create clean data sets for the data analyst. Show less

• 

  Andela

  May 2020 - Jul 2020

  Associate google cloud engineer - google africa developer scholarship

  Projects and studying Google Cloud Platform infrastructure and its core services with a focus of getting an associate google cloud engineer certificate and training experience.- Google Cloud Platform Fundamentals: Core Infrastructure. This includes understanding, setting up & managing services such as google cloud virtual machine, app engine, Kubernetes, Storage services and google big data services- Fundamentals of Google Kubernetes Engine. This involved learning how to containerize applications, deploy them to GKE and scale the workloads to handle increased traffic.- Scaling and Automation in the Google Cloud Infrastructure. This involved learning load balancing, google interconnected networks, infrastructure automation and google managed service.- Google cloud infrastructure core services: Main services on GCP including managing users, resources and also monitoring various GCP cloud services- Fundamentals of Google Cloud Platform Big Data and Machine Learning. Included google big data and machine learning services and a deep dive into google data processing and analytics services. Show less

• 

  Indeed.com

  Aug 2021 - Sept 2022

  Software engineer - data engineer

  Indeed is an American worldwide employment website for job listings launched in November 2004. It is a subsidiary of Japan's Recruit Co. Ltd. and is co-headquartered in Austin, Texas, and Stamford, Connecticut, with additional offices around the world.As a single-topic search engine, it is also an example of vertical search. Indeed is currently available in over 60 countries and 28 languages. In October 2010, Indeed.com passed Monster.com to become the highest-traffic job website in the United States.The site aggregates job listings from thousands of websites, including job boards, staffing firms, associations, and company career pages. They generate revenue by selling premium job posting and resume features to employers and companies hiring.In 2011, Indeed began allowing job seekers to apply directly to jobs on Indeed's site and offering resume posting and storageDuties:- Migration of Indeed data platform from On-prem to AWS.- Automation of the data platform migration process. Show less

• 

  Roam

  Sept 2022 - now

  Software engineer - data products

  Roam was founded in 2017 just as electric mobility was taking off, when electric cars were just arriving on our streets. Roam vision is to make electric transport more accessible to a broader market by making the technology more cost efficient and simplifying deployment. The company focuses on all-electric conversion kits for fleet vehicles such as light trucks, public transport and buses, as well as electric motorcycles and energy systems. These focus areas have been chosen to maximize impact, as these vehicles are some of the highest CO2 emitting vehicles on the market and are largely an untapped opportunity. Therefore creating the standard for electric mobility in Africa. Show less