Senior Data Engineer Teradata/EDW Expert

Kalyani Atre

*******.****@*****.***

+1-925-***-****, Fremont, California

Professional Summary

Results-driven Teradata Developer / Senior Data Engineer with 15+ years of experience in designing, developing, and optimizing large-scale enterprise data warehouse (EDW) solutions. Strong expertise in Teradata SQL, ETL development, data integration, and performance tuning. Hands-on experience with Teradata utilities (BTEQ, TPT, FastLoad, MultiLoad), Explain Plan analysis, and data validation techniques to ensure high data quality and performance. Deep expertise in accounting engines, reconciliation, and regulatory reporting with proven ability to architect complex ETL implementations and enabling BI for supporting multi-currency, multi-GAAP frameworks. Adept at collaborating with cross-functional teams, managing stakeholders, and delivering high-quality, scalable solutions aligned with business goals. Authorized to work in the U.S. (L2S Visa, valid through 2028). Core Competencies

• SQL Teradata – Complex query writing, Scripting, Utilities- BTEQ, TPT, FastLoad, MultiLoad, FastExport

• ETL/Data Engineering- Mainframe (JCL, TDS), Microgen Accounting Hub ETL tool, Snowflake, Hadoop

• Scheduling Tool- CA7, Control M, Oozie, batch automation

• Languages- SQL, Shell-Unix, Python(basic)

• Cloud & BI: IBM Cloud, Tableau

• Analytics: Teradata Vantage Cloud

• Data Warehouse Architecture: EDW Strategy, Data Integration, Enterprise Data Modeling, 3NF, Star/Snowflake, Dimensional Modeling

• Performance & Scalability: Query optimization, workload management, partitioning, indexing strategies, Explain Plans analysis

• Stakeholder Leadership: Road mapping, business alignment, cross-functional collaboration, Leadership communication

• Project Delivery: Agile/Scrum, technical leadership, migration strategy, UAT, Confluence documentation

• Testing & Support: Analyst Collaboration, defect resolution, UAT, L2/L3 production support Professional Experience

Senior Data Engineer/ Teradata Developer

IBM — India/Global Client - Tesco UK Retail Jul, 2018–Sep, 2025

• Led design and development of enterprise-scale Teradata EDW supporting 50+ subject areas, 5TB+ of data using SQL and teradata utilities BTEQ, FLOAD, MLOAD, FEXPORT.

• Designed and implemented dimensional models for sales, finance, and customer analytics, enabling faster reporting and self-service BI adoption using Teradata sql.

• Performed Teradata SQL performance tuning (stats, partitions, indexes, workload groups) reducing batch runtime by 40%.

• Maintained and developed CA7-scheduled production jobs supporting critical data extraction processes.

• Created and updated JCL procedures for batch execution, file movement, and data transformation.

• Migrated legacy-based warehouse into Teradata -sql platform with zero data loss.

• Led a support team in 'Tesco' project which is responsible for Monitoring applications 24/7, Providing DB recommendations to perform better and faster by saving database space and execution time.

•Working on getting new technologies into the application and work on migration activities for the same.

• Provided L2/L3 support for data warehouse applications.

• Mentored and led a team of 4 offshore developers, improving delivery velocity and quality. 1

Kalyani Atre

*******.****@*****.***

+1-925-***-****, Fremont, California

• Architected star schema models for supplier 360 view, supporting marketing and retention campaigns.

• Designed SCD Type 2 dimensions for capturing customer history, improving analytical accuracy.

• Automated ETL jobs Teradata load processes, increasing reliability and reducing manual effort.

• Coordinated UAT with business teams, ensuring data accuracy and compliance with reporting standards.

• Introduced Agile Scrum practices into data warehouse projects, improving sprint delivery by 20%.

• Utilized TPT, BTEQ, FastLoad, and MultiLoad utilities to design high-throughput ingestion and transformation frameworks.

• Developed architecture documentation, data flow diagrams, lineage, and technical specifications for enterprise use.

• Collaborated with IT and infrastructure teams to manage capacity planning, optimization, and high availability designs.

• Supported audit, compliance, and data governance requirements by enforcing metadata and quality frameworks.

Data Engineer

Accenture— India/ Sweden Client - Nordea European Bank Aug, 2010–Jul, 2018

• Involved in requirement analysis along with creating Technical Design document and mapping document.

• Have experience in FACT-dimension model development.

• Have experience in creating dimensions- SCD1, SCD2 using Microgen tool.

• Developed complex Teradata BTEQ scripts, macros, and stored procedures to support data transformation and reporting.

• Assisted in Teradata sql migration and upgrades from v12 to v14, ensuring system stability.

• Built performance-optimized fact tables and aggregates using sql to enhance reporting efficiency.

• Partnered with BI teams to provide validated datasets for dashboards and ad-hoc reporting.

• Designed optimized fact tables, aggregates, and semantic layers enabling faster BI and executive reporting.

• Worked closely with BI teams and data consumers to deliver validated, trusted datasets for dashboards and analytics.

• End to end experience in development work of sourcing data, starting from source file/table/view to Microgen Accounting Hub (MAH) to Stars Semantic Layer (SSL) using Microgen tool and teradata sql.

• Deployment and package creation of different project and resolving errors found during deployment.

• Experience in Teradata Utilities (BTEQ,Fast Load, Multi Load).

• Development of streams to execute job using Batch scheduling tables and managing streams as per data dependency.

• Pro-actively work with Business and Support staff in problem analysis, reproduction, and resolution.

• Have worked on MAH GUI screen configuration.

Education & Certifications

• B.E., Computer Science, University of Pune, India (2010)

• Certifications: Teradata Professional Snowflake SnowPro Core Microgen Accounting Hub RPT QTP Key Achievements

• Successfully delivered 10+ large-scale Teradata EDW implementations across multiple industries.

• Reduced ETL load windows by 30–50% through optimization and automation.

• Recognized with award for excellence in delivery and stakeholder engagement. 2

Contact this candidate