Open for Data Analyst & BI Developer roles

Tejas Teke

Analytics Engineer & BI Developer

I'm Tejas — an MCA student obsessed with turning chaotic data into clean pipelines and stunning dashboards. Shipping ML models, ETL pipelines, and BI insights with Python, SQL, and Power BI.

Get in Touch View Projects
CONNECT:
Tejas Teke
Scroll
ABOUT

Professional Summary

Decoding chaotic data, one pipeline at a time.

I am a tech-driven Master of Computer Applications (MCA) student focused on building high-performance data systems. I bridge the gap between complex database backends and clean executive dashboards, transforming messy raw metrics into automated, visual business intelligence.

My toolset centers on writing optimized SQL queries, orchestrating python ETL pipelines (Pandas/NumPy), and designing interactive dashboards in Power BI. I also enjoy training predictive machine learning models to forecast trends and eliminate manual reporting bottlenecks.

88%
Model Accuracy
80+
LeetCode Solved

Education

Academic background & coursework

2024 - 2026

Master of Computer Applications (MCA)

IMSCDR, Ahmednagar
  • Focus areas: Data Mining, Machine Learning, Database Management Systems, Statistics for Data Science.
  • Actively building end-to-end data analysis and model deployment pipelines for academic projects.
2021 - 2024

Bachelor of Computer Applications (BCA)

Ahmednagar College, Ahmednagar
  • Graduated with distinction.
  • Built a strong foundation in algorithms, data structures, object-oriented programming (OOP), and databases.
SKILLS

Technical Skills

My analytics toolbox and programming languages

Languages & Core

Python (Pandas, NumPy, Scikit-learn)85%
SQL / PostgreSQL80%
HTML5 & CSS375%

Visualisation & BI

Power BI (DAX, Power Query)85%
Data Modeling (Star Schema)80%
MS Excel (Pivot, Formulas)70%

Machine Learning

Supervised/Unsupervised Learning75%
Feature Engineering & Scaling80%
Model Evaluation (RMSE, F1, Recall)75%

Algorithmic Problem Solving

I actively practice coding and data structures to sharpen my analytical reasoning and problem-solving skills.

80+ Challenges Solved LeetCode HackerRank Arrays Dynamic Programming OOP
80+ solved
WORK

Featured Projects

Academic works and independent developments

Sales Analysis
Python Pandas Matplotlib Data Analysis

SuperStore Sales & Profitability Analysis

  • Exploratory Data Analysis: Analyzed 5,901 transaction records from a retail "SuperStore" dataset spanning Jan 2019 – Dec 2020.
  • Profitability Gaps: Identified margin-erosion pattern where sales grew 5x faster (77.3%) than profit (14.2%) YoY.
  • Actionable Insights: Uncovered that Central and South regions grew sales >80% while profits fell >50%, likely due to discounting.
  • Visualizations: Generated a 6-panel Matplotlib dashboard covering Sales vs. Profit, Segment sales, and Profit margin %.
Repository
Clinic Analysis
Power BI DAX Power Query

Clinic Performance & Profitability Analysis | Power BI

  • Analyzed 2,000 dental appointments generating $937,624 revenue and 20.5% profit margin using Power BI, DAX, and Power Query.
  • Identified Chicago’s 4.11% margin as the lowest, where average cost was $456.02 vs $372.62 overall and waiting time reached 49.2 min.
  • Found a $61,340 NY–LA revenue gap despite similar appointment volumes (556 vs 560), linked to treatment mix: 228 vs 94 whitening appointments, with 39.97% vs 10.09% profit margins for whitening and cleaning.
  • Found dentist profitability varied by location, with D5 ranging from 4.11% to 27.44%, challenging simple dentist-level performance comparisons.
Repository
DayFlow Scheduler
Node.js Express.js SQLite Vanilla JS

DayFlow Scheduler

  • Visual Timeline & Conflict Detection: Schedule on a 24-hour timeline with overnight support and automatic double-booking warnings.
  • Analytics Tracking: Dashboard tracking focus time, completed tasks, and automated workload categorization.
  • Glassmorphic Indian Theme: Modern frosted-glass UI with dark mode, a glowing Diya logo, and a tricolor palette.
  • Local Data & Exports: Secure local data storage using SQLite and one-click PDF backup generation.
Repository
Sales & Inventory Analytics
Region: All 2026
Revenue $124.5K +12.4%
Transactions 10.2K +8.1%
Margin % 38.2% +0.5%
Power BI DAX Power Query Star Schema

Super Store Sales Dashboard | Power BI

  • Developed an interactive Power BI dashboard to analyze $1.60M in sales and $175.26K in profit, with an average delivery time of 3.93 days.
  • Analyzed sales and profit trends across 2019–2020, regional performance, product categories, customer segments, payment modes, shipping modes, and sub-categories.
  • Identified Technology as the highest-profit category ($90K), Consumers contributing 46% of profit, COD accounting for 47%, and Copiers generating $43K profit, while highlighting 3.5K returns through Standard Class shipping.
Repository
train_retail.py
1 import pandas as pd
2 from sklearn.cluster import KMeans
3 from sklearn.linear_model import Ridge
4 # Serializing models to data.js
5 export_weights(kmeans, ridge, "data.js")
$ python train_retail.py
[INFO] Loaded 1,000 transactions...
[SUCCESS] Serialized K-Means & Ridge models!
Python Scikit-learn Vanilla JS Data Science

Retail Sales Analytics & ML Dashboard

  • Interactive ML Dashboard: Combines exploratory data analysis (EDA) with real-time, client-side machine learning.
  • Data Pipeline: Cleaned 1,000 transactions and generated analytical charts using Python (Pandas & Seaborn).
  • ML Models: Trained K-Means Clustering (4 customer profiles) and Ridge Regression models to predict purchase quantity and expected transaction spend.
  • Serverless Architecture: Serialized weights into a static data.js file for serverless client-side predictions on GitHub Pages with zero CORS issues.
  • Data Science Insight: Found near-zero correlation (-0.06) between customer age and spending, proving demographics alone are poor spend predictors.
Repository Live Site
Smart Phone v5
$599 4.8
Add to Cart
Pro Wireless Headset
$149 4.5
Add to Cart
HTML5 CSS3 Responsive Design

E-Commerce Clone Front-End

  • Developed a pixel-perfect, responsive Amazon-style UI mockup compatible across devices from 320px to 1440px widths.
  • Configured 6 clean grid-based product grids with strict alignment and spacing hierarchy.
  • Wrote semantic, accessible HTML templates utilizing clean, modular style guidelines.
Repository Live Site
BADGES

Certifications & Achievements

Credentials and competitive programming milestones

1st Prize in Optimisation Technique

MCA 1st Year

Secured 1st place in the Optimisation Technique subject and was awarded a cash prize of ₹1000.

Power BI Workshop

Ahmednagar College (2025)

Secured 1st place in the Power BI quiz competition (competing against seniors and teachers) along with hands-on training in dimensional modeling and DAX.

Python Programming Certification

Academic (2023)

Credential covering OOP principles, file manipulation, scripting, and data structures.

80+ Algorithmic Challenges

LeetCode & HackerRank

Completed challenges covering Array manipuation, Dynamic programming, and Tree structures.

PING

Get In Touch

Have a dataset, a dashboard, or a hiring decision in mind? Let's talk.

Location

Ahmednagar, MH, India