YASH MALVIYA
Data Analyst
Transforming raw data into business intelligence through cloud analytics, modern data platforms, and impactful dashboards. Specialist in designing end-to-end data processing pipelines.
500K+
Records Processed
40+
SQL Analyses
3
End-to-End Pipelines
AWS + Snowflake
Analytics Deployments
Yash Malviya
AWS & Snowflake Analyst
ABOUT ME
Specializing in translating complex retail & transactional data into cloud-native intelligence.
I am a results-oriented Data Analyst focused on designing scalable cloud architectures, transforming multi-million row transactional databases, and crafting analytical tools that drive strategic growth. My analytical toolkit spans across Python and SQL for core processing, AWS and Snowflake for cloud analytics, and Tableau for interactive reporting.
Throughout my hands-on portfolio milestones, I have engineered analytics systems for mock environments like Olist E-Commerce, AdventureWorks, and Contoso Retail. My passion lies in finding the narrative within numbers—helping executives make sense of customer cohort metrics, seasonal trends, and profit margins.
Let's build data solutions that are not just accurate, but highly queryable, scalable, and responsive.
Cloud Infrastructure
AWS (S3, Athena, Glue) & Snowflake cloud databases mapped for pipeline automation.
Advanced Visualizations
Tableau interactive dashboards featuring cohort analytics, customer segmentation, and KPI tracking.
Algorithmic Analytics
EDA scripts built with Pandas, NumPy, and SQL queries optimized for processing high-volume databases.
0K+
Transactions Parsed
0
Data Pipelines Built
0+
SQL Queries Optimized
0+
Business KPIs Modeled
SKILLS ORBIT
ANALYST
WORK EXPERIENCE
Data Analytics Projects
Self-employed
500K+
Records Processed
3
Analytics Projects
Cloud Native
AWS + Snowflake
40+
SQL Analyses
Engineered and deployed scalable cloud data structures, designed warehouse star schemas, and custom dashboards mapping complex transactional pipelines.
Designed and delivered three end-to-end analytics solutions (Olist, Contoso and AdventureWorks) using SQL, Python, PostgreSQL, AWS, Snowflake and Tableau to solve customer, sales and operational analytics problems.
Processed and analyzed 500K+ records across customer, sales and operational datasets.
Designed dimensional data models, ETL workflows and analytical SQL queries using CTEs and window functions.
Developed executive dashboards delivering insights into customer retention, revenue trends, profitability and geographic performance.
Built cloud-based analytics pipelines using AWS S3, Athena, Glue and Snowflake.
Data Analyst Intern
Oasis Infobyte
Collaborated within the analytics division to ingest, clean, and profile e-commerce and retail transactions. Structured diagnostic SQL models and Python environments for team analysis.
Performed EDA on retail and customer datasets using Python, Pandas, Matplotlib and Seaborn to identify sales trends and seasonal demand patterns.
Cleaned and preprocessed datasets and built KPI reports tracking revenue trends, customer insights and product performance.
Conducted statistical and trend analysis to support business recommendations using end-to-end Jupyter Notebook workflows.
EDUCATION
Bachelor of Artificial Intelligence & Data Science
Prestige Institute of Engineering Management & Research
Deep training in database architectures, pipeline operations, and statistical calculations. Learned methods for structuring queries, developing machine learning regressions, and modeling analytical databases.
Core Coursework
CLOUD ARCHITECTURE
Interactive roadmap outlining Yash's end-to-end cloud pipeline. Hover or click on any node to view how data is staging, transformed, and queried.
Raw files landing in S3 are cataloged automatically by Glue, audited serverlessly via Athena, integrated inside Snowflake tables, and monitored dynamically on Tableau workbooks.
Snowflake
Pipeline Node Info
Cloud Analytical Data Warehousing
Stages cleaned warehouse schema tables with high-performance clusters
Implements dimensional modeling (Star and Snowflake schemas)
Supports time-travel data queries and zero-copy clones
FEATURED PROJECTS
Data & Cloud Analyst
Database & Pipeline Verification
Olist E-Commerce End-To-End Analytics
Engineered an automated data processing pipeline staging raw e-commerce records. Designed Snowflake target schemas for querying customer delivery offsets, payment metrics, and category revenue performance.
$15.4M+
Revenue Analyzed
100K+
Orders Analyzed
99K+
Total Customers
32K+
Products Cataloged
20+
Business KPIs
Database & BI Engineer
Database & Pipeline Verification
Contoso Customer Revenue Analysis
Imported massive retail datasets into PostgreSQL to model retention curves. Prepared complex cohort query models to track 24-month customer retention intervals, transaction frequencies, and revenue segments.
$22M+
Revenue Analyzed
200K+
Transactions
104K+
Total Customers
2.5K
Unique Products
24-Month
Retention Study
Data Analyst
Database & Pipeline Verification
Adventure Works Sales Intelligence
Crafted an interactive Tableau portfolio tracing global corporate metrics. Pinpointed high-performing geographical territories, revenue drops in offline retail channels, and margins across high-volume inventories.
$109.85M+
Revenue Analyzed
$9.37M+
Total Net Profit
Australia
Top Region
73%
Offline Sales Share
CORE ACHIEVEMENTS
0K+
Records Processed
High-volume data cleaning & query pipelines mapping transactional logs.
0+
SQL Analyses
Optimized complex joins, indexes, subqueries, and partition calculations.
0
Analytics Pipelines
Full pipeline flow ingestion, transformations, cataloging, and reporting.
AWS → Snowflake
Architecture
Cloud analytical storage architecture mapping schemas automatically.
0+
Dashboard KPIs
Interactive business metrics, cohort retentions, and profit parameters.
0
Cloud Projects
Full end-to-end cloud database migrations and analytics pipelines.
GITHUB ACTIVITY
YashMalviya01
Contributions Heatmap
OLIST-E-Commerce-Data-Analytics-Project
End-to-End data analytics architecture built using AWS S3 staging, Snowflake data warehousing, and Tableau dashboard profiles.
End-To-End-Retail-Sales-Customer-Analytics
Database cohort analytics modeling customer segments and 24-month retention metrics on PostgreSQL retail data.
Adventure_Works_End-to-End_Analytics
Operational and sales analytics dashboarding, tracking regional margins and revenue share differences.