Sign in

Python, R, SQL, Tableau, Plotly, Shiny

Hoboken, NJ
March 10, 2020

Contact this candidate



201-***-**** Jersey City, NJ – ****2

EDUCATION Stevens Institute of Technology, Hoboken, NJ Dec 2020 Master of Science in Business Intelligence and Analytics (GPA 3.8)

(Scholarship received from School of Business)

Related Courses: Web Mining Data Visualization Multivariate Data Analytics Big Data Technologies Social Network Analysis

Amity University, Noida, India Jul 2018-Jun 2019

Post Graduate Diploma in Big Data Analytics (GPA 3.8) Related Courses: Applied Analytics Data Science and Data Mining for Business Intelligence Business Mathematics & Analytics for Business Forecasting University of Delhi, Delhi, India Aug 2014-Aug 2017 Bachelors of Commerce with Honors (GPA 3.6)

SKILLS Programming: Python, R

Database: MySQL

S Software: Microsoft Excel (Pivot Table, Solver, Solver Tables, V Lookup,Macros) Data Visualization: Plotly, Dash, Tableau, Seaborn, Matplotlib, GGplot2 Concepts: NLP, Statistical Modeling, Machine Learning, Web Scraping, SciKit Learn ACADEMIC Dash Web Application Current Pursuit

PROJECTS Designing a dash web application for financial analysis using Plotly Dash on any given ticker by the user using Yahoo Finance API to analyze trends in historical stock data S&P 500 Prediction Spring 2020

Predicted direction of next-day Open and Close of S&P 500 using several Machine Learning and Statistical Learning Methods (Random Forests, SVM, Logistic Regression, Decision Trees, KNN, etc.) to achieve accuracy of 60% Investment Portfolio Optimization Fall 2019

Designed a project for Optimizing Portfolios using Yahoo Finance API based on VaR and Sharpe ratio using Monte Carlo Simulation and SciPy Library in Python Data Warehousing-BI Challenge Fall 2019

Created a database employing STAR Schema from a raw data file of Delta Airlines Using the database, created 8 Tableau Dashboards(25 visualizations) for research on the different attributes of the airline and reasons for delays EXPERIENCE Ashok Akshay Associates, Noida, India Jul 2017-Aug 2019 Accounts Analyst

• GST Implementation: Provided consultation to small and medium businesses to implement the regulatory requirements for assessment and filing of GST tax requirements.

• Aided in modernizing the accounting systems to enable direct and indirect tax planning resulting in compliance with the organizations financial guidelines. Union Bank of India, Noida, India May 2016- Jun 2016 Summer Analyst Intern

• Automated the existing internal reporting on Excel VBA creating Pivot Tables and Charts r reducing effort by 130 hours on an annual basis

• Prepared financial statements while managing accounts payable

Contact this candidate