Wallis Williams

I developed an interest in software development after using Microsoft SQL Server since 2015 working in software configuration QA and testing. I completed TrueCoders' Full Stack Software Engineering self-paced bootcamp learning Git, C#, JavaScript, CSS, APIs, JSON, and more SQL. I secured a new role as a Product Owner at the beginning of 2024 have been able to expand my SQL skillset to include Oracle databases using Toad Data Point. Check out my skills, projects, and work experience below. Thanks!

Skills

• Code in C#, CSS, HTML, JavaScript, JSON, and SQL
• Write complex SQL DQL statements (and DML statements to create temp tables)
• Build and manage new processes
• Document software configuration and configuration QA procedures using Atlassian Confluence

Projects

CRUD Inventory Database Website: ASP.NET MVC | C# | HTML | CSS | SQL

• Built in Visual Studio using the ASP.NET Core MVC Framework, this project allows users to perform Create, Read, Update, and Delete functions on items in a MySQL database.
• Utilized JSON to connect to a MySQL mock Best Buy database
• Used C# to:
  • Create a "Product" model - containing properties mirroring the Product table's columns from our MySQL database
  • Create an IProductRepository interface
  • Create a ProductRepository class conforming to IProductRepository, that accepts an IDbConnection variable as its argument
  • Create Razor Views (HTML/C#) and MVC Controller Classes, integrating Dapper ORM and parameterized SQL queries to allow users to perform CRUD operations on products-related tables in the database

"Taco Parser" - CSV Parsing and Geolocation Console Application: .NET Core | C# | xUnit

• This .NET Core application, also built in Visual Studio, parses data from a CSV file containing geolocations of restaurants in order to determine which are farthest from each other
• Wrote xUnit tests in order to apply Test-Driven Development
• Used File.ReadAllLines(), then string.Split() to create an array containing a collection of strings (each string representing a restaurant, containing location name, latitude, and longitude data from the CSV file)
• Extracted name, latitude, and longitude from each array using a custom Parse method
• Created restaurant objects using the parsed CSV data as the properties for each object
• Called our custom Parse method using Linq's Select method to create an array containing all the restaurants (ITrackables)
• Calculated locations with maximum distance between them (using nested for loops to traverse through all locations and using GetDistanceTo() method from GeoCoordinate class)

Weather Application - API | .NET Core | C#

• This basic console application shows the current weather for the requested city, by calling the OpenWeatherMap API)
• Used C# and the Newtonsoft.Json NuGet package extension in Visual Studio