admin

About admin

This author has not yet filled in any details.
So far admin has created 12 blog entries.

Invoice Management in Home Loan Department

  • derrick1Tableau project description (invoice management in Home Loan Department)
  • This is a tableau dashboards project for home loan department for bank. There is SLQ2CQ internal management system requires tons of tableau dashboards to sure the proper data in order to track the performance of each employee in each department. This project is for invoice management department and there are several sections with it. There visual management, people management, and department management. Each team will have this tree types of dashboards and tells with different kinds of data metrics. Here is an example of how this dashboards look. The first two are same dashboards with different filtering. And 3rd one is the dashboard for compliance view, which has summary information with calculation of metrics up there and loan level detail down there.
  • For visual management view:
  • The currant and historical data […]
2019-01-20T13:57:53+00:00Projects|

HBase Data Extraction

  • Legacy Community Health was founded in 1978. It is a federally qualified Health Center and they provide services such as adult primary care, dental care, vision services, nutrition services, HIV/AIDS care, behavioural health services, etc. Currently, traditional RDBMS is used to manage all the data regarding to patient, medication, transaction, and more. Our goal of this project was to load the current existing data in RDBMS to HBase and extract the data using conditions such as prefixes, base column names and etc.
  • Pig is mainly used for this project since its built in functions found to be suitable. Using UDF was necessary due to Pig Latin being a data flow language. Some of the functions didn’t work as expected in the early stage of the project. However, it didn’t take a long time to find a way to work around it. It was convenient to use Pig to interact with HBase. […]
2019-01-20T14:09:16+00:00Projects|