Dan Andrews
System Analyst @Prairie Diagnostic Services Inc
Signup · Get unlimited contacts
WORK HISTORY
System Analyst @Prairie Diagnostic Services Inc
Saskatoon, CA
Integrated D365 Business Central APICollaborated with a highly motivated and successful groupDeveloped SSRS reportsDeveloped Power BI reportsDeveloped Excel Power Pivot reportsModeled data using Star Schema for Power BI/Excel Power PivotDesigned, implemented, deployed and maintained a multi-disciplinary Laboratory Information Management System (LIMS/LIS)Implemented paperless bacteriology workflow and reporting management module that’s integrated with electronic data from the BOIMIC and the MALDI-TOFImplemented secure cytogram image transfer from a Siemens Advia Data Manager using a private network bridge and crossover Ethernet cablesUsed database management techniques to manage incremental schema changes in development, staging and production environmentsAbstracted Microsoft Dynamics GP to a generalized billing web services APIImplemented a custom CRMDesigned and implemented a large LIMS using C#, Visual Basic and Web Services and SQL ServerDesigned a reusable serial-communication-transaction pattern to communicate with real-time devicesImplemented Socket Server ASTM communication with MALDI-TOF and LIMS integrationImplemented serial communication (ASTM) simulator for the Siemens RAPIDPoint® 500 Blood Gas machine and integrated with LIMSImplemented serial (ASTM) for Giles Scientific BIOMIC V3 for transfer of antimicrobial susceptibility data and integrated with LIMSImplemented serial communication transactions for Siemens Advia Hematology Analyzer to deliver real-time data for patient casesImplemented serial communication transactions for Roche Cobas C311 Analyzer to deliver real-time data for patient casesImplemented client and administrative reporting as PDF, Excel and XML reportsImplemented enterprise person-to-person/person-to-laboratory communication using WCF Duplex Web ServicesImplemented a service-oriented architecture for communication laboratory resources
EDUCATION
University of Saskatchewan
Master of Science (M.Sc.), Horticulture Science
University of Saskatchewan
BEd, BSc, MSc, Mathematics, Physics, Computer Science, Horticulture Sciecne
University of Saskatchewan
Bachelor of Science (B.Sc.), Computer Science
ABOUT DAN ANDREWS
I’m passionate about building a better world one day at a time and I’m open to new opportunities. My name is Dan Andrews and I specialize in building effective and maintainable systems. In my free time, I enjoy running, gardening and growing trees. My favourite quote is \"The best time to plant a tree was twenty years ago. The second-best time is now.\" – Chinese Proverb. It’s a great metaphor for life! Congratulations to the PDS LIMS team on their 9th anniversary! They have completed over one million tests on the new LIS (LIMS) system that was built and delivered 9 years ago. The system is live across 11 lab areas including Bacteriology, Immunology, Serology, Pathology, Clinical Pathology, Histology, Parasitology, PCR, Genomics, Toxicology and Virology. PDS is accredited by the American Association of Veterinary Laboratory Diagnosticians (AAVLD). Fantastic job team!
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.