The Repository @ St. Cloud State

Open Access Knowledge and Scholarship

Date of Award


Culminating Project Type

Starred Paper

Degree Name

Engineering: M.E.M


Mechanical and Manufacturing Engineering


College of Science and Engineering

First Advisor

Dr. Hiral Shah

Second Advisor

Dr. Ben Baliga

Third Advisor

Dr. Kasi BalaSubramanian

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.

Keywords and Subject Headings

UI, Oracle, Financial Industry, Data Quality, Data Model



Data Quality refers to the processes which help in analyzing or validating the data based on different business rules. As a leading financial providers with a growing customer it is very difficult to maintain their detailed and secured data. An adjustment in the customer data was done very frequently (everyday) and it was done manually. Monitoring huge chunks of present and historical data is a complex task. The client will not take any risk even in losing any one of its secured financial data. The client’s current system has lot of limitations such as monitoring, adjusting, and validating employee data. The data that was in crude form was processed in order to satisfy the need of the end user for this kind of analysis. The user data and roles from different sources, legacy systems, interfaces need to be kept in track for audit and to overcome these limitations, the client implemented Certification Application, which not only allowed supervisors to certify their subordinates from various source systems but also used for auditing purpose on a fiscal year basis by which data integrity is maximized and data redundancy is minimized, as the single centralized place of all data also implies that a given set of data only has one primary record which helps maintaining of data accurate and consistent to enhances data reliability. Easier for use by the end-user due to the simplicity of having a single database design. This helped the business to have an auditing of the secured data which in turn assisted appropriate financial decisions to the stake holders.



I am really thankful to my advisor Dr. Hiral Shah for the guidance she provided me throughout the course of this project. She is always being a source who guided me in the right path of success, and shared her knowledge. She took her valuable time to read this paper and was most patient and understanding till the end of the project. Dr. Shah’s insightful suggestions and recommendations were very helpful to present this project effectively.

I would also like to thank Dr. Ben Baliga and Dr. Balasubramanian Kasi for their guidance and support throughout the entire study. I am grateful to the Engineering Management program and St. Cloud State University for providing the resources. I am thankful to my friends and family for their support and encouragement throughout my Master’s program.



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.