Dyanna Hess-Miller

Offering Database expertise in all data management, including data modeling, data administration, and data analysis.

Contracts include:

• Huntington Back 9/2022 - 1/2023 - Reprogram the QRM application to migrate QRM-specific transformations out of the pre-QRM data table and into the QRM application’s ETL module. (7 month contract)
• TrustedQA- Naval Air Systems Command NAVAIR 02/2023 - Current - Senior Data Analyst supporting the DECKPLATE (Data Mart) database. Performing Data Analysis and Research on critical Naval Aviation Data, including Maintenance, Flight, Inventory, Supply, Maritime, etc.

• Designing a Data Mart for the Dept
• Of State OSIS II program to periodically extract and integrate data from multiple operational source systems into an environment optimized for analytical processing to support data analysis and visualization via dynamic reports and dashboards
• Using Visual Studio SQL Server Integration Services (SSIS) to create ETL mappings to pull data from various source systems (SharePoint, Unanet, Excel, and flat files) and transform the data into SQL Readable data to be migrated into MS SQL Server
• Used Amazon AWS RDS MS SQL Server Database instance in the US Gov West (GovCloud).
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Gathered, defined and refined requirements, led project design and oversaw implementation

• Involved in MSSQL Server Database programming activities, including requirement estimation, mock-up, prototype design, and testing, as well as writing supporting documentation, including code comments
• Creating SSIS Control Flow and Data Flow ETL tasks, establishing and troubleshooting ETLs, and creating SSIS Connection Managers
• Report creation and management in SSRS
• Identified issues within databases, performed troubleshooting, and implemented effective solutions.
• Uploading large amounts of data from flat files to SQL Server using bulk insert tasks
• Job creation and management for SQL Agent
• Developed scripts and processes for data integration and maintenance.

Providing database administration, systems analysis, testing, and integration for Commerce Business Systems (CBS) Solutions Center (CSC)

• Administrated, maintained, and monitored production and non-production data & databases
• Installation of OBIEE 12.2, Fusion Middleware/WebLogic 12.2 servers
• Performed Oracle Database upgrades 11G to 12c, 12.1
• To 12.2; database Migration
• Patched applications for database environments & Perform Transport Data Encryption (TDE), & Apply quarterly security patches (CPU) to customer instances
• Performed extensive PSU WebLogic patching, Critical Patch Update (CPU) for database & its Applications using O Patch & run installer
• Set up database jobs to execute ad-hoc PL/SQL as well as procedures used to validate data, modify data, or gather table and index statistics at regular intervals
• Managed database user security, security access, data maintenance, backups, restores, replication, & data integrity auditing of data structures & applications
• Planed Backup/Restoration Strategy, scheduling Backups, performed RMAN backups
• Identifying, researching & resolution of security vulnerabilities Scans
• Provided daily oversight of database systems including establishing & managing database accounts, privileges & resources, & assurance of security & data integrity
• Ensure Compliance with data management standards from (NIST)
• Run complex analysis on security incidents & threat data, Use in-depth research to inform & derive Dept
• Commerce remediation process
• Provide review & analysis of vulnerability scan results from tools such as Nessus, Web-Inspect, IBM App-Scan

• Database Developing/Administration support as part of DevOps as part of Agile Process
• Provide database support during major weekend deployments for Passport Services
• Developed and saved all database objects, documentations, diagrams into Team Foundation server using Visual Studio
• Developed and tested high-level tables, views, procedures, and triggers using Oracle PL/SQL and SQL Server T-SQL and implemented into database production environments (Oracle 11g and SQL Server 2008) within the Passport System for the U.S
• Department of State
• Tested and debugged new and Ad-Hoc queries to ensure T-SQL code follows Standard database requirements
• Analyzed business requirements and database design specifications for new Passport system processes that will be implemented into the current SQL Server Passport database
• Design/reverse engineer data-models to review and meet requirements to the database

Team Project lead supporting CGI Federal in developing a Prototype for the ARMY TRAINING INFORMATION SYSTEMS (ATIS) which will merge all training databases into a single Database for the new design of the ATIS interface.

• Creating Schemas, designing table structures, creating views, and Relational Data models and logical flow charts for the ORACLE 12c ATIS repository
• Loading Army provided data from various authoritative data sources into the ATIS development environment
• Converting of SQL Server, excel file formats, and GIS database tables to the Oracle database tables
• Creating Ab-initio ETL processes to move data from source databases to the ATIS Repository based on Prototype requirements
• Meeting with Program managers/System administrators/ Oracle DBAs on best practices for developing an Oracle Database
• Provided direction to technical staff to ensure database standards are incorporated to ensure deadlines are met
• Created program-level documentation for a Silent installation of the Database and backup scripts of the Oracle 12 C database into the AWS GovCloud environment
• Assisted technical writers in designing the Database Architecture
• Collaborating with the Functional team to design a database crosswalk document to determine what tables will be needed to populate the new UI for the ATIS prototype.

• Database Developing/Administration support as part of DevOps as part of the Agile Process
• Provide database support during major weekend deployments for Passport Services
• Developed and saved all database objects, documentation, diagrams into Team Foundation server using Visual Studio
• Developed and tested high-level tables, views, procedures, and triggers using Oracle PL/SQL and SQL Server T-SQL and implemented into database production environments (Oracle 11g and SQL Server 2008) within the Passport System for the U.S Department of State
• Tested and debugged new and Ad-Hoc queries to ensure T-SQL code follows Standard database requirements
• Analyzed business requirements and database design specifications for new Passport system processes that will be implemented into the current SQL Server Passport database
• Design/reverse engineer data models to review and meet the requirements to the database

• Created custom Extract Transform and Load (ETL) workflows using Informatica on a Netezza Platform supporting Department of Treasury reconciliations for Department of the Navy General Ledger systems, accounts, and balances.\
• Leveraged ETL tools for relational and dimensional data modeling to document data architecture including detailed analysis capturing the nature of Slowly Changing Dimensions (SCD) for needed information/data related to Navy Appropriations and funding across the Future Years Defense Program (FYDP), defined environmental fact tables for related dimensional information, transformed relational to dimensional through data modeling capabilities
• Combined and blended data from disparate financial data systems using PostgreSQL for the Fund Balance with Treasury multi-billion-dollar Navy appropriations total to create automated reconciliations and data reports associated with 400+ feeder systems and 12 general ledger systems in support of Financial Improvement and Audit Readiness (FIAR).

• (ARBA) data warehouse, Develop and maintain data interfaces and ETL Processes using SQL Server Integration Services -SSIS
• Creating and modifying reports using SSRS to load into the SharePoint Portal for analysts to view
• Creating and modifying T-SQL stored procedures and views using Microsoft SQL Server to populate new/existing tables to be used in the SSRS reports
• Acts as back up to the SQL Server DBA when needed
• Review of object and data models and the metadata repository to structure the data for better management and quicker access
• Participation in user requirements meetings
• Maintaining administration and SOP documentation
• Translate business needs into data architecture solutions

• US Airforce F-35 Joint Strike Fighter Program (JPO)

• Project: DEA- Federal Government Document and Media Exploitation (DOMEX) office