Nicholas Tesoro

Relational Databases

• Created databases for managing recipe, user, and site information. The recipe database is designed to hold recipes, steps, ingredients, notes, and photos. The user database is designed to store user information, suggestions, and local storage (e.g. cookie) information for GDPR regulations.
• Designed views and stored procedures where appropriate to build out API functionality.
• Optimized data flow for speed and reliability while considering user input.

ASP.NET Core Data Access Transport Layer

• Architected data access structure with the capablility of accessing SQL Server databases in a structured manner.
• Built data access classes for generic API executions and strict database access methods.
• Designed hierarchical data models that preserve database schema while preventing front end visibility of sensitive data.

API and MVC Front End

• Utilized Microsoft MVC and API controller tools to build end points for data acquisition.
• Added data access to front end for optional server-side rendering techniques.

JavaScript Startup Class

• Designed API Fetcher class to perform API fetches in a structured, reusable manner. Created extra method to catch exceptions when error handling is fully implemented.
• Designed Storage class to get and set Cookies, Session tokens, and Local Storage items. Cookies are automatically stored into an object accessible by JavaScript with methods to add and remove. This class is utilized for the home page's trending card view count statistics.

Image Management JavaScript Classes

• Designed image importer that automatically assessed file types and sets object properties to easily add images to any page.
• Built custom image carousel with viewport and pagination functionality. Images can be infinitely scrolled both manually and automatically with an optional pause feature for automatic scrolling. Autoscrolling restarts after manual input and a configurable timer.
• Built custom menu list class with viewport and selection container. This class is utilized for the home page's trending card and allows for hovering over a list of items and displaying the accompanying image within a seperate container.

Home Page

• Featured and Blog cards use API calls to generate static display data.
• Trending card utilizes autoscrolling code to dynamically show images from trending recipes which stops as a user interacts with the card.
• Suggestion card utilizes a multitude of user behavior checks to validate the suggestion form and minimize garbage data collection and malicious attack vectors from the front end.

Recipe List Page

• Utilizes the image importer class to display the first available image for a given recipe.
• Animates cards upon load. A button loads more available recipes while preserving the loading animation.

Recipe Page

• Utilizes the image carousel class to display all available recipe images alongside static page data.
• Created an event listener for when the StorageClass fires a loaded event to track recipe page views. This listener requires a valid UserId GUID cookie and for the page to be navigated to. Any access to the page via refresh for back-forward browser behavior will not record a view.

HTML and CSS

• CSHTML files are utilized to take advantage of Microsoft tools and MVC hierarchical structure as well as dynamic injection of JavaScript, CSS styles, and other data.
• Modern CSS is used to prevent legacy bloat and encourage users to use a modern browser while preserving full functionality in Google Chrome, Safari, and Firefox. These tools enable less code to be more clever and functional for the purpose of beautification.

Hosting

• Migrated databases to Azure SQL Server database. Modified SQL to be compatible with Azure hosting.
• Upgraded API and Web projects to .net 8.0 for long term support.
• Managed API and Web project database permissions and documented a workflow for future reference.
• Generated SSL certificates with Cloudflare and translated them between formats for use in Azure to utilize a custom domain.

• Developed and implemented a Notion-based tracking system for client projects, meetings, and deliverables, streamlining communication and ensuring transparency.
• Designed and maintained an advanced production tracking spreadsheet to monitor client projects, materials, quantities, and pricing, ensuring accuracy and efficiency in operations.
• Managed and coordinated artist responsibilities and deliverables, ensuring projects were completed on time and in alignment with client specifications.
• Oversaw client relationships and expectations, managing communications through text, email, and in-person meetings, ensuring clarity and satisfaction throughout the project life-cycle.
• Managed the end-to-end manufacturing process of a 300-piece client project, from initial design to final production, ensuring high-quality standards, timely delivery, and cost-efficiency through optimized production workflows and strict quality control.

Order Management System Migration

• Played instrumental role changing OMS providers that feeds master accounting databases for allocations, commission, trade details, and client reports.
• Detailed processes which are impacted by legacy fields no longer provided and enacted solutions to rectify any discrepancies in crucial data.

Account Rectification Application

• Replaced aging application with a vital maintenance system for broken account data that links clients to trader commission.
• Combined multiple unique data imports into one system to improve operations department workflow.

Error Acknowledgement Application

• Developed a bespoke platform for the traders, compliance department, and other management staff to audit business transaction errors.
• Reduced internal audit time by implementing restful APIs and custom front end interface with compliance-mandated user-input tracking.

SQL Server Reporting Services Migration

• Reduced SQL Server licensing costs by 90% per year by implementing an in-house replacement for data-driven subscriptions across eleven fewer servers.
• Saved weeks manually migrating financial reports via automation and created SQL Server jobs to manage essential client reports with automatic delivery via email and SFTP.

API Consolidation

• Reduced code compile time by removing redundant, deprecated code. Organized startup processes into neat code blocks for future maintainability.
• Updated stored procedures and APIs on both server and front end points to use new development standards for every crucial project. Manually sifted through every single front end API fetch request to utilize new controller end points and ran quality assurance to maintain functionality.

Custom Dropdown JavaScript Class

• Created a JavaScript module that implements a custom dropdown menu input reducing development time on applications with both single and multi-select dropdown requirements. Included autofill and keyboard entry capability through a filtered list of options that updates while the user types.
• Thoroughly documented functionality and implementation requirements with examples to simplify future utilization. Included a quick-start guide for maintainers to understand how to quickly utilize this class while explaining how the code functions.

Project Management in Azure DevOps

• Translated high-level discussions and ambiguous requirements into clear, prioritized action items to improve team efficiency and facilitate knowledge transfer.
• Collaborated with stakeholders to gather feedback, define feature requests, and implement functionality enhancements aligned with product roadmaps.
• Maintained comprehensive project and support documentation within the internal Wiki to streamline task handoffs, reduce development overhead, and ensure continuity.