Michael Amado Email & Phone Number

Berkeley, Ca, Us

San Francisco, California, Us

Designed and lead the development/release of Listing Fees and Subscriptions* 4 new services implemented by 3 teams, 11 devs* Node, Kotlin, DynamoDB, API Gateway, Lambda, Fargate, Snowflake, StripeDesigned Event Promotion and Tracking services* 4 new services, implemented with 4 other devs* Python, Lambda, Fargate, Aurora MySQL, Timestream, Kinesis, RetoolDrove plan to deprecate legacy email invitationsBuilt data pipeline of order conversions from Eventbrite to ToneDen product (Node)Assigned as technical advisor to 6 teams (4 marketing products, 2 email teams, integrations)Mentored 5 engineers, held office hours and wrote for the Principal Newsletter

San Francisco, California, Us

* Moved to internal incubator to collaborate with cofounder on experimental projects* Built Sponsorships feature to allow companies to submit sponsorship proposals to events* After a year of effort, deprecated Sponsorships and thoroughly deleted all traces* Took ownership of the new email service, resolved major stability/performance issues* Migrated all emails sent site-wide from Strongmail to SparkPost* Migrated email campaigns from SMTP to API sending for a 5-6x speed improvement

San Francisco, California, Us

* Mentored a 3rd backend engineer* Initiated, lobbied for and executed 2 major deprecation projects* Deleted the fundraising feature, 15,000 lines of code and 6 MySQL tables* Deleted the legacy analytics script that was the largest individual burden on MySQL* Part of the redesign team for the order confirmation email (sent after each ticket purchase)

San Francisco, California, Us

* Mentored two backend engineers* Built new backend to report page views by source to organizers (Kafka, Hive, Elasticsearch) * Deleted final dependencies on MongoDB and worked with Ops to remove it from our stack* Designed new system for grouping tracking codes into user friendly traffic sources* Wrote script to submit values in the database for translation (MySQL, Django, Transifex)* Gave presentations to new engineers: MySQL, deprecating code and site performance* Filled in for DBA consulting on MySQL table definitions and query performance* Major contributor on overhaul of user permission logic

San Francisco, California, Us

* Mentored my first backend engineer* Took ownership of backend infrastructure for all of Eventbrite's organizer facing reports* Built backend for reporting page views to organizers (Google Analytics, Hive, Elasticsearch)* Built feature to schedule and send daily reporting emails to organizers (MySQL, Celery)* Wrote Django command to carefully scrub junk data from MySQL without orphaning rows* Made authentication in webviews in the android native app seamless (Django middleware)* Pursued personal project to delete thousands of lines of legacy code* Charted and presented lines of legacy code over time (Git, Pandas)

San Francisco, California, Us

* Took temporary ownership of Business Intelligence while moving to software engineering* Managed direct report responsible for importing Salesforce data and Tableau administration* Designed new reporting schema with the Director of Data Strategy & Data Science Manager * Built daily Oozie job to import Google Analytics data from BigQuery to Hive tables* Built MySQL schema and script for company financial performance vs. annual plan* Assisted in hiring a Business Intelligence manager to replace me and a BI Analyst

San Francisco, California, Us

• Manager for projects across BI, BA and Data Science spanning all departments• Hired 5 analysts and managed an additional data scientist• Lead weekly analytics meetings and prioritized weekly and quarterly team goals • Managed the team that implemented Tableau Server, launched a crowdsourcing categorization solution, created the model for three annual financial plans and more• Continued to contribute individually to monthly, weekly and board meeting analysis• Designed the snowflake schema for our core reporting datamart• Wrote 5 of the Python/MySQL based ETL jobs for our datamart• Developed expertise optimizing MySQL performance• Member of team of 3 that built a new Hadoop based data warehouse (CDH5, Hive, Impala)

San Francisco, California, Us

• Primary analyst during a $50m funding round• Built the financial plan for 2012 ticket sales from non-sales accounts• Led the analytics meetings twice a week with the other 5 analysts• Interviewer for all analyst positions and most in finance• Trained two new analysts and taught a dozen employees to query MySQL• Responsible for reviewing work done by new analysts to ensure quality and accuracy• Regularly met with two engineering Scrum teams working on analytics, spam and fraud• Automated regular reports and did ad hoc analysis using MySQL, Hive, Excel and Matlab• Modeled the future financial value of free users

San Francisco, California, Us

• Primary analyst during two fundraising rounds, totaling $27m• Designed, automated and analyzed weekly/monthly reports for our executive staff and board• Ran ad hoc reports each week using MySQL, Excel and Matlab• Delivered meaningful insights to satisfy analytics requests from all departments• Analyzed links between accounts to capture spammers and fraudsters in bulk• Trained two new analysts for the Marketing and Sales teams• Calculated payouts for all affiliates and value added resellers• Reconciled reported revenue for the income statement (before we had an accountant)

San Francisco, California, Us

• Improved ROI definition and brought SEM campaigns to higher breakeven standard• Handled the complication of cohorts, conversion latency and revenue accrual over time• Restructured the tracking of SEM activity for more precise attribution (in use >10 years later)• Made the case to reduce employee resources invested in SEM and changed roles• Joined when there were <20 employees

• Worked as a full-time instructor in an educational garden program for middle schoolers• Guided six to ten middle school students through gardening projects daily

Bs, Engineering Math And Statistics

Education record