Jaime Ramirez, MA
Data and Reporting Analyst at St. Mary's University- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
St. Mary's University
-
United States
-
Higher Education
-
700 & Above Employee
-
Data and Reporting Analyst
-
May 2022 - Present
•Daily task were to handle ad-hoc data request from in-house clients by using IBM Cognos to calculate student need in 10,000s of dollars, graduation and retention rates for hundreds of students, cleaning legacy static data containing thousands of students. •Completed US NEWS & World Report College Rankings by calculating graduation rates for over 600 students, top ten majors by percentages for whole undergraduate, and student to instructor ratio. •Calculated approximately $200,000 of student financial need among four STEM majors for an academic year, along with retention and graduation rates, for a National Science Foundation grant. •Found and pointed out errors within data warehouse to leadership as well as sat in meetings to find solutions to said problems. Examples: wrongly attributed ethnicity for hundreds of students and hierarchy issues within evaluation system. Show less
-
-
-
AllianceBernstein
-
United States
-
Investment Management
-
700 & Above Employee
-
Corporate Analyst
-
Apr 2021 - Oct 2021
•Ran 20 daily tasks through Microsoft Access critical towards Financial Control Department and used Access to find information within databases requested by in-house clients. •Worked on request to terminate dealer relationships on mainframe using legacy systems and verified net asset values of mutual funds from dealers as well. •Worked in collaboration with outside departments within the company such as the financial control department, auditing department, tax department, and provided analyst support to the investment services department. •Trained new member to the team. Show less
-
-
-
The University of Texas at San Antonio
-
United States
-
Higher Education
-
700 & Above Employee
-
Research Assistant
-
Jun 2020 - Dec 2020
Data wrangling: date formatting, turning raw data into a data frame, removal of junk observations, and vector and matrix transformations. Exploratory Analysis: Scatter plots of response variable and independent variable Regression Analysis: OLS, LPM, classification, probit, logit, and mixed multinomial logit model Data wrangling: date formatting, turning raw data into a data frame, removal of junk observations, and vector and matrix transformations. Exploratory Analysis: Scatter plots of response variable and independent variable Regression Analysis: OLS, LPM, classification, probit, logit, and mixed multinomial logit model
-
-
Education
-
The University of Texas at San Antonio
Master's degree, Economics - Data Analytics and Forecasting