Karan Shah

Business Analyst

Mumbai, Maharashtra, India4 yrs 4 mos experience

Key Highlights

  • Reduced delivery delays by 55% with dashboard insights.
  • Built automated reports, cutting manual effort by 80%.
  • Led data efforts for retail vertical at Candere.
Stackforce AI infers this person is a Data Analyst with expertise in E-commerce analytics and data-driven decision-making.

Contact

Skills

Core Skills

Data AnalyticsBusiness Intelligence (bi)Data VisualizationData Wrangling

Other Skills

Analytical SkillsBusiness AnalysisBusiness InsightsCommunicationDashboard MetricsData AnalysisData EngineeringData ManipulationData ScienceData StructuresData ValidationData WarehousingDatabasesEngineeringExcel

About

Hi! I’m Karan, a Data Analyst with a passion for turning numbers into stories that help businesses grow smarter. Over the past few years, I’ve worked with e-commerce brands like Tyaani and Candere, where I’ve helped teams understand what’s really happening behind the scenes whether it’s optimizing inventory, figuring out what’s driving high-value purchases, or helping marketing teams connect better with customers. I enjoy digging into SQL, Python, and dashboards (Looker Studio is a favourite!) to build things that actually get used not just pretty charts, but tools that simplify decisions and save hours of manual work. One of my dashboards even helped reduce delivery delays by 55% that was a good day! What drives me is seeing data make an impact when a report I build helps a manager fix a bottleneck, or when we spot a customer trend no one saw coming. That’s the sweet spot. I'm always open to learning, collaborating, and exploring new challenges in analytics, especially in product, marketing, or operations roles. Let’s connect happy to chat data, dashboards, or even jewellery trends over a coffee!

Experience

Hansa cequity

Senior Data Analyst

Aug 2025Present · 7 mos · Mumbai, Maharashtra, India · On-site

Tyaani jewellery by karan johar

Senior Data Analyst Executive

Oct 2024Jul 2025 · 9 mos · Mumbai, Maharashtra, India · On-site

  • As a Senior Data Analyst at Tyaani (a luxury jewellery brand by Karan Johar), I help the team make faster, data-backed decisions across inventory, sales, and customer engagement.
  • 🔹 Built automated reports to track weekly sales and inventory trends, reducing manual effort by 80%
  • 🔹 Created regional performance dashboards to help marketing and operations teams identify buying trends and regional variations
  • 🔹 Analysed high-ticket item performance to uncover pricing and conversion insights, improving average transaction value
  • 🔹 Collaborated with merchandising, warehouse, and retail teams to optimize stock movement and improve inventory turnover at each store
  • 🔹 Tech stack: SQL, Python, Excel, Looker Studio, Gati (ERP Software)
Data EngineeringMicrosoft SQL ServerProduct ManagementData AnalyticsData AnalysisAnalytical Skills+7

Candere by kalyan jewellers

3 roles

Data Analyst - Lead Floor Vertical

Promoted

Apr 2023Sep 2024 · 1 yr 5 mos · On-site

  • At Candere, I led data efforts for the retail vertical, enabling better decision-making through real-time dashboards, automation, and cross-functional reporting.
  • 🔹 Developed dashboards for the Product team to help identify emerging product trends and performance gaps
  • 🔹 Rebuilt and validated large datasets using SQL and Python, ensuring clean and reliable data for all reporting use cases
  • 🔹 Built a unified performance dashboard for non-technical teams, reducing reliance on ad hoc reports
  • 🔹 Trained new analysts on tools, best practices, and data visualization techniques
  • 🔹 Collaborated with Operations, Product, Marketing, Sales, and Tech teams on key cross-functional projects
  • 🔹 Tech stack: SQL, Python, Jupyter, GCP, Postman
ManagementData VisualizationPython (Programming Language)Data EngineeringMicrosoft SQL ServerData Wrangling+26

Jr. Data Analyst

Apr 2022Mar 2023 · 11 mos · On-site

  • I began my full-time journey at Candere by taking ownership of foundational data tasks that directly supported business and automation teams. This role helped me build confidence with SQL, reporting tools, and cross-functional communication, laying the groundwork for the senior analytics responsibilities I would take on later.
  • 🔹 Collaborated with business and marketing teams to understand data requirements and translate them into structured reports
  • 🔹 Designed and documented early-stage data models that were later used to automate communication workflows
  • 🔹 Developed SQL queries and Excel reports for weekly updates on product performance and inventory health
  • 🔹 Worked closely with the automation team to gather requirements and build logic for triggers and broadcast campaigns
  • 🔹 Built the first iteration of performance dashboards for non-technical teams — simplifying reporting across functions
  • Tools: SQL, Excel, Google BigQuery, Looker Studio, Postman
Data VisualizationPython (Programming Language)Data EngineeringMicrosoft SQL ServerData WranglingData Analytics+20

Intern

Aug 2021Mar 2022 · 7 mos · On-site

  • As an intern, I was introduced to real-world data in a fast-moving e-commerce environment. I worked alongside senior analysts, supporting them in data cleaning, reporting, and basic analytics. It was the role that sparked my passion for turning data into actionable insights.
  • 🔹 Assisted in cleaning and organizing raw sales and product data for analysis
  • 🔹 Conducted QA on data pipelines and dashboard outputs to ensure accuracy
  • 🔹 Documented internal data processes and learned the fundamentals of automation logic
  • 🔹 Supported senior analysts in exploring tools like WebEngage, Google Analytics, Nosto and Klevu
  • 🔹 Built basic visualizations and presented weekly learnings to the analytics team
Microsoft SQL ServerData WranglingData AnalyticsData AnalysisData WarehousingProblem Solving+14

Powerflex industries

Engineering Trainee

Jan 2021Jun 2021 · 5 mos · Goregaon, Maharashtra, India

  • As an engineering trainee at Powerflex Industries, I had the opportunity to work on streamlining inventory systems for hydraulic hose assemblies and fittings. This hands-on role gave me valuable exposure to inventory planning, warehouse operations, and data-backed decision-making.
  • 🔹Studied existing inventory flow and identified key gaps in part traceability and stock accuracy.
  • 🔹Applied FIFO principles, which helped reduce rejections in plated fittings by over 5%.
  • 🔹Conducted ABC and FSN analysis on critical components to prioritize stocking and reordering schedules.
  • 🔹Suggested layout improvements and implemented part tagging to reduce retrieval time and minimize picking errors.
  • 🔹Used EOQ-based logic to recommend more efficient purchasing cycles and control excess stock.
  • 🔹Supported monthly audits and ERP reconciliation to improve reporting accuracy and reduce manual mismatches.
  • 🔹Gained practical exposure to production-floor processes like skiving, crimping, and hose assembly.
Pivot TablesMicrosoft Excel

Djs cycloid

Production Manager

Jun 2020Feb 2021 · 8 mos · Mumbai, Maharashtra, India · On-site

  • As Production Manager of Team DJS Cycloid, I led the manufacturing efforts for our human-powered trike that competed in the ASME Human Powered Vehicle Challenge (HPVC) 2019, hosted at Marwadi University, Rajkot. This international competition challenged student teams to design, build, and race sustainable, safe, and efficient pedal-powered vehicles under real-world constraints.
  • 🔹Oversaw fabrication of a recumbent trike using tubular steel framing, precision drivetrain assembly, and Ackermann-style steering geometry
  • 🔹Coordinated cross-functional teams across design, aerodynamics, and safety to ensure compliance with ASME engineering standards
  • 🔹Managed workshop execution, material procurement, and daily production schedules under tight deadlines
  • 🔹Introduced quality checks and supervised load and dry-run testing to ensure readiness before race day
  • 🔹Gained practical insight into end-to-end engineering execution, teamwork, and decision-making under competitive pressure
  • 🔹Though we didn’t place in the top ranks, our participation alongside top institutions in a global ASME event was a milestone and a turning point in how I approached structured problem-solving and execution.
Pivot TablesMicrosoft Excel

Khar diesel loco shed

Intern

Dec 2017Dec 2017 · 0 mo · Khar Road (East)

Education

Dwarkadas J. Sanghvi College of Engineering

Bachelor's degree — Production engineering

Jan 2018Jan 2021

Agnel Technical College (Polytechnic)

Diploma — Production Engineering

Jan 2015Jan 2018

St. Anne's High School

SSC

Jan 2015Present

Stackforce found 100+ more professionals with Data Analytics & Business Intelligence (bi)

Explore similar profiles based on matching skills and experience