Hello 🙏

I am Prachanda Oli

I am a Backend Developer

Backend Software Developer based in Kathmandu, Nepal.

View Selected Works

About

Hi, I am Prachanda Oli, a Software Engineer and Python Developer based in Nepal. Unlike the politicians, I build Odoo modules and Machine Learning models. I graduated in 2024 and specialize in Django ORM and Data Structures.

I love solving complex backend problems and optimizing database queries.

Core Technologies

Python (3.10+) C# JavaScript SQL HTML/CSS Django FastAPI .NET Core Odoo ERP Django Channels

Experience

Bajra Technologies

March 2025 – June 2025

Backend Developer Trainee (Team Lead) | Kathmandu, Nepal

  • Led a 12-member agile team to deliver the BTP Game project two weeks ahead of schedule, managing sprint planning and code reviews.
  • Enhanced performance by optimizing PostgreSQL query execution through advanced indexing strategies, query refactoring, and ORM optimization.
  • Built a Public Library Resource Management System using Odoo 13 to streamline operations for community and city libraries.

AMNIL Technologies Pvt. Ltd.

March 2024 – May 2024

.NET Developer | Lalitpur, Nepal

  • Built robust desktop applications utilizing C#, WinForms, and MVC architecture for enterprise data management.
  • Optimized SQL Server queries, enhancing application response times and data retrieval efficiency.
  • Implemented complex business logic using Entity Framework (EF Core) and ADO.NET.

Selected Projects

Odoo Project

Public Library Resource Management System

A user-friendly, scalable system built with Odoo 13 to efficiently manage books, users, and reservations for public libraries.

Odoo 13 Python PostgreSQL XML JavaScript
GitHub
Personal Project

IMDb Clone API - Scalable Backend

Architected a RESTful API with JWT authentication and complex database relationships (Movies, Crew, Actors).

Django Redis Celery Docker JWT
GitHub Live Demo
Personal Project

Real-Time Messenger App

Developed a full-duplex chat application supporting instant messaging and persistent chat history for users.

Django Channels WebSockets Redis
GitHub
Data Analysis Project

NPL 2024 Data Analysis

Analyzed league financial data to visualize team spending efficiency, player salary distribution, and role-based contribution.

Python Pandas Matplotlib
GitHub
Machine Learning Project

California House Price Prediction

End-to-end ML project predicting house prices in California using 1990 census data. Achieved 73% variance explanation using tuned Gradient Boosting with comprehensive feature engineering and model optimization.

Python Scikit-learn Pandas NumPy Matplotlib Seaborn Jupyter GridSearchCV
GitHub

Education

Academia International College

B.Sc. in Information Technology (BSc-CSIT)

Jan 2019 – Aug 2024

Certifications

  • Foundational C# with Microsoft
  • Completion Certificate for .Net Full Stack Foundation (Coursera)
  • Advanced SQL Project: Design and Manage a Database (Walter Shields)
  • Learn SQL for Developers (Educative)

Writing

2024-02-22

Avoiding Race Conditions with F() Expressions

How to update database values safely in high-concurrency environments.

Read Article
2024-02-25

Speed Up Writes with bulk_create and bulk_update

Inserting and updating thousands of records efficiently.

Read Article
2024-02-28

Advanced Patterns: Subquery and Exists

Using nested queries for deep optimization.

Read Article
← Prev 3 / 3