ABCDataworks
Database and Website Design, Development, and Deployment--All in the Service of Your Mission
You can also download a Word version of this resume.
Jeremy Wallace
235 Ainslie Street, #3
Brooklyn, NY 11211
(646) 234-5532
Experienced, talented, and energetic programmer/analyst with a knack for communication, both with techies and with non-techies. I've developed databases since 1995, using a large arsenal of tools for project management. I've written documentation, training manuals, portions of a book on education in the United States, and educational materials for teachers and students. I've presented at national conferences, to board members, and to many, many clients.
6/2004-Present Fund for the City of New York (New York, NY)
Application Architect, Lead Developer: Access, MS SQL Server
I lead the product design, development, testing, and deployment of the Metrix database, a free, open-source constituent relationship management database designed to assist non-profits in the management of their fundraising, communications, and program activities. We use Visual Source Safe to manage the Access ADP and MDB components in the Metrix front end and RedGate tools to manage the SQL Server back end. We use Atlassian's Jira bug tracker and Confluence wiki for project management, Remote Desktop for support, and Virtual PC for testing.
I also implement the Metrix database for clients, provide technical assistance, train users, and lead Metrix orientation seminars. In addition, I speak at conferences and participate in several online communities involved with non-profit technology use.
8/2003-6/2004 Center for Family Life, Sunset Park (Brooklyn, NY)
Developer: Access, db5
Developed reports for management, the board, and the content of the Center's annual report based on data stored in an outdated database with no support and no documentations. Advised client on how to move forward with their data. Developed a small database application to allow the client to organize and export the queries and reports I am creating.
6/2003-10/2003 Columbia University Mailman School of Public Health (New York, NY)
Developer: Access
Developed a client-management database for a pediatric HIV/AIDS clinic at Metropolitan Hospital. The database tracks client visits, medical tests, and staff notes as well as producing reports for management and funders.
6/2002-10/2002 Interfaith Neighbors (New York, NY)
Developer: Access; Photographer
Created a database to record student demographic and testing data, maintaining a record as the student is registered and evaluated through both standardized and open ended assessments. Photographed events for newsletter and brochure images.
11/2001-12/2002 Performance Space 122, Safian Associates, Sari Freeman Associates, Global Sports Connexion (New York, NY)
Developer: Access, Word, Outlook, Netscape Mail, Eudora, WinFax
Merged, normalized, and enhanced existing Access applications for a series of New York clients. Added generic and customized e-mail and faxing functionality. Built a specification for complex reports using Word.
10/2000-10/2003 TIAA-CREF (New York, NY)
Developer: Access, Word, Outlook; Project Manager; Trainer
Developed an Access database to manage the reconciliation of over 150 bank accounts. The database includes a messaging component using custom Outlook forms that can update the database using VB Script. Reports assist in the decision-making process for people through the vice-president level of the organization. With a user base of 20 people, the database makes full use of Access security and uses extensive transaction protection. Deployment of new versions and backups are done through automation. Also developed a time-card database and a workflow database for an electronic funds transfer process.
4/2000-7/2000 UZ-UCSF Collaborative Research Program in Women's Health (Harare, Zimbabwe)
Developer: Access; Project Manager; Trainer
Designed and developed an Access database to track the purchasing process from order entry through delivery to one of five sites, with an on-line approval process and reports that serve as invoice approvals, distribution lists, and action confirmation logs. Improved existing research databases by modifying data entry forms and interim analysis queries and reports. Developed documentation and trained staff.
9/1997-2/2000 Pfizer Pharmaceuticals (New York, NY)
Developer: Access, Word, Outlook, SQL Server Developer; Project Manager; Trainer; Writer
-Oversaw a team of 10 subcontractors researching the compliance of licensed software. Increased team's productivity by 20% through modifications to their existing database, targeted trainings, and policy changes.
-Developed an Access database that was the guidance system for a corporate Year 2000 Situation Room for monitoring 85 worldwide sites during the rollover period.
-Developed Access databases to track contacts and compliance research on licensed software.
-Facilitated creative thinking and directed-brainstorming sessions to overcome institutional hurdles.
-Co-wrote two 60-page guides to the technical and business aspects of assuring Year 2000 compliance.
-Wrote application documentation and trained users.
2/1996-9/1997 The Education Trust (Washington, DC)
Developer: Access; Network Administrator; Project Manager; Trainer; Writer
Developed and maintained Access databases for lobbying, press conferences, capacity development, training, and publishing needs. Managed 20-person Windows NT network. Did data synthesis, layout, graphics, editing, and writing for a biannually published statistical book distributed to educators and legislators.
3/1995-2/1996 Carlson Wagonlit Travel (Alexandria, VA)
Developer: Access; Researcher/Writer; Trainer
Developed project management databases to track sales, operational expenses, and employee records.
1/1993-3/1995 Toby Levine Communications (Bethesda, MD)
Developer: Hyperstack; Illustrator; Researcher/Writer
Researched, wrote copy, and created computer illustrations for teachers' and students' guides to educational videos and museum exhibitions. Contributed to design and graphics in electronic and print materials.
Education:
BA American Studies, 1992 San Francisco State University
Since graduation I have taken courses and attended seminars on Visual Basic, Access, Spanish, European History, and Genetics.