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- Developed long term strategic roadmap for BGE HOME’s data architecture and infrastructure with a focus on providing a single source of truth… Show more - 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- Developed long term strategic roadmap for BGE HOME’s data architecture and infrastructure with a focus on providing a single source of truth for reporting, self-service business intelligence, and a strong foundation for advanced analytics. Executed against that roadmap incrementally as resources permitted- Independently introduced Power BI to BGE HOME and produced a suite of dashboards spanning every department in the company. Owned the development of the dashboards from the initial conceptual and requirements-gathering phases through final presentation and deployment, including the development of the underlying data models- Informally mentored colleagues through lunch-and-learns, 1-on-1 sessions, and internal message boardsTools: SQL Server, Azure SQL, Azure Synapse (Pool and Serverless), Azure DevOps, Azure Data Factory, Power Automate, Power Apps, Power BI, Dynamics 365 Customer Engagement, Dynamics 365 Customer Voice, Dynamics 365 Customer Insights, Dataverse Show less

- 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 reduce the amount of code needed to complete ad-hoc analyses and improve the consistency of output- Worked with the IT team to set up an… Show more - 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 reduce the amount of code needed to complete ad-hoc analyses and improve the consistency of output- Worked with the IT team to set up an improved address validation pipeline that is more efficient and removes the need for costly standalone software- Created several new dashboards that provided a much more granular look into current trends than was previously available- Standardized the process used to generate mail files which greatly reduced production time, increased readability of code, and improve accuracy/validity of final output Show less

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 performance indicators, and providing custom ad hoc reports as necessary.Extensive experience using SQL to retrieve data from large… Show more 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 performance indicators, and providing custom ad hoc reports as necessary.Extensive experience using SQL to retrieve data from large relational databases as well as experience in manually creating analysis datasets from many disparate data sources. Utilizes SAS, SAS Enterprise guide, and Excel to create clear picture of factors influencing customer acquisition, retention, and attrition in order to drive marketing strategy. Experience in working directly with key client stakeholders to present findings and determine next steps in analyses. Show less

- 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 statistical support for the Johns Hopkins research team

Bs, Biology, Minor In Mathematics

Master'S Degree, Biostatistics

Focus on clinical trial design/analysis and consulting.