Transcript Slide 1
Edwards Lifesciences Putting our heart and soul into the creation of a new database Presented by Patrick Liu Trang Nguyen Daphne Ong David Huh Urvashi Upta Karena Wong Onyi Lam What is Edwards Lifesciences? Edwards Lifesciences is: • a global leader in products and technologies to treat advanced cardiovascular diseases • a global leader in acute hemodynamic monitoring • the number- one heart valve company in the world Edwards Lifesciences leverages its research, design, development and marketing expertise to produce products that address specific cardiovascular opportunities including heart valve disease, peripheral vascular disease, and critical care technologies. Brief History Lesson The history begins with Miles “Lowell” Edwards, who was a retired electrical engineer and lifelong inventor by 1957. However, his inquisitive nature urged Edwards to start a new project. Only weeks after retiring, the 60-year-old inventor, with a background in hydraulics, was busy theorizing how the human heart- essentially a pump, he thought- could be mechanized. He enlisted the help of Dr. Albert Starr, a young surgeon at Oregon Health Sciences University. After a farmer named Philip Amundson became the first patient to receive the Starr- Edwards valve, newspapers nationwide proclaimed a “miracle heart surgery success.” They had created the world’s first commercially available replacement mitral valve. Since the 1960’s, Edwards Laboratories has been purchased by American Hospital Supply Corporation, which in turn was bought by Baxter International Inc. In 2000, Edwards Lifesciences was “reborn” when it was spun off from Baxter and its stock began trading on the New York Stock Exchange. Company Stats Employees: 5,700 2006 Sales: $1.037 Billion Corporate Headquarters: Irvine, California Market: Sells medical technologies to over 100 different countries Existing Database: used to use a database system called ECHO, but have just upgraded to an Oracle based system called Enterprise One also utilized Microsoft Access for databases within the Electronic Service Center and Technical Support exclusively. Current Situation Two Primary Responsibilities • Producing OM-2 cables • Repairing Edwards Vigilance I, Vigilance II, and Videleo cardiac monitoring units Data • Customer complaints • Customer Purchases • Products that have been produced • Defective products • Repaired products • Dates Area of Need • Major issues in the streamline processing of the OM-2 cables Streamline consists of “birth” and the cables are then labeled with duct tape and a sharpie Bookkeeping processes are all hand written Serial numbers given to each cable were of sequential order with no systematic process Proposed Benefits • Eliminate the Electronic Service Center’s need to have manual hand- written record system for OM-2 cables Textual Summary of Database • CONTACT stores all contact information of CUSTOMER and SUPPLIER. It includes company’s name, contact person’s name and email address, company’s phone and fax number. Each CUSTOMER also has its own customer ID and shipping address. Each SUPPLIER has its own supplier ID. • CUSTOMER_ORDER records the customer’s name and ID, the amount and detail of the order, shipping address, and the employee who receives the order. • PURCHASE_ORDER keeps track of orders of material the company placing to suppliers. It has the order number, order date, employee placing the order, type of material and the supplier. • RAW_MATERIAL keeps track of what types of material received from what supplier and on what date. It also keeps track of the received amount and the amount of material having in hand. Textual Summary of Database (cont.) • ITEM keeps track of the product ID, the employee who manufactures it, and the date it is manufactured. There are two types of PRODUCT categories, which are NEW products and REFURBISHED products respectively. When the products are returned by the customers because of functional problems, the products will have to go through the manufacturing process again and are labeled as ‘refurbished’. • QUALITY_CONTROL keeps track the pass/fail information when the product goes through the testing process. It has the product ID, the pass/fail status and the date that the product is being manufactured. • FINAL_PRODUCT contains information on the product ID, the customer that it is shipped to, and the date that it is shipped out. Textual Summary of Database (cont.) • • • • INVENTORY keeps track of the inventory level of the cable. SHIPPER contains information about the shipper’s name, shipper ID and the shipper’s phone number. Each EMPLOYEE is assigned to an employee ID, address, SSN, phone number, salary, email address. COMPLAINT contains information about the customer and product when the customers file a complaint on the product. It contains the product ID, the technician who manufactured the product, the date that the product is being manufactured (to check if the warranty is expired) Contact Customer (0,N) (1,1) Supplier d (0,N) place (0,N) make Receive (1,N) (0,N) (1,1) regarding (0,N) supplies (1,N) Contain Purchase_Order Complaint (0,N) Raw_material (1,1) (0,N) received by (1,N) Placed_by about (1,1) Request (0,N) Received_by Employee (1,1) (1,N) (1,N) (1,1) Customer_Order (0,N) (0,N) Received_by (0,N) (0,N) (0,N) (1,N) Build_program Tested_by Final_Product (1,N) packaged (1,N) using (1,N) (0,N) packaged Quality_Control (1,N) (1,N) (1,N) Inventory (1,N) Shipped_to (1,N) (1,N) Shipped_by tested (1,N) Shipper (1,N) Item