Data Analyst
Resume:
SHAWN LI
Data Analyst Geologist
Phone: 403-***-****, Calgary, Alberta Email: ***************@*****.*** 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