Based on Raw data prepare reports from various sources and brand wise
Create and maintain daily sales, and purchases, for that includes month to date and year to date wise.
prepare Various types of reports, for market Product pricing, comparison between different brands.
Country-wise sales report preparation
Sending monthly reports Brand-wise Gross Profit Report, Regional Sales Report, Sales Return Report, and Target vs. Sales Report.
Consolidate all the daily reports and create a PPT presentation for the monthly and quarterly business review.
Responsible for sales reporting and forecasting process by Channels, Customers
Must be Hands experience in Advanced Excel, VLOOKUP, H-Lookup, Pivots, Dashboards, Conditional Formatting etc.
Making MIS Reports of collated data
Meticulously working on the data collated from various sources of department and preparing comprehensive reports.
Ensuring the precision of the reports Preparing Delivery Files
Extensive work on Excel and must be good in preparing MIS Report
Perform data analysis for generating reports on a periodic basis Provide strong reporting and analytical information support.
Knowledge of various MIS reporting tools
Interpreting data, analyzing results using statistical techniques
Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality.
Acquiring data from primary or secondary data sources and maintaining databases
Identify, analyze, and interpret trends or patterns in complex data sets.
Filter and clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
Work with management to prioritize business and information needs.
Desired Candidate Profile
Advanced Excel , Well versed in Excel Formulas , Pivots, Dashboards, MS Word
Min. – Max Planning of stocks to ensue stock availability
Managing comprehensive database of SKUs includes details lead times, demand pattern and supplier information
Identifying Slow Moving/Fast Moving and P category .
Automation Buying Cycle
Utilizing data analytical tool to generate report and dashboards that provides details for SKU performance, inventory turnover and buying cycle efficiency .
