Summary
Overview
Work History
Education
Skills
Academic Projects
Certification
Websites
Project Blogs
Extra - Curricular
Timeline
Generic

Kalyan Mamidi

San Jose

Summary

Computer Science graduate pursuing my Master’s in Data Analytics at San Jose State University, exploring various subjects around data. Has experience in Data Warehousing, SQL development, cloud computing, and data visualization. Passionate about handling data and turning them into insights. Currently seeking internships in Data Engineering, SDE, or Data Analytics to apply skills, solve real-world problems, and contribute to impactful, innovative, and inspiring solutions while growing professionally.

Overview

1
1
Certification

Work History

Junior SQL Developer

ScriptBees
Hyderabad
05.2023 - 06.2023
  • Wrote and optimized 25+ SQL queries, views, and stored procedures, improving reporting performance by 25–30%.
  • Assisted in ETL operations by scheduling SQL scripts to automate data transfers across 2 internal systems, reducing manual effort by 30%.
  • Performed data validation and cleansing on datasets (~500K+ records), improving accuracy for client reporting dashboards.
  • Collaborated with backend developers and QA team to troubleshoot database issues and ensure timely project delivery.
  • Gained exposure to indexing strategies and performance tuning, reducing query response times from seconds to milliseconds in test environments.

Junior Engineer - Cloud and DevOps

Phoenix Global
Online, Hyderabad
04.2023 - 06.2023
  • Completed an intensive training + internship program focused on real-world Cloud and DevOps projects, under mentorship from industry professionals.
  • Built and tested CI/CD pipelines with Jenkins and GitHub Actions, reducing manual deployment time by 30% for sample applications.
  • Applied Infrastructure as Code (IaC) principles using Terraform to provision AWS resources (EC2, S3, IAM), gaining hands-on experience in cloud automation.
  • Containerized 5+ applications using Docker and deployed them into Kubernetes test clusters, practicing rolling updates and blue-green deployments.
  • Gained exposure to monitoring/logging tools (Prometheus, Grafana) to track application performance and ensure system reliability.
  • Collaborated in team-based sprints, following Agile/DevOps practices to deliver project milestones on time.

Education

Master of Science - Data Analytics

San Jose State University
San Jose, CA
12-2026

Skills

Programming Languages: Python SQL Java C# C R Scala MATLAB
Web Technologies: HTML CSS JavaScript TypeScript
Frameworks(Backend): TensorFlow Keras Flask FastAPI PyTorch PySpark Django Spring Boot Nodejs

Databases & Cloud: AWS Redshift AWS S3 Snowflake Google BigQuery Microsoft Azure PostgreSQL MySQL MongoDB MongoDB Atlas Neo4j Elasticsearch Logstash (ELK) Cassandra Hadoop HDFS Databricks

Frameworks(Frontend): Reactjs Angularjs Vuejs

Tools: Docker Kubernetes Terraform Git Jenkins Kafka Tableau Power BI Matillion Knime Selenium Kibana Airflow NiFi Splunk Alteryx Jira LaTeX Confluence
Soft Skills: Communication Teamwork & Collaboration Leadership & Decision Making Problem-Solving Creativity Analytical Thinking Adaptability Attention to Detail Time Management Patience Networking Confidence Presentation

Academic Projects

Leveraging OLAP for Cost Analytics in Healthcare      

Tech: Python, Amazon S3, Redshift, Pandas, Seaborn, Matplotlib

  • Designed and implemented a data warehouse using the MIMIC-IV critical care dataset and government health worker data.
  • Built ETL pipelines to gather and integrate cost-related data for analysis.
  • Applied OLAP techniques to analyze ICU stays, lab testing, and drug utilization trends.
  • Identified high-cost drivers and potential inefficiencies in healthcare resource usage.
  • Developed predictive insights for ICU demand forecasting to support hospital planning.
  • Delivered data-driven strategies to reduce expenses while maintaining quality patient care.

Modern Job Market: Insights from LinkedIn Job Postings       

Tech: Python, Selenium, Seaborn, Tableau, Plotly, SQLite, Power BI

  • Analyzed LinkedIn job postings to identify trends in job roles, skills, industries, locations, and salaries, aimed to provide data-driven insights for job seekers, recruiters, educators, and policymakers.
  • Focused on uncovering demand vs. pay gaps, hiring patterns, and workforce planning opportunities.
  • Scraped LinkedIn job postings using Python, Selenium, and SQLite, also, cleaned and processed data by handling missing values, deduplicating, standardizing formats, and parsing skills/salaries.
  • Applied OLAP techniques and statistical methods to study hiring trends, salary distribution, and demand-supply mismatches.
  • Built dashboards and charts with Seaborn, Plotly, Tableau, and Power BI to communicate insights.

Certification

  • Cloud Computing Basics
  • Build Your First Android App
  • Database Management Essentials
  • Symmetric Cryptography
  • Introduction to Basic Game Development using Scratch
  • Python for Data Science, AI & Development
  • Draw a wireframe in pencil project

Link to all the certificates with the credentials : Kalyan Mamidi’s Certifications

Websites

Project Blogs

NoSQL - MongoDB vs Neo4j

Paper Review: An Extensive Data Processing Pipeline for MIMIC-IV

Extra - Curricular

  • Kalakrithi Cultural Club(Artist, Sponsorship Lead, Vice President)
  • Spartan Mambo(Performer, Member)
  • Kontagious(Non-Profit)

Timeline

Junior SQL Developer

ScriptBees
05.2023 - 06.2023

Junior Engineer - Cloud and DevOps

Phoenix Global
04.2023 - 06.2023

Master of Science - Data Analytics

San Jose State University

Similar Profiles

CREATE PROFILE
Kalyan Mamidi