Learn Data Skills
Beta
Jennifer-Celestine Johnson

Jennifer-Celestine Johnson

Business Analyst

Texas Tech University / University of Houston | Dallas, Texas

Technologies

My Portfolio Highlights

My New Article

Environmental Economics Policy Memorandum

My New Article

Environmental Economics Policy Memorandum

Analyst ready to exercise experience in a collaborative effort!

My Work

Take a look at my latest work.

DataLab

Project: Analyzing Students' Mental Health

DataLab

Project: When Was the Golden Era of Video Games?

notebook

Analyzing International Debt Statistics

article

Environmental Economics Policy Memorandum

DataLab

Project: Analyzing Students' Mental Health

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

IBM Excel Analysis

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Joining Data in SQL
Data Manipulation in SQL

My Work Experience

Where I've interned and worked during my career.

Texas Tech University | Aug 2020 - May 2023

Economics Reserach Associate

- Key member of Environmental Economics research study focusing on government subsidies for alternative energy sources. Research included government expenditure, wind energy allocation, population interest, & forecasted use. - Analyzed supply and demand data between consumers and the market based on expenses for windmills. Study included correlating external factors to customer demand, income & substitution effects, population incentives, proximity to noise, and complements/substitutes.
Show More

Galloway Clinic | Dec 2020 - Jan 2022

Customer Data Analyst

- Maintained patient database to review last visit's details and determine course of treatment. Increased customer retention from 65% in pre-transitional period to 93% for clinical visits. - Utilized SQL to find customer details for more productive visits; Number of patients seen per hour (output) increased from 3 to around 4.5. - Forecasted & visualized volume of walk-in patients expected throughout the week with R regression & Tableau

Zwicker & Associates, P.C.

Paralegal Assistant

- Applied Excel to post judgment litigation reports to more efficiently reach company metric goals. After applying pivot tables and filters through 18,000 debt cases, I was able to select the highest-balanced delinquent accounts to award us our maximum profits. - Corrected bi-weekly reports of summary, agreed, trial, and default judgments from stakeholders to ensure legal compliance with our clients, the plaintiffs (American Express, Goldman Sachs, Discover, OnDeck Capital, & PNC Bank). - Communicated with district/county courts to follow up with case progress using Excel pivot tables. Doing this allowed us to retrieve our judgments to be aggregated to our monthly productivity metric. - Communicated with disgruntled defendants (often hostile) to give provide legally complying directives on how to progress with their debt case. - Maintained an F-drive personal database of all judgments ever retrieved in my employment (2,100+) so that any future inquiries about cases could be easily answered. - Calculated simple statistics on projected post-judgment discoveries to be mailed out based on last date of payment, previous monthly counts, and productivity of pre-judgment teams. - Used pivot tables to collaborate with supply chain of post judgment discoveries to satisfy legal deadlines of documents. - Utilized process MACROS to lessen manual work time (crucial for productivity output). - Cleaned data within quantitative reports for forecasted volume of cases to be status changed

My Education

Take a look at my formal education

Bachelor's in EconomicsTexas Tech University | 2023

About Me

Jennifer-Celestine Johnson

Inquisitive analyst yearning to apply newfound analytics skills towards a collaborative effort. Business oriented mindset ready to apply SQL, Excel, and data visualization tools to maximize company value.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free