// Sandeepan_Mohanty_Resume.pdf
Sandeepan Mohanty
✆+91 8658463545 ✉sandimohanty@gmail.com inLinkedIn ⌥GitHub

Experience

Graduate Engineer TraineeAugust 2024 – October 2025
HCLTech – Citrix Client Project · Bangalore, India
  • Data Analysis: Analyzed 1M+ rows of operational and business data using SQL and Python, delivering insights that supported weekly decision-making across multiple teams.
  • EDA: Performed EDA and root cause analysis on 200+ incident cases, reducing average resolution time by 35%.
  • Automation & Reporting: Automated 5+ recurring reports and data pipelines, saving 15+ hours/week and improving reporting accuracy by 25%.
  • Dashboarding: Built 6+ KPI dashboards tracking SLA, performance, and volume metrics, used by 20+ stakeholders.
Business Analyst InternJanuary 2024 – July 2024
PhonePe · Bangalore, India
  • Regulatory Analytics: Standardized data workflows for 20+ RBI regulatory reports, ensuring 100% audit compliance and reducing submission errors by 30%.
  • SQL Optimization: Optimized 15+ complex SQL queries, improving data extraction time by 30%.
  • Data Visualization: Developed 10+ QlikSense dashboards enabling 30+ stakeholders to monitor metrics independently.
  • Business Reporting: Delivered 8 custom reporting solutions across 5 cross-functional teams, increasing turnaround by 25%.
Software Development Engineer InternJanuary 2023 – December 2023
Hatica · Remote
  • Frontend Performance: Reduced page load time by 30% (4.2s → 2.9s) and improved Core Web Vitals by 40% using React.js, Gatsby.js, and Prismic.
  • UX: Delivered responsive UI for 5,000+ daily users, driving 20% increase in engagement and 15% reduction in bounce rate.
  • Backend: Integrated FormSpark with Node.js APIs, reducing form submission errors by 25%.

Projects

SplitExpense – Expense Sharing Web AppReact.js · Firebase · JavaScript · HTML/CSS
  • Real-time expense sharing platform supporting 50+ active users with sub-second sync and accurate balance computation.
  • Equal and custom splitting across 100+ transactions with Firebase Authentication and multi-user data integrity.
  • Reduced manual expense reconciliation by 90%.
Sales Data AnalysisPython · SQL · MySQL · Pandas · NumPy
  • Analyzed 50,000+ rows of Walmart sales data, achieving 92% forecast accuracy through feature engineering on 10+ variables.
  • Built predictive models identifying top-performing regions and seasonal sales trends.
Pigeon – Anonymous Messaging SiteReact.js · MongoDB · Express · Node.js
  • Full-stack web app allowing users to send and receive anonymous messages with 500+ users.
  • REST API built with Express.js, MongoDB backend, JWT Authentication, and React.js frontend.
Python Syntax Helper CLIPython · PyPI
  • Published Python package on PyPI providing 6+ reusable syntax templates, reducing coding effort by 60%.
  • 200+ weekly downloads; structured input validation reduced runtime errors by 40%.

Education

B.Tech in Computer Science and EngineeringDecember 2020 – May 2024
Veer Surendra Sai University of Technology, Burla
CGPA: 8.70 / 10.0  ·  Operating Systems, Data Structures, Algorithms, Networking, Databases

Skills

LanguagesPython, JavaScript, SQL, C/C++, HTML/CSS
FrameworksReact.js, Node.js, Express.js, Next.js
DatabasesMySQL, PostgreSQL, Firebase, MongoDB
ToolsGit/GitHub, Linux, Postman, VS Code, AWS
assets/resume/Sandeepan_Mohanty_Resume.pdf
⬇ Download PDF ↗ View PDF

Available for opportunities

Sandeepan
Mohanty

Software Engineer

I turn complex data into sharp decisions and ship production-grade software. Based in India — building at the intersection of data analytics and full-stack engineering.

Let's Work Together
LinkedIn GitHub +91 8658 463 545

Toolkit

Technical Skills

Languages

PythonJavaScript SQLC / C++ HTMLCSS

Frameworks

React.jsNode.js Express.jsNext.js Gatsby.js

Databases

MySQLPostgreSQL FirebaseMongoDB

Tools & Platforms

Git / GitHubLinux AWSPostman VS CodeQlikSense

Built

Featured Projects

// 01

SplitExpense ↗

Real-time expense sharing platform with equal and custom splitting, live Firebase sync and multi-user data integrity.

  • Real-Time System: Firebase Realtime Database supporting 50+ active users with sub-second synchronization.
  • Splitting Logic: Equal and custom splitting across 100+ transactions with Firebase Authentication.
  • Scalable Frontend: Responsive React.js UI reducing manual reconciliation by 90%.
50+Active Users
<1sSync Speed
90%Less Manual Work
React.jsFirebase JavaScriptHTML / CSS

// 02

Sales Data Analysis ↗

End-to-end data analysis on 50,000+ rows of Walmart sales data using Python and SQL with high-accuracy predictive modelling.

  • Feature Engineering: Engineered 10+ variables including seasonal trends and regional performance for model input.
  • Predictive Modelling: Built models achieving 92% forecast accuracy, identifying top-performing regions.
  • SQL + Python Pipeline: End-to-end pipeline from raw MySQL data to actionable business insights using Pandas and NumPy.
50K+Rows Analysed
92%Forecast Accuracy
10+Features Built
PythonSQL MySQLPandasNumPy

// 03

Pigeon – Anonymous Messaging ↗

Full-stack web app letting users send and receive anonymous messages. One of my most popular projects with 500+ users.

  • REST API: Built with Express.js communicating with MongoDB for scalable message storage.
  • Auth: JWT Authentication System for secure, stateless user sessions.
  • Frontend: React.js UI integrated with the backend API for seamless anonymous messaging.
500+Users
RESTAPI
JWTAuth
React.jsMongoDB Express.jsNode.js

// 04

Python Syntax Helper CLI ↗

Published Python package on PyPI providing reusable CLI syntax templates — cutting boilerplate and reducing runtime errors through structured validation.

  • CLI Tool: 6+ reusable syntax templates published on PyPI, reducing repetitive coding effort by 60%.
  • Adoption: 200+ weekly downloads; structured input validation reduced runtime errors by 40%.
200+Weekly Downloads
6+Templates
60%Effort Saved
PythonPyPICLI

Academic

Education

B.Tech — Computer Science & Engineering

Veer Surendra Sai University of Technology, Burla

December 2020 — May 2024

Operating Systems Data Structures Analysis of Algorithms Networking Databases
8.70
CGPA / 10.0

Contact

Let's Build
Something Great

Whether it's a data challenge, a web product, or just a good conversation — my inbox is open.

✉sandimohanty@gmail.com inLinkedIn ⌥GitHub ☎+91 8658463545
Say Hello →