JEAN PAUL MITTERHOFER

Data Engineer & Analyst with 4+ years of experience building cloud-based applications and data solutions. B.S. in Computer Information Systems. Strong technical foundation with hands-on AWS expertise and proficiency in Python programming language. Eager to contribute to innovative, high-impact cloud projects.

• Python Programming

Rice University - School of Continuing Studies

ID: https://youracclaim.com/badges/051df398-b7f2-46f0-bc24-563fc423a773

Create a Python script that analyzes financial records of a fictitious company and prints the results to the terminal as well as exports a text file. Create a Python script that analyzes poll data from multiple counties and prints the results to the terminal as well as exports a text file with the results.

Create one of two challenges: create a report using Python Pandas to analyze purchasing data from a gaming company's fantasy game, or create a report using Python Pandas to analyze a school district's standardized test results and showcase trends in school performance.

Create one of two challenges using Matplotlib, Pandas, and Jupyter Notebook: create bubble plots and pie charts that showcase relationships between key variables and city types for a ride-sharing company, or create a scatter plot and bar graphs that show results between different treatments from a pharmaceutical company's most recent animal study.

Create a representative model of weather across world cities using either Matplotlib or Pandas and the OpenWeatherMap API.

Demonstrate appropriate methodologies for data importing and preprocessing, such as data type-casting and text sanitization.

Demonstrate clean coding techniques such as abstraction of functions, commenting, and effective git commit messages.

Demonstrate consideration of code efficiency.

• Databases and ETL

Rice University - School of Continuing Studies

ID: https://www.credly.com/badges/c4ea7364-0e46-48a6-95ea-1c04a7c4516a

Create complex SQL queries that return various data from across multiple tables in a database.

Create a climate analysis using Python and SQLAlchemy for a specific set of dates, creating plots for different variables such as precipitation and temperature.

Design a Flask API based on the queries developed in the climate analysis that returns data in JSON format.

Create a production database that combines 2 or more sources of data from either database, APIs, or web scraping, and then perform the ETL process on the data in order to populate the production database along with a technical report on the entire process performed.

Justify database type to be used based upon application and underlying data.

Demonstrate effective use and understanding of the purpose of ORM's.

Demonstrate effective use of normalization on a SQL database.

Demonstrate successful deployment of remote database resources.

• Web Visualization

Rice University - School of Continuing Studies

ID: https://www.credly.com/badges/31c279f0-137a-4c4b-8b8d-4cbe9def1923

Create a website to host a visualization dashboard to display visualizations from a previous assignment, including various pages and a page to display the data used to build each plot.

Create a web application that scrapes other websites for data related to the Mission to Mars and displays the information in a single HTML page.

Create a web application using HTML, CSS, JavaScript and D3 that displays information from a dataset in a table that is updated dynamically based on user filters.

Create and deploy a Flask web application to Heroku that includes a dashboard page showcasing interactive charts based on a dataset.

Create a scatter plot showing states data on health risks and factors from two different data sources compared on multiple variables using D3.

Create a geographical visualization of earthquake data pulled from a JSON dataset using D3, including data markers, pop-ups with additional information, and an additional data set to illustrate the relationship of tectonic plates to seismic activity.

Demonstrate understanding of client-server interactions, including data retrieval from a database using a front-end request through a Flask server.

Demonstrate effective chart selection for underlying data

• Apache Druid Basics

Imply | ID: https://verify.skilljar.com/c/8x6mzpy453y

• Advanced Excel

Rice University - School of Continuing Studies

ID: https://www.credly.com/badges/cdbe3653-55e5-4a82-b0a8-1d41dc999f2c

Analyze a dataset using Microsoft Excel and use formulas, pivot tables, stacked column pivot charts, and pivot chart line graphs to view trends within the data. Utilizing of conditional formatting to detect anomalous data or trends.

Analyze real-world data using VBA scripting that work on multiple sheets of data in Microsoft Excel.

Demonstrate appropriate tool selection when using Excel over other tools in course

• Resume Website: jpm.social-networking.me/