| Kelley Rianna Prebil |
| EDUCATION |
Boston University, Metropolitan College,
Boston, Massachusetts
Master of Science in Computer Information Systems, May 2009
|
San Francisco State University, College of Science and Engineering,
San Francisco, California
Bachelor of Science in Physics with a minor in Mathematics, May 2005
|
Cornell University, College of Architecture, Art, and Planning, Ithaca, New
York
Bachelor of Fine Arts in Photography, May 1999
|
| SKILLS |
Systems: Windows; Macintosh; UNIX (Red Hat, Solaris, Mandrake)
Computer Languages: SQL, T-SQL, C#, Java, XML, HTML
Software: Microsoft Visual Studio .NET, Microsoft SQL Server Tools, Microsoft Visual Studio 6.0, Microsoft Office Suite, SQL Server Reporting Services, SQL Server Integration Services, Subversion, RedGate SQL Backup, Idera SQL Diagnostics Manager, Microsoft Visio
Databases: SQL Server 2000/2005/2008, MySQL, Oracle
Database Design Skills: Data Modeling, Data Analysis, 1st/2nd/3rd/4th Normal Forms,
Data Integrity, ER Diagrams, Logical Schema/Design, Physical Schema/Design, DBLC, Joins
Languages: Knowledgeable in Spanish and Japanese |
| EXPERIENCE |
DATABASE ADMINISTRATOR
Product Development, Coupons Inc.
Mountain View, California
(July 2009 - present)
·Administer several VLDB 24x7x365 high traffic production database clusters
·Provide hardware and software support for production and development database environments
·Troubleshoot production database performance issues
·Maintain transactional replication for production, development, and QA environments
·Create data imports methods from various file types including XML, CSV, and TXT files
·Reloaded multiple servers in QA and development environments on a recurring basis
·Review and optimize stored procedures submitted by software developers
·Produce stored procedures supporting requested recurring reports for development and production support
|
DATABASE SPECIALIST
Applications Support Group, Gensler
San Francisco, California
(October 2005 - June 2009)
·Communicated with and train employees at all levels and areas
·Managed SQL Server security, growth, backups, performance, monitoring, troubleshooting, log shipping, and task scheduling
·Designed database disaster recovery plan
·Identified, troubleshooted, and resolved real-time SQL Server server, database, and data issues
·Created, monitored, and troubleshooted SQL Server agent jobs for data transfer and manipulation
·Installed, configured, upgraded, migrated, and tested SQL Server databases and dependent applications
·Designed, developed, and supported custom reports in SQl Server Reporting Services and Actuate
·Designed, developed, and supported DTS and SSIS packages
·Perform database queries to assist all business development teams
·Implemented, customized, and supported legacy and new in-house and third party systems including CRM, Accounting, Finance, and Human Resources systems
·Wrote .NET/C# applications embedded in third-party software and stand-alone applications
·Designed and supported SQL Server data warehouses
|
TEACHING ASSISTANT
Department of Physics, San Francisco State University
San Francisco, California
(January 2005 - May 2005)
·Prepared and lectured on concepts of electricity, magnetism, radiation, optics, quantum physics, and atomic physics to non-science majors on a weekly basis
·Collaborated with professor on session material
·Individually tutored students
|
WEB PROGRAMMER INTERN
International Americas, MySales, Sun Microsystems
Menlo Park, California
(June 2003 - March 2004)
·Helped streamline group's online community and communications
·Wrote JSP applications to generate metric reports from MySQL database
·Wrote SQL queries and designed database schema for MySQL database
|
RESEARCH ASSISTANT
Psychophysiology Lab, NASA Ames Research Center
Moffett Field, California
(September 2002-June 2003)
·Analyzed and reduced Real-time data from experiments
·Created graphical representation of data
·Assisted in preparation of Powerpoint Presentations for research results |
ADMINISTRATIVE ASSISTANT II
Department of Surgery, UCSF General Hospital
San Francisco, California
(July 2001-December 2001)
|
WEB PRODUCER
Learning Solutions and Development, DigitalThink
San Francisco, California
(July 2000-February 2001)
|
WEB DESIGNER
Zappos.com
San Francisco, California
(April 2000-June 2000)
|
SLIDE TECHNICIAN
The New Lab
San Francisco, California
(November 1999-April 2000)
|
SENIOR PHOTOGRAPHER
Prestige Portraits
San Carlos, California
(June 1999-November 1999)
|
LAB ASSISTANT
Department of Biochemistry, Cornell University
Ithaca, New York
(June 1996-May 1999)
|
DARKROOM MONITOR
Department of Art, Cornell University
Ithaca, New York
(August 1997-June 1998)
|
| COMMUNITY LEADERSHIP |
ADVISORY BOARD MEMBER, Western Cave Conservancy (2008 - present)
IT COMMITTEE CHAIR, National Speleological Society (2003 - 2005)
NEWSLETTER EDITOR, San Francisco Bay Chapter of the National Speleological Society (2002 -
2003)
|
| AFFILIATIONS |
Cornell Native American Alumni Association
National Speleological Society
Cave Research Foundation
Western Cave Conservancy
American Motorcyclist Association |
|