Himanshu Yadav

Data & Bi Engineer @Tata Consultancy Services

Indore, IN

As a Data & BI Engineer at TCS, I design and deliver scalable data solutions that power analytics and business insights.Major Duties:• Developed and optimized end-to-end ELT pipelines integrating data from APIs, IBM Db2, and flat files into AWS S3 and Snowflake.• Automated workflows using PySpark on EMR and Apache Airflow, ensuring high availability (99.9% uptime) while processing 5M+ records daily.• Designed star-schema data models and tuned Snowflake queries, enhancing analytical performance by ~40%.• Built Power BI dashboards with advanced DAX measures, row-level security, and Snowflake integration for executives and business teams.Key Projects & Successes:• Legacy Modernization Initiative: Migrated 50+ Db2 tables and 70+ Datastage ETL jobs to AWS-based architecture, reducing operational costs by 30%.• Reusable PySpark Framework: Created generic PySpark scripts for full and incremental loads, eliminating manual effort across 100+ tables.• BI Modernization: Converted 100+ Cognos and QlikView reports into Power BI, improving usability and performance for end users.• Recognized with 8+ awards, including Best Team and Continuous Learning, along with multiple client appreciations for quality and delivery excellence.