Skip to content
View fran9300's full-sized avatar

Block or report fran9300

Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
fran9300/README.md

Profile Views

Francisco Kin | Bioinformatics Student | Data Analytics, Data Science & Software Development

Contents

๐Ÿ‘‹ Welcome

I'm Francisco, a Bioinformatics student passionate about building software and data-driven solutions for scientific and real-world problems.

My interests span backend development, data analytics, and computational biology, with a growing focus on healthcare and life sciences.

About Me

I am a Bioinformatics student with a multidisciplinary background in life sciences, clinical research, data analytics, data science, and software development.

My experience in healthcare and regulated environments has strengthened my analytical thinking, attention to detail, and ability to work with complex and data-driven processes. Alongside my professional experience, I develop projects that combine data analysis, computational biology, and software engineering.

I enjoy using technology to solve real-world problems, whether by analyzing and visualizing data with Python and SQL, developing software and APIs, or applying computational methods to biological and scientific problems. I am particularly interested in opportunities at the intersection of data, technology, healthcare, and life sciences.

Technical Skills

Data & Analytics

Python | SQL | Power BI | Tableau | Excel | DAX | Pandas | NumPy | Matplotlib

Bioinformatics

Biopython | Sequence Analysis | AIUPred

Backend & Databases

Java | Spring Boot | REST APIs | PostgreSQL | Docker

Tools

Git | Maven | Jupyter

Certifications

  • Google Data Analytics Professional Certificate (2026)
  • Oracle Next Education (ONE) Program (2023)

Current Focus

  • Building REST APIs with Spring Boot
  • Improving software architecture and backend design
  • Deepening SQL and database optimization skills
  • Applying Python to bioinformatics and data analytics

Currently Learning

  • Spring Security
  • Backend Testing
  • Flyway
  • Docker
  • Database Optimization

Featured Projects

A selection of projects showcasing my experience in backend development, data analytics, and bioinformatics.


๐Ÿงช TrialScope | Clinical Trials Analytics Platform

Python PostgreSQL SQL Power BI Scikit-learn

End-to-end clinical trials analytics and data science project built using data from ClinicalTrials.gov.

The project transforms clinical trial data from its original hierarchical API structure into a relational PostgreSQL database and uses it for exploratory analysis, visualization, statistical analysis, machine learning, and NLP.

Key Features

  • Explored and validated ClinicalTrials.gov API data and its structure.
  • Designed a relational data model for clinical trial information.
  • Built a PostgreSQL database schema with normalized entities and relationships.
  • Developed data ingestion and transformation workflows.
  • Performed SQL-based analytical queries and exploratory data analysis.
  • Planned Power BI dashboards to analyze clinical research trends.
  • Applied statistical analysis, machine learning, and NLP techniques to clinical trial data.

Technologies: Python, Pandas, PostgreSQL, SQL, Power BI, Scikit-learn, NLP, Git

Repository: GitHub


๐Ÿงฌ Protein Evolution Explorer | Full-Stack Bioinformatics Platform

React Spring Boot Python PostgreSQL Docker

Full-stack bioinformatics platform for protein sequence analysis, combining computational biology workflows with modern web technologies.

The project integrates a React frontend, Spring Boot backend, and Python-based analysis service to process FASTA sequences and store biological analysis results.

Key Achievements

  • Built a complete full-stack architecture connecting frontend, backend, and bioinformatics services.
  • Developed REST APIs using Spring Boot for protein analysis management.
  • Implemented FASTA sequence processing and physicochemical protein calculations using Python and FastAPI.
  • Designed PostgreSQL persistence using JPA/Hibernate.
  • Created a React + TypeScript interface for uploading sequences and exploring analysis results.
  • Applied layered architecture principles across backend components.
  • Containerized development environment using Docker.

Technologies: React, TypeScript, Tailwind CSS, Java, Spring Boot, Spring Data JPA, Hibernate, PostgreSQL, Python, FastAPI, Biopython, Docker

Repositories:


๐Ÿบ Brewery Management API

Java Spring Boot PostgreSQL Docker Maven

RESTful API built with Spring Boot for managing brewery recipes and ingredients.

Key Achievements

  • Designed a RESTful API following a layered architecture.
  • Modeled many-to-many relationships using JPA/Hibernate.
  • Implemented DTO-based request and response handling.
  • Containerized the application with Docker and PostgreSQL.
  • Introduced Flyway migrations for database version control.
  • Built centralized exception handling for consistent API responses.

Technologies: Java, Spring Boot, Spring Data JPA, Hibernate, PostgreSQL Database, Docker, Docker Compose, Flyway, Maven, Lombok

Repository: GitHub


๐Ÿ“‰ Telco Customer Churn Analysis & Dashboard

Python Pandas Power BI

End-to-end analytics project focused on customer retention and revenue-risk analysis.

Key Achievements

  • Processed and cleaned raw customer data using Python.
  • Built customer tenure cohorts to identify churn patterns.
  • Developed an interactive Power BI dashboard.
  • Estimated more than $4M in potential revenue at risk based on churn analysis.
  • Generated actionable recommendations to support retention strategies.

Technologies: Python, Pandas, NumPy, Power BI, DAX

Repository: GitHub


๐Ÿงฌ E1A Protein Analysis & Disorder Prediction

Python Biopython AIUPred Jupyter

End-to-end bioinformatics workflow for protein sequence analysis and disorder prediction.

Key Achievements

  • Processed and analyzed multiple sequence alignments (MSA).
  • Computed sequence identity and amino acid frequency statistics.
  • Estimated hydrodynamic radius and charge-related properties.
  • Integrated AIUPred-based intrinsic disorder predictions into protein sequence analysis workflows.
  • Produced reproducible analyses and visualizations in Python.

Technologies: Python, BioPython, LocalCIDER, AIUPred, Matplotlib

Repository: GitHub


๐ŸŽฌ Cinema Management System

Python OOP Data Structures

Academic project focused on developing a cinema ticket reservation system, applying object-oriented programming concepts and software design principles.

Key Achievements

  • Designed a complete reservation workflow for movies, schedules, rooms, and seats.
  • Implemented user registration and validation logic.
  • Developed business rules for seat availability, age restrictions, and ticket purchasing.
  • Structured the application using modular components to improve maintainability.
  • Applied object-oriented programming concepts for system modeling and management.

Technologies: Python, Object-Oriented Programming, Data Structures

Repository: GitHub


Other Projects

๐Ÿงฎ Java Calculator MVC

Java Swing MVC

Desktop calculator application developed in Java implementing the Model-View-Controller (MVC) architectural pattern.

Key Achievements

  • Separated application logic, user interface, and event handling using MVC principles.
  • Implemented arithmetic operations and input validation.
  • Developed an interactive graphical interface using Java Swing.
  • Applied clean code practices and object-oriented programming concepts.

Technologies: Java, Java Swing, MVC Pattern

Repository: GitHub


Professional Background

My professional experience spans clinical research, project coordination, logistics, and technical support. Working in regulated healthcare environments has strengthened my attention to detail, process compliance, and analytical problem-solving.

These experiences complement my technical background and influence how I approach software development and data analysis projects.


Contact


Thanks for visiting my profile!

Feel free to explore my projects or connect with me on LinkedIn if you'd like to discuss backend development, data analytics, bioinformatics, or opportunities in science and healthcare.

Pinned Loading

  1. brewery-management-api brewery-management-api Public

    REST API for brewery recipe and ingredient management.

    Java 1

  2. bioinformatics-e1a-analysis bioinformatics-e1a-analysis Public

    Bioinformatics analysis of adenovirus E1A proteins using Python, Biopython, LocalCIDER and AIUPred.

    Jupyter Notebook 1

  3. Telco-Customer-Churn-Analysis Telco-Customer-Churn-Analysis Public

    End-to-End Data Analysis project focusing on Customer Retention using Python and Power BI.

    Python 1

  4. cinema-management-system cinema-management-system Public

    Console-based cinema reservation system developed in Python as part of a university project.

    Python 1

  5. java-calculator-mvc java-calculator-mvc Public

    Java Swing calculator application implementing MVC architecture.

    Java

  6. protein-evolution-explorer protein-evolution-explorer Public