Prepared and Maintaining Dashboard in Microsoft POWER BI to REVIEW and TRACK performance of All Dealer Showroom chain || SM, GM || SRM || RM of NEXA and ARENA and TRUE Value Dealership.

• Preparing a Revenue Analysis Report, DSR, Weekly Review Report of Pan India Owned and Franchise Clinics.• Overall Marketing ROI & Margin % on SEM cost for different campaigns• Estimating the expected traffic on website for the forthcoming season and festival: By making projection based on past trends and geographic regions• Coordinating with MIS team: By giving the guidelines, format and structure required as per the management• Preparing Productivity Report for Incentive Structure of Pan India Clinics & Employees.• Maintaining operational & financial monthly database: Compiling all major parameters through which proper business visibility can be assured.• Preparing Call Center Report.• Taken Care of Global Leads and forwarding them to our Global Partners.

• As a member of Central Planning Team handling OTB planning and control PO raising for Men’s Business - both International and National brands.• Analyze, on an ongoing basis, SKU performance for area of responsibility; review all aspects of sales performance/trends (as it pertains to Age, style, size, color and price etc.) by stock type etc.• Preparing statistically derived Assortment plan, Sales Plan & Demand plan for the seasons at Department, Brand Brick, Price Band level and sharing the same with all stake holders like Brands, Buyers and Category Heads.• Manage inventory, open-to-buy, inventory health, item-level forecasting, assortment planning.

• Preparing Daily Revenue Analysis Report and Gross Margin Report.• E-mail count compilation Report:For calculating customer life time value of various sources of traffics and track the registered and captured e-mail ids from different sources and provide useful insight about their trend to top management.• Conducting funnel and banner analysis: By calculating various matrix e.g. CTR, CPC, RPC and CPA amongst others• Calculating revenue &expenditure incurredfrom SEM (Search engine management) on daily basis: Calculating the ROI & Margin % on SEM cost for different campaigns• Estimating the expected traffic on website for the forthcoming season and festival: By making projection based on past trends and geographic regions• Co-Ordinating with MIS team: By giving the guidelines, format and structure required as per the management• Keeping an track on different modes of payment and generating reports on daily basis : By calculating the total attempts, APC’s (awaiting payment confirmation), pending paymentsand confirmed orders• KPI Matrix - Keeping monthly KPI parameters updated and providing useful insights about any major change. • Ad hoc Reports- Creating ad-hoc reports on different parameters required by top management.