Construction of Dorco Claim Management System

● Portfolio Introduction

This project involves building an internal statistical solution for Dorco Yongin Factory Co., Ltd., aimed at managing user claims and utilizing sales data for statistical inquiries. This solution allows users to register and view claims in real-time and includes functionalities to visualize various types of statistical data in tables and graphs based on customer requirements. Additionally, it integrates with the client’s SAP system to synchronize sales and product data periodically for use within the system. To efficiently update large-scale statistical data, a batch system that runs at specific intervals was implemented, ensuring the reliability and currency of the statistics.

● Scope of Work

The scope of this project encompasses all stages of building a comprehensive website, including requirements gathering, storyboard creation, design and publishing, front-end and back-end development, unit testing and third-party testing, user testing, and final release.

• Requirements Gathering: Thoroughly analyzed the client's requirements to collect detailed needs for functionalities and services. This helped define the project direction clearly and provided solutions that met the client’s expectations.
• Storyboard Creation: Visually represented the overall flow and structure of the system to facilitate understanding. This minimized confusion during the development process and promoted smooth project progression.
• Design/Publishing: Based on user interface (UI) and user experience (UX) considerations, designed and published the web pages using HTML5, CSS3, and JavaScript. The user-friendly design maximized usability.
• Front-end/Back-end Development: Simultaneously carried out front-end and back-end development to implement system functionalities. The front-end was developed using jQuery to create dynamic web pages, while the back-end was developed using PHP to handle server-side logic.
• Unit Testing and Third-Party Testing: Conducted individual tests of developed features and external testing to verify system stability and functionality. This helped identify and fix bugs in advance, enhancing quality.
• User Testing: Performed testing with actual users to directly verify user experience and incorporated feedback to improve the system.
• Release: After completing all tests, the system was finalized and released to the client.

● Key Features

• SAP Integration: Integrated with the client's SAP system to synchronize sales and product data in real-time, ensuring data consistency and reliability.
• Batch Job Implementation: Implemented batch jobs to refresh SAP data on a daily and monthly basis, efficiently handling large-scale data and providing up-to-date information.
• Statistical Excel Download Function: Implemented a feature to download necessary statistical data in Excel format, enhancing work efficiency. This allowed users to utilize the data more effectively.

● Technologies Used

• Server Configuration: Configured the server using IIS (Internet Information Services). IIS was utilized to provide stable and reliable web services.
• Back-end: Developed server-side logic using PHP. PHP's speed, flexibility, and variety of features enabled efficient server development.
• Database: Used MSSQL to build and manage the database. MSSQL's capabilities in handling large-scale data and providing high performance allowed for stable data management.
• Front-end: Utilized HTML5, CSS3, JavaScript, and jQuery to build the structure and style of the web pages. User-friendly and responsive web design ensured optimal user experience across various devices.

This Dorco Claim Management System project applied various cutting-edge technologies and methods to create a user-centric statistical solution. Real-time data synchronization was achieved through SAP integration, and large-scale data was efficiently managed via the batch system. Various tests ensured the system's stability and reliability, and the final release provided the client with high satisfaction. This project maximized the operational efficiency of Dorco Yongin Factory Co., Ltd. and enabled them to provide better services.

https://qms.dorconet.com/