Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ipsita Mallick

Faridabad

Summary

Experienced leader in data analytics, skilled in driving efficiency through automation, reporting, and dashboard development. Led teams to optimize procurement, supply chain, and client management for global retailers, delivering significant cost savings and improved performance. Proficient in SQL, Power BI, Python with a strong focus on turning data into actionable insights to enhance decision-making and operational effectiveness.

Overview

5
5
years of professional experience

Work History

Lead Data Analyst

Unicommerce
05.2024 - Current
  • Lead a team of 7 analysts supporting internal as well as client teams across Unicommerce
  • Built dashboards to tracks SOIs, display monthly projections, highlight dips and lows to address potentials complexities
  • Designed dashboards to monitor unprocessed orders and inactive channels for our clients to minimize operational disruptions
  • Developed a revenue projection model based on projected SOIs with 98% accuracy improving financial decision-making, inventory management and operational efficiency
  • Designed reports to track metrics like SLA breaches, unfulfilled orders, and O2S for enhanced operational visibility, while also automating KRAs for Operations teams to provide periodic updates that keep team members focused on their goals.
  • Built an app on AppSheet to track client status, account health, POC details, go-live dates, and other key metrics like category, support model, inventory sync model, streamlining client management and improving operational efficiency

Senior Data Analyst

Mu Sigma
10.2019 - 05.2024
  • Lead a team of 6 analysts in transforming the procurement and supply chain functions of one of the world’s largest retailer
  • Lead the project in handling multiple bid management retail events and auctions end to end from planning stage to award stage enabling reduction in event turnaround time and increased volume of events (64% Increase in events and 282 days saved from FY21 to FY22) and optimizing the overall sourcing & procurement process Software - Coupa, Tools - Excel, Power BI, R
  • Developed an automated tool to scout potential suppliers for an event. It helped in potential cost savings and stakeholder’s time savings by eliminating the need for manual scouting of suppliers Tools - Python, Excel, ML
  • Designed an interactive dashboard providing weekly trends and insights on the sales, YoY and showcasing the performance of the products placed on different locations for the Business Category Managers of the 2nd largest Australian retailer Tools - Power BI, Excel, VBA, Python

Education

B.Tech - Electrical Engineering

Odisha University of Technology And Research
Bhubaneswar
04-2019

Skills

  • SQL expertise
  • Redash
  • MS Excel, VBA
  • Power BI
  • Python
  • ML (Collaborative Filtering, Market Basket Analysis)
  • Project Leadership
  • R programming
  • Web scraping

Timeline

Lead Data Analyst

Unicommerce
05.2024 - Current

Senior Data Analyst

Mu Sigma
10.2019 - 05.2024

B.Tech - Electrical Engineering

Odisha University of Technology And Research

Similar Profiles

CREATE PROFILE
Ipsita Mallick