POOJA RAO

• Aspiring Data Analyst with a strong foundation in data visualization, data analysis, and logistics.
• Proficient in Python, SQL, Power BI, and Excel (including Advanced Excel) with hands-on experience gained through internships in data analytics.
• Skilled in transforming raw data into meaningful insights to enhance operational efficiency and support data-drive.
• A dedicated team player with a keen eye for detail, problem-solving abilities, and a passion for uncovering trends and patterns in data. Strong background in business intelligence and reporting, combined with a structured approach to analytical problem-solving.
• Committed to leveraging data to drive business growth, improve decision-making, and optimize processes.

1. Credit card transaction: SQL, data analysis, and transformation

Used advanced SQL and built SQL queries using sub-queries, CTEs, and window functions to solve complex business questions, recognize patterns, and understand customer segments and behavior.

2. ADVENTURE SALES ANALYSIS [PYTHON]

Built an exploratory data analysis on sales data, identifying trends and patterns over time

Analyzed product performance and customer segmentation to identify top revenue drivers

Visualized and compared sales across different regions to determine high-performing areas, and recommended strategies for future forecasting and segmentations.

3. US crime data analysis

Data cleaning: Clean and preprocess the crime dataset using advanced Excel tools, like filters, text-to-columns, and conditional formatting, to ensure accuracy

Pivot Table - Use Pivot Tables to summarize crime data, analyze trends by location, time, or type, and create dynamic data views for in-depth insights

Advance Formulas - Apply formulas like VLOOKUP, INDEX-MATCH, and IF statements to manipulate data, calculate metrics, and derive key statistics

Data visualization: Create compelling visualizations using charts and conditional formatting to represent crime trends and patterns effectively.

4. SMART BAZAR SALES DASHBOARD [POWER BI]

Developed an interactive sales dashboard using Power BI

Analyzed sales trends, customer behavior, and product performance

Create dynamic data visualizations and reports for decision-making

Integrated multiple data sources for real-time sales insights

Improved business performance by identifying key sales metrics and patterns.

5. Ecommerce Database Systems

Creating tables for customers, products, orders, order details, and categories

Implemented JOINS, GROUP BY, ORDER BY, FILTERS, and aggregation functions

The database has details about every order and registration

• Data Analytics Master Programming, Besant Technology
• Data Analytics, Analyst Builder