Sign in

Tableau, SQL, Python, R, Excel, VBA

New York, New York, United States
January 18, 2018

Contact this candidate




Clifton, NJ ***** Tel: 201-***-**** Email:



Securitized Products Analytics Intern


Jun ‘17 – Present

• Improved pricing for ‘high coupon’ to-be-announced mortgage backed securities by creating prediction model on Python with machine learning algorithms, improving prices by 55%

• Automated weekly Wall Street Journal reports and daily morning broker sheets for Bank Loans, by moving the process from MS Access to SQL and Tableau, purging the total process time of 60 minutes per week

• Generated automated reports for multi asset-type challenge trends, while comparing them with availability of market color/information, improving the turnaround time of challenges by 30%

• Automated process for monthly challenge reporting for managers, by moving the manual MS Excel process to Tableau, which is updated every day and available online on one of the major web applications used internally

• Produced research reports for securitized products such as issuance, prepayments, etc. to aid future pricing

• Designed layouts for internal web applications on Photoshop, e.g. market color monitor, portfolio manager, etc. VIADESIGN INDIA LLP

Design Consultant

Delhi, India

Jan ‘14 – Aug ‘15

• Worked independently on two major hotel projects, drove bimonthly design workshops, with cross-functional teams of client, designers and service consultants

• Created FF&E document of new interior materials by doing market research, reducing material cost by 15%

• Pioneered standardization of files for documentation & construction, reducing project completion time by 20%

• Developed project deadlines with key focus on time management, resource availability and cost cutting GEODESIGNS


Delhi, India

Jan ’13 – Dec ‘13

• Worked in a team (of 2), to create a ‘Bollywood’ themed Food Court ‘Daana Paani’ on National Highway

• Analyzed commuter trends on Highways, to identify the most profitable franchises for the Food court

• Coordinated with service consultants to create technical specifications and construction related details RELATED INDEPENDENT PROJECTS

• Measured ‘Momentum’ of Stock Prices (Python, Tableau) – Measured changes in stock price of 25 publicly traded companies due to their financial news, for the last 5 years. Used Python to scrape news from Reuters archives. Identified words that led to most changes in stock price, and depicted the analysis using Tableau

• Predicted ‘Donors’ (Python, Azure ML, Tableau) – Worked with historic data set of 92,000 entries and 400 variables to develop model to predict donors. Identified top donors and factors that lead to high donations EDUCATION


MBA, Concentration in Business Analytics & Finance, GPA 3.74/4.00 NJ, USA

2015 – 2017

• Worked as a Graduate Assistant in department of Accounting & Finance (Spring – Fall ’17)

• Worked as a Graduate Assistant in Financial Aid department at Montclair State University (Fall ’16)

• Worked as a Teaching Assistant in department of Information Technology & Business Analytics (Spring ’16) BIRLA INSTITUTE OF TECHNOLOGY

Bachelor of Architecture, GPA 3.85/4.00

Mesra, India

2007 – 2012

• Selected as a finalist for Berkeley Essay Prize Competition, 2011 conducted by UC, Berkeley

• Analyzed and planned contemporary interior & exterior spaces, during 6-month internship at Paradigm Designs TECHNICAL SKILLS

• Data Prediction and Visualization Tableau, Alteryx, Microsoft Azure ML, MiniTab, MS Excel

• Programming Languages Python, R, C++, SQL, HTML

• Design Softwares Adobe Photoshop, Indesign, Auto Cad 2D & 3D, Google SketchUp

Contact this candidate