Zach Alexander Email & Phone Number

New York, Ny, Us

-Work with a variety of stakeholders both within our organization and with external partner agencies to determine data needs and engineer solutions to combine, clean, and transform existing data sets from multiple sources to meet those needs-Advise on possible solutions where it is not already possible to meet the data needs of our staff or our funders-Develop and maintain automated solutions to continually clean, transform, and validate data at scale-Develop and maintain efficient, reliable, and secure methods to retrieve and store data-Create and maintain a data warehouse, including establishing and documenting appropriate processes-Advise management on recommended software and infrastructure investments to better store and process data at scale-Collaborate closely with our research and data analytics team to meet their complex data needs-Work with internal stakeholders to understand their reporting needs and create appropriate data marts, as needed

- Build data capacity at the Manhattan Justice Resource Center, Downtown Manhattan Criminal Court and Downtown Manhattan Supreme Court and track performance of alternative-to-incarceration programs.- Serve as Principal Investigator of a large-scale court-experience research project in Brooklyn Criminal Court.- Manipulate large datasets within SQL and R to automate statistical reports for staff and stakeholders.- Directly supervise one team member conducting research at Midtown Community Court and Harlem Community Justice Center.

- Downloaded, coded, cleaned and analyzed data from large databases in SQL, R and SPSS.- Produced statistical reports on program volume, service linkages, or compliance rates.- Conducted research projects and initiatives designed in collaboration with CCI research and program staff.- Assisted staff at the Midtown Community Court and Harlem Community Justice Center in building their data capacity.

Cambridge, Massachusetts, Us

-Work within SPSS, SQL, and R to analyze large-scale quantitative and qualitative datasets, using inferential statistics and qualitative coding techniques.-Lead SQL trainings for internal staff on query syntax, transactions, and stored procedures.-Contribute to the publication of 7+ CEP research reports from 2016 through 2018.-Lead survey administration and data collection processes for CEP's ongoing research.-Produce clear and compelling content for research reports, highlighting findings and recommendations drawn from analysis.

Cambridge, Massachusetts, Us

-Used python, SQL, and Microsoft Excel to clean and combine 20,000+ grantee responses, storing data in CEP's robust dataset of over 400,000 individuals.-Selected internally to lead the survey administration process for CEP's largest assessment tool, the Grantee Perception Report (GPR).-Coordinated and managed the launch of 70+ surveys to funders throughout 2016 and 2017.-Worked with 18 individual funders (with assets of $5M or more) to help measure their grantee feedback. -Produced reports, communicated directly with clients, and supported presentations to foundation boards, CEOs, and staff.-Actively contributed to team discussions, collaborated on cross-team projects, and helped to develop CEP’s internal knowledge base and operations.

Kingston, New York, Us

-Managed client accounts for Web/Google Analytics, Conversion Rate Optimization, Pay Per Click Advertising, Search Engine Marketing, Google Adwords adjustments, Remarketing, and Online Lead Generation.-Maintained client marketing and digital advertising budgets and relations.

San Juan, Pr, Pr

-Researched and monitored the diversity and growth of over 10,000 native tropical trees through a National Science Foundation (NSF) grant to understand the effect of land use legacies and natural disturbance on tropical forest ecology and tree community composition.-Responsible for data entry and management of a Long-Term Ecological Research (LTER) database.

Boston, Ma, Us

-Collaborated with Boston Public School administration officials to identify and evaluate key trends in systems data across 10 district schools with the aim to lower high school dropout rates.-Analyzed qualitative and quantitative data for 745+ students at the John P. Holland Elementary School.-Provided and communicated data to multiple stakeholders at City Year Boston and its partners in the Boston Public School District.

Boston, Ma, Us

-Served as the Evaluation Coordinator at the Neighborhood House Charter School.-Collaborated on projects analyzing student state-wide test scores, attendance data, and coursework information.-Developed curriculum, taught, and led afterschool enrichment programs for underserved youth.

Cambridge, Ma, Us

-Generated written content for the Ecologic website covering topics of agroforestry, REDD+, climate change, and deforestation.

Reston, Virginia, Us

-Provided briefing and meeting support for the United States Army Chemical Materials Agency (CMA).-Conducted primary research of industry best practices in project and contract management.

Master Of Science - Ms, Data Science

Bachelor Of Arts - Ba, Biology/Biological Sciences, General

Rainforest Biology & Conservation

High School Diploma, General