Allen Davis Resume

Veteran Canteen Service (VCS) Point of Sale (POS) and Automated Information System (AIS)

Senior Database Engineer | March 2023 to Present

• GovCIO

  March 2026 to Present

• Cognitive Medical Systems Inc.

  April 2024 to March 2026

Overall: May 2023 to Present

• Developed SSIS-based ETL processes to migrate legacy Oracle data to modern SQL Server schemas.
• Architected least-privilege database designs with view-based interface layer with lookup tables and temporal tables which improve audit performance by 25% over traditional triggers.
• Automated database deployments using Visual Studio SSDT database projects with unit tests for SQL Server deployments, ensuring 100% consistency across dev, test, and production.
• Modernized BI Publisher report views, enhancing query performance by 20% through optimized T-SQL and PL/SQL scripts that eliminated stale data staging tables and cursors with real-time views.

Veteran Tricare

Senior Database Engineer | May 2023 to March 2023

• Cognitive Medical Systems Inc.

  December 2023 to April 2024

• VIA Technical

  May 2023 to December 2023

Overall: May 2023 to April 2024

• Designed and implemented rule based bi-directional data synchronization between Oracle 19c and SQL Server 2022 for VA Tricare.

Michigan Disease Surveillance System (DSS)

Senior Database Engineer / Lead Database Administrator | February 2022 to February 2023

Altarum Institute

February 2022 to February 2023

• Led database modernization and redesign managing Oracle 19c databases in a Kubernetes-based, cloud-first architecture.
• Designed Solr / Elastic Search targeted views with denormalized full-text search, improving query response time by 35%.
• Implemented slowly changing dimension (SCD)-based rollback processes, allowing users to audit all changes and provide point in time rollback.
• Automated database integrity scans reducing bad-data related dev downtime from hours to minutes daily.
• Automated deployments using Flyway, achieving 90% uptime across dev, test, and UAT environments.

Michigan Syndromic Surveillance System (MSSS)

Senior Database Engineer / Lead Database Administrator | February 2022 to February 2023

Altarum Institute

February 2022 to February 2023

• Led modernization to replace Oracle with a Postgres database
• Implemented role based access using table valued functions.

Consolidated Mail Order Pharmacy (CMOP)

Senior Database Engineer / Lead Database Administrator | July 2016 to February 2022

• PingWind

  Apr 2021 to Feb 2022

• Innovative Management Concepts (IMC)

  Aug 2017 to May 2021

• Document Storage Systems (DSS)

  May 2017 to May 2021

• Cornerstone Automation Systems (CASI) , (via TEKsystems ), Tucson, AZ

  Jul 2016 to Mar 2017

Overall: July 2016 to February 2022

• Supported 16 SQL Server databases for the VA's Consolidated Mail Order Pharmacy (CMOP), processing 117M prescriptions annually across seven facilities.
• Developed stored procedures and functions to standardize business logic, reducing processing errors by 20%.
• Created SSIS packages to replace linked server connections, improving data transfer efficiency by 30%.
• Designed automated data validation and mismatch detection processes, generating HTML-formatted alerts to ensure patient safety during deployments, reducing deployment analysis time by 80%.
• Led PHI/PII data scrubbing for non-production environments, ensuring compliance with VA security standards.
• Trained 20+ new hires in database orientation, improving team onboarding efficiency by at least 50%.
• Created dynamic SQL based process to autogenerate when a holiday fell and if it was moved from a weekend to the nearest Monday or Friday.

Arizona Health Care Cost Containment System (AHCCCS) Reinsurance Reporting

IT Systems Analyst | February 2016 to July 2016

Banner Health (via TEKsystems ), Tucson, AZ

February 2016 to July 2016

• Six Month Contract to prepare for new Arizona Health Care Cost Containment System (AHCCCS) contracts.
• Built PL/SQL stored procedures and Excel macros to automate data processes, reducing manual reporting time by 15 hours weekly.
• Performed ad-hoc Oracle queries to support business intelligence reporting for healthcare operations.
• Created dynamic SQL based process to autogenerate when a holiday fell and if it was moved from a weekend to the nearest Monday or Friday.

North Carolina MILES DMV Contract

Software Developer / Senior Test Engineer | August 2012 to July 2015

Opus Inspection (formerly Systech) , Tucson, AZ

August 2012 to July 2015

• Developed T-SQL scripts and views for vehicle inspection databases, improving data retrieval speed by 25%.
• Designed ETL processes to integrate external data sources, ensuring data integrity for state compliance reports.
• Led fraud detection module design and development using VB.NET and T-SQL, adopted across multiple inspection projects. This provided inspectors with real-time flags of suspected fraudulent inspections.
• Spent over 100 days travel in Raleigh / Durham, North Carolina at customer testing facility over the project ensuring non-compliant but certified equipment worked with our system.

Hospice of the Valley | Software Support Administrator | April 2008 to August 2012

Hospice of the Valley (HoV) , Phoenix, AZ

April 2008 to August 2012

• Charged with planning, integrating, testing, documenting, troubleshooting problems, diagnosing, and maintaining systems-level computer hardware and software technologies, with a focus on operating systems and integration with applications, databases, equipment, and communications networks.
• Served as designated ISS contact and resource for user departments, and director level management to develop business and information requirements. Assisted in design, code, and test peer review sessions throughout life cycle to identify tuning and optimization opportunities as well as undocumented issues.
• Oversaw configuration, installation, and support of all client IT equipment to ensure optimal performance using established configuration standards, tools, and procedures.
• Created UI data entry screens using Cerner's HomeWorks system, performed testing and troubleshooting support for profiles, crystal reports, custom modules developed in-house, and issues with 3rd party data import files. This reduced data entry errors in managerial reports, allowing better planning.
• Assisted with the upgrade of 400+ laptops to support new software versions and provided top-level support to the helpdesk for issues related to the development team and the clinical support team. Scripts reduced time per device by 50%.

University Physicians Healthcare | Oracle Forms and Reports Developer | Jan 2007 - April 2008

Oracle Forms and Reports Developer

University Physicians Healthcare (UPH)

Jan 2007 to April 2008

• Lead developer on the NCPDP 5.1 pharmacy data import into Oracle, process involved data validation, error checking, and conversion as vendor used AHCCCS 1999 update instead of the 2007 AHCCCS NCPDP update; programmed new internal process for hex/decimal combination delimited files using Oracle PL/SQL. This work eliminated an annual subscription for 3rd-party conversion.
• Installed enterprise-wide systems and trained end-users in the operation of Oracle web reports menu, Oracle Forms, and Reports; programmed and automated a laptop maintenance system in Oracle Forms that interfaces with the helpdesk tracking system to create work-order tickets.
• Developed Extraction, Transformation, and Loading (ETL) processes to acquire and load data from internal and external sources while working closely with the Encounter and Finance/Reinsurance teams for the automation of Excel spreadsheets imports into Oracle reports using PL/SQL, massively increasing the performance of a department.
• Programmed support Encounter reports to maintain better the reprocessing reports, HIV drug report, and an associated Oracle form for end-user maintenance of the approved drug list as well as automated bump reports for end-user comparison of data sources, including IDX and AS400.
• Created, documented, and automated a process of remote connecting to computers for command line maintenance using Sysinternals tools without end-user interruption or log-off, resulting in significant time saving for both technicians and other employees across the agency.
• Produced claims data extracts for use by 3rd party consultants and vendors in requested custom formats.

University Physicians Healthcare | Help Desk Computer Technician | June 2005 to January 2007

Help Desk Computer Technician

University Physicians Healthcare (UPH)

• Oversaw creation of support tech specific documentation and automation scripts for use in hands-on training in areas of installs, file copies/updates, and registry modifications including automation of common security policies including disabling support for USB drives and marking all non-hard drives as read only to protect data security; which reduced the incidence of data loss when directions were not followed.
• Managed remote configuration, password resets, and on-site service for many of the corporate software systems and participated in the rotation for on-site and after-hours on-call support for clinics and UPH Hospital.
• Collaborated with the Team Manager in supporting and maintaining the categories, detected software and computer inventories, and remote capabilities in our work order tracking system, Track-It, as well as performed after-hours initial computer rollout of computers to a new location in Phoenix.
• Led documentation creation for use in training employees in everyday tasks that generated helpdesk calls, maintained the structure of installation software, and documentation. Allowed junior technicians to perform specific senior-level tech tasks.
• Performed creation and maintenance of sysprep ghost images, achieved department and user-specific configuration changes to computers before delivery.
• Managed the design of documentation checklists, increasing quality by 30%.