NIKHIL TRIPATHI
Aspiring Data Analyst | Data-Driven Problem Solver | Android Development Enthusiast
Driven by Data, Focused on Impact
As a final year B.Tech student from KIIT, Bhubaneswar, I am passionate about leveraging data to drive strategic decisions and build robust applications. My goal is to transform complex information into clear, actionable insights and functional designs. This visual summary outlines my diverse skills and comprehensive experience.
Key Technical Skills & Expertise
Programming Languages 💻
- ✔ Python
- ✔ Kotlin
- ✔ Java
- ✔ C
Data & ML Frameworks 📊
- ✔ Pandas, NumPy, Matplotlib, Seaborn
- ✔ SciPy, scikit-learn, TensorFlow
- ✔ LangChain, Google PaLM
Tools & Platforms 🛠️
- ✔ SQL
- ✔ Streamlit, Jupyter Notebook, Tableau
- ✔ Git/GitHub, Android Studio, Figma, Canva
Professional Journey & Impact
Infogain Summer Intern (May 2025 - June 2025)
Applied data analysis and visualization to complex insurance data, contributing to data-driven decision-making and ML model development.
- Processed sensitive customer data and built insightful visualizations (Pandas, Seaborn, Plotly) for accurate reporting.
- Contributed to ML model development with Python, Jupyter, Scikit-learn in agile workflows.
Media Swaraj: Data & Digital Media Impact (May 2024 - Jan 2025)
Leveraged analytics and digital media skills to significantly boost audience engagement and visual branding.
- Used YouTube Studio analytics (CTR, retention) to increase subscriber count from 6K to 15K+.
- Created SEO-based scripts, thumbnails, and posters, contributing to visual branding and audience engagement in digital media.
AICTE Google Android Developer Intern (July 2024 - Sept 2024)
Gained hands-on experience in mobile application development, strengthening UI design and event handling.
- Developed Android apps (Grocery List, Cupcake Order) using Kotlin and Android Studio.
- Practiced UI design, event handling, and activity lifecycle basics through various beginner-friendly apps.
Highlight Projects
Strategic Supply Chain Value Optimization
Python (Pandas, Matplotlib, Seaborn, SciPy), SQL, Advanced Analytics, Data Visualization
- Drove ~$2.7M in working capital liberation by analyzing excess unsold inventory.
- Achieved ~72% unit cost reduction via bulk purchasing analysis.
- Uncovered profit margin disparities (Top: ~31%, Low: ~-41%) across vendors using statistical hypothesis testing.
Natural Language to SQL GenAI Assistant
Python, LangChain, Google PaLM, FAISS, Streamlit, SQLite
- Developed a natural language query engine converting user prompts into accurate SQL queries.
- Integrated Google PaLM for semantic search, improving query precision and minimizing hallucinations.
- Built and deployed a Streamlit dashboard for real-time inventory and sales analytics.
Reflectify - Journal App
Kotlin, MVVM, Firebase, Glide, Android Studio
- Developed a secure journaling app using Firebase Authentication and Storage.
- Followed MVVM architecture for modular code structure and integrated Glide for smooth image loading.
Blinkit Clone
Kotlin, MVVM, Firebase, Retrofit, Glide, PhonePe API Integration, Android Studio
- Built a grocery delivery app with Firebase Authentication, Realtime Database, and Storage.
- Utilized MVVM architecture and Retrofit for REST API integration, enhancing UI responsiveness with Glide.
Skill Proficiency Overview
This chart provides a visual representation of my confidence and expertise across a diverse set of skills crucial for data analysis and development.
My Comprehensive Journey
B.Tech Foundation
KIIT University
Key Certifications
IBM Data Science, Android Dev
Diverse Internships
Infogain, Media Swaraj, AICTE
Impactful Projects
Analytics, GenAI, Mobile Dev
Ready for Impact
Versatile & Driven Professional
Honors & Awards
Smart India Hackathon (SIH)
Winner at KIIT University (Team BookNBot), qualified to represent the institute at the state level.
Naukri Campus Young Turks
Ranked in the top 2% (98.04 percentile) among 5.13 lakh participants in India's largest skill contest (Coding track).