Suggested Planning
Please find hereby the method of working that I suggest,
1-Objective and scope
The objective here is to understand the steps of the work, and to make the maximum automation in your work process. A database should be designed to minimize the paper come and go, to minimize the daily data controls etc. So the objective is to make your business running more efficiently with a database use.
2-Planning of work
The first step is to exchange information. I will get all your requests as reports content, type of data to enter.
I will prepare a prototype.
After you will revise. comment, and suggest on this prototype and then you will notify me about them.
Then I`ll prepare and send the second database. This second database will be the program ready to run.
Also I will organize the database structure according your work flowchart
I will assign operability and control options according the user place in the hierarchy.
On your approval I will prepare the final database by making the final touch on it, and finalise it.
For making this planning running most closely the same in practice, I will stay all the time in contact with you.
Finally I will send you this program`s user manual.
Also I will be online for services on after sale.
If any need of change will occure, you will notify me for the changes to be done, I`ll prepare this changes and send it to you.
3 - Technical Details
I will provide you one database where you will be able to install this database for multi user environment.
4 - Further Technical details of the database:
The program I will design will have its backend on the server. So the whole data entered will be stored on your server.
The frontend will be placed on the user`s computer, Id Est on the local hard drive of each user.
The main reason I do this is because the frontend is much more heavier then the backend, and when you run it it requires more space in memory of the computer. By placing it on the user`s computer I avoid server`s memory being overloaded.
This system will open you the way to convert in the future, this database to sql server easily.
Your satisfaction is my primary objective in my business
If you are interested and you would like to get more information on my services, do not hesitate to contact me
Other Works I make the consulting
1. The QRS Database for QS Department
a. For this database I made all the necessary changes. I don`t think there will be any need of doing something special
b. Shashank has given aleady a training to all QS department about how the system works and the procedures to follow for reporting to the client, to the planning and other reportings
c. Generally the way the QS personnel maintain their data is as follows
i. Marina and Lena make the batchloading (batchloading = adding data) to the QS system of new data. They are used to this thing for many months already
ii. Lena is trained to make the changes in the piping database for progress reporting of the cimtas production in the system.
iii. Lena is also trained on middle level about access database programing, She can make middle level queries for data checking and and she can also make some massive updates. But for doing this operation the best is she get support and help by Gokhan Nazikkulak or Haluk Tuna or Tolga Coskun (They know well Access programming, especially Gokhan Nazikkulak and Haluk Tuna)
iv. Also Marina and Lena makes the necessary changes to the database. They are trained for making simple queries, simple filterings and simple changes in the system.
v. Aydin, and the two Joey Brothers are preparing the data to batchload and they coordinate this job with the girls. They have been trained to make the simple filtering in the system and making the checking and changes they require.
d. If there will be any additional need about this database, it is going to be about the reporting section. This work can be done from here or from there by Gokhan, Haluk or Tolga Coskun. As Gokhan has a really advanced level he can be more helpful about it. But as it was discussed with Shashank, the QRS database got all the reports and forms necessary for running the department jobs. As this database has been used in 2 projects already , and according the fact that during 1 year I have been only interventing about adding new report only, I don`t think you`ll get any problem about the database structure. Also The mechanical, electrical database are really well maintained by the two Joey brothers. About the Civil database Aydin and I have been corrected the data and this database is ready to produce correct data, We stored many system for this database so as to control the best way the data entered and the data changed. Aydin got lots of training about it.
2. The database for Mechanical Engineering and Mechanical construction Department
a. This database structure has been established many months ago and it is running for many months without a problem occurred. Also for its production Tolga Coskun has participated actively, and he knows very well its structure. For any reporting needs for this database I can produce any report by your requirement. I don`t think that there will be any change on its structure. So this will cause no problem to you.
3. The databases for HSE Department.
a. All the database for HSE department have been maintained for long period. For the last six months I had no more request for any change or adding anything. I guess thess databases have proven their performance, they don`t need any more any maintenance.
b. The HSE may only require new database. I can provide them without problem in short time
4. The procurement Department database for reporting and data controlling of the MMSXP
a. I have prepared a database for procurement department. But as far as I know they were no need of this database.
5. Bar database and the library database
a. These database are working well for since 4 months. The problems that raises up about them is generally due to IT. Either there are network updates that causes connection interruptions becauses they change the addressing system.
b. The database need to have direct connection to the computer stored in SEIC bar and in BETS bar so as to produce the report, if there is any formatting of these computer or change in the network system then the connection is lost and should be restored.
The library database is also working the same way. I suggest to IT to have the least intervention on the bar and library computers
Experience
In just few words about the following table:
After your analyse of the table, you may conclude like many of our customer.
We are reflecting our experience accumulated in many years to our customer`s business. We do and do again same programs that has proven its reliability
Past Experience about Custom Programming |
About my personal experience | I have been working in construction business at Bechtel Construction Co as Cost Engineer and programmer in the same time I worked for the Russia/Sakhalin project and Kazakstan Tengiz project. I did programs for various departments of the construction site.
Also I designed many access databases for companies in different sector like construction, real estate, advertisement agency, furniture retailing. |
Among my XX-JV experience : | I did databases and maintained them during 1.5 year for: · quantity surveying, · logistics, · purchasing and warehousing, · cost, · finance, · electrical, mechanical and civil site construction control, · personnel payroll · and finally safety departments. . Equipment warehousing and workshop (My partner Gokhan`s experience for over 7 year) . Safety departments. |
As Outside Universe Consulting we did databases for: | · Finance . Call lines helpdesk, · Document control , · Advertising agency general database (including bid, accounting and customer address book). · Logistics · Warehouse control and reporting · Personnel Payroll and human ressources · Sport Schools Student achievements |
