Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Community Service
Timeline
Generic

Chaitra Venkatesan

Austin

Summary

Accomplished Senior Data Engineer at Intel Corporation with expertise in Azure Data Factory and ETL optimization. Spearheaded cloud migration projects, enhancing data processing efficiency by 55%. Proven ability to unify siloed data and ensure high data quality, fostering data-driven decision-making and collaboration across teams.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Intel Corporation
Hillsboro
04.2022 - Current
  • Cloud Migration Leadership: Led the migration of a heavily consumed on-premises data model to a cloud-based architecture using Azure Databricks, Azure Data Factory, PySpark, Postgres, and Azure AI/ML, enhancing data processing efficiency and analytics capabilities.
  • Crucial Data Migration: Designed and executed a critical data migration from legacy systems to a new platform, ensuring a seamless user experience for downstream consumers using Azure cloud services.
  • Data Quality Ownership: Built data expertise and maintained data quality for allocated areas, ensuring high standards, and reliability.
  • Unified Siloed Data: Consolidated previously siloed data, improving accessibility for business users, and supporting data-driven decision-making.
  • ETL Pipeline Optimization: Re-architected and optimized an ETL pipeline using SSIS, reducing load time for 25 million records from 6 hours to 1 hour and 20 minutes, achieving a 55% performance boost and significant cost savings.
  • Improved Efficiency and Stability: Enhanced tabular model efficiency and stability by 70% through data architecture redesign, batch processing, and query optimization.
  • Supply Chain Integrated Environment: Designed infrastructure for the internal Supply Chain Integrated Environment, improving data quality, integrity, and ETL process efficiency.

Software Engineer

Intel Corporation
Hillsboro
12.2019 - 03.2022
  • Full-Stack Development: Developed front-end user interfaces, back-end logic, and database integration for internal software applications that automate Tapeout compute activities in Windows and Linux environments.
  • Stakeholder Training and Support: Trained stakeholders on the newly developed automation software system, created user-effective training modules, and provided continuous support during Tapeout operations.
  • Testing and Issue Resolution: Developed and tested various non-happy path use cases, implemented fixes for issues identified during testing, and ensured robust software performance.
  • Usability Improvements: Enhanced software system usability by simplifying business processes and improving query response times in specific UIs.

Data Engineer I

Dupaco Community Credit Union
Dubuque
12.2018 - 11.2019
  • Azure Data Warehouse Migration: Designed ETL jobs to move historical tables to Azure Data Warehouse, updating dimension tables, extracting changes, and performing full loads.
  • Cross-Department Collaboration: Collaborated with various departments to identify automation opportunities, assess data value, and enhance data utilization.
  • Process Simplification: Developed reusable jobs, complex mappings, and metadata to simplify business processes.
  • Performance Optimization: Implemented multi-thread execution and parallelization to improve job performance while loading large volumes of data.

Data Engineering Intern

Physicians Mutual
Omaha
06.2018 - 12.2018
  • ETL Development: Extracted data from Oracle and flat files, transformed it according to business requirements, and loaded it into target tables. Conducted unit testing to validate data across different testing environments.
  • Performance Tuning: Optimized performance at source, target, mapping, session, and system levels by analyzing and addressing data rejects.
  • Job Scheduling: Scheduled sequence and parallel jobs using DataStage Director, UNIX scripts, and scheduling tools.

Education

Master of Science - Management Information Systems

University of Nebraska at Omaha
Omaha, NE
08.2018

Bachelor of Engineering - Electronics and Communications Engineering

Anna University
Chennai, India
05.2015

Skills

  • Data Integration & ETL: Azure Data Factory, AWS Glue, DataStage, Informatica, Talend, SSIS
  • Data Storage Solutions: Azure Blob, Azure DataLake, Amazon S3, Amazon Redshift, Snowflake, MySQL, PostgreSQL, MongoDB
  • Data Processing Frameworks: Azure Databricks, Apache Spark, ETL/ELT pipelines
  • Business Intelligence & Analytics: Tableau, SAP Business Objects, Power BI
  • Programming Languages: SQL, Python
  • Development Tools: Microsoft Office Suite, Git, Linux, Azure DevOps

Certification

  • Microsoft Azure Data Engineering Associate, 01/01/24
  • Talend Data Integration Developer, 01/01/19
  • Talend Data Quality Steward, 01/01/19
  • Graduate Certificate in System Analysis & Design, 01/01/17

Accomplishments

  • Recipient of University of Nebraska at Omaha Advantage Scholarship.
  • Chief Executive Officer of Indian Student Association at University of Nebraska at Omaha.
  • Global Diplomat for International Studies and Programs at University of Nebraska at Omaha.
  • Graduate Senator for College of Information Science & Technology at University of Nebraska at Omaha.

Community Service

Make A Difference, India, 04/01/13 - 05/01/15, Led city operations in corporate sector and fund-raised 2.2 million for improving safety of children at-risk through the development of shelter homes and provision of education.

Timeline

Senior Data Engineer

Intel Corporation
04.2022 - Current

Software Engineer

Intel Corporation
12.2019 - 03.2022

Data Engineer I

Dupaco Community Credit Union
12.2018 - 11.2019

Data Engineering Intern

Physicians Mutual
06.2018 - 12.2018

Master of Science - Management Information Systems

University of Nebraska at Omaha

Bachelor of Engineering - Electronics and Communications Engineering

Anna University