Sandra Walker

Defense Health Agency - J5 Analytics & Evaluation (remote)

• Responded to data requests from Defense Health Agency leadership for clinical and operational decisions using SQL on AWS Redshift and SQL Server Management Studio.
• Created data models using SQL from two platforms for patient resource utilization and illness burden to guide staffing at treatment facilities.
• Conducted root-cause analysis for anomalies in dashboards with expertise in validating dimensional model databases.
• Mentored new analysts on databases and electronic healthcare records systems.

Department of Defense Hearing Center of Excellence (hybrid)

• Collaborated with principal investigators to refine data sharing agreements for submission.
• Defined data elements for limited datasets and ensured de-identification compliance according to HIPAA Safe Harbor methods to support at least six or more research projects containing PHI/PII.
• Extracted data from SQL Server and AWS Redshift with over 80 databases for approved data request submissions.
• Advised principal investigators and research teams on optimal data sources for research projects.
• Trained new analysts on Military System Health data sources for effective analysis.
• Mentored team members in combining datasets to meet project requirements.
• Evaluated data sources from two different data warehouses to assess quality and determine deliverable requirements targets.
• Completed CITI Human Research training focused on biomedical investigations and research ethics (2022).

Air Force Medical Operations Agency - AFMS Analytics (on-site)

• Collected and transformed structured/unstructured data for enterprise reporting including KPI, metrics, and ad hoc analysis.
• Led development of patient-level registry database for 3M+ TRICARE members with Asplenia anatomically or functional.
• Re-coded SQL scripts and restructured monthly HEDIS SSIS packages for reporting on 15+ metrics across 74 healthcare facilities for 1.3 million beneficiaries.
• 
  

Air Force Medical Services Agency - Healthcare Informatics Division (on-site)

• Developed SQL codes for portions of measures for the DHA HEDIS software according to annually published technical specifications for compliance audits.
• Offered technical assistance and customer support for data collection and processing of NCQA HEDIS measures, including various Healthcare Informatics Division projects for 9.4M beneficiaries.
• Created Excel workbooks with pivot tables/charts, calculated formulas, with data connections refreshes.
• Assisted IT Systems Engineers, DBAs with data definitions and relationships from legacy warehouse to a new platform Teradata Studio for dimensional modeling methods.