Cheshta Chauhan

ac07j4@r.postjobfree.com 312-***-**** linkedin.com/in/cheshtachauhan

PROFESSIONAL SUMMARY

Finance professional with experience in financial modelling, data analysis and business reporting. Effective team player with strong

communication & interpersonal skills with ability to learn quickly, prioritize tasks, and deliver results in a fast-paced environment.

EDUCATION

Master of Science in Finance Illinois Institute of Technology Aug 2015 -

May 2017

Bachelor of Technology in Electronics and Communication Engineering VIT University Jul 2011 -

May 2015

SKILLS

Core Financial Modeling, Valuation and Portfolio Management, Futures Options and OTC Derivatives, Financial

Competencies: Statement Analysis, .NET and Database Management, Market Risk Management, Performance Optimization

Software: Microsoft Office suite (Outlook, Word, PowerPoint), Advanced Excel (Pivot Tables, VLOOKUP, Macros)

Programming: R programming, C, C++, Tableau, C#, SQL, Visual Basic, Python, SAS, MATLAB

PROFESSIONAL EXPERIENCE

Finance and Engineering Associate IT Architect Corporation, Chicago, IL Jan 2016 -

Aug 2016

Researched IT product offerings of the suppliers and evaluated financial statements using SAS and Excel, generated reports on efficiency

and performance using Tableau and projected to implemented changes to drive business results

Conducted quantitative analysis of financial data to forecast revenue, identify future trends, and assess risk associated with capital

expenditures, acquisitions, and joint-venture projects for clients to carefully match them with the firms IT products and software.

Added 2 clients and accomplished 2 new projects with the biggest IT/Telecom companies in USA increasing the firms revenue by 17%

Financial Data Analyst Stuart Investments, Chicago, IL Jan 2016 -

Dec 2016

Evaluated Activation Blizzards Financial Performance using Excel & R by conducting Comparative Peer Analysis, Forecasting and

Financial Analysis using Yearly Budget, Balance Sheet, and Income & Cash Flow statements

Provided suggestions to the board, estimated the stock to be undervalued by 21.52% and proposed to invest in 300 shares worth $9,579

Loan Analyst Punjab National Bank, New Delhi, India Dec 2014 -

July 2015

Built relationships, gathered client information and maintained due diligence to ensure accuracy and timeliness of loan applications as well

as low-risk loan approvals for 100+ accounts

Analyzed revenues, expenditures, current and future debt obligations to complete debt coverage calculations by analyzing financial,

statistical and operational data trends

Identified risks associated with projects and contract approvals by developing financial/economic market information databases while

ensuring compliance with established policies and procedures

ACADEMIC PROJECTS

Derivative Pricing Using MATLAB Aug

2016 - Dec 2016

Analyzed payoff structure for all 4 types of compound options and programmed to calculate their prices and conducted risk-return analysis

using Monte Carlo simulation, Smart Lattice in CRR Binomial Tree, Trinomial Lattice and Implicit Finite Difference method and optimal

portfolio allocation

Utilized Control Variate Technique to improve convergence speed of Monte Carlo Simulation and provided recommendations for

diversification with an annual return of 5.39%

Risk Analysis and Volatility Modeling Aug

2016 - Dec 2016

Estimated the one-day VaR and CVaR of a simple portfolio consisting of a $1000 investment in JP Morgan US Equity Fund A (JUEAX).

Calculated the maximum drawdown of the portfolio and performed Monte Carlo simulation on a portfolio consisting of an Asian option to

calculate the 99% 10-day VaR.

Modeled and estimated the volatility of a simple portfolio using GARCH, N-GARCH, and EWMA models based on the 5-year daily return

data and evaluated the performance of each of the models using statistical tests including Ljung Box test.

Financial Statement Analysis and Forecasting Jan

2016 - May 2016

Assessed and analyzed the significance of financial distress of a Molson Coors using Altman Z-score by examining historical operating

performance using the years trend analysis and margin ratios based on US GAAP

Analyzed the financial position and ROE using DuPont, capital structure & liquidity analysis and constructed a 3-year forecast model with

both income and cash flow statement, and calculated ROA and ROE based on the same

Contact this candidate