# Thomas Uchiyama Aguilar

> Senior Software Engineer @Ideon

Location: Brooklyn, New York, United States
Profile: https://flows.cv/thomasuchiyamaaguilar

Software Engineer @Ideon. Working to improve healthcare navigation through
data, technology, and transparency.
Engineering Technologies: Ruby on Rails, Rust, Postgres, Elasticsearch, git, Terraform, Docker, AWS services (Lambda, Step Functions, S3, EventBridge, SQS, Aurora/RDS, CodePipeline, Athena, etc)
Data Analysis Technologies: R, STATA, SAS, WinBUGS

## Work Experience
### Senior Software Engineer @ Ideon
Jan 2016 – Present | Greater New York City Area
Building data pipeline infrastructure and APIs to provide greater transparency
into the health insurance market (insurance quoting, provider network directories,
and drug formularies).

### Director of Data Operations @ Ideon
Jan 2018 – Jan 2019 | Greater New York City Area
Oversee data operations for Ideon's health insurance data products.

### Programmer Analyst II @ UCSF
Jan 2014 – Jan 2016
- Lead data analyst and programmer for cahealthcarecompare.org, a price and quality transparency tool for health care in California
- Statistical analysis for clinical and policy research using large commercial/medicare
claims and EHR data
- Writing and contributing to manuscripts and technical documents.
- Provide analytical and programming support and training to address needs of
clinical researchers

### Analyst @ OnPoint Analytics, Inc.
Jan 2014 – Jan 2014
- Applying statistical and econometric methods to financial and economic data in R and STATA
- Managing large proprietary datasets using SAS and STATA in linux environment
- Preparing expert reports, trial exhibits and other presentation materials for the court in ongoing legal proceedings

### Statistical Consultant @ Columbia University Mailman School of Public Health
Jan 2013 – Jan 2014
- Simulating egocentric network data using Exponential Random Graph Models in R to test sensitivity of measurement error, analyzing results and comparing them to observed network data. 
- Building Bayesian hierarchical models in R/WinBUGS to investigate the influence of violence exposure on post-traumatic stress symptoms using complex-survey data of 900 Rwandan children within orphanages who experienced the 1994 genocide. 
- Providing ad-hoc support for statistical analysis and graphics, study design and manuscript writing.

### Data Analyst @ Columbia University in the City of New York
Jan 2012 – Jan 2014 | New York, NY
- Providing statistical expertise for study design and sample size calculations, data analysis, technical document preparation for hypothesis-driven research projects.
-  Performing regression analysis, Bayesian hierarchical modeling and predictive analysis, EFA/CFA factor analysis and structural equation modeling, multiple imputation of missing data in R, WinBUGS and STATA
- Building data infrastructure for remote data collection and automate daily and weekly reports of ongoing survey and test results for quality assurance using SQL

### Graduate Research Assistant @ Columbia University Mailman School of Public Health
Jan 2011 – Jan 2012 | New York, NY
- Developing a R program to decompose the trends of Malaria prevention and treatment among children in Sub-Saharan countries working with clustered survey data and incorporating bootstrap sampling weights to produce unbiased confidence intervals of non-linear functions.
- Performing survival analysis of national insurance uptake of pregnant women in Ghana to determine the effects of the location healthcare and antenatal services were provided. Responsible for developing the statistical analysis in STATA and reporting on the findings.

### Teaching Assistant @ Columbia University Mailman School of Public Health
Jan 2011 – Jan 2011
Department of Biostatistics - Analysis of Categorical Data


## Education
### Master of Science (M.S.) in Biostatistics
Columbia University

### Bachelor of Arts (B.A.) in Economics & Mathematics
University of California, Santa Cruz


## Contact & Social
- LinkedIn: https://linkedin.com/in/thomasaguilar

---
Source: https://flows.cv/thomasuchiyamaaguilar
JSON Resume: https://flows.cv/thomasuchiyamaaguilar/resume.json
Last updated: 2026-03-31