<PR_SATYARTHI/>
Open to internships

Pushpam Raj Satyarthi

Data and Backend Developer

Third-year CSE student at GITAM University. I work mostly with Python, SQL, PostgreSQL and FastAPI, and I spent the summer of 2026 as an AIML intern at Motherson Technology Services.

HOST: GITAM University
CLASS: 3rd Year CSE
GPA: 9.17 / 10.0
etl_pipeline_diagram (illustrative)
DB Src API Src AzureBlob TRANSFORM Warehouse
PIPELINE DIAGRAM
Illustrative
This is a generic ETL diagram, not live data. Select a node to see what that stage does.
01 // About the Developer

About me

I'm a 3rd year B.Tech Computer Science student at GITAM University, Visakhapatnam (CGPA: 9.17) with a core focus on backend architecture and data engineering. I like building things that move data around and keep it correct.

Recently, I wrapped up a software engineering internship at Motherson Technology Services, where I built the chat history storage layer for LegalLensa live AI legal research platform.

Outside of coding I listen to the Arctic Monkeys, read One Piece, think about Triumph motorcycles and drink Davidoff Espresso 57.

9.17
CGPA
16
IBM Courses
14+
Bugs Patched
9
Endpoints

Off-Duty Stack

Arctic Monkeys
One Piece
Triumph Bikes
Davidoff 57
pushpam@satya-systems:~
Pushpam Raj Satyarthi, interactive shell
Type 'help' to list available system commands.
guest@pushpam.dev:~$
Quick Queries:
02 // Technical Capabilities

Skills

Technologies I have used, grouped by area.

Data Engineering

Extracting data from several sources, cleaning and normalizing it, and loading it incrementally.

ETL Pipeline Design Incremental Loading Schema Normalization Data Warehousing Fault-Tolerant Architecture
PIPELINE PARADIGM: ELT & ETL STATUS: CERTIFIED

Database Systems

Relational schema design up to 3NF, reading query plans, and choosing indexes.

PostgreSQL MongoDB MySQL SQLite Raw SQL Stored Procedures Query Optimization
FAVORITE ENGINE: POSTGRESQL INDEXING: B-TREE/GIN

Languages

Python C C++ Java SQL TypeScript JavaScript

Libraries & APIs

FastAPI Node.js React Pandas NumPy Mongoose

Cloud & Storage

Azure Blob Storage Azure Cloud Infrastructure

Systems & Developer Tools

Git/GitHub Linux/Unix Shell Valgrind GDB Make VS Code

CS Core Concepts

Data Structures & Algorithms OOP OS Architecture Memory Management Database Normalization
03 // Professional Experience

Experience

One internship so far.

Motherson Technology Services Limited

Software Engineering Intern

AIML Team | Product: LegalLens (Live AI-powered legal platform)
May 2026 – June 2026
Hyderabad, India
▸

Architected a hybrid data persistence layer: paired SQLite for lightweight conversation metadata indexing with Azure Blob Storage for full message payload archival. Independently designed and shipped end-to-end across a FastAPI backend and three React/TypeScript frontend modules.

▸

Engineered per-feature-mode storage isolation across three product modes (Analysis Engine, Research Assistant, Draft Builder). This enabled per-session search, restore, and archive operations with zero cross-module data contamination.

▸

Authored a 316-line FastAPI module (chat_history.py) from scratch. Shipped 9 CRUD endpoints for conversation recovery, archiving, title-based search, and message persistence, coordinating Azure Blob writes with SQLite metadata tracking in a unified read/write flow.

▸

Conducted systematic codebase audit: surfaced 14+ critical bugs including broken feature-type isolation across all three product modules; produced a 27-entry structured bug tracker with root-cause documentation.

SYSTEM METADATA Active
Language: Python / TypeScript
Framework: FastAPI + React
Persistence 1: SQLite (Metadata)
Persistence 2: Azure Blob (Payload)
Module size: 316 lines
Endpoints: 9 CRUD routes
// SQLite coordinates metadata tracking with Azure Blob payload writes in a unified transactional flow.
04 // Projects

Things I have built

Four projects, with a short list of other repositories below. Each card has a details panel and links to the code.

ETL pipeline

Global Banking ETL

Python pipeline that scrapes market capitalization data for the largest banks, converts currencies with vectorized Pandas and NumPy, and loads the result into SQLite and CSV.

SQLite + CSV
Outputs
NumPy
Vectorized transform
PythonPandasNumPyBeautifulSoupSQLite
Full-stack web app

KAPS MedTech

University clinic app where students book doctors, and doctors record diagnoses and prescriptions. Express API on PostgreSQL with JWT auth, bcrypt password hashing and rate limiting.

29
Integration checks
Vercel + Neon
Deployed on
Node.jsExpressPostgreSQLJWTbcrypt
Full-stack web app

TripSync

Travel companion for road trips: route planning, nearby stops, a Gemini-powered chat assistant and trip logging. The repo README says it is still in development.

React + Express
Client and API
MongoDB
Database
TypeScriptReactExpressMongoDBGemini API
Systems programming

Autocomplete engine in C

Prefix search in C using a Trie, with a min-heap to rank the top suggestions. Checked with Valgrind. This one has no public repository.

O(k)
Prefix lookup
Valgrind
Leak checked
CMakeValgrindGDB

More on GitHub

05 // Academic Grounding

Education

GITAM University

B.Tech in Computer Science and Engineering
Visakhapatnam, India
2024 – 2028
CGPA: 9.17
Relevant Coursework:
Database Management Systems Design & Analysis of Algorithms Data Structures Operating Systems Data Warehousing and Mining Computer Networks Machine Learning Techniques Probability & Statistics for Engineering
06 // Professional Training

Certifications

IBM Data Engineering

Professional Certificate — Coursera

A comprehensive 16-course curriculum spanning data engineering architecture, pipeline design, and distributed processing.

Core Curriculum Competencies:
  • :: ETL pipelines with Airflow & Kafka
  • :: SQL & relational databases
  • :: Python for data science
  • :: Linux shell scripting
  • :: Data warehousing
  • :: NoSQL databases
  • :: Big Data with Spark & Hadoop
  • :: BI dashboards (Cognos & Looker)
  • :: Machine learning with Apache Spark
  • :: Generative AI for data engineering
07 // Hackathons

Hackathon Milestones

Two 24-hour hackathon builds.

Smart India Hackathon (SIH) 2025 Qualifier

Internal Round Qualifier

Led development of TripSync, an AI-powered travel platform, delivering a functional prototype from zero within a 24-hour constraint.

Role: Lead Systems Developer | Scope: Geospatial & AI Integration
Gitathon University Hackathon Completed

Full Backend Deployment in 24 Hours

Deployed the full KAPS MedTech healthcare backend within 24 hours, including PostgreSQL schema design, API endpoints, and secure authentication: under competitive conditions.

Role: Solo Backend Developer | Scope: PostgreSQL Schema, Auth, Express APIs
08 // Establish Connection

Let's Build Something Real

I am looking for data engineering and backend internships. The easiest way to reach me is email.

// Email
$ mail prsatyarthi2404@gmail.com
© 2026 Pushpam Raj Satyarthi. Built with HTML, Tailwind & Vanilla JS.