Freelance Senior Developer
2020 - 2020Aoxoa Computing Services- Developed a smart IoT application to control LED light strings.
- Developed an Adafruit Huzzah-based hardware component to control and power a 5-meter LED light string, with photoresistor light-sensing capabilities and passive IR motion detection. I also developed hardware for power management.
- Designed and developed an iPhone application with Swift to remotely control the light system. All messaging and commands are routed through an MQTT server, currently on an Onion Omega2.
Technologies: Architecture, Hardware, Internet of Things (IoT), Scripting, Shell Scripting, Enterprise Architecture, MacOS, Sensors & Actuators, IoT Protocols, Code Generators, Documentation, Eclipse IDE, Object-oriented Programming (OOP), ESP8266, Data, Xcode, SQLite, Git, Unix, MQTT, iOS, C, Swift, Swift 5, Arduino, C++Senior Systems Analyst
2019 - 2020T4BI, Inc.- Provided support and fixed bug for a large health insurance system that was recently developed. This is a very large and complex system with business rules and logic in the database.
- Supported teams which are currently part of the overall business process (including sales, finance, and enrollment). I am part of the sales support team. All code goes through rigorous code reviews and follows a careful deployment and promotion plan.
- Worked on the system that uses a series of Java front-end subsystems corresponding to business areas. All database logic is coded in PL/SQL packages within an Oracle database.
Technologies: ETL, Data Engineering, Unit Testing, JSP, Scripting, Code Generators, Documentation, Oracle 12c, Object-oriented Programming (OOP), Oracle Database, Data Modeling, Data Analysis, Query Optimization, Data, Use Cases, Oracle ADF, JavaScript, NetBeans, jQuery, XML, Database Design, SQL, Unix, Oracle PL/SQL, Oracle SQL, Databases, Java EE, Java, PL/SQL, OracleIoT Programmer
2019 - 2019Toptal Clients- Developed programs for an Arduino Mega and an Nvidia Jetson Tx2 to communicate back and forth. The Arduino program read buttons and limit switches as well as controlled LEDs and stepper motors. The Jetson Tx2 captured and analyzed camera images and sent information to the Arduino. The Arduino sent "process state" information back to the Jetson Tx2, which then displayed images on an attached HDMI screen.
- Collaborated with the client to flesh out requirements, determine optimal processing paths, and debug issues on the actual hardware installation.
Technologies: Scripting, Shell Scripting, Enterprise Architecture, Sensors & Actuators, Microcontroller Programming, IoT Protocols, Embedded Systems, Code Generators, Documentation, Eclipse IDE, Object-oriented Programming (OOP), Data, Agile, Python, C++, Git, Embedded Hardware, C, Unix, Hardware, Internet of Things (IoT), NVIDIA Grid SDK, Jetson TX2, ArduinoSoftware Developer
2017 - 2019T4BI, Inc.- Worked on a team developing RESTful web services in Java to support a client's new redevelopment effort, with a very large Oracle 12c database back end.
- Enhanced and maintained two legacy applications (one with JSP code, and the other using Oracle Forms and Reports). There was some design work and requirements gathering involved, as well as some data modeling and PL/SQL work. All of these projects used an agile scrum-based approach.
- Developed Java web services with Java 8 and Spring, using Lombok automation to provide getters and setters and deployed on Kubernetes.
- Maintained web service documentation in Apiary and Confluence. Task scheduling was done in Jira.
Technologies: ETL, API Development, Data Engineering, Unit Testing, JUnit, Scripting, Shell Scripting, Microservices Architecture, Enterprise Architecture, Oracle Application Server, Data Integration, RESTful Microservices, Code Generators, Documentation, Data Quality Analysis, Oracle 12c, Eclipse IDE, Object-oriented Programming (OOP), Oracle Database, Data Cleaning, Data Modeling, Data Analysis, Query Optimization, Data, Use Cases, Agile, JavaScript, Spring, Microservices, Jira, REST APIs, Spring Boot, jQuery, XML, Git, Java EE, Database Design, SQL, Unix, Oracle PL/SQL, Oracle SQL, Databases, PL/SQL, Oracle Reports, Oracle Forms, JSP, Java, RESTful Web ServicesOracle Specialist
2016 - 2016ITI Technologies- Configured, troubleshot, and tested an Oracle Fusion Middleware setup.
- Ported a custom-built reporting solution from 10g to 12.2 with Oracle Reports, mod_plsql, and Pro*C components.
- Investigated and ensured consistency in database objects and grants across development, testing, and production environments.
- Assisted in recompiling and troubleshooting Oracle Forms and Reports modules.
- Investigated and developed documentation on configuration steps. Documented troubleshooting steps to assist support personnel.
Technologies: Scripting, Shell Scripting, Oracle Application Server, Documentation, Oracle Database, Data Migration, Oracle WebLogic Application Server, Oracle 11g, Unix, Oracle PL/SQL, Oracle SQL, Databases, Pro*C, Oracle, Linux, Oracle Fusion Middleware, Oracle Reports, Oracle Forms, PL/SQL, SQLWebsite and Application Support Specialist
2015 - 2016Peninsula Yoga Society- Provided support and enhancements to a nonprofit website.
- Developed reports and provided data analysis using SQL directly against their MySQL database.
Technologies: Scripting, Shell Scripting, MySQL/MariaDB, HTML, Documentation, Database Administration (DBA), Data Analysis, JavaScript, HTML5, CSS, MySQL Workbench, Database Design, Unix, Databases, SQL, MySQL, DrupalOracle Specialist
2012 - 2015T4BI, Inc.- Developed PL/SQL packages for member and dependent reinstatement processing in a large medical insurance system, based on use case requirements.
- Developed Oracle Reports as per-use case requirements.
- Coded PL/SQL packages for data validation/verification for a custom-built rules engine.
- Developed PL/SQL packages to convert six million data records into new data structures (to ultimately run within a two-hour window) according to use case requirements.
- Investigated and documented inconsistencies in data conversion input data to be corrected by another team.
- Attended weekly status meetings via phone and/or online meeting software.
- Participated and worked effectively and reliably as part of a large remote team, with great communication, and ensuring availability during core hours.
Technologies: ETL, Data Engineering, Unit Testing, Scripting, Shell Scripting, Enterprise Architecture, Data Integration, Code Generators, Documentation, Data Quality Analysis, Oracle 12c, Oracle Database, Data Cleaning, Data Migration, Data Modeling, Data Analysis, Query Optimization, Data, Jenkins, Hibernate, JavaScript, XML, Oracle 11g, Java, Database Design, Unix, Oracle PL/SQL, Oracle SQL, Databases, Java EE, Use Cases, Linux, PL/SQL, SQLLead Designer and Developer
2011 - 2015EMGI Systems, Inc.- Developed a PC-based system with Filemaker Pro for Windows and Mac, for a situational awareness system for major/catastrophic events.
- Designed and developed handheld "reporter" applications with a SQLite data store, in Java and Objective C, for iOS, Blackberry and Android devices to collect and send data to a PC-based analysis system.
Technologies: ETL, Data Engineering, Scripting, Shell Scripting, Spatial Databases, Enterprise Architecture, MacOS, Data Integration, Documentation, Data Quality Analysis, Object-oriented Programming (OOP), Database Administration (DBA), Data Cleaning, Data Modeling, Data Analysis, Data, Xcode, iOS, Git, MySQL Workbench, Database Design, Databases, Objective-C, Java, SQLite, FileMaker ProApplication Development and Support
2007 - 2012BC Ministry of the Environment (Provincial Government)- Developed enhancements and bug fixes for a number of corporate and/or business-area applications.
- Led JAD sessions with end users to define requirements for system enhancements. Translated requirements into designs and develop enhancements and patches.
- Investigated bugs, diagnosed issues, and developed solutions.
- Ensured that all work and processes adhered to government and ministry standards and guidelines.
Technologies: ETL, Data Engineering, Distributed Systems, Data Warehouse Design, Data Warehousing, Architecture, Oracle Designer, Scripting, Spatial Databases, Enterprise Architecture, Oracle Application Server, Data Integration, HTML, RESTful Microservices, Oracle Spatial, Code Generators, Documentation, Data Quality Analysis, Object-oriented Programming (OOP), Pro*C, Database Administration (DBA), Database Modeling, Oracle Database, Data Cleaning, Data Migration, Data Modeling, Data Analysis, Query Optimization, Data, Apex, Oracle Fusion Middleware, Use Cases, Oracle ADF, PostgreSQL, Python, UML, JavaScript, Spring, REST APIs, NetBeans, XML, HTML5, CSS, Oracle WebLogic Application Server, Oracle 11g, MySQL Workbench, Java EE, Linux, Database Design, C, Oracle PL/SQL, Oracle SQL, Databases, Oracle Application Express (APEX), Shell Scripting, Unix, Oracle Reports, Oracle Forms, Java, PL/SQL, SQLData Modeler (Contract)
2006 - 2009Integrated Land Management Bureau (ILMB; Provincial Government)- Developed data models for business areas.
- Created/generated scripts for object creation and data loading.
- Worked with business areas to model their data sets for including into the corporate spatial warehouse.
Technologies: ETL, Data Engineering, Data Warehouse Design, Data Warehousing, Scripting, Shell Scripting, Spatial Databases, Enterprise Architecture, Code Generators, Documentation, Data Quality Analysis, Database Modeling, Oracle Database, Data Modeling, Data Analysis, Data, UML, Oracle 11g, Database Design, Unix, Oracle PL/SQL, Oracle SQL, Databases, Oracle Spatial, Oracle SQL Data Modeler, Esri, SQL, Oracle Designer, OracleCorporate DBA and Oracle Support (Contract)
1996 - 2006BC Ministry of the Environment (Provincial Government)- Provided corporate database administration support across the Ministry for all their database instances, including troubleshooting, upgrades, and planning.
- Supported application deliveries by vendors to the Ministry infrastructure. Developed guidelines and standards for application delivery.
- Assisted and guided vendors and business areas in SQL queries, tuning, etc.
- Participated in JADs and vendor client meetings to ensure that all solutions are reasonable and follow all standards and guidelines.
- Troubleshot database and application issues.
- Provided ad-hoc queries for business areas.
Technologies: ETL, Data Engineering, Distributed Systems, Data Warehouse Design, Data Warehousing, Architecture, Oracle Designer, Shell Scripting, MySQL/MariaDB, Oracle Application Server, Data Integration, Code Generators, Documentation, Data Quality Analysis, Pro*C, Database Administration (DBA), Database Modeling, Oracle Database, Data Cleaning, Data Migration, Data Modeling, Data Analysis, Query Optimization, Data, Oracle Reports, Oracle Forms, Oracle Spatial, PL/SQL, SQL, Apex, Oracle, Scripting, Esri, Unix, Java