-
Essay / Databases - 736
SUMMARYThe Automated Business Services System (ABSS) was designed to allow military personnel to process documents without wasting a significant amount of time. The original way of processing a document involved typing it and visiting each person to sign it. Not only was this time consuming, but there was no historical record available if the original document was lost or destroyed. ABSS uses an Oracle database and has forever changed the way finance processes documents. Before working as a systems administrator for finance, I was a budget analyst. I started using the Automated Business Services System (ABSS) over eight years ago and believe it is one of the best programs adopted by the Air Force. ABSS was written by a private company and has been implemented in several branches of the service. When the program was first implemented at my base in Germany, I was made a functional administrator to maintain the program. I was in charge of managing all user accounts and assisting the resource advisors on base in building their flows. I also had to process my program documents through ABSS. I had to quickly learn how to use this program as well as learn how the Oracle database stored all of this relevant data. Before the system went live, I was trained for a few days on how to start creating the database and prepare the system for implementation. I would not be responsible for maintaining the actual database. We had a remote database administrator who had the ability to access the database and ensure there were no issues. The current server was in my office but I didn't have access to connect to it. I could log into the program from any system and make changes to the database that way. Actual database integrity was not part of my duties. I had to start creating all the accounts for each user in the database. There was a lot of work to be done before the database went live. Each person who needs to approve a document would have an account as well as a step in the process. A user would write and submit a document. Each user account also had an email address linked to it. This would allow the system to generate an email and the next person in line to approve the document could log into the system and take appropriate action..