Michael Poremba Email & Phone Number

San Jose, California, Us

Seattle, Wa, Us

Enterprise data architecture; ETL standardization; API standardization; Databricks.• Key projects: Enterprise data lakehouse design based on a medallion architecture; Multi-tenant health data platform; Data modeling and API endpoint design for multi-tenant data products; Relational data models of FHIR resources• Lead - Enterprise Architecture Guild• Healthcare IT: FHIR, clinical terminology coding systems; identity resolution; master data management• Technologies: Databricks, AWS, Azure

San Francisco, California, Us

Data Engineering team lead for a healthcare data management startup that provides real-world evidence data products for clinical research partners.• Leadership: Provided technical design of new features for research data pipelines. Managed a globally distributed Data Engineering team in the developing new features. Supported data deliveries to research data partners. • Key project: Led Data Engineering team in delivering a research data platform providing research-grade clinical data hosted on BigQuery and built using a dbt data pipeline orchestrated using Airflow.• Developed a data ingestion process for clinical data cuts in Python.• Migrated clinical OMOP ontology data published by OHDSI Athena.• Healthcare IT experience: OMOP, Datavant tokens, C-CDA, clinical terminology coding systems.• Technologies: GCP, BigQuery, dbt, Postgres, Python, Node.

Chicago, Il, Us

Director of Data Architecture team and lead data architect for an electronic health records (EHR) service used by 100,000 healthcare workers managing 150 million patient medical records at 25,000 medical practices. Managed a distributed team of 10 data architects and data engineers.• Leadership: Hands-on technical manager for data team employees and contractors, lead data architect, deep technical guidance, automation and tooling, process improvement, technical training, coding standards, agile, HL7, FHIR.• Key project: AWS data pipeline for calculating clinical quality measures.• Data engineering: Work with product engineers and product managers on data models, implementing product features, data analysis, services architecture, code reviews, uptime deployment to production databases, security threat modeling, root cause analysis, design and implementation of ETL to data lake and data warehouse.• Healthcare IT expertise: EHR, HL7, FHIR, C-CDA, clinical terminology coding systems.• Technologies: SQL Server AlwaysOn, AWS Redshift, Step Functions, Glue, MongoDB sharded clusters, Postgres, microservices and SOA, C#, Python, HL7, FHIR, ER/Studio, database CI/CD pipeline using Red Gate and Jenkins.

San Francisco, Ca, Us

Senior Director of Data Architecture for a cloud-based electronic health records (EHR) startup. Managed 5 data architects in a 75-person US engineering team.• Data architecture: Managed data modeling, implementation, and deployment of new product features. Designed FHIR clinical data store. Close collaboration with regulatory and legal teams on sensitive issues around security, compliance, privacy and data analysis.• Key project: Technical design and project lead for 4TB audit tracking and reporting subsystem.• Performance and scalability: Design and performance tuning of transactional databases > 20 TB. 40,000 transactions per second, over 800 entities, spanning 40 databases. Data modeling, performance monitoring, identify and prioritize performance bottlenecks, application performance optimization, high-performance data access methods, design of database servers for performance and high availability.

Amsterdam, Noord-Holland, Nl

Data architect for medical imaging startup, acquired by Philips. High-performance medical imaging service deployed globally at 400 hospitals, with 5 PB data distributed on commodity hardware and SQL Server clusters. 100-engineer team distributed globally.• Data architecture and technical design: HL7 clinical data repository, image storage, REST API design, coding standards, database performance tuning.• Data infrastructure: Designed a high-performance, highly available database server for large customers using commodity server hardware.• Healthcare IT: PACS, RIS, HL7, IHE, DICOM, FDA 510(k) regulation.• Coaching: Agile development and design, coding for performance and scalability, relational databases, data access.

Foster City, California, Us

Data Architect for Visa Resolve Online (VROL), the transaction dispute management system used by Visa member financial institutions. 80-engineer technology team distributed globally.• Data architecture: Data modeling and implementation, data migrations, OLTP scalability testing, performance tuning, coding standards, code reviews, production deployment. Designed an ITIL configuration management system.• Team coaching: Data access methods for high-performance transaction processing.• Data migration: Designed and created a framework for modeling data migration rules and generating code for data migrations. Sped up development, improved accuracy and added new capabilities for data migrations.• Testing: Teamed up with customer acceptance test leads on data migration testing for product releases. Resulted in faster product validation and greater confidence in test results.

Burlingame, California, Us

Data architect and database tech lead for real-time targeted ad startup. Member of a 15-person US engineering team. Responsible for requirements refinement, design, implementation, and performance optimization of database applications for targeted ad system.• Architecture: Data modeling, database implementation, and testing for high-transaction media targeting engine, publication process for targeted media content, high-performance real time geo-spatial targeting, data warehouse, and data mart.• Database performance: Scaled media targeting engine to millions of ads with complex ad targeting rules maintaining 50-millisecond response times.• Analysis and design: Concept definition and requirements refinement, UX application design, technical design.• Technical team lead: Work breakdown, progress tracking, risk management, coaching engineers.

Software engineering consultancy and incubator to Bay Area startup companies.Hello Asia: Consumer rewards system for Asian audiences. Web architect of five-person development team.• Business requirements, database design, web application architecture, localization strategy for five Asian languages.Macromedia: High-traffic consumer entertainment web site. Tech lead for four-person development team.• Rapid solution definition, prototyping, Flash integration, object-oriented design, business systems integration.• Led web application development team, performance optimization, transition to client operations teams.Cadence Design Systems: Corporate knowledge management web portal. Seven-person development team.• Designed security subsystem and localization strategy, facilitated application design sessions.• Prototyping, MVC pattern, UI libraries. Technical coaching of team members.

Bachelor Of Science, Computer Science

Bachelor Of Arts, Philosophy