Skills and interests:
• Building data pipelines from start to finish - taking the data you have and turning it into the insight you need
• “Solving problems,” not just “answering questions”
• Bringing order to the chaos of messy, unstructured data
• Anticipating and planning for data needs - no more “oops, we weren’t tracking that”
• Productionizing ad-hoc analyses to save my time and yours
• Automating everything that moves
My favorite tools:
• PostgreSQL: Procedural Postgres, Window Functions, Complex Queries, User Defined Functions, Date/Time Operations, Common Table Expressions, Table Creation/Manipulation/Administration
• Python: Pandas, iPython/Notebook, NumPy, SQLAlchemy, Flask, Boto, REST APIs, pdb
• JavaScript: Highcharts, PhantomJS
• Hadoop: Hive
• Linux Terminal
• Business Intelligence: ChartIO
• APIs: Google Analytics, Facebook Graph API, Twitter, Instagram, LinkedIn
• Additional Skills in RegEx, OOP, Git, S3
What I want to Learn: More Hadoop, More JS, Java, Scala, Machine Learning/Data Mining, Data Structures and Algorithms
Digital Analyst @ From October 2015 to Present (3 months) Product/Data Analyst @ Optimizely has built a best-in-class platform that enables businesses of all sizes to bring the power of data to their decision-making. As a product and data analyst my job was to do the exact same thing for Optimizely.
On the Product team I worked closely with Product Managers and Engineers to make sure product owners have the most accurate, actionable data they need to make the best decisions for our business and our customers. I also worked with our Data Science team to serve as a resource throughout the company for analytics and insights.
Some of what I did at Optimizely:
* Become an expert in our data ecosystem. Knowing what data we have, what we don't have, how to use it properly, what it means, and very importantly, what it doesn't mean.
* Solve the 80/20 problem for data scientists. That means building and managing curated tables on top of our data warehouse, so scientists and analysts can focus on building the models that drive our business without wasting time on finding and cleaning data from our vast warehouse.
* Develop and prototype processes on top of our data warehouse to make the most of our data. For example, working with Technical Support Representative to parse snippets of JavaScript into a set of features we could use to understand the experiments our customers are running.
* Build useful analytics products and systems. Translating the needs, questions, and curiosities of product owners into proper data collection, data pipelines, and SQL/Hive queries, and dashboards.
* Develop processes to make sure that we're building products and features that are conducive to analytics.
* Productionize analyses by designing and implementing new tables and stored procedures in our PostgreSQL data warehouse.
* Productionze analyses by designing, implementing, scheduling and maintaining jobs in our Hadoop ecosystem. From March 2014 to September 2015 (1 year 7 months) San Francisco Bay AreaMarketing Intern @ • Coded Python scripts to automate marketing tasks and analyze customer data
• Developed benchmarks and projections for holiday sales using BI tools (Looker) and R
• Analyzed sales figures, identifying the source of a drop off in sales and planning optimization tactics
• Wrote, deployed, and analyzed user surveys to understand customer behavior and improve customer satisfaction
• Planned and executed A/B tests to increase customer retention and engagement through email and push notifications
• Researched and developed assets for paid Facebook marketing including targeting, art and copy
• Managed brand social media driving increased engagement and a 60 percent annual increase in page likes
• Analyzed social media performance, deriving lessons and successfully implementing insights
• Developed expertise in using BI software in marketing, customer service, and other contexts
• Provided excellent customer service and outreach via phone, email, and social media From October 2013 to February 2014 (5 months) San Francisco Bay AreaResearcher @ Nonprofit progressive media research and information center. As a researcher I was responsible for monitoring conservative media, identifying inaccurate or misleading information, finding reliable sources with which to respond, and writing research items and blog posts for publication on our website. From September 2010 to May 2013 (2 years 9 months) Political Communications Intern @ In my capacity as an intern I assisted our Press Secretary and New Media Specialist by conducting media monitoring and compiling daily clips as well as working with Excel and PowerPoint to create compelling charts and data visualizations. From April 2010 to September 2010 (6 months) Federal Budget and Tax Intern @ As the Federal Budget and Tax intern at CBPP I worked with researchers and senior staffers to produce high quality and relevant economic policy research. I used a variety of research methods and statistical analysis techniques to study, analyze, and write about economic policy problems. This research included conducting literature reviews, utilizing official data sources, and attending and reporting on congressional hearings. I learned a tremendous amount about policy analysis and the policy process, as well as how outside groups can influence legislative outcomes in positive and effective ways. From August 2009 to December 2009 (5 months) Intern @ At Treasury I had the pleasure of interning with the Office of Economic Policy. I attended congressional hearings and think tank lectures, reporting back and sending my reports around the office. I worked with Treasury staffers and political appointees on projects as needed. I started at Treasury during the most acute phase of the financial crisis and saw first hand part of how the Department handled it. From September 2008 to December 2008 (4 months) Associate Tester @ As an Associate Tester I was responsible for producing IEEE compliant testing documents and carrying out the tests. I worked in a team to design and carry out a testing program for the firmware on an electromechanical device (an electric lock). From January 2005 to March 2005 (3 months)
Economics B.A; B.A, Politics @ University of California, Santa Cruz From 2005 to 2009 David Shere is skilled in: Research, Blogging, Data Analysis, Writing, Nonprofits, Quantitative Analytics, Python, SQL, R, PostgreSQL