Avanish Tripathi

About

Data Analyst and Data Science student pursuing a BCA in Data Science & Artificial Intelligence. Hands-on experience in Python, SQL, Power BI, Excel, ETL, KPI reporting, dashboard development, and AI/ML project work.

Experience

• Data Analyst Intern
  Cognifyz Technologies
  Oct 2025 – Nov 2025

  Cleaned and visualized datasets to identify business patterns and actionable insights. Designed KPI-focused dashboards and reports using Power BI and Excel.

• AI Intern
  CodSoft
  Sep 2025 – Oct 2025

  Built supervised-learning-based AI solutions for automation use cases. Worked on NLP-oriented decision automation workflows using Python.

• Machine Learning Intern
  CodeVeda
  Jul 2025 – Aug 2025

  Developed classification and regression models and evaluated model performance. Performed exploratory data analysis using Pandas, Seaborn, and Matplotlib. Applied supervised learning techniques to prediction use cases.

• Data Analyst Intern
  Elevate Labs
  Jun 2025 – Jul 2025

  Cleaned and preprocessed datasets using Python and SQL for analysis and reporting. Built interactive Power BI dashboards for business reporting and KPI tracking. Supported data preparation and reporting workflows.

Education

• BCA
  Shri Ramswaroop Memorial University
  Data Science & Artificial Intelligence · 2025 – 2027

Skills

• SQL <3 months
• FastAPI <3 months
• Python 3 to 6 months
• Machine Learning 3 to 6 months
• Classification <3 months
• Data Cleaning 3 to 6 months
• Feature Engineering <3 months
• Matplotlib <3 months
• NumPy <3 months
• Pandas <3 months
• Streamlit <3 months
• scikit-learn <3 months
• React <3 months
• DAX <3 months
• Seaborn <3 months
• Supervised Learning <3 months
• Reporting 3 to 6 months
• Data validation <3 months
• Microsoft Excel <3 months
• API Integration Understanding <3 months
• Statistical Analysis <3 months
• KPI Analysis 3 to 6 months
• Regression <3 months

Tools / apps / platforms

• Git <3 months
• GitHub <3 months
• Jupyter Notebook <3 months
• Microsoft Excel <3 months
• Microsoft Power BI 3 to 6 months
• MySQL <3 months
• Power Query <3 months
• SQLite <3 months
• VS Code <3 months

Projects

• NOVA-EDU - AI-Powered Education & Career Intelligence Platform ↗
  Python, Streamlit, Gemini API, SQLite

  AI-powered education and career platform with career assistant, chatbot memory, student dashboard, recommendations, and profile intelligence features.

• NEXUS - Retail Business Intelligence & Analytics Platform ↗
  Python, Pandas, Power Query, DAX, Power BI

  End-to-end retail analytics workflow covering data generation, validation, ETL, relational and star-schema modeling, analysis, dashboarding, and business insights.

Courses & certifications

• Deloitte Australia - Data Analytics Job Simulation · Forage · 2026
• Generative AI · Analytics Vidhya · 2026
• IICT · Indian Institute of Commerce & Trade
• Python for Data Science · machinelearning.org.in
• Data Analytics Certificate · Elevate Labs
• SQL & Relational Databases · Satish Dhawale
• Advanced Excel · Satish Dhawale
• Power BI Advanced · Satish Dhawale

⚽ Extracurricular activities

• Project Lead / Developer - NOVA-EDU

  Project leadership role for the AI-powered education and career intelligence platform.