Summary
Overview
Work History
Education
Skills
Timeline
Generic

Smit Mandavia

Vadoadra

Summary

Results-driven Python Developer with a strong background in backend development, data engineering, and API integration. Skilled in building robust, scalable systems using FastAPI, SQL (MySQL, PostgreSQL, MSSQL), and Pandas for enterprise-level applications. Proven expertise in automating workflows, developing custom ETL pipelines, and integrating real-time reporting solutions across HR, trading, and analytics domains. Adept at data visualization using Apache ECharts, ensuring intuitive and insightful dashboards. A collaborative team player with a problem-solving mindset, passionate about writing clean, maintainable, and performance-optimized code in fast-paced, data-centric environments.

Overview

1
1
year of professional experience

Work History

Python Developer

Junomoneta Finsol PVT LTD
Gift City
01.2025 - Current

Responsibilities:

  • Designed and developed robust RESTful APIs using FastAPI to support modules like attendance reports, trader performance dashboards, and HRMS data integration.
  • Built custom ETL pipelines to extract, transform, and load data across MySQL, PostgreSQL, and MSSQL databases for real-time analytics.
  • Automated daily reporting tasks using Pandas, generating styled HTML reports and CSV attachments, and sending them via internal email notification services.
  • Created backend logic for modules such as PIP detection, anomaly monitoring, strategy usage, and performance forecasting in the Trade Insights platform.
  • Implemented secure data migration routines between databases, ensuring integrity and optimizing query performance using joins, indexing, and aggregations.
  • Collaborated closely with frontend teams to integrate APIs with ReactJS, ensuring seamless user interactions and data flow.

React Contributions:

  • Developed dynamic, responsive dashboards and UI components using ReactJS for visualizing PnL performance, strategy trends, and attendance analytics.
  • Integrated Apache ECharts to render interactive Bar, Line, and Multi-Series Charts for PnL and margin analysis, with features like hover tooltips, conditional coloring, and dropdown filters.
  • Built reusable components such as dropdowns and strategy selectors to enhance UI modularity and maintainability.
  • Implemented features like financial year toggle, trader drill-down, and employee insights views, driven by real-time data from backend APIs.
  • Ensured frontend state synchronization and dynamic chart rendering based on API responses and user input.

Technologies Used:

  • Backend: Python, FastAPI, Pandas, SQLAlchemy
  • Frontend: ReactJS, Apache ECharts, Axios, CSS (custom)
  • Databases: MySQL, PostgreSQL, MSSQL
  • Tools: Git, Postman, SQLyog.
  • Other Skills: API Integration, Data Visualization, ETL, Automation, Performance Monitoring, Reporting, Cross-Team Collaboration

Education

Post Graduate - Software Engineering Technology - Artificial Intelligence

Centennial College
Toronto
2023

Bachelor of Science - Computer Science

Gujarat Technical University
Gujarat
2020

Skills

  • Languages & Frameworks: Python, FastAPI, SQL, ReactJS
  • Backend Development: RESTful API design, FastAPI-based services, ETL pipelines, reporting automation
  • Frontend Development: Component-based UI in ReactJS, Apache ECharts integration for dynamic charts, responsive dashboards
  • Databases: MySQL, PostgreSQL, MSSQL – joins, aggregations, indexing, data migration
  • Data Processing & Automation: Pandas, NumPy, openpyxl, smtplib – data cleaning, transformation, HTML/CSV report generation
  • Tools & Platforms: Git, Postman, SQLyog, DBeaver, VS Code
  • Others: API integration with frontend, strategy performance monitoring, real-time analytics, cross-functional collaboration

Timeline

Python Developer

Junomoneta Finsol PVT LTD
01.2025 - Current

Post Graduate - Software Engineering Technology - Artificial Intelligence

Centennial College

Bachelor of Science - Computer Science

Gujarat Technical University
Smit Mandavia