ANSH MALHOTRA'S

PORTFOLIO

A Little

About Me

I am a student at Mukesh Patel School of Technology,NMIMS pursuing B Tech in IT and MBA Tech in Finance.

I am highly motivated individual looking to work with a mixture of finance and technology in my future career.



02

Work Experience

03



Treasury Analyst:

  • Automated a Forex hedging Report using VBA.
  • Automated Cashflow reports

Financial Controller:

  • Created Dashboards for Cost centers.
  • Create Pivot Tables for MIS Net Sales


Bayer,Mumbai

Management Internship

(May-September 2023)






  • Created Distance Based ETA for transportation of goods and services.
  • Automating Distance based URLs in Excel sheets.
  • Converted weekly reports in JPEG formats.



Tata Technologies,Mumbai

Data Analyst Intern

(May-July 2022)






  • Media Evaluation of Delhi Capitals a leading cricket franchisee in the IPL
  • Media Evaluation of Bengaluru FC a leading football franchisee in the ISL
  • Asset evaluation – Player Clothing, Verbal Mentions and Perimeter branding





YouGov Sport,Mumbai

Media Analyst Intern

(April-June 2019)



04

Skills & Expertise

Programming Languages – Java, Python, C, SQL, JavaScript, HTML, CSS, React, VBA

Software Technologies – Node, Express, Tableau, Unity, Photoshop, PowerPoint, Excel

Data Technologies – MySQL, MongoDB, Microsoft SQL Server, Pyexcel, Firebase

Technical Electives – UI/UX (Figma), Advance Database Management System

Management Electives- Investment Banking,Mergers and Acquisitions,Securities and Derivatives


My Work

Fyfth Avenue



Responsive website for Luxury Fashion Apparel (JavaScript, HTML, CSS)


TileVania



A unity game of a Mario Character running through the obstacles.


05

Other Projects

•Hospital Database Management System -Created a database for hospital, made ER and EER models for the same and added dummy data and retrieved data from the database using SQL.


•BlockBid-An auction system with blockchain technology and crypto based transactions


•Financial Ratio Analysis- Created an Excel worksheet of ACC cements balance sheets and analyzed financial ratios by deriving thedata from the balance sheet.

07

Ansh Malhotra

Work

with Me

79-77163873 aanshmalhotraa@gmail. com 602/B Evergreen, Rodas Enclave, Hiranandani Estate, Thane west 400607


08