Co-founder
2012 - PRESENTAppian Data Services- Developed and maintained a financial reporting suit and budgeting application used by thousands of managers, executives, and analysts within a large healthcare system in California.
- Built subject-oriented data marts, complex business logic in SQL queries, and Tableau dashboards for multiple customers within health systems.
- Assisted multiple health system clients with ERP (WorkDay) and EHR (Epic) migrations, including requirements gathering, reverse engineering business logic, validation, and refactoring.
Technologies: SQL, MySQL, APIs, Tableau, Tableau Server, Financial Forecasting, Anomaly Detection, Budgeting, Financial Reporting, Dashboards, Business Intelligence (BI), ETL, Data Engineering, Azure SQL, Amazon S3 (AWS S3), AWS RDS, AWS Lambda, Cloud Infrastructure, Healthcare IT, Data Visualization, T-SQL, Azure, Business Logic, MariaDB, GitHub, Data Warehousing, Data Science, Relational Databases, Amazon Web Services (AWS), Google Sheets, Data Analysis, Azure SQL Data Warehouse (SQL DW), Jupyter Notebook, Databases, Schemas, Data Analysis Consultant, Data Management, Reporting, BI Reports, ETL Tools, Data Warehouse DesignHealthcare System Integration Consultant
2022 - 2023Kannact- Advised the CTO on data interoperability options in the context of a rapidly shifting competitive landscape with changes in the regulatory and technical frontier.
- Conducted research to anticipate the impact of regulation on the opportunity to build new data-sharing arrangements between diverse players.
- Collaborated with vendors to build a set of options for the client to build internal tools to interact with.
Technologies: Electronic Medical Records (EMR), Electronic Health Records, APIs, API Integration, JavaScriptData Engineer
2021 - 2022Pfizer - PGS Operations Insights- Served as the primary data engineer building a resource optimization application to increase the on-time completion rate of critical processes to guarantee drug safety and learn from history.
- Designed the DB schema for permissions, team dynamics, and work history. Pulled data from Redshift, Neo4j, and APIs that hooked into ML models.
- Optimized code to onboard new sites as users, allowing them to quickly build teams, assign work, and track progress against targets and history.
Technologies: Data Engineering, SQL, ETL, Data Modeling, Data Pipelines, Python, Cypher, GraphDB, Neo4j, Data Lakes, Databases, Schemas, Data Management, Redshift, Star Schema, Data Warehouse DesignConsultant Data Engineer
2021 - 2021Groups Recover Together- Recovered logic from an ineffectively documented EMR database to build a set of revenue cycle management KPIs for a behavioral health startup.
- Designed and implemented data mart for RCM and financial reporting; created complete documentation for the data mart to hand off to internal resources.
- Created a weekly scorecard for presentation and analysis in Tableau.
- Assisted in the design and execution of automated validation checks to establish a source of truth for the organization.
Technologies: Azure SQL, eClinicalWorks, Tableau, SQL Server Management Studio, Pandas, JSON, T-SQL, Business Logic, GitHub, Data Analytics, Relational Databases, Data Analysis, Startups, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI ReportsEconomist and Data Engineer
2021 - 2021USAID- Pulled data from Crunchbase to develop a database of investors, transactions, acquisitions, and businesses in Africa.
- Merged and cleaned pandas data and built Tableau visualizations to help the team explore data and assign industry mappings and geographical patterns.
- Quantified indirect international connections between investors and businesses to identify strategic relationships.
Technologies: Tableau, Neo4j, Pandas, Crunchbase API, Dashboards, Research, Econometrics, Business Intelligence (BI), Data Engineering, Finance, Economic Analysis, Economics, International Development & Economics, Data Visualization, Data Pipelines, Data Modeling, PostgreSQL, GitHub, Data Warehousing, Data Analytics, Relational Databases, Data Analysis, Microsoft Excel, Jupyter Notebook, Databases, Schemas, Data Analysis Consultant, Data Management, ReportingConsultant Data Engineer
2015 - 2020El Camino Health- Built a data warehouse and data integration layer as a platform for analysis of several financial and clinical information domains inside a growing health system.
- Automated reporting, developed analytical solutions to business problems, and translated business logic into technical terms to surface opportunities and threats to the executive team.
- Combined utilization data from ERM with materials spending from the ERP system into a clean data mart; built financial performance dashboards of orthopedic supplies utilization to reveal inefficient use of implants and update preference cards.
- Built a comprehensive view of profitability for physician groups and clinics, including physician scorecards and profitability by service.
Technologies: SQL, SSIS Custom Components, Tableau, Tableau Server, Microsoft SQL Server, Dashboards, SQL Server Integration Services (SSIS), Business Intelligence (BI), ETL, Data Engineering, Data Visualization, Data Pipelines, Data Modeling, SQL Stored Procedures, Stored Procedure, Dashboard Design, T-SQL, JSON, Business Logic, Data Architecture, Data Warehousing, Data Analytics, Relational Databases, Migration, Data Analysis, Microsoft Excel, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports, ETL Tools, Data Warehouse DesignData Engineer, Data Visualization
2017 - 2018A Surgery Center in California- Developed an income statement and balance sheet by service line and by surgeon for a surgery center.
- Created an ELT system integrating data from multiple vendor silos, including EMR system, surgical supplies system, time and attendance, and GL system.
- Designed and implemented data marts to read scrubbed data and feed clean views to the dashboard tool.
- Built dashboards to manage growth using profitability measures.
Technologies: Amazon S3 (AWS S3), Microsoft Power BI, Electronic Medical Records (EMR), Vendors & Suppliers, Profitability Analysis, Enterprise Resource Planning (ERP), Financials, APIs, Microsoft Access, SQL Stored Procedures, Stored Procedure, Dashboard Design, Business Logic, GitHub, Data Warehousing, Data Analytics, Relational Databases, Amazon Web Services (AWS), Data Analysis, Microsoft Excel, Startups, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports, ETL Tools, Data Warehouse DesignConsultant Data Engineer
2016 - 2016Tesla- Developed a test application to demonstrate the optimal approach to anticipating manufacturing problems in remote supplier factories before products arrived at assembly.
- Managed clients and a team of three engineers to beat deadlines and requirements.
- Built a test application in AWS and assisted internal resources with a plan to build an internal application based on our design.
Technologies: JavaScript, AWS Elastic Beanstalk, AWS Lambda, Python, ETL, Data Engineering, Amazon S3 (AWS S3), Cloud Infrastructure, Databases, ReportingData Engineer, Data Visualization
2008 - 2015Sutter Health- Developed and maintained in-house web-based financial reporting applications as the source of truth for thousands of internal users. The suite is still used heavily for reporting at Sutter today.
- Managed a small team of developers to add new features and maintain and validate pipelines and end-user features.
- Maintained a homegrown budget application with auditing features. Helped homegrown design budget build and spread applications used at all Sutter Bay area hospitals and foundations.
Technologies: SQL, SQL Server BI, SQL Server Integration Services (SSIS), Tableau, Tableau Server, Dashboards, Microsoft SQL Server, Business Intelligence (BI), ETL, Data Engineering, Data Visualization, Stored Procedure, SQL Stored Procedures, Dashboard Design, T-SQL, Business Logic, Data Architecture, Data Warehousing, Data Analytics, Relational Databases, Data Analysis, Oracle, Microsoft Excel, Reports, Databases, Schemas, Data Analysis Consultant, Data Management, BI Reporting, Reporting, Star Schema, BI Reports, ETL Tools, Data Warehouse DesignEconomist
2002 - 2006University of Colorado Boulder- Implemented techniques of optimal survey design to estimate choice parameter values.
- Used choice experiments to confirm social psychology predictions that having a companion and the companion's relative ability are critical determinants of site choice.
- Revealed that site choice models of recreation demand omit an endogenous variable—a result of a cooperative game: when they omit a companion's presence in the description of site characteristics.
- Contributed to the overall project. Additional information available at www.sciencedirect.com/science/article/pii/S1755534513000055.
Technologies: Survey Design, Econometrics, Data Analysis, Data Science, Economics, Discrete Choice Models, Experimental Design, Statistical Data Analysis