Python Developer

Joseph Lang, MBA

Freelance Python Developer & Business Automation Specialist

I build Python applications that replace manual workflows — invoicing systems, monitoring tools, document automation, and API integrations. Self-taught, production-deployed, and built to last.

Self-taught. Production-ready.

I’ve been writing Python for roughly four years — entirely self-taught, driven by real problems that needed real solutions. Everything I’ve built has been deployed and used in a production environment, from solar farm control centers monitoring a 42-site, ~250 MW portfolio to a construction company’s project management workflow.

My focus is on practical automation: desktop applications with GUIs, REST API integrations, database-backed tools, and document generation pipelines. I care about building software that non-technical users can actually use without friction.

  • Every project has been production-deployed and actively used
  • Focus on removing manual, repetitive workflows
  • Strong attention to usability — built for non-technical end users
  • Available for freelance and contract work

4 yr

Python Development

🐍

Intermediate Python

GUI

Desktop App Dev

API

REST Integration

What I Build

Desktop Applications

Full GUI applications built with tkinter — data entry forms, dashboards, reporting tools, and workflow managers. Designed for end users who need something that just works without any technical setup.

  • tkinter
  • tkinterweb
  • Custom UI components

Document Automation

Automated generation of Word documents, Excel spreadsheets, and PDF exports from templates and database records. Includes printing workflows and file naming conventions using regex for consistent output.

  • python-docx
  • openpyxl
  • PDF export
  • re / regex
  • Print automation

API & Data Integration

Integrating third-party APIs and connecting disparate data systems. Experience with REST APIs, Google Sheets API, and bridging legacy databases (Access, SQL Server) with modern tooling and cloud services.

  • requests
  • Google Sheets API
  • Gmail API
  • BeautifulSoup
  • SQL Server / Access

Process Automation

Replacing manual, error-prone workflows with reliable automated systems. From scheduled data syncs to triggered notifications to batch processing — identifying the bottleneck and eliminating it.

  • pandas
  • scikit-learn
  • Scheduling
  • Notifications

Tools I Use

Core

  • Python
  • SQL
  • re / regex
  • VBA (legacy migration)

GUI & UX

  • tkinter
  • tkinterweb

Documents

  • python-docx
  • openpyxl
  • PDF generation
  • Win32 Print

Data & APIs

  • pandas
  • requests
  • BeautifulSoup
  • Google Sheets API
  • scikit-learn

Databases

  • SQL Server / SSMS
  • Microsoft Access
  • SQLite
  • pyodbc

Projects

Production App

Solar Farm Monitoring Platform

Python application integrating the Also Energies API with a SQL Server database. Provides real-time solar farm performance data and sends tailored automated alerts to O&M field teams based on contract-specific thresholds — cutting daily Control Center analysis labor from 6 hours to 1 hour.

  • Python
  • SQL Server
  • REST API
  • pandas
  • scikit-learn
  • tkinter
Migration / Automation

Solar Performance Analysis Tool

Rewrote the company’s legacy Excel/VBA analysis tool in Python. Connects directly to Google Sheets via API 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
Desktop App

Wind Weather App

A tkinter desktop GUI that pulls and displays real-time wind speed and direction from weather APIs for solar farm sites. Later extended into a weather-aware daily scheduling planner — cutting scheduling-check time from about an hour to under 5 minutes.

  • Python
  • tkinter
  • requests
  • BeautifulSoup
Integration

Access → Google Sheets Live Sync

A Python bridge keeping a legacy Microsoft Access database synchronised with a Google Sheet, giving a customer a real-time 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 a company work-order system: a Gmail API integration retrieves a 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 work-order tracking from 3 people to 1, a 66% reduction.

  • 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
GitHub

More on GitHub

Additional scripts, experiments, and open-source tools on my GitHub profile.

View GitHub →

Available for freelance work.

Got a workflow that’s still running on Excel and manual copy-paste? A database that needs a front-end? A report that should generate itself? Let’s talk.