=== Data Engineering and Projects ===** Contact Details Pipeline **- Created Airflow-scheduled, Docker-hosted, Hive-persisted data pipeline- Used discrete transformations, allowing data analysts easy inspection of ETL steps- Created Python driver for interacting with partner API- Cached documents to S3, avoiding duplicative requests- Worked iteratively with product managers to identify desired job titles and define filtering rules- Cleaned, normalized, and validated resulting data before ingesting into DB** People Data Ingestion **- Improved an inherited Python / Flask ingestion process- Stored full JSON responses rather than immediately processing, recognizing business process boundaries- Worked with partner and AltX biz teams to expand data collection and handle schema "upgrades" dictated by partner- Established schema versioning to allow reprocessing / reingestion of full data set (idempotency)- Validated ingestion SQL stored procedures** Financial Data Ingestion **- Used Python to transform nested JSON document into flattened JSON ready for insertion into DB- Added in extra layer of abstraction / mapping to meet concurrent engineering challenge of fast-moving project** SSO Integration **- Used SAML-to-JWT authentication service to facilitate access to our product- Built test setup from sample OneLogin account, proving process and determining integration parameters- Worked with DevOps to shift dev/QA environment authorization onto newly-configured account** Simhash Persistance Pilot **- Used MongoDB and Redis to persist simhash / id pairs=== Full Stack Engineering ====** Product Development **- Developed incremental features for and helped maintain Python / Flask / Angular-based site- Used internal Flask-based library to send email alerts containing SendGrid-embedded API hooks- Retrofitted code to make use of harmonized SQLAlchemy queries in a shared package- Enhanced Celery-scheduled Elasticsearch indexing process

​=== Core Product ===- Developed our Python-based DB management suite: implemented new features and tools, fixed bugs- Worked on ClustrixDB codebase (written in C): wrote new features, fixed bugs, wrote unit tests- Supported our Django codebase (for our WebUI), doing full-stack development (pure Python, Django framework, JQuery / Javascript) and launching a unit test framework (QUnit and PyUnit)- Worked on our Ruby on Rails-based next-generation WebUI- Developed collaboratively using tools such as Bugzilla, Buildbot (for continuous integration), Mercurial (hg), and ReviewBoard- Used various IDEs / authoring tools as appropriate (Eclipse, vi/Cscope, Sublime Text, MySQL Workbench)​=== Internal Systems and Tools ===- Created and maintained our Python-based AWS provisioning tool (leveraging the Boto API)- Refactored major parts of our Python-based QA infrastructure, disaggregating monolithic functions and revising to follow PEP8- Tightened QA infrastructure object scopes, coalesced forked code via class inheritance, and rewrote tests using PyUnit and mock- Created Python-based DB performance testing framework (fPerf) and performance reporting web tool (krampus)=== Evangelism ===- Implemented Clustrix / Ruby on Rails Performance Benchmark test (automated with Python)- Authored RoR Performance Benchmark Whitepaper: http://goo.gl/4QX7sg- Gave keynote speech on RoR Performance Benchmark at Percona NYC 2012: http://goo.gl/hML5xu (intro and @ 11:00)=== Professional Services ===- Built PoC using Pivotal Cloud Foundry PaaS: developed Clustrix service broker API, BOSH release package, and Pivotal product “tile”- Implemented VMWare’s vSphere environment to provide IaaS backing to Cloud Foundry- Led successful migration of key customer’s DB migration from Heroku-hosted Postgres to Blue Box-hosted Clustrix- Designed and implemented unique customer migration solutions using Apache / PHP, Tungsten Replicator filters (Java), and custom desharding code (Python)

- Conceived of, developed business logic Java classes for, and designed user interface for Android-based app examining European sovereign debt issues (“EuroCrisis Explorer” - Beta release deployed to the Android Market but since removed)- Developed backend PHP code and MySQL database to perform data scraping and server-side calcs for EuroCrisis Explorer- Designed and coded Android-based arcade/action-style game (“Kittehz” (unreleased))

- Programmed and integrated logic controllers, operator interfaces, software packages, and equipment from a wide variety of manufacturers- Created custom applications backed by MSSQL Server, using Crystal Reports for DB visualization- Integrated RFID antennas and tag tracking systems with batching / supply chain management systems- Authored project proposals and bid documents; defined firm scopes and budgets for projects- Met with clients to analyze their project requirements and to market consulting services- Traveled to client sites around the US and internationally to commission and support projects- Worked with clients from many industries: bio / pharma (ALZA, LifeScan), food (C&H Sugar), oil / gas (Plains LLP, Alyeska), manufacturing (Toyota), chemical (General Chemical, Rohm & Haas), utilities (PG&E, CalPine), government (Seattle Sound Transit, SF PUC, UC Davis), environmental (LFR)- Adjusted project courses mid-execution to balance project scope and costs with customer satisfaction- Developed contacts with new clients while continuing to work with established clients

- Developed COM/Active-X components using Visual Basic for production line monitoring systems- Authored parameterized SQL statements to store, manage, and retrieve operational data- Developed Visual Basic / MSAccess-based defect tracking application- Integrated third-party software (such as graphing packages) to minimize development time and lower costs- Assisted with requirements gathering / analysis and functional specification development- Hosted clients for customer factory approval testing and QA procedures- Developed software tool to deterministically rewrite logic controller code from version 3 to version 5 (new hardware platform and mildly different instruction set)- Worked extended hours when required to reach project milestones by their assigned deadlines- Traveled to customer sites to start up and integrate custom products (both foreign and domestic travel)