Financial Modeling & Valuation, Tally erp9, Excel

CURRICULUM VITAE

Name: HARSH JAIN

Email ID: **************@*****.***

Mobile No.: +91-700*******, +91-818*******

Address: ***/***, *** ******* *****, Lucknow.

Date of Birth: 08/03/1997

CAREER OBJECTIVE

To prove myself as a valuable analytics professional and join a progressive organization where I can learn and apply my skills. Accept challenging positions by exhibiting my skills with utmost sincerity and dedicated smart work to encourage growth and excellence.

CORE COMPETENCIES

● Lateral thinking

● Organized

● Analytical bend of mind

● Presentation skills

● Attention to details

● Leadership and interpersonal skills

● Ability to work in a team

PROFESSIONAL KNOWLEDGE

Institute: Coursera/Macquire University

Course: Excel Skills for Business (4 Course Specialization) Duration: Oct 2020 – Present (to be completed by December 2020)

● Advance Excel features like Pivot Tables and Pivot Charts.

● Detailed analysis using functions like VLOOKUP, HLOOKUP, IF, SUMIF, COUNTIF, CHOOSE, etc.

● Using Slicers and Timeline for enhanced visualizations.

● Data cleaning, formatting and What-If Analysis (Goal Seek).

● Text-to-columns, and data validation.

● Multiple assignments with various data sets.

Institute: Internshala Training

Course: Financial Modelling and Valuations

Duration: Oct 2020 – Present (to be completed by December 2020)

● Financial analysis and modelling using Excel functions.

● Present Value, Net Present Value (NPV) and Discount Rate.

● Internal Rate of Return (IRR) and Payback Period.

● Absolute Valuation (DCF Method) and Relative Valuation (Price to Earnings Ratio).

● Cash-Flow Statement, Balance Sheet, and Income Statement generation.

● Calculation of EMIs.

Case Study: Hero MotoCorp with detailed Financial Statement Analysis and checking for Financial Statement Irregularities.

Institute: E-MAX COUNCIL FOR VOCATIONAL TRAINING AND EDUCATION Course: TALLY.ERP9 with GST

Duration: July 2020 – September 2020

● Recording Tally entries on daily basis.

● Preparing Day Book and Ledger.

● Maintaining Monthly Bank Reconciliation Statement.

● Maintaining Salary Statement and Payroll of the Employees.

● Maintaining records of TDS, VAT, GST etc.

EDUCATION

● B. Com, Lucknow Christian Degree College. Marks- 60%.

● HSC (ISC), Spring Dale College, Lucknow. Marks- 80.4%

● SSC (ICSE) Spring Dale College, Lucknow. Marks- 75.83% ADDITIONAL INFORMATION

● Computer Proficiency: Common concepts of computer and MS-Office with Intermediate knowledge of Excel.

● Languages: English, Hindi.

● Typing Speed: 35-40 WPM (English)

● Hobbies and Interests: Technology, and learning about Smartphone Photography.

DECLARATION

I hereby declare that the information furnished above is true to the best of my knowledge and belief.

Place: Lucknow

Contact this candidate