Melik Hajlawi

Developed SARA, a unified web platform for real‐time and historical analysis of IoT sensor data and custom researcher datasets: Real‐Time Monitoring: Built a FastAPI microservice to ingest live sensor streams via Aizu University’s API and deliver updates to an Angular dashboard using Server‐Sent Events. Historical Exploration: Developed a FastAPI microservice that aggregates high‐frequency data (525K points/year) using hierarchical temporal roll‐up and Redis caching for sub‐second query responses. Custom Dataset Management: Enabled researchers to upload/validate CSV/JSON files, set visibility, and visualize alongside sensor feeds. Backend & DevOps: Implemented a Spring Boot Gateway for JWT authentication and request routing, containerized services with Docker, and managed PostgreSQL schemas for users, datasets, and sensor metadata. Frontend & Visualization: Created an Angular UI with drag‐and‐drop chart configuration (Apache ECharts), supporting metric selection, time‐resolution controls, annotations, and data export (CSV/JSON). Technologies: Java (Spring Boot), Python (FastAPI), Angular, Redis, PostgreSQL, Docker, Apache ECharts, Git.

During my internship, I developed a solution to automate the monitoring of ERP databases by extracting and analyzing logs using Python and Pandas. I designed interactive data visualizations in Power BI to present findings, enhancing data accessibility and insight. This experience deepened my skills in data analysis, visualization, and database management.

While at ETAP, I had the opportunity to engage in system administration tasks, contributing to the efficient management and maintenance of systems within the organization.