Background: In Media Analytics, Airflow jobs are used frequently to kick off tasks/jobs that would query a database in a certain way as to give the analysts worthwhile data about how certain media is used by certain parts of the population. This data is crucial in marketing and targeted media advertisement and very useful to our customers. These Airflow jobs can be complicated, though, so developers typically have to create a JSON form in order to help the analysts run them better. This project cut out the need to use developers to constantly edit JSON forms by making a configuration database that utilized typical web forms to create the JSON forms that could then kick off the Airflow jobs. The developer would only have to make the initial form, and the analysts could easily change the values themselves through the intuitive launcher. The form editing page even had a real time form renderer that could constantly give you a preview of what your form would look like.

Design: I used a Clojurescript layout for the frontend because the closely tied re-frame library would allow me to have the form window "subscribe" to the JSON editing window to constantly update itself as the JSON was changed. By working with the half of my team that created the API, I was able to integrate the two seemlessly so that the JSON form data could be easily saved, retrieved, and edited later. I also made a rudimentary login page, such that there would be a unique experience for both the developers and the analysts, and such that there would be no fear of analysts accidentally altering the JSON forms working behind the scenes. Before handing off the project to the teams that would utilize it, I made extensive notes detailing how to connect the app to their individual Airflow jobs, thus allowing my application to be utilized across the Nielsen company.

Skills showcased: Clojurescript Frontend Design, Re-Frame, Reagent, GUI Design, Agile Development, Product Management

Background: While many medical devices in hospitals stay put in their designated departments, IV pumps tend to roam about the hospital quite frequently. This makes it hard to find them whenever it is time to do their annual preventative maintenance or when one floor is in need of more pumps than another. In our hospital, we use RTL tags and the Mobileview software in order to locate the pumps when needed. Unfortunately, the software does not allow you to find more than one pump at a time, and it is quite the time consuming process because you will frequently have to search for the pumps as they are continuously moving. Thus, a more time efficient process of finding the pumps was needed.

Design: I began by using the Selenium web scraper to navigate my hospitals Mobileview app and find the various bits of information about each pump (PM month, location, battery status). I then organized this information in a variety of modalities (to be used by both management and the technicians). I then designed a GUI with Tkinter, and added the additional options of just looking for assets in certain PM months, allowing for custom asset lists, giving different options for those without admin accounts, and allowing the user to email out the results. I then compiled the program using pyinstaller to allow my teammates to run it without any programming knowledge. Finally, I made up a fully encompassing test to ensure they set up the program correctly on their own machine.

Skills showcased: SQL manipulation, GUI design, selenium web scraping, script testing, Excel exporting, SMTP server access

Background: Knowing early on that e-commerce web development is a profitable market, this was one of my first projects I started. But being how much there was to learn, it was a project that I kept working on throughout my learning. I wanted a site that was simple, elegant, easy to navigate, and easy to update. Through this, I learned much about web hosting, mobile friendliness, and what design aspects are most important for customer satisfaction.

Design: I began first with the inventory and how best to showcase the items. I researched many sites designs to see what worked. I settled on a basic four category design with various levels of sorting and customizing. I then tested this out with a randomized item inventory I made up. I expanded on this SQL based inventory to allow sorting, searching, etc. It was quite fun designing the navbar, splash screen, and mobile designs after that. I did find I could waste a lot of time trying to make things perfect. I went on to add a contact page, newsletter sign up, and social media links as well to complete the basic e-commerce layout. This is one project that will continue to be updated as I progress.

Skills showcased: AWS, Django web framework, SQL inventory management, admin layout design, web development, SMTP emailing

Background: Inspired by Cat Facts, I thought an app that randomly chose a fact, picture, and sent it to someone was a good first choice for my first fully fleshed out app. I initially wanted to have email and texting a possibility, but later just stuck with email for simplicity sake.

Design: After finding the facts, I used Wiki Commons in order to get animals that matched every fact. Then I went about making a simple form that would collect desired info, and generate a list of facts and picture that could then be sent to the email using my Mailgun account.

Skills showcased: MVC design, SMTP emailing, basic web design, Django web framework, Mailgun

Dark Dungeon Escape: This is a basic text adventure with alternating paths, multiple endings, and multiple failures as well. As this was my first game, it is quite crude in design and was basically an intro to Unity and C# for me. You can view my game outline I made here if you are interested. Otherwise, feel free to check out my game here, and enjoy!.

Skills showcased: Game Development, Unity, C#