Teradata Developer with DW & Performance Expertise

Kumar Gulshan

Ȱ Bengaluru, India ć ************@*****.*** Л +91-773******* f krgulshan

Professional Summary

Teradata Developer with 4 years of hands-on experience working on large-scale enterprise data warehouses. Strong expertise in Teradata SQL development, performance tuning using EXPLAIN plans, and troubleshooting production data issues. Proven experience analyzing high-volume fact tables, defining aggregation strategies, and ensuring data integrity across reporting layers. Known for owning problems end-to-end in support and delivery environments, working closely with architects, analysts, and business stakeholders. Core Technical Expertise

Teradata & SQL

• Teradata SQL Assistant, BTEQ, FastLoad, MultiLoad, Import/Export utilities.

• Advanced Teradata SQL: complex joins, window functions, QUALIFY, subqueries, macros, stored procedures.

• EXPLAIN plan analysis, primary index design, data skew identification, query optimization. Data Warehousing

• Fact and dimension table analysis, measures validation, aggregation design.

• Dimensional modeling, Slowly Changing Dimensions (SCD Type I & II).

• Data lineage, data reconciliation, transformation validation. Performance & Support

• Production issue analysis, batch job monitoring, SLA-driven support.

• Spool space analysis, performance troubleshooting, root cause analysis.

• Data integrity, consistency, and data quality checks. Additional Skills

• Snowflake, SAP HANA (working knowledge).

• Azure Data Factory, Azure Databricks (exposure).

• Python (basic) – data validation and reconciliation scripts. Work Experience

BI Engineering Analyst — Accenture Feb 2022 – Present Client: Leading Global Semiconductor Manufacturer

• Designed, developed, and optimized complex SQL queries, views, and stored procedures to support reporting, reconciliation, and analytical use cases.

• Performed query performance tuning using execution plan analysis, join optimization, and query refactoring on large enterprise datasets.

• Troubleshot database performance issues by identifying inefficient joins, suboptimal access paths, and data volume bottlenecks.

• Validated 70+ migrated tables during Teradata to Azure/Snowflake migration, ensuring row-level accuracy, schema consistency, and data integrity.

• Built and optimized foundation and consumption views to improve query performance and usability for reporting teams.

• Ensured adherence to data governance, security, and compliance standards during database development and validation activities.

• Collaborated with business analysts and data architects to translate reporting requirements into efficient SQL- based solutions.

• Performed BI report validation including joins, filters, aggregations, and security logic.

• Worked closely with cross-functional teams in an Agile environment, participating in sprint planning, defect triage, and release validation.

• Provided guidance to junior team members on Teradata SQL best practices and debugging approaches. Certifications

• Microsoft Certified: Azure Data Engineer Associate (DP-203)

• Microsoft Certified: Azure Data Fundamentals (DP-900) Education

Dr. B C Roy Engineering College

B.Tech in Computer Science

Aug 2017 – Jul 2021

Contact this candidate