Yeswanth Chamarthy Email & Phone Number

Tampa, Florida, United States

Tampa, Florida, United States

• Developed more than 10+ dashboards in Qlik Sense across finance and hospitality for tracking revenues, budget, GOP%, and acquisition.• Coordinated the development of a three-layered architecture in Qlik Sense, resulting in improving 60% efficiency.

Tampa, Florida, United States

• 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.

Chennai, Tamil Nadu, India

• 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.

Master'S Degree, Business Analytics And Information Systems, 3.93

Bachelor Of Technology - Btech, Mechanical Engineering, 3.81

Activities and Societies: IEI,SAE