Justin Hild

• Managed the API services through the Azure platform, including updating documentation, troubleshooting issues, and issuing API keys.
• Maintained our integrated services with various companies.
• Worked with our partners to ensure accurate data was being sent and received.
• Diagnosed issues with integrations running on platform currently.
• Interacted with clients to assist setting up and maintaining integrations.
• Worked with a team to ensure every customer need was being met.
• Developed an automated integration through Zapier to submit web forms through our API.
• Tracked down errors in our codebase to assist with completion of Jira tickets.
• Created internal documentation on the various integrations we worked with, along with related SQL queries.
• Applied SQL knowledge to assist in troubleshooting product errors.
• Tested our API in order to provide a better understanding of its capabilities to our internal team and customers.
• Developed custom tools using Python, ODBC for SQL Server, and Selenium for querying across multiple databases, formatting JSON/XML/HL7, automating the set up of plugins and Integrations, and validating data between our databases and the website.
• Wrote and reviewed technical issues through the Jira platform.

• Designed Random Forest Classifier and Random Forest Regressor algorithm using Scikit-Learn, Pandas and NumPy libraries to predict outcome of leads and predict the probablilty a lead would go to sale with 97% accuracy on average
• Developed Random Forest Regressor model to predict the length of time a lead would spend living in a community.
• Migrated algorithm to Microsoft Azure platform through PowerBI and Fabric using Lakehouses and Notebooks to execute code using PySpark and SQL to pull data from our Datawarehouse.
• Worked closely with other engineers to aggregate correct data into a table.
• Used feature importance charts to select most accurate features for the model.
• Wrote SQL queries running on the Spark platform to create tables that were more easily accessible from the machine learning algorithm.
• Tested different algorithms and features to find most accurate combination using feature importance charts, confusion matrices, and accuracy percentages.
• Preprocessed data using Imputers, Label Encoders, One-Hot Encoding, and Ordinal Encoding.
• Designed, implemented and evaluated new models and rapid software prototypes to solve problems in machine learning and systems engineering.

• Managed the support desk, including several coworkers working as Tier 1 Support Engineers.
• Developed and documented a variety of procedures being used, including a comprehensive list of SQL scripts, onboarding procedures, and training materials.
• Responded to customers support related issues promptly and thoughtfully, solving issues ranging from integrations issues to account troubleshooting.
• Worked closely with other IT professionals to integrate various services into our product including Office 365, EWS, Mailchimp, Twilio, and several other CRM-related integrations.
• Automated tasks using Python and Selenium in order to optimize our efficiency.
• Worked with Jira, Confluence, and ZenDesk systems in order to track and organize issues with the code.
• Filed bug reports to our development team in order to accurately document the issue.
• Worked closely with cloud services such as Azure and Visual Studio Dev ops to manage integrations and find errors in the code.
• Utilized SQL Server to diagnose and fix issues with the product.
• Performed regression testing when needed, and helped design several of the automated testing procedures.
• Worked closely with REST APIs to support various integrations.

MIDI RGB LED Controller:

• Developed an algorithm to convert musical MIDI notes into colors based on the key of the notes being played.
• Displayed the colors using an Ardiuno board to output the color to LED strips.
• Created a MIDI interface for the Arduino to convert MIDI input signals into digital inputs to be read, then redirected the output to MIDI signal to another source.

Discord Bot:

• Developed a general purpose bot for a discord server using the discord API and python.
• Maintained a testing and production version by developing the bot locally on WSL Ubuntu and deploying to the Google Cloud platform using Docker.
• Created several features that were unique to this bot including text effects, custom games, and utilities for moderation.
• Worked with Ubuntu in order to deploy automatic services, stream console output, and containerize using Docker for easy deployment.
• Hosted the code on Github in order to implement version control.
• Worked closely with other developers to collaborate on projects.

Online Recipe Book:

• Designed interface using React and the full MERN stack, as well as Material-UI components.
• Designed the initial website layout, including all of the routing and UX elements using UML activity charts.
• Worked with a team using Agile methodologies.

Web-Controlled Arduino/Raspberry Pi Project:

• Used Angular and TypeScipt to create the front-end web interface to show the sensor data and control the LEDs.
• Build basic API using NestJS/Express to allow Arduino to periodically send sensor data and receive instructions back (turn on/off LEDs).
• Create MySQL database to track sensor information.
• Programmed Arduino Uno using Python libraries such as Adafruit_NeoPixel and DHT.h/Adafruit_Sensor.hb to read temperature data and control NeoPixel LED rings.
• Programmed Raspberry Pi Zero W using CircuitPython libraries to control lights and access then device wirelessly.