Travis Douglas Email & Phone Number

Chicago, IL, US

Chicago, Illinois, United States

• Migrated existing on-premises ETL data pipelines to the cloud for a property management company with 26,000+ homes and 74,000+ residents, using Amazon S3, Glue, Athena, Redshift and Power BI.
• Worked as a key member of the central data management team to create new star schema data models for the most critical business processes and entities, forming a Single-Source-of-Truth for analytics and reporting on a.
• Leveraged dbt to modularize data transformations and Athena SQL window functions to efficiently process financial data, decreasing pipeline execution time from hours to minutes, empowering our rent collections team to.
• Developed tools with Python and SQL for the data engineering team to compare data between legacy data stores and new systems, speeding up pipeline migration and data QA.
• Designed and implemented a change management and code review process using Gitlab and dbt-expectations tests for pipelines running on the data lake, increasing development efficiency and avoiding data quality incidents.
• Compiled and distributed data lakehouse release notes to our internal users, and wrote documentation to onboard new data users to the AWS + Power BI platform.

Evanston, IL

• Built data pipelines for x-ray scattering image processing using Python, SQL, and Bash scripting.
• Automated error detection in the data collection phase using Python.
• Developed algorithms for model selection by analyzing data-fitting residuals.
• Built Python modules for non-linear regression and parameter estimation using Lmfit (Python).
• Created publication-worthy images to visualize complex data using Matplotlib and Seaborn.
• Managed scientific research projects from design through proposal, data collection, analysis, and publication.

• Instructed undergraduate laboratory-based physics classes with 20+ students.
• Developed and headed a new teaching assistant training process for the NU Physics department.
• Improved the curriculum and grading policies of the lab classes by leading a joint grad student-faculty task force.

Chicago, Illinois, United States

• Performed data exploration and analysis of millions of S&P500 index options trades using Pandas and Scikit-Learn.
• Used analysis results to evaluate the predictive power of emerging algorithms for options pricing.
• Created visualizations to communicate results to partners using Matplotlib and Seaborn.

Rochester, New York, United States

• Provided technical support to university faculty and staff users of web-based course management applications.
• Wrote and maintained program documentation on the company Wiki for both end-users and support staff.
• Collected and communicated user-requested features to upper management and app vendors.