
This is software (AWS) generated transcription and it is not perfect.
So my name is Spencer Hinckley. I worked for the University of Utah in, uh, Utah USA, Salt Lake City, Utah USA. And I got to where I am through a number of, uh, mentors and through some strong, um, work encounters that I've had and threw my schooling. So Thio kind of line that up and to bring that all together, Um, I have an undergraduate degree in operations management from the University of Utah. I have a master's degree in information systems from the University of Utah, and I have worked at a number of, um, small companies to one Fortune 500 company that has given me the opportunity to rub shoulders with people who have recognized my strengths and been able to have some real conversations with me to say, Hey, I think this is an area that you should pay attention to your skill set into and the continue sharpen those. And, um, if there's one thing that I would say, I feel that those touchpoints, um, did my career more service than anything else that I've done be that schooling or, um yeah, any prep work that I've done aside from those touch points I can say hands down, listening to a mentor, getting that time and hearing, um, where they see their X where their expertise sees the future of my of the is going, um, and preparing based on that has been so helpful.
um, in my position, I handle things from taking on new projects, meaning that we have never seen this type of work before. Um, example. A use case example of that would be throughout Cove it onda pandemic that we've been seeing Now we did not have the ability to ramp up our telehealth services to be able to grant people telehealth appointments or two for their appointment reminders to transition to a Hey, this is a telehealth appointment. So they'd get an appointment reminder telling them to come to clinic when it was really a telehealth appointment that they could take from their phone on DSO using data in our data warehouse and available through the Elektronik health record, Um, I wrote an algorithm that would go through and could assigned with relatively high accuracy around 97 to 98% accuracy. Um, which appointments should be considered telehealth. And then we supply that data to a third party vendor who then manipulates that text message to say that this is a telehealth message and this is how you get those get onto those appointments so it reduces, um, patient confusion. We get a higher, um, success rate reducing are no shows. So we get. It's better for our revenue. It's better for our operations. It's better for patient care. Um, so we handle we have a problem. Projects like that as well as things like, Hey, we have this new drug. We wanna see if we could do a study based on patients with these conditions. Can you help us to see how many patients we have that might qualify? So a very big range of operations. Um, but all in all we use we use data available from the EMR or from different healthcare operations to answer health related questions. Operations related questions down to even how many rooms should we rent in a month?my top three priorities of the areas that I really focus into our How can we keep our operations informed so that they their best decisions? Ah, how are we staying ahead of the curve? And what relationships do we need to be making? Um, as in in our, uh, data aspect, the data points that we really see as data people. We are all familiar with what the concept of metadata is or the data about the data. And we tend to take data as law. But in reality, it is the metadata of what his ah process that has already happened. And we need help putting that into context. And those relationships are the only way that you're going to be able to do that. Um, and furthermore, if you're trying to drive change with data without those relationships in place, uh, showing up to a meeting with data can be very intimidating to people. But if you've already bridged that gap, if you've already made that relationship and it's more about the story you're trying to tell, you'll be so much more successful in your career.I work, I would say I'm regularly a 40 hour week individual. Um, I do have the occasional 50 or 60 hour work week, but the majority, I would say my averages right around 40. Um, part of that is that I even employees, um, demands that they are, uh, when they're at work there at work and when they're not at work. I don't want them to be at work, So, um, it's, I think work life balance is a very important thing. And I've tried Thio keep that in my own life, and I also keep it for my employees.
eso I would say our biggest to Softwares on all time. The languages with it are. And I probably put three in here. Eso we use SQL through, uh, Toad Micro. Sorry. Quests toed, which is the Dale product. Um, and that's it's been a great, um, relation database query tool that we have used across the board for my sequel, Oracle Access databases. Basically, to manage all of them and to manage our connections. All of them we love using. Yeah. Thank you. Toad is the name of the software eso we use toad. For data analysts, the second one would be tableau. Ah, lot of our data work data, prep work, automation zones will all be done in code. And then all of our visualizations will be done in tableau. And we do have a tableau server that we push everything to we maintain, and then we show basically our operations dashboards are all built there. The nice thing about it is we get to see who's using them, how often they're hitting them on gives us nice user feedback so that we can see what features people have liked. What features people aren't using. Onda helps us to know where we can go out and re educate or where to go out and hit that people are using. And it's been successful. Aan den. The last one would be Microsoft Excel. Um, this one kind of just are quick and dirty If we're just proving, um that hey, we can make something useful out of this before we'll invest the time to push it into tableau will probably build a draft version of it in itself. And we'll use vb eight. Oughta me? Um and our automation scheme is, uh it's dated, I would say on DWI use anything from command prompt dos to vb a andan, the toad automation scripts. So, really, those three languages are the most common we use.