Telugu Puzzles

Full Stack Web Developer, Dec 2020 - Present

Website for creation and sharing of puzzles in Telugu. Link to website: Telugu Puzzles.

PHP and MySQL three-tier web application

• Enhancements:
  • Restructured puzzle folder structure and adjusted all relevant functions accordingly.
  • Designed and implemented Single Sign-on for several puzzle applications (subdomains) hosted under a single parent application (primary domain).
  • Enhanced user administration (add, update, delete, role management).
  • Implemented user authentication (login, logout, forgot password).
  • Enhanced puzzle, apps, and books management (CRUD operations, filters).
  • Provided summary reports for end-users and administrators.
  • Enabled PayPal integration for puzzle book sponsorship.
  • Streamlined the deployment and development processes for offline (localhost) and online (Bluehost) hosting.
  • Developed the "Catch A Phrase" puzzle application, cap.telugupuzzles.com
  • Hosted the enhancements to bluehost.com on a regular basis.
• Bug fixes:
  • Fixed session bugs caused by session_start not being at the top of the pages.
  • Adjusted several database foreign key 'on update' constraints to allow for deletion of parent records.

SILC Registration System

Web Developer, May 2019 – August 2019 and July 2020 – December 2020

Website for class registration for the School of Indian Languages and Culture (SILC). Link to website: SILC Registration System.

PHP and MySQL three-tier web application

Developed version 4.0 and supported the rollout of the enhanced registration system during the school year 2020-21.

• Enhancements:
  • Auto-sort data by last name.
  • Added visual indicators for paid/unpaid buttons.
  • Created and formatted a printable report of data.
  • Added detail to summaries of various pages.
  • Implemented codeless configuration to allow class roster access for administrators and teachers.
  • Developed the tracking mechanism for the sources of registration.
  • Enabled several reports (fees paid, fees due, household reports) for administrators.
  • Implemented role-based access control (admin, super-admin, treasurer).
  • Designed and implemented PayPal integration for registration fee collection.
• Bug fixes:
  • Discovered and fixed a query that had been deleting historical records.
  • Fix to redirect after hosting website changes broke core functionality.
  • Corrected display of registered classes and registration costs.
  • Adjustments to display of data so that it fit logic requirements given by supervisor.

This Website (samaragarrett.com)

PHP and MySQL three-tier web application.

• Designed and implemented web application, including structure, style, and database.
• Implemented role based access control.

Link to github for project: Samara Garrett.

Tool Rental System

January 2020 – May 2020

ASP.NET Core and MySQL three-tier web application.

Capstone Project for Metropolitan State University Bachelor of Science in Computer Science. Built application from the ground up with a group of four other students.

• Collaborated with team on design of website look, structure, and database.
• Designed the Use Case and Class Diagrams for the project.
• Managed team, including assigning tasks and monitoring progress.
• Recorded minutes for twice weekly meeting and compiled them online to be referenced by group.
• Implemented several use cases, including Rent Out Tool, Return Tool, and display and search of tables (using jQuery DataTables).

Link to github for project: Tool Registration System. My commits are under the GitHub account SamaraEGarrett.

See the project documentation pdf: Tool Rental System Documentation