Yan Jin
*** ****. ***. *** ****, King of Prussia, PA 19406 484-***-**** 312-***-**** *********@*****.***
EXPERIENCE
GE Edgelab, Stamford, CT Sep 2008 – Dec 2008
Graduate Research Analyst, GE Goldseal Supply and Demand Forecast Project
• Performed data preparation, and conducted statistical analysis to identify risk drivers of revenue and cost at supply market and demand market
• Built decision trees, linear regression model, and time series model to quantify the relationship between the risk drivers and the profit margin
• Ran Monte Carlo simulation, and performed scenario analysis, stress test and sensitivity analysis
• Recommended optimal decision makings on buying price, selling price and buying quantity using @risk software
• Presented the model framework to GoldSeal management and convinced them to implement the model
• Wrote tutoring documents for future analyst to use the model, defining scope and business requirements, detailing technical work and providing examples
WASHINGTON MUTUAL, San Francisco, CA May 2008-Aug 2008
Credit Risk Analyst Intern, Credit Card Acquisition Strategy Project
• Designed and maintained SAS programs (Base, Macros, SQL) to collect data from various databases and track the performance of credit card accounts
• Built monthly MIS reporting dashboard with Pivot Table and charts for four marketing channels
• Evaluated current underwriting strategy and two competing strategies by analyzing account balances, default rates and charge off rates in terms of fico scores, utilization rates, age, vintages, etc
• Forecasted future performance of the three underwriting strategies under different assumptions
• Concluded with clear evidence that the current acquisition strategy was superior to the other two alternatives in terms of balancing new business acquisition and risk control
• Presented the findings to both the marketing and risk management departments with excellent feedback
DOW JONES CONSULTING (SHANGHAI) LTD. BEIJING OFFICE, China Feb 2001 - Jan 2007
Senior Editor
• Coordinated the launch of The Wall Street Journal Chinese website. Generated $0.5MM internet ads revenue
• Analyzed page view data and click-through data under different web strategies to improve website design using Excel, Access. Increased website traffic by 30% and ad revenue by 50%
• Identified the drivers of page views, quantified the impact of different layout and the change of columns. Presented findings and recommendations to senior management and led the WSJ website re-design
• Established a partnership with the local magazine Money Journal to explore the print market in China. Increased profits by $200,000 a year
INDUSTRIAL & COMMERCIAL BANK OF CHINA, Changchun, China Jul 1997 - Jan 2001
Loan Portfolio Analyst
• Built predictive models and conducted in-depth analysis for $5 billion loan portfolio. Identified the drivers of loan performance and helped reduce the delinquency rate by 5%
• Led the implementation of a credit management system at 85 branches in Jilin province.
• Offered trainings to coworkers on the system as well as basic data mining and predictive modeling principles
• Monitored local branches on government regulations and internal controls compliance
Credit Risk Analyst
• Monitored and forecasted default rate and prepayment rate for residential mortgage portfolio
• Conducted due diligence on mortgage application documents and helped prevent fraud
• Published monthly reports on mortgage portfolio performance and supported management on market positioning
EDUCATION
UNIVERSITY OF CONNECTICUT Aug 2007- May 2009
• Master of Business Administration (MBA) Concentration: Finance GPA: 3.89/4.0
• Full scholarship recipient. Outstanding Finance MBA Student Award
JILIN UNIVERSITY, Changchun, China
• Master of Economics; Concentration: Finance Jul 2000 - Jun 2002
Bachelor of Economics; Major: International Business Sep 1993 - Jul 1997
Scholarship in four consecutive years for academic excellence and leadership in activities
SKILLS
• Excellent in SAS, SQL, and Excel VBA.
• Certified SAS Base and SAS Advanced Programmer
• Expert of Excel, Access, PowerPoint, Visio, and @Risk