Jake Bilich Email & Phone Number

San Francisco, California, US

New York, NY, US

San Francisco, California, US

Boston, Massachusetts, US

Boston, Massachusetts, US

San Jose, CA, US

During this internship, I built a foundational analytics framework by developing ETL functions in R to process 18M+ rows of customer and manufacturing data. I applied clustering techniques (K-Means, DBSCAN) to identify performance discrepancies in internal components and used predictive models (random forest, logistic, and tree regressions) to forecast.

Boulder, Colorado, US

As a Teaching Assistant, I guided undergraduates through fundamental SQL concepts and practical data management skills using MySQL. I helped students learn how to approach new databases, design schemas, and leverage data to address real business questions. By the end of the course, students understood the principles of data modeling, database systems, and.

Brentwood, Tennessee, US

• Reverse engineered an antiquated medical records database to extract, transform and load, relevant information into a new database to be used as evidence in a Medicare fraud case
• Designed analytics to aid executive decision making, enhance departmental operations, and optimize end-user experience
• Defined a governance structure to catalog, prioritize and resolve 1,500 system issues. Results included implemented solutions for all patient safety issues, as well as a 75% reduction in issue count

Brentwood, Tennessee, US

• Expedited $2.5M in revenue generation, by designing and implementing an automated system to process 75,000 pharmacy charges. The solution created financial stability, and avoided manual entry cost of $18,750 assoc..
• Migrated 25 years of medical records from a legacy health record software system to a new database
• Conducted Time-Driven Activity Based Costing research initiatives to provide healthcare executives with a comprehensive view of the true cost incurred to provide specific patient care services
• Developed a SharePoint site to be used as the primary tool for project prioritization, tracking and management for a community hospital

Dallas, Texas, US

• Provided go-live support for an enterprise-wide upgrade of Epic electronic health record software
• Developed an ICD-10 resource site in SharePoint to be used as by over 4,000 UT Southwestern employees

Tampa, Florida, US

Participated in a 10-day practicum program where I conducted market research on user engagement data and financial analysis on competing EHR vendors. I presented my findings to the product management team and senior VPs, recommending several ways to better target and improve marketing messaging to current and prospective practice managers.

Austin, Texas, US

During this internship, I supported the Texas Comptroller’s Data Services team by validating data on bond-financed school construction costs, helping the state save thousands of dollars. I collected and analyzed NAEP data to understand ethnic disparities in student performance and contributed to the 2012 Comptroller’s Financial Allocation Study of Texas.

Masters Of Science, Business Analytics

Bachelor Of Arts (B.A.), Economics

Health Information Technology And Health Information Exchange Certificate, Healthcare & Technology

Education record