Taruna Taneja

Taruna Taneja

Business Intelligence Analyst · Sun and Sand Sports Gulf Marketing Group

Dubai, DU

In My Own Words

Business analyst who helps organizations
gain higher visibility over their data to help
support business decisions.

Specialties include:

- Data modeling;
- Data wrangling;
- Dashboard/report design & development;
- Data visualization;
- Automation;
- Process improvement;
- Project management.

Work Experience

Business Intelligence Analyst

Sun and Sand Sports Gulf Marketing Group

2019 – Present

United Arab Emirates - Analyzing store sales performance by breaking it down into category and brands. - Tracking and reporting key KPI's-Footfall, conversion, ATV and UPT. - Analyzing effectiveness of the operation by breaking it down in GMROI and GMROM - Successfully managed to point out the loss making stores and collaboratively worked with the operations and the finance team to take corrective actions. - Liaising with the merchandise and the planning team and helping them to analyze OTB plans vs receipts vs sell through. - Created a category dashboard for the category managers and the planners where they can view the performance of an article by the hierarchy, season and style. - Preparation of Ad-hoc reports like budget utilization, Inventory and business performance including cash-flow and P&L Statement.

Business Analyst

Direct Distribution

2017 – 2019

United Arab Emirates

- Devised brand Net Realization Value NRV report and end of the month sales estimation report.

Steered Product Demand Simulation, Auto Replenishment and Stock - Optimization. - Responsible for product range plan management and product negotiation. - Tracked rebate performance, ageing models, Regional productivity and performance, brand performance, trade marketing performance and target setting. - Strategic Pilot studies and implementation. - Designed Incentive template calculated every month for Regional managers, supervisors and sales team.

MIS Analyst

Life Health Care Group

2016 – 2017

United Arab Emirates - Publishing accurate and timely MIS inclusive of monthly, quarterly and annual reports that compare actual results to forecasts and budget. - Tracking of the stock custodianship and inventory management system. - Other supporting reports such as Revenue per sq. ft. for all stores, Category wise, Brand wise, supplier wise reports, as and when required or requested by the management.

- Analyse current and past trends in key performance indicators including all areas of revenue, cost of sales, expenses and Inventory.

Business Analyst - Merchandise Planning

Target corporation

2015 – 2015

- Maintain in stock goals through effective product distribution. - Analyze sales history and trends to maximize sales potential by developing

allocation strategies - Manage inventory to achieve department in stock goals by working with Minneapolis team to achieve turnover goals. - Liaise with Minneapolis team to deliver on sales, turnover, profit goals and also understand sales and markdown trends.

Education

MBA

Institute of Management Accountants

MBA

Pune University

2013 – 2015

SENIOR SECONDARY

2010 – 2013

Industries

FashionLifestyleYogaHealth & Fitness