Yeswanth Chamarthy

Experience

• 

  Tata Consultancy Services

  Apr 2019 - Aug 2022

  Data Engineer

  • Automated 8+ data ETL pipelines using Lambda, Glue, EMR, and step functions to migrate/store data across various sources like S3, Athena, and DynamoDB.• Improved app retention by 6% by developing / modifying KPIs that measure customer engagement using PowerBI to track user actions and usage patterns.• Implemented 12+ SSIS pipelines for seamless data migration across multiple sources (Snowflake, HubSpot).• Migrated Database from Microsoft SQL Server 2005 to Microsoft SQL Server 2019 using ETL.• Managed tickets in Jira and made documentation with confluence for every procedure we migrated along with improved qualities.• Managed various data sources and sinks in DataStage jobs, Enhanced code to leverage PySpark's extensive data source support (e.g., CSV, Parquet, Avro, JDBC) for reading and writing data, leading to a 40% data integration time.• Deployed Databricks jobs using PySpark and Scala to streamline and automate the daily data transfer tasks and produce Quicksight reports for consumption by various stakeholders.• Demonstrated expertise in crafting indexes, stored procedures in T SQL, and executing complex queries in MS SQL, minimizing joins and sub-queries for data retrieval and manipulation, enhancing performance by 20%.• Followed Agile methodologies and visualized the team performance every month using Tableau and Excel. Show less

• 

  University of South Florida Muma College of Business

  Feb 2023 - May 2024

  Research Assistant

  • Automated the report generation process within MS SQL(SSMS) by implementing an ETL pipeline using Apache Airflow, resulting in increased efficiency, and saving 1.5 hours daily.• Demonstrated exceptional data accuracy skills, with a precision rate of 95% in data validation and cleansing process.• Formulated statistical models like multiple regression, Tobit, and logistic regression in R and Python to track customer tipping behavior in restaurants, resulting in a revenue increase of 60k USD.• Developed Tableau dashboards to monitor student enrollment metrics in the hospitality sector. Show less

• 

  McKibbon Hospitality

  Jun 2024 - now

  Senior Business Analyst