Mansi Raghavendra Bhat

New Jersey, NJ 562-***-**** ad4157@r.postjobfree.com https://www.linkedin.com/in/mansi-bhat/ L2 Visa holder (No US Visa Sponsorship needed) and Business Analytics Manager, Children’s STEM Author with 9+ years’ experience delivering Marketing and Customer Analytics, Technology, Data Management, and Business Development engagements. Competent in building strong client and vendor relationships and Agile project management while leading through Design Thinking.

EDUCATION

California State University, Fullerton Los Angeles, US Master of Science in Information System and Decision Sciences, Business Analytics Dec 2019 Winner of Teradata Global Analytics competition among 65+global teams in Las Vegas Beta Gamma Sigma Awardee

M.S Ramaiah Institute of Management Bangalore, India Post Graduate Diploma in Management, Marketing and Finance (Equivalent to 2-year MBA) May 2015 Gurgaon Institute of Technology and Management Gurgaon, India Bachelor of Engineering, Electronics and Instrumentation Engineering (Honors) May 2010 SKILLS

Skills: Python, R, SQL, Tableau, Power BI, Advanced Excel, SPSS, Forecast Pro, IBM Watson, SAS PROFESSIONAL EXPERIENCE

Tredence Analytics New Jersey

Associate Manager, Analytics Apr 2021 – Present

• Consulting for a hospitality Giant (Marriott) to identify the key marketing trends in demand and supply to be consumed by business users.

• Led a team to create a Self Serve Business Intelligence system consolidating 500+ reports from various tools onto a single Self-Serve platform, serving 20,000 Global users.

• Worked with the team to build Marketing Mix Model pilot models and Simulators and optimizers for understanding the ROI of Marriott’s media drivers and understanding the impact of drivers on revenue for subsequent year. Created

$10MM impact for the client

• Recommended strategy of moving the media budgets to digital and online mediums basis the ROI and effectiveness analysis

• Working with Media and digital agencies such as SapientRazorfish and Marriott One Media team along with Marriott’s internal media teams globally to present the media insights to Marriott’s marketing leadership

• For HVMI (Homes & Villa Marriott International) predicting high demand regions to aid Supply team in acquisition of new properties and doing seasonality analysis by region

• Led a team of 5 (Data Engineering, Analytics team, Design and Visualization) for building the voice of customer- insights platform and executive decks for Marriott’s HVMI centers for insights such as Split of Cards Vs Loyalty points used

• HVMI property segmentation basis (Size of property, Avg Income etc) and Customer Segmentation (Staycation, Business travel etc) and building strategy of mapping both for optimal deployment Semnox Solutions Mountain View, CA

Client Manager, Parks, Americas Feb 2020 – July 2020

• Established customer relationships with the Amusement and Theme park customer accounts along with meeting of quarterly sales targets. Performed tasks of preparing the quotation and partner sales agreement. Lead management through Salesforce while uncovering opportunities

• Built a theme park sales strategy through market analysis, financial reports, online resources and targeting participation of right kind of local and national exhibitions and grew the business by 20%

• Produced and analyzed Tableau reports and assessment results through SQL to identify trends and issues, perform root-cause analysis, develop recommendations for resolution and track effectiveness of remedies

• Developed the Digital and Social media marketing strategy for Semnox including targeting of right prospects through content management strategy for web portal

• Coordinated the product development for Payments in Mobile app through requirements gathering, shortlisting vendors and implementation plan for Product Roll out while working with cross functional teams

• Conduct system demos for prospects and conduct training sessions to customers including trouble shooting issues, fielding incoming help requests from customers and finally performing post resolution follow ups Fractal Analytics Mountain View, CA

Consultant, Business Analytics and Consulting Feb 2019 – Feb 2020 Analytics partner to Small and Medium Business, Google ($120B Business)

• End to end engagement and delivery in an onsite-offshore model for SMB clients leading a team of 5 members

• Worked with a team to create centralized data pipeline Multiple Touchpoint Database for all the ads marketing channels at a customer level. The database is used by the client and team to analyze marketing activities and for customer segmentation, customer analytics and product analytics (Adwords & Google analytics)

• Worked in GCP to analyze data from Firebase using Bigquery to analyze on Google Colab and visualize using Data Studio

• Created EMEA and Americas Dashboard to analyze the impact of marketing channels (such as emails, learning programs, events, and sales calls for Small and medium business customers) for the customers in the EMEA and AMERICAS region. Used by the client to identify opportunities in the mid market client segment

• Created Weekly Churn Tool for Customer churn analysis. customer retention analysis and better targeting of the customers to maximize revenue. This tool is being used to engage better with customers during on the peak churn periods to maximize revenue.

• Used Marketing Attribution model to analyze the impact of various marketing channels on revenue. Helped drive engagement and customer segmentation to optimize ROIs. Deloitte Bangalore, India

Consultant, CPG Jun 2015 – Nov 2016

• Converted the internship to the full-time job offer as Consultant at Deloitte

• Work with Client Partners to develop Project proposals on Marketing Analytics through dashboards and SQL for building data pipelines by using data base such as Nielsen and Internal Sales data

• Delivered Tableau global database dashboards to compare the ROI for different brands across geographies

• Building forecasting models basis regression and timeseries models for predicting demand for CPG firms

• Understanding impact of the shopper metrics such as penetration, consumption on sales through correlation analysis

• Drafting Monthly, Quarterly and Annual Reports on marketing performance with analysis on competition and channels ACADEMIC EXPERIENCE

Crime Analytics Los Angeles, USA

Team Lead for six-member Team Feb 2018 – Apr 2018

• Employed Multinomial logistic regression to predict occurrence of crime at a location and ARIMA Forecasting models to develop crime forecast.

• Visualized using Tableau and IBM Watson and presented results to the Sheriff of Fullerton Police department for predictive policing to allocate resources to high risk areas. Health Care Analytics Teradata Case Competition Los Angeles, USA Group Lead for Three Member Project Mar 2018 – May 2018

• Built regression models to identify the medical professions more prone to prescribe overdosing of opioid medications using SPSS and XL Miner and communicated the business insights. RIM alumni Mansi Bhat (PGDM 13-15 Batch) wins honor for her research paper at Teradata Analytics University Challenge held in Las Vegas (msrim.in) ACADEMIC ACHIEVEMENTS:

• STEM Children Author- ‘Cybersmart kids’- online safety for kids (Cyber Smart Kids: Staying Safe Online a book by Mansi Bhat and Smiling Alpaca Publishers (bookshop.org)

• Research Assistant to Prof. Rahul Bhaskar of CSU, Fullerton and helping Analytics MSBA students for concepts clearing and assignments.

• President of Business and Data Analytics Club at CSU, Fullerton and Core member of Womens Leadership Club at CSU Fullerton

• President of the MSRIM Placement Committee, Cultural coordinator and Make a Difference Foundation

• Second grade Guitar Player from Trinity University and performed at multiple Professional events PROFESSIONAL ACHIE

VEMENTS:

• ‘Impact of Leaks on TV Shows’ social media analytics paper presented at SAS Forum, Colorado 2018

• ‘Analytics approach to predict total recall in automobile industry’ presented at SAS Global Forum, Florida 2017

• Winner of two Excellence Awards at Deloitte- Distinction through initiative and ownership 2016

• Won STAR Award at Fractal for delighting the Google SMB Client with marketing analysis 2019

• Quick off the Block Award by Tredence Analytics for working with Marriott client and resolving the escalations as soon as I joined the account 2021

Contact this candidate