Best Claude prompts for Credit Analysts

Develop a predictive model using a dataset of 10,000 borrower records, including demographic information, credit history, and loan terms, to forecast the likelihood of default within the next 12 months. The model should incorporate both linear and non-linear variables, and provide a clear ranking of the most influential factors contributing to default risk. Additionally, perform a sensitivity analysis to determine the impact of varying economic conditions on the model's predictions.

Conduct a thorough audit of a Snowflake database containing 5 million rows of credit data, identifying and documenting any data inconsistencies, missing values, or formatting errors. Develop an optimized ETL pipeline using Python to cleanse and transform the data, and implement data validation checks to ensure accuracy and completeness. Provide a detailed report outlining the audit findings, proposed corrections, and recommendations for future data quality improvements.

Perform a comprehensive regression analysis to identify the key factors driving credit score fluctuations among a population of 50,000 borrowers. The analysis should include a review of demographic characteristics, credit history, and loan performance metrics, as well as an examination of potential interactions between variables. Develop a set of predictive equations to estimate credit score changes based on these factors, and provide a clear interpretation of the results, including any implications for credit risk assessment and lending strategies.

Develop a comprehensive portfolio risk assessment framework to evaluate the potential impact of various economic scenarios on a $1 billion loan portfolio. The analysis should incorporate a range of stress testing scenarios, including recession, interest rate fluctuations, and industry-specific disruptions. Provide a detailed report outlining the portfolio's risk profile, including expected losses, value-at-risk, and stress test results, as well as recommendations for risk mitigation and portfolio optimization strategies.