Overview
Work History
Timeline
Summary
Skills
Education
Software
Certification
CustomerServiceRepresentative
Shubham Sharma

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

undefined

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

MS EXCEL

POWER BI

Tableau

Microsoft Office

Workflow management system

SAP - ERP (Retail operations)

Certification

Certified Effective dashboard creator

Shubham SharmaMIS Analyst