SUMMARY:

• Software Developer and Software Engineer, Data Architect, DBA and Project Manager who has successfully designed, developed and deployed internal proprietary enterprise software solutions
• Extensive SQL Server and Oracle DBA expertise in data modeling, design, deployment of OLTP and OLAP systems
• Expertise in T - SQL writing/debugging stored procedures, triggers and user defined functions
• Highly proficient with SQL Server reporting services for server side and client based reporting
• Skilled in clinical workflow analysis; clinical business intelligence and functional health systems support
• Proficient in database performance tuning, index analysis and query optimization
• Highly skilled C#, .NET professional with over 20 years of design and development experience
• Proficient in OOD, SOA, .NET, Framework Design, Web Development and Database Architecture
• Ensures rigorous application of information security and information assurance policies and practices
• Proven technical leader with experience as an architect, technical lead, mentor, team lead, manager and project manager
• Adept at managing teams to implement project plans and meet defined objectives
• Proven attention to detail and solid problem solving skills in fast-paced environments
• Articulate, confident communicator experienced with written and oral presentations

TECHNICAL SKILLS:

.Net (version 5): C#, .NET, WPF, WCF, ASP.NET, Web Services (SOAP, REST), Unity

ORM Tools/Frameworks: Entity Framework (4,5,6), LINQ to SQL, NHibernate (open source)

Web Development: JQuery, AJAX, HTML5, JavaScript, CSS, XML

Database / Language: SQL Server RDBMS ( 2005 to 201 6), Transact SQL (TSQL), CACHESQL (Mumps), Oracle 11, PSQL, MySQL, DB2, Sybase

Database Management Tools: Microsoft SQL Server Management Studio, SQL Profiler, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Toad for SQL Server

Design Patterns / Architecture: MVC (4,5,6), MVP, MVVM, SOA, OOD, TDD

Process / Methodologies: Agile, XP, UML, RUP

Virtual Environments: VMWare, Hyper-V, VirtualBox

Enterprise Services: Microsoft Biztalk Server 2006-201 3, IBM MQ Series Messaging

Messaging Standards: HL7/CDA 2.0

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lewis

Senior Systems Specialist

Responsibilities:

• Plan, develop and maintain database management systems within department and program framework, priorities and established goals.
• Lead data architect for data model normalization and query optimization of SQL Server application data stores
• Provide technical guidance and instruction to functional users, managers and application programmers.
• Maximize effective use of data storage and memory resources; reduce data redundancy; performance tuning and optimization of queries
• Development of a prototype mobile hospital application to assist Madigan patients with clinic visits using the MobileSmith development platform.
• Configured and installed security principles and protocols for SQL database applications; developed data marts and warehouses for end user query and reporting analysis
• Implemented data backup and recovery procedures and operations to ensure high system availability and reliability
• Tested and evaluated hardware and software solutions to meet the needs of our customer requirements and system specifications
• Monitor and access deployed applications for performance and troubleshooting issues; testing and deployment of enhancements and defect resolutions.
• Led a team of 6 on design and development of a web-based enterprise self-service Point of Service Kiosk and survey system for patient check-ins (CHCS) and clinical survey administration.
• Created and managed logical and physical data models for application databases, including normalizing and even de-normalizing databases for performance and tuning of large-scale OLTP applications
• Review and design of replication strategies for consolidation of in-patient and out-patient data sources (CHCS, Essentris) into regional data marts for consolidated provider dashboards
• Design of normalized data views and reports using SQL Server Reporting Services for end-user access and dashboard use
• Design and development of ETL packages for data integration and migration needs using SQL Server Analysis Services
• Utilize system analysis, data and process modelling across projects to ensure delivered systems meet required functional and performance specifications
• Implement secure access to clinical systems using public/private key and certificates (PKE) as well as Active Directory authentication.
• Implement public systems access using traditional user account credentials, SMS two-factor authentication with OAuth authorization
• Designed, built and maintained an Microsoft Biztalk B2B patient referral tracking system using an HL7 278 messaging for authorization message exchanges (B2B).

Key Technologies: include SQL Server 2005-201 6; SSRS; SSAS; Biztalk; Visual Studio 2013/2015; C#; ASP.Net

Confidential, Fort Lewis

Senior Developer

Responsibilities:

• Design and develop data integration solutions bridging disparate systems for enhanced clinical dashboards and reports utilizing SQL Server 2005; SQL Server reporting services and SQL Server Integration Services.
• Configured and installed security principles and protocols for SQL database applications; developed data marts and warehouses for end user query and reporting analysis
• Implemented data backup and recovery procedures and operations to ensure high system availability and reliability
• Tested and evaluated hardware and software solutions to meet the needs of our customer requirements and system specifications.
• Monitor and access deployed applications for performance and troubleshooting issues; testing and deployment of enhancements and defect resolutions.
• Team lead for the Medical Survey software application utilized across various Western region locations to pre-screen soldier readiness as well as administer pre and post deployment surveys
• Developed and deployed an HL7-based patient consult-authorization system to replace a fax-based workflow
• Lead an effort to extend our existing CDA-based message application (MERIT) to enable consolidation of patient ER encounter notes from Essentris (in-patient system) to the CDR in near-real time
• Managed and supported the IT efforts of the PPR (OTSG) group for fielding the ANAM TBI pre-screening tool and other TBI-related initiatives.
• Managed resource allocation and task schedules; interface with senior command members and architected solutions to medical data privacy and data integrity needs.
• Supervised contract resources for extension and development of core applications.

Confidential, Fort Lewis

Senior Research Scientist / Senior Developer

Responsibilities:

• Worked to implement web-based educational and informational materials for the testing and treatment of mild Traumatic Brain Injury.
• Supporting the PR&R office efforts to field a web-enabled TBI-testing tool with a consolidated reporting database.
• Working to implement reporting image output of TBI metrics into the service-wide medical systems (AHLTA, HRR).
• Designed and developed applications for inventory tracking and financial budget tracking in support of program management.
• Key technologies in use include Oracle 10, MS SQL Server 2005; Visual Studio .Net (C# and ASP.Net), as well as administration of purchased web content management tools.

Confidential, Riverdale, MD

Test Director

Responsibilities:

• Worked to establish the core test strategy and Quality Assurance processes and procedures for a b2b project serving a key Government agency.
• The project was a multi-year effort and part of a larger, intra-governmental financial management systems streamlining initiative.
• Responsible for high level test planning; test environment configuration and operation; test resource staffing and management; and implementation of manual and automated test processes and tools to ensure project success.
• Work with the data and infrastructure team, development, business SME’s and key stakeholders to ensure delivery of proper functionality and of production-ready quality.
• Develop and implement processes and procedures to support a phased deliverable approach.

Confidential, Washington, DC

Project Manager

Responsibilities:

• Managed a team of Quality Facilitators and PM’s in preparation for SDLC phase gate reviews required prior to production execution for Restatement applications.
• Worked with PM’s and project resources to develop project plans; schedule milestones; align resource and provide guidance on ability of key deliverables and processes to withstand internal and external audit.
• Worked with business leads and testing resources to construct and review test strategy; system integration and UAT plans and post-execution business validation procedures.
• Facilitated QA phase gate review sessions with senior management, business and technical architects, operations leads, risk analysts and key business/technical managers to ensure production readiness.
• Worked across enterprise infrastructure groups to ensure projects met internal audit and SOX and operational readiness criteria.