TECHNOLOGY• Database Architecture and Data Modeling• TSQL Development, Stored Procedures, User Defined Functions, Views, Indexes, Tables and Partitioning• Disaster Recovery• Optimization & Tuning• SQL Agent, SSIS, SSRS• MS Excel• MS Visual Studio 2019DESCRIPTIONResponsible for Database Administration. Also reverse engineering legacy ASP system into SSIS. Aiding in the migration to Microsoft Azure environment. Data investigation into data anomalies in the existing system. Optimization and tuning on existing environment. Maintaining the database security model. Recommendations on space and memory requirements for a more stable environment. Optimization and Tuning the existing database structures.

TECHNOLOGY• Database Design• MS SQL TSQL Development, Stored Procedures, User Defined Functions, Views, Indexes, Tables• MS SQL Backup & Recovery• MS SQL Optimization & Tuning• MS SQL Agent, SSIS• MS Visual Studio ASP.Net/VB.Net - Net Framework 1.5• MS Excel including Pivot• MS Visual StudioDESCRIPTIONCustom frontend entry points. A commercial package project entry process was complex, required multiple data entry points which lead to errors and omissions. Developed a single point of entry application that eliminated bottlenecks. This cut down on the data entry process from weeks to minutes.Using complex calculations to distribute budgets over the project lifecycle (Project, Phase, Task, and Organization) to produce KPI’s that provided instantaneous feedback to the current status of the project.Integration of multiple data sources (Project Management, Financial, Accounting, CRM, Payroll, IT Asset Management) into a single reporting structure. Rewrote the system using ASP.Net to develop a web-based solution to deliver reports REAL-TIME.Document management system. The engineering firm has massive amounts of scanned images, plots, designs, documentation, and scanned forms & correspondence. Developed a solution to be able to search this vast library of documentation from multiple physical locations across the WAN spanning multiple cities and locations.Nightly processes to sync multiple systems with related data. To reduce duplicate entries into multiple systems, developed a solution to ‘Sync’ these systems with data from a single data source.Integrated Error Capturing within applications. Web-based solutions continuously capture application errors and report error information back via email. Building solutions to these errors with all the error information dramatically cut down the communication pipeline trying to determine and solve the issue.

TECHNOLOGY• Database Architecture and Data Modeling• MS SQL TSQL Development, Stored Procedures, User Defined Functions, Views, Indexes, Tables and Partitioning• MS SQL Backup & Recovery• MS SQL Optimization & Tuning• MS SQL Agent, SSIS, SSRS• MS Excel• MS DevOps• MS Visual Studio 2019DESCRIPTIONDatabase support for multiple AWS environments including database design/architecture as well as installation and ETL packages to support data transfers and import. Heavy use of Spatial data for GIS applications. Extensive application of table partitioning and backup/restore processes as well as AWS S3 use.

TECHNOLOGY• MSSQL• Data Modeling• ETL Design – SSIS• MS SQL AgentDESCRIPTIONDeveloped ETL packages in SSIS for unloading and reloading an 11TB data warehouse to facilitate new schema changes.

TECHNOLOGY• MSSQL• SSIS• Azure• MS SQL AgentDESCRIPTIONEnhance and maintain the current data warehouse in Azure. Optimization and Tuning of existing databases.

TECHNOLOGY• Database Design and Architecture• MS SQL TSQL Development, Stored Procedures, User Defined Functions, Views, Indexes, Tables• MS SQL Optimization & Tuning• Table Partitioning• MS SQL AgentDESCRIPTIONArchitecture for the ingress of various databases (currently at 45TB) into a secured environment managing varying user group access to resources for research projects. Responsible for the optimization and tuning of deployed databases. Monitoring of user queries to anticipate assistance to optimize the access of data indexes and table partitioning.Building an automated database subset that combines data from the various databases that are specific to research project requirements for government agencies.

TECHNOLOGY• Database Design and Architecture• MS SQL TSQL Development, Stored Procedures, User Defined Functions, Views, Indexes, Tables• MS SQL Optimization & Tuning• Table Partitioning• MS SQL Agent• SSIS• MS Visual Studio 2015DESCRIPTIONDesigned and developed data structures and ETL packages to import data from multiple vendors to provide a data warehouse of patient demographics and claim data into a central repository for identifying patients eligible for services.