Data Analyst - SQL, Python, Power BI

HARSIMRANKAUR

San Jose, CA *******@*****.*** LinkedIn GitHub Portfolio 346-***-****

SUMMARY

Data Analyst with hands-on experience in SQL, Python, Excel, Power BI, Tableau, ETL pipelines, and data visualization. Experienced in collecting, cleaning, validating, and analyzing large datasets to deliver actionable business insights. Strong foundation in analytics, reporting, dashboard development, and cross-functional collaboration, with a passion for continuous learning and solving data-driven problems. PROFESSIONAL EXPERIENCE

Systems and Data Associate Metro by T-Mobile Houston, TX Feb 2024 – May 2026

• Collected, cleaned, and organized 50K+ customer interaction and sales records using SQL and Excel to identify service trends and support operational decision-making with high data accuracy

• Automated 10+ recurring reporting workflows in Python (pandas) and Excel, reducing manual reporting time by 35% and improving data accuracy

• Built and maintained Power BI and Tableau dashboards tracking sales, customer engagement, and store performance metrics to support routine reporting activities

Undergraduate Research Intern University of Houston Houston, TX May 2023 – Aug 2023

• Optimized the accuracy of the machine learningsolution, a Python-based tool for detecting true/false positives in source code, from 87% to 90% by using NLP techniques for advanced preprocessing.

• Developed a modular system using 5+ classification algorithms for source code true/false positive detection and provided insights on model performance trends, visualizing results using a Power BI dashboard.

• Implemented pre-trained LLMs such as CodeBERT, GPT-3, and Codex, increasing overall classification accuracy to 92% Information Technology Support Specialist Intern Lone Star College Woodlands, TX Jun 2022 – Dec2022

• Coordinated device provisioning, software installation, and technology asset tracking across 100 + campus technology resources.

• Resolved classroom hardware, software, and connectivity issues supporting smooth teaching and administrative operations.

• Extracted and transformed 500K+ records using SQL and prepared datasets for analysis and dashboard reporting. Operations Manager Best Western Spring, TX Mar 2021 – Nov 2023

• Analyzed occupancy, reservation, and revenue data to identify trends and support pricing and operational decisions.

• Developed Excel and SQL-based reports tracking key hotel performance metrics across multiple properties.

• Leveraged Python analysis, SQL querying, and operational datasets to uncover customer and sales trends, identifying a potential 12% growth opportunity and support for optimizing operational decision-making workflows. PROJECTS

Spotify Listening Insights Data Pipeline & Analytics Project GitHub

• Developed a Power BI dashboard revealing top music trends by creating an ETL pipeline using Python to ingest 5M+ records from the Spotify API, transform and load the data into an SQLite database, and connect it to the dashboard. NYC Analytics Platform Big Data Analytics Project GitHub

• Built a Looker dashboard on 46GB of data with 615M trip records for NYC traffic and taxi service patterns, using Python to load data into Cloud Storage, processing it with Spark in Databricks, storing it in BigQuery, and connecting to Looker. SKILLS

• Programming:Python (pandas, numpy, matplotlib, seaborn,Plotly, SciPy, scikit-learn, PySpark), R (stats, caret, ggplot2, tidyverse, RShiny)

• Analytic Tools: Tableau, Power BI (DAX, Power Query),Looker, Excel, Google Sheets, Spark, Databricks, DBT, Airflow

• CloudPlatforms: GCP (BigQuery, Data Studio),Azure (Data Factory, Azure SQL), AWS (S3, Redshift, QuickSight)

• MLTechniques: Regression, Classification, Clustering,Time Series, NLP, LLMs, A/B Testing, Hypothesis Testing EDUCATION

University of Houston, Houston, TX B.S. in Computer Science GPA - 3.96 / 4.00

● Awards:Magna Cum Laude, Dean's Scholar List

● Activities: Vice President of Indian Student Organization,Codecoogs

Contact this candidate