Jon Tavernier

My Resume Jon Tavernier

[email protected] | 312-623-8660 | jontav.com

Summary

I am an IT professional who enjoys designing, building, documenting, and implementing scalable analytical data solutions and pipelines, including extracting, integrating, and adding value to terabytes of complex data from both internal and external sources. I like helping teammates learn to do the same as well.

Experience

Zoro

- present

Staff Data Engineer, Data Engineering Team, - present

I help gather and make data easier to use for folks at Zoro. Here is how I help do that in Google Cloud Platform:

  • Implement and maintain scalable cloud-computing solutions for large-scale data processing.
  • Design batch and streaming data pipelines, data-movement standards, and patterns.
  • Share knowledge, write technical documentation, and set up local development.
  • Help other data engineers on the team with all of the above.
  • Environment: BigQuery, Apache Airflow (Cloud Composer), Pub/Sub, Docker, Kubernetes (GKE), Cloud Run, Apache Spark (Dataproc), Apache Beam (Dataflow), Terraform, Jenkins, Git, SQL, and Python.

Senior Data Engineer, Data Engineering Team, -

  • Led the technical direction of Zoro's Data Platform team, launched a new analytical technology stack on Google Cloud Platform, and helped teammates in many areas.

Raise Marketplace

-

Senior Data Warehouse Developer, Data Team

  • Partnered with data scientists and data analysts to understand business needs and data, developing easier-to-use, integrated data sets focused on supply, demand, purchases, buyers, sellers, web and mobile sessions, and transactional and campaign email messages.
  • Helped replace a legacy analytical data solution by designing, developing, and implementing a new analytical data store in Google BigQuery, including conceptual, logical, and physical designs of denormalized tables that drive self-service analytical capabilities in Looker.
  • Acquired and integrated data from more than 15 sources, including Adjust, Desk.com, Salesforce, Algolia, Google, Firebase, Sailthru, Linkshare, and Promoter, by interacting with REST APIs and batch exports.
  • Investigated production issues including zombie processes spawned by Docker containers in Kubernetes, stuck Apache Airflow DAGs, missing vendor data, data-quality concerns, slow queries, and high CPU usage.
  • Identified business and technical needs, shortlisted solutions, and created technology proof of concepts.

Allscripts

-

Expert Software Engineer, Care Management & Care Director Team

  • Led and supported the Allscripts Care Management and Care Director SQL Server data warehouse environments, their customers, real-time reporting, analytical queries, and data-loading processes.
  • Collaborated with internal business analysts and external customers to define requirements for data products such as data marts, SQL Server Reporting Services reports, and data extracts.
  • Developed utilities in Python and C# to aid troubleshooting efforts and reduce development time.

Networked Insights

-

Senior Data Engineer, Architecture Team

  • Oversaw a Pivotal Greenplum data warehouse environment, a massively parallel processing shared-nothing database technology, including its storage, performance, and availability.
  • Designed, built, loaded, and maintained denormalized, distributed, and partitioned data structures.
  • Enhanced and created more than 20 PL/pgSQL analytical functions used by a customer-facing web application.
  • Aligned the team's deployment process with that used and supported by other groups within the company.
  • Created Google BigQuery ETL logic to incrementally extract data from terabytes of JSON documents, transform it into smaller relational data sets, and load the results into append-only tables.
  • Investigated technologies including AWS Redshift, Azure Data Warehouse, ScaleDB, MySQL, and PostgreSQL.

Northwestern University: Northwestern Medicine EDW

-

Chief Data Architect and Manager of Source System Loads, -

  • Managed ETL processes that acquired data from more than 100 source systems representing dozens of storage technologies into the EDW environment, requiring frequent collaboration with other teams.
  • Planned and developed data structures in a 20+ terabyte Microsoft SQL Server 2012 environment to integrate and deduplicate data from dozens of clinical applications, including Epic, Cerner, and Athena.
  • Created, researched, and encouraged best practices in information architecture, SQL Server Integration Services (SSIS) ETL, SQL query optimization, data materialization, design reviews, and team processes.
  • Interviewed and evaluated candidates for Data Architect, Data Warehousing Specialist, and Power User roles.
  • Managed the migration of 157 SQL Server Agent jobs to a new server and established owners for every job.

Data Architect, -

  • Developed a Cerner inpatient-vitals data mart standardizing more than 100 million rows of data over ten years.
  • Extracted, loaded, and transformed data using SSIS from sources stored in Oracle, SQL Server, PostgreSQL, Informix, XML, CSV, Access, Excel, and text files.

Northwestern Medicine: Northwestern Medical Group

-

Application Programmer Analyst II, Clinical Information Systems Team

  • Acted as liaison to the Division of Cardiology's physicians, nurses, and professional staff, incorporating business and clinical requirements into the Epic electronic medical record (EMR) and other applications.
  • Extended Epic EMR functionality by proposing, designing, and coding more than 55 projects in InterSystems Caché (MUMPS), many of which improved integration between Epic and other applications.

Epic Systems Corporation

-

Technical Services, MyChart Application Team

  • Supported large health care organizations, including Fairview and Kaiser Permanente, and their IT and business-office professional staff with installations of MyChart, Epic's patient-portal web application.
  • Identified, captured, and analyzed workflow business requirements to develop technical-solution specifications using Epic Programming Points, Visual Basic, ASP, JavaScript, XML, HTML, and CSS.
  • Worked closely with InterSystems Caché, a NoSQL database management system, and Epic Chronicles.

Education and Certifications

  • Fellow, Association of American Medical Colleges Information Resources Leadership Institute,
  • Business Analyst Certification, Northwestern University School of Continuing Studies,
  • Bachelor of Science in Computer Information Systems, Indiana University Kelley School of Business,