nTangibles Data Architecture Service provides the following services for our Clients:

Business Modeling

• Work closely with the client, external agents (such as external data providers), and the business team to fully understand and represent the business model.
• Perform data analysis to discover where and when data may appear in their systems and how best to utilize the data in the most efficient manner.
• Translate the business model into a feasible and acceptable technical solution.
• Provide leadership for the data aspects of the project.
• Be the focal point for data-related issues.

Database Support

• Oracle, SQL Server, DB2, PostgreSQL, MySql

Data Modeling & Database Design

• Data architecture scoping. Identify what part of the Data Architecture may be impacted.

• Provide data modeling, database design, development, and implementation of corporate enterprise data components, data repositories, intranet/internet data flows, external data interfaces, and database management.
• Design data repositories and data movement to fulfill business needs.
• Prepare the plan for the Data Architecture change.
• Perform physical modeling that focuses on the physical implementation of the logical model.
• Maintain the Logical and Physical Data Models.
• Ensure that the data requirements are effectively addressed and provide a foundation and structure to meet the business and technical data repository needs.
• Help the Client understand the data model, flows, and interfaces, as well as validating the technical specifications prior to the release of the system.
• Support the team members by explaining the design and providing a prototype of the proposed design to validate/invalidate the design prior to the coding phase of the project.

ETL

• Design the needed Extraction, Transformation, and Loading processes (ETL).
• Identify the data structures and their dependencies, design and construct the data flows for the systems. This involves the design and development of the ETL processes.  These ETLs are used for loading into data marts, data warehouses, OLAP databases other relation/non-relation databases, and XML and flat file formats.  When necessary, build interfaces to perform ETL processes.

Integration

• Reconcile and integrate different data repositories so that they work together in a coherent and complementary manner.
• Design the data integration interfaces that are involved in data movement between heterogeneous and homogeneous databases/file systems.
• Design the internal and external data interfaces and interact with external data providers.
• Recruit the appropriate team members that will be involved in the design and implementation phase of the project.

Deployment

• Prepare the Data Deployment Plan.
• Identifying the technical specifications that are needed to satisfy the data requirement.
• Work with various departments within the Client's organization to determine the best database deployment strategies.
• Design and plan for data distribution and replication, database performance, data recoverability, and database fault tolerance.
• Manage the configuration of the backend software versions and database builds that are to be implemented in Production.
• Deploy the data change to its targeted area.

Support

• Play the leadership role for the Database Administrators, ETL Process Developers, and on occasion the Testers.
• Provide technical support for design, data issues, database, and data queries to the Database Administration, Development and Test groups.
• Test Readiness Reviews with QA prior to the first data test cycle of the product release.
• Provide support and documentation to the organizations that will own the process.