San Francisco Bay Area
19K followers 500+ connections

Join to view profile

Articles by Sumit

See all articles

Activity

Join now to see all activity

Experience & Education

  • Notion

View Sumit’s full experience

See their title, tenure and more.

or

By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.

Licenses & Certifications

Volunteer Experience

  • Digital Media Voluteer

    Nanhikali

    - Present 9 years 11 months

    Children

Publications

  • 1-Click Marketing Blueprint Formulation using Web Mining

    International Journal of Engineering Research and Technology

    This paper proposes an idea in which a marketing application will help us to create the whole marketing blueprint using just a click. With the evolution of the world, the success of the product now not only depends on the quality of the product but also depends on how well the company is able to market their products and bring it to the masses. The day has arrived wherein the public will know about the product when it is marketed in a way that it reaches the masses and is accessible to the…

    This paper proposes an idea in which a marketing application will help us to create the whole marketing blueprint using just a click. With the evolution of the world, the success of the product now not only depends on the quality of the product but also depends on how well the company is able to market their products and bring it to the masses. The day has arrived wherein the public will know about the product when it is marketed in a way that it reaches the masses and is accessible to the targeted customer. But the issue with marketing is that we need to market research before formulating a plan and implementing it. In this system, we will create a marketing blueprint with just couple of clicks and present a proper strategy as the output which will be categorized based on the industry, budget and type of marketing(online and offline).

    Other authors
    • Parinita Bhandary
    • Nipun Shetty
    • harshali patil
    See publication

  • Semantic Web: using Microdata and Schema

    International Conference and Workshop on Advance Computing

    Other authors

Courses

  • Applied Data Science

    IST 687

  • Business Analytics

    SCM 600

  • Database Management System

    IST 659

  • Enterprise Risk Management

    IST 625

  • IT Auditing

    IST 600

  • Information System Analysis

    IST 654

  • Introduction to Information Management

    IST 621

  • Leadership and Cultural Exchange

    -

Projects

  • Data Warehousing: NOPCommerce Enterprise Data Warehouse

    ♦ Conducted ETL with SQL SSIS & MOLAP Cube Development using SQL SSAS from relational star schema and created data pipelines from source to the Enterprise Data Warehouse
    ♦ Designed dimensional model for nop-commerce database using High level dimensional modeling and detailed level dimensional modeling techniques.
    ♦ Performed the analysis of sales figure for an internally created e-commerce portal & proposed methods of increasing sales
    ♦ Visualized the data using PowerBI and Tableau…

    ♦ Conducted ETL with SQL SSIS & MOLAP Cube Development using SQL SSAS from relational star schema and created data pipelines from source to the Enterprise Data Warehouse
    ♦ Designed dimensional model for nop-commerce database using High level dimensional modeling and detailed level dimensional modeling techniques.
    ♦ Performed the analysis of sales figure for an internally created e-commerce portal & proposed methods of increasing sales
    ♦ Visualized the data using PowerBI and Tableau and presented the findings to increase and sales and e-commerce site traffic

    Other creators

  • Enterprise Risk Management - NEXIS Lab

    - Present

    ♦ Assessed the risk culture and risk infrastructure of an organization by carrying out in detailed analyses using Surveys, interviews & SWOT analysis
    ♦ Conceptualizing an enterprise risk process model by identifying different risks for the lab, Measuring those risks based on probability of occurrence and impact
    ♦ Prioritizing and categorizing different risks based on the impact and delineating possible mitigation techniques for the same

    Other creators

  • Data Analysis: U.S. Department of Agriculture

    -

    ♦ Conducted exploratory data analysis of U.S. Department of Agriculture dataset containing health and restaurant statistics in U.S.
    ♦ Performed data cleaning in R by removing inconsistencies in data such as missing values and incorrect entries
    ♦ Created visualizations (using ggplot2, chloropleth package)

    Other creators

  • Business Analytics: Recruitment Strategy and Loan Application Approval

    -

    ♦ Data Analysis using Tableau & Google Analytics. Used analytical techniques such as PowerPivot and MS Excel to visualize data patterns to strategizing cities for the recruitment tour. Applied Cost OPTIMIZATION techniques to reduce the campaigning costs by 10% by strategizing utilization of resources.
    ♦ Performed Statistical analysis on loan distribution data using Linear, Logit & Probit Regression models in R-Solver and R-Commander.
    ♦ Used sensitivity analysis in excel on the factors…

    ♦ Data Analysis using Tableau & Google Analytics. Used analytical techniques such as PowerPivot and MS Excel to visualize data patterns to strategizing cities for the recruitment tour. Applied Cost OPTIMIZATION techniques to reduce the campaigning costs by 10% by strategizing utilization of resources.
    ♦ Performed Statistical analysis on loan distribution data using Linear, Logit & Probit Regression models in R-Solver and R-Commander.
    ♦ Used sensitivity analysis in excel on the factors identified to generate patterns which would increase the probability of success of a loan application
    ♦ Performed Sensitivity Analysis, Predictive Modelling and Price Optimization using Excel (Pivot Tables, Power Pivot, Data Mining, Power View and Regression)

    Other creators

Honors & Awards

  • Best Photographer of the year

    Thakur College of Engineering and Technology

Languages

  • English

    -

  • Hindi

    -

  • Marathi

    -

Organizations

  • Nanhi Kali: Girl Child Education

    -

    - Present

  • Institute of Electrical and Electronics Engineers

    -

Recommendations received

2 people have recommended Sumit

Join now to view

More activity by Sumit

View Sumit’s full profile

  • See who you know in common
  • Get introduced
  • Contact Sumit directly
Join to view full profile

Other similar profiles

Explore top content on LinkedIn

Find curated posts and insights for relevant topics all in one place.

View top content

Others named Sumit Gupta in United States

144 others named Sumit Gupta in United States are on LinkedIn

See others named Sumit Gupta

Add new skills with these courses

See all courses