John Mutai

John Mutai

Data analyst apprenticeship

Arlington, Texas, United States.

About  

I possess all the skills and experience that makes me fit for the job. I'm confident that I am the best candidate for this job. It's not just my background in the past projects, but also my people skills, which will be applicable in this position.

Hours Available / Wk - 40 hrs

Employment History 

  • Reporting Analyst

    goTRG
    February 2022 - Present

    • Used Pivot tables, Power query to create reports, dashboards and visual to assist leadership in making business decisions.
    • Gathered, arranged, and inspected data using various procedures to understand information to improve the business
    • Checked and cleaned data, taking special care to replace erroneous values with correct figures.
    • Analyzed data, with due consideration for the influence of missing information, outliers, plus confounding and extraneous variables.
    • Reported on insights obtained, which might be utilized to inform business strategies.
    • Consulted on areas of uncertainty to promote optimal use of ideas derived from data.
    • Created and updated data sets that evolve in tandem with our business's needs.
    • Created reports that provide information to understand key data points

  • Apprenticeship in Data analytics

    Colaberry Inc
    January 2020 - Present

    • Designed reports, dashboards and interactive visual reports using power bi
    • Identified key performance indicators (KPIs) with clear objectives and consistently monitored data and presented data through reports to aid decision-making.
    • Created relationships between data and developed tabular and other multidimensional data models.
    • chart creation and data documentation explaining algorithms, parameters, models, and relations.
    • Created views, functions, and stored procedures such that appropriate changes can easily be made to respective tables.
    • Wrote optimized SQL queries for integration with other applications and creating database triggers for use in automation.
    • Gathered data from clients to determine their needs and help to plan flow of the project at hand.
    • Validated data from source and update/insert the records into target tables.
    • Created a variety of transformations in the ETL process using SSIS.

  • Reporting Analyst

    Northern Freight llc
    January 2019 - July 2021

    • Recorded financial information in quick books system.
    • Did Account & Bank Reconciliations.
    • Created reports that provide information to understand key data points
    • Reported on insights obtained, which might be utilized to inform business strategies.
    • Checked and cleaned data, taking special care to replace erroneous values with correct figures.

Digital Credentials  

Schedule an Interview