Data Analyst

NISHITA LAMBA

646-***-**** ******@********.*** E linkedin.D U C com/A T in/I nishita-O N lamba-61361a105 New York City, NY Columbia University New York, NY

Master of Science in Business Analytics Expected Dec ‘20

• Courses: Data Analytics, Business Analytics, Optimization Models and Methods, Tools for Analytics, Analytics in Practice University of Delhi New Delhi, IN

Bachelor of Arts in Economics (Honours) July ‘15 – May ‘18

• Courses: Statistical Methods for Economics, Game Theory, Micro and Macro Economics, Mathematical Methods, Econometrics E X P E R I E N C E

Project X New York, NY

Data Analyst Intern Jul ‘20 – Present

• Analysed 100+ survey responses to identify the pain-points of concession stand visitors and conducted In-depth interviews with 40 industry players in stadium operations.

• Incorporated Twitter Scraper to gather tweets about concession stands using Twitter’s API to perform Vader Sentiment Analysis. Related Digital Turkey, TR

Marketing Analyst Intern Jul ‘20 – Present

• Established automation flows using Tableau to customize the web and email playbooks according to the direct needs of B2B clients as part of their marketing automation tool for the E-commerce industry.

• Researched their newly designed express email marketing service to establish a pricing model prior to its launch Internationally. Publicis Sapient New York, NY

Data Science (Student Consultant) Jan ‘20 – May ‘20

• Modelled unsupervised Machine Learning Clustering algorithms such as K-means and Hierarchical Clustering for building a scoring model to analyse the strength of consumer-brand relationships from survey data comprising of 4000+ features.

• Analysed importance of Features using Random Forest along with Feature Extraction Methods like Principal Component Analysis

(PCA), Recursive Feature Elimination (RFE), Forward Subset Selection and Backward Subset Selection. HBO New York, NY

Marketing Analyst (Student Consultant) Jan ‘20 – May ‘20

• Conducted and analysed research studies using methods like landscape review, quantitative(survey), qualitative(focus group, in- depth interviews), to identify the potential market for HBO’s newly dubbed SVOD service before its launch in May 2020.

• Analysed consumer behaviour and preferences taking into account the pros and cons of alternative solutions, as well as short-term and long-term implications of the proposed recommendations and finally chose to target Gen-Z viewers. HDFC BANK New Delhi, IN

Financial Analyst Intern June ‘18 – July ‘19

• Monitored finance trends, standards and practices to identify developments in monetary planning and execution.

• Enhanced cost-effectiveness and profitability scenarios by 9% using the company’s statistical analyses. Ernst and Young Gurugram, IN

Business Development Analyst June ‘16 – Aug ‘16

• Improved sales for Central/state government related agencies and defined strategy with the accounts management team.

• Analysed and provided in depth solutions to the underlying needs of the target customers. Kotak Securities New Delhi, IN

Sales and Trading Analyst Intern Mar ‘16 – June ‘16

• Researched and recommended new investment opportunities and financial products to clients.

• Applied various Machine Learning algorithms and analysed stocks using moving averages and regression analysis. P R O J E C T S

Morgan Stanley Wealth Management using Python New York, NY Natural Language Processing Jun ‘20 – Aug ‘20

• Extracted tweets related to Morgan Stanley and competitors using Twitter API and performed Vader Sentiment Analysis.

• Reviewed Morgan Stanley’s strategy with frequency count and predictive modelling using TfidfVectorizer and CountVectorizer. Amazon Recommendation System using Python New York, NY Machine Learning Feb ‘20 – Apr ‘20

• Designed a recommendation system for Amazon products using the Product review dataset in the luxury beauty category.

• Applied Collaborative filtering method and recommended products to users based on a user-item interaction matrix. Squirrel Tracker App using Django ( https://hale-music-253619.appspot.com/ ) New York, NY Web Development Oct ‘19 – Dec ‘19

• Designed a web-based application which tracks the squirrels located in central park using the 2018 Central Park Squirrel Census data.

• Enabled the app to allow users to add, update, and view squirrel data. S K I L L S & C O M P E T E N C I E S

• Technical: Python (NumPy, Pandas, SciPy, Scikit-learn, Web Scraping), R, SQL, GIT, HTML, Web Development (Django)

• Data Analytics: Machine Learning, Tableau Prep, Tableau Desktop, Text Mining, Data Cleaning and Visualization

Contact this candidate