Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sourav Halepalya Aswathnarayan

Tampa

Summary

Results-driven Data Engineer with over 4 years of experience specializing in designing and optimizing data pipelines, strategic cloud migrations, and advanced data modeling. Proven expertise in cloud technologies, real-time analytics, and data governance. Effective leader and mentor, adept at delivering cost-effective solutions that significantly enhance organizational efficiency and data reliability.

Overview

4
4
years of professional experience

Work History

Data Engineer

Actabl
01.2022 - Current
  • Led comprehensive migration of data pipelines from Azure Data Factory (ADF) to Fivetran, managing Proof of Concepts, planning, and execution phases.
  • Maintained and enhanced existing DBT architecture through customized macros.
  • Acted as Product Manager, creating user stories, managing agile processes, and ensuring smooth project execution.
  • Reduced operational pipeline costs by 50% through strategic implementation of Fivetran.
  • Transitioned from DBT Cloud to DBT Core, achieving monthly cost savings of approximately $1,000.
  • Addressed Snowflake view size limitations by developing dynamic DBT macros, effectively managing over 250 client datasets through efficient hierarchical child views.
  • Collaborated on ETL (Extract, Transform, Load) processes to maintain data integrity and ensure pipeline stability.
  • Improved query performance by 80% through rigorous fine-tuning and optimization of database structures.
  • Developed and implemented a robust in-house data validation solution and dashboards, significantly enhancing the accuracy and reliability of the pulse-letting system.
  • Mentored and trained 4 junior data engineers, markedly improving overall team productivity and knowledge sharing.
  • Engineered reliable data recovery solutions, ensuring over 90% data integrity in recovery scenarios.
  • Eliminated redundant data entries by 90%, streamlining processes and enhancing overall data accuracy.
  • Built real-time dashboards, boosting data flow efficiency by 85% and facilitating effective decision-making.
  • Designed and optimized scalable data models and database structures within Snowflake.
  • Enforced rigorous data security protocols and ensured compliance with privacy standards.
  • Collaborated closely with stakeholders to align data engineering solutions with business objectives and requirements.

Business Intelligence Analyst

Transcendent by Actabl
07.2021 - 06.2022
  • Optimized ETL processes using SQL Server Integration Services for datasets exceeding 10 TB.
  • Implemented comprehensive data governance protocols, achieving 96% accuracy.
  • Reduced data anomalies by 80% through efficient monitoring.
  • Managed Comcast Data Warehouse independently, demonstrating technical and project management expertise.
  • Automated data delivery processes, significantly improving scalability.
  • Developed intelligence-sharing dashboards providing company-wide access to collected data.
  • Seamlessly transitioned over 150 reports between various reporting tools.
  • Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
  • Designed customized data collection models tailored to specific visualization tasks.

Education

Master of Science - Engineering Management

NJIT
Newark, NJ
01.2021

Bachelor of Engineering - Computer Science

Dayananda Sagar College
01.2019

Skills

    Cloud & Data Platforms:

  • Azure Data Factory, Azure Synapse Analytics, Databricks, Amazon S3, Amazon Redshift, Snowflake, AWS Redshift, Google Cloud Platform
  • Fivetran, Stitch, Census, Apache Airflow

    • Data Warehousing & Databases:

  • Snowflake, Amazon Redshift, SQL Server, MySQL
  • Data Vault 20, Kimball Dimensional Modeling, Data Mesh, Data Lakehouse

    • Data Transformation & ETL/ELT:

  • DBT , SQL, Python (Pandas, NumPy, PySpark), Scala
  • SSIS (SQL Server Integration Services), Azure Data Factory, Fivetran, Stitch, Databricks Notebooks, Spark SQL

    • Programming Languages:

  • Python, SQL, R, C, C

    • Business Intelligence & Visualization:

  • Tableau, Power BI, Sisense, Looker

    • Version Control & CI/CD:

  • Azure DevOps , Github

Timeline

Data Engineer

Actabl
01.2022 - Current

Business Intelligence Analyst

Transcendent by Actabl
07.2021 - 06.2022

Bachelor of Engineering - Computer Science

Dayananda Sagar College

Master of Science - Engineering Management

NJIT

Similar Profiles

CREATE PROFILE