Jordan Hoolachan Email & Phone Number

- Developed and deployed fully automated solutions to send customer satisfaction surveys and SMS status updates using Microsoft Power Automate, Microsoft Dynamics 365, Microsoft Customer Voice, and Twilio- Led migration of on-premise reporting server to cloud data warehouse using Azure Synapse Link for Dataverse, Azure Data Factory, and Azure SQL.

- Optimized monthly data extraction process and reduced time-to-completion from multiple days to 30 minutes while improving standardization of the data. This optimization allowed for the data to be extracted weekly, rather than monthly, which provided more up-to-date data to be easily accessible for analysis- Utilized MS SQL Server stored procedures to.

Columbia, MD

Driven customer relationship marketing (CRM) analyst who provides proactive and actionable marketing and consumer insights to major pharmaceutical and retail clients by way of developing customer segmentation profiles, creating and validating test and control groups to allow for campaign measurement, analyzing campaign performance as compared to key.

- Direct interaction with client (Doctors and/or other Hopkins' researchers) to determine project goals and develop an appropriate analysis plan- Analyzed clients' research data and develop concise reports- Presented results to clients in face-to-face meetings- Taught statistics and statistical programming to clients and students during weekly clinics

- Forecasted potential financial damages from high cost insurance claims- Developed a predictive model to determine the frequency of high cost claims in order to mitigate annual losses- Data analysis of historical damage claims and claim trends- Developed project management skills by efficiently balancing multiple projects simultaneously- Provided main.

Bs, Biology, Minor In Mathematics

Master'S Degree, Biostatistics

Focus on clinical trial design/analysis and consulting.