Yash Aggarwal
Experience
Analyst — Ernst and Young LLP
Dec 2025 -- PresentGurugram, Haryana
- Automated end-to-end tax compliance workflows by engineering Python pipelines (Polars, FastExcel), reducing manual data preparation time by 300+ hours annually.
- Architected high-speed data transformation engines to process large-scale datasets (50K+ rows/file), ensuring 100% accuracy in compliance-ready Excel outputs.
- Developed intelligent rule-based logic for automated tax categorization and conditional remark generation, eliminating human error in sensitive compliance reporting.
- Optimized data integrity by building robust reconciliation modules and exception-handling checks to flag mismatches across disparate tax datasets.
- Engineered resilient automation scripts capable of parsing irregular "real-world" Excel structures, including merged cells and inconsistent formatting.
- Streamlined multi-source consolidation by implementing automated lookups and merging workflows, minimizing manual intervention in final report generation.
Software Developer — Lyxel labs private limited
Jan 2024 -- Dec 2025Gurugram, Haryana
- Developed and revamped Weavr Sense by integrating cross-server databases via custom REST APIs, improving data retrieval speed by 25% through MongoDB query optimization.
- Led development of MongoDB models and scrapers in the automation pipeline.
- Developed scalable serverless features and automated data handling tasks in a Linux environment using Redis and Celery using managed API endpoints.
- Streamlined scraping pipelines using Celery and Python, reducing manual effort by 40% while ensuring robust version control via Git.
- Designed secure registration/login APIs with security and data protection best practices, ensuring normalized data storage (1NF/2NF).
- Mentored 3 interns and assisted in knowledge transfer for backend architecture and CI/CD practices.
Backend Developer — Freelancer
Mar 2023 -- Aug 2023Remote
- Developed a scalable Inventory Management System using NodeJS, MongoDB, and ExpressJS.
- Ensured optimized CRUD operations, contributing to 35% faster inventory updates.
- Implemented role-based access control.
- Integrated NodeMailer for automated notifications added full user-action logging.
- Delivered end-to-end development of features and integrated NoSQL storage solutions efficiently.
Technical Skills
Languages:Python (Expert), JavaScript, Shell Scripting, SQL, MongoDB
Frameworks:FastAPI, Flask, Falcon, NodeJS, ExpressJS
Data Engineering:Polars, pandas, NumPy, FastExcel, PyExcelerate
Cloud/DevOps:Git, Linux
Tools:VSCode, PyCharm, GitHub CoPilot
Education
Bennett University — Greater Noida, Uttar Pradesh
Sep. 2020 -- Jun 2024Bachelor of technology in Computer Science and Engineering
- Content Writer IEEE BU, 2020 to 2021
- 8.9 CGPA
Projects
SMTP Honeypot | Python, smtpd, Async
Mar 2023- Developed a honeypot server using Python and the smptd library.
Twitch Watcher Discord Bot | Docker, Python, Discord, Requests
Jan 2023 -- Feb 2023- Built a bot to streamline server interactions and RLCS loot acquisition.
- Deployed using Docker for isolated, consistent performance.
Remote Intensive Care Application | Python, Flask, SQLite, Pytest
Oct 2021 -- Dec 2021- Built a web-based ICU system using agile methods, boosting efficiency by 30%.
- Optimized database queries and schema to improved data retrieval speed by 40%, enhancing overall performance of the web application.
- Used Pytest to develop and execute comprehensive test suites for API testing, ensuring functionality, reliability, and performance of RESTful services