Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Jayateja Vanamu

Jersey City,NJ

Summary

Results-driven Data Analyst with a strong focus on productivity and efficiency in task completion. Expertise in data visualization, statistical analysis, and predictive modeling supports informed decision-making. Proven problem-solving skills and critical thinking abilities enhance team collaboration and project success. Committed to leveraging data insights to drive strategic initiatives.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Data Analyst

Reliance Surfaces
New Jersey, USA
05.2024 - 01.2025
  • Analyze sales data and inventory trends to optimize stock levels across multiple warehouses, reducing overstock by 15% while maintaining 99% product availability
  • Develop and maintain 3 interactive Power BI dashboards to track key performance indicators for sales, inventory turnover, and supply chain efficiency
  • Utilize SQL and Python to clean and analyze large datasets of customer purchase history, identifying cross-selling opportunities that increased the average order value by 8%
  • Collaborate with the supply chain team to forecast demand for 200+ product lines, improving inventory accuracy by 20% and reducing carrying costs
  • Create monthly reports on market trends and competitor pricing, contributing to strategic decisions that have increased market share by 3% in the premium stone segment

Data Analyst

I 28 TECHNOLOGIES
New Jersey, USA
12.2023 - 05.2024
  • Wrote complex SQL queries involving correlated subqueries, window functions, and common table expressions to track user activity metrics such as retention rate and daily active user
  • Optimized 10 existing queries, reducing average runtime by 40% on datasets exceeding 1 million records
  • Built dashboards in Tableau and presented data to track KPIs and product performance
  • Conducted trend analysis on user activity data, identified 3 underperforming user segments, and presented findings to stakeholders, resulting in a 15% improvement in user engagement strategies
  • Designed 12 key metrics for Tableau dashboards, enhancing test process monitoring and result analysis efficiency by 35%
  • Executed data analysis using SQL, successfully cleaning and standardizing over 200,000 customer records, improving data accuracy by 98%

Education

Master of Science - Advanced Data Analytics

University of North Texas
DENTON, TX
12.2023

Bachelors - Engineering

BV Raju Institute of Technology
Hyderabad, India
01.2022

Skills

  • Data Visualization: Power BI
  • Data Visualization: Tableau
  • Data Visualization: Matplotlib
  • Data Visualization: Seaborn
  • Programming Languages: Python
  • Programming Languages: R
  • Machine Learning Algorithms: Regression
  • Machine Learning Algorithms: Classification
  • Machine Learning Algorithms: Clustering
  • Big Data: Hadoop
  • Big Data: Spark
  • IDE: Jupyter Notebook
  • IDE: RStudio
  • IDE: VS Code
  • Database Language: MySQL
  • Database Language: SQL Server
  • Data Warehousing: Data Cleansing
  • Data Warehousing: ETL
  • Environments: AWS
  • Environments: Google Cloud Platform
  • Environments: SAS Enterprise Miner
  • Environments: Anaconda
  • Version Control: Git
  • MS Office Tools: Excel
  • MS Office Tools: PowerPoint

Certification

  • DATABRICKS: LAKEHOUSE FUNDAMENTALS
  • DATABRICKS: GENERATIVE AI FUNDAMENTALS
  • DATACAMP: MACHINE LEARNING WITH CARET IN R
  • COURSERA: IBM GENERATIVE AI FUNDAMENTALS

Projects

Baggage Handling Analysis Project - American Airlines Data Challenge, Conducted a comprehensive analysis of baggage handling operations at American Airlines to enhance operational efficiency, resource allocation, and predictive modelling for future bag arrivals., Conducted Exploratory Data Analysis (EDA) involving data preprocessing, identifying hourly baggage handling patterns, and day-of-week analysis., Analyzed bag load consistency, station efficiency, early bags, and identified peak periods using descriptive statistics and visualizations., Developed prediction models (Linear Regression, Decision Tree Regressor, Random Forest Regressor) for bag arrivals with a focus on improving accuracy and resource planning., Utilized time series forecasting techniques (SARIMA model) to predict future bag arrivals with precision, aiding in efficient resource management and operational planning., Provided insights into hourly bag count trends, day-of-week analysis, and arrival patterns, enabling actionable recommendations for operational efficiency, resource allocation, and performance monitoring., Recommended strategies for operational improvements, resource planning, forecasting models' adoption, and time series analysis utilization., Highlighted operational implications including resource optimization, planning for peak hours, and informed decision-making based on hourly patterns., Emphasized the project's real-world impact, contributing to operational excellence, risk mitigation against baggage loss/theft, and optimizing baggage policies. Customer Feedback Analysis with Sentiment Prediction, Built a sentiment analysis system to classify and extract insights from customer feedback, leveraging AWS Glue for data preparation, SageMaker for fine-tuning BERT models, and Lambda for real-time inference. Integrated AWS Kendra for intelligent feedback search, enabling actionable insights for improved decision-making.

Timeline

Data Analyst

Reliance Surfaces
05.2024 - 01.2025

Data Analyst

I 28 TECHNOLOGIES
12.2023 - 05.2024

Master of Science - Advanced Data Analytics

University of North Texas

Bachelors - Engineering

BV Raju Institute of Technology
Jayateja Vanamu