Ankita Shah

Strategic Data Analyst and BI Lead with 3+ years of hands-on experience delivering end-to-end analytics solutions across E-commerce and Retail. Expert in SQL, Power BI, Python, and Statistical Methods — translating large, complex datasets into actionable business intelligence. Consistent track record of improving operational efficiency and profitability through data-driven decision-making. Seeking to leverage deep analytical expertise to solve complex challenges in Consulting or Finance.

BI Developer at CodersCode (2023-08 – 2024-01)

• Designed and implemented scalable Power BI data models using DAX and M Query for high-volume food delivery data, improving query performance by 30%.
• Managed end-to-end data pipelines — importing, cleaning, and validating large CSV datasets — to ensure accuracy for real-time operational tracking.
• Delivered actionable insights on cost-per-order and restaurant performance to stakeholders, directly informing pricing strategies and boosting operational efficiency.
• Optimized data retrieval by authoring complex SQL queries (joins, subqueries, aggregations, GROUP BY / HAVING) to support ad-hoc analysis and dashboard development.

Data Analysis Project at IPSR Solutions Ltd. (2022-11 – 2023-02)

Certification Capstone

• Applied Statistical Modeling in Python (SciPy) to analyze company sales data and built a predictive model for customer return rates.
• Conducted rigorous Exploratory Data Analysis (EDA) on a 100K+ record dataset — cleaning data and addressing outliers to ensure modeling integrity.
• Visualized key findings in Tableau, presenting clear, data-backed recommendations on inventory management and category strategy.

Business & Pricing Analyst at Mebelkart.com (2016-01 – 2016-08)

• Analyzed product costs and competitor pricing to determine optimal selling price points, improving margin performance.
• Delivered insights on product popularity and emerging trends to support assortment planning decisions.
• Authored business requirement documents to drive site functionality improvements, working crossfunctionally in an Agile environment.

Business & Category Analyst at Eatlo App (2015-04 – 2016-01)

• Conducted cost analysis and redesigned operational processes to improve efficiency and reduce waste.
• Analyzed customer demographics and preferences to identify and validate new market opportunities.
• Developed sales forecasts and supported strategic marketing initiatives; managed vendor relationships and quality control for order placements.

Certification in Data Analysis – IPSR Solutions Ltd. (2022-11 – 2023-02)

MBA in Business Administration – Visvesvaraya Technology University (2012-09 – 2014-08)

BBA in Business Administration – Veer Narmad South Gujarat University (2005-08 – 2008-03)