Data Sql Server

KYLE DEROSA

678-***-**** *.*.******@*****.***

*** **** *****, *** ** Fort Lee, NJ 07024

EXPERIENCE

Agriculture Center (Ag Center) of Columbia University January 2011 - present

Agriculture and Socioeconomic Data Specialist Palisades, NY

Research and implement cutting edge socioeconomic models to biophysical and longitudinal household data

Provide data management and analysis for nutrition, agriculture, and socioeconomic indicators and trends for projects

conducted in Sub-Saharan Africa (R, Stata, python)

Manage a 3 person team of socioeconomic analysts that produce data towards U.N. Millennium Development Goals

Identify and implement new mobile data collection tools Open Data Kit (ODK) for various economic and biophysical

research projects (Javarosa, XML)

Vitalsigns.org July 2012 - present

Data specialist, concurrent appointment with the Ag Center New York, NY

Designed appropriate socioeconomic data sample for inclusion in biophysical and agronomic projects

Developed prototype mobile data entry tools for biophysical & socioeconomic data collection (ODK - Javarosa, XML)

Manage the metadata and data dictionary standards (EML, DDI standards) for data collection and analysis

Developed functional and technical specifications for data workflows

Exeter Group August 2007 - July 2009

Technical Consultant Cambridge, MA

Implemented Financial Aid and Admissions ERP modules across admin systems within universities (BANNER)

Developed online admissions applications (Banner, Web Tailor)

Led test installation and implementation of Peoplesoft 9.0 & SAP 6.0 ERP releases (RHEL, SQL)

Developed and tested custom API interfaces between universities and ETS organizations (SQL)

EDUCATION

Columbia University, SEAS 2013

(coursework in Advanced Algorithms; Advanced Programming; Computer Architecture) New York, NY

Yonsei University, Graduate School of International Studies 2010

International Trade and Finance Seoul, South Korea

Tufts University, Undergraduate School of Arts and Sciences 2007

Econometrics Medford, MA

(coursework in Data Structures; Discrete Mathematics; Linear Algebra; MV Calc)

TECHNICAL AND LANGUAGE SKILLS

Experienced Stata, R, MS Office Suite, LaTeX, ODK

Working Knowledge Python, XML, Java, PostgreSQL, UNIX/OSX

Basic Nvivo, ArcGIS, KNIME, Netbeans, Eclipse, Korean

CERTIFICATIONS

MCSE, MCSA Windows Server 2003; MCTS SQL Server 2005 2007

PUBLICATIONS

Journal of Development Studies Volume 49, Issue 7, 2013

Measuring Socioeconomic Status in the Millennium Villages: The Effect of Asset Index Choice

with H. Michelson & M. Mu iz

n

Contact this candidate