Portfolio - vishally hariprasath

Excel Project

Sales Report

Happy to share with you all that I completed "Excel: Mother of Business Intelligence" on codebasics on Aug 30, 2023. Key things which I learned in Excel: Excel functions ✔ VLOOKUP ✔ HLOOKUP ✔ INDEX ✔ MATCH ✔ SUMIF ✔ COUNTIF ✔ Data Visualization: ✔ Charts ✔ Graphs ✔ Pivot tables

View Project
Engagement

View Project
on GitHUB

Customer Net Sales Performance includes filters such as region, market and division for all the fiscal year

Market Performance vs Target

Project Details

✨ Utilized conditional formatting to highlight key insights and trends within large data sets. ✨

Automation and Macros:
🌟 Developed Excel macros using VBA to automate repetitive tasks, reducing manual workload by X%.
🌟 Created user-friendly interfaces for macros to enhance accessibility for team members.

Financial Modeling:
🌟 Designed comprehensive financial models to forecast budgets, project revenues, and analyze investment opportunities.
🌟 Utilized Excel's data analysis tools to perform scenario analysis and sensitivity testing for informed financial decisions.

Report Generation:
🌟 Generated detailed reports and summaries using pivot tables, supporting management in strategic decision-making.
🌟 Combined pivot tables with charts and graphs to create visually appealing and informative data representations.

PowerBI Project

Business Insights-360

The aim of the project is to generate actionable business insights by analyzing data to support informed decision-making. This project aims to empower decision-makers with actionable insights derived from data, ultimately driving operational excellence & enhancing the overall business performance.

View Project
Engagement

Financial View includes KPIs, Net sales Performance Over Time, P&L Statement, Top / Bottom Products & Customers by Net Sales.

Supply Chain View includes KPIs, Accuracy / Net Error Trend, Key Metrics by Customer, Key Metrics by Products.

Project Details

The "Boosting Efficiency with Data Insights" project leverages computer analysis to enhance our business. Analyzing internal data, we focus on key metrics like order delivery speed and customer satisfaction, using tools like Excel and PowerBI. The goal is to optimize inventory and operations, presenting findings through concise reports and visuals. Led by data experts, the project anticipates streamlined operations, improved customer satisfaction, and cost savings, acknowledging challenges with a commitment to ongoing improvement. Ultimately, the project aims to inform decision-making, contributing to overall business excellence.

Live Interactive Dashboard

PowerBI Project

Revenue Insights In Hospitality Domain

Maximize revenue in hospitality. Analyzing booking patterns, pricing strategies, and customer preferences for data-driven insights. Improve decision-making for increased profitability.

View Project
Engagement

Revenue Insights includes KPIs, Revenue % for category, Trends & Properties by Key Metrics, Realisation % & ADR by booking platform for June 2022.

Revenue Insights includes KPIs, Revenue % for category, Trends & Properties by Key Metrics, Realisation % & ADR by booking platform for May 2022.

Project Details

"Maximizing Hotel Profits" is a smart project in the hospitality world. We use clever tools to study how people book and what prices work best. Our goal is to help hotels make more money by understanding customer preferences. We'll give easy tips on pricing strategies, ensuring guests are happy, and profits go up. By looking at booking patterns and customer feedback, we aim to create a simple yet effective plan to boost revenue. The team, made up of pricing experts and data wizards, will use special tools and techniques. The project's benefits include increased earnings, better pricing strategies, and improved guest experiences. While we know there might be challenges like changing markets, we're committed to keeping an eye on things and making our plan even better over time. The "Maximizing Hotel Profits" project is all about making smart decisions to help hotels thrive.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Project

Thrilled to share insights from my latest venture in consumer goods. From concept to market impact, I've led seamless project execution. Explore my journey in turning visions into reality, driving success & making a mark in the consumer goods industry.🌟💼

View Project
Engagement

View Project
on GitHUB

the list of markets in which customer "AtliQ Exclusive" operates its business in the APAC region

This picture has Top 5 customers who received an average high pre_invoice_discount_pct for the fiscal year 2021 and in the Indian market.

Project Details

Hello! I'm [Your Name], a Consumer Goods Project Leader. With expertise in on-time delivery, cross-functional collaboration, and creative problem-solving, I turn ideas into market triumphs. Let's connect on LinkedIn for a glimpse into my journey of transforming concepts into impactful ventures! 🌟💼 #ConsumerGoods #ProjectLeader #InnovationTrailblazer

PowerBI Project

Insights to the product strategy team in Banking Domain

Analyzed 4000 customer data for Mitron Bank, providing key insights to Mr. Bashnir Rover. Contributed to project validation, ensuring successful implementation for strategic product diversification at AtliQ Data Services.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Google Slides

ChatGPT

Insights to the product strategy team in Banking Domain

City Explorer: We peeked into spending secrets of Chennai, Bangalore, Delhi, Mumbai, and Hyderabad!

Category Adventure: From trendy Apparel to daily Groceries and wild Entertainment!

Project Details

Embarked on Mitron Bank's Credit Card Expansion journey, our mission was clear: making credit cards the ultimate financial sidekick! Leveraging Power BI magic, we delved into the spending secrets of Chennai, Bangalore, Delhi, Mumbai, and Hyderabad. Our Dream Team, led by Strategy Captain Mr. Bashnir Rover, executed a game plan targeting specific age groups and professions. Mumbai emerged as our spotlight for credit card buzz, while special promos in high-spending areas led to ninja-level customer targeting. The results spoke volumes – dreamy credit card upgrades, a meteoric rise in VIP cardholder love, and invaluable lessons in the power of data-driven decisions. Our journey continues with hyper-speed monitoring and continuous upgrades for the ever-changing finance galaxy – Mitron Bank's Credit Card Expansion, where finance meets fun! Ready for the spending spree?

Hello, I am

vishally hariprasath

1

3

1

About

Key

My

Sales Report

Business Insights-360

Revenue Insights In Hospitality Domain

Consumer Goods Project

Insights to the product strategy team in Banking Domain

Awards

Contact Me

Email

Github

Linkedin

Call

vishally hariprasath

Download Resume