Ranjan Bhagat
A passionate and skilled software engineer with over 4 years of experience in building applications across various domains using Flutter and React.js. I have actively explored and built AI-driven solutions, including the development of the Metabase MCP Server, demonstrating my ability to integrate AI tools into functional systems.
But there’s more to me than just code. I’m deeply curious about startups and the process of turning ideas into real-world solutions. I love exploring new business concepts and dreaming up products that solve meaningful problems.
Beyond code, I’m someone who enjoys meaningful conversations and spontaneous plans. In my free time, I love playing guitar, singing, exploring new places, meeting people from different walks of life, and creating lasting memories. I believe growth comes not just from lines of code, but also from the connections we build and the joy we spread.
Let’s connect, collaborate, or just chat, I’m always open to new ideas and stories.
Projects
Metabase MCP Server
Metabase: An open-source business intelligence tool.
Model Context Protocol (MCP): An open protocol that allows AI assistants to understand and interact with tools and APIs enabling natural language access to backend systems.
Developed a Python-based backend server to bridge Metabase with AI assistants using the Model Context Protocol (MCP). This integration enables natural language access to Metabase dashboards, saved queries, and SQL data through structured APIs. The project emphasizes clean, scalable, and well-documented code, with a GitHub repo and video walkthrough for easy onboarding.
Technologies & Tools : Python, MCP, Metabase API, Docker, GitHub
GitHub Repository: CW-Codewalnut/metabase-mcp-server
Youtube Video: Data Analytics Jobs are DEAD? How AI is Replacing Analysts!
Sabre’s Continuous Revenue Optimizer (CRO)
Sabre's Continuous Revenue Optimizer (CRO), a React-based data analysis app for flight data and revenue optimization. Developed key features like Last Year in Booking Curve and Flight Analysis, fixed critical bugs, and improved stability. Used Sabre Spark (UI library) for design consistency and integrated Highcharts & AG Grid for data visualization. Collaborated with the Scrum Master, Tech Lead, stakeholders, and UI/UX team, contributing to sprint planning, feature discussions, and grooming meetings. Translated Figma designs into functional components and managed tasks via Rally & GitHub.
Technologies & Tools: React.js, TypeScript, SCSS, Sabre Spark (UI Library), Highcharts, AG Grid, Figma, Rally, GitHub
Hiring Assessment Tool
Led the frontend development for Codewalnut’s Hiring Assessment Tool, designing and implementing a scalable and efficient UI. Deployed the application using Firebase and leveraged Bolt and Cursor to accelerate development. Developed a secure online assessment system where shortlisted candidates receive test links for the next round. Implemented proctoring features, including camera monitoring, tab/app switching restrictions, internet connection tracking, and automated violation warnings leading to disqualification. These features ensured fairness and security in the hiring process.
Technologies & Tools: React.js, TypeScript, Tailwind CSS, Firebase, Bolt, Cursor
Timer Assignment
Designed and developed a Timer App Assignment to assess React developers’ proficiency in UI implementation, state management, and best practices. Built using React (Vite), Tailwind CSS, and Vitest for testing, the assignment featured simultaneous timers support, snackbar notifications with sound control, reusable components, LocalStorage persistence, and device-responsive UI enhancements. Created unit and component tests to evaluate candidates' testing proficiency and established evaluation criteria based on code quality, functionality, responsiveness, and testing coverage.
Technologies & Tools: React.js, TypeScript, Vite, Tailwind CSS, Vitest, LocalStorage, GitHub
SEO Watchdog
SEO Watchdog is a tool designed to monitor and enhance website SEO performance. It scans web pages and reports key metrics such as performance, core web vitals, accessibility, and SEO best practices.
The tool provides actionable insights that help website owners and digital marketers improve their site’s performance and visibility in search results.
Technologies & Tools: React, TypeScript, FastAPI, Python, Docker, Digital Ocean Droplets, Firebase, GCP
Flutter Template
An open-source Flutter template under Apache 2.0 license that provides a structured starting point for mobile app development. It includes a well-organized folder structure, essential utilities, dependency injection, internationalization, and asset management.
This template helps developers streamline the setup process and maintain a clean architecture, serving as a valuable resource for those seeking a solid foundation. There is also a premium flutter template which has advanced features like Firebase integration, authentication, and notifications and more.
GitHub Repository: CW-Codewalnut/free_flutter_template
Blog: Flutter Template Blog
Akasa Air
Akasa Air is India’s newest affordable airline, committed to providing reliable and comfortable air travel with a customer-first approach.
The Akasa Air mobile app enhances the travel experience by allowing users to seamlessly book, check-in, and manage their flights. It offers essential features like a boarding pass QR code, real-time flight status updates, and customer support chat, ensuring convenience at every step.
Built using Flutter, GraphQL, and Firebase, the app delivers a fast, smooth, and user-friendly experience, making it the perfect travel companion for hassle-free and budget-friendly journeys.
Palash
Palash is an online upskilling platform for women that offers short video courses on various topics such as beauty, fashion, health, and wellness. The app allows users to learn new skills, discover their passions, and connect with other like-minded women.
The app also features a Reels style short video feed that showcases the best content from the instructors and the learners.
The app uses Flutter and Firebase to create a smooth and engaging user experience. Palash is the perfect app for women who want to learn, grow, and have fun.
New Time
News Time is a mobile app that delivers the latest news from various sources and
categories. The app allows users to browse and read news articles that interest them. The Flutter version of the app uses Firebase to provide secure and easy authentication, allowing users to sign in with their email or Google account. It also features a simple and elegant user interface with support for both light and dark themes.
I have also developed the React.js version of the app, which is available on GitHub. While it retains the core functionality of delivering news, it does not yet include the features present in the Flutter version, such as Firebase authentication and theme support.
Download Flutter version: News Time App
GitHub repository: New Time React.js App
Socially
A social media application made using Flutter and Firebase that allows users to create and share posts, chat with friends, and follow other users.
Download : Socially App
Videos
Data Analytics Jobs are DEAD? How AI is Replacing Analysts!
Introducing the MCP server a flexible interface that allows AI clients or LLM to perform tasks like create charts, dashboards etc. through simple prompts.
Rep: metabase-mcp-server
Instant insights using GSC & Claude AI
This video demonstrates how integrating Google Search Console (GSC) with Claude AI can revolutionize SEO analysis and reporting.
Blogs
Build Flutter Apps Faster: Unleash the Power of Templates
Struggling to speed up Flutter app development? This blog offers customizable templates and pre-built components to streamline your process. Boost your productivity—read more now.
GitHub Rep: free_flutter_template
App Usage Spikes: Strategies for Effective Management
Struggling with sudden app usage spikes? This blog outlines key strategies to ensure your app's stability through effective app performance monitoring. Learn how to prepare for and manage unexpected traffic surges. Read now!
How to Manage Dynamic Content in Your App Like a Pro
Do you want to create and deliver content that changes based on who your users are and what they do? If so, you need to learn about dynamic content and how to use it in your app.
Resolve Tickets: Streamline Your App's Customer Support
Struggling with unresolved support tickets in your app? Discover practical strategies to swiftly address customer support tickets, enhancing user satisfaction. Dive in for expert insights and actionable tips. Start improving now!
Records in Dart 3
Dart 3 🎯 lets you make and use records. Records are collections of values that don’t change. Records are like tuples in other languages, but they have some cool features. In this blog post, I will tell you what records are, how to use them, and how they can make your code better and easier to read. 🚀