- Engineered data pipelines from Workday to Netezza using Airflow and dbt enhancing control and visibility- Introduced a dbt and SQL coding methodology, reducing code update time by 66% Details:Full Time Contractor - Temporary Role- Developed and implemented data pipelines from Workday to Netezza database servers using Airflow, enhancing data control and accessibility for the Finance and Research teams.- Leveraged dbt to transform the data and created an interactive graph visualization to track and showcase progress to stakeholders. This work, in addition to the comprehensive documentation of the Workday-Netezza workflow I initiated, significantly improved transparency and understanding of data management processes across the company.- Devised and applied an optimized SQL coding methodology that reduced code update time by 66%, resulting in cleaner, more maintainable, and readable SQL scripts. This strategy empowered the Finance team to adopt the logic into their own system, identified data entry errors, and offered deeper insights into grant allocation.

- Built predictive tools for clients using state of the art machine learning algorithms- Provided excellent, professional, and timely communication with executives and stakeholders- Focused on return on investment for clients and producing robust deliverables

Helped restructure the analytics data warehouse, building a well-documented, easy to use, single source of truth for company-wide metrics. Assisted in the speeding up of company-wide tables by 50% or more, by refactoring existing dbt models. Supported the data analysts and data scientists by reviewing their code via git and GitHub and by responding to adhoc requests. Supported finance and marketing with critical reports and dashboards so they could accomplish their regular OKRs.

Benchling is a software company supporting the biotech sector, with a mission to speed up the pace of scientific discovery.Responsibilities:- Designed and built the core data model for internal analytics at Benchling, the model which is used for all product analytics at the company today. - Implemented an overhaul of the analytics tracking system used at Benchling to capture data in a way that was both intuitive for our engineers and straightforward for our analysts.- Built end-to-end product metrics for several products, including the second-most-used product at Benchling, the Developer Platform (API and SDK), Insights (Benchling's Tableau), and finance. Resulted in data-driven product roadmaps for the first time in the company's history.- Built analyses, dashboards, and ETLs using Mode, Looker, dbt, and Snowflake, among other tools. This created company-wide tools are used by all teams, both individually and cross platform.- Created a novel system to safely refactor/clean up existing SQL code using dbt. This led to significantly lower downtime of ETLs and dashboards due to newly introduced bugs from unsafe refactoring.

- Developed TrueCampaignStory, a web app that discovers anomalies in political campaign spending, aiding watchdogs in their quest for transparency- Reduced, via this app, the amount of transactions that watchdogs must sift through by 92%- Deployed the web app with Flask on AWS after building the model based on gigabytes of data

- Used my experience and connections in the data science community to help create the Data Science major slated for 2020-21 school year- Used Mathematica/Sage extensively on large data sets while leading my research program in Mirror Symmetry, the math behind String Theory. Invited to present this work at Harvard University and the University of Alberta- Managed three classes each semester, mentoring and teaching about 100 students at any time. Received positive student evaluations for my lecturing style

- Discovered a $24 million data opportunity, leading to buy-in from the executive suite and prioritization by the relevant teams; solution in works at the time of my leaving- Built user lifetime value (LTV) models for each game studio in London using R- Created Tableau dashboard for Cross-Promotional Advertising team- Employed SQL extensively to create insightful analyses and dashboards based on terabytes of data- Detected cheaters in a newly-developed game using machine learning tool DBSCAN and Python

- First data hire at HackerRank. Reported directly to the CEO- Built company-wide business intelligence dashboard from the ground up, plugging into the company tech stack using Ruby on Rails and the Javascript library D3.js for advanced customized data visualizations and building custom data cubes (OLAP) for ultra-fast manipulation of data- Created advanced predictive analytics for sales and marketing, including a likelihood-to-churn model, using the APIs for Salesforce, Hubspot, Google Analytics, AdWords, and LinkedIn Ads

- Automated, with SQL, various processes that had been previously accomplished by copying Excel spreadsheets while helping the executive team solve a $150,000/month commissions issue

- Calculated the value of thousands of mutual funds per day and published to newspaper.- Promoted to team in charge of Norway's entire sovereign wealth fund holding $500 billion in assets.

- Gathered and analyzed data for national HIV study. Solved real time logistical problems

- Built self-driving car software based on an algorithm I developed using Bayesian Networks, a machine learning tool, to integrate sensor information