Summary
Overview
Work History
Education
Skills
Consulting Projects
Leadership Experience
Timeline
Generic
Kartik Singh Gautam

Kartik Singh Gautam

Glasgow,GLG

Summary

Results-driven Data Scientist & Business Analyst with expertise in SQL, Python, R, A/B Testing, and Data Visualization (Power BI, Tableau). Experienced in consulting, process optimization, and predictive analytics. Passionate about leveraging data science methodologies to solve business challenges and optimize decision-making.

Overview

4
4
years of professional experience

Work History

Analyst Intern

Virtue Analytics
08.2024 - Current
  • Created 5+ RFPs for U.S Universities, covering student enrollment management, net price calculators, and traffic systems, ensuring 100% on-time submissions
  • Researched 50+ university RFPs, analyzing requirements to tailor proposals, leading to a 30% increase in proposal relevance
  • Collaborated with cross-functional teams to integrate data-driven insights, improving proposal quality and contract acquisition potential
  • Streamlined the proposal process, reducing RFP turnaround time by 25%, enhancing efficiency and submission rates.
  • Identified gaps and recommended enhancements for new tool development, improving functionality, UX, and system performance.

Business Consultant Intern

Blackmont Consulting
05.2024 - 08.2024
  • Developed a pitch deck for a product-based eCommerce company, securing £170K in funding from university alumni, with submissions to venture capitalists and crowdfunding platforms for an additional £130K goal
  • Conducted an in-depth SEO analysis, optimizing website keywords and structure, improving search visibility and outreach potential
  • Designed a website framework and layout to enhance user experience and branding, aligning with market trends and customer engagement strategies
  • Performed SWOT, GAP, and PESTEL analyses to support the company's UK expansion, identifying key market opportunities and strategic positioning

Consulting Project

NHS Golden Jubilee National Hospital
06.2023 - 08.2023
  • Analyzed surgical theater efficiency, reducing turnover times by 20% using statistical methods and discrete event simulation
  • Assessed shared anaesthetic room impacts, providing data-driven recommendations that increased utilization rates by 15%
  • Delivered actionable insights, earning top academic and client feedback, and scoring 80% (Top 5 in class)

Apprenticeship

Strathclyde Catering Services (Nourish)
01.2023 - 02.2023
  • Analyzed customer feedback and operational data to support process improvements and enhance service delivery
  • Built dashboards using Excel and Power BI to monitor key performance metrics and identify trends

Data Analyst

Rexaware Solutions Pvt. Ltd
08.2021 - 08.2022
  • Analyzed 1M+ data points using SQL, Python (Pandas, NumPy), and Excel, conducting descriptive, inferential, and predictive analytics to derive actionable business insights
  • Developed interactive data visualizations and dashboards using Tableau and Matplotlib, enhancing stakeholder decision-making and reducing reporting time by 40%
  • Performed trend analysis, forecasting, and statistical modeling, identifying key business patterns that improved resource allocation and operational efficiency by 15%
  • Created and delivered client-facing presentations with compelling data narratives, translating complex analyses into actionable strategies that increased client engagement by 30%

Education

Master of Science - Business Analysis & Consulting

University of Strathclyde
09.2023

BE - Mechanical Engineering

Maharashtra Institute of Technology
09.2023

Skills

  • SQL
  • Python
  • R
  • Advanced Excel
  • Power BI
  • Tableau
  • A/B Testing
  • Predictive Analytics
  • Business Process Optimization
  • Stakeholder Communication
  • Consulting
  • Strategy Design
  • Statistical Modeling

Consulting Projects

  • Student Placement Program, NHS Golden Jubilee National Hospital, Glasgow, UK, 06/01/23, 08/01/23, Analyzed surgical theater efficiency, reducing turnover times by 20% using statistical methods and discrete event simulation., Assessed shared anaesthetic room impacts, providing data-driven recommendations that increased utilization rates by 15%., Delivered actionable insights, earning top academic and client feedback, and scoring 80% (Top 5 in class).
  • Apprenticeship, Strathclyde Catering Services (Nourish), Glasgow, UK, 01/01/23, 02/01/23, Analyzed customer feedback and operational data to support process improvements and enhance service delivery., Built dashboards using Excel and Power BI to monitor key performance metrics and identify trends.

Leadership Experience

Part-time Supervisor, Zapatista Burrito, UK, 09/01/23, Present, Trained and supervised staff, fostering leadership within the team and improving operational efficiency by 20%., Managed day-to-day operations, ensuring seamless customer service and efficient task delegation., Spearheaded process improvements, resulting in a 15% reduction in service errors.

Timeline

Analyst Intern

Virtue Analytics
08.2024 - Current

Business Consultant Intern

Blackmont Consulting
05.2024 - 08.2024

Consulting Project

NHS Golden Jubilee National Hospital
06.2023 - 08.2023

Apprenticeship

Strathclyde Catering Services (Nourish)
01.2023 - 02.2023

Data Analyst

Rexaware Solutions Pvt. Ltd
08.2021 - 08.2022

BE - Mechanical Engineering

Maharashtra Institute of Technology

Master of Science - Business Analysis & Consulting

University of Strathclyde
Kartik Singh Gautam