"A database management system project requires as much strategic planning as any financial system and is not fully optimized until all opportunity costs are considered."
- Noel Udofa
"The focus of any successful project is quality. "
- Noel Udofa
- Noel Udofa
"The focus of any successful project is quality. "
- Noel Udofa
Projects
Cellular and Local Phone Company Merger - Data Warehouse / RDBMS
This project included both a cellular and a local phone company with individual system needs of managing per-second call logging, customer service requests, phone accessories, customer information, etc. OLTP (on-line transaction processing) systems were created to support the daily business functions of the companies by developing an Oracle 9i relational database for the cellular phone company and a Microsoft Access database for the local company.
Upon placing both OLTP systems into full production, from a business perspective,
This project included both a cellular and a local phone company with individual system needs of managing per-second call logging, customer service requests, phone accessories, customer information, etc. OLTP (on-line transaction processing) systems were created to support the daily business functions of the companies by developing an Oracle 9i relational database for the cellular phone company and a Microsoft Access database for the local company.
Upon placing both OLTP systems into full production, from a business perspective,
the companies merged into one entity. Therefore, system needs of the newly formed company included maintaining the initial OLTP systems in addition to the creation of a data warehouse to allow for unified data analysis. A data warehouse was created using Oracle 9i and designed according to a star schema and fact table size optimization. To cleanse and transport data from both OLTP systems into a form suitable for the data warehouse, an Operational Data Store (ODS) was created using Oracle 9i. In the ODS, the cellular company data was converted using PL/SQL and Dynamic SQL. The data for the local phone company was first transferred to Oracle 9i using a
single-step ODBC connection and then cleansed with PL/SQL and Dynamic SQL. Lastly, a PL/SQL script was created to automate the ETL (Extraction, Transformation, Loading) process. This script included Dynamic SQL so that the structure of the data warehouse (in regards to dimensional attributes) could be changed automatically to support rapidly changing data. As the OLTP systems supported daily input, these business processes where phased off into 4, 3-month cycles upon which the ODS, ODBC and ETL scripts where run to continually populate the data warehouse.
Photography Studio - Data Warehouse / RDBMS
This project included the creation of an OLTP (on-line transaction processing) system through the development of an Oracle 9i relational database. For the OLTP, the database structure was optimized for business data entry specific to the photo shop’s clientele and service organization needs. The OLTP was the basis for a data warehouse in which the structure was designed to support statistically friendly data. The data warehouse was based on a star schema and fact table optimization. The ETL (Extraction, Transformation, Loading) process was automated so that daily OLTP data could be cleansed
Next
This project included the creation of an OLTP (on-line transaction processing) system through the development of an Oracle 9i relational database. For the OLTP, the database structure was optimized for business data entry specific to the photo shop’s clientele and service organization needs. The OLTP was the basis for a data warehouse in which the structure was designed to support statistically friendly data. The data warehouse was based on a star schema and fact table optimization. The ETL (Extraction, Transformation, Loading) process was automated so that daily OLTP data could be cleansed
and transported to the data warehouse after any given period by simply running an ETL script.
Nationwide Merchandiser - Distributed Database Management System
This project sought to manage data for a merchandiser who has company sites at various areas of the country. This called for the development of an Oracle 9i Distributed Database Management System so that the various sites had equal access to two physically separated databases. Hence, two separate relational databases were created for the two sites and were linked using database links and kept in sync with materialized views, refresh packages and efficient usage of table space.
This project sought to manage data for a merchandiser who has company sites at various areas of the country. This called for the development of an Oracle 9i Distributed Database Management System so that the various sites had equal access to two physically separated databases. Hence, two separate relational databases were created for the two sites and were linked using database links and kept in sync with materialized views, refresh packages and efficient usage of table space.
Patron and Asset Management System - Systems Analysis
This project sought to conduct a thorough analysis to engineer plans for an automated library system. This system was to include both Internet and Non-Internet Graphical User Interfaces (GUIs) as well as Telephony and Kiosk interfaces. The analysis resulted in an elaborate system proposal and plan including the following:
This project sought to conduct a thorough analysis to engineer plans for an automated library system. This system was to include both Internet and Non-Internet Graphical User Interfaces (GUIs) as well as Telephony and Kiosk interfaces. The analysis resulted in an elaborate system proposal and plan including the following:
- Goals in regards to each stakeholder
- Project Directive
- Project Scope
- Managerial Approach
- Report Methods and Frequency
- Project Approach
- Development Approach (Incremental)
- Project Schedule
- Budget
- Constraints
- Opportunity Cost Feasibility
- System Resource Supply vs. Demand
- Quantifiable Benefits including:
- Performance
- Information
- Economics
- Control
- Efficiency
- Service
- Package Diagrams
- Context Diagram
- Class Diagram
- Data Object and Attribute Definitions
- System Usage Model / Use Case Diagram
- Use Case Glossary
- System Actor Glossary
Tool Checkout System - Systems Analysis
This system was designed for a manufacturing company with large capacity of inventory and a high rotation of inventory usage by employees. Hence, the system was to create an efficient process of tracking inventory including per-second verification of inventory possession. A complete system was engineered so that employees at various company sites could check inventory availability via an Internet interface and checkout specific tools. The system was to maintain security by validating employee credentials against specific tool checkout requirements. It was also designed to provide management with report ready data to summarize inventory movement.
This system was designed for a manufacturing company with large capacity of inventory and a high rotation of inventory usage by employees. Hence, the system was to create an efficient process of tracking inventory including per-second verification of inventory possession. A complete system was engineered so that employees at various company sites could check inventory availability via an Internet interface and checkout specific tools. The system was to maintain security by validating employee credentials against specific tool checkout requirements. It was also designed to provide management with report ready data to summarize inventory movement.
Property Management System - RDBMS
This project required a system to manage data for a leasing company. The company’s services included selling property for ownership, for lease and for rent. An Oracle 9i relational database management system (RDBMS) was developed to manage the company’s business data along with an Internet interface that was designed using active server pages (ASP) and JavaScript.
This project required a system to manage data for a leasing company. The company’s services included selling property for ownership, for lease and for rent. An Oracle 9i relational database management system (RDBMS) was developed to manage the company’s business data along with an Internet interface that was designed using active server pages (ASP) and JavaScript.
Merchandise Management System - JSP / RDBMS
This system was designed to support a large capacity of inventory, sales and customer data. It was developed using an Oracle 9i relational database with a JSP (Java Server Pages) Internet interface. The interface was equipped with several search and pre-population functions to provide ease of use for users while enforcing application and data security.
This system was designed to support a large capacity of inventory, sales and customer data. It was developed using an Oracle 9i relational database with a JSP (Java Server Pages) Internet interface. The interface was equipped with several search and pre-population functions to provide ease of use for users while enforcing application and data security.
Employee Management System - RDBMS
The goal of this system was to manage employee data by tracking work hours and productivity, salary, and dependent (children) data. An Oracle 9i relational database was created to manage this data while enforcing data security and optimizing table space.
The goal of this system was to manage employee data by tracking work hours and productivity, salary, and dependent (children) data. An Oracle 9i relational database was created to manage this data while enforcing data security and optimizing table space.
Fault Simulation - Application and Database Testing
The goal of this project was to design an elaborate testing strategy and then to carry out the tests for a software/Internet product during its second release. The test strategy included compatibility, conformance, usability, robustness, reliability, unit, regression and stress testing. The tests were performed by conducting fault simulation with the Canned Head software and with manual fault injection.
The goal of this project was to design an elaborate testing strategy and then to carry out the tests for a software/Internet product during its second release. The test strategy included compatibility, conformance, usability, robustness, reliability, unit, regression and stress testing. The tests were performed by conducting fault simulation with the Canned Head software and with manual fault injection.