Garima Sood
Phone: +1-312-***-**** Email: **************@*****.***
EDUCATION
Current full-time student at University of Chicago, MSc Analytics 2017 - 2018
National Institute of Technology, Hamirpur (B.Tech, Civil Engineering) CGPA - 8.23/10 2009 - 2013
DAV Public School, Palampur (High School Examination) Percentage - 90% 2009 RELEVANT COURSEWORK
Completed: Statistical Analysis, Database Design & Implementation, Communication & Ethics in Analytics
Current Quarter: Linear and Non-Linear Models, Data Mining Principles, Research Design for Business Applications PROFESSIONAL EXPERIENCE
ZS ASSOCIATES, NEW DELHI Oct 2013 – Jul 2017
Decision Analytics Associate Consultant Jan 2016 – Jul 2017
Analyzed promotional effectiveness of marketing channels through regression modeling and provided key marketing strategies for a ~$115M for marketing campaign
Determined the optimal launch prices for the launch of a new product using conjoint analysis in the US, Canadian and Australian markets for a $40B pharmaceutical client
Quantified customer preference for different variants of pipeline products using conjoint analysis, which enabled clients to make strategic decisions on building product profile and positioning in the market
Managed teams of multiple associates, and took training sessions for new ZS recruits and team members on the Market Research practice area, Conjoint study design, Simple Linear Regression, Microsoft Excel and PowerPoint Business Analytics Associate Oct 2013 – Dec 2015
Estimated the expected demand for improved versions of a $35M drug to understand the potential implications of their launch on company profits in different timeframes
Developed an excel based optimal price launch calculation model, which has been adopted by multiple teams for conjoint analysis based launch price estimation projects
Developed a tool to estimate market share of drugs present / expected to launch in the market, using logistic regression of different product profile attributes vs. the product preference, captured through a conjoint study SKILLS
Software: MySQL, Tableau, OpenRefine, MS Office
Programming languages: R, Python, SAS
COURSE PROJECTS
Analysis of skills required for Data Scientist and Analytics job in the US (Database Design & Implementation project)
Scraped data from Indeed.com to collect list of keywords in job postings obtained for a particular job title and location search (using Python)
Cleaned the scraper outputs in OpenRefine & R, and stored in a MySQL database
Created Tableau visualizations for relative demand of different skills for multiple job postings & cities in the US EXTRA-CURRICULAR ACTIVITIES AND ACHIEVEMENTS
Served as the Convener of Dance Club NIT Hamirpur for two years, leading a team of 35 members
Organized the dance performances of underprivileged children for their annual education fundraising event ‘Prayas’
Won the CBSE scholarship for meritorious students for under graduation based on 90% marks scored in Class XII