Hello, I’m

Joseph Lang, MBA

Data Analytics Professional — Business Automation & Solar Energy

Self-taught programmer and data analyst with nearly four years turning raw operational data into automated tools, actionable reports, and reliable pipelines — primarily in the renewable energy sector.

Data analyst.
Automation builder.

I am a data analytics professional and self-taught programmer based in Charlotte, NC. My work sits at the intersection of data analysis and practical software development: I design the tools that make data usable — custom monitoring applications, automated reporting pipelines, and API integrations — and I use that data to surface the insights that drive smarter decisions.

Currently working as a PV Performance Analyst at National Renewable Energy Corporation, I monitor a 42-site, ~250 MW solar portfolio, build Python-based tooling for our O&M team, and continuously look for ways to automate repetitive processes and improve data visibility across the organisation.

After the eMaint work-order dashboard I built proved its value and our team’s Ops Manager departed, I absorbed that role’s core responsibilities alongside my analyst duties — I’m now the primary point of contact for O&M customers and field technicians, schedule daily technician tasks, and own the work-order system directly.

I hold an MBA in Quantitative Methods of Business from Queen’s University of Charlotte, strengthening the bridge between technical data work and business strategy.

  • ~4 years self-taught programming: Python, SQL, automation
  • Building production tools used daily by O&M teams
  • Passionate about eliminating manual work through smart automation

4 yr

Self-taught Development

MBA

Queen’s University ’26

PV

Solar Performance Analyst

Ops Mgr

O&M Point of Contact

Core Competencies

Data Analytics

Turning operational data into clear, actionable intelligence. I design reporting frameworks, KPI dashboards, and analysis tools that allow teams to monitor performance and make faster decisions. Hands-on experience analysing solar farm production data at scale.

  • Exploratory Analysis
  • KPI Design
  • Performance Monitoring
  • Visualisation
  • Reporting

Business Automation

Identifying manual, repetitive workflows and replacing them with reliable automated systems. From migrating Excel/VBA tools to Python to scheduling live data syncs between databases and cloud spreadsheets — I build automation that saves time and reduces human error.

  • Python Scripting
  • API Integration
  • Workflow Automation
  • Google Sheets API
  • Gmail API
  • VBA to Python

Database & SQL

Designing and querying relational databases to support real-time monitoring applications and operational reporting. Experience integrating SQL Server databases with Python applications and bridging legacy Access databases with modern tooling.

  • SQL
  • SQL Server / SSMS
  • Microsoft Access
  • Database Integration
  • Query Design

Operations & Stakeholder Management

Primary point of contact for O&M customers and field technicians, owning the company’s work-order system end-to-end and setting daily technician task schedules — the operator’s side of the tools I build.

  • Stakeholder Communication
  • Work-Order Management
  • Technician Scheduling
  • Customer & Vendor Relations

My Tech Stack

Languages

  • Python
  • SQL
  • VBA
  • JavaScript
  • AHK

Python Libraries

  • pandas
  • scikit-learn
  • requests
  • BeautifulSoup
  • tkinter
  • googleapiclient

Data & Databases

  • SQL Server / SSMS
  • Microsoft Access
  • Google Sheets
  • Excel (Advanced)
  • R / RStudio

Infrastructure

  • Linux
  • Proxmox
  • Nginx
  • Docker
  • Cloudflare
  • Git / GitHub

Experience

Sept 2022 — Present

Charlotte, NC

National Renewable Energy Corporation (NARENCO)

PV Performance Analyst

  • Monitor a 42-site, ~250 MW solar portfolio for optimal production performance from the Control Center.
  • Built an automated ops-reporting pipeline for the company’s eMaint work-order system — Gmail API retrieval, Python re-analysis, and a statically regenerated HTML dashboard covering ~10,000 work orders/year — cutting administrative staffing for WO tracking from 3 people to 1, a 66% reduction.
  • Following the departure of the team’s O&M Ops Manager, absorbed the role’s core duties in addition to my own — sole point of contact for O&M customers and field technicians, direct administrator of the eMaint work-order system, and daily task scheduler for the technician team.
  • Designed a comprehensive solar monitoring platform using the Also Energies API, backed by an SQL Server database, with tailored automated notifications for the O&M team — cutting daily Control Center analysis labor from 6 hours to 1 hour (pandas, scikit-learn, requests, tkinter).
  • Designed and maintain a config-driven, multi-site forecasting pipeline (Python dataclasses, pyodbc) covering 7 solar sites, generating branded Excel deliverables distributed by automated email.
  • Migrated the company’s core Solar Performance Analysis tool from Excel & VBA to Python & Google Sheets, cutting the full multi-site reporting cycle from 8–16 hours to 30–60 minutes (pandas, scikit-learn, googleapiclient).
  • Built a Wind Weather App in Python to track real-time wind conditions near solar farm sites, later extended into a weather-aware daily scheduling planner for 6 field technicians — cut scheduling-check time from about an hour to under 5 minutes (tkinter, requests, BeautifulSoup).
  • Engineered a live sync between the company’s Microsoft Access database and Google Sheets via Python, fully automating a Control Center task that previously took 30 minutes per update (tkinter, tkinterweb).
  • Designed standardised deliverable templates for O&M data visualisation used by internal and external stakeholders.

Featured Projects

Monitoring App

Solar Farm Monitoring Platform

A Python application integrating the Also Energies API with an SQL Server database to provide real-time performance monitoring and automated, contract-specific notifications for O&M field teams — cutting daily Control Center analysis labor from 6 hours to 1 hour.

  • Python
  • SQL Server
  • pandas
  • scikit-learn
  • REST API
Automation

Solar Performance Analysis Tool

Rewrote the company’s legacy Excel/VBA performance analysis tool in Python, connecting directly to Google Sheets for live collaborative reporting — cutting the full multi-site reporting cycle from 8–16 hours to 30–60 minutes.

  • Python
  • Google Sheets API
  • pandas
  • scikit-learn
Data Tool

Wind Weather App

A desktop GUI application built with tkinter that pulls and displays live wind data from weather APIs for solar farm sites. Later extended into a weather-aware daily scheduling planner for field technicians — cutting scheduling-check time from about an hour to under 5 minutes.

  • Python
  • tkinter
  • requests
  • BeautifulSoup
Integration

Access → Google Sheets Sync

A Python bridge that keeps a legacy Microsoft Access database synchronised with a Google Sheet, giving a customer a live, always-current view of their data and fully automating a Control Center task that previously took 30 minutes per update.

  • Python
  • Microsoft Access
  • Google Sheets API
  • tkinter
Internal Tool

eMaint Ops-Reporting Dashboard

An automated pipeline for the company’s eMaint work-order system: a Gmail API integration retrieves eMaint’s scheduled Excel export, Python re-analyzes and re-saves the data, and a scheduled job statically regenerates a searchable HTML dashboard with embedded charts — covering roughly 10,000 work orders/year and cutting administrative staffing for WO tracking from 3 people to 1, a 66% reduction. Its impact led to my taking on the team’s vacated Ops Manager responsibilities — I’m now the tool’s primary daily user as well as its builder.

  • Python
  • Gmail API
  • pandas
  • openpyxl
  • Static HTML Dashboard
Reporting Pipeline

Solar Forecasting Pipeline

A config-driven Python system (dataclasses defining per-plant parameters) covering 7 solar sites, pulling from an Access database via pyodbc and generating branded Excel forecast reports distributed by automated email.

  • Python
  • pyodbc
  • Microsoft Access
  • openpyxl
  • Automated Email
Edge-hosted

This Portfolio Site

A secure, fully static portfolio site — zero client-side JavaScript — deployed to Cloudflare’s global edge network via Cloudflare Workers. A small Worker script handles clean-URL routing (/data, /resume, etc.) and attaches hardened security headers (CSP, X-Frame-Options, and more) on every response.

  • HTML
  • CSS
  • Cloudflare Workers
  • Edge Routing
GitHub

More on GitHub

Browse all of my personal tools, experiments, and automation scripts on GitHub.

View Profile →

Education & Certifications

Queen’s University of Charlotte

Master of Business Administration (MBA)

Business Administration & Management — Quantitative Methods

Aug 2024 — May 2026 Completed

Wingate University

Bachelor of Science — Psychology

Analytical thinking and understanding human behaviour applied to data communication and stakeholder engagement.

Aug 2018 — May 2021

Resume

Three versions, same experience, different framing — pick whichever matches the role you’re looking at.

Let’s Connect

Open to opportunities, collaborations, and conversations about data, automation, or renewable energy analytics.