Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic

ANKIT SINGH

Associate Business Analyst
Bengaluru

Summary

Results-driven Business Analyst with more than 2 years of experience in data science and analytics. Proven ability to use data to drive business decisions and improve processes. Skilled in statistical analysis, data visualization, and data mining. Proficient in various data tools and programming languages including Python, SQL, and Excel. Strong problem-solving skills and the ability to communicate complex data insights to non-technical stakeholders.

Overview

4
4
years of professional experience
3
3
years of post-secondary education
4
4
Certifications

Work History

Business Analyst

Data Labs - Landmark Group
04.2022 - Current
  • Part of In-Season Planning Analytics team responsible for price optimization, inventory management, order recommendations, consolidation, and other merchandising-related analytics projects.
  • Developed and implemented advanced Markdown solution using elasticity curve models based on sell-through data to optimize price recommendations, generating incremental revenue of over $11 million. Automated KPI calculation and compliance using SQL and Databricks.
  • Conducted in-depth data analysis and utilized statistical and machine learning techniques to enhance profitability, inventory management, and pricing decisions.
  • Conducted inventory analysis to reduce cover, identifying overbought departments, ineffective lifespans, and stores contributing to increased covers over last six seasons.
  • Led external audit process encompassing review of pricing recommendations, alignment with planning team utilization, price roll-up, and implementation at store level.
  • Designed concept-level dashboard featuring year-over-year and week-over-week product performance comparisons, summarizing sell-through, markdowns, margins, revenue, costs, and key merchandising variables.
  • Supported product team in developing automated web application for markdown management, serving as primary point of contact for ensuring data accuracy, application efficiency, and stakeholder communication.

Data Analyst Intern

Pioneer Management Consultant PVT LTD.
07.2020 - 09.2020
  • Market Research Intern for "Her Career Foundation," contributing to "Her Career - from Break to Restart" survey. Conducted secondary research, engaged participants, and utilized tools like pivot tables, Tableau, and Python's Dash for data analysis and infographic creation. Compiled findings into actionable documentation for project stakeholders.

Education

PGP Data Science -

Praxis Business School
Kolkata
06.2021 - 05.2022

MBA (Business Analytics & Marketing) -

Mittal School of Business - LPU
Jallandhar - Punjab
06.2019 - 04.2021

Skills

    - Language: SQL, Python and Pyspark

    - Technologies/Frameworks : Azure Databricks, SAS EG, JupyterHub

    - Data Science: Statistics, Machine Learning

    - Visualization Tools: Power BI, Tableau, Excel, Power Point

    - Project Management

    - Stakeholder Management

    - User Acceptance Testing

    - Requirements Gathering

    - Project Management

    - Internal Auditing

Projects

  • Markdown
  • Consolidation
  • E- com Recommender System
  • Buying Reference Book

Certification

Data Science Course (Board Infinity): 150 + Data Science Tools & Skills Covered: - Excel, Tableau, SQL, Python, Numpy, Pandas, Power BI, Matplotlib, Machine Learning algorithm, Linear regression, Logistic Regression and Statistics, 2021

Timeline

Business Analyst

Data Labs - Landmark Group
04.2022 - Current

PGP Data Science -

Praxis Business School
06.2021 - 05.2022

Data Analyst Intern

Pioneer Management Consultant PVT LTD.
07.2020 - 09.2020

MBA (Business Analytics & Marketing) -

Mittal School of Business - LPU
06.2019 - 04.2021

Similar Profiles

CREATE PROFILE
ANKIT SINGHAssociate Business Analyst