Work Examples

Publications:

• SWASIA North Africa
  A weekly news digest of Southwest Asian and North African events plus translations from the Hebrew and Arabic press focusing on the Israeli-Palestinian conflict.
  Publisher: National Council of Churches.
  Co-Editors:
  Allan Kellum (July 1975-Dec.1977)
  James Fine (Jan. 1974-June 1975)
  Norton Mezvinsky (Jan. 1974-Dec. 1977)
  Selected issues to view:
  U.S. Testimony on Palestinians and Regional Reaction
  Regional Reaction to Testimony, continued...
  Saudi Arabia and the Petroleum Revolution
  Lebanon Moves Toward Peace
  Secret Israeli-PLO Meetings of 1977
  PLO Official Reveals Peace Strategy
  


• Mideast Observer
  An independent twice-monthly report from Washington focusing on U.S. policy in the Middle East.
  Allan Kellum was founder and served as editor for nearly a decade. The publication's mailing list was sold to the Washington Report on Middle East Affairs in 1986.
  A searchable index of the first four years is available here: Mideast Observer


• The Washington Report on Middle East Affairs
  Allan was one of the first people that the Washington Report chose to profile. Here's a copy of the 1983 profile:
  Profile of Allan C. Kellum
  The following year the Washington Report requested that Allan do a profile of Landrum Bolling.
  Here is that two-page profile plus additional pages that include the raw materials on which it was based:
  Profile of Landrum Bolling
  



• Voting Record Issues
  Allan published voting record issues in the Mideast Observer and the Washington Report.
  Here are the Mideast Observer's:
  Voting Record Issues published 1978-85
  And here are the Washington Report's:
  Voting Record Issues from 1989-94
  



• PAC Data
  On November 1, 1983, the Mideast Observer published a survey of Federal Election Commission data for the 1982 election cycle that revealed the predominance of pro-Israeli PACS.
  View that PAC Issue and also UPI's report about it.
  
  

Web Site Examples:

• South Asia Regional Initiative for Energy Integration - Began developing the website in 2000 and travelled to India where I hired three web development experts who I managed until 2003 when Development Associates discontinued its involvement in SARI-EI. The site has continues under different management.
• Gauer Website - Website developed for Mike Gauer for his business as author and speaker.
• Picture Gallery - Example of the use of Visual Lightbox for the dynamic display of pictures on a website.
• Designer & Builder's Site - Website for a Home Designer who also Builds Homes.
• Memorial Website - Website that I developed as a memorial to my mother.
• Organization Website - Website developed for ARTA -- the Alexandria Retired Teachers Association.

Description of MIS Projects:

MIS for Healthcare Organization

Created, implemented and trained staff in the use of a web-enabled MIS for Project Concern International's Border Health Initiative (BHI) to centralize business data among its Mexican and California offices. The system allows all of the BHI offices to securely enter and track information regarding the proceedings of staff meetings, grants, and data regarding BHI-sponsored events in real time. Additionally, information about evaluations and BHI contacts - people, committees and organizations - can all be viewed, edited and updated via the website. The system provides data for management decisions and for donor reports that were not previously possible.

Created Time-Saving Reporting System

With another volunteer, developed an MIS system for two Arlington County social service programs that saved one FTE annually. The reporting portion of the system allowed for detailed reporting of metrics for any or all of the workers for any time span with the default time span being the just completed month. This was a huge time-saver.

Designed Update of Education Department System

Wrote: "A Proposed OBEMLA Database Management System: Current Data Collection Practices and a Proposed System for Database Management and Reporting" as part of a multi-year contract with the Department of Education to provide the Office of Bilingual Education and Minority Languages Affairs (OBEMLA) with analyses of special issues.

Created Head Start Logistical System

Created a travel agent-like, real-time networked system for a three-year $5 million Head Start On-Site Review Support project that involved sending out teams of from one to ten Head Start officials and peer reviewers to over 400 Head Start sites nationwide each year. The system provided the means to dispense and track the travel, per diem, honoraria and other expenses involved in fielding review teams.

Designed Youth Evaluation System in Jamaica

Designed tracking and evaluation system for 11,000 at-risk youth in Jamaica who were tutored and trained in Jamaica by numerous local organizations such as the Boy Scouts, Girl Scouts, Red Cross, etc. in a USAID "Uplifting Adolescence" program.

Established USAID Trainee Information System

Designed and developed computerized information system to monitor and report trainee costs associated with the firm's five year, $20 million U.S. Agency for International Development (USAID) contract for the Andean Peace Scholarship Project. The system enabled the firm to rapidly perform training cost analyses for any of the approximately 1,700 trainees by group or country over any specified time period. The trainees were from the four Andean nations of Bolivia, Colombia, Ecuador and Peru.

Short-term Work Assignments:

• American Medical Group Association (See: www.AMGA.org)
  Substituted for a full-time employee who was on medical leave for four months in early 2013. Used SAS, MS-Access and MS-Excel in the production of patient satisfaction survey reports for member organizations of AMGA. In the process, significantly improved the automation of several data procedures.



• Friends Committee on National Legislation (See: www.FCNL.org)
  During most of 2012, served as receptionist one-day-per-week and performed data entry and other related tasks involving their membership database.