Implemented an real-time event-driven ETL pipeline to migrate all of our various data sources into a big query data warehouse.

Implemented previously unstructured data into many separate SQL tables that conform to star schema architecture.

Integrated a white labeled Thought Spot's data analysis feature into the Chekhub product, which allows for ai integrated charting and reporting, replacing previous functionality.

Created generative AI solutions using gemini, and google cloud functions such as:

• A SQL query generator that queries our data warehouse and answers a plain english question back in plain english.

• root cause analysis based on make/model

• summary of work completed for our ticketing system

Using Vue.js (frontend) and Nest.js/Node.js (JavaScript/typescript). Helped in the design maintenance of a cloud-native building automations application (KMC Commander). The app communicated through BACNet, Modbus, SNMP to a physical gateway. Being a mostly a legacy app my main responsibility was to address bugs, and customer requests in a timely manner. That being said I also:

• Implemented full interopability between Tridium's Niagara application and physical box, Making it completely seamless for customers that use the number one market solution for on-prem building automation to transition to KMC Commander, allowing cloud based control of a building.

• Overhauled the Server-rendered JQuery licensing system to Node.js/Vue.js which added features such as automating the previously manual process of issuing sales and purchase orders. Automated customer invoicing and payment processing. Created automatic billing report emails. Implemented the code to restrict the user when their license expired.

• Created energy management functionality that would change temperature in rooms people weren't using. Dim lights if no activity was detected. Optimize air flow through the internal HVAC system. Which allowed our users to take part in a DOE energy rebate program, which allowed them to use our software/hardware for free, while also helping the environment.

Maintained both frontend and backend systems. Responsible for creating and maintaining a reports and charts services. Created a reporting system that exported almost every schema in a database in a structured format. Used mongoDB aggregations to create complex graphs and trends.

Working directly under the CTO, as a team of two using Node on the back-end and react on the front-end together we built out a scalable, optimized, and responsive full-stack application. During my time at Translator I learned that creating software products in a b2b industry requires immense dedication to quality and consistency. While at the same time working in a small startup requires incredible flexibility and responsibility.

Learned industry best practices and practical software development standards with a focus on HTML5, CSS3, JavaScript, jQuery, Node.js, postgreSQL, MongoDB, React, Redux, as well as algorithms and data structures

Created and deployed mobile-first applications while learning new languages and frameworks by collaborating several hours every week with a senior web developer.