Asif Saheer Kallivalappil

Data Analysts

[email protected] +371 26654351

Resume

Hello, I am

Asif Saheer Kallivalappil.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Welcome to my portfolio! I am an aspiring Data Analyst with a deep-seated passion for leveraging data to drive strategic decisions and business growth. With a Master’s in Computer Systems from Riga Technical University and a Bachelor’s in Computer Applications, I have cultivated a strong foundation in data analysis, enriched by hands-on experience in advanced analytical tools and methodologies.
My project work showcases my ability to deliver actionable insights through sophisticated data visualizations and business analysis, including projects like the Sales Insight Report and Hospitality Analysis, which have led to significant improvements in business metrics and decision-making.
Certified in Big Data Engineering and Data Analytics, I am passionate about using data to drive strategic decisions and am excited to bring my skills to a dynamic team. Explore my portfolio to see how I can contribute to your organization’s success.

Key Skills

Stakeholder Management

SQL

Effective Communication

Data Visualization

Python

Critical Thinking

My Projects

Sales Analytics(FMCG)

Domain/Function: https://github.com/AsifSaheerkv/Excel-Sales-Analytics

Business Insights 360

Domain/Function: https://app.powerbi.com/view?r=eyJrIjoiMjc5M2E5N2MtZGNkZC00NGRmLWIyM2MtN2MxMzg1ZmI0YjBmIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9

Power BI Cricket Best 11

Domain/Function: https://app.powerbi.com/view?r=eyJrIjoiYzc1M2I1MmQtYjQxZi00NWQ0LWI0ZWUtNjdjNGMyMDU4NzkyIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9

Atliq hospitality

Domain/Function: https://app.powerbi.com/view?r=eyJrIjoiM2JiMzYzNTItMzk4OS00YzIwLThiNjktMTIzOTdjNmJlMjMxIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9

yahoo finance web scrapping package

Domain/Function: https://github.com/AsifSaheerkv/Web_Scrapping.git

Sales and Market Analysis Project

Domain/Function: https://github.com/AsifSaheerkv/Sales-and-Market-Analysis-Project-SQL.git

My Experience

Big Data Engineer | Accenture (Bootcamp) Mar 2023 - May 2023

Gained hands-on experience in handling large datasets and applied R and Python for various data analysis tasks, contributing to a better understanding of data-driven decision-making.
Participated in the development and delivery of a training program focused on advanced IT tools, which enhanced team skills and facilitated the adoption of new technologies within the organization

Product Specialist | DYNINNO Latvia Dec 2022 - Present

• Designed and implemented a comprehensive flight booking management system using GDS platforms including Apollo and Amadeus; streamlined processes resulted in a 25% increase in booking accuracy and reduced response times by 30%.

Data Analyst Intern | Codebasics (Remote) Apr 2024 - Present

Developed dashboards in Power BI, Excel, and Tableau for actionable insights.
Conducted analysis to identify trends and support decision-making.
Ensured data accuracy for reliable reporting.
Utilized SQL and Python for data manipulation.
Designed performance dashboards to track key metrics.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Big Data Engineer at Accenture

Excel

Power BI

Web Development

SQL Beginner to Advanced For Data Professionals

Data science 2021: complete data science bootcamp

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/asifsaheerkallivalappil

Call Me

+371 26654351

GitHub

https://github.com/AsifSaheerkv

Excel Project

Sales Analytics(FMCG)

Domain/Function: https://github.com/AsifSaheerkv/Excel-Sales-Analytics

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360

Domain/Function: https://app.powerbi.com/view?r=eyJrIjoiMjc5M2E5N2MtZGNkZC00NGRmLWIyM2MtN2MxMzg1ZmI0YjBmIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard

PowerBI Project

Power BI Cricket Best 11

Domain/Function: https://app.powerbi.com/view?r=eyJrIjoiYzc1M2I1MmQtYjQxZi00NWQ0LWI0ZWUtNjdjNGMyMDU4NzkyIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9

Cricket Best 11 is a data-driven project aimed at analyzing and optimizing cricket team selections using Power BI. By leveraging advanced analytics, the goal is to provide actionable insights that help in selecting the best possible team for optimal performance, surpassing traditional Excel-base

View Project
on GitHUB

Analyzing the top 11 cricket players globally

Data modelling tables

Project Details

Cricket Best 11 is a Power BI project aimed at creating a comprehensive report for analyzing the top 11 cricket players globally. The report will be useful for stakeholders in various domains, including marketing, finance, and the executive team. Key aspects of the project include:

1. Robust Data Modeling: Building a strong data foundation with over 10 tables.
2. User-Empathetic Report Design: Designing intuitive and user-friendly reports.
3. Drillable Insights: Offering deep, interactive insights into player performance.

Through this project, I acquired skills in:

1. Power Query (Basic and Advanced Operations)
2. Basic and Complex DAX Formulas
3. Data Modeling with Multiple Tables
4. Choosing the Right Visuals and Formatting
5. Dashboard Design Principles
6. Using Bookmarks
7. Deploying Reports in Power BI Service
8. Implementing Stakeholder Feedback
9. Analyzing Metrics for Top Cricket Players

Live Interactive Dashboard

PowerBI Project

Atliq hospitality

Domain/Function: https://app.powerbi.com/view?r=eyJrIjoiM2JiMzYzNTItMzk4OS00YzIwLThiNjktMTIzOTdjNmJlMjMxIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9

AtliQ Hospitality is a project aimed at transforming AtliQ ' reporting system by moving from Excel to an advanced analytics solution using Power BI. The goal is to provide the company with actionable insights and data-driven decision-making capabilities, helping them stay competitive in

View Project
on GitHUB

Provided Mock-up Dashboard

Data Model

Project Details

**AtliQ Grands** is a luxury hotel chain in India with 20 years of experience in the hospitality industry. Recently, they have been losing market share and revenue in the luxury/business hotel category due to strategic moves from competitors and poor management decisions. To address this, the managing director aims to leverage "Business and Data Intelligence" but lacks an in-house analytics team. As a result, the company hired a third-party provider to extract insights from their historical data.

As a data analyst, your task is to create relevant metrics and design a dashboard based on provided data and mock-ups.

Live Interactive Dashboard

Python Project

yahoo finance web scrapping package

Domain/Function: https://github.com/AsifSaheerkv/Web_Scrapping.git

The **yahoo_fin** package is a Python library designed for scraping stock data and financial information from Yahoo Finance. It allows users to retrieve real-time and historical stock prices, financial summaries, company data, and news. The package also supports downloading data in various formats a

View Project
on GitHUB

View Project
on

First 5 data

Visual graph

Project Details

This project utilizes the yahoo_fin Python package to scrape and analyze stock market data from Yahoo Finance. It focuses on retrieving real-time stock prices, historical data, company financials, and market news to provide actionable insights for decision-making.

Key Features
Real-Time Stock Price Retrieval: Fetch live stock prices for selected companies.
Historical Data Extraction: Collect historical stock data to analyze trends.
Company Financials: Scrape financial statements like balance sheets and income statements.
News Scraping: Gather the latest market news relevant to companies.
Data Visualization: Visualize stock performance using libraries like Matplotlib and Seaborn.
Tools Used
Python, yahoo_fin, Pandas, Matplotlib, Jupyter Notebook.

SQL Project

Sales and Market Analysis Project

Domain/Function: https://github.com/AsifSaheerkv/Sales-and-Market-Analysis-Project-SQL.git

SQL scripts and Excel files for sales forecasting, product performance, and regional market analysis. Key insights include top markets, product demand, and trends over time using SQL window functions. The project supports data-driven decision-making for business growth and market optimization.

View Project
Engagement

View Project
on GitHUB

View Project
on

MySQL query fetching customer data, including platform, channel, market, sub-zone, and region, from the dim_customer table.

MySQL query retrieving monthly sales data, including date, product, customer codes, and quantities sold, for fiscal year 2020

Project Details

Sales and Market Analysis Project
This repository contains SQL scripts and Excel files for sales forecasting, product performance analysis, and regional market insights. The project analyzes sales data across divisions and regions, forecasts trends, and provides actionable insights for decision-making, covering various fiscal periods, product categories, and geographical regions.
Project Structure
- Forecasting:
- `forecast_drop_2020_2021_sample.sql`: Sales forecasting from 2020 to 2021.
- `fact_est_forecast_table.sql`: Forecasted sales estimates based on historical data.
- Market Analysis:
- `region_chart.sql`: Generates charts for sales trends by region.
- `region_pie_chart.sql`: Creates pie charts visualizing sales distribution.
- Top Products:
- `top_2_market.sql`: Identifies the top 2 markets by sales.
- `top_n_product_per_division_by_sold_qty.sql`: Highlights the top N products sold within divisions.
- Window Functions:
- `data_set_window.