Strategic Technology Solutions’ clients range in size from one a person office, to organizations with staff over 100. The clients include national nonprofits, community-based nonprofits, membership organizations, associations, foundations, educational centers, and small businesses.

Institute for Educational Leadership (IEL)

• Program and Design an interactive Web Database that serves as a central location to track information on and disseminate information to Alumni, Site Coordinators, and Sponsoring Agencies. This site includes an online searchable database, adminstrator login and online database reports. www.epfp.org
  
• Integrated Program Tracking - Design an Access database to track information for over 12 programs of IEL. This database sits on shared network and tracks alumni data, categories, relationships, contact activity, service on committees, interests, and financial data. It also includes a secure login, query tracker and update menu.
• Provide training to staff on table, query and report design.

Federation of State Humanities Council

• Online Members Only Database - Using PHP and MySQL, design an online database to track member contacts, congressional activity, resources, income and salary surveys. Database includes three levels of access and an administrative menu. www.statehumanities.org
• Member Tracking Database - Design in Access a centralized database to track members, contacts, member dues and categories; also the ability to track conferences and events and register members for these events.
• Requirements Gathering and Strategic Technology Planning Work with the staff to develop a Strategic Technology plan to include: a review of current infrastructure, hardware and network; Goals and Priorities—recommending the appropriate technology tools to support those goals; Review of Processes and use of Database applications (Web and LAN integration); recommend ways to streamline operations; and a Review of Staff Training needs.

Prince George's County - Department of Housing and Community Development - 2007 and 2006 Home Ownership Fairs www.princegeorgesha.org

• Design a Registration Database to track all attendees and participants in the Housing Fair. This database registered attendees on site and generated name badges,
• Provide Onsite Registration Management the day of the Fair to manage the entire registration process.
• Set-up and Coordinate Technology Equipment (pcs and printers used to register attendees, print name badges and reports.
• Analyze Data from the Home Ownership Fair and provide summary reports to the Housing Department.

Wheeler Technical Services

• Online Job Database - Using ASP and Microsoft Access design an online searchable database to track technical jobs available for applicants. www.wheelertechserv.com
• Design online admin control panel to track users, post, edit, delete and update jobs.

Capital Area Food Bank

• Children and Nutrition Program Tracking - Design a database to track nutrition programs in DC, MD and VA to include: site orders, meals served, weekly attendance, costs of meals, and program funders. Design Adult and Children surveys to track the progress of the RX for Healthy Weight Program.
• Agency Relations Program Tracking - Design in Access a database to track information on the 700 Member Agencies receiving assistance frome the Food Bank. This database tracks site information, food storage, financial data, meal programs, product surveys, evaluation, and follow-up data.
• Grants Management Tracking Database- Design in Access 2000 grant database system to include: security login, grants planning, major funders & donors, donor contact, payments, reporting requirements, program expenditures, relationships, matching funds, and direct mail campaigns.
• Meet with development staff and note grants tracking requirements; prepare documentation on features for a new grants management system.
• Review organization program goals and priorities; write a technology proposal to present to funders; identify funders to approach for the Food Bank Outreach Network
• Onsite Training for Development Staff on Access 2000

McLaurin & Brad-Affordable Custom Homes

• Project Management for Home Constrution Clients - design a builder's database to track the phases, descriptions, and costs for building a new home
• Design forms to track various builder requirements such as cost breakdown for the bank, current projects, and list of contractors and vendors
• Web site layout and Design for a builder in Prince Georges County; Design online slide show to showcase home designs and features. www.mclaurinandbrad.com

Coalition for Community Schools (CSC)

• Online Report Tracking - Using MySQL designed an online database to track downloads of reports from the website www.communityschools.org
• Design reports to count the numbers and types of download reports.

DC FEMA - Emergency Assistance Program

• Web site layout and Design; Online database system to track agencies participating in the FEMA program, case manager workload, and applicants applying for the program.
• Design an online reporting system to be used by case managers and staff to track applicant activity /DC_FEMA_mainpage.htm

DC VOICE and Teaching for Change

• Quickbooks Export to Access - Create a routine to export financial data from Quickbooks to into Microsoft Access. This has reduced time in data entry and allowed staff to generate reports for better analysis of publication sales.
• Joint partnership effort of two nonprofits with similar database needs - Design in Access 2000 a database of teachers, parents, policy makers, school administrators, universities, community activists and board. This database tracks constituent activity, attendance at events, levels of education, service on committees, and purchases of educational materials.

Lake Arbor Technology Learning Center

• After-School Technology Program - work with students from Lake Arbor Elementary and Ernest Everett Just Middle on how to integrate technology into school projects using math, presentation, formatting, and graphic design skills.
• Adult Computer Program - Provide computer training to Adults and Seniors which includes (Basic Computer Skills, Windows 2000, Microsoft Word, Excel and Access.)
• Summer Computer Camp - Provide graphic and web design skills for the elementary and teen programs.

Catholic Legal Immigration Network

• Grants Management and Individual Campaign Tracking - Design in Access 2000 database system to meet the needs of the Development department. This database is used to track programs, projects, payments, reports due to funders, and background information on individuals.

AOL Time Warner Foundation

• Grantee Tracking Database - Design for the AOL Peace Packs project and database in Access 2000. This database tracks grantees, award dates and amounts, the contact person, program information and reporting requirements.

National Urban League

• Online Financial Tracking System - design an online system to track statement of activities, financial position, and governance for the 115 Affiliate network; download to Access 2000 for reports.
• Online Software Distribution Tracking - design an online database to track the distribution of a Microsoft software grant to the Affiliate network; downloads to Access 2000 for reports. (2001-2002)
• Web Database Design Project for the 115 Member Affiliate Communication Network. Access 97 Backend. www.nul.org/affilweb.
• Chief evaluator for the Urban League Technology Centers in Baltimore, Boston, Binghamton, and Newark
• Database Conversion & design Project (Access 97) & Web PDF files for the Job Training Programs (SPIR) Data from the Department of Labor. www.nul.org/spirweb
• Design an Access 97 Database for 1998 Job Opportunity Showcase and provide technical support and training (Annual Conference)

Rare Center for Tropical Conservation

• Membership/Gifts Tracking System. Design a database in Access 2000 to track member gifts and renewals, prospect activity via an integrated calendar module; contacts by interests and categories and the ability to track responses to specialized mailings.  Provide staff training in Access.

Venture Philanthropy Partners

• Design in Access 2000 a database to track organizations, contacts, activity, and follow-up with contacts.

• Design a module to track sources and link sources to organizations.

Power UP

• Technology Site Tracking - Design in Access 2000 a database to document activity for over 600 Technology Sites. Highlights of the database include the ability to track sites with multiple locations, contacts, site activity, site hours, site hardware and software usage, site sponsors, and site status.
• Site Trainings and Registrant Tracking - Design a module to track trainings and the ability to register contacts at each site for specialized training.

Community Wealth Ventures

• Survey Tracking - Design a database in Access 2000 to survey Venture Philanthropy organizations and their activities. This database tracks financial information, contacts,and fund activity.

Bowie State University

• Design a web database management system for the Bowie State High Tech Training program. This database has secure user level access and tracks training programs and evaluation, class schedules, applicant activity, employer and partner interest, and online reporting.

Afro American Newspaper

• Circulation Management Tracking System - Design a database to track subscribers and payment history, gift subscriptions, special promotions, vendor payments and billing, and route analysis.
• Design a module to track the weekly dispatch and do comparative analysis of the weekly distribution process

National Coalition to Abolish the Death Penalty

• Design in Access 2000 a database to track contacts and organizations, international organizations and activity, multiple categories for contact and organization interests.
• Library cataloguing system - Track videos, books, articles, papers and newsletters. This module has the ability to link to many subject areas, and a check out system.
• Program Budget and Expense Tracking

Language ETC…

• Design in Access 2000 a database to streamline the entire class registration process for Language ETC…  an adult education learning center. This database tracks demographic information on students, student levels, test scores, class registration and payments, types of classes and types of books
• Design a module to track teacher background & hours worked
• Design a module to track expenditures for Language ETC programs

National Association of Affordable Housing Lenders (NAAHL)

• Membership Management Tracking Program - track Members by types, activity, member dues and renewals, by interests and categories
• Conference & events module to track meeting logistics, sponsors, and speakers
• Design reports to track conference attendees, registration, payments and confirmation letters
• Specialized staff training on use of Access 2000 to design a conference database for March 2001 annual conference. Training included table design, query design, creating calculated fields, setting up merges and designing name badges and attendee reports.

Technology Works for Good

• Searchable Web Database - online database to provide a central location for resource sharing and technical assistance among the nonprofit community and technology resources in the Washington metropolitan area. www.technologyworks.org
• Implement a Beta Testing Group and Beta Survey for the Website.
• Online Rating system that allows nonprofits to rate the support provided by consultants, service providers and vendors.
• Automated bidding system that allows nonprofits to post rfps online.
• Activity tracking system to track activity on the site and generate reports.

Samaritan Inns

• Design in Access 2000 a Resident Tracking system to track residents in three phases (Intensive Recovery, Transitional Living, and Long Term Housing)
• Design a Money Management Module to track monthly income and allocation of funds
• Design Reports to track residents, money management and program activity
• Train staff on use of the database management system and report design

Enterprise Foundation

• Inventory and audit existing network, server, and workstation configuration (DC office)
• Upgrade network and workstation configuration
• Provide technical support for installation and workstation setup for DSL connection

National Center for Family Philanthropy

• Inventory and audit existing network, server, and workstation configuration
• Document recommendations for network enhancementand workstation upgrade
• Provide technical support on Web Trends tracking activity on the website

Foundation for Street Scholars

• Provide technical support and expertise for purchase of new laptop and software
• Migrate all data to new computer and laptop
• Backup of all data, e-mail, and contact database
• Document recommendations for network enhancement, server and workstation upgrade
• Document recommendation for design of a new database to track contacts, volunteers, member types, dues payments and conference registration

Rural LISC (Local Initiatives Support Corporation)

• Design in Access 97 an Information and Communication Network for Rural LISC Constituents & Contacts. The database tracks affiliations, contacts, meetings, donors, logistics, trainings, committees, & mailings.
• Provide Training on Report Generation and provide documentation.
• Write Documentation on Streamlining Database Management Duties.

National Low Income Housing Coalition

• Designed in Access a Membership Management Tracking Program to track Members, Donors, Dues Member Activities, Payments, Meetings, and Publications.
• Staff Training and Report Generation on Access Database Management System.
• Staff training design & set-up (Badges/Merges) - conferences, fundraisers, & regional events

Council for Opportunity in Education

• Perform Requirement Analysis for Office-wide Database Migration
• Provide Database Structure, Reporting, and Process Flow Documentation.
• Make Recommendations on Membership Management & Accounting Software Packages.
• Direct Liaison for Implementation of IMIS (Nonprofit Information Management Database)

A Broader Image

• Assist the President of A Broader Image with identifying specific strategies for approaching funders for the Community Cyber-Youth Project. This project is a public/private partnership making computer and information technology available to public schools in Washington DC.

• Develop a template to be used for all major funders and prepare proposals to funders.

INDEPENDENT SECTOR
(Nonprofit Membership Organization)

• Website Design and Implementation
• Network Management (Windows NT)
• Office-wide Migration to Windows 95, Exchange 4.0, Winfax Network Version
• Head Technology Task Force
• Managed Office-wide Database in FoxPro (Members, Affiliates, Prospects, Dues, Grants, Meetings)
• Database Migration to "Keep in Touch" - Government Relations Tracking Program
• Staff Training (Windows95, Exchange, Winfax, Foxpro, WP, R&R Report Generator)
• Managed Technology Exhibit and Technology Sessions for Annual Conferences (1995, 1996, 1997)
• Technology Proposal Writing 1994-1997