• 🇯🇵 Currently working as a Software Developer & System Engineer in Japan, building enterprise construction management systems, AI-powered document tools, and data pipelines at scale.
• 🎓 B.Tech in Mechanical Engineering from IIT(ISM) Dhanbad (2020–2024).
• 🧩 Passionate about full-stack development, AI/RAG systems, data-intensive dashboards, and system design.
• 🛠 I love turning complex business workflows into clean, performant, and maintainable systems.
• 🔭 Current focus:
  • AI Document Assistant – RAG stack with Gemini Vision, pgvector, LangChain, and SSE-streamed output.
  • Centralized MySQL Query Runner – execute SQL across multiple DBs with one interface.
  • Multi-Server Data Transfer / ETL Tool – sync distributed MySQL servers into a central warehouse.
  • Authentication & Authorization for production-grade apps.
• 💬 Ask me about Next.js, React, Node.js, LangChain, RAG, System Design, Dashboards, and SQL-heavy backends.
• 📫 Reach me at shivankarmehta60@gmail.com
• 🌐 Portfolio: shivankarportfolio.netlify.app

Software Developer & System Engineer — Standard Force Corporation, Japan (Oct 2024 – Present)

• Architected a distributed ETL pipeline consolidating 4 remote MySQL databases into a centralized warehouse via SSH2 tunneling and cron-based batch sync; managed end-to-end CI/CD with Docker and Git across AlmaLinux servers, cutting deployment time by 60%.
• Built an AI Document Assistant supporting PDF, Office, image, Excel, and audio uploads with natural language querying; implemented a full RAG stack with Gemini Vision, Tesseract OCR, pgvector search, pg-boss workers, and SSE-streamed token output via LangChain.
• Delivered an enterprise Construction Management System with real-time budget alerts, financial tracking, and compliance monitoring across 5 client organizations with zero-downtime rollouts.
• Built a Next.js dashboard with virtualized tables, Recharts/Tremor visualizations, drag-and-drop layout, fuzzy search, Redis caching (40% load reduction), Excel export pipelines, and a QR Code Management System with real-time logistics tracking.

Full Stack Developer Intern — Life Team United (LTU Corporation), Japan (May 2023 – Sep 2024)

• Designed and deployed a full-stack supply chain dashboard (ReactJS, Node.js, MySQL) serving 3 internal teams; reduced manual reporting time by 50%.
• Integrated Nivo and Wijmo chart libraries into an existing Laravel project over secure SSH tunneling.

Frontend Developer Intern — Urban Reach & Fynii, India (Jun 2022 – Jan 2023)

• Engineered a responsive ReactJS Sales Management System for 200+ users in the agricultural sector.
• Developed tutor selection and matching modules for Fynii's EdTech platform, supporting 500+ student–tutor pairings.

• 🤖 AI Document Assistant Next.js · LangChain · Gemini Vision · pgvector · Tesseract OCR · pg-boss Natural language querying over uploaded documents (PDF, Office, image, Excel, audio). Full RAG stack with vector search, OCR, background job workers, and SSE-streamed token output.

• 🗄️ Centralized MySQL Query Runner JavaScript · Express.js · MySQL · OOP Execute SQL queries simultaneously across multiple databases with identical schemas — class-based OOP, multi-threading, logging, and transaction management. ~80% reduction in manual query execution effort.

• 🌐 Multi-Server Data Transfer Tool Node.js · MySQL · SSH2 Automated ETL pipeline to migrate & synchronize data from multiple servers into a central data warehouse — connection pooling, data validation, batch processing, SSH tunneling, cron scheduling, and transaction rollback.

• 🎥 Automated Online Classroom Platform ReactJS · Node.js · Python · WebRTC · Socket.io · ML Multi-user video calling with real-time chat, automated attendance, speech transcription, and ML-based attention detection for 50+ concurrent users. Top 5 at HACKFEST 2022, IIT(ISM) Dhanbad.

• 🔐 Authentication Project (Node.js) Repo: nodeauth_complete End-to-end authentication & authorization with session/JWT-based flows and production security best practices.

JavaScript, C++, SQL, Python

Node.js · Express.js · REST APIs · WebSockets · SSH2 · Streams · Clusters

RAG · LangChain · Gemini API · MCP Server · pgvector · Document Intelligence · Tesseract OCR · pg-boss

MySQL · PostgreSQL · Redis · pgvector · ETL Pipelines · Query Optimization

Docker · Git · CI/CD · AlmaLinux · CentOS · Sakura Internet · SSH Tunneling · Cron Jobs · Server Management

Data Structures & Algorithms · Object-Oriented Programming · DBMS · Computer Networks · Operating Systems

• LeetCode: shivankar_123 · HackerRank: shivankarmehta60
• Active on CodeChef, CodeForces, AtCoder — 1500+ DSA problems solved across platforms.

• 🏅 Top 5 — HACKFEST 2022, IIT(ISM) Dhanbad · Automated Online Classroom with ML-based attention detection
• 🥈 1st Runner-up — Web-It-Up Competition · Team: Binary Bombers
• 🥈 1st Runner-up — Ideate Competition · Off-Earth Mining concept
• 🌍 Global Rank 511 — CodeChef Starters 27
• 🌍 Global Rank 1571 — AtCoder Regular Contest 141
• 🌍 Global Rank 605 — Newton Coding Challenge

• Event Head of the largest cultural fest of Eastern India — annual socio-cultural fest of IIT(ISM) Dhanbad.
• Founder of YouTube channel "Integrative Learning" — led a team of ~20 for teaching & management.
• Coordinator at Chayanika Sangh — Hindi literary club of IIT(ISM).
• Member of Student Coordination Placement Team (2022–23).

Open to collaboration on full-stack, data systems, and AI-powered applications. Feel free to reach out! 🙂