Prathmesh Mehrotra

Prathmesh Mehrotra

Software Dev Engineer
Dubai , Dubai , United Arab Emirates (UAE)
English, Hindi

About Me

Backend-focused Software Engineer specializing in distributed architectures, async job pipelines, and large-scale API integrations. Currently building fault-tolerant infrastructure at a B2B fintech startup. Strong founda…

Experience

Software Development Engineer Intern

Kema | Media City, Dubai · Dubai , Dubai , United Arab Emirates (UAE)
Jan 2026 - Present · 9 months

<ul><li>Led end-to-end Odoo ERP integration by building invoice, payment, and credit note data processing pipelines, and drove migration from the deprecated XML-RPC protocol to the JSON 2.0 API, , ensuring long-term compatibility. </li><li>Designed a fault-tolerant inbound request logging system using FSM-managed state transitions, Django middleware for request capture, and a config-driven Celery retry handler, enabling automatic replay of failed API Requests and improving pipeline reliability with zero manual intervention. </li><li>Architected a payments & allocations revamp, redesigning the data model and building new REST APIs with transactional atomicity, multi-layer validation, and full CRUD on payment-invoice allocations and delivered comprehensive unit and integration test coverage for all new endpoints. </li><li>Unified 5+ ERP webhook pipelines (QuickBooks, Xero, Zoho, Wafeq, Odoo) into a single async Celery architecture reducing code duplication and standardizing event processing </li><li>Identified a ~5s admin dashboard load time caused by over-fetching; introduced a lightweight serialiser, server-side search, and scroll-based paginated dropdown, reducing load time by over 70%</li></ul>

Software Development Engineer Intern

Kema
Jan 2026 - Present · 9 months

<p>Led end-to-end Odoo ERP integration by building invoice, payment, and credit note data processing pipelines.<br>
Drove migration from the deprecated XML-RPC protocol to the JSON 2.0 API, ensuring long-term compatibility.<br>
Designed a fault-tolerant inbound request logging system using FSM-managed state transitions, Django middleware for request capture, and a config-driven Celery retry handler.<br>
Enabled automatic replay of failed API requests and improved pipeline reliability with zero manual intervention.<br>
Architected a payments & allocations revamp, redesigning the data model and building new REST APIs with transactional atomicity, multi-layer validation, and full CRUD on payment-invoice allocations.<br>
Delivered comprehensive unit and integration test coverage for all new endpoints.<br>
Unified 5+ ERP webhook pipelines (QuickBooks, Xero, Zoho, Wafeq, Odoo) into a single async Celery architecture.<br>
Reduced code duplication and standardized event processing.<br>
Identified a ~5s admin dashboard load time caused by over-fetching.<br>
Introduced a lightweight serialiser, server-side search, and scroll-based paginated dropdown.<br>
Reduced load time by over 70%.</p>

Software Development Engineer Intern

DH Lighting | Hybrid · Noida , Uttar Pradesh , India
May 2026 - Oct 2026 · 5 months

<ul><li>Designed and developed a full-stack e-commerce platform from scratch, building a normalized PostgreSQL schema for products, orders, inventory, and users with integrity across all relations.</li><li>Built a Node.js/TypeScript REST API backend with Redis-based session management and product catalog caching, reducing repeated database queries on high-traffic pages.</li><li>Integrated Razorpay payment gateway with server-side webhook handling for real-time order confirmation and payment status updates.</li><li> Delivered a high-performing production website with 5000+ visitors and 500+ successful orders, with Redis caching keeping response times stable under load.</li></ul>

Software Development Engineer Intern

DH Lighting
May 2026 - Oct 2026 · 5 months

<p>Designed and developed a full-stack e-commerce platform from scratch.<br>
Built a normalized PostgreSQL schema for products, orders, inventory, and users with integrity across all relations.<br>
Built a Node.js/TypeScript REST API backend with Redis-based session management and product catalog caching.<br>
Reduced repeated database queries on high-traffic pages.<br>
Integrated Razorpay payment gateway with server-side webhook handling for real-time order confirmation and payment status updates.<br>
Delivered a production website with 5000+ visitors and 500+ successful orders.<br>
Kept response times stable under load with Redis caching.</p>

Skills

Linux PostgreSQL Shell Scripting Django NumPy Redis Vue.js Docker Node.js React Express REST APIs Next.js Pandas Matplotlib Seaborn Scikit-learn SpaCy Git Github Sentry Vector databases RAG pipelines Ollama (open-source LLM deployment OpenAI/Anthropic APIs Python C++ TypeScript Go SQL Ollama HNSW KD-Tree WebSockets Socket.IO Razorpay Celery Ngrok OpenAI APIs Anthropic APIs
Report this Profile?