Helpdesk Access Control Migration

Oct 2021 - Apr 2022

Role: Fullstack Developer Intern

Project Link Access to this project is restricted because it runs in an internal environment.
Helpdesk Access Control Migration thumbnail
Tech Stack

Overview

This project was an internal helpdesk modernization initiative at Alfamart. In this phase, the work focused on rebuilding the Security Level or Hak Level module from the legacy Oracle Form environment into a web-based system using Flask, while preserving the original business behavior and improving maintainability for future development.

In Collaboration With: IT Back Office Development Team

Responsibilities

  • System Analysis
  • Flowchart Design
  • Front-end Development
  • Back-end Development
  • Controller and DAO Development
  • SQL Query Development

Outcome

This project phase demonstrated how a legacy enterprise helpdesk module could be translated into a web-based workflow without losing its core operational logic. The result was a more maintainable and collaborative development structure, supported by cleaner interface planning, Flask-based back-end logic, and a clearer separation between view, controller, DAO, and query handling.

Detailed Breakdown

The section above is optimized for fast recruiter review. If you want the full implementation context, open the details below.

The existing internal helpdesk application still relied on Oracle Form, which made the system less flexible for interface improvements, collaborative development, and long-term modernization. The module needed to be migrated to the web so internal users could work with a more structured, user-friendly, and maintainable system without changing the core operational flow.

The solution was to rebuild the module as a Flask-based web application while preserving the operational rules that internal users already relied on. My contribution focused on helping translate the legacy module into a more maintainable structure through flow design, interface rebuilding, and system-side implementation support.

Primary Flow

01

The existing Oracle Form module is reviewed to understand its fields, access structure, validations, and related database tables.

02

A flowchart is created first so the usage flow and user interaction can be defined clearly before development starts.

03

The web UI is built with Bootstrap and adapted from Oracle Form into a cleaner, more user-friendly layout for internal use.

The Security Level or Hak Level module was used to manage user access information within the company. Users could view records directly and perform create and update actions through the web interface. Compared to the legacy version, the web implementation kept the same functional purpose while improving the layout and making the table structure more aligned with user needs.

Implementation Flow

01

Flask back-end logic is implemented to support reading records, creating new access entries, and updating existing records.

02

Controllers, DAO structure, and SQL queries are used to connect the interface with PostgreSQL data handling in a more maintainable way.

03

The module is refined with supporting features such as search, code cleanup, and iterative bug fixing during development.

Implementation Details

  • Legacy module migration from Oracle Form to Flask web application
  • Flowchart-based UI planning before implementation
  • User interface development with Bootstrap
  • Back-end service development using Python Flask
  • Database and query handling with PostgreSQL
  • Search feature, bug fixing, and code refinement during iteration

Some screens and implementation details have been intentionally generalized because this was an internal enterprise project.

Explore More Projects

A few more top picks that show adjacent product, platform, and operations work across the portfolio.

View All Projects
Brill One-Page Landing Page Development preview Brill One-Page Landing Page Development Brill Hepa Filter | New product development Strapped Plate Generator Enhancements preview Strapped Plate Generator Enhancements Strapped Plate | Product enhancement QRIS Refund Reconciliation System preview QRIS Refund Reconciliation System Alfamart | New product development Stock Opname Application preview Stock Opname Application BRIX Performance | New product development