John Mathena Email & Phone Number

Baltimore, MD, US

Arlington, Virginia, US

On my team, I lead the track of work responsible for legacy enrollment data system maintenance and migrating bulk manual processing applications to AWS Lambda functions built in Python. I write up new tickets for feature work and issue resolution when necessary. I have also cross trained two additional engineers to support my track.Our infrastructure.

Arlington, Virginia, US

+ Administer ETL process updating and creating student enrollment data in Salesforce and Learning Management Systems for dozens of degree programs+ Query millions of records in cloud-based Postgresql databases to find student and faculty enrollment errors+ Coordinate with enrollment specialists to ensure data management systems function properly and catch.

Baltimore, Maryland, US

+ Maintained PowerBI reports that provide the public access to data on 211 programs+ Administered weekly updates to AWS MySQL database storing millions of records on 211 calls+ Submitted over twenty reports at weekly, monthly, quarterly, and annual frequencies+ Convened bimonthly Data work group with six community partners to improve data quality

+ Represented nearly two dozen community associations in the Southwestern Police District by attending meetings and addressing residents' public safety concerns+ Managed homicide and non-fatal shooting data for the unit+ Created Shiny App in R to map victim-based crime across Baltimore City+ Maintained updated information on hundreds of defendants on.

Washington, D.C., US

+ Conducted data retrieval and analysis on 30+ files daily related to immigration status + Wrote macro in Excel VBA to determine physical location of hundreds of files daily needed for special projects, saving project managers hours of work weekly+ Utilized Excel VBA to improve automated performance evaluation of Analysts in my department for my.

Lawrence, KS, US

+ Used Access and SQL to extract data from various Health Department databases and our EHR system+ Visualized average length of stay and average client intake in LDCHD Clinic for over 10,000 encounters in 2017 using R Markdown+ Built map in ArcGIS to visualize addresses of clinic patients across the city grouped by type of clinic visit+ Wrote R script to.

Performed routine automotive maintenance including:+ Tire rotations+ Brake checks and replacements+ Oil changes+ Cabin and air filter changes+ Assist head mechanic with more extensive repairs

+ Wrote legal summaries of previous cases in Arabic+ Prepared client files for future cases

+ Categorized new book arrivals in Arabic and French+ Wrote lesson plans for Introductory Computer class (Basic typing and Intro to Microsoft Office)+ Taught Intro Computer Class to children (Elementary and Middle school aged)

College Park, MD, US

The INSPIRE project uses social media analytics to predict where and when instability will occur with the current focus on elections and violence in Sub-Saharan Africa. My responsibilities included:+ Tweet labeling for relevance and sentiment classifiers across cases+ Analysis of inter-rater agreement and significance tests of results within and across.

College Park, MD, US

The INSPIRE project uses social media analytics to predict where and when instability will occur with the current focus on elections and violence in Sub-Saharan Africa.

I was responsible for designing items and analyzing the results of key studies, as well as other research-related tasks, led by Colin Phillips and Shota Momma. Topics included:+ Sentence processing+ Syntactic prediction+ Event-related potentials. I also designed a study investigating advance verb planning in Sentence production using Arabic speakers.

Washington, DC, US

+ Organized thousands of photos in the CLS database based on year and program country+ Wrote and recorded an OPI (Oral Proficiency Interview) guide using Zoom with another Intern+ Assisted Program Officers with various office tasks+ Improved recruitment efforts by using Access and Excel to assess the efficacy of dozens of past recruitment events

New York, NY, US

+ Assisted asylee and refugee clients in applying for various social services including cash assistance, travel subsidies, public schools.+ Taught dozens of clients how to properly utilize public transportation around in the DC Metro area+ Translated for Arabic and Spanish speaking clients+ Completed federal, state, and local reporting requirements on.

+ Cleaned data from 200 participants of a previous experiment+ Constructed qualitative coding scheme to categorize hundreds of survey responses + Coded survey responses for 90 participants with usable data+ Presented findings to fellow researchers, academics, and US Government funders

+ Ran dozens of participants through experiment investigating effects of social rejection on anger and aggression + Performed post experiment debrief+ Provided recommendations for improvements in experimental design to principal investigators

I performed routine auto maintenance including but not limited to:+ Oil changes+ Tire rotations and alignments+ Brake checks and replacements+ Engine and Air filter replacements+ Inner engine repairs

+ Listened to and transcribed 911 tapes from Domestic Violence cases+ Compiled case histories of defendants to be used by the Prosecution+ Printed out pictures of crime scenes to be used by the Prosecution + Used Spanish language skills to interview witnesses and defendants when necessary

I taught math, reading, and US culture to middle-school age children.

Bachelor Of Arts - Ba, Arabic Studies

Certificate, Arabic Language And Literature

Bachelor Of Arts - Ba, Linguistics, Minor In Spanish Language & Culture

High School Diploma, Honors From The Law And Public Policy Program