Stephen T.

I transform complex business tasks into efficient, automated systems, saving time, reducing errors, and improving productivity across all business areas. ---My Mission--- To build software solutions that dramatically improve the speed, quality, and output of critical business tasks, enhancing efficiency and reducing costs. ---Core Competencies--- Excel, VBA, SQL, Power Automate, Power Apps, SharePoint, Azure Cloud Services, ERP integrations, Python (Plotly - Dash, PyQt5, Selenium, Pandas, more), Data Analytics & Visualization, Power BI, Custom Dashboards, Document Automation, KPI tracking, Process Optimization, O365, Azure MS SQL, MS Access, SQLite, Postgres, MRP, ERP ---Professional Experience--- With 4+ years as a full-time freelancer and 11 years in manufacturing engineering, I've evolved from a Project Engineer (with a Mechanical Engineering Degree) to a Lead Software/Automation Engineer. My 11 years in manufacturing started with a company with ~200 employees, then acquired by an enterprise publicly traded company where I continued to work for another 5 years. This unique trajectory has honed my ability to: - Develop robust, effective yet easy to use, software solutions - Understand diverse business processes and stakeholder needs to create tailored, goal-oriented tools ---Industries Served--- Manufacturing | Engineering | Operations | Supply Chain | Sales | Accounting | Finance ---My Approach--- I collaborate closely with stakeholders to ensure solutions are user-friendly and aligned with business goals. My diverse background allows me to quickly grasp complex processes and translate them into efficient software tools. ---Example Projects--- - Custom Product Configurator with automated analysis of engineering specifications, BOM, Labor costs, lead-times, manufacturing processes, and document generation - Inventory and Supply Chain Data Tracking and Analysis - Production floor planning and analysis for revenue and OTD optimization - Financial analysis - Automated scripting, document creation, data entry, and more - ERP data design and add-on tools (Baan and SAP experience) - Data mining, aggregation, cleaning, etc. - API Integration with custom software tools with OAuth Authentication via Excel / VBA or Python - Combined Excel VBA and Python tools, utilizing modern Python features from within Excel User Interface - Data Visualization, KPI Metrics, Custom Dashboards - Windows 365 Virtual PC Utilization, Scheduled Automations to SharePoint Shared Folders - SQL Data serialization, JSON with SQL integration for combined structured and NoSQL data. - Excel to Python bridge, utilizing modern Python technology seamlessly within Excel-based tools. ---Let's Optimize Your Business--- Ready to transform your time-consuming tasks into streamlined, automated processes? Reach out and let's chat!