Data Project

VAISHNAVI NAGARAJAN Email: *********.*********.**@*****.***

*** * ** ****** ****, Apt 211C LinkedIn Profile: linkedin.com/in/vaishnavi-nagarajan-08594a52 Sunnyvale, California 94087. Phone: +1-408-***-**** EDUCATION

Amrita School of Business - M.B.A (Finance & Marketing) April 2012 PSG College of Arts and Science - Bachelor of Commerce (Accountancy) April 2010 SKILLS/TECHNICAL EXPERTISE

Databases : MySQL,Oracle

Programming/Scripting : Python,R,Numpy,Pandas

BI/Reporting skills : Tableau, MS Excel,MS Power Point,Matplotlib,Seaborn Financial Skills : Financial Modelling, Balance Sheet Analysis, Bloomberg, Forecasting CERTIFICATIONS & AWARDS

DATA ANALYSIS: Introduction to data analysis – using Numpy,Pandas (05/2017 – 07/2017) PYTHON: Programming using Python (MIT) (01/2017 – 03/2017) PYTHON: An Introduction to Interactive Programming in Python (12/2016- 02/2017) TABLEAU: Data Visualization and Communication with Tableau (10/2016 -12/2016) SQL: Managing Big Data with MySQL (03/2016 – 05/2016) FINANCE: The Language and Tools of Financial Analysis (06/2015 – 07/2015) WORK EXPERIENCE

Sky Industrial Components

Freelance – Business Consultant (remote from US) - (2014 till date) Major roles and responsibilities include:

• Analyzed the barriers in business operations and provided solutions to smoothen the day to day business process

• Helped in devisiang customer acquisition and retention strategies

• Came up with segmentation and positioning strategies for various products of the company Payoda Technologies – (HedgeMark LLC, acquired by BNYMELLON ) Financial/Data Analyst (May 2012 – Oct 2013)

Analyzed the portfolio of various Hedge Fund Investors to provide position – level risk and performance analytics which helped the clients make investment decisions. The role mainly involved: Data Pre-processing (MS Excel/Macros/VBA)

• Analyzed raw data and performed data cleansing, scrubbing and processing to extract essential data required for risk calculation (MS Excel functions/Pivot tables/macros/VBA)

Modularizing the Data (Oracle SQL, Python)

• Designed modular database tables and provided the required views, functions and stored procedures that helped data analysts to efficiently query the required information

• Automated the migration of risk data from Excel to Oracle database by writing python scripts Data Validation, Analysis and Report Generation (Oracle SQL, Query/Views/Stored Procedures)

• Extracted and analyzed huge volume of data using SQL queries & validated the results from the risk engine

• Provided customized summary risk reports including VaR, Stress test, Highlights reports to the clients on daily/weekly/monthly basis by creating interactive dashboards which educated the clients regarding the risk exposure of their portfolio Manage Deliverables & provide Operational Solutions

• Interacted with client service team, global hedge fund admin and risk engine team to efficiently manage deliverable PROJECTS

Data Analysis Project - Business Process Change Proposal for Dognition(TABLEAU) – 10/2016 – 12/2016 Analyzed the data of Dognition using Tableau and presented a data driven business process change Proposal. The project involved:

• Generating interactive Dashboards with filters, quick filters and parameters

• Creating table calculations, grouping and filtering for data analysis

• Creating storyboards to effectively communicate the business process change recommendation Data Analysis Project - Titanic data (NUMPY,PANDAS) – 05/2017 – 07/2017 Analyzed the factors affecting the survival rate of Titanic passengers. The project involved:

• Performed data wrangling and merging data from different formats- CSV,XML,JSON,EXCEL

• Performed data analysis using Python – NUMPY,PANDAS

• Presenting the findings through visualizations created using MATPLOTLIB and python SEABORN HDFC Bank – Financial Analyst Intern – (April2011-June 2011) Analyzed the Term loan and Working Capital proposal of sugar companies and presented a detailed report to the bank about the financial position of the company. The project involved:

• Financial analysis, Competitor analysis, sensitivity analysis, monitoring price fluctuations and generating reports using Excel

Contact this candidate