Senior Software Consultant
CurrentClient 2 (Education):- Automated manual workflows using T-SQL and Oracle SQL, merging data from multiple sources and saving admin staff hours of weekly data entry- Built high quality data pipelines using T-SQL and SFTP file transfers, reducing error counts by tens of thousands in some cases- Enabled admin self-service through researching reporting options and moving to a vendor-hosted SSRS solution, which increased report security and reduced the number of tickets created for custom query requestsClient 1 (Medical Software):- Drove changes to Agile processes, reducing meeting time for a single team by almost 50%- Ruthlessly simplified a Node.js API used for FHIR data transformations, reducing custom code in favour of pre-existing FHIR standard API calls- Took on Project Management responsibilities when the need arose, building out requirements with stakeholders, documenting the exact needs of the data pipelines and the reasons behind those needs in JIRA Epics- Worked with other Technical Leads to restructure Kafka producers and consumers in Python to reduce redundancy and duplicated workGeneral:- Strong written communication, including documentation and knowledge sharing, seen in blogs written for both developers and technical leaders- Lead consultant teams for both clients, raising concerns and opportunities to the greater Test Double team
