Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Ishaan Tyagi

Summary

Dedicated and results-driven ETL Developer with 1.5 years of hands-on experience in Extract, Transform, Load (ETL) processes, SQL database management, and Power BI reporting. Proven ability to analyze business requirements, design efficient ETL workflows, and create insightful visualizations for data-driven decision-making. Adept at collaborating with cross-functional teams to deliver high-quality solutions that meet business objectives.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Assistant System Engineer Trainee

Tata Consultancy Services
07.2021 - 12.2022
  • Collaborated with business analysts to define and implement ETL processes, resulting in a 20% improvement in data loading efficiency.
  • Developed and maintained ETL processes using [mention specific ETL tools], processing an average of 500,000 records daily with 99.9% accuracy.
  • Conducted performance tuning, optimizing SQL queries that led to a 25% reduction in query execution time.
  • Created Power BI reports that contributed to a 15% increase in data-driven decision-making across the organization
  • Implemented database security measures, resulting in a 30% decrease in security-related incidents.
  • Conducted regular database maintenance tasks, leading to a 15% improvement in overall system performance.
  • Collaborated with development teams to optimize database schema, reducing query response time by 20%.

Education

B.Tech - Information Technology

Inderprastha Engineering College
Sahibabad, India
07.2021

Skills

  • ETL Tools: Informatica PowerCenter
  • Database Management: SQL Server, MySQL, PostgreSQL
  • Business Intelligence: Power BI
  • Data Modeling: ERD, Dimensional Modeling
  • Programming Languages: SQL, Python (basic)
  • Data Warehousing: Design and implementation
  • Data Analysis: Query optimization, performance tuning
  • Collaboration: Cross-functional teamwork, effective communication

Certification

  • Power BI - Data Analytics Essentials with Power BI By UDEMY
  • Python + SQL + Tableau: Integrating Python, SQL, and Tableau By UDEMY
  • The complete SQL Bootcamp: Go from Zero to Hero By UDEMY


Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)

Timeline

Assistant System Engineer Trainee

Tata Consultancy Services
07.2021 - 12.2022

B.Tech - Information Technology

Inderprastha Engineering College
Ishaan Tyagi