his first assignment was in guam , doing terrorist assessments for a secret unit housed at the naval base ; his last was in the dc area , as a pencil-pushing , paper-filing , report-generating intelligence analyst , who looked for trends in terror attacks .