shaibaz banu
Data Analyst
About
Data Analyst with 7+ years of experience in operations, Merchandising and data analysis. Skilled in SQL, Excel, and Power BI. Turns raw data into clear business insights, builds dashboards, automates reports, and helps teams make better decisions. Experienced in ETL processes, data cleaning, and working with different teams across an organization.
Skills & Expertise (27)
Work Experience
Data Analyst (Shopsy)
Flipkart Pvt. Ltd
Jan 2025 - May 2026
Analyzed large datasets using SQL, Excel, and Power BI to track KPIs, identify business trends, and support data-driven decisions. Built and maintained interactive Power BI dashboards and reports to monitor sales, conversion rate, traffic, category performance, and year-over-year/event-level comparisons. Developed Power Query workflows for data cleaning, validation, transformation, merging, and reconciliation across multiple data sources. Created and maintained Power BI data models, relationships, datasets, DAX measures and reports, with focus on accuracy and performance optimization. Automated daily and weekly reporting using Power Query, Excel, and Google Sheets, including automated sales trackers that provided timely visibility to senior management. Wrote and optimized SQL queries using JOINs, CTEs, subqueries, window functions, aggregations, and analytical functions for data extraction and reporting. Worked with Power BI Service, workspaces, scheduled refresh, gateways, report publishing, and RLS, while providing actionable insights to improve business efficiency and revenue.
Senior Operations Executive – Grocery
Flipkart Pvt. Ltd
Sep 2023 - Dec 2024
Managed end-to-end e-commerce merchandising activities, including content creation, campaign setup, ad groups, scheduling, and promotional activities for grocery categories. Extracted and analyzed business data from SQL Server to prepare performance reports, trackers, and insights for merchandising and business teams. Developed interactive Power BI reports and dashboards using visualizations, data modeling, and DAX measures to monitor sales and business performance. Performed competitive benchmarking by comparing product prices, offers, discounts, and other business metrics with data from competitor websites to identify market trends and opportunities. Automated recurring reports for ADS Data using Google Sheets, while using Excel, SQL, and Power BI to analyze KPIs and support data-driven merchandising decisions.
Senior Operations Executive – ClearTrip
Flipkart Pvt. Ltd
Jun 2022 - Feb 2023
Managed end-to-end travel merchandising operations for airline and promotional campaigns, including content creation, ad groups, campaign setup, and scheduling within allotted slots and timelines. Extracted and analyzed business data using Excel and internal tools to create performance trackers and dashboards for airline, bank, discount, and promotional offers. Developed Excel dashboards and MIS reports using Pivot Tables, VLOOKUP, SUMIF/SUMIFS, conditional formatting, and other Excel functions to monitor campaign and business performance. Performed benchmarking and competitor/airline comparisons by analyzing fares, offers, discounts, and other performance metrics to support merchandising decisions. Managed and monitored multiple campaigns and promotional activities, ensuring accurate content, timely scheduling, and adherence to business requirements.
Operations Executive
UrbanPro Company
Dec 2018 - Jun 2022
Managed daily operations for an EdTech platform offering Home Tuition, Teacher Home, and Institution-based learning services from LKG to NEET/PG. Handled daily student/trainer calls and escalations, supporting issue resolution and maintaining service quality. Prepared Excel-based MIS reports and trackers for student, trainer, and operational information. Used Pivot Tables, SUMIF/SUMIFS, Excel formulas, conditional formatting, and data validation for data analysis and management reporting.
Education
Bachelor of Science in Computer Science - S.K. University
2007 - 2010 · India
Board of Intermediate – MPC - Andhra Pradesh
2005 - 2007 · India
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (27)
Click a skill to find developers with the same skill
