Engineering Heritage & Innovation

For four decades, I have specialized in the 'impossible' middle ground: bridging legacy back-office environments with the cutting edge of the cloud. Below is a map of the technologies and systems I have mastered, migrated, and fused to keep enterprise operations at peak performance.

The Professional Journey of Andrew Bottoni

Four Decades of Bridging Foundational Engineering and Cloud Innovation

I. Foundations: Low-Level Mastery & Cross-Platform Pioneering

My career began in the silicon-level era of the early 1980s, engineering high-performance systems in Assembler, Pascal, C, and C++. At Teleware (BestWare), I was a core architect for the Market Manager portfolio suite. Initially developed for the Apple II, I spearheaded its migration to the PC—a project that established my lifelong focus on multi-platform portability.

This expertise evolved into the development of M.Y.O.B., a flagship accounting system. I led the architectural transition from Macintosh to the nascent Microsoft Windows environment, mastering the complexities of UI/UX parity and cross-platform data integrity long before modern frameworks existed. Later, at Avantos Performance Systems, I managed a unified C++ source base for ManagePro, ensuring seamless interoperability across Mac, Windows, and Unix (X-Windows) while solving deep-level database alignment and memory-management challenges in real-time.

II. The Core: Enterprise Data Orchestration & ERP Modernization

For the past two decades, I have specialized in transforming the "back-office" into a high-velocity data engine. My work is defined by the fusion of VBA (Application Layer) and T-SQL (Orchestration Layer).

Financial & Telecom Automation: At Information Strategies Group, I revolutionized manual data workflows by architecting automated ETL pipelines. I replaced manual entry with direct ISDN/EDI integrations, building a massive data dictionary tree that allowed SQL Server to ingest and process telecommunications data at a scale previously impossible for the firm.
ERP Fusion : Since 2006, I have acted as a Lead Systems Integrator at Team Systems, building libraries that allow legacy ERP environments to communicate with modern SaaS platforms like Salesforce, Sage, QuickBooks, Samsara IoT cloud, and Fintech gateways.
Infrastructure Optimization: For Colonial Surety Company, I managed a 100MB+ mission-critical Access environment. I modernized the architecture by moving away from traditional linked tables toward detached CRUD forms and dynamic T-SQL pass-through queries. This reduced latency and allowed legacy systems to operate with the speed of a modern web application.

III. Innovation: Distributed Systems & High-Availability Mobile

I have consistently pushed the boundaries of "local" software into the mobile and cloud realms. I architected the SmartID™ anti-counterfeiting system and the FirstWitness™ safety network—both powered by a PHP/MySQL back-end running on high-availability virtualized server farms.

These systems utilized load-balanced application servers and synchronized MySQL suites to ensure zero downtime. I personally developed the native mobile interfaces—Objective-C for iOS and Java for Android—ensuring that complex back-end logic was delivered through a seamless, responsive user experience.

IV. Today: IoT Interoperability & API Fusion

Currently, at Smartflow Data, I specialize in "Data Alchemy"—turning raw telemetry into business intelligence. My primary focus is the bi-directional integration between internal SQL environments and the Made2Manage Cloud.

I architect headless data pipelines that ingest complex JSON structures via the Samsara API. Using OLE Server Objects, Common Table Expressions (CTEs), and CROSS APPLY logic within T-SQL, I normalize nested JSON sub-arrays into high-performance SQL tables. This allows for real-time synchronization between "on-the-road" assets and "in-office" ERP systems, providing a unified view of enterprise operations.

V. The Frontier: Cloud-Native Infrastructure & AI

My current technical focus is the migration of legacy logic into Cloud-Native environments. To support this, I architected a multi-node, bare-metal Kubernetes (K8s) cluster using a fleet of headless ARM64 nodes managed via Rancher on VMware vSphere.

This private cloud lab allows me to experiment with:

Microservices: Containerizing PHP and MySQL stacks for infinite scalability.
Distributed Security: Implementing Blockchain nodes to study decentralized encryption protocols.
Generative AI: Training and testing local LLM models to explore the next generation of automated business logic.