Jyotsna Gatram

I’m an aspiring DataAnalyst/Data Scientist who turns messy data into clear, actionable insights. My focus is data cleaning, preprocessing, exploratory data analysis (EDA), and transforming large datasets into KPI-ready reporting.

In a Python Programming virtual internship at CodSoft, I developed Python-based desktop applications (Task Management System, Calculator, Password Generator) using Tkinter and SQLite. I implemented task tracking with CRUD operations, database integration, input validation, password complexity generation, and real-time calculations.

On my projects, I built a MySQL Fitness Tracker database with 10+ relational entities and used advanced SQL (joins, subqueries, aggregations, and triggers) to analyze workout trends, calorie burn, BMI insights, and personalized recommendations. I also created a command-line Task Tracker Management System using Python, Pandas, and SQLite with analytics like completion-rate analysis, overdue-task detection, due-date validation, and CSV export.

For end-to-end analytics, I executed a retail analytics pipeline on 150,000+ records across 6 datasets, using data cleaning, feature engineering, SQL-based integration, and EDA to uncover purchasing, retention, and conversion patterns. I trained Logistic Regression and KNN models for delivery delay prediction, evaluated performance using ROC-AUC and confusion matrix analysis, and built interactive dashboards to visualize customer behavior and revenue-driving membership segments.