My name is Travis Horesh and I’m a Data Analyst in the Electric Utility Industry

I’m currently supporting reporting and analytics efforts related to stakeholder engagement. Using Power Platform, SQL, and other tools, I’m helping to improve Duke Energy’s engagement with customers in the Carolinas who are impacted by our infrastructure projects.

I created this website using R blogdown as a means to learn one of R’s many capabilities and to showcase my efforts and experience.

Know more Contact me

Experience

 
 
 
 
 

Business and Technical Consultant

Duke Energy

Aug 2023 – Present Charlotte, NC
  • Infrastructure Engagement handles interactions with customers who are directly impacted by infrastructure projects, which include transmission, distribution, generation, and energy storage projects
  • I developed automations and simple web applications using Microsoft’s Power Automate and Power Apps
  • Developed reporting to aid in project management and awareness using Power BI
 
 
 
 
 

Data Science Consultant

Duke Energy

Oct 2020 – Aug 2023 Charlotte, NC
  • Liaison for various lines of business; able to learn their language and translate their needs and requests into informative, actionable reports, dashboards, and visualizations

  • I provide support and input for data architecture, migration, and archiving activities

  • Employ my experience in Internal Audit to assist with the standardization of internal processes and documentation

  • Program and project experience includes:

    • Billing-based programs that allow customers access to or promotion of renewable energy
    • EV and EV infrastructure programs
    • Team and department-level financial performance metrics
    • Logic for lottery-based customer incentives
 
 
 
 
 

Senior Audit Consultant

Duke Energy

Mar 2019 – Sep 2020 Charlotte, NC
  • Assisted with the planning, coordination, and execution of internal operational audits across a variety of fields and audit teams
  • Served as the team lead for data analytics on multiple audits, which included preparation of SQL query requests and the creation of visualizations and dashboards using Power BI.
  • Also served as an audit software administrator for the department
 
 
 
 
 

Senior Audit Consultant

Duke Energy

Jan 2015 – Mar 2018 Charlotte, NC
  • Member of the Operations and Finance group within Corporate Audit Services

  • Assisted numerous different audit teams in planning, coordinating, and executing audit projects

  • Audit experience includes:

    • Project management reviews across several business units
    • Natural gas operations
    • Wind renewables data analysis and compliance reporting
    • Nuclear and fossil power generation
    • Transmission and distribution
    • Customer information systems
    • Real estate, and more
  • Led, or assisted with, several internal department initiatives

    • Planning yearly operational training
    • Streamlining employee on-boarding process
    • Leading our annual volunteer event
 
 
 
 
 

Service Engineer II

Babcock & Wilcox

Jan 2009 – Dec 2014 Charlotte, NC

Dynamic position with a wide variety of day-to-day tasks and a significant level of responsibility, including:

  • Providing technical assistance for the construction, repair, and operation of utility-scale steam boilers and related equipment
  • Providing engineering support across a range of topics related to safe and efficient boiler operation
  • Visual inspection services for boilers and associated equipment, along with detailed technical reports of my findings

Served as:

  • Lead field engineer for a coal-to-natural gas conversion of two units totaling approximately 120 MW in generating capacity
  • Lead technical adviser for construction & commissioning of a Wet Flue Gas Desulfurization (WFGD) project in Chile
  • Lead field engineer on an 8 month, multi-million dollar WFGD retrofit project
  • Night-shift lead field engineer on two Recovery Boiler floor tube panel and floor support beam replacement projects

Accomplishments

Data Analyst in SQL

12-course program that covers the fundamental competencies of how to:

  • Write basic SQL queries
  • Group and aggregate data to produce summary statistics
  • Join tables and apply filters and sub-queries
  • Write functions to explore and manipulate data
See certificate

HarvardX Data Science

  • Fundamental R programming skills
  • Statistical concepts such as probability, inference, and modeling and how to apply them in practice
  • Implement machine learning algorithms
See certificate

Microsoft Data Science Fundamentals

  • Analyzing and Visualizing Data with Power BI
  • Introduction to Data Science
  • Analytics Storytelling for Impact
  • Ethics and Law in Data and Analytics
See certificate

Projects

*

Looker Studio Coffee Brewing Dashboard

An early dashboard build that visualizes my daily coffee brewing.

Find a B Corp Shiny App

My first shiny app. This simple app helps users find the top rated B Corps in a given industry.

HarvardX Data Science Capstone Projects

Two machine learning prediction projects completed as part of my edX / HarvardX Data Science program.

Contact