Avatar

Ralitza Mondal

Business Analyst and experienced teaching assistant with a demonstrated history of working in the higher education industry. Skilled in Research, Matlab, Python, SQL, and Statistical Data Analysis. Strong education professional with a Bachelor's degree focused in Data Science from Clark University. Currently pursuing Masters of Science in Business Analytics at Seattle University.

Seattle, WA

ralitzamondal@gmail.com

5088477504

Programming Languages

Java

70%

STATA

80%

R

80%

Python including pandas,numpy

70%

SQL

90%

Languages

English

Bengali

Bulgarian

German



Experience

Data Analyst (Internship and paid position)
Click here to see presentation
Clark University, Worcester, MA
May 2018 - May 2019

  1. Programmed algorithms to text mine Clark University over 1000 reviews on various websites including non-English, yielding in vital information on areas of potential improvement in campus community.
  2. Implemented predictive modeling, LSA on web scraped reviews on Clark and produced concept matrix using packages in R resulting a scalable process that can be used to scrape new additional reviews.
  3. Applied data mining methods on text scraped and produced concept matrix using packages in R.
  4. Standardized over 18000 variables on student engagement data using sqldf in R speeding up queries on the dataset by 300 times.
  5. Initiator of a project of merging first destination surveys with student data by cleaning and merging over 10,000 student records in last 10 years.
  6. Merged student employment and retention data that has never been done at the institution before making it more predictable to track student's potential success
  7. Utilized Tableau and R for visualizations of predicting markers of student retention enabling viewers to interact with the data.

Web Publisher
PWPP Clark University, Worcester, MA
Aug 2016 - Dec 2016

  1. Publish articles for the People's World Peace Project Website
  2. Contacted media partners for weekly posting for the Website
  3. Collected data on how popular the website was around campus
  4. Evaluated the data over the period of 5 months to check which variables correlated with the website performance

Projects

Data Visualization on Human Resources
Click here to see Technical Appendix
Click here to see Memo
Seattle University, Seattle, WA
Sept 2019-Dec 2019

  1. Analyzed employee attrition of 16% and come up strategies to reduce attrition
  2. Successfully identified two significant findings for strategies of employee retention with 95% confidence interval
  3. Targetted significance of proportion of total working hours of employees invested in current role and manager
  4. Visualized the effect of training on attrition for employees
  5. Evaluated that trained employees should increase their time with their manager by 2 months and 4 months in their current role to achieved 100% retention

Airline Demand Forecast with Python
Click here to see project on github
Seattle University, Worcester, MA
Sept 2019 - Dec 2019

  1. Created a multiplicative model with a rolling average which reduce the reduced the mean absolute scaled error from the naive forecast by 30%
  2. Used training data set with 84 departure dates to train the mulplicative model
  3. Developed predictive modeling that accurately predicts final demand on a new data set


Data Visualization on Cereal Producers
Click here to see Technical Appendix
Click here to see Memo
Seattle University, Seattle, WA
Sept 2019-Nov 2019

  1. Analyzed the advantages of General Mill as a competitor over other producers by tracing median revenue over 52 weeks
  2. Successfully identified two significant findings for strategies of promotion and advertisement with 95% confidence interval
  3. Targetted significance of median revenue difference by promotion and advertisement based on brand
  4. Visualized the significance of mean revenue difference based on promotion and advertisement over 52 weeks

Capstone Project on Effective of Culling on Survival of Tasmanian Devils
Click here to see presentation
Clark University, Worcester, MA
Aug 2018-Nov 2018

  1. Used ordinary differential equations on three categories of Tasmanian population and uncertainty of latency to perform a stochastic model
  2. Collected data sets on latency,birth rates and death rates of Tasmanian Devil to run simulations on the stochastic model
  3. Successfully produced three equilibrium scenarios which involes disease-host coexistence, disease eradication and host extinction to minimize the cost of maintaining the strategy of culling
  4. Evaluated that disease eradication happens less than 2% of the time with a small remaining population of Tasmanian Devil
  5. Stochastic analysis finalized that culling will not retain a high enough healthy population of Tasmanian Devil to reach a non-endangered level.

Econometrics Women's Health Project
Click here to see presentation
Clark University, Worcester, MA
Jan 2018-May 2018

  1. Used Logit models to predict the variables for the health issues of women in the US
  2. Regressed large data sets as large as 600 per set on women’s health conditions on several socioeconomic factors using STATA
  3. Hypothesized the significance of health care coverage over women’s health for years 2006-2016
  4. Hypothesized the significance of difference between health care coverage and the behavioral risk factors such as smoking, alcohol, obesity and stress.

Econometrics House Prices Project
Clark University, Worcester, MA
Jan 2018 - May 2018

  1. Created a model successfully to predict the houses prices according to the demographics in US
  2. Hypothesized the significance of variables in the models using t and F tests
  3. Tested slope coefficients of models using Chow tests
  4. Tested for heteroskedasticity by Breusch Pegan and White test

Interacting Species Project
<Click here to see results
Clark University, Worcester, MA
Aug 2017 - Nov 2017

  1. Analyzed of mathematical model for the large increase in the percentage of selachian during WWI
  2. Developed two model scenarios for the prey and predator population by testing for different coefficients from the ordinary differential equations in MATLAB
  3. Presented a full interpretation in class of the results of the Volterra principle through my analysis

Zoo Management Database System
Click here to see project on github
Clark University, Worcester, MA
Jan 2017 - May 2017

  1. Created a relational model between the administrator and the user/visitors of the zoo
  2. Used SQL to query data in the table
  3. Developed database application using Python by testing CRUD functionalities and create a user interface


Education

Seattle University,Seattle,WA
till Dec 2020

Masters of Science in Business Analytics, expected Dec 2020

Click here to see university's MSBA program
Clark University,Worcester,MA
Click here to see university
till May 2019

Bachelor of Arts, Double major: Economics and Mathematics, minor: Computer Science, graduated May 2019

Member of the Omicron Delta Epsilon, the International Honors Society for Economics

Manga Cum Laude