Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Satnam Singh

San Bernardino,California

Summary

Responsible and motivated student ready to apply education in the workplace. Offers excellent technical abilities with software and applications, ability to handle challenging work, and excellent time management skills.

Overview

3
3
years of professional experience

Work History

Junior Data Analyst

Abbas Roadlines
Hyderabad, Telangana
11.2018 - 07.2021
  • Conducted in-depth data analysis using Python and SQL, identified key trends and patterns to support business decision-making during pandemic and increased the profit by 21%.
  • Understood the business requirements and provided analytical support to address reduced revenue issues in 2019.
  • Introduced a new product from the market and marketplace to add new transportation route, resulting in a 15% increase in revenue.
  • Defined, implemented, and standardized metrics, reports, and dashboards.

Education

Master of Science - Information Technology Data/Business Intelligence

California State University - San Bernardino
San Bernardino, CA
12.2023

Bachelor of Commerce - Computers Application

Osmania University
Hyderabad
10.2020

Skills

  • Programming Languages: Python, SQL, R, C, C, NetBeans
  • Knowledgeable: Machine Learning, PySpark, Tableau, AWS, Power BI, Microsoft Office
  • Languages (Fluent): English, Hindi, Punjabi
  • Data Analysis: Data Wrangling, Data Modeling, ETL/ELT Processes, Database Maintenance
  • Data Repositories: Databases, Data Warehouses, Data Marts, Data Lakes, Big Data

Projects

Early-Warning Prediction for Machine Failure in Automation Industry using Advanced Machine Learning Techniques

  • Conducted a project using Machine Learning to detect industrial machine failures.
  • Explored data quality impact, emphasizing outlier handling; investigated SMOTE integration and feature engineering effects; evaluated performance of diverse ML algorithms.
  • Identified Catboost as a standout algorithm with 92% accuracy and 99% failure detection.

Quantifying Qualcomm: Unveiling Brand Potency and the U.S. Advantage in Semiconductors(flexdashboard, DT, ggplot2, tidyverse)

  • Evaluated Qualcomm's brand recognition and competitive advantage as a U.S.-based semiconductor company.
  • Conducted a study with a questionnaire, processed data in R, and found target markets and a competitive edge for Qualcomm.
  • Target marketing advised for 18-24 age groups on Instagram and TikTok; clear competitive advantage for Qualcomm as a U.S.-based semiconductor company, suggesting strategic emphasis in future marketing.

Analyzing Students' Mental Health in SQL

  • Conducted thorough exploratory data analysis using SQL to understand, filter, and summarize diagnostic scores for different student types.
  • Applied aggregate functions to calculate and present concise summary statistics for diagnostic tests, contributing to data-driven decision-making.
  • Effectively communicated insights through clear data visualization, emphasizing the impact of the length of stay on average diagnostic scores for international students.

Dr. Semmelweis and the Discovery of Handwashing

  • Conducted historical data analysis on Dr. Ignaz Semmelweis's mid-1800s maternal mortality dataset, examining clinic-level and hospital-level records to derive insights into death rates over the years.
  • Utilized R programming language and the dplyr package for data manipulation, transformation, and summarization, showcasing proficiency in data analysis and visualization.
  • Investigated the impact of hygiene practices, specifically the introduction of handwashing and autopsies, on maternal mortality rates, demonstrating the ability to derive meaningful conclusions from complex historical datasets.

Timeline

Junior Data Analyst

Abbas Roadlines
11.2018 - 07.2021

Master of Science - Information Technology Data/Business Intelligence

California State University - San Bernardino

Bachelor of Commerce - Computers Application

Osmania University
Satnam Singh