Rama Devi

Data Analyst

Hyderabad, India 3+ yrs exp 91 · Outstanding

About

Data Analyst with 2+ years of experience transforming sales, inventory, and operational data into actionable business insights using SQL, Python, and Power BI. Experienced in SQL-based analysis, KPI reporting, data cleaning, EDA, star-schema modeling, DAX calculations, and interactive dashboard development. Hands-on experience analyzing large datasets, including 10M+ records in BigQuery and 500K+ records for Power BI reporting. Skilled in identifying revenue, product, inventory, and regional trends to support data-driven business decisions.

Skills & Expertise (25)

Git Advanced

8.0/10

Years Exp

VS Code Advanced

8.0/10

Years Exp

Jupyter Notebook Advanced

8.0/10

Years Exp

Google BigQuery Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Joins Advanced

8.0/10

Years Exp

Aggregations Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Dashboard Development Advanced

8.0/10

Years Exp

Python Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Exploratory data analysis Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Business Insights Intermediate

7.5/10

Years Exp

Data Validation Intermediate

7.5/10

Years Exp

KPI Analysis Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

Query Optimization Intermediate

7.0/10

Years Exp

Star Schema Intermediate

7.0/10

Years Exp

Window Functions Intermediate

7.0/10

Years Exp

Postgresql Intermediate

7.0/10

Years Exp

Databricks Lakehouse Intermediate

7.0/10

Years Exp

Databricks Intermediate

7.0/10

Years Exp

PySpark Intermediate

7.0/10

Years Exp

Delta Lake Intermediate

7.0/10

Years Exp

Work Experience

Analyst

AUROPRO Soft Systems Pvt Ltd

Apr 2024 - Present

Analyzed sales, inventory, and operational data using SQL and Python to identify revenue trends, top-performing products, store performance, and demand patterns. Developed and optimized SQL queries to analyze business data and track key retail KPIs including sales, Average Order Value (AOV), and inventory turnover. Performed data cleaning, validation, and analysis to identify stock-outs, overstock, slow-moving inventory, and data-quality issues. Designed star-schema data models using sales fact tables and product, store, and date dimensions to support structured and scalable analytical reporting. Built interactive Power BI dashboards for sales and inventory monitoring, enabling business users to track KPIs, product performance, store trends, and inventory movement. Worked with POS and large-scale datasets across Databricks and Google BigQuery to support centralized reporting and analytical requirements. Delivered actionable insights on demand trends, product performance, inventory behavior, and store optimization to support data-driven business decisions.

Customer Support Associate

Tech Mahindra

Apr 2023 - Nov 2023

Performed customer data validation and document verification while maintaining data accuracy and compliance standards. Resolved customer queries and supported efficient workflow management within defined operational processes.