Juan Daniel Sanchez Cambronero

I created a set of applications to manage the workflow of many parking garages in Australia owned by the client.

The first system was a web application embedded into a Squarespace site. This web application is connected to a third-party API in New Zealand to get the ticket information and another third-party API to process the payment. Afterward, an email is sent to the user, and the ticket management system is updated with the payment.

Another system created was an ETL process that pulled information from a camera management system that monitors the parking garages 24/7 to get the time of arrival of cars to mark exceptions depending on specific business rules.

Everything was deployed in an AWS environment, using technologies such as React, Node.js, and TypeScript.

I led a team of eight resources and was the primary architect for the system. Three main applications were built as described below:

The first is a custom content management system for admins to register new events and any related information for the fighters or necessary information for the organization. This system was built using a serverless API with AWS Lambda, Prisma to connect to the database, and NestJS to organize the code and provide security configuration, among other things. For the front end, we created a single-page application with React.

The second is a responsive website using Next.js and React—we were tasked to review the SEO and accessibility functionalities carefully.

The third is the mobile application using React Native. Besides using a serverless API, AWS Lambda, Prisma as an ORM, and NestJS as the two systems mentioned above, this application also integrated with Firebase to manage authentication and push notifications.

I also created a set of ETLs to migrate all the information from a legacy system to the new database schema.

A React-based application to process the payments for all the company's employees.

This system provides a simple overview of what each employee must be paid on payroll, plus providing reports for the accountants, pay stubs of salaries for each employee, and many other functionalities.

The UI was built using React as a single-page application and Material UI as the framework. The authentication is made through Cognito from AWS. The backend is built using a Serverless API with GrapQLl, NestJS, and Prisma as an ORM to connect to the database.

A separate service was created to generate the pay stubs with a queuing system using AWS SQS to speed up the process and avoid Lambda's execution time limitation in AWS.

A customer-oriented application that helps manage drone flights, keeping a record of the routes, pilots, and licenses, and handling all the related parts that require maintenance in a drone.

I collaborated on building the system with a multi-tenant approach and designing it with a microservices architecture to scale as much as possible.

A .NET-based application using Web API for the back-end service and AngularJS for the front end.

This application was created for engineers to verify the proper distribution and correlation of concentrations used in their chemicals based on the type of testing and materials used for the manufacturing process.

For the front end we relied on KendoUI components to improve the development time and reuse components that fulfill the client's requirements. Also, we used Bootstrap as the framework and standardized the look and feel of the application.