Randy Avalos
Data analytics, econometrics, and cost benefit analysis in enterprise environments. Adept at working with R for data ETL, modeling, and reporting. Agile project management.
Professional Experience
Project Coordinator, Tesla / SolarCity
2015 - Current
Promoted from Contractor to Engineer, to Project Coordinator
Automated User Management
Developed user management strategy for internal video conference platform from scratch. Turned a passive business function into an active platform that increased efficiency.
- 42% reduction in average cost per user
- 19% increase in monthly active users
- Defined KPIs used for monitoring and finding troubled areas
- API interactions for monitoring and dynamically adjusting user privileges
- Automatic email nofitifactions and interactions
- A/B Test used to determine most effective communication in elliciting feedback
- Eliminated associated workload on users and IT support personnel
Ad-hoc Analysis
Analysis upon request for departments across organization
- Weekly trend report, client calls for direct manager's direct report in sales
- Measured video conference campaign effectiveness for training department
- Automated reports of attendance and attention tracking for training department
- Automated collection and distribution of recordings for training department coordinators
Nudge Campain
Implemented campaign to reduce high cost user subset.
- 5% voluntary user reduction from high cost behaviors
- A/B Test using an email campaign targeting high cost users
- Random effects model controlling on department, location, and usage
- Result from trial implemented into quarterly email campaign.
Implemented agile project agile project management with team to align with organization structure.
- Scrum Leader
- Coordination across and within departments
- Updating internal knowledge base resource to reduce information costs for organization
Project Management
Masters Applied Economics, 2017
3.9 GPA
Best Economics Research Paper Proposal Award 2017
Bachelors Film and Digital Media, 2007
Academic Projects
Analysis of New York Independent System Operator's transmission congestion contract market. A market designed to allow for efficient trading of risk for electricity markets. The market is fundamentally flawed in forcing rate payers to take on the risk unknowingly. This allows other market participants to exploit the imposed market system.
- CAPM model used with GARCH estimation to compare returns to volatility
- NY Rate Payers incurred over $100 million in unnecessary costs between 2010 and 2016
Cost benefit analysis of Virginia enacting legislation to allow direct to consumer wine shipping from out of state wineries. This exposed Virginia wine producing to external competition, increased user choice, and had marginal to no effects on vehicle related accidents.
- Vehicle accident effect estimated with fixed effects on panel data
- Net present value of DTC legislation of $89 million for Virginia residents.
- Data set of state wine consumption and mean price per liter to measure differences