Rishitha Galicherla.

Available for freelance & contract

I build systems that turn signal into something you can act on.

MCA, Reva University. Most recently I built and shipped two modules into a live commercial product at DYLIT — React, Next.js and TypeScript, integrating against the team's Go services. Before that, an NLP engine that detects sarcasm from speech by reading tone and words against each other, and Power BI reporting on live marketing data at Areksoft. I work from Figma through to the database.

Based in
Bengaluru, India
Focus
Full-stack & UI/UX
Projects shown
5
Response time
Within a day

What I can take on

Four things I have already built, described as work you could hire me for.

Not a skills list. If your problem is one of these, I have done the equivalent before.

Full-stack web applications

Interface, server logic, database, deployment. I have shipped a React front end against a Flask API with separate user and admin views, running live.

React · Flask · Python · REST

Power BI dashboards

A spreadsheet or database turned into a report someone can read and act on — with drillthrough, custom tooltips, and DAX that holds up. Cleaning the source data first is usually most of the job.

Power BI · DAX · SQL · Power Query

Database design & queries

Schema design, relationships, and the queries behind features and reports. From a normalised schema to a join that stops timing out.

MySQL · Oracle · SQL

Internal tools that replace paper

Small systems that retire a manual process. I have built a Java desktop app over MySQL and an approval workflow inside a live university ERP.

Java · Swing · MySQL · ERP

Experience

Work that happened inside a real organisation.

Apr 2026 — Jul 2026

Full Stack Development & UI/UX Design Intern

DYLIT (India) Pvt. Ltd. · Hyderabad · product engineering centre for DYLIT Inc., USA

  • Shipped two modules into a live commercial product — an AI-driven content orchestration platform with real users, so the work met production standards rather than project-demo ones.
  • Built the Auto-Propagate module, which distributes approved content to connected external platforms. Implemented the client side of the OAuth 2.0 authorisation code flow so users could grant publishing permission, and designed the interface around queue-backed propagation — representing a state that is neither "not started" nor "finished".
  • Built the Admin Panel, including a list-heavy user table tuned with useCallback and useMemo to avoid unnecessary re-renders.
  • Started from the problem, not the ticket — researched how content fragmentation actually affects creators and small businesses before designing anything, then worked the flow through Figma before writing code.
  • Typed every API contract in TypeScript, which caught response-shape mismatches at build time instead of as runtime failures in the browser.
  • Worked inside a cross-functional team using feature branching, peer code review, and documented API contracts against Go services backed by MongoDB, Redis, and RabbitMQ. Performance rated excellent.

Aug 2023 — Nov 2023

Data Analyst Trainee

Areksoft Technologies Pvt. Ltd.

  • Mined and analysed social media data in MySQL and Power BI to show which digital marketing activity was actually working, rather than which felt like it was.
  • Built the dashboards that carried those findings to the people making the spend decisions — reports they could read without an analyst sitting next to them.
  • Owned collection and validation of the underlying data, so the numbers held up when they were questioned.
  • Worked in Figma with the UI/UX team on the design of those interfaces, tightening the path between what a user clicks and what they came to find out.

Selected projects

Three you can open and inspect. Two more listed plainly.

The first three come with working files and a walkthrough of what was mine. I would rather you verify three than believe five.

MUSE analysis results — sentiment, sarcasm score, tone, and Tamil translation
Machine learning · Full-stack Code available

MUSE — Multilingual Sentiment & Sarcasm Engine

A system that listens to speech and works out not just whether the speaker is positive or negative, but whether they mean it. Sarcasm is the hard case: the words and the tone disagree, so reading the transcript alone gets it wrong.

It reads both signals against each other — language through mBERT embeddings and a trained classifier, tone through pitch and energy features from Librosa — then fuses them. Around that sits a full pipeline: Whisper transcribes the audio and detects the language, a router translates across seven languages using NLLB-200 or Marian, and RoBERTa handles sentiment.

It runs as a full application with JWT authentication, bcrypt-hashed passwords, per-user analysis history in MongoDB, an admin panel, and PDF export with embedded Noto fonts so Indic scripts render properly rather than as boxes.

PythonmBERTWhisper NLLB-200RoBERTaLibrosa FlaskReactMongoDB JWTbcryptLate fusion
  • Built the feature extraction and late-fusion pipeline joining the text and audio signals.
  • Trained the sarcasm classifier on mBERT embeddings, and evaluated it against a labelled dataset.
  • Wired the translation router so each language pair goes to the right model.
  • Built and deployed the React and Flask application end to end, including auth, history, and the admin panel.
Read the code → Runs the models locally — Whisper and NLLB need a GPU backend
Maven Roasters sales dashboard — KPI cards, revenue trend, hourly trading pattern, and category performance by location
Business intelligence · Data modelling Live interactive report

Maven Roasters — Sales Performance Dashboard

A Power BI report over six months of transaction-level retail sales — 149,000 records across three locations. Built to answer the questions a shop owner actually asks: where revenue is trending, which hours carry the day, which products are doing the work.

The interesting part is not the charts, it is the interaction. Most dashboards answer one question and then need an analyst for the follow-up. This one lets the viewer ask their own: a single slicer switches the trend and hourly charts between four metrics, right-clicking any product opens a detail page that renames itself to whatever was clicked, and hovering shows a miniature report rather than one number.

Underneath it is a star schema with a marked date table, so month-over-month and year-to-date resolve correctly rather than approximately. Fifteen measures, and the whole thing styled through a theme file — nothing in it is a Power BI default.

Power BIDAXPower Query Star schemaTime intelligence Field parametersDrillthrough Custom theme JSON
  • Modelled the data — date dimension built in DAX, marked as the report's date table, auto date/time disabled to keep the model clean.
  • Wrote fifteen measures covering aggregation, time intelligence, ranking, and dynamic text for the self-titling drillthrough page.
  • Designed the report page and wrote the theme JSON — palette, typography, gridlines, visual containers.
  • Built the interaction layer: drillthrough page, custom report-page tooltip, field parameter, conditional data bars, cross-filtering.
EnviroTrack dashboard — live sensor readings, multi-sensor graph, and anomaly predictions
Desktop application · Live data Code available

EnviroTrack — Environmental Monitoring & Alerts

A Java desktop application that reads sensor data as it arrives and shows temperature, humidity, and air quality in a form someone can scan in a second, with alerts when a reading crosses a threshold.

The real problem was legibility under change — values updating constantly need a layout that holds still, and a schema that stays queryable as historical readings pile up.

The multi-sensor chart is drawn from scratch in Graphics2D rather than pulled from a library, and a Python layer runs alongside the Java client for linear-regression forecasting and z-score anomaly detection.

JavaSwingGraphics2D MySQLPythonscikit-learn SciPyReal-time data
  • Designed the schema and indexes for continuously arriving readings.
  • Wrote the charting component by hand — axis scaling, gridlines, per-sensor series, legend.
  • Built the Python forecasting and anomaly-detection layer the Java client calls.
  • Implemented threshold alerting on incoming values.
Read the code → runs locally · setup in README

Also built

Two more, described honestly.

Working systems from my degree. They are listed rather than written up, because I would rather give you three projects you can open and inspect than five you have to take on faith.

Out Pass Digitalisation System

ERP integration · Web development · Database management

Integrated a digital module into the college ERP system to automate the out-pass process, enabling online student requests and HOD approvals — replacing the paper slips entirely and cutting the manual handling around them.

Code not public — the module is deployed inside the university's ERP system and is not mine to release.

Online Hostel Management System

Python · Django · SQLite · rebuilding

Full-stack system with separate admin and student modules, authentication, and full CRUD over rooms, allocations, and requests — two roles sharing one database with different permissions.

Originally built during my BCA. Being rebuilt now, with the code public and a live demo.

Skills

Split honestly, because a client hands you work on day one.

The first list is a promise. The second is a realistic timeline, not a same-day one.

Core — work unsupervised

Hand me a task in these and it gets done without hand-holding.

  • React
  • Next.js
  • TypeScript
  • JavaScript
  • Redux Toolkit
  • Tailwind CSS
  • HTML
  • CSS
  • Python
  • Flask
  • Java
  • C
  • SQL
  • MySQL
  • MongoDB
  • Git
  • Figma
  • Power BI

Working knowledge

Used in coursework and projects. Happy to take on with a sensible timeline.

  • Django
  • AngularJS
  • Oracle
  • R
  • Machine learning
  • Deep learning
  • IoT
  • Big data

Education

First class throughout, if that matters to you.

MCA — Computer Applications

Reva University, Bengaluru
2024 – 2026
CGPA 9.9

BCA — Computer Applications

KL University, Hyderabad
2021 – 2024
CGPA 9.54

Intermediate (BiPC)

Viswasai Education Society, Nellore
2018 – 2020
CGPA 9.6

Secondary School Certificate

Sri Chaitanya Techno School, Kadapa
2017 – 2018
CGPA 9.8

Certifications

Cloud, AI, and fundamentals.

Have something that needs building?

Tell me the problem and roughly when you need it. If it is not something I can do well, I will say so rather than learn on your budget.