MS EXCEL
Shubham Sharma
MIS Analyst
Ahmedabad,Chhattisgarh
Overview
2
2
Certificates
4
4
years of professional experience
5
5
years of post-secondary education
Work History
MIS Analyst
Suntara Cosmetics pvt ltd
Ahmedabad, Gujrat
12.2021 - Current
- 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.
- S.I.T.A Simulation . (SALES , INCENTIVES , TARGET ACHIEVEMENT).
- D.S.R (Daily sales report sales person wise, zone wise, Team wise analysis).
- Distributor's datasheets file maintenance , Distributor appointment form and distributor's agreement creation.
- Workflow management software handling (FIELD ASSIST).
- Dispatch process system creation
- 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 .
Skills
Microsoft Excel expertise
Advanced MS Excel knowledge
POWER BI
Tableau
Quality improvement dashboards
Data management
Analytical skills
Computer proficiency
Education
Bachelor of Science - Mechanical Engineering
Dr C. V. Raman University
Kota , Chhattisgarh 06.2014 - 05.2017
Data Science With Machine Learning
Simplilearn IBM
11.2020 - Current
Some College (No Degree) - 12th
Mohanty Eng. School
Bilaspur, CG 04.2012 - 04.2013
Software
POWER BI
Tableau
Microsoft Office
Workflow management system
SAP - ERP (Retail operations)
Certification
Certified Effective dashboard creator