Ranjana Tiwari

Software Engineer

Mumbai, Maharashtra, India4 yrs 11 mos experience
Highly Stable

Key Highlights

  • Reduced MySQL performance from 15s to under 2s.
  • Built a Visitor Management System for Mahindra.
  • Developed a complete Loyalty Platform with instant payouts.
Stackforce AI infers this person is a Backend-focused Software Engineer with experience in Fintech and SaaS industries.

Contact

Skills

Core Skills

Backend DevelopmentDatabase ManagementFrontend DevelopmentWeb Development

Other Skills

.NET FrameworkAJAXAPI DevelopmentAWSAgile MethodologiesAmazon Web Services (AWS)Android DevelopmentAndroid SDKApplication DevelopmentArchitectureBack-End Web DevelopmentBootstrapBusiness RequirementsCSSComputer Science

About

Iโ€™m a ๐’๐จ๐Ÿ๐ญ๐ฐ๐š๐ซ๐ž ๐„๐ง๐ ๐ข๐ง๐ž๐ž๐ซ experienced in designing ๐ฌ๐œ๐š๐ฅ๐š๐›๐ฅ๐ž ๐›๐š๐œ๐ค๐ž๐ง๐ ๐ฌ๐ฒ๐ฌ๐ญ๐ž๐ฆ๐ฌ, improving performance, and automating business workflows. Iโ€™ve worked across domains like ๐•๐ข๐ฌ๐ข๐ญ๐จ๐ซ ๐Œ๐š๐ง๐š๐ ๐ž๐ฆ๐ž๐ง๐ญ, ๐‹๐จ๐ฒ๐š๐ฅ๐ญ๐ฒ & ๐‘๐ž๐ฐ๐š๐ซ๐ ๐’๐ฒ๐ฌ๐ญ๐ž๐ฆ๐ฌ, ๐๐š๐ฒ๐ฆ๐ž๐ง๐ญ ๐๐ซ๐จ๐œ๐ž๐ฌ๐ฌ๐ข๐ง๐ , and ๐…๐ข๐ž๐ฅ๐ ๐Ž๐ฉ๐ž๐ซ๐š๐ญ๐ข๐จ๐ง๐ฌ, building solutions used by thousands of daily users. โ— ๐Š๐ž๐ฒ ๐‡๐ข๐ ๐ก๐ฅ๐ข๐ ๐ก๐ญ๐ฌ โ€ข Improved MySQL performance from ๐Ÿ๐Ÿ“๐ฌ โ†’ ๐ฎ๐ง๐๐ž๐ซ ๐Ÿ๐ฌ, optimizing over ๐Ÿ“๐Œ+ ๐ซ๐ž๐œ๐จ๐ซ๐๐ฌ. โ€ข Built a ๐•๐ข๐ฌ๐ข๐ญ๐จ๐ซ ๐Œ๐š๐ง๐š๐ ๐ž๐ฆ๐ž๐ง๐ญ ๐’๐ฒ๐ฌ๐ญ๐ž๐ฆ for Mahindra, reducing processing time from ๐Ÿ๐ŸŽ ๐ฆ๐ข๐ง โ†’ ๐Ÿ ๐ฆ๐ข๐ง. โ€ข Developed a complete ๐‹๐จ๐ฒ๐š๐ฅ๐ญ๐ฒ ๐๐ฅ๐š๐ญ๐Ÿ๐จ๐ซ๐ฆ (๐€๐ญ๐จ๐จ๐ญ ๐๐š๐ง๐๐ก๐š๐ง) including coupon scanning, points, dashboards, and instant payouts. โ€ข Designed secure payment flows handling โ‚น๐Ÿ๐ŸŽ+ ๐ฅ๐š๐ค๐ก๐ฌ/๐ฆ๐จ๐ง๐ญ๐ก with JWT authentication. โ€ข Integrated barcode scanning, automated SMS/email alerts, and approval workflows to eliminate manual processes. โ€ข Built ๐‘๐„๐’๐“ ๐€๐๐ˆ๐ฌ for sales operations, master data, and field activities. โ€ข Published and maintained ๐…๐ฅ๐ฎ๐ญ๐ญ๐ž๐ซ ๐š๐ฉ๐ฉ๐ฌ on the Play Store & App Store before moving full-time into backend engineering. โ— ๐“๐ž๐œ๐ก ๐’๐ญ๐š๐œ๐ค ๐ˆ ๐–๐จ๐ซ๐ค ๐–๐ข๐ญ๐ก โ€ข Languages โ†’ JavaScript, SQL, Dart โ€ข Backend โ†’ Node.js, Express, JWT, Redis, MySQL โ€ข Cloud โ†’ Firebase, Google Cloud โ€ข Mobile โ†’ Flutter (previous experience) โ€ข DevOps / Tools โ†’ Docker, Nginx, PM2, Git, Postman โ€ข APIs โ†’ Google Maps, GPS Location, FCM, Google Play Services โ— ๐‹๐ข๐ง๐ค๐ฌ โ€ข ๐†๐ข๐ญ๐‡๐ฎ๐›: https://github.com/Ranj1/ โ€ข ๐๐จ๐ซ๐ญ๐Ÿ๐จ๐ฅ๐ข๐จ: https://ranjanatiwari.com/

Experience

4 yrs 11 mos
Total Experience
4 yrs 11 mos
Average Tenure
4 yrs 11 mos
Current Experience

Zeki software solutions pvt. ltd

Software Engineer

Jul 2021 โ€“ Present ยท 4 yrs 11 mos ยท Mumbai, Maharashtra, India

  • Optimized MySQL query performance, reducing API response time from 15s to under 2s on queries running across 5M+ transaction records by adding indexing, restructuring joins, and using summary tables.
  • Developed a secure payment processing system using Node.js, Express, MySQL, and JWT, handling โ‚น20+ lakhs per month with penny-drop verification, idempotency, retry logic, and trigger-based audit logs.
  • Implemented a robust payout retry mechanism where each attempt generates a new request_id while maintaining the same transaction_id and idempotency_key, ensuring zero duplicate payments and complete attempt history.
  • Built an automated Visitor Management System for Mahindra, handling 300+ daily visitors and reducing check-in time from 10 minutes to 1 minute using barcode-based Entry/Exit APIs with automated SMS and email notifications.
  • Designed and optimized REST APIs for field operations (attendance, dealer visits, orders, dispatch logs), processing 10,000+ daily operational records, and improved performance by 40โ€“60% using indexing, pagination, and efficient SQL queries.
  • Implemented a secure RBAC (Role-Based Access Control) system with JWT authentication, permissions tables, and middleware-level authorization for Salesperson, Manager, Dealer, Distributor, and Admin roles.
  • Developed cross-platform Flutter mobile features with optimized UI, state management, and integrations including Google Maps, GPS tracking, FCM notifications, and real-time syncing for 100+ field agents.
  • Took end-to-end ownership of backend architecture, including cron jobs, database design, performance tuning, deployment pipelines, and full audit logging for production systems.
MySQLNode.jsExpressJWTREST APIsFirebase+3

Freshvnf

Frontend Developer

Jan 2020 โ€“ Apr 2020 ยท 3 mos ยท Mumbai, Maharashtra, India ยท On-site

  • Developing and maintaining the back-end & front-end functionality of websites using ReactJs and NodeJS.
  • Developed a Responsive and interactive profile page using HTML, CSS, JavaScript, Bootstrap, ReactJs and NodeJS.
  • Employed AJAX and JSON technologies to create a seamless data exchange between the front-end and back-end.
  • Responsible for writing the Cross-browser compliant HTML, CSS & JavaScript code.
ReactJsNodeJSHTMLCSSJavaScriptBootstrap+3

Education

Vasantdada Patil Pratishthanโ€™s College of Engineering and Visual Arts (VPPCOEVA)

BE - Bachelor of Engineering โ€” Computer Engineering

Jan 2014 โ€“ Jan 2019

Stackforce found 100+ more professionals with Backend Development & Database Management

Explore similar profiles based on matching skills and experience