Information
Skills
About
I am a Senior Software Engineer with a broad range of experience for more than 30 years in the IT industry, including managing, training and customer support. Managing Director of small GIS and database software provider. Developed Software and designed databases for Oracle Corporation, Ricoh, Bank of the West, Starbucks, Akamai, Premiere Digital Services, Cargill and several startups. Author of “py2jdbc” Python package on Pypi to integrate Python and Java Database APIs.
Experience
Application for manual entry of plant/farm data points where automation was not available. Created a "custom API" between Power Apps forms and OSISoft/Aveva's "PI" web api. Wrote a small scraper that scanned "PI" web api documentation and automatically generated Python requests client wrappers.
Application managed movie and tv prices on streaming distribution retailers. Upgraded main Python application to Python3 and created Docker development environment. Gave presentations on Python “clean coding” and best practices. Worked next iteration of application, using Serverless, AWS Lambda (nodeJS and Python), DynamoDB, S3, SNS, SQS, MySQL RDS and Puppeteer for web scraping. Created Docker development environment containers and Bitbucket pipelines for automated quality checking and code deployments.
Wrote circuit board logical chip diagrammer UI using Django/PostgresSQL/React/Material-UI/Axios and Konva. UI allowed users to lay out logical diagram of chip inputs and outputs. Nodes could be dragged around, with routes (input/output lines) added and removed.
Helped to develop new certificate rotation workflow REST service. System is used to create or redeploy certificates in bulk upon expiration or when compromised. Used Python requests, OpenAPI/Swagger, Marshmallow to interface to corporate backends. Wrote extensive unit tests and mock servers for developer and QA testing. Application used Flask and PostgreSQL database. Agile and code reviews.
Developed internal website interface on top of Illumio (network security management) API. Migrated Python Django to Flask, SQLite to MySQL with database design. Connexion, SQLAlchemy, Marshmallow OpenAPI REST API, React and Redux Javascript front-end development. Pytest, Jest, Jenkins, Docker CI/CD testing and deployment using Github Enterprise and Jira. Agile and code reviews.
Customer leads generation and distribution for digital, ATM, e-mail, direct mail, branch and call center. Python, PETL, Redhat Linux, Oracle and Teradata RDBMS integration to BNP Paribas-supplied Java application. Python Flask with Jquery XML REST API integration to FISGlobal Touchpoint. Wrote Java stored procedures for enhanced encryption. Worked on several migration and enhancement projects. Reporting systems with Splunk, Informatica and SAP BODI. SOAP and REST APIs. Managed QA and production releases using GIT and Subversion. Created an internal “pypi” repository to store approved and internal Python packages. Worked on project to perform ETL tasks using Hadoop, PySpark, pig, pydoop, kafka and sqoop.
Developed middleware features for e-paper Android tablet. Managing WiFi and Bluetooth connections, interfacing to barcode scanners and printers, generating keyboard layouts. Python, ZeroMQ, dbus, ctypes integration with “inotify” system service to watch files. Git, nose for source code management and testing. Agile, scrum and code reviews.
Managed staff of 4. Created project proposals for Brunei government projects. Won 2009 BICTA special mention 2009 APICTA. Python, jQuery, MySQL, Oracle databases. Google Maps, qgis, HTML, CSS, jQuery web front end. Mobile web apps. GPS and AIS tracking apps. Supported GIS application developed for TelBru, (Brunei Telecommunication). Developed mobile application to view landline maps and information from NetMinister application.
Worked on “NetMinister” project to deploy Siemens GIS application to track phone landlines in Brunei for TelBru, (Brunei Telecommunication). C++, Visual Basic 6, Oracle PL/SQL and SQL. Python utilities.
Oracle Applications, Oracle Book, Oracle SupportNotes developer (working up from tech support). Java, PL/SQL, C, Oracle RDBMS Core development, C++, NLS internationalization. SGML and XML. Utilities and web servers in Python, Perl, C. Windows, Mac and Solaris porting.