Drive stability, reliability, and performance by optimizing in-application SQL statements and user focused databases. Develop SQL Server Integration Services (SSIS) included designing new programs to ingest data into MHS Information Platform (MIP) part of the United States Defense Health System. Member of SQL team of analysts involved in software upgrades and deployment capacity planning hardware and software integration and back-up strategies. Gather requirements from business analyst, develop physical data models using Erwin, and created DDL scripts to design database schema and database objects. Determined storage growth and implemented measures to maintain it. Developed reports per Business Requirements and created various reports like Summary reports, Tabular reports, etc. Use SQL queries to obtain data from multiple tables to spool data into CSV formats and provide extracts to business and users. Conducted research to enhance programming techniques SQL usage and data access. Used CERNER HealtheAnalytics to provide analytic focus on Access to Care data to include key performance indicators (KPIs), reports, and data models. Took these reports and used Tableau and SAP BusinessObjects to isolate specific underlying variables into visualization dashboards.

Installed SAS Enterprise Guide and Maintenance on Laptop Computers. Member of SAS team of analysts involved in software upgrades and deployment capacity planning hardware and software integration and back-up strategies. Determined storage growth and implemented measures to maintain it. Extensive use of PROC SQL, PROC FREQ, PROC SORT to perform queries, join tables. Developed routine SAS Macros to create tables/libraries for inclusion in daily, weekly, and monthly Analytical Reports. Developed reports per Business Requirements and created various reports like Summary reports, Tabular reports, etc. Conducted research to enhance programming techniques SAS usage and data a access. Exported data to Excel and Access for reporting, summarizing, and created bar graphs and charts in Excel, and integrated data from different systems into an Access database. Assisted with redesigning TRICARE Operations Center (TOC) website using SharePoint and migrated the site to the Health.mil website.

Performed all aspects of database administration, including data modeling, backups, replication and recovery. Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) included designing new programs and debugging existing programs. Maintained, debugged and optimized existing data warehouse system and streamlined batch process. Wrote stored procedures and Transact SQL code as well as VB script. Created Perl, SQL queries and scripts to update and create tables, extract data for uploading, reporting, analysis and data consistency checks. Exported data to Excel and Access for reporting, summarizing, created bar graphs and charts in Excel, and integrating data from different systems into an Access DB. Convert and modify existing matrix reports from Crystal to a more dynamic reporting tool utilizing Excel Pivot Tables and Power Pivot.Redesign new Tricare Operations Center website using Dreamweaver and migrated the new site to the Health.mil website. Currently redesigning all of Tricare Operations Center numerous reports from basic Excel to Pivot Table style reports.

Installed new 8.0 SQL Servers and maintained eight servers. Performed all aspects of database administration, including data modeling, backups, replication and recovery. Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) included designing new programs and debugging existing programs. Maintained, debugged and optimized existing data warehouse system and streamlined batch process. Wrote stored procedures and Transact SQL code as well as VB script. Created Perl, SQL queries and scripts to update and create tables, extract data for uploading, reporting, analysis and data consistency checks. Exported data to Excel and Access for reporting, summarizing, created bar graphs and charts in Excel, and integrating data from different systems into an Access DB. Convert and modify existing matrix reports from Crystal to a more dynamic reporting tool utilizing Excel Pivot Tables and Power Pivot.

Support the operation of the M2 Data mart in support of Defense Health Service Systems (DHSS) Project Office. Development effort includes planning and design stages, identifying system requirements for operations and testing (technical and functional), and working with other M2 developers, testers, and functional analyst to develop new functionality. Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models. Implement data security guidelines while making data available to those authorized to have access. Capacity planning and analysis and implement required changes on the database server. Create data processing documentation as changes occur in migration to new data feed sources to help functional staff perform their duties.Technical duties require installation and configuring new DB2 releases, upgrades and fix packs to maintain database currency. Daily efforts include monitoring production, test, and development servers for system performance, system availability, monitor disk space and take corrective actions for file space clean up in the event of disk shortages, monitor system logs and availability through monitoring software, provide backup and restore for multiple machines using TSM. Analyze DB2 event monitor information, physical design, performance characteristics of table spaces, physical I/O rates and table access activities. Creation and modification of primary database storage structures (table spaces) and primary objects (tables, views, indexes). Developed ETL scripts using SQL and Korn Shell to ingest data into the M2 Data Warehouse