- SQL, MySQL, MS Access, Excel, HTML, CSS, ASP, Visual Basic, Photoshop, Javascript
Website design
Summary: I enjoy databases. I am highly skilled in database architecture, including creation, modification and restoration. I am well versed in ETL procedures utilizing various data formats, as well as setup, optimization and maintenance of indexes. I enjoy solid, meticulous, and optimized query writing. My university studies included: statistics, econometrics, advanced calculus, and game theory.
Education
Bachelor of Science, Economics, University of Washington
Employment
Alaska Salmon Program, University of WA - Research Consultant
02/ 2007 – present
I currently work for a grant-funded university research department with many data contributors. My position has three primary components. First, I created a database to capture long term environmental, biological, and fisheries data. Second, I provide ongoing technical assistance to several teams of field researchers and data support for scientific papers published by the program. This has included onsite fieldwork in Alaska. Finally, I hire, train, and supervise a team of data entry personnel.
Washington State Democratic Central Committee - Data Analyst
08/2008 – present
Based on my successful work in 2006, I was contacted to work on a contract basis for the 2008 election cycle. I provide data analysis for the WSDCC in support of local, state, and national electoral contests.
Washington State Democratic Coordinated Campaign - Database Manager
07/2006 – 12/ 2006
I managed the Washington State Democratic Party voter-file database and provided technical support for Senatorial and Congressional campaigns. Key objectives for this position were ensuring data integrity and providing statistical analysis. I optimized the use of existing data using statistical analysis and I was able to significantly reduce statewide campaign spending by eliminating errant or redundant data and by improving data capture methods. I independently researched and directed successful micro-targeting analysis using demographic modeling. In this role, I provided management oversight of software vendors, support staff, and volunteers.
Western Wireless Inc. - Database Reporter
08/ 2005 – 05/2006
In this contract position, I developed sales and marketing reports querying various Oracle and SQL databases. Reports were primarily pivot-table report/chart presentation in Excel. I also reverse engineered and debugged pre-existing, undocumented work by prior programmers.
Planet Organics - Database and Website Developer
04/2001 – 08/2005
For this small but rapidly expanding business, I served as the jack-of-all trades for all computer needs from hardware installation to sophisticated analytics. I managed the design and development of databases in SQL, Great Plains, and MS Access. I also maintained data integrity between these databases and established back-up procedures. I oversaw the website and customer technical assistance. I coded, tested, debugged, and documented new applications. I also provided technical training to all staff. I administered security measures to restrict unauthorized use of data systems and databases, managed email lists, and supervised the quality of the data entry process. Finally, I tracked website metrics and used analysis of metrics to improve customer acquisition and retention, as well as to promote increased revenue. I consistently achieved #1 natural rankings on all major search engines for this business.
No comments:
Post a Comment