STOCK BROKERAGE

BY

LARRY KING JR.

IT203

SEPTEMBER 3, 2013

Having a stock brokerage company that is need of capturing data can be very difficult. Like any other industry, there are many types of data that can be captured on many different levels. For this project I have chosen to capture the basic information that a client and broker would be able to share at moment’s notice. The information that was collected was taken in the context of a client calling or logging into a particular stock brokerage. The ideal is to make the pertinent information available in a simplistic manner. What needed to be captured was all the pertinent information that related to the client and the information that is attached to the client’s broker. If the client were to call into the company, the initial representative would need some basic information such as the client identification, the broker’s information, account information, and possible transaction information. When looking at what the pertinent information a customer would need to know when calling or emailing the company the above listed information is what was of most importance for the clients. What was most important to determine was who needed access to what information. An example of that would be that the receptionist may receive a client call and the client needs to find out detail information about their account, then the receptionist can direct the client to the correct broker. When it comes to data input, I needed access to the clients demographics, how the client was being paid and the process in which they were being paid, broker demographics, basic account information, and stock information. The reason I needed the client demographics was to establish more than one way to access the client’s information. I wanted to be able to link the client demographics with their broker demographics. The combination of those two types of information would allow you to obtain identification numbers to the other pieces of information. The account information is needed to link all pertinent information together. When the broker access the account information, they will be able to give the client any information they need at any given time. The client might want to know payment information or stock information and with a simple click of a button the broker will be able to deliver that information to the client. Given that each client may have internet access to the broker firm, they too will be able to access the same information from the company’s website with minimal searching. When a client or an employee accesses the database at a minimum they will need an account number. If the account number is not readily accessible they will need to know all of the client’s demographic information to access the proper account. Depending on what type of employee you are dealing with will determine what type of access that person has. Since there are huge security risks involved with the amount of money and information coming in and out of the company, this will have to be heavily monitored. Levels of access will have to be determined by the management and implemented during the creation of this database. Top level management and the IT Security officer will have the highest level of security access and the customer service representative will have the lowest level of security access. The only access the receptionist may need to have access to is the client’s basic information, whereas the broker will need access to the client’s complete account. Other measures may need to be created to work with the database to ensure the most stringent security protocols stay in place. Reports will be generated on a monthly, quarterly, and annual basis. The reports will measure the accuracy of the data that is being entered as well as the progress of the company and client profiles. Each report will determine if more or less information or fields will be needed to better the database. Based on the company’s needs I will modify the database on an as needed basis, but will review the database on a quarterly basis. If the review determines a need for updates or changes then it will be done at that time. System performance will be monitored during these times. A considerable amount of data will be placed into the system, therefore the size of the database will be evaluated during the bi-annual review of systems or unless otherwise asked to update the data size. The agreed upon rate was $90 per hour and the finish project was schedule to be done within 40 hours to include all materials. Schedule maintenance will be at the same rate. The project was completed on time. No additional expenses were incurred during the project. The client was satisfied with the final product and the terms that were agreed upon.