Hi, I'm 👋

Ramsi Favas KP

Software developer & Data Analyst

A passionate Python Developer from India, specializing in data analytics and Visualization

Software developer & Data Analyst

MSc Computer Science graduate with a passion for Python programming and data analysis. Proficient in data management and visualization tools like Power BI and Excel.

Gained hands-on experience in data engineering and machine learning during my internship. Skilled in database management with PostgreSQL and version control using Git. Focused on leveraging analytical and technical skills to extract data-driven insights.

Aiming to contribute to impactful decision-making in a dynamic team environment.

Resume

Skills & Expertise

Languages

Python

HTML

CSS

JavaScript

SQL

Java

Frameworks

Django

Bootstrap

Tools

- VS Code

- Power BI

- Git

- Tableau

- MS Office

Databases

SQL Lite

MySQL

SQL

Projects

Current project

Health Sync

Built Using Python (Django), HTML, CSS, JavaScript.
Developed a web app for a city hospital, enabling patients to book appointments with doctors by selecting from a categorized list by department. Users can schedule appointments by providing their name, email, and preferred date. Integrated with a database for managing doctor availability and appointments, offering a user-friendly interface to simplify healthcare access.

Past Projects

Companion

Built Using HTML, CSS, JS and Python(Machine Learning).
A comprehensive Web Application for effective sleep health management using Machine Learning and Integrate with Google AI Studio for real time Chatbot. It helps manage sleep duration with a smart alarm, and provides educational resources.

Movie Verse

Built Using Python(Django), HTML, CSS Java Script.
Developed a dynamic web application enabling users to create personalized profiles, share movie posters, upload YouTube trailer links, and contribute reviews and ratings for their favorite movies. The platform fosters an engaging community for movie enthusiasts, providing an intuitive interface and seamless functionality.

Moto Care App

Built Using Android Studio(Java, XML).
Road-Side vehicle assistance app. In which android users can get vehicle related mechanical information they need anytime and anywhere.The interesting part of application, travelers can use this application to know about their problems. By which they can solve the problem them self if it is handy, otherwise they can approach experts and get immediate possible assistance.

Calculator Project

Built Using Python (PyQt5).A simple yet effective GUI-based application for performing basic arithmetic operations. This project demonstrates the fundamentals of GUI development and interaction using PyQt5.

Revenue Insights Analysis in Hospitality Domain(Power BI)

Analyzed key revenue metrics like RevPAR, ADR, Occupancy %, and Realization % across various properties, creating interactive Power BI dashboards with dynamic filters by city, room class, and time period. Visualized trends to identify performance shifts and provided actionable insights for revenue optimization. Compared platform performance to improve decision-making.

Olympics Dashboard Analysis (Power BI)

Analyzed Olympic data (1896–2016) to track medal counts, athlete performance, and participation trends. Developed interactive dashboards with dynamic filters for sport, year, gender, and season, enabling in-depth analysis. Visualized key insights, including top-performing countries, sports, and athletes, along with geographical trends. Leveraged Power BI for data modeling, transformation, and storytelling to uncover actionable insights.

Call Center Performance Dashboard (Power BI)

Created a comprehensive Power BI dashboard using a dataset from Kaggle to analyze and visualize key metrics of call center performance. The dashboard provides actionable insights to enhance service quality and customer satisfaction.

Resume

Educational Experience

Present

Looking for new opportunities.

2024 July - Present (6-Month)

Data Engineering Intern

Hayago Smart Solution, Hyderabad

Python(Libraries)
Power BI & Tableau
Data Analytics
Data Visualization
Data Management
Data Modeling
SQL
MS Excel

2022 Oct - 2024 May

Master's Degree in Computer Science

Pondicherry Central University

Web Development
UI/UX Design
Software Engineering
Database Management
Project Management
Machine Learning
Artificial Intelligence
Statistics

2019 Jun - 2022 Mar

Bachelor's Degree in Computer Science

University of Calicut

Computer Networks
UI/UX Design
Python & Java Programming
Database management system and RDMS
Operating Systems
Android programming
Principles Software Engineering
Probability Distributions & Sampling Theory

Languages

Malayalam Native

English Fluent

Hindi Fluent

Certificates

Python Django

Avodha Edutech - September 2023

Download Certificate

Data Analytics with Python

NPTEL(Founded by the MoE, Govt.of India) - April 2023

Download Certificate

PostgrSQL Certificate

Simplilearn - September 2024

Download Certificate

Companion

View Project

Companion combines cutting-edge technology and personalized interventions to help users improve their sleep health. By analyzing sleep data, offering task recommendations, and providing educational resources, it empowers users to make informed decisions about their sleep habits./p>

Key Features:

Sleep Data Analysis: Machine learning algorithms analyze user-provided sleep data to detect patterns and identify potential sleep disorders like Sleep Apnea and Insomnia.
Personalized Interventions: Tailored recommendations and task suggestions to improve sleep quality based on individual sleep patterns.
AI Chatbot: Powered by Google Gemini AI, the chatbot offers real-time support, guidance, and educational insights about sleep habits and disorders.
Alarm Clock Feature: A smart alarm function helps users maintain consistent sleep schedules and manage sleep duration.
Educational Resources: Access to articles, videos, and expert insights on sleep health to promote informed decision-making.

Technical Details:

Frontend: Built using HTML, CSS, and JavaScript to provide an intuitive user interface.
Backend: Developed in Python, incorporating machine learning algorithms for sleep data analysis.
AI Integration: Google Gemini AI powers the chatbot for real-time interaction.
Database: Utilizes structured data storage for user profiles and sleep data.

Challenges Overcome:

Accurate Analysis: Implementing machine learning models to handle diverse sleep data while ensuring accuracy in predicting sleep disorders.

Real-time Interaction: Seamlessly integrating Google Gemini AI to enable instant and meaningful conversations without compromising performance.

User Engagement: Designing engaging features that balance functionality with simplicity for diverse user demographics.

Future Improvements:

Enhanced Prediction Models: Expanding datasets and incorporating advanced machine learning techniques for improved sleep disorder predictions.
Wearable Device Integration: Collecting real-time data through fitness trackers and smartwatches for comprehensive sleep pattern insights.
Telemedicine Features: Facilitating virtual consultations with healthcare professionals for expert sleep health advice.

Revenue Insights Analysis in the Hospitality Domain

View Project

This project focused on visualizing and analyzing critical performance indicators like RevPAR, ADR, Occupancy %, and Realization % across various properties. It empowered stakeholders with actionable insights to enhance decision-making and revenue strategies.

Key Features:

Interactive Dashboards: Created visually engaging Power BI dashboards with dynamic filters for city, room class, and time period.
Key Metrics Analysis: Analyzed revenue-focused metrics such as:

RevPAR (Revenue per Available Room): Insights into revenue generated per room.
ADR (Average Daily Rate): Assessment of average revenue earned per occupied room.
Occupancy %: Visualization of occupancy trends across properties.

Trend Visualization: Highlighted performance shifts over time for better forecasting.
Platform Comparison: Compared performances across different booking platforms to identify the most profitable channels.

Technical Details:

Tool: Power BI for data transformation, visualization, and dashboard creation.
Data Integration: Processed raw data from multiple sources to create a unified dataset
Dynamic Filtering: Implemented slicers and filters to allow granular analysis by property, city, and room class.
Data Modeling: Established relationships between datasets for accurate calculations and trend analysis.

Challenges Overcome:

Data Preparation: Cleaned and transformed disparate datasets to ensure consistency and accuracy in analysis.

Dynamic Filtering: Designed user-friendly interactive elements to cater to various analytical needs.

Skills Gained:

Expertise in Power BI for creating advanced visualizations and interactive dashboards.

Strong analytical skills for revenue metric analysis and trend identification.

Proficiency in data transformation and modeling for effective decision-making.

Experience in creating user-focused solutions for business intelligence.

Moto Care App

View Project

Moto Care simplifies the process of finding mechanics and resolving vehicle issues on the go. The app offers step-by-step instructions for minor repairs and connects users to nearby mechanics for professional help, ensuring a hassle-free travel experience.

Key Features:

Self-Help Guidance: Provides users with instructions to resolve minor vehicle issues independently when feasible.
Mechanic Locator: Allows travelers to search for mechanics in nearby areas using a built-in locator tool.
Admin Management: Admins can manage and approve mechanic profiles to maintain a verified database of professionals.
Mechanic Profiles: Mechanics can register their services and offer assistance directly through the platform.

Technical Details:

Frontend: Built using Android Studio with Java and XML for a responsive and interactive user interface.
Backend: Integrated PHP scripts and MySQL database for managing mechanic profiles, user details, and appointments.
Server: Utilizes XAMPP Webserver for hosting backend services.
Database: MySQL for storing and retrieving user and mechanic information.
Platform: Supports Android smartphones.

Challenges Overcome:

Real-Time Mechanic Discovery: Implemented an efficient location-based search system to ensure users can find mechanics even in remote areas.

Data Management: Ensured smooth data flow between the app, database, and server for real-time updates and accurate information retrieval.

User Accessibility: Designed a straightforward interface for both users and mechanics, simplifying the process for non-technical individuals.

Future Improvements:

Enhanced Locator Accuracy: Integrate GPS-based real-time tracking to refine the precision of mechanic searches.
Multi-Language Support: Add support for regional languages to cater to a broader user base.
Payment Integration: Incorporate online payment options for service bookings.

Call Center Performance Analysis

View Project

This project focused on visualizing and analyzing key performance metrics such as Answered vs. Resolved Calls, Average Speed of Answer, and Customer Satisfaction. It empowered stakeholders to make data-driven decisions for optimizing call center performance.

Key Features:

Interactive Dashboards: Designed visually engaging Power BI dashboards with dynamic filters for agents, call types, and time periods.
Call Metrics Analysis:

Answered vs. Resolved Calls: Visualized how effectively customer queries are addressed.
Average Speed of Answer: Tracked response times, currently at 67.52 seconds, ensuring timely service.
Number of Calls Per Month: Analyzed monthly call trends for resource planning and workload management.

Agent Performance: Provided detailed statistics for each agent, including the number of resolved calls and average satisfaction rates.
Customer Satisfaction: Highlighted an average satisfaction score of 3.40, helping identify areas for improvement.

Technical Details:

Tool: Power BI for data transformation, visualization, and dashboard creation.
Data Integration: Processed raw call center data from multiple sources to create a cohesive dataset.
Dynamic Filtering: Implemented slicers for granular analysis by agent, month, and call type.
Data Modeling: Built relationships between datasets for accurate KPI calculations and trend analysis.

Challenges Overcome:

Data Preparation: Cleaned and transformed large datasets to ensure accuracy and consistency in analysis.

Interactive Elements: Designed user-friendly dashboards with intuitive filtering options for easy exploration of insights.

Skills Gained:

Expertise in Power BI for creating advanced visualizations and interactive dashboards.

Strong analytical skills in evaluating call center KPIs and performance trends.

Proficiency in data modeling and transformation for effective business intelligence solutions.

Experience in creating data-driven strategies to improve customer service operations.

Ramsi Favas KP

Software developer & Data Analyst

A passionate Python Developer from India, specializing in data analytics and Visualization

Software developer & Data Analyst

Skills & Expertise

Languages

Frameworks

Tools

Databases

Projects

Current project

Health Sync

Past Projects

Companion

Movie Verse

Moto Care App

Calculator Project

Revenue Insights Analysis in Hospitality Domain(Power BI)

Olympics Dashboard Analysis (Power BI)

Call Center Performance Dashboard (Power BI)

Resume

Educational Experience

Looking for new opportunities.

Data Engineering Intern

Hayago Smart Solution, Hyderabad

Master's Degree in Computer Science

Pondicherry Central University

Bachelor's Degree in Computer Science

University of Calicut

Languages

Certificates

Python Django

Data Analytics with Python

PostgrSQL Certificate

Career Essentials in Data Analysis

Introduction to Artificial Intelligence

Ramsi Favas KP

Software developer & Data Analyst

A passionate Python Developer from India, specializing in data analytics and Visualization

Software developer & Data Analyst

Skills & Expertise

Languages

Frameworks

Tools

Databases

Projects

Current project

Health Sync

Past Projects

Companion

Movie Verse

Moto Care App

Calculator Project

Revenue Insights Analysis in Hospitality Domain(Power BI)

Olympics Dashboard Analysis (Power BI)

Call Center Performance Dashboard (Power BI)

Resume

Educational Experience

Looking for new opportunities.

Data Engineering Intern

Hayago Smart Solution, Hyderabad

Master's Degree in Computer Science

Pondicherry Central University

Bachelor's Degree in Computer Science

University of Calicut

Languages

Certificates

Python Django

Data Analytics with Python

PostgrSQL Certificate

Career Essentials in Data Analysis

Introduction to Artificial Intelligence

Health Sync

Key Features:

Technical Details:

Challenges Overcome:

Future Improvements:

Movie Verse

Key Features:

Technical Details:

Challenges Overcome:

Future Improvements:

Companion

Key Features:

Technical Details:

Challenges Overcome:

Future Improvements:

Revenue Insights Analysis in the Hospitality Domain

Key Features:

Technical Details:

Challenges Overcome:

Skills Gained:

Moto Care App

Key Features:

Technical Details:

Challenges Overcome:

Future Improvements:

Calculator Project

Key Features:

Technical Details:

Challenges Overcome:

Future Improvements:

Olympics Dashboard Analysis(Power BI)

Key Features:

Technical Details:

Skills Gained:

Call Center Performance Analysis

Key Features:

Technical Details:

Challenges Overcome:

Skills Gained:

Olympics Dashboard Analysis
(Power BI)