Source: www.jobeasy.cn
I and the story of ERP: A female CIO is born about ten years ago, I made a small technical manager in a large joint venture. Once, one of my good friends wants me to help him relatives - a little girl who has graduated from graduation to find a job. This little girl is very beautiful, it seems to be very smart, belonging to the middle school in rural school, but finally, it is the kind of student who is squeezed by the high-efficiency college entrance examination line in the city. She is learning computer, my friend knows that my department also does the company's IT, asking if I can bring her into my department. I clearly say that my technical department is impossible. Our undergraduate students in our department are not willing to want. However, I can introduce her to our production department, there are many surface mounting machine production lines, need to know some computer workers maintenance. When the worker on the production line is obviously not my friend to try me, but which little girl doesn't care: our company's benefits are very good, the technical workers on the production line income. For her, more than 1,000 yuan per month can be quite effective to help her family. So she resolutely expressed willing. The next thing is very simple, the mainstay is very happy to recruit her. Although he can find undergraduate, few are willing to grow. After numerous hopping wind wave, he swear only to be a college student. This Mranan girl seems to be able to adapt to her first job. Soon, you can go to the edge and have time to run to the technical department and chat with me. I know that the computer on the patch machine is actually nothing to see, just know how different product sequences are loaded with different programs. So she often runs to my office to turn my computer newspaper, ask this question. In the words, she is very satisfied with the current work. A few months later, Xiaolan had no time to come. Once I met her, I found out that her eyes were black. I asked her whether she was sick, she said no: "It is not enough to work overtime." I know that the sales situation is good, the production line is very full, and when they have six SMT lines, no matter how it should be enough. Asked, her complaint immediately broke out: "I really don't understand, since it is so busy, I should turn the production line all the way. We have enough people. Now it is good, open and stop, often in the middle of the night. Suddenly overtime, everyone can only play poker, but the company's leadership is not crazy? "This situation, I have a little known one, explain to her:" This is the problem of spare parts. If the spare parts are not enough , Stop, when is the spare part to produce. These spare parts warehouses cannot be stored too much, that is equal to a big money? " "So, the warehouse should predict the shortage of spare parts." I said: "Not that simple. You don't have progress tables every week. But the progress is not linear. For example, I have a guy in the last month that you have broken the laser feet on SMT, right. Your production The progress is slow, the inventory cost is going. After last year, who can think of the user suddenly want to do a gift project, reminding the delivery, the warehouse lacks a small plug-in, causing the entire production line to work. This problem, The warehouse or the purchase department can only rely on experience every month to ensure that less stocks will meet the supply. Their people, when they account for each month, a statement of the report, I can't kill your production department. " I finished, and comforted her a few words. I think she may not want to add more nights, so that she can get a lot of overtime pay. However, she came to my office that night. "We are waiting for spare parts, it is said that the big truck will go to Tianjin." I asked: "So you have to be all overnight?".
She suddenly said with a very serious tone: "I don't understand, when we start, each component is useless, how much, the computer is recorded, right?" "Yes, such as Each IC used is recorded in a computer of SMT, and the accessories are scanned by the accessories. " "So, we will give the data in the computer to the restaurant. They don't know how much each of our spare parts, how is the progress? So, before the shortage, they can take action." She obviously The idea is very excited. I laughed and said: "This is impossible. First, these data is scattered in dozens of processes. Some data, such as in SMT, is a real name. Some is only code. There are still many things. I know what it means. Second, these data formats are completely different, such as bar code is filed for the maintenance department, the rack is to the Engineering Department. On your production line, there are dozens of systems in operation, each person Some data, but each other is completely independent. The last is also the most important, the number of the library's number system and the production line is completely different. The same thing, in the warehouse, the production line is another name, no one can put them Before you, what is the same, what box number, list; you use the self-edited product number. The IT department of this Technical Department has done a detailed investigation. The conclusion is not available. "Mercure my answered I got a role, she thought about it. I didn't expect to have been a few days, she is looking for me to say that I want a computer. "Our department's computer is 386, I don't dare to move on SMT", she said. Some of our department's computer, let her move, but there is no display, we use a 20-inch Sony display, which is a configuration. However, Xiaolan was very happy, she said: "It doesn't matter, our department has a black and white, still used". Later I listened to someone that Xiaolan often ran to the warehouse to find someone to ask each device. I strangely she didn't want to produce most of the girls on the line, using the opportunity to go to the work to play poker or shopping, and very sympathetic. It seems that she still thinks of data, this is a tragedy of people who have received higher education. In fact, our IT has been to many warerooms, and no one can stay for more than 2 days. Masters in the warehouse are old workers before joint venture, and the cultural level is very low, and more terrible is a decades of thinking. They are only used to describe things with their own language, if a box of filter chips are called C3, then they will always call it C3. What is C3, that is, C3. Several of my hand claimed that I would rather go to the production line, and I didn't want to open a meeting with the warehouse masters. "She will soon feel annoyed for her time." When I think of such a lively little girl, I can't help but feel distressed when I was a bloody star of the teacher's tache. I am doing a project abroad for a few months. One day, I called me in one, said: "You guess how you, your Lantan is connected to the production line and the warehouse! This software has run for a week, the result is very accurate, big leaders Happy is crazy. Now they have to drag our HP9 server away from it. " I was shocked, I found an excuse to run back to the country. When I came to the factory, my leadership, the general manager of the technical department was obviously not very happy. He said that now the warehouse is daily, every hour, every minute can see the progress, consumption and inventory of all spare parts; start running from the little girl's software, the production line has never stopped working. The manager of the production department said that they can now pre-rinse every class, and no longer have a half-night chicken.
The Purchasing said how many clouds have been saved. My brain is confusing, which is completely scared by the big digit that I have said by the Purchasing. Finally, he said, "Your IT seven into the seven out, that is, the problem of the warehouse is not able to go on the computer. The result is a little girl, or the production department, 4 months solved, you are not." I went to the building Looking at Xiaolan's software, now I am running on the Office of the Manager, I support her machine, I have been still falling aside. I went to the machine and found that the entire program was only based on a FoxPro database. I checked her program. Of course, the program is very rough, which is clearly characterized by amateur programmakers lacking system training. But I have to admit that we are deemed to be fearful, and it is impossible for impossible data processing processes, which is only huge patience, meticulous exchanges and neatly. God knows how she should correspond to the data of each link, but all this may only need a pen and a record. I can imagine how she is talking to everyone, and then organizes the monarch to finish the unified. During my program, the secretary of the production department came over several probes, and he said hetely: "You don't break the program, Xiaolan Today ...". I can't help but be angry. Now I think of it, all this is just the beginning of Xiaolan career, I have to admit that people need luck, but this kind of luck is often in the heart and a unusual quality. Xiaolan may have a very low knowledge, but the ability to communicate and summarize the summary is outstanding. . . . (Write here today, to be continued) Now the pressure has fallen on our technical department. When the general manager meets, it specially praises Xiaolu, and the computer management is important to the business, and it seems that the Prime of Xiaolan is his idea. Xiaolan now has time to come to talk to me, seems to notice that she gives me the embarrassment. Once I said to her: "You do this, but you can say hello to us, I can help you plan more." She smiled, she thought that this procedure is to the data format, no History bother us. I thought that when I was watching my overtime every day, I didn't even bother me. After a week, the old man of the Ministry called me to his office. I saw that the big leader of the Ministry of Production and Purchasing was there. My boss requires me to transfer a usual HP Server to Xiaolan. The reason is that the data has a large amount of data, the purchase department reflects the speed of access to the speed of the visit - they have ordered this procedure. I don't want to put the server, I just said: "Now the speed is busy is the problem of the program, and the relationship between the machine is not big. She uses FoxPro is not a real relational database, data table access needs frequent Unlock. This point of access is a lot of inevitable performance. In addition, her procedure has a lot of bugs. Now there is a lot of information on my public server to use, and there is no role in tone. " Unexpectedly, the general manager of the production department said that I said to me very well: "What is the problem that Xiaolan's procedure is problematic, or be reluctant to put the red alert loaded?". My face is red, the red police on our server in fact is actually playing in the technical department, but two people who have went to many production units have also added it. I didn't expect this leaders who all knew that they also selected this time in the bucket. The old leaders of the housing room also said that he didn't know what to add, he knew that this thing was very good. Now he asks to improve the speed of running, don't want to hear what I explain why I finally re-made a program with Sybase. Finally, I still walked in a word: "You will use the computer to prepare your fingertiline, and we have our meal; how to have a smallman work, that is the real helping company? ".
My boss's nose must be ignored, and I am smelling me first, and I will limit the machine within two days. "You will send two people, let Xiaolan's optimization procedure, must do it!" I immediately fell: I want to give her a server, but I have to listen to a teacher's computer system. The command of the little girl graduated, I am afraid that they have to strike with me. I thought in a night, I went to my boss next day, and now the best way is to transfer Xiaolan to the technical department. I said that if the production department is always programmed, I will take a big bag for them. My boss is very hesitant, saying that this process is very important, I am afraid that the leadership of the production department will not put it. I whispered, just because it is important, you must call Xiaoran. Leading a look, looking for the general manager to report. Tuning Lan Lan to the technical department did not imagine the difficulties. We can't always let Xiaolan look at the machine on the production line during the day, so you can call the Technical Department, or we take hands to make this program. The general manager snorted: "Let you do these people, I don't worry." Next, a piece of paper is adjusted, regardless of the manager of the production department, will come over. Xiaolan is very excited. Now she can sit in our office. It is seen in our office - at the production department, working hours reading is considered violations; but the technical department is a virtue of leadership praise. She doesn't need to wear a tool, and she is in her hands. The anti-static bracelet is. Even if we go to the outside restaurant to eat, she is very happy: because the regeneration department, the work is arranged, and only 45 minutes of dinner. Her labor contract becomes a long-term contract rather than a year of temporary contracts for the production workers; the wages have risen double. I think, this Xiaolan should be satisfied. Xiaolan is indeed very satisfied, excited all day, I said her new discovery; but my ministry, I will call me a college students, I feel that I have broken the technical department. I have to explain that you don't always say that the route of the machine room has become a group, let you go to the reason, you feel too trivial. Now I am looking for a college student, just do these things. After two days, I found that they really commanded Xiaran dry. The laboratory's room has really changed very well. In the past, they had to pull various terminal equipment to the host, and the new line flying is like a spider web. Now they just greet Xiaolan, Xiaolan will open a block, and wear the line from the floor. She made a detailed record. When do everyone pulls what equipment, how long you have to say good. Therefore, engineers needed the interface to be ready to start, and they will be taken away. In the past, our machine room was covered with a variety of wirings. Some lines appeared in a few centuries, but no one dared to pick up - Who knows who is using this line? Now that this well is very satisfied, it is really a good thing. It is a hundred and twelve patience. She never angry, the most discerning and the most confused engineers can be included in the plan. She is also very satisfied with the current job. I saw that she was picking up the floor for an engineer to find a line that declared the existence of the existence, just criticized this engineer. Xiaolan didn't care, saying that I will not help everyone in this regard. I did assign a new college student to help her modify her procedure. In fact, the procedure is not more complicated, and her time is mainly spent on the meeting, on the data. I said, her patience and meticulous are extremely excellent. What we are most afraid is to deal with people who don't understand the computer, because everyone cannot communicate with the same language. Brother of a purchase department.
At the moment, you will point offices, always think about how the window is open, how to get the mouse, how to jump out, then and Xiaolan, do not consider logically not only logically. I couldn't help but jumped, saying that the program is designed to be systematic analysts, you only need to explain how you usually work. However, Xiaolan is a book and his countless discussion, without seven bleeding, and finally reaches the same. One day, she said to me, she wants to move the program to SQL Server. I asked her to have learned SQL Server before, she was very embarrassed, the teacher only taught DBase when the school, and she even foxpro came from self-study. Nowadays, the number of users is very large, and Xiaolan records the number of users' visits and performance reports. From the report, in a few days, our new surface mount machine (SMT) is started, the system's performance is not enough. Supported. After all, it is her program, I agree. I didn't expect the next day, which college students I sent to me came to me to talk, let me know the meaning: First, he asked to use the Oracle database instead of SQL, because Oracle's performance is powerful, and the company's Many departments are now using Oracle, with ready-made platforms. Second, he said that the level of programming of Mran is too bad, even the process and trigger will not, each query is countless SQL interaction, so that software performance becomes very poor. He also hinted that he should be systematically designed by him when he is a new platform, and Xiaolang gives her hand. I asked him a few questions and found that he did not arrive at the production line, nor did it go to the warehouse. He doesn't know what the data in the database is. In his opinion, he as a graduate of the computer system of famous university, and there is no need to run and worry together. I smiled, I thought I met a self-righteous guy. The new graduation students are often like this: the theoretical knowledge of the brain, I feel that no one is high, but I don't want to do hard trivial and seem to have something worth showing off. As a result, this system is the most complicated is the early analysis survey, and the workers in each link check data and terminology. If the data flow is clear, it is actually just a dish. If it is so simple, we still use him to make an idea? But I have to pay attention to his question. I found Xiaoran and I suggested that she uses Oracle instead of SQL Server. Xiaolan smiled and said that many people were so suggest that she felt that they were enthusiastic about oracle because Oracle was more complicated in society. They would like to take this opportunity to practice. I ask, don't you want to learn Oracle? I can arrange your training to Oracle, and I am also a nice opportunity. Xialan said she still wanted to learn, but she took a few Oracle's books and thought that no matter how to train, it is too small from FoxPro to Oracle. Although the company is now useful with the Oracle system, but it is bought, there is no master of Oracle. Instead, there are many people who are familiar with SQL Server; because they are mircosoft products, there is a lot of workloads from FoxPro to SQL Server. I think maybe because Madlan starting is relatively low, she considers what she considers is not so far, do not intend to do everything possible to learn a variety of fashionable technologies, but diligently want to do things well. On the contrary, her college student assistant, she is also a good one for Oracle, but in order to pave the way to her future, she will take a risk to take risks. I support her SQL Server program, and her platform migration is completely completed.