CHETAN RAUT
ANALYST
Hello there!
My name is Chetan and I am delighted to welcome you to my website. Kindly scroll down to discover more about my work.
Chetan Raut
Engineer | Analyst | Sport Enthusiasts
About Me,
๐ผ Analyst with 1 year of experience in solving business problems by gathering and analyzing data.
Creating Data visualization and providing meaningful insights to stakeholders.
Preparing executive-level Presentations, reports, and Dashboard.
Additionally, 2 years of experience as a freelancer, Proficient in the Microsoft Office suite (#Excel, #PowerPoint, #PowerBI, #Word, etc.), and Skilled in Stakeholder management. (Maintaining Rapport, Conflict Resolution and RAP/PRR techniques, etc.)
Focused on Business Growth, Data Accuracy and Operational Efficiency. (Retail and E-commerce, FMCG, Edtech)
๐ฏ Functional Areas
Business Analyst | Data Analyst | Marketing Research | Visual Specialist | Operation Analyst | Supply Chain
Business Intelligence | Presentation Specialist
๐จโ๐ Accomplished Engineer armed with a Bachelor of Engineering in Mechanical.
๐โโ๏ธ Beyond the professional realm, working as a Plogger on the weekend โป(The act of picking up trash and litter while jogging). Gained valuable Teamwork, Leadership, and environmental awareness skills through my involvement in a social cause.
๐บ Passionate about Movies, Web Series, and Cricket enthusiasts.
๐ค Please feel free to connect with me for networking, discuss Job opportunities, collaborate and exchange ideas.
Email: chetanraut2014@gmail.com
Thank you.
Education
Yeshwantrao Chavan College of Engineering, Autonomous Nagpur
Bachelor of Mechanical Engineering
2019
Nagpur, Maharashtra
1) Completed a 30-hour Dale Carnegie workshop. Improved Professional Development skills like Self-confidence, Leadership and Teamwork.
2) Organized 3 Technical and 1 Cultural Fest, with over 500+ attendees in 2017.
3) Participated in the Matt Abrahams workshop (Think Fast, Talk Smart) held by VNIT Nagpur in 2018.
4) Published 2 Research papers for the final-year project, focusing on the design and development of a spray painting machine.
5) Engage in networking events to establish meaningful connections, collaborate with classmates, and explore new ideas together. Additionally, Participate in cricket matches to foster team building and develop valuable connections.
Project
The pages below showcase samples of my work using Microsoft Office tools.
(Projects are updated regularly)
Tools and technologies I work on include:
- Microsoft Excel
- PowerPoint
- Microsoft Word
- Canva
- Power BI
- Outlook
- Google Tools
- SharePoint
- SQL
- AI Tools - ChatGpt, Bard
Climate and Sustainability for Fast Cars
๐น Sector: Fast Cars, Automobiles Industry
๐น About Company X is a telecom company that sells the mobile handset
๐น Problem: The automotive client, Fast Cars, has pledged to reduce carbon emissions and their Science Based Target initiative (SBTi).
They are under pressure from investors to address climate change and expect new regulations to mandate the phase-out of Internal Combustion Engines (ICE) used in their cars.
๐น Task: Assisting Fast Cars to Achieve Net-Zero Emissions in a High-Performance Industry. Helping to understand the current emissions profile of Fast Cars
Task 1: Setting the Baseline
- Understanding what the situation is for the client and identifying opportunity areas.
Task 2: Context and Benchmarking
- Comparing the clientโs baseline position within the industry.
Task 3: Costs and Benefits
- Understanding an abatement curve.
Task 4: Adding Value
- Looking for additional ways to help clients.
Task 5: Risks and Opportunities
- Differentiate between Risks and Opportunities for clients.
Task 6: Making it Stick
Communicate with client and their investors.
Research analysis for Telecom company X
๐น BCG Strategy Consulting Job Simulation
๐น Sector: Telecommunications and IT Sector.
๐น About Company X is a telecom company that sells the mobile handset
๐น Problem: Telecom Company X has been facing a decline
in profits over the past few years. company exploring one of the hypotheses under consideration is the introduction of handset leasing.
๐น Task: Improvements in profitability, By working on the hypothesis of handset leasing.
Task 1: Market Research on Handset Leasing Hypothesis
Task 2: Financial Statement Analysis of Telecom Companies
Task 3: Data Analysis and Modeling Using Historical Data
Task 4: Understanding Consumer Needs and Product Development
Task 5: Identifying Potential Objections in Hypothesis
Task 6: Providing Executive summary
๐น This analysis suggested that Company X should enter the handset leasing market, presenting the "TechFlex Upgrade Plan" to a target segment of tech-savvy individuals below 30 who prioritize frequent upgrades and affordability. This conclusion is grounded in industry success stories, positive trends, global perspectives, and the environmental sustainability benefits associated with handset leasing.
For details, please refer to the presentation.
๐น โ Tools Used: #Excel, #PowerPoint, AI
Data-driven marketing analysis of Codex Beverage
Resume Project Challenge #6 is organized by the codebasics team.
๐น Sector: Food and Beverage
๐น About Codex: CodeX is a German beverage company. A few months ago, they launched their energy drink in 10 cities in India and have ambitious plans to expand its distribution nationwide, aiming to bring their top-quality products directly to consumers.
CodeX conducted a survey in 10 cities and received feedback from 10k respondents.
๐น Task: Provide Data-driven key Insights and recommendations to the Chief Marketing Officer (CMO) and Marketing Team.
1. Identifying Demographic Insights & trends
2. Evaluating sales performance
3. Competition Analysis
4. Understanding customer behaviour
5.. Identifying opportunities for growth
6.. Evaluating promotional effectiveness
๐น This analysis can solve several problems, including:
1. Optimize revenue
2. Drive business growth
3. Allocation of resources effectively
4. Improve customer satisfaction
โ Tools Used: #Excel, #PowerBI, #PowerPoint
For Video Presentation Please click on Link
The presentation provides detailed insights and recommendations.
(Headphones are recommended for a better experience)
Superstore Data Insight
๐น Sector: Retail sector, e-commerce or online retail sub-sector
๐น Problem: The Retail sector client has recently seen a decline in profitability.
๐น Task: Diagnosed the problem, provide insight and recommend the solutions.
๐น Insight:
1) Average Order Value = Total Sales / Number of Orders = 21176377 INR / 31,047 orders
This gives us an average order value of approximately 682.07 INR.
2) 69% of online purchases are made by women, while 31% are made by men.
3) Adult women are more likely to make online purchases than adult men, Data suggests 44% of adult women make online purchases as compared to other age groups.
4) 80%, make purchases through three specific online retail channels/ platforms: Amazon, Flipkart, and Myntra.
5) 92% of orders were successfully delivered. A high rate of successful deliveries suggests that the business is effectively managing supply chain and logistics operations.
6) Top sales for the business are coming from five Indian states: Maharashtra, Karnataka, Uttar Pradesh, Telangana, and Tamil Nadu.
๐นRemedy/ Proposal:
1) To optimize profitability and growth for a retail business, it is important to understand the distribution of order values.
2) Identifying the range of values for individual orders can help a business to identify.
3) Adult women are the targeted audience and can implement targeted marketing campaigns, providing discounts for larger purchases or coupons to this age group.
4) To optimize online sales strategy, leveraging popular channels/platforms to sell their products through additional marketing efforts or unique value propositions.
5) Consider diversifying sales channels beyond just famous platforms in order to mitigate risks associated with over-reliance on a single channel.
6) To minimize cancellations and returns, businesses should prioritize providing accurate product descriptions, clear return policies, and high-quality customer support.
Data Analysis: Red Bull Account Sales
This report will provide an overview of the Red Bull account sales data, including the types of accounts analysed, the time period covered, and the data sources used. It will also highlight key findings and observations from the data analysis, including any notable trends, correlations, or areas of improvement.
๐น Sector: consumer goods/beverage sector.
๐น Task:
1. Identifying sales trends
2. Evaluating sales performance
3 Understanding customer behaviour
4. Identifying opportunities for growth
5. Evaluating promotional effectiveness
๐น This analysis can solve several problems, including:
1. Optimize revenue
2. Drive business growth
3. Allocate resources effectively
4. Improve customer satisfaction
๐น Insight
๐น Account Sales โ Highest Performing
โข Bar 13, Nightclub 5, and Event Venue 11 have witnessed remarkable sales growth in recent times, and it's worth considering the factors that have contributed to their success in order to replicate them.
across other accounts of similar types.
โข Bar 13 has the highest 5-year CAGR of all these accounts, followed by Restaurant 5 and Nightclub 2. Analyse successful strategies to identify consistent best practices for application across other accounts.
๐น Account Sales โ Lowest Performing
โข Event Venue 1 has the worst 5-year CAGR (sales decline) of all these accounts, followed by Bar 7 and Restaurant 8.
For details Insight please check the report's last page.
Cupcake Shop 5-year P&L Forecasting
A cupcake shop that produces baked goods for both consumers and businesses.
Sector: Food and beverage retail sector.
๐น Problem: The client wants to know what their business will look like in five years if all goes to plan.
๐น Task:
- The operating forecast assumptions
- Producing a forecast profit and loss (P&L) statement
- Forecast the Cupcake shopโs future Cash flows
- Conducting a forecast Excel analysis for the cupcake shop!
๐น Insight:
1)$ 1,207,517 will be the Total Revenue and Gross Profit will be $ 806,565 at the end of 2025
2)Closing Debt is zero, which means that the business will fully pay off all of its outstanding debts or obligations by the end of 2025.
3)This is a positive sign for the financial health of the business it indicates that the business will manage its debt effectively and is not burdened by high-interest payments or outstanding debt. And may make it more attractive to lenders, investors, and other stakeholders
4)$ 87,115 will be the Closing cash at the end of 2025. This means the shop will generate more cash from its operating, investing, and financing activities than it spent during the year and has sufficient liquidity to fund its operations and growth opportunities.
5)$ 149,506 will be the Net Cash Flow. This means the shop will generate more cash inflows than outflows during that period.
๐น Remedy/ Proposal:
1)However, it is important to note that having zero closing debt does not necessarily mean that the business has no outstanding financial obligations, as it may still have accounts payable, taxes, or other liabilities that need to be paid
2)Utilizing the remaining Cash resources effectively, such as investing in long-term assets, acquiring new businesses, or returning value to shareholders.
3)Consider external factors: External factors such as economic conditions, industry trends, and changes in consumer behavior can all impact cash flow.
4)Be conservative and prepare for any unforeseen events or expenses.
Note: It's important to note that a profit and loss forecast is just that - a forecast. It's not a guarantee of future profits or losses. However, by carefully estimating your expected revenue and expenses.
CAR SALES PIPELINE TRACKER
This is a win-loss analysis project for an auto accessories shop, where I utilised a sales pipeline tracker to understand better the success factors driving their sales.
Auto accessories shop in the US which comes under the automotive aftermarket sector wants to know the failure of a company's products or services in the market.
๐น Problem
1) The client wants to know the reasons behind the failure of a company's products or services in the market.
2) Why they are gaining or losing customers and how to improve their products or services to better meet the needs of their target market.
๐น Task
1) Analysing and Improving the Sales Pipeline Conversion Rate
The focus of the project would be to identify the reasons behind the high percentage of losses in the sales pipeline and develop strategies to improve the conversion rate.
This report presents a detailed analysis of the sales pipeline for an Auto accessories shop. highlighting key trends and performance metrics. Overall, the analysis shows that the sales pipeline has a win rate of 23% and a loss rate of 77%. The report identifies several key areas for improvement, including lead quality, sales process optimization, and training for the sales team.
Timestamp for video
Dashboard- 00:01 Sec
Introduction- 00:35 Sec
Insight- 00:44 Sec
Proposal- 00:54 Sec
The pages below showcase samples work using MS PowerPoint.
๐นTopic
A Critical Analysis of the Leading Video
Conferencing Tools: Zoom, Google Meet, Microsoft Teams, and Amazon Chime.
๐น Agenda
This analysis provides a comprehensive evaluation of these platforms, with a particular emphasis on their crucial features, usability, security, pricing, and overall performance.
I've learned from
- Pluralsight
- Capgemini Degreed Platform
- YouTube, Google
- Other online Platform
BCG Strategy Consulting and market research
Goldman Sachs Excel Skills for Business
Excel 2019 Pro
Climate and Sustainability through Market Research
Introduction to SQL & Fundamentals
Verbal and Written Communication Excellence Program
PowerPoint 2019 Pro
UK Counsellor Course
Outlook 2019 Essentials
Communications: How to Talk, Write, Present,
and Get Ahead
Extracurricular Activity
๐ธ Advocate for Healthy & Clean Nagpur!
Nagpur Municipal Corporation Government office
Cause: Environment and Health | Mar 2023
๐น Swimathon' for Clean, Beautiful & Healthy Nagpur!
- Participated in swimathon, swam in the pool for continuous 3 hours. Top performer in my age category out of 200+ participants, from 7 to 67 years.
- Empowered the community to enhance the cleanliness of Nagpur, with a particular emphasis on preserving the city's 11 lakes and water bodies.
- Planting new trees and preserving existing ones contribute to improved air quality and biodiversity.
- Advocated eco-friendly practices, endorsed responsible plastic use, promoted environmental sustainability
๐ Arboreal Award, Eco-friendly award for an eco-friendly event!
๐ธ Campaign Volunteer
โป Nagpur Ploggers
Cause: Environment and Health | Dec 2020 - Present
๐น Plogging (plocka upp)= Swedish term which means picking up garbage while jogging and spreading awareness.
- Worked with 100+ ploggers, Dedicated time and effort to volunteer for the environmental group.
- Participated in 50+ weekly cleanup drives, contributing to a cleaner environment, reducing plastic waste, and improving community well-being.
- Collaborate with Municipal corporations (NMC). Empowered community, green city, reduced plastic pollution and Enhanced people's participation and civic responsibility by 10%.
Impact:
- Gained valuable teamwork, leadership, and environmental awareness skills through my involvement in a social cause.
- Felt a sense of satisfaction and happiness from contributing to society and making a difference.
Weekend Drive
More the merrier!๐ Started with 15-20 ploggers.
Now we are a team of 100+ active members. ๐ ๐ช
Clean Karona Campaign,
After Covid-19
