Hi, I am Kishor Prajapati
Data Science • Power BI • Database Systems
Backed by dual engineering degrees — M.Tech in Data Science (CGPA: 8.61) from Manipal University Jaipur & B.E. in Mechatronics Engineering. Combining practical application & database support (SQL Server, PostgreSQL, Linux, Docker) with statistical modeling and Power BI automation to deliver immediate value.
Tip: Move your mouse across the background to interact with the live neural connections!
Why Hire Kishor Prajapati for Your Team?
A comprehensive profile summary for hiring managers looking for a candidate who combines rigorous Data Science education with practical database and application support capabilities.
Dual Engineering Rigor (M.Tech + B.E.)
Holds an M.Tech in Data Science (8.61 CGPA) from Manipal University Jaipur and a B.E. in Mechatronics Engineering. This rare combination bridges physical systems, sensors, and telemetry with statistical AI and machine learning.
Database & SQL Query Support
Hands-on support experience with client organizations at Endel Digital Solutions. Proficient in Microsoft SQL Server, PostgreSQL, diagnosing connection failures, resolving data discrepancies, and maintaining data integrity.
Power BI & DAX Automation (~70% Cut)
Designed interactive analytical dashboards using DAX time-intelligence formulas and star-schema modeling that cut repetitive manual operational reporting effort by ~70%.
Cloud, Linux & Container Readiness
Working knowledge of Linux CLI administration (Ubuntu/CentOS), AWS (EC2, S3), Google Cloud Platform (GCP), Docker containers, and Git workflows.
Ready to Interview • Open for Technical Assessments
Currently available for full-time roles in Data Science, Machine Learning, Power BI / Business Intelligence, and Application/Database Engineering.
Featured Data Science & BI Projects
From automated enterprise Power BI dashboards to Python data validation pipelines and predictive ML models. Request code access via email or test interactive simulators directly.
Daily Operations & Sales KPI Dashboard
The operations and accounting teams previously exported daily CSV dumps from SQL Server into Excel to calculate regional sales totals, order statuses, and active accounts. This took ~2 hours every morning and often produced formula discrepancies.
Designed an automated Power BI reporting model connecting to SQL Server views using a clean Star-Schema (Fact_Subscriptions, Dim_Customer, Dim_Date, Dim_Plan). Authored practical DAX measures for Month-over-Month Revenue Growth, Active Accounts, Churn Rate %, and Average Revenue Per User (ARPU).
Client Data Migration & Reconciliation Pipeline
Migrating external client billing spreadsheets and legacy accounting logs into SQL Server often caused batch import crashes due to mismatched date formats (DD/MM/YYYY vs MM/DD/YYYY), trailing spaces in foreign keys, and duplicate payment references.
Developed a Python data cleansing script using Pandas. The script ingests raw CSV/Excel dumps, validates column schemas, standardizes dates into ISO format, strips string whitespace, and writes corrupted/duplicate rows to an "exceptions.csv" report for review before staging insertion.
Customer Churn Analysis & Machine Learning Prediction
Subscription businesses experience recurring customer drop-offs. Identifying accounts with high cancellation risk enables customer support and account managers to address complaints before accounts churn.
Built a customer churn prediction workflow using Python and Scikit-Learn. Performed exploratory data analysis (EDA) identifying key churn drivers (short tenure, month-to-month contracts, high monthly charges). Preprocessed features with StandardScaler and OneHotEncoder, and trained a Random Forest Classifier evaluated via Confusion Matrix and ROC-AUC.
Industrial Motor Vibration & Sensor Anomaly Detector
In manufacturing equipment and conveyor lines, electric motors frequently suffer mechanical bearing failure. Waiting until operators hear noise or notice high heat causes unexpected, expensive factory downtime.
Bridging my Mechatronics engineering background with Data Science coursework, I built a Python time-series anomaly detection pipeline. Reads raw accelerometer vibration (X, Y, Z axis) and thermocouple logs, computes rolling RMS and moving variance, and applies an Isolation Forest to flag abnormal vibration signatures.
Interactive Power BI Projects & Visualizations
Engineered with enterprise star-schema architectures, optimized DAX time-intelligence measures, and executive UX. Click slicers below to interact with the live report simulations.
Daily Operations & Sales KPI DashboardLive Star-Schema
Fact_Subscriptions • Dim_Customer • Dim_Date • Dim_Region • Star-Schema & DAX Measures
Monthly Recurring Revenue Trend (MRR)
Filtered for: All Global Regions • All Tiers
Revenue by Customer Segment
Enterprise dominance with high NRR
Test Live Algorithms & Pipelines
Each sandbox below directly implements the algorithms and data pipelines featured in the portfolio projects. Adjust inputs to test edge cases in real time.
Client Data Cleansing & Reconciliation EnginePython, Pandas & Staging SQL
Tests automated schema validation, whitespace trimming, date standardization (ISO 8601), and rejection logging.
| Transaction ID | Clean ISO Date | Standardized Client | Parsed Amount | Staging Status |
|---|---|---|---|---|
| TXN-9021 | 2024-03-14 | Acme Corp | $1250.00 | READY FOR INSERT |
| TXN-9024 | 2024-03-16 | Vertex Dynamics | $3400.50 | READY FOR INSERT |
| TXN-9025 | 2024-03-17 | BluePeak Media | $2100.00 | READY FOR INSERT |
pd.to_datetime(dayfirst=True), and diverts corrupted records to prevent batch SQL Server bulk import crashes.Honest Competencies & Technical Capabilities
A transparent and realistic breakdown distinguishing verified hands-on experience from applied project pipelines and conceptual tooling knowledge.
Microsoft SQL Server & PostgreSQL
Hands-on ExperienceHands-on querying, diagnosing database errors, resolving discrepancies, investigating duplicate/missing records, and verifying backups.
SQL Querying & Data Integrity Auditing
Hands-on ExperienceHands-on writing SQL queries, auditing financial/transactional records, and resolving relational data anomalies.
Power BI & Advanced DAX Modeling
Hands-on ExperienceEngineered interactive dashboards consolidating operational KPIs with custom DAX time-intelligence formulas, reducing repetitive manual reporting by ~70%.
Python & Pandas Tabular Cleansing
Hands-on ExperienceBuilt automated scripts to parse, cleanse, and validate multi-thousand row tabular datasets, flagging anomalies and null entries prior to database ingestion.
Machine Learning & Predictive Modeling
Applied in ProjectsAcademic curriculum and end-to-end applied project pipelines: supervised classification, time-series forecasting, cost-sensitive learning, and model interpretability.
Advanced Excel & Financial Reconciliation
Hands-on ExperienceHands-on spreadsheet modeling, digital payment gateway reconciliation against ledger books, and auditing transactional entries.
Linux Administration (Ubuntu / CentOS)
Working KnowledgeWorking knowledge of Linux server navigation, troubleshooting OS-level errors, verifying user permissions, and monitoring background services via CLI.
Cloud Infrastructure (AWS EC2/S3 & GCP)
Working KnowledgeAssisted technical support for virtualized cloud environments, provisioning and maintaining VMs, storage buckets, and basic IAM monitoring.
Docker, Containers & Git Version Control
Working KnowledgeWorking knowledge of containerized runtimes, investigating container logs, and utilizing Git for repository version control and branching.
L1/L2 Incident Support & ITIL Methodology
Working KnowledgeUnderstanding of Incident, Problem & Change Management workflows, SLA adherence tracking, Root Cause Analysis (RCA), and escalation management.
ITSM Platforms (ServiceNow, Zendesk, HubSpot, JIRA)
Conceptual KnowledgeConceptual understanding of ticket lifecycles, incident triaging, severity tagging, SLA priority queues, and gathering diagnostic logs to assist development teams.
Tally ERP & Ledger Verification
Working KnowledgeWorking knowledge of transactional entries, purchase ledgers, digital record-keeping, and correcting financial mismatches during inventory audits.
Highlights & Interests
Beyond the data models, SQL queries, and dashboards — who I am as a teammate, communicator, and human.
Professional Vibe
Mindset & Work EthicFocused, adaptable, and always eager to learn new tech without taking life too seriously. Whether tackling complex database issues or picking up a new ML framework, I bring curiosity, calm problem-solving, and a positive attitude to every challenge.
Gaming
Downtime & StrategyFrom immersive RPGs to fast-paced multiplayer matches—always ready for the next level or a quick co-op session. Gaming sharpens tactical thinking, quick decision-making under pressure, and effective voice coordination with teammates.
Volleyball
Team Spirit & EnergyBringing great team spirit, quick reflexes, and high energy whether it’s on the indoor court or at the beach. Sports keep me active, agile, and reinforce the value of synchronized communication, trust, and continuous encouragement in a team.
Personality & Culture
Grounded & ApproachableLaid-back, approachable, and a firm believer that the best work happens when you’re having fun. Great data work requires cross-functional empathy; I enjoy making technical discussions comfortable, clear, and ego-free for everyone involved.
Culture Fit & Team Mindset
“Technical capability solves business problems; positive energy, clear communication, and mutual respect make the journey enjoyable.”
Connect with Kishor Prajapati
Actively interviewing for full-time Data Scientist, Machine Learning Engineer, Power BI Specialist, Technical & Database Support roles. Reach out directly via 1-click email or LinkedIn.
Send an Inquiry or Schedule an Interview
Feel free to reach out directly regarding opportunities, interview schedules, or project discussions.