Gyan Ranjan Ojha

Gyan Ranjan Ojha

Backend Engineer @Gameopedia

Current: Hyderabad, Telangana, India

Hometown: Puri, Odisha, India

Passionate Backend Engineer with 3.5+ Years Professional in building scalable web apps, cloud-native backend applications and RESTful APIs. Specialized in Django, FastAPI, and AWS cloud services with a strong focus on code quality and performance optimization.

EXPERTISE

Django, FastAPI, Flask, MySQL, PostgreSQL
Web Apps & APIs
AWS, Docker, CI/CD, Github Actions

Experience

3.5+ Years Professional

Public Repos: 12

Open to Work: Yes

Connect

Office Projects

GaaS Games Tracking Service (GGTS)

Designed and deployed a scheduled tracking system for five major cloud gaming platforms, using AWS EventBridge to trigger daily scraping, change detection, and final reporting tasks. Ensured a 99.9% successful execution rate for all scheduled jobs.

Tech Stack:

Python
AWS Lambda
AWS S3
AWS Fargate
Docker
Github
Github Actions

Key Contributions:

  • Developed AWS EventBridge + Lambda workflow for daily scraping, delta comparison, and automated email reports
  • Stored structured data in S3 for historical tracking and automated monitoring, reducing manual checks by 95%
  • Containerized deployments using Docker and AWS Fargate for Python 3.13+ environments
  • Ensured 99.9% successful execution rate for all scheduled jobs

Game Matching Tool (GMT) v3.0

Built a high-performance search and matching system for large-scale game datasets with advanced indexing and monitoring capabilities.

Tech Stack:

Python
FastAPI
Algolia
MySQL
GraphQL
AWS Lambda
AWS S3
AWS Fargate
Docker
Github
Github Actions
New Relic

Key Contributions:

  • Redesigned system in version 3 to improve accuracy, integrating internal metadata API with Algolia search index
  • Automated daily EventBridge jobs for delta updates, new game additions, and cleanup of deleted titles in Algolia
  • Implemented async batch processing in FastAPI to handle 1000+ records/min and maintain <50ms query times
  • Built high-performance search and matching system for large-scale game datasets

Game Ratings Service (GRT)

Created a centralized platform for managing and displaying multi-platform game ratings, replacing manual spreadsheet processes.

Tech Stack:

Python
FastAPI
React
MySQL
GraphQL
AWS Fargate
Docker
Github
Github Actions

Key Contributions:

  • Integrated OpenCritic API for automated critic rating collection with real-time updates
  • Implemented validation rules to maintain 100% data integrity across rating distributions
  • Built a responsive React frontend with light/dark theme support and mobile compatibility
  • Created centralized platform for managing multi-platform game ratings

Data Quest Hub (DQH) Client Delivery System

Automated data collection, processing, and delivery workflows for custom client packages. Built scalable, fault-tolerant systems for large-scale operations.

Tech Stack:

Python
FastAPI
AWS S3
AWS Lambda
AWS Fargate
Docker
GraphQL
Github
Github Actions
Newrelic

Key Contributions:

  • Developed backend modules for data processing and storage using AWS S3 and Dockerized components
  • Built a package generator for logging metadata and delivering structured data to clients
  • Implemented exception handling and logging for system reliability
  • Delivered features on time following Agile Scrum practices
  • Automated data collection, processing, and package generation using Python scripts

Steam Prices Service Backend (Internal Tool)

Developed a backend service to fetch and store Steam SKU price details from internal and external APIs, ensuring seamless data flow into a PostgreSQL database.

Tech Stack:

Python
PostgreSQL
AWS S3
AWS Lambda
AWS Fargate
Docker
GraphQL
Steam API
Github
Github Actions

Key Contributions:

  • Designed and implemented ORM-based database interactions using SQLAlchemy
  • Utilized Pydantic for environment variable management and data validation
  • Integrated Google Webhook for critical notifications and Python logging for detailed event tracking
  • Deployed three modular AWS Lambda functions, containerized with Docker for efficient job scheduling
  • Improved system scalability and performance for high traffic environments

Game Ratings Service (Internal Tool) (Full Stack Role)

Designed and developed a centralized system for managing user and critic ratings for games across different platforms, replacing previous Google Sheets-based system.

Tech Stack:

Python
FastAPI
MySQL
GraphQL
React
Node.js
JavaScript
HTML
CSS
Docker
AWS Fargate
Github
Github Actions
Mixpanel
Newrelic

Key Contributions:

  • Led full stack development from architecture to deployment implementing both backend and frontend components
  • Developed RESTful API endpoints with FastAPI and integrated OpenCritic ratings with automated scraping
  • Built ORM-based database interactions using SQLAlchemy, Alembic for migrations and implemented data validation with Pydantic
  • Created interactive frontend with React components for game rating management and visualization
  • Implemented comprehensive logging system and performance monitoring with NewRelic and Mixpanel

DQH Admin Tool (Internal Tool)

Created a centralized tool for managing client data statistics and operational workflows with role-based access control.

Tech Stack:

Python
Django
DRF
MySQL
Next.js
Docker
GraphQL
HubSpot API
AWS S3
AWS Fargate
Bitbucket
CI/CD

Key Contributions:

  • Designed secure Restful APIs to integrate backend functionalities with the frontend
  • Built user management systems with roles and permissions for secure operations
  • Integrated HubSpot APIs for seamless data imports and real-time updates
  • Implemented role-based access control for different user types
  • Created centralized management for client data and statistics

Game Matchmaking Discord Bot (Sammen) (Consumer Product)

Built a Discord bot to manage matchmaking sessions for gamers, providing real-time game session updates.

Tech Stack:

Python
Django
DRF
MySQL
GraphQL
Discord API
AWS S3
AWS EC2
Nginx
Bitbucket
CI/CD
Mixpanel

Key Contributions:

  • Designed and implemented backend APIs using Django REST Framework
  • Integrated Discord's API to enhance user engagement and interaction
  • Deployed on AWS EC2 with secure configurations and load balancing
  • Created real-time game session updates for users
  • Implemented matchmaking functionality for gamers

Work Assignment Tool (Internal Tool)

Replaced manual workload management systems with an automated solution to improve operational efficiency.

Tech Stack:

Python
Django
MySQL
HTML
CSS
JavaScript
Bitbucket

Key Contributions:

  • Developed dynamic reporting modules for real-time department statistics
  • Designed Restful APIs for efficient frontend-backend communication
  • Created automated workflow management systems
  • Improved operational efficiency through process automation
  • Built user-friendly interfaces for task assignment and tracking

API Gateway with Rate Limiting and Caching (Personal Project)

Developed an API Gateway for secure, scalable, and optimized API requests handling.

Tech Stack:

Python
FastAPI
Nginx
Redis

Key Contributions:

  • Implemented JWT authentication and Redis-powered rate limiting
  • Configured Nginx for reverse proxy and load balancing to enhance API performance
  • Built caching mechanisms for improved response times
  • Ensured secure handling of API requests
  • Optimized API gateway for scalability
Personal Projects

© Portfolio by Gyan Ranjan Ojha