Shubham Garg

Student Consultant at Carlson Analytics Lab
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Information Services
    • 1 - 100 Employee
    • Student Consultant
      • Jan 2023 - Present

      · Conceptualize a marketing mix modeling approach for a leading retail client to get monthly readouts, results to be used for reporting ROI on marketing investment at 4 different levels of granularity and future marketing planning · Tackle high dimensionality with 20 product categories and 14 channels, also modeling halo effects among categories · Conceptualize a marketing mix modeling approach for a leading retail client to get monthly readouts, results to be used for reporting ROI on marketing investment at 4 different levels of granularity and future marketing planning · Tackle high dimensionality with 20 product categories and 14 channels, also modeling halo effects among categories

    • United States
    • Software Development
    • 700 & Above Employee
    • Senior Associate
      • Jul 2021 - May 2022

      · Served as lead developer in teams of 4 to 14 members for conceptualizing data warehouses and reporting dashboards. · Built reporting dashboards for 3 pharmaceutical clients to show KPIs such as sales, number of rep calls, etc. to improve performance tracking of newly launched products, bringing $50K+ revenue for each client. · Designed and implemented 200 ETL pipelines to extract and consolidate information from various data sources and create a single source of truth, reducing dashboard development time by 50%. · Engineered unit tests for each data pipeline to ensure accuracy in reported values, enhancing process quality to 98%. · Established extensive documentation and implemented codes with 100% quality scores to enhance quality, explain functionality, and improve readability of code, simplifying resource transitions and future modifications.

    • 1 - 100 Employee
    • Business Technology Solutions Associate Consultant
      • Jan 2021 - Jul 2021

      · Led reporting operations and change requests for client reports, used to measure brand performance across various parameters such as geography, targeting, and market access, generating $300K revenue per year.· Planned weekly and monthly data load and refresh processes of 150 deliverables to assist clients in deriving sales insights and taking timely business decisions, reducing overall delay in deliverables to less than 1%.· Constructed a thorough QC and review process for all operational reports to maintain >95% accuracy.· Negotiated time and resource estimates for new development activity requested by client.· Mediated regular weekly and ad-hoc client connects focused on operations tracking and addressing client concerns.

    • Business Technology Analyst
      • Jul 2018 - Dec 2020

      · Designed and programmed automation processes for 150+ reports to assess brand sales using metrics such as market attainment, growth vs. previous years and growth vs. competitors, etc.· Set up ETL process using advanced SQL queries and Informatica mappings to integrate and analyze raw data from 15 different data sources and update reports, used in deriving sales insights and making business decisions. · Implemented 100+ change requests in existing reports to reflect updates in business scenarios and ensure smooth transition to production system after completion of code amendments.· Constructed a daily planning process to help distribute development and operations tasks among team members.

    • India
    • IT System Custom Software Development
    • 1 - 100 Employee
    • System Engineer Intern
      • Jan 2018 - May 2018

      - Learnt basics of various skills and technologies like Java, Python, SQL, HTML. - Application of skills learnt to create a Java tool used to verify accuracy of codes submitted as assignments by students. - Learnt basics of various skills and technologies like Java, Python, SQL, HTML. - Application of skills learnt to create a Java tool used to verify accuracy of codes submitted as assignments by students.

Education

  • University of Minnesota - Carlson School of Management
    Masters, Business Analytics
    2022 - 2023
  • UIET Panjab University
    Bachelor's degree, Information Technology
    2014 - 2018

Community

You need to have a working account to view this content. Click here to join now