Client Overview

My client, a small business owner who runs a pet grooming service, was struggling to manage their growing customer base. Beyond just keeping track of customers, they needed an efficient way to manage their customers' dogs, track past appointments, record payments, and store notes—all while keeping the system as simple as possible for everyday use.

The Challenge

The client’s existing process involved juggling multiple spreadsheets and paper records, which was time-consuming and prone to errors. They needed a centralized, easy-to-use solution that would allow them to:

• Store and manage detailed records of both customers and their pets.

• Track and review past appointments, payments, and notes.

• Access and update information quickly and efficiently, without the need for complex software.

​

The Solution

​

I proposed and developed a custom database and user interface using Google AppSheet, a powerful no-code platform that integrates seamlessly with Google Sheets. This solution provided the simplicity and functionality the client required.

Key Features:

1. Customer & Pet Management: A simple interface to add and manage customer details alongside information about their pets. Each customer record is linked to their pets, allowing easy access to specific information.

2. Appointment Tracking: The system allows the client to schedule and view past appointments for each pet, with options to add services provided during each visit.

3. Payment Records: The AppSheet application includes a feature for recording payments, ensuring the client can easily track financials associated with each customer and their pets.

4. Notes Section: For each customer and pet, there’s a notes section where the client can jot down important details or reminders, ensuring that no information slips through the cracks.

5. User-Friendly Interface: The interface was designed to be intuitive, with simple navigation and easy data entry, ensuring that the client and their staff can use the app with minimal training.

The Results

​

By implementing this AppSheet solution, the client was able to streamline their operations significantly. The benefits included:

• Increased Efficiency: The client reported a significant reduction in the time spent managing customer and pet information, thanks to the centralized database and easy access to records.

• Improved Accuracy: With all data stored in one place, the risk of errors and lost information was minimized.

• Scalability: As the business grows, the client can easily add more records and even expand the functionality of the app as needed.

Client Feedback

​

The client was thrilled with the simplicity and effectiveness of the solution. They appreciated how the app met their specific needs without overwhelming them with unnecessary features. The ease of use and integration with Google Sheets meant that the transition was smooth, with minimal disruption to their daily operations.

​

Conclusion

​

This project demonstrates how a well-designed custom solution using Google AppSheet can meet complex needs in a simple, user-friendly way. By focusing on the client’s specific requirements and leveraging the power of no-code tools, I was able to deliver a system that not only met but exceeded their expectations.

Project Overview

As part of a school project, I led a team to develop a tournament website designed to streamline the management of sports events. The website needed to provide a user-friendly interface for registering teams, scheduling matches, tracking results, and displaying leaderboards. Our tech stack included HTML, CSS, EJS, and JavaScript.

The Challenge

The primary challenge was to create a dynamic and responsive website that could handle multiple tournaments simultaneously, offer real-time updates, and present a polished, professional look—all within a tight deadline.
As the project manager, I was responsible for:

• Coordinating the efforts of our team members.

• Ensuring that we stayed on track with our timeline and goals.

• Overseeing both the front-end and back-end development to maintain a cohesive product.

• Managing communication and task allocation to ensure smooth workflow.

The Solution

We developed the tournament website using a combination of HTML, CSS, EJS, and JavaScript to create a dynamic, interactive platform that met all the project requirements.

Key Features:

1. Team Registration: We implemented a registration system where teams could sign up for tournaments, complete with automated validation and confirmation.

2. Match Scheduling: The site featured an intuitive scheduling tool that allowed administrators to set up matches easily, with the schedule automatically updating based on the tournament progress.

3. Real-Time Updates: Using JavaScript, we enabled real-time updates for match results, which instantly reflected on the leaderboard.

4. Responsive Design: We ensured that the website was fully responsive, providing a seamless experience across different devices, thanks to our use of CSS and EJS templating.

5. User Interface: The front-end design focused on a clean, modern look with easy navigation, ensuring that users could find the information they needed quickly.

My Role as Project Manager

In my role as project manager, I:

• Defined Project Scope: I worked closely with the team to outline the project requirements, define the scope, and set realistic milestones.

• Task Allocation: I assigned tasks based on each team member's strengths, ensuring that work was distributed evenly and efficiently.

• Timeline Management: I kept the project on schedule by monitoring progress, addressing roadblocks, and adjusting timelines as necessary.

• Quality Assurance: I led regular testing sessions to ensure that all components of the website were functioning as expected and met our quality standards.

• Team Collaboration: I facilitated effective communication within the team, holding regular meetings to discuss progress, resolve issues, and ensure that everyone was aligned with our goals.

The Results

The project was successfully completed on time and received positive feedback from our instructors and peers. Key outcomes included:

• Successful Deployment: The website was fully functional and ready to be used for managing tournaments, fulfilling all the requirements outlined at the start.

• Enhanced User Experience: The responsive design and intuitive interface made it easy for users to register, track matches, and view results, contributing to a positive user experience.

• Effective Team Collaboration: As project manager, I was able to lead the team effectively, ensuring that each member contributed their best work and that the project was completed smoothly.

Conclusion

This project highlighted the importance of strong project management in achieving a successful outcome. By coordinating our team's efforts and maintaining clear communication, we were able to deliver a well-executed tournament website that met all project goals. The experience also reinforced my skills in leadership, time management, and web development, all of which are crucial for my future career.

Project Overview

As part of a school team, we developed a meal planning application designed to help users plan their meals efficiently. The application featured a calendar for scheduling meals and allowed users to choose, favorite, and filter meals based on dietary preferences. My primary responsibilities were to develop the backend functionality and to create the calendar interface.

The Challenge

The goal was to create an intuitive application that would simplify meal planning for users. Key challenges included:

• Backend Functionality: Developing a robust backend to handle user data, meal preferences, and calendar integration.

• Calendar Interface: Designing a user-friendly calendar that would seamlessly integrate with the meal planning features and provide an easy way for users to manage their meals.

The Solution

Our team developed a comprehensive meal planning application using a combination of front-end and back-end technologies. The application was designed to be user-friendly and flexible, catering to various dietary needs and preferences.

Key Features:

1. Meal Selection & Favorites: Users could browse a diverse selection of meals, mark their favorites, and easily add them to their meal plan.

2. Dietary Filtering: The app included filtering options to sort meals based on dietary preferences, such as vegetarian, vegan, gluten-free, and more.

3. Calendar Integration: A dynamic calendar interface allowed users to schedule their meals, view their plans for the week, and make adjustments as needed.

4. Backend Functionality: The backend was developed to manage user data securely, handle meal selections, and integrate with the calendar to update meal plans in real-time.

My Role

As a backend developer and calendar interface creator, my responsibilities included:

• Backend Development: I designed and implemented the backend functionality to support user accounts, meal data management, and integration with the calendar. This involved setting up a database, developing APIs, and ensuring data integrity and security.

• Calendar Interface: I developed the calendar interface using React, ensuring it was responsive and user-friendly. I integrated the calendar with the meal planning features, allowing users to easily schedule and manage their meals.

The Results

The application was well-received by users and demonstrated effective meal planning capabilities. Key outcomes included:

• Functional Application: The app provided a seamless experience for meal planning, with robust backend support and an intuitive calendar interface.

• Positive Feedback: Users appreciated the ability to filter meals based on dietary needs and the ease of scheduling meals using the calendar.

• Team Collaboration: Working closely with my team, we successfully integrated the backend functionality with the user interface, delivering a cohesive and functional product.

Conclusion

This project underscored the importance of both backend development and user interface design in creating a successful application. By focusing on backend functionality and calendar integration, I was able to contribute significantly to the development of a practical and user-friendly meal planning tool. This experience enhanced my skills in backend development, user interface design, and teamwork, preparing me for future challenges in software development.