Chief Technology Officer (CTO)
2018 - 2022Aloft UAV- Created spatial mapping, air operations, and imagery management apps for agricultural UAVs, encompassing mission plans, flight log data, and multispectral NDVI geo-raster imagery. Used Oracle Spatial, Oracle Cloud Infrastructure, and Oracle APEX.
- Built real-time UAV telemetry sharing data network using MAVLink over dedicated and long-term evolution (LTE) connections. Provided network for mission control, telemetry, and imagery.
- Configured and used Jira, Jira Service Desk, Confluence, and Bitbucket for product planning, project management, issue tracking, documentation delivery, build automation, and customer support.
- Configured site monitoring and alerting using Oracle Enterprise Manager, Snort, Nagios, and Checkmk.
Technologies: Oracle Cloud, Oracle Application Express (APEX), Jira, Atlassian Suite, Oracle DBA, PL/SQL, Oracle Spatial, GIS, ArduPilot, MAVLink, Oracle PL/SQL, Oracle SQL Developer, Data Modeling, Oracle SQL Data Modeler, Process Flows, Process Design, DevOps, Agile DevOps, Jira Administrator, Linux, Windows System Administration, Architecture, SQL, Kubernetes, Docker, Bamboo, GitOps, VPN, XML, Oracle Graph, IT Consulting, Data Architecture, Agile Practices, Jira Administration, Entity-relationships Model (ERM), ETL, Database Administration (DBA), Databases, Oracle DatabaseDevOps Consultant
2019 - 2019ITSoft- Designed and implemented a multi-cluster Kubernetes or Rancher environment for a managed service provider (MSP) application delivery.
- Completed cloud and cluster migration of multiple PostgreSQL, MySQL, and SQL Server instances.
- Administered multiple instances of PostgreSQL, MySQL, and SQL Server.
- Updated and improved DevOps processes with a development team to support migration to the cloud.
- Created and managed an internal multi-national and multi-site network.
Technologies: Linux, PostgreSQL, MySQL, Kubernetes, Maven, Jira, Hyper-V, Networking, Rancher, Agile DevOps, Docker, Istio, Splunk, NGINX, Grafana, VyOS, Jenkins, Bamboo, Bitbucket, GitOps, Git, VPN, Oracle SQL Developer, Process Flows, DevOps, Windows System Administration, Architecture, SQL, Windows, IT Consulting, Database Performance, Agile Practices, Entity-relationships Model (ERM), Database Administration (DBA), Databases, Microsoft SQL ServerPractice Manager
2002 - 2017CaseIntel Corporation- Acted as the architect for NetGIS, an application for electric utilities that maps their complex redundant downtown electrical distribution networks using AutoCAD and Oracle Spatial and Graph.
- Managed NetGIS product development. Developed complex PL/SQL and Java Oracle applications and used Oracle Spatial, Network, Graph, Oracle AQ, Java, and Native XML in the database and CQN.
- Built an Oracle Native XML-based CIM data hub (IEC 61968-100 compliant) for electric utilities to support IEC 61968 and 61970 standard CIM requests, transactions, and events.
- Developed CaseIntel, a criminal intelligence data mining system based on Oracle. Used a data lake to extract models of criminal networks, inter and intra-case linkages between suspects, phones, weapons, vehicles, and communication records.
- Created multiple business intelligence applications for the maintenance and operations of electrical distribution equipment. Facilitated predictive and preventative maintenance planning and equipment fault analysis.
- Designed an Oracle Streams-based memory replication architecture and system for an automated fingerprint identification system (AFIS) to support cache coherence of an application object cache across Oracle MAA architecture utilizing Oracle RAC.
- Implemented dashboards using Oracle Warehouse Builder, BI Publisher, and OBIEE for utility network management.
- Conducted Oracle database security hardening. Worked with Morpho Trak to modify the minimum baseline security standard (MBSS) AFIS in support of FBI and DHS implementations to achieve DoD STIG and DHS secure configuration standards.
- Architected and implemented Oracle RAC and Active Data Guard (MAA) distributed platforms for Hexagon Intergraph outage management systems at several US-based utilities.
- Completed many setups, administration, and tuning consulting engagements using Oracle Real Application Clusters (RAC), Oracle Data Guard, Oracle ASM, and Oracle Advanced Queuing (AQ) on Windows, Linux, HP, Sun, IBM, and VM. Versions 6-19c.
Technologies: Oracle, Oracle DBA, Oracle RAC, Oracle Data Guard, Oracle PL/SQL, Oracle Designer, Oracle SQL Developer, Data Modeling, Oracle SQL Data Modeler, Process Flows, Process Design, DevOps, Agile DevOps, Jira Administrator, Confluence, Java, Linux, Windows System Administration, Architecture, SQL, Hyper-V, Bamboo, GitOps, VPN, Atlassian Suite, Oracle Spatial, Windows, XML, Oracle Graph, Management Consulting, IT Consulting, Process Reengineering, Database Performance, Data Architecture, Oracle Forms, Oracle Data Miner, Agile Practices, Jira Administration, Entity-relationships Model (ERM), PL/SQL, Business Intelligence (BI), ETL, Data Lakes, Database Administration (DBA), Databases, Oracle Database, Microsoft SQL Server, Data EngineeringPractice Director
1986 - 1999Oracle- Led and worked as a data architect on a project to automate the manufacturing process at an aerospace manufacturer's sheet metal fabrication plant. Managed the team architecting and building a data integration hub for the shop floor plan data.
- Worked as a data architect for a customer service division of Boeing for an SGML-based technical document authoring and production system responsible for producing and managing highly complex technical documentation.
- Developed a retail sales snowflake dimensional data warehouse for grocery store beer sales for Anheuser-Busch.
- Acted as a founding member of the Oracle Business Process Reengineering (BPR) consultancy. Wrote the Oracle BPR methodology, a streamlined reengineering methodology that leverages modern process engineering tools and agile development processes.
- Conducted training for hundreds of internal Oracle consultants and external clients around the US and globally on data architecture, data modeling, process modeling, and Oracle development methodologies.
- Re-engineered procurement processes for the Ford electronics assembly plants in Sao Paulo and Lisbon.
Technologies: Oracle, Data Architecture, Database Performance, Process Reengineering, IT Consulting, Management Consulting, Oracle PL/SQL, Oracle8i, Oracle RAC, Oracle Designer, Oracle SQL Data Modeler, Process Flows, Process Design, Java, Linux, Architecture, SQL, Oracle Spatial, XML, Oracle Graph, Oracle Forms, Oracle Data Miner, Agile Practices, Entity-relationships Model (ERM), PL/SQL, Business Intelligence (BI), ETL, Database Administration (DBA), Databases, Oracle Database, Data Engineering, Roadmaps