Zach Brookler

Data Engineer

Express Scripts•  July 2019 - Present

•Currently working on an application for users to email a file to a Sharepoint file repository to kick off an automated data loading process that uses the parameters supplied by the user. •Currently working on a SAS compiler that takes SAS files as input and compiles them in Python code. (This includes the use of packages such as pandas, pyodbc, and win32com) •Set up a tensorflow neural network that gets retrained on a weekly basis using Apache Airflow, keras, sklearn and pandas. •Maintaining previously developed code and applications. •Developed a new Tableau dashboard that showcases our analytical capabilities to prospective clients.

Data Engineer

Express Scripts•  January 2018 - July 2019

• Automated generation of PowerPoint presentation from Excel via VBA. • Designed Tableau dashboard for presentation to prospective clients. • Created custom Alteryx tool with customized HTML5 user interface. • Automated creation of folders and files using integration between Python and Alteryx • Working on SAS emulation software in Python

Market Analytics Intern

Express Scripts•  May 2017 - August 2017

• Tasked with integrating Alteryx into the department and showcasing how Alteryx could be used as a corporate standard for analytic processing. • Regarded as the Alteryx ‘expert’ at Express Scripts. • Created many new processes using Alteryx including a dynamic file loading interface, a macro that can run SQL containing volatile tables and efficient connectivity between Alteryx and Tableau.

Market Analytics Intern

Express Scripts•  May 2016 - August 2016

• Explored Express Scripts data warehouse environment, Teradata processing systems, and SAS, as well as learning about the Pharmacy Benefit Management industry. • Investigated how Alteryx could be used in the Market Analytics environment to improve overall analytical process efficiencies. • Developed a new process with Alteryx that efficiently consumes prospective client pharmacy claims data and provides intelligence to the pricing and sales teams.