Joseph Lang, MBA

Data Analytics Professional — Business Automation, Solar Energy Data & O&M Operations

Summary

Data analytics professional and self-taught programmer with nearly four years of hands-on experience building Python-based monitoring tools, automating business processes, and managing operational databases across a 42-site, ~250 MW solar portfolio in the renewable energy sector. Proven ability to take ownership of end-to-end data projects — from API integration and database design to reporting and stakeholder deliverables, including an ops-reporting dashboard that cut administrative staffing needs by 66%. That dashboard’s impact led to an expanded operational role: now the primary point of contact for O&M customers and field technicians, owning the company’s work-order system and daily technician scheduling directly. Holds an MBA in Quantitative Methods of Business, reinforcing a strong foundation in data-driven decision-making.

Skills

Programming Python (Intermediate) — pandas, scikit-learn, requests, BeautifulSoup, tkinter, googleapiclient Data & Databases SQL, SQL Server / SSMS, Microsoft Access, Google Sheets, Excel (Advanced), R / RStudio Automation Business process automation, API integration, Google Sheets API, Gmail API, VBA-to-Python migration, AHK Analytics Exploratory data analysis, KPI design, performance monitoring, data visualisation, reporting Infrastructure Linux, Nginx, Proxmox, Docker, Cloudflare, Git / GitHub, HTML, JavaScript (Beginner)

Experience

National Renewable Energy Corporation (NARENCO) September 2022 — Present
PV Performance Analyst Charlotte, NC
  • Monitor solar farm production and optimise control-center workflows across a 42-site, ~250 MW portfolio, ensuring prompt identification and escalation of performance anomalies.
  • Built an automated ops-reporting pipeline for the company’s eMaint work-order system (Gmail API retrieval, Python re-analysis, statically regenerated HTML dashboard) covering ~10,000 work orders/year — cut administrative staffing for WO tracking from 3 people to 1, a 66% reduction.
  • After the dashboard proved its value and the team’s Ops Manager departed, absorbed the role’s core responsibilities alongside my analyst duties — sole point of contact for O&M customers and field technicians, direct owner/administrator of the eMaint work-order system, and daily task scheduler for the technician team.
  • Designed a Python monitoring platform integrating the Also Energies API with a SQL Server database to deliver tailored, automated performance alerts to O&M field teams — 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 legacy Solar Performance Analysis tool from Excel/VBA to Python and Google Sheets, cutting the full multi-site reporting cycle from 8–16 hours to 30–60 minutes (pandas, scikit-learn, googleapiclient).
  • Built a live sync bridge between a Microsoft Access database and Google Sheets via Python, fully automating a Control Center task that previously took 30 minutes per update (tkinter, tkinterweb).
  • Developed a desktop Wind Weather App (tkinter, requests, BeautifulSoup) and later extended it into a weather-aware daily scheduling planner for 6 field technicians — cut scheduling-check time from about an hour to under 5 minutes and eliminated weather-related mis-scheduling over 3 months of use.
  • Designed standardised O&M data deliverables and visualisations used by internal teams and external stakeholders.
Cummings Construction Corporation (Freelance Contract) December 2025 — February 2026
Python Developer — Business Management Platform
  • Scoped, designed, and built a full-featured Python desktop application for CCC’s project management office, replacing a fragmented, Excel-based manual workflow with a single entry point for purchase orders, invoices, change orders, and subcontracts.
  • Automated the complete document lifecycle — Word/PDF generation, one-click printing including envelopes, and regex-based file naming — backed by a Microsoft Access database; now used daily by 3–6 project managers processing an estimated 3–10 documents each per day.
  • Gathered requirements directly with CCC staff and trained a lead user who onboarded the rest of the team; the application has remained in active use with minimal support needed since its February 2026 launch.
CapRock Investments March 2022 — July 2022
General Laborer (promoted to Project Lead) Charlotte, NC
  • Promoted to lead a warehouse decommissioning project, coordinating work completion and punch-list management; role ended when the company dissolved and sister company NARENCO made a direct hire offer.

Education

Queen’s University of Charlotte

Master of Business Administration (MBA) — Quantitative Methods of Business

Aug 2024 — May 2026

Completed

Wingate University

Bachelor of Science — Psychology

Aug 2018 — May 2021