Emir Sarialtin

I am a third-year Software Engineering student at Yasar University. I have experience with programming languages such as C, C++, Java, and SQL. I have actively participated in several group projects so far and consider myself a team player with a collaborative and solution-oriented mindset.

I aim to continuously improve myself in the field of software development and work on both academic and personal projects to enhance my coding skills. I am eager to learn, pay great attention to detail, and always strive to complete my tasks in the best possible way. I make it a priority to deliver high performance and take full responsibility in every task I undertake.

Date: March 2025 – June 2025
Technologies: Java, JDBC, MySQL, SQL Triggers & Procedures, Database Views, UML (Visual Paradigm)
Description:
Designed and implemented a database-backed system for managing multi-floor office buildings, enabling office rental operations, tenant management, and meeting room reservations.

My Contributions:

• Created the ER diagram and relational schema based on system requirements.
• Developed the backend using Java and JDBC to connect and interact with the MySQL database.
• Implemented stored procedures, functions, and triggers to enforce business logic, such as tier-based office rental validation and conflict-free meeting scheduling.
• Built SQL views for reporting office locations, lease details, and manager assignments.
• Implemented procedures for assigning, updating, and removing office managers via Java integration.

Date: April 2025 – June 2025
Technologies: Selenium WebDriver (Java & Python), JMeter, XPath, JUnit 5, TestNG
Description:
Conducted a comprehensive quality assurance and testing project for the macfit.com website, focusing on critical user interactions, form validation, fitness calculator functionality, and system stability under load. Black-box techniques and UI automation frameworks were used to ensure a robust user experience.

My Contributions:

• Designed and implemented automated functional test cases for modules including BMI calculator, body fat calculator, login, registration, homepage navigation, and feedback forms.
• Utilized Selenium WebDriver with both Java and Python to execute over 100+ UI test scenarios.
• Applied Boundary Value Analysis, Equivalence Partitioning, Decision Table Testing, and Use-Case Analysis to generate systematic test coverage.
• Developed and executed a load test for the Ideal Weight Calculator using Apache JMeter, simulating concurrent users and measuring system response times.
• Handled complex dynamic UI behaviors (reloads, modals, token-protected forms) using JavaScriptExecutor, WebDriverWait, and scrollIntoView techniques.
• Logged and documented critical defects, such as invalid phone number acceptance and incorrect BMI calculation, with supporting evidence.

Deliverables:

• 100+ automated test cases (Java & Python)
• Selenium scripts for all major user flows
• Load test scenario (.jmx file) and metrics report
• Finalized test completion report with analysis

Date: March 2025 – June 2025
Technologies: Java, MySQL, JDBC, IntelliJ IDEA, SQL, UML (Visual Paradigm)

Description:
Developed a desktop-based library management system with user and admin roles. The application allows adding, editing, deleting, and displaying books and authors, along with personalized features such as favorites, wishlists, and read status. Designed with a layered architecture and modeled using standard software engineering techniques.

My Contributions:

• Designed and implemented the entire application in Java, using JDBC to connect with a MySQL database.
• Built a role-based GUI system for Admin (full access) and User (limited features) with login and navigation panels.
• Developed core CRUD operations for books and authors, including cover image handling and release dates.
• Implemented advanced user features such as wishlist, favorites, unread books, and rating/commenting system.
• Designed and documented system models including Use Case Diagrams, Class Diagram, Sequence Diagrams, DFDs using Visual Paradigm.
• Wrote a complete SRS (Software Requirements Specification) document based on IEEE 830-1998 standards.

Deliverables:

• Java source code (complete GUI + DB connection)
• MySQL database script with sample data (MyLibraryDB.sql)
• Diagrams (UML, DFD), GUI screenshots
• Final SRS Report
• Demo video