Ajit Mahapatro
Available for Opportunities

Ajit Mahapatro

Data Analyst & Data Scientist

I transform raw data into business decisions through SQL analytics, interactive dashboards, machine learning models, and scalable data applications. Experienced in building solutions across finance, operations, and AI-driven analytics.

5+

Projects Built

8+

Certifications

4+

Competitions

5+

Analytics & ML Projects

Convert complex data into actionable insights

Build executive dashboards and KPI reports

Develop predictive models and AI applications

About

Analytics-Driven Problem Solving

I am a Data Science undergraduate passionate about solving business problems using data analytics, machine learning, and visualization tools. My work focuses on building interactive dashboards, predictive analytics projects, and data-driven solutions that transform raw data into actionable insights. I enjoy working on business intelligence reporting, exploratory data analysis (EDA), KPI tracking, and machine learning workflows using Python, SQL, Power BI, and Scikit-Learn.

Skills

Analytics & Technical Skills

Language and Database

PythonMySQLPostgreSQLSQL (CTEs, Window Functions)

Analytics & BI

Power BITableauMicrosoft ExcelData VisualizationExploratory Data Analysis

Statistical Methods

Descriptive StatisticsVariance & Deviation AnalysisHypothesis TestingCorrelation & Trend AnalysisA/B Testing

Data Quality & Operations

Data ValidationStructural Data WranglingRoot Cause AnalysisFeature Engineering

Machine Learning

ClassificationRegressionXGBoostK-Means ClusteringModel EvaluationPredictive ModelingPytorch (Deep Learning)

Tools & Libraries

FastAPIPandasNumPyMatplotlibScikit-LearnVisual Studio CodeJupyter Notebook

Projects

Selected Work

Employee Attrition Prediction & Workforce Analytics

Individual Power BI Project • Attrition Anlaysis

Employee Attrition Prediction & Workforce Analytics

End-to-end HR analytics platform integrating SQL, Python, ETL workflows, Machine Learning, and Power BI dashboards for workforce decision support.

1,470 employee records • 25+ KPI visualizations • 4 dashboard pages

Random ForestPower BIDAXPythonPredictive Analytics
Stark Data Science Assistant

Independent Production Project

Stark Data Science Assistant

AI-powered analytics platform combining FastAPI, Groq Llama 3.1, Plotly visualizations, dataset profiling, NLP commands, and intelligent reporting.

6 REST APIs • 15+ interactive visualizations • Automated AI insights

PythonFastAPIGroq Llama 3.1BeautifulSoup4Plotly.jsVercel
QuantAlpha – Financial Analytics Platform

Team Project • Team Lead

QuantAlpha – Financial Analytics Platform

Financial analytics platform integrating machine learning, macroeconomic indicators, portfolio analytics, and predictive forecasting through scalable FastAPI services.

18 engineered features • 11 portfolio risk metrics • XGBoost forecasting

PythonFastAPIXGBoostReactFinancial Analytics
Global Enterprise Ledger & Database Replication Monitor

Independent Telemetry Project • Infrastructure Risk

Global Enterprise Ledger & Database Replication Monitor

Enterprise infrastructure analytics dashboard monitoring distributed database replication, SLA compliance, telemetry, and operational risk using Tableau and Python.

6.43M+ transactions • 4,608 telemetry records • Star Schema data warehouse

TableauPythonPandasNumPyStar SchemaSystems Telemetry
Quantum Operational Intelligence System (QOIS)

Hackathon Project

Quantum Operational Intelligence System (QOIS)

Quantum workload monitoring platform providing live IBM Quantum backend analytics, operational dashboards, and system intelligence.

Live IBM Quantum monitoring • FastAPI backend • React dashboard

QiskitMERNIBM QuantumREST API
Airline Delay Pattern Discovery

Data Analysis & Visualization

Airline Delay Pattern Discovery

Exploratory aviation analytics project identifying operational bottlenecks, airline performance trends, and delay patterns using statistical analysis and visualization.

Analysis of 6M+ flight records • Interactive analytical dashboards

FP-GrowthAssociation RulesNetworkXEDA

Journey

Experience & Education

💼

Experience

Machine Learning Engineer Intern

Dec 2025 - Mar 2026

Adhoc Network Tech Company · Visakhapatnam

  • Served as Team Lead for 7 engineers to coordinate data engineering workflows, maintain code data validation routines, and optimize pipeline execution stability.
  • Performed exploratory data analysis (EDA), data preprocessing, feature engineering, and model evaluation using Python and Pandas
  • Contributed to the development of predictive models using Scikit-Learn and XGBoost
  • Worked on FastAPI integration for deploying machine learning prediction workflows
  • Assisted in building data transformation pipelines and analytics dashboards for project reporting

Group Discussion Mentor

Aug 2025 - Feb 2026

Aditya Degree College

  • Guided junior students in communication and analytical skills.
  • Managed group discussions and provided real-time feedback.

Power BI Analyst Intern

May 2025 - Jun 2025

ULEARN · India

  • Built advanced DAX-driven data models to audit and validate $33M in enterprise distribution data, ensuring absolute data accuracy across high-scale metrics.
  • Created data transformation pipelines using Power Query.
  • Delivered logistics, flight delay, and retail sales dashboards.
🎓

Education

Bachelor's Degree in Data Science

2023 - 2026

Aditya Degree College · Visakhapatnam

  • Focused on applied machine learning, analytics, and data systems.
  • Worked on predictive modeling, business intelligence, Power BI, and analytics projects.
  • Built end-to-end ML applications using Python, FastAPI, and Scikit-Learn.

Senior Secondary Education

Aug 2021 - Mar 2023

MVR Junior College · Visakhapatnam

  • Completed higher secondary education with a GPA of 9.7.
  • Strengthened analytical problem-solving and quantitative reasoning skills.

Secondary Education

May 2020 - May 2021

SLN Public School · Odisha

  • Completed ICSE secondary education with a GPA of 9.0.
  • Built strong academic foundations in mathematics, science, and communication.
  • Actively participated in analytical and technical learning activities.

Recognition

Achievements

Runner-Up – AP Amaravati Quantum Valley Hackathon

Recognized for QOIS — quantum workflow monitoring and analytics dashboard built during the hackathon.

3rd Position – Inter-College SQL Query Quest

Ranked among top performers in inter-college SQL querying and analytical problem-solving.

2nd Prize – Inter-Branch Technical PowerPoint Presentation Competition

Awarded for delivering a strong technical PowerPoint presentation on Data Science.

2nd Prize – All-Branches Online JAM Competition

Recognized for quick thinking, structured communication, and analytical articulation in an online JAM format.

Learning

Certifications

📘

Analytics & Data Science Certifications

IBM Data Science
IBM Python Data Science
SQL for Data Science
Advanced Tableau Analytics
Excel Basics for Data Analysis
ULearn AI & ML
Essentials of Gen AI
Python Essentials 1 & 2

Contact

Let's Connect

Open to Data Analyst, Business Intelligence Analyst, Analytics Engineer, and Data Science opportunities. Connect with me through email, LinkedIn, or GitHub to discuss how data-driven solutions, dashboards, and machine learning projects can contribute to your organization.