IIT Projects

1. Design & Development of Custom Management Applications
2. Travel Management Platform
3. Work Hours & Cost Control for European Commission Projects
4. Systems Integrations (School of Engineering, HR, Accounting, and the University’s Central IT Department)
5. Virtualization Platform – Migration from Solaris to VMware ESXi
6. Hosting Service Implementation
7. GitLab Version Repository Implementation
8. Monitoring Implementation with Nagios

1) Design & Development of Custom Management Applications

• Scope: multi-year engagement designing, developing, and administering custom applications for the institute’s day-to-day operations (e.g., expenses, documentation, organizational chart, and website management).
• Roles performed: Full-stack · DevOps · DBA.
• Practices: refactoring of legacy code to improve maintainability and performance; structured backlog and change control with scripted deployments.

2) Travel Management Platform

• Functions: travel requests and approvals, reporting of days abroad for tax agency, and expense settlements for each trip.
• Data handling: daily ETLs from CSV/SFTP/APIs into MySQL, with reconciliation/validation to ensure data consistency across modules.
• Outcome: streamlined submissions and auditability across travel lifecycle.

3) Work Hours & Cost Control for European Commission Projects

• Functions: timesheets and timesheet reporting for EU projects, enabling cost attribution and exportable summaries for compliance workflows.
• Data: scheduled and on-demand reports in CSV/Excel.

4) Systems Integrations

• Targets: School of Engineering, HR, Accounting, and the University’s Central IT Department, plus multimedia services.
• Approach: APIs for synchronous exchange where available; SFTP/CSV interchanges for batched updates; keep endpoints/topologies private by design.
• Result: shared data flows with clear responsibilities and fewer manual handoffs.

5) Virtualization Platform – Migration from Solaris to VMware ESXi

• Scope: migration of services from Solaris to VMware ESXi.
• Result: consolidation and flexibility to provision VPS instances for institute services.
• Note: the section remains high-level by design.

6) Hosting Service Implementation

• Scope: setup and administration of hosting services for institute sites and internal applications (provisioning, backups policies, and operational routines).
• Outcome: consistent environments for web properties and back-office tools.

7) GitLab Version Repository Implementation

• Scope: implementation of GitLab as the institute’s version repository (on a VPS), without disclosing versions or internal topology.
• Practices: Git workflows, access discipline, and scripted operations.

8) Monitoring Implementation with Nagios

• Scope: Nagios installed on a dedicated VPS to monitor the rest of services.
• Coverage: host/service checks and thresholds appropriate for institute systems (kept generic for security).

Technologies Used

• Operating Systems: Windows 7/10, Linux (Debian/Ubuntu), Solaris
• Software: WordPress, NetBeans, Notepad++, Microsoft Excel/Word
• Frontend: Javascript, jQuery, Bootstrap, Handsontable
• Scripting / Server: PHP, Bash, Apache (web server)
• Databases: MySQL
• Automation: Bash scripts

Data & Reporting

• ETLs: multiple daily ETLs per process/module, ingesting from CSV/SFTP/APIs to MySQL, with reconciliation and validation as part of each run.
• Reports: CSV/Excel outputs; some scheduled, others on demand.

Compliance & Security

• Aligned with ISO 27001 and GDPR practices for university environments.