Hi, I'm Tejal Kunjir

Data Analytics • Business Intelligence • Data Engineering

Building business intelligence solutions and modern data systems with SQL, Power BI and Python.

Tejal Kunjir

A Closer Look

I build data solutions that transform operational information into meaningful business insights. My work focuses on SQL development, ETL, data warehousing, semantic modeling, business intelligence, and analytics, supported by hands-on experience delivering enterprise reporting solutions.

Beyond building dashboards and data models, I enjoy understanding how data reflects real business operations. My experience includes enterprise licensing automation, operational data analysis, and documenting technical implementations through GitHub repositories and Medium articles.

Toolkit

Data Engineering

SQL ETL Pipelines Data Warehousing Data Modeling Star Schema

Business Intelligence

Power BI DAX Power Query Semantic Models Dashboard Design

Data Analysis

Pandas Python Excel NumPy

Data Platforms & Tools

MQTT Node-RED GitHub Postman Figma

Featured work

SQL Data Warehouse Development Project
2026

SQL Data Warehouse Development

Built a production-style SQL data warehouse using the Medallion Architecture, transforming raw operational data into analytics-ready models optimized for reporting and business intelligence.

SQL Server SSMS Star Schema T-SQL ETL
Power BI Business Intelligence Reporting Solution
2026

Power BI Business Intelligence Reporting Solution

Designed a semantic data model and interactive Power BI dashboards with reusable DAX measures, enabling business reporting across sales, customers, inventory, and operations.

Power BI DAX RLS Power Query Data Modeling
Chronic Disease Prediction System
2026

Chronic Disease Prediction System

Developed a machine learning pipeline for chronic disease risk prediction, covering data preprocessing, model evaluation, and deployment within a full-stack web application.

Python Flask React Scikit-learn

Insights

Sharing practical insights on SQL, Business Intelligence, Data Engineering and modern analytics through project based articles.

CAP, ACID and BASE

CAP, ACID, BASE - one system, one story

Understand why payments demand ACID, user experiences rely on BASE, and CAP determines system behavior during network failures.

Data Workflow

From Raw to Real: The Data Workflow Playbook

Turning chaotic bytes into brilliant insights - one tool, one transformation, one deployment at a time.

WF

Window Functions in SQL: The Secret Weapon for Data Analysis

Window functions let you perform calculations across a set of rows while still keeping access to individual row details. Think of it as putting a “window” over your table , you can see everything inside the frame, do calculations, and still keep your row-level data intact.

Where I've worked

Samprama Digitek (I) Pvt. Ltd.

Software Development and Data Analytics Intern Jan 2026 - May 2026

Jan 2026 - May 2026

Worked with real-time IoT data streams using MQTT, Node-RED, Grafana, and backend APIs to support operational monitoring, dashboards, alerts, and reporting workflows. Contributed to the DPS License Module by helping transform a command-line based licensing process into an application-driven workflow. The implementation supported license generation, license extension using unique license keys, progressive expiry notifications, and notification delivery through email and Telegram.

PostgreSQL Node-RED MQTT Backend APIs

BAIF Development Research Foundation

Process Analysis Trainee (Apprenticeship) Jun 2022 - Jul 2023

Jun 2022 - Jul 2023

Identified operational deviations related to scheduled power outages, detected process variations affecting quality assurance, and analyzed seasonal inventory patterns that contributed to product quality issues. The analytical findings supported operational improvements, reduced process losses, and contributed to improved audit outcomes for the department.

Excel Data Visualization Microsoft 365

Certifications

Oracle Data Platform 2025 Foundations Associate

Oracle • 2025

SQL • Database Fundamentals • Data Integration • Analytics Ecosystem • Data Lifecycle Concepts

View Credential →

Oracle Cloud Infrastructure 2025 AI Foundations Associate

Oracle • 2025

Machine Learning • Generative AI • Responsible AI • OCI AI Services

View Credential →

Oracle Cloud Infrastructure 2025 Foundations Associate

Oracle • 2025

Cloud Computing • Compute • Networking • Storage • Identity & Security

View Credential →

IBM Data Science Professional Certificate

Coursera • 2025

Python • SQL • Data Analysis • Machine Learning • Data Visualization

View Credential →

Volunteering

Youth Empowerment Foundation

Fund Raising Campaign Analyst

June 2021 - May 2022

Supported educational and community-focused initiatives by contributing analytical and organizational efforts as part of the foundation's activities.

Inlaks Budhrani Multispeciality Hospital, Pune

Volunteer Assistant

April 2020 June 2020

Supported PPE kit distribution and logistics during the COVID-19 response, helping frontline healthcare teams maintain uninterrupted access to essential protective equipment.

Connect

Contact Information

Connect with Me