Portfolio - Rama Gopala Krishna Masani

1

Excel
Project

3

PowerBI
Projects

About

I'm a data analyst passionate about transforming complex information into clear, actionable insights. With a keen eye for detail and a drive for continuous learning, I leverage my expertise in Excel, Power BI, SQL, Python, and Machine Learning to solve data challenges and support informed decision-making.

My experience includes:

➜ Completing a 1-year internship at KSR Datavizon, where I worked on real-world data projects across domains.
➜ Crafting compelling dashboards using Power BI to bring data to life and drive user engagement.
➜ Ensuring data quality through meticulous cleaning techniques like standardization, handling missing values, and deduplication.
➜ Extracting and analyzing data with precision using SQL and advanced querying methods.
➜ Applying machine learning algorithms to uncover patterns, make predictions, and enhance business insights.

I'm constantly expanding my skillset, focusing on data visualization best practices and effective stakeholder communication to ensure

Key

Skills

EXCEL

Power BI

SQL,

Python,

Machine Learning

Problem-Solving

Communication

Attention to Detail

Analytical Thinking

My

Projects

Business Insights 360

Domain/Function: Finance | Sales | Marketing | Supply Chain | Executive

I created a Power BI dashboard called Business Insights 360 for AtliQ Hardware, a company that sells computer hardware. The dashboard helps them to understand their financial, sales, marketing, supply chain, and executive performance. It also shows them how accurate their predictions are and where

AtliQ IQ Insights: Hospitality Analysis

Domain/Function: AtliQ IQ Insights: Hospitality Analysis

Revive Insights 360 for AtliQ Hospitality Analysis: a Power BI project revealing weekly hotel performance metrics, occupancy trends, room distribution, and KPI cards tailored for executive-level decision-makers.

Sales and Finance Analytics

Domain/Function: Sales and Finance Analytics

AtliQ Sales and Finance Analytics Reports showcases my exploration into customer and market performance, financial health, and strategic decision-making. Leveraged ETL methodologies, Power Query, Power Pivot, and DAX to craft impactful reports.

Zomato Business Intelligence Dashboard

Domain/Function: Business Intelligence / Data Analysis

Designed an interactive Business Intelligence dashboard for Zomato to analyze sales, ratings, order volume, and city-wise performance. Provided clear insights into food category trends and yearly growth using visual storytelling techniques.

My

Experience

Data Analyst Intern

KSR Datavizon | Nov 2023 – Nov 2024

Built and published interactive Power BI dashboards to track KPIs and support data-driven decisions.
Led end-to-end data projects involving data collection, cleaning, modeling, and insights delivery.
Improved data quality through standardization, imputation, and transformation techniques.
Automated analysis using Python, SQL, and Excel, reducing manual effort by 30%.
Developed machine learning models (Linear Regression, Logistic Regression, K-means) for forecasting and classification.
Conducted exploratory data analysis (EDA) to identify trends, outliers, and actionable business insights.