Portfolio - Lesie Fernandes | Codebasics

Powered by
Codebasics DA Bootcamp

Lesie Fernandes

Data Aspirant

EMAIL

[email protected]

PHONE

+91 7507426122

About Me

Hi, I’m a data enthusiast with a background in finance, currently transitioning into the world of data analytics. With a Bachelor's degree in Financial Markets and professional experience in accounting, I’ve always been drawn to numbers—but what truly excites me is uncovering the story behind them.
My journey into analytics began with curiosity and quickly turned into a passion. I’ve since built a strong foundation in Excel and Power BI, using them to analyze data, spot trends, and generate insights that support smarter business decisions.
Through self-driven learning and hands-on business projects, I’ve developed a data-focused mindset, blending financial logic with analytical thinking. I take pride in simplifying complex data and communicating it clearly to drive action.
These projects, detailed in my portfolio below, reflect my commitment to learning and real-world application of data analytics
I’m excited to bring my skills, curiosity, and drive to innovative organizations, where

1

Excel Project

3

PowerBI Projects

1

SQL Project

2

Python Projects

Key Skills

EXCEL

POWER BI

SQL

Python

EFFECTIVE COMMUNICATION

PROBLEM SOLVING

My Projects

My Experience

Career Transitioner

Accountant – Stallion Barware, Mumbai

Jan 2020 – Mar 2025

· Reconciled 1,000+ bank and vendor transactions monthly, ensuring 100% accuracy and reliable financial insights.

· Streamlined sales invoice generation for 10+ clients, reducing billing errors by 15% using data-driven workflows.

· Verified and updated purchase invoices in ERP, improving data accuracy and operational efficiency by 20%.

· Produced Purchase Orders and Proforma Invoices for 15+ clients, optimizing procurement and sales operations.

· Monitored dispatch records and collaborated with production teams to ensure 100% on-time deliveries.

· Coordinated with overseas clients for timely shipments, maintaining 100% document accuracy.

· Created weekly and monthly reports in Excel to monitor unbilled balances, reducing unbilled amounts by 10% over three months..

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

Python: Beginner to Advanced For Data Professionals

Resume Project Challenge No.16

Resume Project Challenge No.16

Let's Work Together!

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.

EMAIL

[email protected]

Call Me

+91 7507426122

LinkedIn

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

GitHub

https://github.com/Lesie-23

Excel Project

Sales and Finance Analytics

Domain/Function: FMCG

Developed two analytical reports for the sales team, enabling them to evaluate customer performance and assess market positioning against sales targets, driving more informed and strategic decision-making.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics

Customer Performance Report: Shows the net sales performance of each customer over multiple years.

Sales and Finance Analytics

Market Performance vs Target Report: Assesses each country's sales performance across years compared to targets for better strategic decisions.

Project Details

In this project, I developed a dynamic sales report using Excel Pivot Tables to support better business decision-making. The report helps identify optimal customer discount strategies, improve negotiation outcomes, and uncover potential markets for expansion.

Key Skills Gained:

1.Pivot Table creation and analysis
2.Power Query for data cleaning
3.Basic DAX calculations
4.Conditional Formatting for better data visualization
5.Understanding key Sales Domain Metrics

Overall, this project enhances a business’s ability to monitor, assess, and optimize its sales activities. By leveraging sales data analysis, businesses can discover new growth opportunities, strengthen customer relationships, and stay competitive in a fast-evolving market.

PowerBI Project

Business Insights 360 – AtliQ Hardware

Domain/Function: Brick & Mortar and E-commerce

AtliQ Hardwares, a fast-growing consumer electronics company, struggled to compete as most reports were still in Excel. My goal was to implement an advanced analytics solution with Power BI, providing real-time insights to help the company make informed, data-driven decisions .

View Project
Engagement

View Project
on GitHUB

Business Insights 360 – AtliQ Hardware

The Home Page acts as the central hub, allowing users to easily navigate through different business views using bookmarks for seamless interaction.

Business Insights 360 – AtliQ Hardware

Data modeling involving 15 tables

Project Details

The goal of this project was to create a unified Power BI dashboard for 5 different departments, enabling teams to analyze data and make informed, data-driven decisions.
Throughout the process, I enhanced my skills in:
1.Power Query (Basic and Advanced Operations)
2.Basic and Complex DAX Formulas
3.Data Modeling (involving 15 tables)
4.Selecting and Formatting the Right Visuals
5.Dashboard Design Principles
6.Using Bookmarks for Enhanced Interactivity
7.Deploying Reports on Power BI Service
8.Implementing Stakeholder Feedback
9.Analyzing Sales, Marketing, Finance, and Supply Chain Metrics

This project allowed me to deepen my understanding of Power BI while creating an impactful tool for decision-making across departments.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-Hoc Requests

Domain/Function: Consumer Goods

Atliq Hardwares is one of the leading computer hardware company. They faced challenges to get data driven insights and to make decisions. In order to solve this they had to hire an analyst to solve the ad-hoc requests via SQL and to provide insights using Power BI.

View Project
Engagement

View Project
on GitHUB

View Project
on Power Point

Consumer Goods Ad-Hoc Requests

What is the percentage of unique product increase in 2021 vs. 2020?

Consumer Goods Ad-Hoc Requests

Provide a report with all the unique product counts for each segment and sort them in descending order of product counts.

Project Details

Company Overview:-Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too. They produce Mouse, Keyboard , PC and so on.

Challenge:-Management faced challenges as they couldn’t access insights needed to make smarter, data-driven decisions for their business.

Task:- 1.Analyze 10 Ad-hoc requests and provid business insights.
2. Create a presentation to showcase the insights, tailored for top-level management.
My Approach:- Utilized SQL to run queries and extract neccessary data.
Used POWER BI for visualization and provide insights.
Designed presentation using Microsoft powerpoint and provided meaningful insights for the top-level management.
This project gave me the opportunity to work through complex data queries and turn them into meaningful, easy-to-understand insights.

PowerBI Project

Atliq Hospitality Analysis

Domain/Function: Hospitality domain

AtliQ Grands, a five-star hotel chain in India for 20 years, faced losses due to rising competition and poor decisions. As a data analyst, I used Power BI to deliver key revenue insights and support strategic decision-making for business recovery.

View Project
Engagement

View Project
on GitHUB

Atliq Hospitality Analysis

Performance Overview - it provides a detail of revenue, revpar, occupatancy % , property details by city wise, weekday and weekend.

Atliq Hospitality Analysis

Booking Analysis - this page provides total bookings, capacity, cancellation %, average rating of the hotel, total booking by room class.

Project Details

While working on this project i built a dashboard providing actionable insights to the Atliq Grand's revenue team.

The dashboard has 2 pages:-
1.Performance Overview - it provides a detail of revenue, revpar(revenue per average rating), occupatancy % , property details by city wise, weekday and weekend.

2. Booking Analysis - this page provides total bookings, capacity, cancellation %, average rating of the hotel, total booking by room class.

Tools used:-
1. Excel - used as a dataset
2. Power Bi - for creating dashboard

Key learnings :-
1. Data Modeling
2.Data Visualization
3.Dax

Live Interactive Dashboard

PowerBI Project

Airpure Market Research

Domain/Function: Consumer Goods /Research Analytics

AirPure Innovations, an early-stage startup, is developing an air purifier for India. With 14 of the world’s most polluted cities in India, the firm sees a severe air quality crisis but needs solid market analysis to confirm strong, long-term consumer demand before committing to a full-scale launch.

View Project
Engagement

View Project
on GitHUB

Airpure Market Research

Overview of AQI

Airpure Market Research

Regional Pollution Breakdown

Project Details

Company Overview: AirPure Innovations, an early-stage startup, is developing an air purifier for India. With 14 of the world’s most polluted cities, India faces a severe air quality crisis. The company seeks solid market analysis to confirm long-term demand before a full-scale launch.

Project Overview: Using Indian datasets—AQI, health impacts, population trends, and EV adoption—it identifies priority markets and provides data-backed recommendations for product, pricing, and entry.

🔑 Focus Areas: Target PM2.5/PM10, define features, size demand, align R&D.
🧠 Insights: Worst AQI: Delhi, Ahmedabad, Bengaluru, Hyderabad, Kolkata, Pune; Tier 2: Nagpur, Bhopal, Lucknow. Demand spikes post-Diwali/winter. Awareness moderate in urban, low in rural. NCAP/FAME-II policies improved AQI. Children (6–11) most affected.
🎯 Recommendations: Multi-stage filtration, UV sterilization, smart features, compact design, affordable pricing, focus on polluted zones.

Live Interactive Dashboard

Python Project

Atliq Grands-Hospitality Analysis

Domain/Function: Hospitality / Revenue

“AtliQ Grands, a hotel chain in Mumbai, Delhi, Bangalore, and Hyderabad with brands like Seasons, Exotica, Bay, and Palace, faces declining revenue and market share, prompting data-driven strategies to boost efficiency, revenue, and competitiveness.”

View Project
Engagement

View Project
on GitHUB

Atliq Grands-Hospitality Analysis

Analyze hotel booking data to identify trends, optimize operations, increase revenue, and improve customer satisfaction.

Atliq Grands-Hospitality Analysis

Average occupancy % by city

Project Details

“AtliQ Grands, a hotel chain in Mumbai, Delhi, Bangalore, and Hyderabad with brands like Seasons, Exotica, Bay, and Palace, faces declining revenue and market share, prompting data-driven strategies to boost efficiency, revenue, and competitiveness.”

🎯 Project Objective
The primary objective of this project is to leverage data analytics on booking records from both the official website and third-party platforms. By analyzing patterns in bookings, revenue, occupancy, and customer behavior, the project aims to:

- Identify high-performing and underperforming properties.
- Optimize revenue generation across platforms and cities.
- Inform strategic decision-making for marketing, pricing, and operational improvements.
- Provide actionable insights to drive growth and competitiveness in the market.

🛠️ Tools used:
- Python (pandas,matplotlib)
- Jupyter Notebook

Python Project

Expense Management System

Domain/Function: Finance

Developed a full-stack expense management application with a Streamlit frontend and FastAPI backend, allowing users to seamlessly record, update, and analyze expenses across categories and time periods.

View Project
Engagement

View Project
on GitHUB

Expense Management System

This page lets users add, update, or delete expenses and view a detailed list of entries with their corresponding dates.

Expense Management System

This page allows users to filter expenses by start and end dates and by category, providing clear insights into spending patterns.

Project Details

“The Expense Management System allows users to perform full CRUD operations on expenses, storing details like date, amount, category, and notes in a MySQL database. The FastAPI backend provides endpoints for adding expenses, retrieving data by date, generating category summaries, and monthly analytics, with logging for monitoring and debugging. The Streamlit frontend offers a user-friendly interface with an interactive dashboard, enabling clear visual insights into spending patterns by category and over time.”

#TechStack Used:
- Frontend: Streamlit
- Backend: FastAPI
- Database: MySQL (Connected using MySQL - Connector-Python)
- HTTP Testing: Postman
- Logging: Python's built-in logging module
- Testing: Pytest