Aneesh Karsanbhai

GOOGLE BigQuery PROJECTS (SQL) - Explored various relational databases (Size ranging from 200k to 30 million rows), utilizing complex SQL queries to generate insights. Queries were performed in the Google BigQuery Sandbox. 

ANALYZING CRIME IN LOS ANGELES (SQL DataCamp project) - Explored database to determine where and when crime is most likely to occur as well as most common crimes committed in LA.

ANALYZING UNICORN COMPANIES (SQL DataCamp project) - Explored database to find how many private companies have reached a valuation of over $1 billion between 2019 and 2021 across different industries.

EVALUATE A MANUFACTURING PROCESS (SQL DataCamp project) - Identified issues in a manufacturing process using SQL window functions and subqueries.

MANIPULATING DATA IN SQL TRACK

• Learned to create and query relational databases using SQL.
• Learned SQL joins (inner and outer), how to apply relational set theory and work with subqueries.

STOCK PICKING PROJECT(Python/Tableau)

• Utilized Yahoo Finance API for Python to pull data on listed securities. Used data from query to calculate risk measures (Variance, Beta, R Squared, etc.)
• Filtered securities based on risk profile - Utilized portfolio optimization package to determine optimal weights and create 3 portfolios with varying risk tolerance.
• Created dashboard to visualize hypothetical returns and asset breakdown of each portfolio in tableau

STOCK ANALYSIS PROJECT (Python)

• Compared historical price and PE data for mega cap companies.
• Created visual representations of normalized historical trends using Matplotlib and Seaborn.

PYTHON FOR FINANCE COURSE - Learned how to use date time, if-statements and how to create, manipulate and combine data frames.

          Capstone: Working with live NASDAQ data - Filtered, analyzed and created visualizations for real NASDAQ data in python.

MANIPULATING TIME SERIES DATA IN PYTHON COURSE - Learned to manipulate rolling and expanding time series data using pandas

          Capstone: Building a value weighted index - Utilized market data to build a weighted index based on historical market capitalization.

• CAIA Fundamentals of Alternative Investments
• CAIA Private Debt Microcredential
• Datacamp - Python for Finance Track (6 courses)
• Datacamp - SQL Fundamentals Track (7 courses)
• Series 7 - General Securities Representative
• Series 9 - General Options Sales Supervisor
• Series 10 - General Securities Sales Supervisor
• Series 63 - Uniform Securities, State Law