Conrad Lewis

Portfolio

Data Analyst skilled in AWS, SQL, Tableau, and Python

Hi there! I'm Conrad

Highly motivated and results-driven data professional with 5+ years of experience. Proven ability to analyze complex datasets within academic research. Expertise in Python (pandas, NumPy, SciPy), SQL, Excel, and Tableau, honed through computational and theoretical chemistry projects.

Skills:

  • Data Analysis: Proficient in Python for data cleaning, manipulation, statistical analysis, and modeling.
  • Database Management: Experienced in querying and managing data within relational databases using SQL and BigQuery.
  • Visualization: Adept at creating compelling visualizations with Tableau and Python (matplotlib) to communicate insights clearly.
  • Project Management: Strong background in leading research projects, developing project management and organization skills.

Equations of State

Have you ever noticed how squeezing a balloon changes its shape and its resistance? Just like that, imagine an equation that predicts how things like pressure, volume, and temperature influence each other. That's an equation of state! It's like a recipe for matter, telling us how a substance's behavior (solid, liquid, gas) and properties (like density) dance with changing conditions. In my Python project, I used this recipe to build a model that can predict the volume given pressure data and vice-versa. By reading the code of these equations, we can unlock secrets about materials, stars, and even optimize processes like creating new medicines. It's all about taking the pulse of the universe, one equation at a time!

Tableau Emergency Room

In this Tableau dashboard, I delve into the dynamics of Emergency Room data. Visualize the influx of patients across age groups, genders, and races. I expose inefficiencies with heatmaps showcasing peak wait times, and track patient satisfaction alongside their eventual department destinations. This data-driven tool empowers informed decision-making, paving the way for a smoother, more equitable ER experience.

Variational Hydrogen

Atoms, the fundamental building blocks of matter, can be visualized as miniature solar systems with electrons orbiting a central nucleus. In the simplest case, the hydrogen atom, understanding the electron's behavior is key to deciphering the properties of more complex materials. My project employed the variational principle, a powerful mathematical tool in quantum mechanics, to approximate the ground state energy and wavefunction of the hydrogen atom.

Education

MIDDLE TENNESSEE STATE UNIVERSITY (2017 - 2019)
Master of Science, Chemistry
  • Lewis, C., Proynov, E., Yu, J., & Kong, J. (2022). Analyzing cases of significant nondynamic correlation with DFT using the atomic populations of effectively localized electrons. Theoretical Chemistry Accounts, 141(3).
    https://doi.org/10.1007/s00214-022-02871-z
  • Volunteered as Technical Support for Women in STEM
MISSISSIPPI COLLEGE (2014 - 2016)
Bachelor of Science, Chemical Physics
  • 1st place in Physical Chemistry Presentation at Annual Honors Banquet 2015, Hattiesburg, MS