Data Analyst & Database Developer | Open Source Contributor
I am an aspiring Data Analyst based in Pune, India. I specialize in relational database design (SQL), database modeling, data extraction, and using Python for data cleaning and scripting. I enjoy translating raw data into meaningful business intelligence and actionable insights.
- π Focus Areas: Data Analytics, Relational Database Modeling (MySQL/SQLite), and Python Data Scripting.
- π€ Open Source Contribution: Active participant in Social Summer of Code (SSOC) Season 5, contributing to various repositories.
- π Location: Pune, India.
- βοΈ Contact: giteonkar2004@gmail.com
π₯ PhysioBuddy (Final Year Project)
- A full-stack web application designed for digital physiotherapy and patient monitoring. Built with a React frontend and a Django backend, featuring real-time patient-doctor chat, exercise assignment tracker, and diagnostic health profile metrics.
- An end-to-end database modeling and portfolio analytics system. Contains a Star Schema architecture with 400 transaction records and 15 advanced SQL queries (CTEs, Window Functions) extracting business metrics like geographic revenue distribution, agent ranks, and inventory conversion rates.
- A desktop drawing canvas application built in Python using the Tkinter GUI toolkit, allowing users to sketch, paint, and clear their ideas dynamically.
π Language Translator
- A translation application built using Python's
googletransandgtts(Google Text-to-Speech) libraries to translate and speak texts across different languages.
