Harsha Kolli

Virginia Rd, Atlanta, Georgia ****8 469-***-**** ac6mhx@r.postjobfree.com

Summary

A highly motivated Finance professional with a year experience in the Finance field with a strong understanding of financial statements, Financial analysis, Valuation and Financial Modeling.

Experience in Balance sheets, Income Statements and Financial Modelling using Excel

Competent with Analysis Tools R, SAS, Microsoft Excel (Pivot tables, VLOOKUPS)

Direct Experience in analyzing business problems and makes strategic decisions and recommendations supported by statistical modeling

Experience in writing complex SQL codes using SELECT, JOINS

Able to work on own initiative and as part of a team

Strong analytical, interpersonal, communication and problem-solving skills

Experience

FINANCIAL ANALYST INTERN THE RISE NETWORK FEB 2018-PRESENT

(EXCEL/OUTLOOK)

Work with the VP of Financial Operations to consolidate their financial statements from all departments of their companies. I have developed a corporate budget and general ledger accounts for their accounting team

I made an adjuster revenue forecast to help accurately predict cost of revenue and provide insights to top leadership.

Prepare the annual long range financial plan, collaborating with operations for project justifications and strategic objectives. Complete business plans for projects with a capital investment greater than $500000, preparing a discounted cash flow analysis and calculating the internal rate of return

TEACHING ASSISTANT THE UNIVERSITY OF TEXAS AT DALLAS JAN 2017-DEC 2017

(BLACKBOARD/ EXCEL)

Assisted 150+ students understand concepts of Financial Planning and utilize financial calculators.

Developed grade dashboards and reports for easy retrieval which improved score visibility of individual students in Excel.

Reduced workload of professor by creating classroom instructions, grading exams and streamlining record keeping

LAB WORKER THE UNIVERSITY OF TEXAS AT DALLAS JUN 2017-AUG 2017

(EXCEL/SQL)

Tutored 125+ students on financial concepts related to courses like Business Finance, Financial Management and Data Base Management Systems

Guided students with classroom projects based on SQL, Excel

Monitored and reviewed students’ progress throughout the semester and provide timely feedback and required guidance

JUNIOR ANALYST TRUST CHEM SOURCINGS JUN 2014-AUG 2015

(EXCEL/SQL)

Collected data on the chemicals that are imported and exported to other countries utilizing company databases using SQL

Summarized data using MS-Excel which encompassed all spheres of analysis like statistical descriptive analysis etc.

Predicted quality data-based solutions for the company and devised management strategy for process improvisation

Education

THE UNIVERSITY OF TEXAS AT DALLAS MASTERS GRADUATION DEC 2017

Major: Management Science (Finance) GPA: 3.62

THE UNIVERSITY OF HYDERABAD INTEGRATED MASTERS GRADUATION JUNE 2014

Inspire Scholarship by Government of India, for higher education

Major: Statistics Minor: Mathematics

Skills & Certifications

TOOLS & PROGRAMMING

R Studio, SQL, Advanced MS Excel (Pivot Tables, VLOOKUPS), STATA, Base SAS, Power BI

STATISTICAL SKILLS

Descriptive analysis, Linear, Multiple, Logit regressions, Hypothesis testing, Time series and Forecasting

CERTIFICATIONS

Certification in MS Excel and Fixed Income from Corporate Finance Institute

Academic Projects

DATA ANALYSIS, FORECASTING PREDICTION CAR FATALITIES

Acquired data from various sources and implemented data cleansing and optimization

Analyzed the Data sets with more than 39 variables, 336 observations, information on 48 states in the US from 1982 - 1988

Forecasted fatality rate using Ordinary Least Squares, interaction variables, Panel data models using STATA with 62% accuracy

Concluded that increase in consumption of Alcohol, per capital income, Unemployment rate increases the fatality rate

PORTFOLIO ANALYSIS OF 5 STOCKS QUANTITATIVE METHODS IN FINANCE

Collected the weekly stock prices of VZ, MXIM, LUV, NKTR, ORCL from finance.yahoo.com from 2013 - 2016

Examined the stock prices and the effect of S&P 500 with and without Fama French factors

Leveraged R software for linear regressions, ANOVA tables, Multi collinearity, Heteroskedasticity, Auto correlation

VALUATION AND FORECASTING PROFORMA STATEMENTS VERIZON COMMUNICATIONS INC.

Researched the latest 10k data of Verizon Communications Inc. in Security Exchange Commission (SEC)

Evaluated valuations, options, Cost of capital, Equity analysis, Debt analysis and Working capital using Excel for Financial forecasting and Proforma Statements

Contact this candidate