“ALL IMAGES ON THIS WEBSITE ARE AN “EA SOLUTION” CREATION”
SAROS SMALL RUMINANT LIVESTOCK TRACKING SOLUTION
SQL
VBA
ACCESS DATABASE
With the implementation of our database application at the Saros Small Ruminant Livestock Production Facility, we have enabled comprehensive tracking of all animals based on their ear tag numbers. This system facilitates the monitoring of sales, births, and deaths of all animals within the facility. Furthermore, it ensures compliance with governmental regulations by enabling the automatic generation of reports for regulatory authorities.
STUDENT TRACKING SOLUTION
SQL
VBA
ACCESS DATABASE
The student tracking system enabled teachers within the school to easily plan their lessons. Still using in various schools. Through the established database, necessary data for monitoring students could be inputted, and with the aid of the created tool, the entered data could be analyzed swiftly, facilitating the rapid generation of student progress reports for the users.
CANCELATION ANALYSE SOLUTION
SQL
VBA
ACCESS DATABASE
ORACLE
Through our database analysis and identification system developed for MAN Türkiye A.Ş., we have established an automated part cancellation system that identifies components no longer to be produced for buses and promptly dispatches cancellation requests to suppliers. This system streamlines the management of obsolete parts and ensures efficient supply chain operations.
FABRIC PLATE COMPATIBILITY CONTROL MEMORY
SQL
VBA
C#
MAN Türkiye A.Ş. has implemented the ATA program, a sophisticated tool that leverages pre-existing code structures for vehicle analysis. These structures, customizable by developers, enable data manipulation and analysis. Within this framework, the company has introduced control mechanisms termed “digital memory,” facilitating the development of a system to verify the compatibility of factory plates with vehicles. Moreover, a macro has been incorporated to compare current reports with previous ones and input additional notes, thereby enhancing operational efficiency. This system apptoved to join to “MAN Product Systems Awards” that is an intern competition at MAN TRUCK & BUS Company.
VEHICLE and PART COMPATIBILITY SOLUTION
SQL
VBA
ACCESS DATABASE
ORACLE
At MAN Turkey Inc., we have developed a KBL System Control solution to assess the compatibility between components stored in the database and the vehicle types and engine specifications. This system conducts comparisons between components and vehicles to ascertain their compatibility, ensuring adherence to quality standards and optimal vehicle performance.
DATA ENTRY CHECKING SOLUTION
SQL
VBA
EXCEL MACROS
ORACLE
At MAN Turkey Inc., we have developed a macro integrated with a reflection system to validate user entries into the documentation system. This macro utilizes the reflection system to analyze user entries based on product structure, enabling the detection of potential errors and issuing warning messages to users accordingly.