Data and Database Architecture for Petscare Clinic

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐁𝐚𝐜𝐤𝐠𝐫𝐨𝐮𝐧𝐝

PetsCare is a local clinic that offers care for animals, such as vaccinations, medical services, spay and neuter surgery, dental cleaning and treatment, grooming, and other services. Over the course of more than 20 years, PetsCare has successfully operated as a business while serving the community.The current owner, Claire, who is also the company's founder's daughter, recently came to the conclusion that the outdated file system solution is incredibly ineffective. She and her team are required to put in a lot of time collecting records, requesting data, and maintaining the data.

𝐏𝐫𝐨𝐛𝐥𝐞𝐦𝐬 𝐈'𝐦 𝐠𝐨𝐢𝐧𝐠 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐬 𝐚 𝐃𝐚𝐭𝐚 𝐚𝐧𝐝 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐀𝐫𝐜𝐡𝐢𝐭𝐞𝐜𝐭She asked me to design an RDBMS so that it could keep track of customers, staff, and visitors to the PetsCare clinic.Skills: Microsoft Office · Scikit-Learn · Microsoft Azure · Machine Learning · NumPy · Google Cloud Platform (GCP) · A/B Testing · agile development and scrum · NLTK · Microservices · Project Management · Statistics · Amazon Web Services (AWS) · Tableau · Python (Programming Language) · Pandas (Software) · Business Development · Jira · Digital Marketing · DevOps · Software Development · Plotly · Extract, Transform, Load (ETL) · Google BigQuery · Product Management · MySQL · User Experience (UX) · Data Analytics · Artificial Intelligence (AI)