• Support the automated/manual methods used to collect data from various authoritative sources using Oracle Business Intelligence 11g, SQL Developer 4.0, Tableau 81, 8.2., and MS Excel/Access 2010• Publishes completed Dashboards/Workbooks to the Tableau Server• Analyze data for alignment to the data dictionaries• Perform daily data transformations• Analyze data, identify data integrity problems, analyze data for alignment and integration to the data dictionaries, data transformations• Create and modify Oracle Views, Modification of Stored Procedures within the Oracle Environment, and Extract, Transform, Load (ETL) process management• Develop and test Complex SQL queries/dashboards for visualization and presentations to the DOD ODCMO/Defense Business Council-Investment Review Board and associated directorates• Daily data preparation for ingestion into the development/test repository and the BI environments• Daily generation of data flow models to be disseminated to the Directorate• Creates sustainable data connection methods/extraction capabilities

• Structuring Cognos Framework utilizing Cognos Framework Manager, Report Studio, Analysis Studio, and Query Studio across all DCMA business lines • Provide daily Software Development Report sustainment • Provide daily Help Desk support• Perform daily analysis utilizing TOAD (Oracle) for data verification• Perform daily data analysis of report outputs across development and production environments.• Perform daily data integrity problems, analyze data for alignment and integration to the data dictionaries, and data transformations• Create Cubes/Packages bases on end user requirements• Perform daily analysis of Cubes/Packages

• Support the automated/manual methods used to collect data from various authoritative sources using Oracle Business Intelligence 11g, SQL Developer 4.0, Tableau 81, 8.2., and MS Excel/Access 2010 which is used as the ETL process by which Tableau 81,. 8.2., is used to create the final visualization, as well as ad-hoc reports creation upon request. • Analyze data, identify data integrity problems, analyze data for alignment and integration to the data dictionaries, data transformations• Create and modify Oracle Views, Table creation Triggers, Procedures, and ETL process management for data extraction• Develop and test Complex SQL queries/dashboards for visualization and presentations to the DOD DCMO/IRB and associated directorates• Prepare data for ingestion into the development/test repository and the BI environments• Create Data flow models to disseminate to the Directorate.