Jacob Johnston Email & Phone Number

Broken Arrow, Ok, Us

Broken Arrow, Ok, Us

Milwaukee, Wi, Us

Milwaukee, Wi, Us

Milwaukee, Wi, Us

Salt Lake City, Utah, Us

-Design, develop, and test ETL procedures in SQL Server to migrate client data from various databases and filesystems into customizable Filevine data structures. Assisted 8 law firms in migrating data for 100k+ client cases to Filevine.-Work with external clients and internal project managers to gather requirements, determine project timelines, and provide technical advice for handling data transformation decisions and data anomalies. -Process internal and external requests for mass data modification using API or web automation with Python. Developed script in Python to handle data update requests where API endpoints were not established.

St Louis, Missouri, Us

- Manage a team of 4 researchers in extracting sanctions data from 1,100+ regulatory agencies each month.- Transform and load the data into a standardized, easily accessible format for client use.- Run quality checks on each researcher's work to ensure work is accurate and comprehensive.- Find innovative ways to increase efficiency in the data collection or manipulation processes.- Use SQL and Microsoft Office tools to generate productivity reports for senior management.

St Louis, Missouri, Us

Melbourne, Victoria, Au

- Applied behavioral science insights to create a new, bias-mitigating process for early-stage research and development portfolio selection.- Designed an interactive online Excel workbook to implement the multi-player, auction-based process.

Provo, Ut, Us

Part of the Life and Family Legacy Project- Organized and managed 50 years’ worth of data on approximately 6,000 participants.- Assisted in the design of the 50th anniversary survey for the project.- Trained and managed other research assistants, ensuring the project ran smoothly.- Created presentations and graphics of data for grant applications and to encourage continued participation.- Located participants of the panel study that have either moved or died.- Operated the machinery necessary to produce and mail mass amounts of documents.- Administered tests, such as the Minnesota Cognitive Acuity Screen, over the telephone.

Provo, Ut, Us

Life and Family Legacy Project

Draper, Utah, Us

- Identified quantitative methods of determining the efficacy of 5 CHOICE Humanitarian interventions in rural Nepal. - Obtained funding through grant applications.- Collected quantitative and qualitative data through guided interviews with 105 local leaders and villagers.- Analyzed and interpreted the data in order to make causal inferences about the effectiveness of humanitarian projects.- Presented the findings and provided recommendations to the organization’s chairpersons.

- Monitored patients and kept a constant log of patient activities/progress.- Measured and recorded vital signs.- De-escalated potentially violent situations and used therapeutic holds when necessary.- Enforced TCBH or court administered policies.- Filled out paperwork and took statements for admissions and releases.

Master Of Science - Ms, Behavioral And Decision Sciences

Bachelor Of Science - Bs, Psychology