Ashutosh Dixit Email & Phone Number

Noida, Uttar Pradesh, India

- Operations & MIS- Budgeting Preparation - Power BI and Excel Dashboard Presentation - Handling Operations process - Customer Order Management- Revenue tracking analysis - Inventory allocation and Planning - Execute orders and analysis- Order analysis and forecasting

Noida, Uttar Pradesh, India

• Handing Sales Queries Material Planning & MIS• Data Analysis (Sales Data, Stock Data, GRN Data, Back Order Data, Pending Order Data)• Coordination with Plant for material delivery and planning• Preparing Daily/Monthly/quarterly Sales Data analysis• Preparing Target Vs Achievement report of sales team• Handling backend operational structure• Coordination with purchase team for shipment delivery• Handling Internal sales backend team• Preparing presentation to the Management• Graphical analysis of past sales and current sale.• Working on SAP SD End User Module• Coordination with sales team and customers regarding queries• Follow-up with sales team for future orders and preparing report

Noida, Uttar Pradesh, India

• Stock data analysis (Stock in and Stock out Material)• Inventory Planning & Control• Prepared daily/monthly/yearly report of delivered material/undelivered material. • Prepared region wise collection and outstanding reports of all active dealers.• Communicating with the branches for sales data queries or others.• Co-ordination with the manufacturing plant for getting status of material delivery.• Prepared daily/weekly/quarterly/yearly reports as per sales team request.• Preparing monthly Sales V/s Achievement report• Preparing NQ report for tracking futures orders.• Sales backend support and handled customer queries regarding orders and material delivery.• Communicating to purchase team for material shipment delivery.

Gurugram, Haryana, India

• Handling Data of all branches.• Preparing multiple reports with the help of Ms-Excel• Communicating with the branches for collecting relevant data.• Handling problems of branches related to the project.• Queries handling through mailing.• Working on back office work like Data Management, Provide information about the project, Queries handling of branches, Response of emailing, Provide training to the new joinee.

Noida, Uttar Pradesh, India

• Preparing Weekly/Monthly MIS Report.• Handling Company Database.• Frequently use of If, Sumif, Countif, V-lookup, Conditional Formatting, Index & Match, If Error, Pivot Table, Macros etc.• Creating Dynamic Pivot and Graph for presentations.• Data entry, data handling, manipulating, cleaning & processing data using Excel.• Analyzing raw data after entry and then creating data reports & dashboards.

New Delhi Area, India

Worked on project, Analysis of data collected by the respondents in the field visit. Data handling in Advance excel tools like (Vlookup,Hlookup,Pivotable,Sumif, Countif, Data Validation, Dynamic Charts, Conditional Formatting, Data Maintaining, Data Scrutiny, Data Entry, Data coding, SPSS (Descriptive Analysis, Cross tabulation).• Data Analysis on Advance Excel & SPSS statistical tools.• Presenting the data in a clear and concise format.• Collecting primary data through interviews, questionnaires, field notes. • Maintain database for future reference.• Designed questionnaires, discussions guides, observations instruments and logs to gather meaningful feedback from respondents.• Email to the respondents for filling questionnaires and communication to the clients regarding projects.• Handling Central Database.