KALYANI SRIVASTAVA

B.Tech Information Technology Student

Ghaziabad, IndiaData Engineering and Analytics
39skills
1education
2credentials

About

Bachelor of Technology student in Information Technology building data engineering pipelines, lakehouse architectures, dashboards, and analytics solutions using Python, SQL, PySpark, Microsoft Fabric, and Power BI.

Education

Ajay Kumar Garg Engineering College

Bachelor of Technology (B.Tech), Information Technology

2023 – 2027

Skills

PythonSQLC++ETL/ELTData PipelinesData IngestionData CleaningData TransformationData ValidationData WarehousingData LakesMicrosoft FabricLakehouseData WarehouseData FactoryDataflows Gen2OneLakeEventhouseApache SparkPySparkHadoopKQLMySQLMongoDBPower BIMicrosoft ExcelPower QueryDAXData VisualizationDashboard DesignREST APIsNode.jsExpress.jsGitGitHubVS CodeDBMSOOPOperating Systems

Projects

E-Commerce Data Engineering Pipeline

Building an end-to-end data engineering pipeline to ingest, clean, transform, and validate e-commerce sales data using Python, SQL, and Microsoft Fabric. Implementing a Lakehouse-based data architecture with PySpark and SQL, designing a star-schema data warehouse with fact and dimension tables, and integrating automated data pipelines with Power BI for business insights and visualization.

Real-Time Retail Data Engineering Pipeline

Building a real-time pipeline for simulated retail transactions using Microsoft Fabric, Python, PySpark, and SQL. Implementing transformation, validation, and aggregation workflows; using Eventhouse and KQL for near real-time analysis; and developing Power BI visualizations for transaction volume, revenue, and product performance.

HR Analytics Dashboard

Built an interactive Microsoft Excel dashboard tracking employee count, attrition rate, average salary, department-wise distribution, and gender ratio. Cleaned and prepared HR data using XLOOKUP, IF, SUMIFS, and COUNTIFS, and built Pivot Tables, Pivot Charts, KPI cards, and Slicers.