Highlights:

Skills:SQL, PowerBI, SPSS, VBA, HTML, Data Analytics, Statistics, Access, Minitab, Python

Research Assistant 09/2017 - current
California State University Long beach, Long Beach, CA United States
Industry: Education
Research Assistant, working with my adviser
• Collect, data cleanse and categorize voting data from different Statewide Ballot Measures Database for various initiatives and legislative referendum to create a basis for assessing the relationship between result of elections and its social and economic impact • Develop python program to calculate the fog index of questionnaires to rate the quality of the answers given and overall effectiveness of the questions in accomplishing its objective • Write robotic process automation with UiPath to automatically perform OCR on pdf to collect text and facilitate the data mining process • Forecast and analyze financial performance of various public companies using Dividend Discount Model to assess the risks and rewards of different investment opportunities and outcomes--
Financial Quantitative Manager 05/2013 - 08/2017
International Bank (EMEA), , United States
Industry: Banking
Financial Quantitative Manager, Managing team of 6 staff members
• Managed a team of 6 staff members to supervise all aspects of the financial and statistical analysis needs for assessing cash flow and daily operations of banking • Restructured and worked closely with software development team to upgrade financial information systems and reporting workflow which led to automating 60 reports and improving monthly close from 3 days to 1 day • Oversaw the profitability analysis of all loans and developed various calculation methods, such as the break-even analysis, to assist branch managers in monitoring transactions to ensure net interest margins are above profit thresholds • Reviewed the financial performance of the business to assess market share, strengths, and weaknesses of all competing products and services, and created corresponding monthly reports to support new business and strategic initiatives • Developed a profitability margin analyses to monitor the performance of all retail branches and support executive decision making on expansion initiatives and shutdown of under-performing business units • Served as an adviser to facilitate Financial and International Department, worked on a legal issue to help distinguish flaw, saved $10 million for bank--
Senior Analyst 02/2009 - 04/2013
International Bank (EMEA), , United States
Industry: Banking
Senior Analyst, Working on Branches evaluation by SQL, Advanced Excel formula, and VBA
• Worked with operations and human resource managers to optimize the incentive-compensation model to assess employee performance and year-end bonuses • Collaborated with software development team to upgrade the budgeting system and workflows to automate projections using multivariate regression model and time series forecasting method • Worked with the executive team to optimize the banks cash management model by classifying retail branches based on performance and transaction volume using the clustering method for the purpose of imposing new retail lending policies and thresholds • Prepared daily banking margin reports to note variances in the volume of transactions of all retail segments with respect to lending, deposits, checks and withdrawals and ensure profitability and performance are within budgetary thresholds--
Analyst 02/2005 - 01/2009
International Bank (EMEA), , United States
Industry: Banking
Analyst, Working on goals for various regional banking hubs and consolidation reporting
• Automated the consolidation reporting of various bank hubs managed on disparate database systems by using a combination of SQL & Excel VBA to analyze daily operational performance, which benefited business decision making by executive and upper management • Contributed with software development team to develop a calculation procedure based on the data envelopment analysis method to analyze the productivity of employees in relations to the output of their branches and seek optimization models to prescribe improvements • Worked with the strategic and planning department to set annual and quarterly goals for various regional banking hubs in maintaining liquidity and positive cash flow by applying various statistical methods using historical data and trends of interest rate, inflation and other economic factors to predict future performance and growth--
Accountant 07/2004 - 02/2005
Faraman Electronics, , United States
Industry: Electronics
Accountant, working on payroll
• Calculated employees’ payroll, day-to-day bookkeeping ensuring cash flow is positive by managing accounts payable and accounts receivable and overlooking treasury and cash management duties--

Beheshti 09/1998 - 02/2003
, , Iran
Degree: Bachelor's Degree
Major:Statistics
Bachelor of Science in Statistics

Login to view resume: Leila Korjani Resume -