Sathvika Pothana

Email: [email protected]
Phone: +91-6304483269
LinkedIn: https://linkedin.com/in/sathvika-pothana-139339293
GitHub: https://github.com/Sathvika1209

Backend-oriented IT undergraduate with strong interests in machine learning, data-driven analytics, and scalable software systems. Experienced in building RESTful APIs, optimizing relational databases, and developing data-driven dashboards. Strong foundation in data structures and algorithms with exposure to application security principles, focused on designing efficient and reliable data-centric solutions.

---

Skills

Languages: Python, Java, C, SQL, Julia

Backend & Web: Django, Django REST Framework, RESTful APIs, API Design, HTML

Databases: PostgreSQL, MySQL, SQLite
Normalization, Indexing, Query Optimization

Machine Learning & Analytics: Machine Learning, Data Preprocessing
Pandas, NumPy, Matplotlib, Streamlit

Data Visualization: Excel, Power BI, Tableau

Tools: Git (Version Control), Swagger, Postman

Core Competencies

• Data Structures & Algorithms
• Problem Solving
• Object-Oriented Programming
• Debugging
• API Development
• Database Design
• Concurrency Handling
• Technical Documentation
• Security Fundamentals

Platforms: Cloud Platforms (Foundational Exposure)

---

Experience

Full Stack Intern

AptPath – Hyderabad, India
Jul 2025 – Aug 2025

• Built 15+ REST APIs using Django REST Framework and PostgreSQL supporting authentication, catalog, and order workflows.
• Designed APIs handling 100+ active records with optimized queries and indexed schemas, reducing response time by ~25%.
• Identified and resolved database performance bottlenecks through query restructuring and indexing.
• Contributed to real-time tracking features using WebSockets, addressing asynchronous processing and concurrency challenges.

Cybersecurity Virtual Experience Participant

Goldman Sachs (Forage)
Aug 2024

• Completed practical modules in vulnerability assessment and incident response workflows.
• Produced structured security documentation based on simulated enterprise scenarios.

---

Projects

Flood Monitoring & Prediction System — Backend Developer

Tech Stack: Python, Django REST Framework, PostgreSQL
2025 (Ongoing)

• Developed REST APIs for structured rainfall and water-level time-series datasets.
• Designed relational models with validation and secure serialization layers.
• Built dashboards for flood risk visualization.
• Extending system with IoT ingestion and predictive APIs for the NASA Space Apps Challenge.

E-commerce Sales Analytics Dashboard — Developer

Tech Stack: Python, Streamlit, Pandas, SQL
2025

• Built dashboards to compute KPIs, revenue trends, and sales distributions.
• Applied data cleaning, feature engineering, and SQL validation.

Hotel Booking Database System — Database Designer

Tech Stack: MySQL, SQL
2024

• Designed normalized relational schemas for hotel reservation management.
• Improved query performance by 25% through indexing and schema optimization.

3D Modeling Automation — Developer

Tech Stack: Python, Blender
2024

• Automated generation of parametric 3D models using Python scripting in Blender.

---

Education

B.Sc. Information Technology

BVRIT HYDERABAD College of Engineering for Women
2023 – 2027
CGPA: 8.3 / 10

Intermediate (MPC)

Sri Chaitanya Jr Kalasala, Hyderabad
2021 – 2023

High School (CBSE)

Maharishi Vidya Mandir, Hyderabad
2021

---

Certifications & Achievements

• Presented research paper at the Pure Earth Environment Conference (2025)
• Great AppSec Hackathon – Qualified CTF Round (CCoE-DSCI, 2024)
• GenAI Hackathon – Participant (FutureSkills Prime & NASSCOM, 2025)
• AptPath Internship – Certificate of Completion (2025)
• Python Programming – HCLTech Career Shaper (2025)

---

Additional Information

Languages: English (Proficient), Telugu (Native), Hindi (Basic)

Leadership: Member – CSI Student Club

Research: Submitted paper to an International Conference