Applied sales forecasting techniques and strategic planning to verify sales and profitability of products, lines and services.
Collect, analyze, evaluate and report data in order to increase sales productivity.
Automated data reporting by using Oracle JDE ERP.
Collect sales records, analyzes sales and profit trends by market and customer segmentation.
Evaluates results against sales and profit targets.
Interpret results of over-all sales to identify elements of under and over performing areas.
Create management reports that depict current state and trend of sales effectiveness.
Provide product details, pricing and availability to sales team.
Follow up with customers and sales team to ensure timely receipt of all needed reports and documentation.
Analyze stock and sales reports in a timely and accurate manner; describe results to senior management and budgets.
Prepare Sales Analysis such as Budget Vs Achievement month-wise/ year-wise and report variance , if any.
Prepare product wise sales analysis and report on fast and slow-moving products.
To provide Administrative Support to sales Division which may include scheduling meetings, maintaining calendar , setting up conference calls, preparing correspondence and presentation materials etc.
Sales forecasting
Follow up on New Product Development status.
Senior MIS Executive
I B Group
Rajnandgaon, Chhattisgarh
09.2020 - 12.2021
Data analysis accordingly to the Standards of the company , and working for the daily update of the data.
Works on Workflow management system (Effort plus) for proper management and tracking of the data.
Works on daily base reports of Retail and production basis data doing analysis for consistent improvement in system.
Audit analysis on SAP , weekly database reports for better executions.
Monthly Branch Performance reports for implementations and improvement suggestions.
Determined data retention parameters based on organizational requirements.
Supervised MIS audit processes to address non-compliance and vulnerabilities.
Identified control gaps in processes, procedures and systems through in-depth research and assessment and suggested methods for improvement.
Developed and implemented corrective actions to bring business areas in line with standards.
Planned and executed all phases of audits, including data input into SAP software for analysis.
Analyzed data and findings and prepared reports for lead auditor detailing in retail and production.
Coordinated with external auditors and documented process reviews.
Produced audit reports which comprised evaluation of internal control systems.
MIS Analyst
Shivangi Foods
Bilaspur, Chhattisgarh
09.2019 - 03.2020
Pricelist creation and modification , analyzing prices of retailer , distributor's tends to MRP.
Price circular creation, Norm's formation and margin adjustment for retailer's and distributor's.
T.A and D.A Norm's and format creation, sales person expense clearance process & solutions.
Sales target & Incentive creation process , with sales per day business analysis.
FIFO management at dispatch segment with line arrangements for ease in dispatch.
Distributor's monthly stock maintenance with convincing for primary orders.
Customer support handling , issue solutions , customer relationship management.
Packing methods creation according to the market demands.
Quality assurance working for premium service and support.
Business Development Manager
American express
Gurgaon, haryana
06.2017 - 08.2019
Compiled product, market and customer data to forecast accurate sales and profit projections.
Collected data and performed customer needs analysis.
Prospected new weekly leads with diverse strategies, including cold calling, site visits and customer referrals.
Developed new business by networking with prospects and valuable customers at bulk and smart events.
Helped incorporate product changes into marketing message to drive customer engagement and firm profits.
Completed and submitted monthly and yearly reports to support executive decision making.
Worked with existing customers to increase purchases of products and services.
Generated new business with marketing initiatives and strategic plans.
Identified key products, services and customers and used data to devise innovative sales and marketing plans enabling dramatic growth.
Timeline
MIS Analyst
Suntara Cosmetics pvt ltd
12.2021 - Current
Certified Effective dashboard creator
04-2021
Certificate Advanced Excel Analyst
04-2021
Data Science With Machine Learning
Simplilearn IBM
11.2020 - Current
Senior MIS Executive
I B Group
09.2020 - 12.2021
MIS Analyst
Shivangi Foods
09.2019 - 03.2020
Business Development Manager
American express
06.2017 - 08.2019
Bachelor of Science - Mechanical Engineering
Dr C. V. Raman University
06.2014 - 05.2017
Some College (No Degree) - 12th
Mohanty Eng. School
04.2012 - 04.2013
Summary
MIS analyst with over 3 years of successful experience in Data analysis and Data management . Recognized consistently for performance excellence and contributions to success in Retail and production industry. Strengths in Advanced Excel and Deep data Analysis & creation backed by training in Data structures and MS Excel .