Summary
Fearless problem solver with a specialization in high scale analytic workloads running on Microsoft SQL Server. For the last 7 years, I have built understanding of each level of the SQL Server database ecosystem seeking to become an end-to-end expert.
Experience
Developer for a de-identified research data warehouse compiling information from over 100 million patients, focusing on improving efficiency and scalability of ETL process and end-user dashboard response time.
Collaborated with data scientists and physicians to design and build data models for studying the Covid-19 pandemic, datasets of which were published in Epic Health Research Network studies.
Designed and implemented functionality to connect physicians with other physicians treating patients with similar rare conditions or symptoms.
Conceptualized technical architecture to meet future functionality and scalability needs as defined by product managers. Participated in proof of concept leveraging Azure Synapse, Databricks and SQL Pools.
Evaluated new and upcoming technologies, including Microsoft Azure and AWS IaaS, Intel Optane, Oracle Exadata, HPE SuperDome Flex, and new releases of VMware vSphere and Microsoft SQL Server.
Communicated findings to customers as a presenter at yearly Epic XGM conference as well as an SME at onsite customer leadership retreats.
Conducted company-wide SQL Server SME, performing SQL code reviews, developing testing tools and methodology, and resolving customer escalations through system resource and query plan analysis.
Implemented and maintained production SQL Server cluster, providing developers with customer-sized environments for isolated performance and scalability testing.
Developed statistical models using R to forecast system resource requirements for Epic's customers, identifying future performance and scalability bottlenecks.
Provided technical and project management support for Epic's Cogito analytics platform running on both Microsoft SQL Server and Oracle, with a focus on academic and international customers.
Authored technical knowledge base articles on system monitoring, system setup, upgrade strategy and consideration, and reference architectures for implementing Epic Cogito on VMware and Hyper V.
Led the implementation of new technologies, including supporting Epic's first customer implementation in Microsoft Azure.
Education
Involvement
Attended PASS Summit in 2017, 2018, and 2019 and participated in seminars on Columnstore Indexes, Windowing Functions, Data and Analytic Solutions in Azure and Virtual SQL Server Performance.
Skills
Languages: TSQL, PLSQL, Powershell, R, Typescript, Python, .NET/C#, Spark
Software: Microsoft SQL Server, VMware vSphere, Hyper V, Oracle, SSIS
Technical Skills: Data Modeling, Custom ETL Development, System Resource Analysis, ETW and Storport Tracing, Azure IaaS, AWS IaaS
Self Evaluation
Internship
Projects
Certifications
Coursework
Awards
Publications
Languages
