Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Henok Demisse

Emeryville,USA

Summary

Senior Data Analyst with 7+ years of experience leveraging SQL, Power BI, Tableau, and Excel to deliver actionable insights, streamline reporting, and optimize decision-making. Skilled in building scalable dashboards, automating workflows, and ensuring data integrity across transportation, energy, automotive, and insurance sectors. Adept at collaborating with cross-functional teams, aligning analytics with business goals, and driving efficiency through data governance, QA, and reporting best practices.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Administrative Analyst / Data Coordinator

UCSF Transportation
01.2023 - Current

· Collected, validated, and managed transportation data to ensure accuracy in vehicle scheduling, route planning, and driver assignments.

· Developed Power BI dashboards tracking budget forecasts, procurement activities, and operational KPIs to support executive reporting.

· Partnered with leadership to define departmental KPIs and built reporting pipelines that improved decision-making.

· Streamlined cross-departmental data collection and QA processes, reducing reporting discrepancies by 30%.

· Conducted cost analysis and performance tracking, providing actionable recommendations for resource optimization.

· Collaborated with vendors and stakeholders to improve workflows and implement reporting automation.

SGIP Operations Analyst

Pacific Gas & Electric (PG&E)
10.2021 - 11.2022

· Processed and validated large volumes of energy rebate applications, ensuring compliance with program criteria.

· Built SQL-driven summary reports for leadership on application timelines and program effectiveness.

· Designed Excel-based tracking models and automated workflows to enhance data quality checks.

· Performed QA audits that reduced customer data errors by 25%.

· Developed dashboards highlighting rebate application trends and customer eligibility.

Incentives Analyst

Kia Motors America
04.2019 - 09.2021

· Designed reports and dashboards using SQL queries and BI tools to track claim volumes, rebate trends, and campaign ROI.

· Managed high-volume rebate and incentive claims, ensuring accuracy and compliance with internal controls.

· Conducted eligibility analysis on incentive programs with advanced SQL joins and aggregations.

· Partnered with finance teams to align incentive reporting with budget forecasts.

· Improved claims processing speed by standardizing documentation workflows.

Data Processor / Claims Analyst

Church & Casualty Insurance
01.2018 - 03.2019

· Processed and audited complex insurance claims and policies to ensure compliance with underwriting standards.

· Validated large datasets, identifying anomalies and correcting data entry errors.

· Developed monthly reporting templates to track claims processing efficiency.

· Collaborated with actuarial teams to support risk analysis and premium modeling.

HRIS Data Specialist

Cummins Cal Pacific
04.2017 - 02.2018
  • - Maintained HRIS databases, ensuring data accuracy across multiple reporting cycles.
  • - Designed ad hoc reports and dashboards for HR leadership using Excel and internal tools.
  • - Audited payroll reports bi-weekly and collaborated on procurement for HR tech systems.

Insurance Underwriter

Africa Insurance Company S.C
08.2013 - 01.2015

· Determined policy terms and calculated premiums based on actuarial, statistical, and background information.

· Analyzed risk in insurance proposals to ensure sound underwriting decisions.

· Prepared insurance policy terms and conditions in compliance with regulatory standards.

· Liaised with insurance brokers and customers to clarify requirements and resolve inquiries.

Education

B.S. - Computer Science and Programming

California State University - East Bay
Hayward, CA
05-2025

A.S. - Computer Science

Irvine Valley College
Irvine, CA
01.2020

B.A. - Human Resources Management and Leadership

New Generation University
01.2013

Skills

    Languages & Tools: SQL, Python, Excel (PivotTables, Power Query, VLOOKUP), Postman
    Visualization & BI: Tableau, Power BI, Looker
    Data Integration & Modeling: Fivetran, AWS Glue, dbt, Airflow, Data Modeling
    Cloud Platforms: Azure, Snowflake Data Cloud, AWS
    Systems & Platforms: SAP, Maximo, BearBuy, Box, WebNow
    Workflow & Project Support: Jira, Application Lifecycle Support, KPI Development, Budget Forecasting, Project Support
    Data Ops & Management: Data Quality Assurance, Procurement & Vendor Management
    Version Control: Git, GitHub, GitLab, Bitbucket

Certification

- Microsoft Azure Fundamentals (AZ-900)

Timeline

Administrative Analyst / Data Coordinator

UCSF Transportation
01.2023 - Current

SGIP Operations Analyst

Pacific Gas & Electric (PG&E)
10.2021 - 11.2022

Incentives Analyst

Kia Motors America
04.2019 - 09.2021

Data Processor / Claims Analyst

Church & Casualty Insurance
01.2018 - 03.2019

HRIS Data Specialist

Cummins Cal Pacific
04.2017 - 02.2018

Insurance Underwriter

Africa Insurance Company S.C
08.2013 - 01.2015

A.S. - Computer Science

Irvine Valley College

B.A. - Human Resources Management and Leadership

New Generation University

B.S. - Computer Science and Programming

California State University - East Bay