Loading profile…
PRATIK RAJ
Open to opportunitiesRetail Sales BI Dashboard
Aspiring data analyst turning messy data into actionable business insights.
IndiaRetail Sales BI Dashboard at GitHub
About
I’m currently pursuing a B.Tech in Data Science (Class of 2027), and I’ve spent the last couple of years building real-world data projects that taught me how to turn raw numbers into useful business insights. I enjoy cleaning messy datasets, writing efficient SQL queries, and building dashboards that help people make decisions.
In my Retail Sales BI Dashboard project, I loaded a 10,000+ row dataset into MySQL, created a clean Python pipeline with SQLAlchemy, and used advanced SQL (window functions and CTEs) to identify monthly trends and best-performing products. I also built a Streamlit dashboard with filters so non-technical team members could explore key metrics, and I used outlier analysis (IQR & Z-score) to uncover that orders with discounts over 40% were almost always making a loss. Beyond BI, I developed a fully local AI chat interface using FastAPI and Ollama that answers questions from uploaded PDFs/CSVs without relying on paid APIs, and I’ve strengthened my foundation through Oracle Generative AI and Hugging Face NLP training, plus open-source contributions during Hacktoberfest 2024.
Experience
Retail Sales BI Dashboard
Built a Retail Sales BI dashboard using Python and MySQL, creating a clean Python pipeline with SQLAlchemy to analyze data directly from the database. Developed advanced SQL (CTEs and window functions) for sales trends and best-performing products, and created a Streamlit dashboard with filters for non-technical users.
PythonSQLMySQLSQLAlchemyPandasStreamlitPlotlyData CleaningAnomaly DetectionWindow Functions
OllamaWebUI — Local AI Chat Interface
Developed a fully local AI chat interface using FastAPI and Ollama that can search the web in real time and answer questions based on uploaded PDFs and CSVs. Implemented natural-language querying over user files and added features like chat export to Markdown and drag-and-drop support.
Education
Haldia Institute of Technology
Pursuing a B.Tech in Data Science with a focus on Data Structures & Algorithms, DBMS, Machine Learning, Statistics, and Python programming.
Bihar School Examination Board (BSEB)
Completed Higher Secondary (Class XII) with a Science track.
Central Board of Secondary Education (CBSE)
Completed Class X education.