Swaroop KY

Data Aspirant

[email protected] +91 9535198901

Resume

Hello, I am

Swaroop KY.

2

Excel
Projects

1

PowerBI
Project

2

Python
Projects

About Me

As an aspiring Data Analyst, I am fueled by a passion for tackling complex problems and generating insights from data. As a recent Post - graduate, I bring fresh perspectives and a keen desire to learn.

My problem-solving skills are complemented by effective communication, making me adept at bridging the gap between technical intricacies and practical implications. Embracing the collaborative spirit, I believe in the power of teamwork and a supportive approach to achieve superior results.

Proficient in technical tools such as advanced Excel, SQL, Python, and Power BI, I am eager to leverage these skills to contribute meaningfully to projects and organizational goals. I am excitedly awaiting the opportunity to learn more, expand my analytical horizons, and make a positive impact in the dynamic field of data analysis

Key Skills

MYSql

Python

MS-PowerPoint

POWER BI

Machine Learning

MS-Excel

My Projects

Sales & Finance Analytics (FMCG)

Domain/Function: Brick & Mortar Business

US-Bank-credit-card Fraud-Prediction

Domain/Function: Banking

TripAdvisor Ratings Analysis using a K-Means Clustering Approach

Domain/Function: Data- Analytics

Optimal Portfolio Construction Using Sharpe’s Single Index Model

Domain/Function: Investment - Banking

Sales Performance Dashboard of Amazon

Domain/Function: E-Commerce

My Experience

FLIPCARBON, Virtual CFO, Financial Consulting & Accounting Services - Research Analyst Intern

Jul 2024 -Aug2024, Bengaluru

Conducted in-depth quantitative analysis of diverse data sources to inform strategic business decisions.
Performed financial statement analysis, including ratio, trend, and peer comparisons to assess company performance and identify growth opportunities.
Developed comprehensive market analyses, industry trend reports, and competitive landscapes, resulting in impactful corporate presentations.
Created visually compelling marketing materials to showcase the company's value proposition.
Conducted comparative financial analysis of key competitors (Workday India, One Identity Technology Systems, Keka Technologies) to inform strategic positioning and decision-making.
Technical Skills: Advanced Excel, PowerPoint, Data Analysis, Financial Modeling

BAJAJ ALLIANZ LIFE - Finance consultant intern

Jun 2023 -Aug 2023

Advising Clients on their financial planning
Risk Management needs (Life, Health, Business)
Responsible for Policy Evaluation and client consultants
Creating a list of potential clients, converting leads into business

Awards & Certificate

Excel: Mother of Business Intelligence

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

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/swaroop-ky-7381b1226

Call Me

+91 9535198901

GitHub

https://github.com/Swaroop055?tab

Excel Project

Sales & Finance Analytics (FMCG)

Domain/Function: Brick & Mortar Business

We analysed extensive datasets, extracting insights with Excel for informed decision-making. Leveraged ETL processes and Excel's Power Query/Pivot for efficient data handling. Produced impactful sales and financial reports guiding strategic decisions.

View Project
on GitHUB

The reports help businesses to compare the market's current year sales versus benchmarks that include last Year and targets.

Pivot Table for Atliq Hardwares' P&L data, organized by fiscal year and quarter. The data includes net sales, cost of goods sold, gross margin, and gr

Project Details

AtliQ Hardware, a top computer hardware producer, faces a challenge with insights from CSV files, hindering quick decisions. The Sales Director initiated analytics collaboration, outlining the requirements:

1. Sales Report: Analyze customer and market performance.
2. Finance Report: Visualize annual and monthly Profit & Loss data, including Net Sales, Cost Of Goods Sold, Gross Margin, and Margin Percentage.

This project aims to streamline data analysis, empowering informed decision-making for AtliQ Hardware's growth and market positioning.

Python Project

US-Bank-credit-card Fraud-Prediction

Domain/Function: Banking

This is financial fraud data about a bank and payments system. You will have to use this data to predict whether the transaction is Fraud or not , Use the first 4 million records for building the model, the next 1 million records for evaluating the model and the rest of the records as live

View Project
on GitHUB

Assessed the XGBoost model using classification reports, confusion matrices, and heatmaps, achieving a balanced accuracy of 92.45%.

The dataset consists of 11 columns, including transaction details and fraud indicators for a credit card fraud detection project.

Project Details

•Developed and optimised a high-performance XGBoost model using Python's Scikit-learn and XGBoost libraries
to detect credit card fraud with 92% accuracy
• Implemented effective data preprocessing using Pandas and NumPy to handle missing values, outliers, and
feature scaling, followed by feature engineering to create informative features for the XGBoost model.
• SMOTE to address class imbalance and standardised features to enhance model performance.
• Identified and removed leaking features to prevent overfitting and improve model generalisation.
• Assessed the XGBoost model using classification reports, confusion matrices, and heatmaps, achieving a
balanced accuracy of 92.45%.

Python Project

TripAdvisor Ratings Analysis using a K-Means Clustering Approach

Domain/Function: Data- Analytics

This data consists of review text and ratings the customers give on TripAdvisor. The ‘review_full’ text column from the data clusters the reviews to identify the top themes of positive and negative reviews given by the customers. This analysis will help businesses identify what customers

View Project
on GitHUB

Implemented K-Means clustering to categorise reviews based on sentiment, optimizing cluster count using the Elbow method for analysis.

Processes positive and negative reviews to extract unique words using set operations and generates a word cloud visualization for negative reviews. Th

Project Details

• Cleaned and preprocessed restaurant review data using Pandas and NLTK for missing values, lemmatization, and
stopword removal.
• Conducted exploratory data analysis (EDA) with Matplotlib and Seaborn to visualise rating distributions and
review lengths through bar plots and pie charts.
• Employed TF-IDF Vectorization from sklearn to convert cleaned text data into a numerical format for machine
learning applications.
• Implemented K-Means clustering to categorise reviews based on sentiment, optimizing cluster count using the
Elbow method for analysis.

Excel Project

Optimal Portfolio Construction Using Sharpe’s Single Index Model

Domain/Function: Investment - Banking

The aim of the project aims to enhance investor , understanding of portfolios by Using Sharp's Indexmodel effectively demonstrate in Building Portfolio which minimizes the risk and maximizes the returns

View Project
on GitHUB

The analysis investment proportions for selected companies, with key metrics A pie chart shows the distribution of investments among these companies.

The table shows the beta values of selected companies' stocks, indicating their volatility relative to the market.

Project Details

1. The primary objective uses Sharpe’s Single Index Model (SIM) to construct portfolios that maximize returns while minimizing risk, focusing on the Indian capital market.
2. The Project involved selecting fifteen companies from the Nifty 50 index and analyzing historical stock prices to calculate returns, beta values, and excess return-to-beta ratios. This data was used to assess systematic and unsystematic risks and to determine the optimal portfolio composition.
3. The project identified four stocks from the Nifty 50 index that were deemed optimal for portfolio construction based on the SIM criteria.
4. The project contributes to the understanding of portfolio management in the context of the Indian stock market, providing practical insights for both individual and institutional investors

PowerBI Project

Sales Performance Dashboard of Amazon

Domain/Function: E-Commerce

Developed a comprehensive sales dashboard using Power BI to visualize and analyse sales data across multiple categories, aiming to enhance decision-making capabilities,This initiative led to a 15% improvement in sales strategies and operational efficiency, providing actionable insights for strategic

View Project
on GitHUB

This Sales Dashboard provides an overview of key metrics like sales, profit, quantity, and discount, with visualizations

Power BI data model with three linked tables: People, Orders, and Returns.

Project Details

This project, the goal is to produce one report that has all analytic solutions using Power BI that will enable the company to get insights and make informed decisions 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. The dataset provides insights into customer purchasing behaviors, allowing for the identification of trends in sales across different regions and product categories.
2. Key performance indicators (KPIs) such as total sales, profit margins, and quantities sold help evaluate business performance and inform strategic decisions.
3. Analyzing sales over different periods (quarters and years) enables businesses to understand seasonal trends and adjust inventory or marketing strategies accordingly.