Michael

Michael

Data Analyst
Canada

About Me

Educated with a degree in programming and data analytics, as well as a master's degree in biophysics and coding Markov chain Monte Carlo simulations. My education and work are heavily involved in critical thinking and pr…

Experience

Data Analyst

AgSights
Oct 2023 - Dec 2023 · 2 months

Provided quality analysis of existing database of over 2 million animal records and hundreds of data points per animal from the old SQL-based system into the new Microsoft Dynamics platform.
Pinpointed duplicate values in multiple tables and provided data standardization to remove redundancies.
Assisted with database normalization to improve data integrity and data modelling by constructing ERD connecting numerous tables which all together contained hundreds of column labels and their data types.
Presented findings and provided formal pdf reports to provide training on how to use new tools and features for staff and new members and ensured project met business needs.

Data and Market Analyst

Quantum International Services Ltd.
Oct 2023 - Dec 2023 · 2 months

Designed and created SQL database to highlight and connect data after researching in-flight entertainment (IFE) suppliers, technologies, clients, and systems.
Research involved web scraping, surveys, reports, and SWOT analysis.
Successfully created programs in Python to more efficiently streamline processes involved in SQL database construction, ETL, and data QA, while reducing data consistency issues through careful structuring of entities to normalize database.
Overcame time constraint and reading unformatted data from hundreds of pdf files by constructing program in Python that read each file, then accessed OpenAI API to highlight data from files, and extract information into Pandas.
Presented database ERD to coworkers to better communicate database structure and meet business needs, and connect database with Tableau to better encapsulate key insights and uncover trends.

Student Assistant

Lakehead University
Jan 2020 - Jan 2020

Constructed computer simulations to describe bacterial mutation to antibiotics in Python and MATLAB, resulting in the completion in a thesis.
Invented mathematical formulas derived from previous models to describe bacterial evolution.
Marked work in biophysics, modern physics, and first year physics for classes of up to 60 students, and communicated and taught concepts to help students learn physics.

Research Assistant

Lakehead University
Jan 2014 - Jan 2014

Natural Sciences and Engineering Research Council of Canada (NSERC) research grant.
Programmed simulations in physics involving proto quantum computer.
Researched and compared paper results to create program.

Research Assistant

Lakehead University
Jan 2013 - Jan 2013

Data analysis and conducting experiments studying Raman scattering on bacterial cultures.

Research Assistant

Thunder Bay Regional Research Institute
Jan 2012 - Jan 2012

Natural Sciences and Engineering Research Council of Canada (NSERC) research grant.
Attended presentations for the summer school on medical imaging.
Analyzed data collected in PET scanning research and communicated results in final presentation.

Skills

Biophysics Python SQL MATLAB NumPy Pandas SciPy BeautifulSoup PyPDF sqlite3 scikit-learn PyCharm pgAdmin DBeaver Anaconda VS Code Jupyter Lab Linux Postman Excel Microsoft Power Apps Git GitHub Tableau Microsoft Power BI Matplotlib Seaborn Plotly Hypothesis Testing Data Wrangling Data Cleaning Quality Analysis EDA Statistical Modelling Classification Regression Clustering Predictive Modelling ERD Normalization Markov Chain Monte Carlo Gillespie Algorithms Statistical Mechanics Linear Algebra Calculus Differential Equations Presentations Technical Writing LaTeX
Report this Profile?