Sai Mohana Kavya Yerramsetti

• Analysis of Sales Data of Retail Stores Across America using Exploratory data analysis (EDA) includes Aggregating&Ranking data,writing subqueries in SQL.
• Data visualization ,dashboarding &storytelling using Tableau.

• Identify trends in business- volume of raw material and analysis using time series forecasting, interpret trends and driving towards targets.
• Attention to detail of data hygiene in existing technology platforms used by Godrej.
• Strategic analysis of the business requirements and situation analysis of the service provided by company.
• Liaised with potential customers to determine needs and provide recommendations.
• Managed customer relationships, leading team and influencing towards goals/objectives.

Projects :

1. Traceability system at farm level :

Digital implementation of internal traceability system in value chain at farm level.

Approach: Database analysis -Entity relationship mapping (Entity to relational mapping).

2. Market research& analysis for customer segmentation:

Primary research and secondary research- Qualitative and Quantitative data analysis, analyzed trends of customers and drawing insights for the potential market.

3. Gamification project:

• Designed KPIs through identifying, analyzing, collection of business metrics for Task based rewards and badge-based reward system for Oil palm farmers to make them adopt best agricultural practices for better quality raw material outcome.
• KPIs: Badges as Gold, Silver and Bronze.
• Compliances: Critical, Major and Minor.

4. Optimization & Scale-up of professional service:

• Business issue analysis: Conducting stakeholder interviews and structuring variable data into analytical framework that provides data insights on scaling-up &optimization of the service provided by Godrej.
• Opportunity analysis and cost analysis for Godrej's business units for demand generation of products and services provided.
• Designing KPIs for services that includes Coverage ratio, Turnaround time, customer feedback, efficiency of operations, timely payments that drive longterm revenue to the business.

Content creation and development for Niti Aayog's -"Innovations for you" coffee table book series on "Agriculture and allied sectors".

Presentation of complex ideas of startups in easily understandable form for readers using the "Pyramid principle"(structured communication").

Hands-on experience in:

MS Excel, Tableau, Power BI,SQL, SPSS, R Statistics, ML using SAS, Time series analysis-Forecasting,Statistical models, Python.

Domain analytics:

• Marketing analytics-RFM analysis and HR analytics.
• Finance and Supply Chain Analytics(Unit price analysis).

1.Area of expertise:

• Market Research &Segmentation- My academic project is on "Effective Hyper-local marketing channel for Gardening E-commerce industry."
• Primary research on customer buying behavior, mode of advertising, and analysis through SPSS and approaches to marketing.

2. Business boot camp:

Manjeeramvillu Mango Farmer Producer Company, Sangareddy, Telangana, we have provided Business plan as:

Marketing plan, Production plan, financial plan, Operational and Management plan and Competitive analysis.

3. Digital marketing: Knowledge on WooCommerce website.