Simran Gautam Email and Phone Number

• Analyzed e-commerce sales and spending patterns using Advance Excel and SQL, leading to a 15% revenue increase and a 20% reduction in unnecessary expenditures.• Utilized Advance Excel and Power BI to create Search Query Volume reports, facilitating efficient data extraction and visualization.• Collaborated with cross-functional teams to maintain data integrity and accuracy.• Developed KPI reports using Advance Excel, SQL and Power BI to analyze sales trends, customer behavior, and campaign effectiveness, resulting in a 20% sales increase and a 15% improvement in campaign ROI.

Tracked product details and presented sales revenue reports to stakeholders.• Designed and developed data visualizations and reports using Power BI, including charts, graphs, and dashboards.• Performed data cleaning, categorization, and wrangling to extract accurate product information.• Assessed special reports to summarize information and identify trends for decision-making• Completed special projects through planning, guidance, and tracking metrics.