Skip to content
View jiyanshgarg's full-sized avatar

Block or report jiyanshgarg

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
jiyanshgarg/README.md

Jiyansh Garg

jiyansh1823@gmail.com       |       LinkedIn       |       [My Portfolio]

Summary

Data Analyst Trainee with hands-on experience in SQL, data analysis, Excel and Python. Skilled in query optimization, data transformation, and building reports to track KPIs, trends, and anomalies. Strong ability to deliver data-driven insights and support business decision-making.

Work Experience

Data Analyst Trainee                                                                                                                                     March 2026 - present

CloudoLogix Limited (Remote)

  • Optimized complex SQL queries to improve performance and enhance efficiency in data processing and reporting workflows
  • Built structured datasets and reports to track cost trends, KPIs, and anomalies for business insights
  • Performed competitive analysis of FinOps tools by comparing features with CloudoBerry, identifying gaps and recommending improvements
  • Collaborated with team members to understand requirements and deliver data-driven insights and actionable recommendations

Projects

Brazilian E-Commerce Customer & Order Analysis

  • Analyzed 100,000+ e-commerce transactions using SQL to evaluate customer behavior and operational performance
  • Calculated order completion rate and average delivery delay metrics to evaluate operational efficiency
  • Identified shipment delay patterns impacting order completion rates and proposed data-backed process improvements

Delhivery Logistics & Delivery Performance Analysis

  • Analyzed 100K+ logistics shipment records to understand delivery timelines, route efficiency, and operational performance.
  • Performed data cleaning and transformation using Pandas to handle missing values, incorrect timestamps, and inconsistent location data.
  • Conducted Exploratory Data Analysis (EDA) to identify patterns in delivery delays and shipment movement.
  • Generated insights that will help improve delivery efficiency and route optimization.

Netflix Content Engagement Analysis

  • Analyzed 8,000+ content records using Python to identify genre and regional performance trends
  • Built Tableau dashboards visualizing content distribution and engagement patterns
  • Identified underperforming content segments and suggested expansion opportunities

Skill

Languages                    Python, SQL

Libraries/Frameworks   Pandas, NumPy, SciPy, Matplotlib, Seaborn ( Python Libraries )

Tools                              Excel, Power BI, Tableau

Concepts                       Exploratory Data Analysis (EDA), Data Cleaning & Transformation, Business Analysis, Statistical Analysis,                                       Data Visualization, KPI Metric skills

Pinned Loading

  1. delhivery-logistics-data-analysis delhivery-logistics-data-analysis Public

    This project analyzes Delhivery's logistics delivery dataset to understand delivery performance, route efficiency, and operational patterns using data analytics techniques. The analysis focuses on …

    Jupyter Notebook

  2. Yulu-Bike-Demand-Analysis-Hypothesis-Testing Yulu-Bike-Demand-Analysis-Hypothesis-Testing Public

    This project performs an end-to-end exploratory data analysis (EDA) and hypothesis testing on Yulu’s historical rental data to identify the key factors influencing bike rental demand and to derive …

    Jupyter Notebook

  3. digital-music-store-analytics-SQL digital-music-store-analytics-SQL Public

    Unravel valuable insights and answer numerous critical questions about our music store's operations. By diving deep into the dataset, we aspire to gain profound understanding and enhance decision-m…

    1

  4. Walmart-Black-Friday-Customer-Purchase-Analysis Walmart-Black-Friday-Customer-Purchase-Analysis Public

    This project analyzes 550,000+ Walmart Black Friday transactions to understand how customer demographics influence purchase behavior. The analysis applies statistical inference techniques, includin…

    Jupyter Notebook

  5. Brazilian-ecommerce-SQL-Analysis-Customer-Order-Insights Brazilian-ecommerce-SQL-Analysis-Customer-Order-Insights Public

    Analyzed a real e-commerce dataset using SQL to uncover customer behavior, order delivery performance, and payment trends. Includes data cleaning, exploratory queries, KPIs, and actionable business…

  6. uber-drives-data-analysis uber-drives-data-analysis Public

    This project demonstrates an end-to-end data analysis workflow, transforming raw Uber trip data into meaningful business insights. The findings can help improve operational efficiency, customer exp…

    Jupyter Notebook