Jay Wiese
611
NW 10th Ave, Gainesville, FL 32601 • 352·281·1084
• wiese.jay@gmail.com
Order items for library collection; streamline and automate unit workflows;
generate and distribute statistical reports; manage unit web site; provide basic computer
support for unit.
- Created a macro using Macro Express to
quickly and accurately enter order records into Aleph from an order tracking database in MS Excel. Macro
virtually eliminates user error and incorporates safety features to
avoid accidental deletion of records.
- Developed a relational database using MS Access and SQL queries to
track monographs funds. Database provides a single
data set from which up-to-date budget reports, bulk emails and web
pages can be generated in minutes by a single staff member. Database
reduces error and saves about 12 staff hours per week.
Manage young adult and fiction
collections; provide
one-on-one computer support and bibliographic instruction; provide
reference and circulation services for patrons; Manage
volunteer program for 40 library branches; Tutor adults in basic
English literacy; assist with training of volunteer adult literacy
tutors.
- Designed an algorithm for quickly selecting books for purchase based on peer selection data.
Introduced a method for identifying low-circulation books for deselection review using LMS-generated reports and MS Excel. Used new method to identify about 2,000 volumes from 10,000 volume adult fiction collection for review; only 3 volumes from the review list were retained (nearly 100% accuracy).
August- October 2003 Amendments review specialist, Royal Caribbean Cruise Lines (Kelly Services)
Review amendment reports for group bookings on cruises & report errors to group booking agents for correction
- Developed a mail-merge to generate customized
amendment error reports and deliver the reports via email to group booking agents. Mail merge is twice as fast as exiting method, and nearly error-free.
2000-2003 Library Technical Asst. (serials), Architecture and Fine Arts Library at UF
Perform check-in and claiming of serials for Architecture and Fine Arts Library; Provided basic
reference and bibliographic instruction at the service desk.
Improved workflows for serials claiming and check-in resulting in an estimated 50% time savings.
- Created databases using MS Excel to track serials backorders, serials to be bound, and duplicate periodicals.
1992-1996, 1998-2000 Gallery Preparator and Studio Assistant, Valencia CC, Orlando, FL (part-time)
Clean and organize art studios;
build and maintain studio furniture; prepare clay and glazes; assist
with installation of art exhibitions.
- Designed and manufactured a
simple welding jig that enabled one
person to accurately assemble sculpture stands at more than four times the rate of the existing assembly method. - Designed, manufactured, and installed a secure display
system for flat art composed of
readily available off-the-shelf components that cost less than $100 in
materials. System enabled fast install and removal of student
artwork and protected the work from vandalism. Manufactured and installation was completed in less
than a day. - Created an artwork registry
database using ClarisWorks. Database eliminated duplication of effort
and reduced error by allowing insurance lists, artwork tags, and other data to be
generated from a single data set.
Developed a mailing list database using ClarisWorks. Database
eliminated need for paper-based or centrally stored contact lists and
allowed gallery to maintain control of contact data.
1996-1997 Interlibrary Loan Asst. (work-study), Herrick Library, Alfred Univ., NY
Process patron interlibrary loan requests and request books; receive and track incoming interlibrary loan books.
- Developed
a relational database in Alpha Four to track incoming interlibrary loan
requests. Database replaced difficult to use paper-based system.
Database virtually eliminated lost requests and made it possible for
department staff to quickly determine the status of a specific loan
request.
May-August 1996 Microfilm copy specialist, First American Title Insurance Co., Orlando
Search and print real estate
titles and title-related documents from microfilm records; perform
other clerical duties including copying and filing.
- Created a method for
searching microfilm using automated functions of microfilm readers, becoming the fastest of 3 copy specialists within a month of hire.
1991-1994 Database developer/Electronics assembler, Mass Memory Systems, Winter Park, FL
Develop and maintain company's relational databases, assemble removable hard drives from parts for special order.
- Developed a relational database
system using dBase IV and SQL to track and correlate product status, customer
information, and sales lead contacts.
Database consolidated separate and redundant datafiles, delivered
customized reports, and imported and exported data to and from other
software packages.
Microsoft Certified Desktop Support Technician, February 2009
Master
of Library and Information Science, University of South Florida,
Fall 2006
Bachelor
of Fine Arts, summa cum laude, ceramic art, University of
Florida, Spring 2003
No comments:
Post a Comment