ITnova Consulting

Data Services

Data Analysis

Review source files that supply data to the data warehouses for accuracy and determine optimal structure for analysis and reporting purposes. Data is analyzed for duplication, formatting errors, and other anomalies to ensure quality for measures and official reporting to external customers or stakeholders. Provide recommendations or make any changes or corrections to data to enhance or improve data quality and document those changes in a format consistent with guidelines.

Database Administration

Evaluate and recommend available database management system (DBMS) products to support validated user requirements. Define file organization, indexing methods, and security procedures for specific user applications. Develop, implement, and maintain database back-up and recovery procedures for the processing environments. Ensure data integrity, security, and recoverability are built into the DBMS applications. Expertise and vast experience working with Oracle databases and ETL data feeds.

Data reporting

Provide clear and concise reporting to the Government to ensure situational awareness. Support dashboard design, development, and implementation, which allows the analysis of the data and creation of ad-hoc reports.

Data Development and Data Modeling

Work with SQL Datawarehouse in Azure. Use Azure data factory for ETL and Power BI databases as a source. Develop and deliver database diagrams, and implement ETL packages, stored procedures, and reporting capabilities. Assist with design, development, testing, implementation, and maintenance of data warehouse solutions (databases, data marts including dimensional star schema data marts, data warehouses, and associated data models).