Data Analyst Executive

LEILA KORJANI

Cell: 323-***-**** www.linkedin.com/in/leila-korjani adb60t@r.postjobfree.com Los Angeles, CA OBJECTIVE

Senior Data Analyst with over 10 years of experience in data analytics, data mining, statistics, optimization, and finance. Seeking full-time position in data analytics.

RELEVANT QUALIFICATIONS

• Experience in Big Data and Business Solutions using SQL and Python

• Expertise in Python, SQL, Advanced Microsoft Excel, VBA, Minitab, SPSS, Access, PowerPoint

• Experience in SAS, Power BI, EViews, S-Plus, QlikView, Git, JavaScript

• Expertise in Statistical Analysis, Multivariate Regression, Forecasting, Hypothesis Testing, Time Series Analysis, Confidence Interval, Probabilistic Modeling, Classification, Clustering, Decision Analysis

• Engaged in Simulation, Visualization, Automation, Optimization, Linear Programming Techniques

• Hands on knowledge in Corporate Finance, Financial Modeling, Modern Portfolio Theory, Variance Analysis, Financial Accounting, Bloomberg, WRDS

• Experience in Data Interpretation and Analysis

PROFESSIONAL EXPEREINCE

California State University Long Beach, Management Department Research Assistant

• 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

09/17 – Present

International Bank (EMEA), Finance Department

Financial Quantitative Manager

• 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 underperforming business units

• Served as an advisor to facilitate Financial and International Department, worked on a legal issue to help distinguish flaw, saved $10 million for bank 02/05 – 08/17

05/13 – 08/17

Senior Analyst

• 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 02/09 – 04/13

LEILA KORJANI

2

• 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

• 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

02/05 – 01/09

Faraman Electronics, Finance Department

Accountant

• 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 07/04 – 02/05

PROJECTS

• Evaluating the Impact of Several Social and Behavior Factors on Life Expectancy Applied multivariate regression modeling to discover the significance of behavioral and social factors that impact human life expectancy in which the results showed positive impacts from education and health care coverage and negative impacts from smoking, drinking, and eating disorders leading to obesity

04/19 – 05/19

• Anomaly Analysis on Net Stock Issuance

Performed CAPM, Fama-French model, Sharp/Sortino ratio, and Bootstrap analysis to conclude the profitability of various investments, identify mispricing factors of stocks and anomalies in order to take advantage of using short selling strategies on newly issued stocks that are over-valued 04/19 – 05/19

EDUCATION

California State University Long Beach

Master of Business Administration (MBA) with concentration in Finance 08/17 - 05/20

Polytechnic University

Master of Science in Social and Economic System Engineering 02/10 - 02/12

Beheshti University

Bachelor of Science in Statistics

09/98 – 02/03

CERTIFICATES

Python bootcamp (Udemy) 01/20

Business Analytics for Decision Making (Coursera) 08/19 Power BI (Udemy) 08/19

Predictive Modeling and Analytics (Coursera) 07/19 Introduction to Data Analytics for Business (Coursera) 06/19 SAS Programming 1: Essential (SAS) 04/19

DAT206x: Excel for Data Analysis and visualization (EDX) 10/15

Contact this candidate