Mrunmayee Bhagwat Email & Phone Number

San Jose, Ca, Us

San Mateo, California, Us

- Partnered with sales leadership to identify opportunities for Rakuten's strategic merchants, recommended solutions and executed them- Provided analytics expertise to merchants on calls to discuss advertising strategy to boost GMV, customer acquisition through Rakuten, also conducted A/B tests for media placements and cash back rate- Focused on automation and building reusable, scalable data frameworks using SQL (Snowflake) and Tableau

San Mateo, California, Us

- Led a team of analysts to deliver B2B and B2C analytics solutions- Collaborated cross-functionally, identified growth opportunities for business and prioritized high impact projects, resolved conflicts and ensured timely project deliveries - Helped merchants reach Rakuten's customer base by designing personalized, targeted campaigns for customers and provided recommendation for budget allocation and cash back to maximize merchant ROAS- Provided a thorough analysis on merchant performance in QBRs and recommended strategy to achieve their goals - Partnered with growth & marketing teams to run acquisition and retention campaigns for customers, performed power analysis for AB tests, LTV calculation and other analyses

San Mateo, California, Us

- Supported sales team with merchant data analysis, cash back campaigns, email campaign lists, QBRs, troubleshooting data issues, etc- Analyzed media campaigns, email performance and site placements and suggested strategy to improve merchants' ROAS- Built Tableau dashboard to track campaign performance, merchant invoicing, created data models and dashboard templates to automate the process- Managed an intern, helped in onboarding, work allocation and ensured successful project delivery

- Data Insights: Used SQL, quant and statistical methods to analyze global sales behavior and pitching activity to design revenue-based incentive system for sales force. Worked with cross functional teams to identify features that drive the ad business and recommended changes. - Dashboards and Data Visualization: Integrated large datasets to build dashboards to monitor and analyze daily sales activity and program performance. Defined success metrics and set up ETL processes to derive meaning from unstructured data. This provided insights to leadership and facilitated data-driven modifications to program structure.- Innovation: Collaborated with program managers to identify revenue opportunities in seller’s portfolio by performing quarterly revenue analysis using SQL, R and Tableau. This laid a foundation for a pilot launch in Q1 2018 with a potential of increasing quarterly brand revenue by 10%.- Operational Excellence: Ensured successful rollout of sales programs on revenue-based incentive system. Built and maintained SQL frameworks to automate productivity goals setting for sales force.

San Francisco, Ca, Us

- Analyzed YouTube channel metrics for the client channels and suggested ways to increase video views and channel subscription using Python, PostgreSQL.- Developed an algorithm that discovers similar YouTube channels based on performance metrics and video type to present the clients (multi-channel networks) with potential business opportunities; Used K-means clustering, k-NN and NLP machine learning techniques.- Enhanced the accuracy of existing prediction model by 15% using random forest to better predict the average daily YouTube video views and helped put the model into production.

Santa Clara, Ca, Us

- Used NLP techniques to categorize Walmart’s unstructured social media data.- Identified seasonal fluctuations and trend in Walmart’s revenue by performing time series analysis on its social media data using R; Modeled quarterly revenue using SARIMA approach by achieving an error rate of 0.008.

Mumbai, Maharashtra, In

- Worked closely with the underwriting team to estimate GIC's risk exposure in the US (state-wise and peril-wise) by performing an exhaustive analysis of its reinsurance treaties and claims data; the analysis led to informed underwriting decisions that minimized GIC’s risk in the US.- Estimated GIC's IBNR (Incurred but not reported) claims reserves for aviation line of business (foreign and domestic) for the annual report of 2013-14.

Mumbai, Maharashtra, In

Pricing:- Using Frequency-Severity method, modeled number of claims and cost per claim to determine premium rates for corporate travel insurance product of the company. Reserving: - Used IRDA data to forecast IBNR claims reserves using chain-ladder and Bornhuetter-Ferguson methods. Analyzed claims settlement process and derived insights that helped improve customer service.

Bangalore, Karnataka, In

- Developed a web application to remotely configure and monitor the client's wind farms using C# and SQL Server.- Collaborated with the client and the team to create and translate functional requirements into technical design specifications.

Master'S Degree, Analytics

Mba, Finance, Banking & Insurance

B.E., Electronics And Telecommunication