Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

ALEX MBAYA

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

9
9
years of professional experience

Work History

Data Analyst

FDA (Williams Consulting LLC)
05.2023 - Current
  • Support building out data calls for operational and IT data Understand, analyze, and manipulate datasets.
  • Use graphs, infographics, and other methods to visualize data.
  • Create reports, presentations and reports based on recommendations and findings.
  • Support maintenance of reporting dashboard in the designated existing platform and/or Microsoft SQL Power BI that allows stakeholders to input and view data on performance for management control purposes.
  • Serve as a technical point of contact for government leadership Monthly Reporting to ensure updates are completed timely and aid users as necessary.
  • Produce monthly executive performance management reports, annual performance management reports and ad hoc reports as requested.
  • Assist in performance management audits that includes a system for capturing, monitoring, and reporting data.
  • Assess the quality of available performance data, the effectiveness of data collection, and identify improvements for the performance management process.
  • Consult and coach in the development and refinement of priorities and collecting supporting performance data various performance metrics related to records management, reasonable accommodation requests, information governance, procurement and financial management, risk management and compliance, communications, and technology.
  • Consult on the development and implementation process and system plans for synthesizing and using performance data to inform decision-making. Other duties as assigned.

Data Analyst

Verizon Wireless, Martin Gold IT Services
09.2018 - 05.2023
  • Utilized data visualization tools (PowerBI) to effectively communicate business insights
  • Collaborated with Project Manager and business-unit to identify and prioritize technical issues
  • Collaborated with stakeholders to document business requirements and functional requirements
  • Analyze large data sets to identify patterns and trends while providing actionable insights
  • Documented effective and replicable methods for extracting data and organizing data sources
  • Performed Data Modeling for existing and new internal projects
  • Analyzed Location Based Services data sets identify applications that are violating privacy laws
  • Created SQL scripts in MSSQL Server to normalize database objects by creating primary keys, foreign keys, and other constraints
  • Performed Aggregations for sales department within MSSQL Server using various aggregate functions and Group
  • By Clauses
  • Migrated Data from multiple sources into final Repository
  • Created Stored Procedures, Views and Functions to perform complex tasks with given parameters
  • Created update and insert scripts for different use cases
  • Created KPIs to measure performance of Verizon Products and services across multiple regions
  • Manage meetings with stakeholders to keep them informed of progress of team
  • Document tasks within Agile environment

Data Analyst

UnitedHealth Group
06.2015 - 08.2018
  • Updated and developed MSSQL scripts and queries to extract and analyze data from multiple sources
  • Identified, analyzed and interpreted trends or patterns in complex data sets
  • Created data models to support decision-making processes
  • Reviewed and corrected claim errors to facilitate smooth processing
  • Educated patients on medicine and at-home healthcare tools
  • Compiled and reviewed medical charts
  • Provided data architecture and modeling to ensure that data within the Claims Management System (CMS) was in line with compliance guidelines
  • Perform data mapping for the process
  • Performed ETL data loads different sources to transform data into complex scripts and codes for software application testing
  • Developed and enhanced MSSQL test scripts for data driven QA and UAT tests
  • Developed and executed automated test case scripts Test for the Front-end applications
  • Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low-level business requirements

Education

Bachelor of Science - Computer Science

University of Oxford

Bachelor of Science - Network And System Administration

University of The Witwatersrand
South Africa

Skills

  • Data Mapping
  • Activity Diagram
  • Data Mining
  • Data Migration
  • Query Tools
  • Trend Data Analysis
  • Data Reporting
  • Structured Query Language (SQL)
  • Data and Analytics

Languages

French
Native or Bilingual

Timeline

Data Analyst

FDA (Williams Consulting LLC)
05.2023 - Current

Data Analyst

Verizon Wireless, Martin Gold IT Services
09.2018 - 05.2023

Data Analyst

UnitedHealth Group
06.2015 - 08.2018

Bachelor of Science - Computer Science

University of Oxford

Bachelor of Science - Network And System Administration

University of The Witwatersrand
ALEX MBAYA