I joined Galen in November of 2014. I’m a technical consultant and my main focus is on data migrations. I take the clinical patient data from a Source system’s database and extract it via SQL into our middleware platform GalenETL. From there, the data is transformed so it can be ingested by the Target EHR via HL7 messages or SQL script. I’ve also dabbled in custom reporting and SQL scripts but migrations are my area of expertise.
What were you looking for during your job search? What made you choose Galen?
When I was looking for a career move, I knew that I wanted to stay in the healthcare industry but I also wanted diversity in the work that I do. I wanted to be able to learn and build upon my knowledge and skill set. Galen finds themselves working with a plethora of clients and vendors which provides a wide range of projects which sealed the deal for me. However, I had initially found Galen while I was working for an EHR vendor. I was searching for an answer to an issue and instead of finding the solution via internal documentation, I found it on Galen’s Wiki. The article was clear and concise enough that I was able to use it to resolve the problem. That was my first glimpse into the expertise that Galen has.
Can you tell me about a particularly tricky project that you had to find a unique/innovative approach for? And what was the outcome with that client?
Recently, I was working on a data migration where the Source EHR stored their clinical notes in binary. We had a custom program to decompress the binary to text but the outcome was a proprietary HTML format. Our technical team built a plugin that would take the HTML, apply a stylesheet, and turn the text into a PDF. Most document management systems can handle PDF but this particular client’s setup only allowed TIFFs in Group 4 compression. We were able to accommodate both custom requests within 3 months, a third of the typical migration project timeline.
In summary, for those who want to skip the technical mumbo jumbo, we were able to overcome 4 hurdles within a short amount of time. The client was ecstatic that we were able to accomplish such a feat and we also saved them money because they did not have to go directly to the EHR vendor. Without being able to work closely with my coworkers to test and troubleshoot the plugin the project would not have been as successful.
What has been most unexpected about working here?
Everyone I’ve had the pleasure of working with at Galen has their own unique set of skills and brings something to the table. I’ve never worked in an organization with so much talent. The cherry on top of this mound of knowledge is that everyone is always willing to help. Questions are always answered, advice given in spades, and it’s always followed up with, “Let me know if you need anything else.”
Anything else you’d like people to know about working at Galen?
There aren’t many more pros I can say about Galen that I haven’t already said. I came here because I refused to believe that, ‘A job is just a job.’ Galen proved me right, a job can be so much more, and I encourage you to try and prove us wrong.
Caught the Galen culture bug? Meet some other awesome Galeneers here.