Open Access. Powered by Scholars. Published by Universities.®

Mechanical Engineering Commons

Open Access. Powered by Scholars. Published by Universities.®

Culminating Projects in Mechanical and Manufacturing Engineering

Management

Discipline
Publication Year

Articles 1 - 2 of 2

Full-Text Articles in Mechanical Engineering

Implementation Of Sql Server Database And Business Intelligence In An Oil And Gas Industry, Pranay Papishetty Dec 2014

Implementation Of Sql Server Database And Business Intelligence In An Oil And Gas Industry, Pranay Papishetty

Culminating Projects in Mechanical and Manufacturing Engineering

The main objective of this project was to meet the needs of data management, capturing data from various data sources and integrating the data into a database for reporting purposes. This was achieved previously using a legacy system called as FOCUS and is now replaced by a database using SQL Server Business Intelligence. SQL Service Business Intelligence is not only used to load data into the database but also provides tools for reporting and analysis services. Loading data is done using a tool provided by SQL Server called as SSIS and reporting or representation of data is done using another …


Root Cause Analysis Applied To Transition To Production, Troy Pierson Sep 2010

Root Cause Analysis Applied To Transition To Production, Troy Pierson

Culminating Projects in Mechanical and Manufacturing Engineering

This study examines problems that arise during transition to production of a complex system. It focuses on a single component of the system as a representative of the whole to illustrate how three common production concerns can be addressed: (a) late delivery of the first production part, (b) the ongoing production of non-conforming parts, and ( c) predicting/preventing future interruptions of continuous production. Focusing on the Analysis process of the Six Sigma DMAIC methodology, this study centers on a structured approach to problem solving by applying root cause analysis techniques to identify key causation factors. Results of this study indicate …