Page * of *

SHAWN LI

Data Analyst Geologist

Phone: 403-***-****, Calgary, Alberta Email: adf5nu@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/canadashawnli/ A professional with over 10+ years of performing data analysis, providing meaningful insights and presenting reports to key stakeholders for business performance improvement. Bringing strong interpretive and analytic skills with a passion for discovering solutions hidden in large data sets. Looking to expand data analysis expertise into various industries to enhance business productivity and performance.

HIGHLIGHTS OF SKILLS

Certificate in Software Development with a Master of Science degree in Petroleum Geology

Practical knowledge of Python, SQL, C#, ASP.NET, ETL, HTML/CSS, JavaScript, AWS, PGAdmin (for PostgreSQL databases), Spyder, Jupyter Notebook (anaconda3), GitHub and Docker

Key personal attributes: Self-learning, able to collaborate in a team or work independently, ability to analyze, attention to detail, reliable and strong problem-solving skills

10+ years’ experience in oil & gas, data validation, data collection, data migration, data interpretation, data analytics, integration and management

Organized geological operations projects and solved real-time field problems through timely communications

10+ years’ experience of mapping skills utilizing accurate locations of oil and gas industry assets including wells, facilities, and pipelines

Excellent written and verbal communication and Microsoft Office Suite skills PROFESSIONAL EXPERIENCE

Data Analyst

IJACK™ Technologies Inc. May- July 2020, Calgary, Canada

Project: machine learning with IJack database (82 million records stored in AWS)

Responsibilities: Database query, data cleaning, exploratory data analysis, data visualization, machine learning test

Software: PGAdmin (for PostgreSQL databases), Spyder, Jupyter Notebook (anaconda3), GitHub, Docker

Frameworks and libraries used: pandas, NumPy, Matplotlib, Seaborn, Scikit-learn(sklearn), Keras Southern Alberta Institute of Technology (SAIT) January-May 2020, Calgary, Canada Project 1: Travel Experts Website Development (Grade: A)

Scope: design and construct a prototype website for the Travel Experts travel agency

Programming stack: HTML, CSS, JavaScript, Node JS, Visual Studio Code, Visio, Microsoft Project

Methods: developed a “Main Page” which welcomes the customer and links to three other pages (“Contact Us” page,

“Vacation Package” page, and “Customer Registration” page) Project 2: Northwind Database (Grade: A+)

Scope: create a 3-layer Windows Forms application that connects to a database, retrieves and updates data

Programming stack: C#, Microsoft SQL Server Management Studio, Visual Studio Community, ADO.NET controls and objects

Methods: developed a 2-projects (App and Class Library) solution containing 3 types of classes (presentation classes, business classes and data base classes)

Project 3: Create an MVC Core solution for an Asset Tracking System (Grade: A+)

Scope: develop a web-based asset tracking application including a page listing all asset types in the system as well a page viewing all assets that can be filtered by asset type

Programming stack: ASP.NET Core, Microsoft SQL Server Management Studio, Visual Studio Community

Methods: Developed a multi-layered solution using MVC Core and Entity Framework Core in a code-first approach, Page 2 of 2

created MVC Controllers, MVC Views, MVC Models, view component, user interfaces with HTML helpers, Tag helps and view models

Data Analyst

Linc Energy Inc. October 2014-May 2015, Calgary, Canada

Performed data searching, displaying, validation, interpretation, and integration to evaluate oil assets through comprehensive mapping and analysis with over 2000 wells

Software used: AccuMap, Petra

Evaluated 20+ projects in Alberta and Saskatchewan including Plover Lake, Cactus, Kerrobert, Winter, Rush Lake, Edam, Pikes Peak, Tangle Flags, and Onion Lake etc.

Results: Identified a joint-venture partner for the company and helped reach a project agreement Data Analyst

Petrobank Energy and Resources Ltd. June 2005-May 2014, Calgary, Canada

Performed operational activities to plan, design, and execute well drilling, and updated geological information

Performed well-log data quality control with real time software LogViewer

Report writing after analyzing and refining complex data sets and sources

Participated in weekly team meetings to communicate on individual work progress, problems encountered to ensure schedules on track for each team member

Attained data from multiple sources by data migration, organize and clean data on reports, correct issues and maintain the database

Frequent presentations to AER, team members, monthly oil assets evaluation to manager and professional association conference

Software used: AccuMap, Petra, LogViewer

Projects: Athabasca May River oilsands project (7 years, budget: $50 million), Alberta Peace River oilsands project (3 years, budget: $10 million), Saskatchewan Kerrobert heavy oil project (4 years, budget: $20 million)

Results: Main contributor to the $150 million profit for the May River Project EDUCATION AND PROFESSIONAL DEVELOPMENT

Coursera: Python for Everybody Specialization (July 2020, University of Michigan), Applied Machine Learning in Python (July 2020, University of Michigan), SQL for Data Science (August 2020, University of California), Machine Learning (Ongoing, Stanford University), Data Engineering with Google Cloud Professional Certificate (Ongoing, Google Cloud), Machine Learning: Algorithms in the Real World (August 2020, Alberta Machine Intelligence Institute)

Certificate in Software Development (May 2020), SAIT Courses: Python, SQL, AWS, C#, MySQL, HTML/CSS, JavaScript, Node JS, ASP.net

PhD student: geology (2003-2005), University of Calgary

M.Sc., B.Sc.: Petroleum Geology, Southwest Petroleum Institute Courses: Statistics, Introduction to Computer Science, Basic Computer Programming, Advanced Mathematics, Linear Algebra, Probability and Mathematical Statistics, Computer Technology and Applications

Certificates from IBM online courses (2019)

Big Data 101, Introduction to Data Science, Data Science Methodology, Data Science hands-on with open source tools

Contact this candidate