Who Am I?
Hello! My name is Erik and I am a professional problem solver. In my spare time I enjoy reading SciFi novels, picking up new hobbies, traveling, and a variety of types of gaming. I’ve spent the past ten years working with healthcare data. My specialities include SQL, Linux, Git, HL7, Automated Testing, Automation, Python, and Quality Assurance. I wear a lot of hats during my tenure so this website was build in order to assist with displaying and promoting my skillsets to potential employers.
Skills & Proficiencies
Problem-Solving
Technical Communication
SQL
Relational Databases
C#
Linux
Python
Experience
As a Senior Engineer at the Craneware Group, my role expanded into role more focused on mentorship and advanced problem solving. I became responsible for the technical setup of onboarding process of new hires with our environments as well as became a default point of contact for questions they may have.
- Operate as a direct point of contact for high impact issues affecting customers.
- Manage relationships with stakeholders through regular communication, informative reporting, and solutions engineering.
- Translate client requirements into viable solutions within the application.
- Read, write, and document internal company code (Ruby, SQL, PHP, and sh).
- Take initiative by identifying and filling potential knowledge gaps on the team.
- Proactively diagnose issues and alert key players before these issues become larger problems.
- Mentor and train new team members.
- Continue with the responsibilities as the Application Support Engineer
The technical client support team (TCS) manages all post-deployment product issues within the company. They are directly in contact with customers who have issues that were not solved by the standard support department. Through regular communication, TCS generates reports, writes custom SQL scripts, and engineers solutions to customize the products to our clients needs.
- Translated client symptoms into both requirements documents and proposed solutions. Communicated these to clients in a way that was understandable and non-technical.
- Managed relationships with internal and external stakeholders.
- Generated informative reports to augment explanations and increase client confidence in a proposed solution.
- Read, wrote, and documented internal company code using languages including Ruby, SQL, PHP, and Shell Script.
- Leveraged existing frameworks to format, ingest, and validate data being brought into the system by external healthcare entities.
- Acted as a subject-matter expert for the patient database component of our product.
- Designed a suite of SQL queries and scripts for TCS team members to utilize. This led to significant improvements in our ability to diagnose problems.
Worked as a team in order to create and implement an automated testing workflow for the company. This included an implementation of a Jenkins CI/CD pipeline, a full testing suite developed in C#, and customer reporting pipelines to provide information to stakeholders.
- Implemented an automated service that tracked and marked internal documentation for regular review. This included pipelines that assigned the review of pages out to qualified reviewers to assess the documentation and maintain it as needed.
- Designed a reporting pipeline for automated testing efforts of new products. Ensured that these reports had proper documentation and all provided information was clear and concise.
- Worked in C# to implement testing requirements and deploy them out via our automated testing suite.
- Stress Tested new tools and new products in order to ensure durability, scalability, and resource expectations.
- Built custom installers for outdated products in order to minimize our technology stack.
Operated as a Quality Assurance contact for all departments seeking answers on complex issues. With my product specialty, SQL knowledge, and problem solving skills, I acted as a critical source for answers.
- Operated as a high-tier support resource for our highest-value clients.
- Worked closely with development and support departments
- Supported and re-wrote the installation suite for our main product.
- Acted as liason between the support and development departments.
With the executive team being sunset, a role was created to allow me to continue to operate as a key member of the team. This role enabled me to be flexible between tackling complex support issues that continued to arise and testing new technology. New technologies were documented in a way that the support team was able to smoothly adopt their responsibilities on release.
- Continued to operate as a primary resource and key problem solver for the support team.
- Directly supported our highest-value clients with 24-hour availability.
- Served as the primary resource for testing new technology being introduced to the department.
- Acted as the department liaison between Support, Development, and QA to ensure high quality solutions were found.
- Leveraged PowerBI and SSRS to generate and support dynamic reporting for clients.
Originally hired on for the technical support team, I gained a reputation for rapid resolution of issues and consistent positive remarks. Between a sharp memory, a knack for pattern recognition, and a keen eye for detail, I was quickly promoted to a technical lead position.
- Managed Microsoft SQL Server instances for clients; performed regular maintenance, managed data retention policies, and diagnosed database related issues.
- Gathered complex laboratory requirements and translated them into viable product workflows.
- Coordinated with other departments to prioritize and resolve recurring issues.
- Wrote custom SQL backed reports for clients. These would be implemented later as critical reporting pipelines.
- Operated as a primary contact and solutions expert for clients with complex long-standing issues.
- Performed additional development for departments internal applications.
- Gathered complex laboratory requirements and translated them into viable product workflows.
- Coordinated with other departments to prioritize and resolve recurring issues.
- Wrote custom SQL backed reports for clients. These would be implemented later as critical reporting pipelines.
- Operated as a primary contact and solutions expert for clients with complex long-standing issues.
- Performed additional development for departments internal applications.
Projects
The majority of my projects are conducted through work. However from time to time I make things that I find necessary or helpful that get put onto GitHub.