Summary
Overview
Work History
Education
Skills
Timeline
Generic
PATRICK KEMBOI

PATRICK KEMBOI

Fort Worth,TX

Summary

A highly motivated and detail-oriented BI Developer with years of experience in collecting, integrating, storing, analyzing data and reporting development. Seeking a challenging role that will utilize my skills and experience in developing and implementing effective BI solutions. Leverages outstanding communication, interpersonal, and negotiation skills to assist in the achievement of business goals and objectives. Detail-oriented with proven ability to accomplish tasks under minimal supervision and quick to learn new technologies skills and best practices.

Overview

6
6
years of professional experience

Work History

BI Developer

Frog Tutoring LLC
03.2021 - Current
  • Create SQL scripts, stored procedures, views, CTEs, and UDF to support business requirements
  • Work with large datasets and implement data warehousing and ETL solutions, including normalization and data modelling techniques
  • Create SSIS packages for ETL purposes and perform data migration from various types of sources (Excel, flat file, CSV, XML, and OLTP DB)
  • Experience in deploying SSIS packages using different methodologies and performing automation of SSIS Packages using SQL Server agent
  • Design interactive Power BI reports and dashboards based on company needs and requirements, publish reports to Power BI Service, and share reports with stakeholders
  • Extract, transform, and load data from various sources such as SQL Server, Excel, and other cloud-based data platforms into Power BI
  • Implement DAX functions to create calculations, custom measures, and Key Performance Indicators (KPIs) to generate reports
  • Utilize Power BI on-premises gateway to keep the data in reports and dashboards up to date by scheduling daily dataset refreshes
  • Define dynamic and static Row-Level Security (RLS) in Power BI Desktop and assign users to a role in Power BI Service.

BI Developer /Data Analyst

Nile Expediting LLC
04.2017 - 03.2021
  • Developed and maintained ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into data warehouses
  • Familiar with Python and C#
  • Designed and developed SQL queries and stored procedures for data analysis and reporting purposes
  • Developed and maintained data models to support business requirements and ensure data integrity
  • Worked with business users to understand their requirements and develop effective reporting solutions using Power BI and SSRS
  • Analyzed data to identify trends, patterns, and anomalies to support business decision-making
  • Monitored and maintained the performance of the BI systems and made recommendations for improvements
  • Create Parameterized reports, Drilldown reports, Drill through reports, Matrix reports, and Sub reports using SSRS for in-depth business analysis
  • Design data pipelines to ingest, process, and store data in Azure Data Lake, utilize Databricks for data processing and incorporate DevOps practices to automate the deployment and management of these solutions

Education

Master of Science - Healthcare administration

The University of Texas
Arlington, TX

Bachelor of Arts - Finance

Texas Christian University
Fort Worth, TX

Some College (No Degree) - Data Analytics

Colaberry School Of Data Analytics
Plano, TX

Skills

  • SSRS SSIS Power BI MS Excel ADF Azure Databricks Azure SQL
  • Data architecture Data governance Data security Data Integrity
  • Agile Scrum Methodology Business Requirements
  • Database Building, Management, and Modelling
  • Data Warehousing Data Mining Trend Data Analysis

Timeline

BI Developer

Frog Tutoring LLC
03.2021 - Current

BI Developer /Data Analyst

Nile Expediting LLC
04.2017 - 03.2021

Master of Science - Healthcare administration

The University of Texas

Bachelor of Arts - Finance

Texas Christian University

Some College (No Degree) - Data Analytics

Colaberry School Of Data Analytics
PATRICK KEMBOI