This report is my first progress report and I will briefly discuss and explain my assignments, task, projects and achievements that I am involved in during my coop period at Rashed Abdul Rahman Al-Rashed & Sons Company at HRIS department from the first to the eighth week.
Here is the list of topics that I will be discussing in this report:
1- SQL Server
2- OFOQ ERP System (Time Management)
From the first day of my coop, my supervisor gave me an SQL database and a Microsoft SQL course CD to practice SQL. It took me a week to refresh and to get back on the right path. Moreover, he also gave me a documentation that has ...view middle of the document...
I have attached in the appendix section a business case that has all of the information regarding the project. The project is still on phase one but I have managed to take some screenshots from it.
Figure [ 3 ] Portal Login Screen
Figure [ 4 ] Auto Generate Report
The archiving system at Rashed Abdul Rahman Al-Rashed & Sons Company (RAR) scans every paper in the company to make an electronic copy; therefore, all of its processes are paperless. All of these processes are being done though a system called Open Text. The problem is that this system does only work on the intranet, which means it is only available to the employees who are physically located at the company or those who have VPN access. VPN authentication is giving to exclusive groups in the company for security reasons. Moreover, that makes it hard on those who travel and in need to obtain a certain document form the system. The Database Administrator (DBA) raised the solution to this problem, which is to make an ASP.NET website that will be connected to the archiving system database. Although, there are other alternatives but since the company has already implemented an ASP.NET web server and the DBA asked specifically for it.
Description of the Problem:
The current system does not have the ability to provide an access to the employees form outside the company and most of the times many employees goes on a business trips and some situation they find themselves in need to obtain a copy from a certain document that is only available in the archiving system.
Solution and Alternatives
There are different types of solutions for this problem but the DBA has already chosen one. A mobile-optimized website is user-friendly and will be integrated with the current archiving system. The website will provide a secure portal for the employees to access the system and will be able to retrieve documents from it.
Team Selection for developing the Business Case:
The following individuals comprise the business case analysis team. They are...