Post: the story of me and ERP: the birth of a female CIO

A good article must be noted down and read more.

About 10 years ago, I worked as a small technical manager in a large joint venture. Once, a good friend of mine asked me to help his relatives-a young girl who just graduated from college to find a job. This little girl looks very elegant and intelligent. She is a student in a rural school who has been squeezed down by the efficient College Entrance Examination assembly line in the city. She is a computer student. She knows that my department is also responsible for the company's IT and asks if I can bring her into my department. I clearly stated that it is impossible to enter my technology department. Our department is not willing to even the undergraduates of famous universities. However, I can introduce her to our production department, where there are many surface installation lines that need to be maintained by computer workers.

　

When the workers on the production line are clearly not for the purpose of my friend, but the little girl doesn't care about it: Our company's benefits are very good, and the technical workers on the production line earn a lot of money. For her, her monthly income of more than 1000 yuan can help her family quite effectively. So she insisted on going.

The next thing is very simple. The workshop director is happy to recruit her. Although he can find undergraduates, he is rarely willing to work long. After numerous job-hopping events, he vowed that as long as he was a college student.

This little girl seems to be able to adapt to her first job. I will soon be able to easily and have time to go to the technology department to chat with me. I know that there is nothing to watch about the computer on the placement machine, as long as I know how to load different programs in different product sequences. So she often goes to my office to flip through my computer newspaper and ask this question. She was very satisfied with her current job.

A few months later, Alan gradually had no time. Once I met her, I found her eyes black. I asked her if she was ill. She said no: "It's all about working overtime day and night ". I know that the current sales situation is good, and the production line is full. When they have six SMT lines, it should be enough in any case. Next, her complaint immediately broke out:

"I really don't understand. Since we are so busy, we should keep driving the production line. We have enough people to work three shifts. Now, it's okay. It's always a long time to work overtime. During the day, everyone is idle and can only play poker. Is the company leader crazy ?"

In this case, I explained to her: "This is mainly about spare parts. If there are not enough spare parts, stop and when the spare parts will be produced. These spare parts warehouses cannot store too much, which is equal to where a large amount of money is stored ".

"So we should predict the shortage of spare parts in the warehouse ".

I said, "It's not that simple. Don't you have a schedule for the warehouse every week. However, the progress is not linear. For example, one of you guys broke the Laser Ruler on SMT last month, right. Your production progress is slow, and the inventory cost goes up. Last year, who could think of what kind of gift project the user was about to launch and urge delivery? As a result, a small plug-in was missing in the warehouse, resulting in the shutdown of the entire production line. In this case, the warehouse or procurement department can only rely on experience to calculate once a month to ensure that less inventory meets the supply requirements. When accounting is made every month, a report is made to your production department ".

After I said that, I comforted her and then left. I don't think she might want to work more night shifts, so she can get a lot of overtime. However, she ran to my office that night. "We are waiting for spare parts again. It is said that a big truck has arrived in Tianjin ". I asked, "Are you going to stay up all night ?".

She suddenly said with a very serious tone: "I don't understand one thing. When we start the production line, every part is useless. When we use it, there are records in the computer, right?"

"Yes, for example, each used IC is recorded in the SMT computer, and accessories must be scanned by bar code ".

"So when we give the data in the computer to the warehouse, they don't know how much we use each spare part. How is the progress? That way, they can take action before they are out of stock. "She was obviously excited about her thoughts.

I smiled and said, "This is impossible. First, the data is scattered in dozens of processes. Some data, such as in SMT, is the real name. Some are codes. There are still many people who do not know what it means. Second, the data format is completely different. For example, the bar code is filed with the repair department, and the rack is provided to the engineering department. In fact, there are dozens of systems operating on your production line. Each person is in charge of some data, but they are completely independent of each other. The last and most important thing is that the serial number system of the warehouse is different from the serial number of the production line. The same thing is called in the warehouse and the production line. No one can beat them. What's more, the dimensions are different. What box number do they use and the column number? You use the self-developed product number. The IT department of this technology department has done a detailed investigation and the conclusion is that it is not feasible ."

Maybe it was my answer. She thought about it and left. Unexpectedly, after a few days, she asked me to ask for a computer. "We have 386 computers in our department, and I am afraid to do so on SMT," she said. Some of our department's computers let her remove one, but there is no display. We use a 20-inch Sony display, which is a one-person configuration. But Alan was very happy. She said, "It doesn't matter. We have a black and white team in our department. We can still use it ".

Later, I heard people say that Alan often went to the warehouse to ask for the serial numbers of each device. I wonder that she doesn't want most girls on the production line to take advantage of the opportunity to stop waiting for work, play poker or go shopping, and feel sorry for her. It seems that she is still thinking about data. This is the tragedy of a person with higher education. In fact, our it has been to the warehouse many times, and no one can wait for more than two days. The masters of the warehouse are old workers before the joint venture. The cultural level is very low. what's even more terrible is the time of thinking for decades. They only get used to describing things in their own language. If a box of filter chips is called C3, they will always call it C3. What is C3 is C3. Several of my employees claimed that they would rather carry cabinets on the production line than hold a meeting with the Warehouse masters. "She will soon be annoyed by the waste of time ". I couldn't help but feel a little bad when I think of Venus, a lively little girl, who was cursed by masters.

I will create a project abroad in the next few months. One day, one of my subordinates called me and said, "You guess what, your lady LAN connected the production line to the warehouse !, This software has been running for a week and the results are very accurate. The big leaders are so happy and crazy. Now they want to drag our hp9 server for her ".

I was shocked and found an excuse to run back to China. When I came to the factory, my leadership and General Manager of the technical department were obviously unhappy. He said that the progress, consumption, and inventory of all spare parts can be seen every day, every hour, and every minute in the warehouse. Starting from the start of the little girl's software, the production line has never been shut down yet. The manager of the production department said that they can arrange every class in advance and no longer need to rush people like a sleep. The Sourcing Department says how much cloud resources are saved. My mind was so messy that I was completely scared by the big number that the purchasing department said. In the end, he said, "Your IT staff are 7 in 7, that is to say, the warehouse cannot be connected to computers. As a result, a little girl is still from the production department. It has been fixed for four months. You are not ashamed ."

I went downstairs and saw Alan's software. Now I am running in the production department manager's office like a baby. The machine that I supported her is still on the sidelines. After logging on to the machine, I found that the entire program was actually based on a FoxPro database. I checked her program. Of course, the program is very rough and obviously has the characteristics of amateur programmers who lack system training. However, I have to admit that in the past, we used to think that the impossible data processing process was just a huge amount of patience, meticulous communication, and painstaking verification. Tian knows how she maps data in various links one by one, but all this may only need one pen and one record. I can imagine how she talked to everyone, and finally sorted out all sorts of strange statements. When I checked the program, the secretary of the production department came over several times and said nervously: "You should not break the program. Alan is switching shift today ...". I was so angry.

Now, it's just the beginning of Alan's career. I have to admit that people need luck, but this kind of luck is often brought about by enterprising and some unusual qualities. Alan may have a low level of knowledge, but his ability to communicate with people and summarize is remarkable. ... (Write it here today, to be continued)