Quantitative Analyst Intern Resume San Francisco Bay Area - Hire IT People

SUMMARY

Over 3 years of comprehensive experience in Business Analysis including Data Analysis, Reporting, Statistical Modeling and Business Intelligence tools.
In - depth working knowledge of Access, SQL, VBA, Excel, Python, Tableau, R, SAS and Alteryx.
General Secretary of INFORMS, Student Chapter at University of Illinois Urbana Champaign.
Excellent Client interaction skills and proven experience in working independently as well as in a team.
Possess Employment Authorization Document (EAD) or Work permit to work in USA and willing to relocate.

TECHNICAL SKILLS

Technical: Optimization, Risk Analysis, Statistics, Data modeling and validation, Forecasting models, LGD models

Software: Microsoft Office, HTML, Power-point, Excel, VBA, Tableau, Python, SAS, SQL, R, Alteryx, ETL, Access

Certifications: Lean Green Belt

PROFESSIONAL EXPERIENCE

Quantitative Analyst Intern

Confidential, San Francisco Bay Area

Responsibilities:

Risk Management Model, CCAR
Performed data analysis to generate quarter wise mortgage loss reports to include in Final portfolio.
Developed customized User forms in VBA to improve data quality at database entry level.
Provided SAS, ETL and SQL programming support to develop LGD model for Single Family Residence Mortgages.

Business Analyst

Confidential

Responsibilities:

Insurance Rejection Forecasting Model
Developed a model to classify insurance claims rejection by performing data cleaning and cluster analysis.
Developed a forecasting model in R to forecast the insurance claims into the designed cluster.
Recommended necessary changes to be adapted in those claims in order to reduce the risk of rejection.
Revenue Cycle Management
Performed data mining, data cleaning and data transformation on historical data of self-pay clients using SQL.
Provided SAS programming support to find patterns in historical and transactional data to identify risk zones.
Identified the major factors affecting the present revenue cycle model and reported them in Tableau.
Developed an efficient revenue cycle model on the basis of cost and time-series analysis.