roshni patel (resume 2015)

1
Nielsen 2012 - Current Manager, Marketing Analytics Clients: Nestlé, WhiteWave Foods • Measure marketing and trade ROI through log-linear regression models • Analyze $14M marketing budget for Nestlé brands and evaluate short-term marketing effectiveness • Present strategic insights to Brand Directors to guide annual marketing budget • Provided recommendation to reduce Nestlé USA’s marketing spend by $50M while maintaining YOY sales by optimizing its multi-brand portfolio and engineering cross vertical marketing mix models • Execute price and promotion analyses to derive future pricing strategies • Develop and test P&P and regression model specifications to address client’s key business questions and issues • Lead weekly meetings with Brand and Insights Managers to share significant findings and ensure analysis is meeting project expectations • Collaborate with internal teams to identify process efficiencies Senior Manager, Retail Consulting & Analytics Clients: Walmart, Sam’s Club • Executed P&L analysis that predicted a $60M loss in sales by changing store hours • Identified root causes of stagnant sales and delivered recommendation to mitigate 2% loss in Business Memberships to Sam’s Club SVPs • Conducted ANOVA study to standardize inventory management technology • Executed a drivers study to identify revenue drivers and merchandising opportunities • Maintained 1,000+ variable database used to conduct ongoing store-level analyses Morningstar, Inc. 2011 - 2012 Data Quality Assurance Intern • Used Google Analytics to target clients for premium subscription service upgrades • Conducted front-end testing on web-based equity and credit research content • Collaborated with divisional leaders to ensure data accuracy of Morningstar ratings • Collected and verified financial data on global equities for company research reports • Produced content for quarterly data reports distributed to all clients Illinois Institute of Technology, Institute of Design 2009 - 2010 Graduate Admission Coordinator The International Academy of Television Arts & Sciences 2006 - 2009 Coordinator, Membership & Events Choice Hotels 2004 - 2006 Assistant Manager ROSHNI PATEL 1212 North Wells Apt 1405 Chicago IL 60610 Address Contact [email protected] +1 765 490 0676 PROFESSIONAL EXPERIENCE ............................................................................................................................................................................. EDUCATION ............................................................................................................................................................................. TECHNICAL SKILLS HOBBIES & INTERESTS ............................................................................................................................................................................. SAS 9.2 SQL Assistant Google Analytics R SPSS SharePoint Cognos GIS Microsoft Office Adobe Creative Suite Windows Mac OS X Analytical & Reporting Tools Illinois Institute of Technology, Chicago IL Graduate Management Certficate, Business Analytics GPA: 3.83 / 4.00 Indiana University, Bloomington IN Bachelor of Science, Business Major in Marketing, Minor in Psychology GPA: 3.10 / 4.00 DePaul University, Chicago IL Master of Science, Predictive Analytics GPA: 3.97 / 4.00 Software UNIX Operating Systems Reading Crossword Puzzles Trivia Games Documentaries Board Games Proofreading Poker Correcting others’ mistakes Boxing Classical/Folk Indian Dance Pilates Yoga Running Bowling (striving for a perfect 300) Billiards Ping Pong Traveling Health & Wellness Cooking Organizing Fashion Wine Gardening Philosophy ............................................................................................................................................................................. CAREER SUMMARY ............................................................................................................................................................................. Detail-oriented individual with innate analytical abilities and ten years of client-facing work experience in CPG, Retail, Education, Entertainment, and Hospitality. Recognized for excellence in analysis, reporting, organization, and project management. With an advanced degree in Predictive Analytics, strives to lead efforts that exceed client operational goals through data analysis. ............................................................................................................................................................................. ............................................................................................................................................................................. Analytical Rigor Client Management Morningstar Nielsen Institute of Design Int’l Academy of Television Choice Hotels 2011 - Current 2004 - 2010 .............................................................................................................................................................................

Upload: roshni-patel

Post on 13-Sep-2015

18 views

Category:

Documents


0 download

DESCRIPTION

Analytics Professional

TRANSCRIPT

  • Nielsen 2012 - Current Manager, Marketing AnalyticsClients: Nestl, WhiteWave Foods Measure marketing and trade ROI through log-linear regression models Analyze $14M marketing budget for Nestl brands and evaluate short-term marketing eectiveness Present strategic insights to Brand Directors to guide annual marketing budget Provided recommendation to reduce Nestl USAs marketing spend by $50M while maintaining YOY sales by optimizing its multi-brand portfolio and engineering cross vertical marketing mix models Execute price and promotion analyses to derive future pricing strategies Develop and test P&P and regression model specications to address clients key business questions and issues Lead weekly meetings with Brand and Insights Managers to share signicant ndings and ensure analysis is meeting project expectations Collaborate with internal teams to identify process ecienciesSenior Manager, Retail Consulting & AnalyticsClients: Walmart, Sams Club Executed P&L analysis that predicted a $60M loss in sales by changing store hours Identied root causes of stagnant sales and delivered recommendation to mitigate 2% loss in Business Memberships to Sams Club SVPs Conducted ANOVA study to standardize inventory management technology Executed a drivers study to identify revenue drivers and merchandising opportunities Maintained 1,000+ variable database used to conduct ongoing store-level analyses

    Morningstar, Inc. 2011 - 2012 Data Quality Assurance Intern Used Google Analytics to target clients for premium subscription service upgrades Conducted front-end testing on web-based equity and credit research content Collaborated with divisional leaders to ensure data accuracy of Morningstar ratings Collected and veried nancial data on global equities for company research reports Produced content for quarterly data reports distributed to all clients

    Illinois Institute of Technology, Institute of Design 2009 - 2010 Graduate Admission Coordinator

    The International Academy of Television Arts & Sciences 2006 - 2009 Coordinator, Membership & Events

    Choice Hotels 2004 - 2006 Assistant Manager

    ROSHNI PATEL 1212 North WellsApt 1405Chicago IL 60610

    Address Contact [email protected]+1 765 490 0676

    PROFESSIONAL EXPERIENCE.............................................................................................................................................................................

    EDUCATION.............................................................................................................................................................................

    TECHNICAL SKILLS

    HOBBIES & INTERESTS.............................................................................................................................................................................

    SAS 9.2SQL AssistantGoogle AnalyticsRSPSSSharePointCognosGIS

    Microsoft OceAdobe Creative Suite

    WindowsMac OS X

    Analytical & Reporting Tools

    Illinois Institute of Technology, Chicago ILGraduate Management Certcate, Business AnalyticsGPA: 3.83 / 4.00

    Indiana University, Bloomington INBachelor of Science, BusinessMajor in Marketing, Minor in PsychologyGPA: 3.10 / 4.00

    DePaul University, Chicago ILMaster of Science, Predictive AnalyticsGPA: 3.97 / 4.00

    Software

    UNIX

    Operating Systems

    Reading Crossword PuzzlesTrivia Games DocumentariesBoard Games ProofreadingPoker Correcting others mistakes

    Boxing Classical/Folk Indian DancePilates YogaRunning Bowling (striving for a perfect 300)Billiards Ping Pong

    Traveling Health & WellnessCooking OrganizingFashion WineGardening Philosophy

    .............................................................................................................................................................................

    CAREER SUMMARY.............................................................................................................................................................................

    Detail-oriented individual with innate analytical abilities and ten years of client-facing work experience in CPG, Retail, Education, Entertainment, and Hospitality. Recognized for excellence in analysis, reporting, organization, and project management. With an advanced degree in Predictive Analytics, strives to lead eorts that exceed client operational goals through data analysis.

    .......................................................................................................................................................................................

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ..........

    ...

    Analytical Rigor

    Clie

    nt M

    anag

    emen

    t

    Morningstar

    NielsenInstituteof Design

    Intl Academyof Television

    ChoiceHotels

    2011 - Current2004 - 2010

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    ......

    .....