Peter Ling Email & Phone Number

New Brunswick, NJ, US

• Created technical documentation and coordinated with developers for the Control Tower project, producing 5 custom data reports, using MS Azure Synapse and SQL.
• Supported the implementation of the MedTech Cost to Deliver model by conducting UAT testing, gathering feedback from stakeholders and end users, and use-case value identification, leading to $60K in cost improvements.
• Managed the development and pilot of the Enhanced Backorder Report, using Alteryx, SQL, SAP, and MS Azure Synapse, to assess potential data sources, create a workflow, and incorporate user feedback into the Minimum.
• Developped a pilot for the DePuis Synthes scanning sheet, using Alteryx, Python, and MS Excel, to create a customized list of material information, with scanable QR codes, which increased the data quality of hospital.
• Automated the unpacking aid report, using PowerBI Report Builder generating 10 hours of time savings to date, and increased the scalability of the solution.
• Currently leading the migration of all CA MedTech data objects into the NA MedTech Azure Synapse environment, for a cost avoidance of $500K.

New Brunswick, NJ, US

• Automated report generation, CIP calculations, and other MS Excel based tasks with Python, Pandas, SQL, Pyodbc and MS Power Automate to repurpose ~150 hours of manual data processing.
• Created and maintained Tableau dashboards to visualize metrics and generate stocking recommendations to engage customer groups across Canada.
• Developed an automated workflow to update and publish Tableau dashboards with Tableau Prep, SAP, Python, and Pandas, that repurposed ~5 hours of manual data upload a week.
• Delivered trainings to team members on analytics tools such as Tableau, Python and MS Excel.

• Facilitated workshops of 90+ attendees by leading presentations and helping with debugging using Jupyter Notebook, generating leads from organizations such as PC Financial, CIBC, and Professional Engineers Ontario.
• Created four-workshop Python tutorial, using Python, Pandas, Sci-Kit Learn and Matplotlib, engaging over 1000 students and professionals to date.
• Employed text mining and Natural Language Processing (NLP) algorithms to database of job listings, using Python, NLTK and spaCy, to identify in-demand skills for co-op students.

Toronto, Ontario, CA

• Entered data from patient charts, using Microsoft Excel, producing spreadsheet with information of over 50 patients.
• Performed cleaning, normalization and manipulation of patient data, using Microsoft Excel, to be used by colleagues in further analysis.

Education record

Bachelor'S Degree, Biomedical/Medical Engineering