Software Consulting

Previous: Maclean Brothers Drywall

Tags: Google Calendar API, Google Drive API, Google Spreadsheets API & JavaScript

Hired by a Drywall Construction Company (with 70+ employees) to work on various workflows for 3 different departments.

Each workflow adds features to their existing manual process; i.e. integrate calendar to create schedules from spreadsheet, create a spreadsheet-based estimating or quote tool, create Gantt charts in-spreadsheet, queue truck-rolls, add PDF to Gmail, etc. Code is private.

👍 TESTIMONIAL: Great job, would reccomend to anyone. Otto was a pleasure to work with and explained everything he was doing. I sincerely appreciate his professionalism and personal approach. - Tyson

Previous Internal: Dashboard App

Tags: Bootstrap, CSS, Firebase Hosting, GitHub, HTML, React, Reactstrap, SAAS & Webapp

Features TBD: add User Auth , add Profiles, and be integrated with Google Workspace Apps (Gmail & Sheets).

Previous: Add3 Digital Marketing

Tags: API Integration (Airfind), Google Drive API, Google Gmail API, Google Spreadsheets API, JavaScript & Python

Hired by an Advertising Agency to port code from Python to JavaScript and to automate a manual workflow. The workflow = parse Gmail > save files to Drive > import .csv to Sheets > parse & merge data > upload to Custom Report File. Code is private.

Previous: ClearSpace Builders

Tags: Airtable API, API Integration (monday.com), Google Drive API, Google Spreadsheets API, Integromat Scenarios, JavaScript, PDF Manipulation, Salesforce REST API & Visualforce / Apex

Hired by a Design-Build Construction Company (with 30+ employees) to work on Quote/Estimating automations for a design-group of 8. The automations involve API integrations to create a PDF Quote from various data sources (Salesforce, AutoCad, Airtable, Monday.com, Integromat, Google Drive & Google Sheets). Code is private.

👍 TESTIMONIAL: We had a complex project in three different platforms with many moving parts so there were changing requirements but Otto was respectful and professional about them. He was readily available to support adding new features, debugging errors, or any new scope that came up. Thank you for all your hard work Otto! - Angela

Previous: CodePath

Tags: CSS, Google Form API, Google Spreadsheets API, HTML, JavaScript, React & Webapp

Hired to create React Form with custom calculations to schedule interview sessions for job candidates. Data deposited into Google Spreadsheet. Note: For the demo, use test@demo.com .

Previous: Condo Blackbook Properties

Tags: API Integration, Google Spreadsheets API, JavaScript & Quickbooks Online API

Hired by Real Estate Agency to work on API Integration & Workflows for Commission / Escrow. Code is private.

Previous: Earth Apples

Tags: Gmail API Service, Google Drive API, Google Spreadsheets API PDF Manipulation & JavaScript

Hired by a Potato Farm which sells packaged products to retail stores. The task: build a Sales Tool with the following features: create PDF quotes, track inventory & orders, email-to-pdf, save all data in client folders, etc. Code is private.

👍 TESTIMONIAL: Overall I am very impressed with the quality of work from Otto. All points of concern that came up during the process were addressed. Communication was good. My only point would be that sometimes the feedback or answers to questions got a bit technical. However that is just the point where I would follow Otto's expertise and trust the process. In the end the result is what matters and that was top notch! All in all it was a great experience and I would most definitely hire him again!. - Phil

Previous: Helberg @ Compass

Tags: People Data Labs API, Google Drive API, Google Spreadsheets API & JavaScript

Hired by Licensed Real Estate Agents (5-person team) to enrich 5,000 row dataset from 12 fields to 30+ fields. The enriched data is used as qualified leads for property sales. Code created to integrate API, parse JSON data into Google Spreadsheets, and produce a CSV file that is imported into the company's CRM. Code is private.

👍 TESTIMONIAL: Otto delivered quality work and I enjoyed working with him. His communication was clear and his skills were strong. I added several deliverables midway through the project and he adjusted to the new requirements with ease. I will hire him for additional jobs in the future. - Brett Helberg

Previous: Kindred Pest Control

Tags: Airtable API, Automations, Google Drive API, Google Spreadsheets API & JavaScript

Hired by 12-person team to code several projects. Most recent automation is to backup Airtable data to Google Drive (as JSON files) & parse data into Google Spreadsheets. Code is private.

Previous: Krueger Real Estate

Tags: Google Spreadsheets API, Google Webapp & JavaScript

Hired by 25+ person real estate team to upgrade code by adding new search features. Enabled the company to search by agent, location, price, source, etc. Code is private.

Previous: Paragon Labs

Tags: Google Spreadsheets API, Google Webapp, JavaScript & jQuery

Hired by a Supplement Manufacturing Company (80-employees) to replace an exiting Google Form with a custom, dynamic webapp that does a compute process before, during, and after form submits. The dynamic Webapp is used by 50+ staff during pill/supplement production. Code is private.

Previous: The Rose Theater

Tags: Google Calendar API, Google Spreadsheets API & JavaScript

Hired to create a custom app to manage Calendar Events for Classes & Camps; i.e. from spreadsheet, manage over 3,000 events per year, spread over 30 different calendars with per event: 10+ attendees, 3+ rooms, + misc. event data. Code is Private.

👍 TESTIMONIAL: Otto was a pleasure to work with! He's professional, always available to answer questions and is flexible whenever we had to change scope. We have a good working relationship with him and definitely will continue to hire him for any future jobs. - Jackie

Previous: Triton Capital: Trifigo App

Tags: AWS Lambda & S3, CSS, Expo, HTML, JavaScript, React & React Native

Hired to do code review of API Integration and if problems found, fix them. Required to test integration & compile all code to specific platforms: Web, Android, iOS. Code is private.

Previous: Under The Radar Report

Tags: Auth0, Chargebee, Google Apps Script (GAS), Google Spreadsheets API, JavaScript, Integromat / Make & no-code development

Hired to create via no-code & low-code: a role-bsed access control workflow using Auth0, Chargebee, Make, & custom (JavaScript) code. Code is private.

👍 TESTIMONIAL: Otto is a creative thinker, problem solver. Understands your business needs and then implements. Always available during the project and after it was completed. - Kelsey

Previous: Ventura Consulting

Tags: C7 API, Google Spreadsheets API, Google Webapp & JavaScript

Hired to create a custom webapp, inside an iFrame on the C7 Winery Platform. Code is private.

👍 TESTIMONIAL: Great communication. Excellent methodologies. Great overall experience. - Cristian

Donation: Tezos Lottery

Tags: Blockchain, CameLIGO/Ligo & Tezos

Improve Lottery Contract prior to deployment into blockchain.