Jun 2024 – May 2025 · 11 mos · San Antonio, Texas Metropolitan Area · Remote

• Monitored and troubleshot high-volume SFTP pipelines to ensure education benefit payment data in PostgreSQL and Oracle met reporting requirements, enhancing overall claims data accuracy.
• Developed Python reconciliation scripts to align flat-file inputs with XML and CSS files, reducing payment discrepancies by 30%.
• Proactively identified pipeline and workflow risks, shortening hot-fix resolution times by 2 weeks through targeted SQL queries.
• Streamlined reporting team workflows by investigating flagged data issues, accelerating claimant error resolution by 25% and reducing daily working group meetings to weekly.
• Mapped and validated data into Amazon Redshift, improving reporting efficiency and enabling stakeholders to access accurate dashboards for payment status and errors.
• Created ad hoc SQL queries and dashboards to track batch errors, system issues, and payment exceptions, increasing operational transparency.
• Documented workflows and SOPs for handling sensitive VA education benefit data, ensuring consistent procedures and audit readiness.

Dec 2020 – Jun 2024 · 3 yrs 6 mos · Gonzales, TX

• Reduced payer denials by 12–25% across 7 clinics by analyzing claims data, identifying trends, and implementing process improvements.
• Decreased average Accounts Receivable cycle time by 2–3 weeks by reconciling claims, validating billing data, and supporting reporting workflows.
• Extracted/staged, cleaned, and analyzed clinical and claims data using SQL, Excel, and EHR systems (Intergy, eCW) to support reporting, audits, and operational decision-making.
• Developed standardized reporting and tracking processes for provider credentialing, claims trends, and operational metrics, improving transparency and audit readiness.
• Applied data governance principles to ensure HIPAA-compliant access, accuracy, and consistency across clinical, billing, and operational reporting.
• Trained consultants and staff on reporting workflows and insurance verification processes, ensuring adherence to operational standards.

Apr 2018 – Jun 2020 · 2 yrs 2 mos · Austin and San Antonio, TX

• April 2018-March 2020
• Owned contracting acupuncture business in Austin, San Antonio.
• Created websites for advertising and marketing for clinics, managed herbal and supplement inventory.
• Resolved IT/EHR issues during intake.

Jan 2015 – Dec 2017 · 2 yrs 11 mos · Austin, Texas Area

• Completed 972 hour graduate clinic internship at AOMA and several community clinics in Austin.
• Completed 3006 total didactic acupuncture/biomedical classes and clinical hours.

Mar 2004 – May 2012 · 8 yrs 2 mos · Austin, TX

• TBONE provides automated end-to-end system enterprise resource planning for
• all phases of the Air Operations Center (AOC) process. It features strategic,
• tactical and logistical decision support. TBONE aims to replace hundreds of
• disparate systems currently in use by the AOC. It is a traditional client-server
• application with most of the business logic living on a Java client and persistence
• handled by an Oracle database.
• ● Developed user interfaces with Java Swing and an in-house object
• relational mapping tool
• ● Overcame limitations of a historical query engine by implementing efficient
• client-side joins
• ● Implemented data visualizations with both traditional charts via a third party
• library and a custom tree that simplifies large object graphs
• ● Employed design patterns pragmatically to model domain entities and
• rules
• ● Refactored code
• CIDNE is a web-based reporting framework that serves to bridge disparate
• communities by providing structure to unstructured data. It supports workflows
• and advanced geospatial search capabilities. It is the primary reporting tool for
• operations in Iraq and Afghanistan with the aggregate data having visibility to the
• President of the United States.
• ● Designed key generation strategy for a multi-master replicated enterprise
• ● Debugged existing Lucene-based search subsystem
• ● Performed transformations with XSLT for loading third-party data
• ● Improved validation code by using regular expressions
• ● Trained new developers in best practices
• ● Created custom reports with in-house framework
• ● Engineered business rules with XML-RPC based web services