NANCY E. SHAFFER

Mesa, AZ



OBJECTIVE A database systems analysis and data management position



SUMMARY OF QUALIFICATIONS



• Nine+ years software development experience.

• RDBMS design, coding, and management skills across the development life cycle.

• Java/J2SE (including JDBC and Swing), SQL, Perl, HTML, CSS, C, Unix, and Object-Oriented Design.

• Extensive experience with secure data migration and query generation.

• Bachelor's degree in Computer Science.

• Strong oral and written communication skills.



RELEVANT SKILLS AND EXPERIENCE



Software Analysis and Programming



• Developed and deployed all database data entry, querying, and reporting applications and supporting utility classes for two magnetic resonance imaging research groups. Had complete responsibility for all phases of the development life cycle, including requirements gathering, design, coding, testing, debugging, version control, and continued evolution of applications in accordance with user needs. Applications were written in Java JDBC and ran on Unix/Solaris, Linux, and Macintosh platforms.



• Created and deployed Unix shell scripts for compiling and installing Java and Perl applications.



• Wrote Transact-SQL stored procedures for adding data to, updating, and deleting data from the databases, performing database queries, and calculating parameters. Procedures made use of triggers, views, joins, data transformation, and cursors.



• Initiated, developed, and maintained Perl utility scripts. Scripts searched for and read Unix-based text files, invoked Unix shell commands, performed pattern matching, calculated parameters, and queried from and uploaded selected data to laboratory databases using embedded SQL (Sybperl).



• Performed trouble-shooting and maintenance of data collection and data analysis applications and lower-level software used in geophysical exploration, experimental psychology, and clinical audiology research.



Data Management



• Served as liaison to data managers from outside labs, departments, and institutions to coordinate the secure and accurate migration of data to and from local databases.



• Modeled data collection at each study time point to ensure timely and accurate implementation of study protocols and their accurate representation in database designs.



• Provided regular reports to lab investigators on research subject accrual and study time point goals, enabling efficient progress towards research objectives.



• Designed an anonymous patient identification system that enabled researchers to comply with HIPAA privacy requirements.



• Initiated and conducted periodic data audits to ensure database information was complete, accurate, and up-to-date.



Database and Database Server Administration



• Designed, implemented, and maintained a relational database management system on the Sybase Adaptive Server Enterprise (ASE) 12.5 platform, including component databases, data models, tables, table relationships, data structures, user applications, stored procedures, and utility scripts.



• Enforced database security through the creation of differential-privilege roles and data entry constraints at multiple levels. Security measures ensured data integrity and HIPAA (Health Insurance Portability and Accountability Act of 1996) compliance.



• Performed various database server administration tasks on the Sybase ASE, including user login/account management, database creation, and enforcement of database design conventions across research groups to ensure lab-wide database compatibility.



Training and Technical Support



• Provided training and technical support to end users and database owners on database applications and concepts, improving database utilization and the efficacy of collaboration on database and database application design.



• Wrote and maintained user interface documentation and tutorials for database end users, and lower-level application, script, and database table code documentation for lab IT specialists.



• Taught university-level courses with full responsibility for content, lectures, group discussions, examinations, and grading.



EDUCATION AND TRAINING



Sybase System and Database Administration ASE course, Emeryville, CA, November 2000.

Ph.D., Philosophy, University of California, Davis, June 1996.

M.A., Philosophy, Arizona State University, Tempe, Arizona, May 1991.

M.A., Cognitive Psychology, Rice University, Houston, Texas, May 1987.

B.S., Computer Science, Psychology, Graceland College, Lamoni, Iowa, May 1985, summa cum laude.



EMPLOYMENT HISTORY



1999-present - Programmer-Analyst II, Department of Radiology, University of California, San Francisco.

1997-1999 - Assistant Professor, Department of Philosophy and Religion, University of Nebraska, Omaha.

1996-1997 - Assistant Professor, Department of Philosophy, Concordia University, Montreal, Quebec.

1991-1996 - Teaching Assistant, Graduate Research Fellow, and Associate Instructor, Department of Philosophy,

University of California Davis.

1993-1994 - Part-time Instructor, Cosumnes River College Division of Humanities and Social Science, Sacramento, CA.

Summer 1991 and 1992 - Research Assistant, California Energy Commission, Sacramento.

1989-1991 - Teaching Assistant, Department of Philosophy, Arizona State University, Tempe.

Summer 1990 - Computer Programmer III, Arizona State University Computing Services, Tempe.

1987-1989 - Software Engineer, GeoQuest Systems, Inc., Houston, TX.

1986-1987 - Computer Programmer, Baylor College of Medicine, Houston, TX.

1985-1987 - Graduate Research Fellow, Department of Psychology, Rice University, Houston, TX.