Sandra Marie W. Email and Phone Number

Analyze and develop meaningful data sets from disparate big data in high level data-driven solutions, research studies, and data requests to support and participate in clinical, business, and managed care knowledge for the Department of Defense (DOD) Hearing Center of Excellence, Department of the Army Residency Program.Acknowledged in submissions of research studies based of the data and guidance of the data submissions.

• Collected, cleansed, transformed, raw structured/unstructured data into meaningful actionable information to support enterprise reporting (KPI, metrics, balanced scorecards, ad hoc analysis, interactive querying).• Re-coded SQL scripts, views, and restructured monthly recurring HEDIS SQL Server Integration Server (SSIS) packages for Air Force monthly reporting requirements of 15+ metrics for 74 healthcare facilities aggregated for over 1.3 million beneficiaries with multiple demographics.• Delivered high priority data analytic requests such as Congressional inquiries and Freedom of Information Act requests with shifting priorities in a matrix organization. • Managed SQL processes, developed reports from multiple data sources containing electronic healthcare records from all beneficiaries that have received medical care using SQL Server Management Studio, Visual Studio.• Wrote SQL code for various clinical, business and ad hoc requests that required sound knowledge of source data from data warehouse to support dashboards and reporting.• Interacted with clients, technical team members, and project managers to advise best sources of data, qualify data sources, and provide level of effort to determine deliverable targets.Maintained weekly activity reports, work stoppage reports, monthly recurring transaction reports.• Attended division staff meetings, provided project status, identified necessary resources for projects.

• Wrote SQL codes for portions of measures for the DHA HEDIS software according to annual published technical specification for annual compliance audits. • Provided subject matter expertise in technical assistance and customer support for the data collection and processing of the NCQA HEDIS measures and many other HID projects covering 9.4M eligible beneficiaries.• Identified areas for standardized coding between all NCQA HEDIS measures which included creating measure-specific reference tables based on the new value set names layout, measure specific NDC pharmaceutical mappings.• Wrote programs using T-SQL, stored procedures, user-defined functions, dynamic SQL, declared variables supporting various projects used for enterprise reporting.• Created Excel workbooks with pivot tables/charts, calculated formulas.• Assisted IT Systems Engineers, DBAs with data definitions, relationships from legacy warehouse to a new platform Teradata Studio for dimensional modeling methods to create a general use data warehouse that supports both business and clinical analytic needs.

• Wrote SQL codes for portions of measures for the DHA HEDIS software according to annual published technical specification for annual compliance audits. • Provided subject matter expertise in technical assistance and customer support for the data collection and processing of the NCQA HEDIS measures and many other HID projects covering 9.4M eligible beneficiaries.• Identified areas for standardized coding between all NCQA HEDIS measures which included creating measure-specific reference tables based on the new value set names layout, measure specific NDC pharmaceutical mappings.• Wrote programs using T-SQL, stored procedures, user-defined functions, dynamic SQL, declared variables supporting various projects used for enterprise reporting.• Created Excel workbooks with pivot tables/charts, calculated formulas.• Assisted IT Systems Engineers, DBAs with data definitions, relationships from legacy warehouse to a new platform Teradata Studio for dimensional modeling methods to create a general use data warehouse that supports both business and clinical analytic needs.Peer reviewed SQL codes. Completed training in SAS Basic, SAS Essential Attended the AcademyHealth Conference in Seattle, WA Jun 2011. Member of the AcademyHealth Association.

Served on a team of Air Force and contractor personnel consisting of web-developers, database administrators, and data analysts. Developed clinical and managed care metrics supporting U.S. Air Force Medical Service executive level initiatives. Played a key role in analyzing mental health beneficiary data in support of the University of Rochester Medical Center USAF suicide study. Served as the lead data analyst for the Air Force Surgeon General P2R2 performance metrics tool. Developed MS transact SQL queries and data transformation services for producing Access to Care metrics, equivalent visits, and provider availability (appointment template management). Served as the Air Force military health systems Data Consultant for the Access to Care metric for the P2R2 website and the P2R2 Virtual Analyst. Provides Tier 2 levels help-desk questions from customers for the P2R2 website. Creates, validates, and tests SQL code when changes are required upon the functional owner’s request. Lead analyst for all of the organization’s data and information products providing corporate decision support to the Air Force Medical System. In-depth knowledge of military healthcare information systems and the data they produce. Thoroughly experienced with data integration of over 20 different health source data systems both military and civilian. Successfully developed and implemented quality control, quality assurance and testing processes for information products in keeping with the concepts traditionally only applied to software development. Developed the corporate quality control documentation, which provides the technical specifications, data sources, data requirements specifications, requirement changes, and data caveats for client deliverables. Served and the San Antonio manager of 4 employees in the San Antonio office which included performance management, mentoring, and recruitment.

• Led analysts for data and information products providing corporate decision support to the Air Force Medical System.• Developed clinical and managed care metrics supporting U.S. Air Force Medical Service executive level initiatives.• Analyzed and provided data requirements for mental health encounter and claims data in support of the University of Rochester Medical Center and the U.S. Air Force Suicide Study Developed multiple pharmaceutical data requests from AFMS relating to clinical studies such as Type II Diabetes population mapping for corporate pharmaceutical marketing strategies and other pharmaceutical company marketing inquiries through approved channels.• Developed TSQL queries and data transformation services for producing Access to Care metrics, equivalent visits, and provider availability.• Provided Tier 2 level help-desk questions from customers for the P2R2 website. Created, validated, and tested TSQL code when changes were required upon the client’s request.• Developed the corporate quality control documentation, including technical specifications, data sources, data requirements specifications, requirement changes, and data caveats for client deliverables.• Lead the Private Sector Care Recapture Model. This model was an MS-Access stand-alone application updated on a quarterly basis.• Managed San Antonio employees which included performance management, mentoring, training and recruitment.