Stephen Brock Email & Phone Number

Washington, Dc, Us

• Built a framework for A/B testing of rental car pricing, with a data pipeline involving AWS S3, Databricks and Tableau.• Developed a Tableau dashboard to display A/B test results and KPIs for senior leadership.• Gathered, analyzed, and transformed large sets of transaction and fleet data into business models using SQL.• Lead the data science team’s transition to Databricks and onboarded colleagues on useful features.

• Developed and maintained micro services including a Flask RESTful API, asynchronous celery task queue, and an event-driven notification service to facilitate tracking of organ shipments.• Created unit and functional tests in Pytest to identify bugs and ensure stable releases to production.• Conducted exploratory data analysis using SQL and Python to identify and resolve telemetry data issues in production environments.• Designed and implemented updates to database schema via Alembic migrations.• Assisted in a refactoring effort to clean up old test suites and legacy code to improve application performance.• Designed and implemented a data analytics dashboard to analyze shipment trends and facilitate external reporting processes.• Spearheaded the implementation of OpenAPI/Swagger documentation to enhance transparency and collaboration between the engineering and QA teams.

• Designed and built dashboards to monitor current and past production, employee/product performance KPIs, and team resource allocation.• Developed and tested complex SQL queries and stored procedures to increase the efficiency and accuracy of the monthly data validation and reporting process.• Performed ad-hoc SQL querying and reporting to support line of business and product owner requests.• Innovated non-Excel-based data validation solutions utilizing Python and SQL to meet enterprise-level EUCT reduction initiatives.• Streamlined multiple operational and ETL processes using VBA and SQL that resulted in significant FTE reduction.