Mudavath Ramesh Email & Phone Number

Irving, Tx, Us

Texas, United States

*Engineered and Automated ETL workflows using Apache Spark and Python, resulting in a 30% reduction in data processing time and improved data accuracy.*Designed and implemented ETL processes using SQL to extract data from various sources, including transaction databases, online interactions, social media, and customer support systems.*Led the development of a Comprehensive Customer Analytics Platform, utilizing SQL for data collection, integration, transformation, and analysis.*Developed SQL queries and scripts for in-depth data analysis, calculating KPIs, and deriving actionable insights for stakeholders.*Collaborated with teams to integrate SQL-based visualization tools like Tableau for creating interactive dashboards displaying customer behaviors, sales trends, and marketing campaign effectiveness.*Implemented CI/CD for data pipelines using AWS Data Pipeline and Airflow, achieved a 20% reducing deployment time.*Integrated Python with AWS Lambda for serverless data processing, decreasing infrastructure costs by 15%.*Leveraged AWS Glue to automate ETL processes for daily sales data feeds, reducing processing time by approximately 50%.*Built a Databricks to build a scalable data lake, ingesting and processing 2 terabytes of financial data, including historical market data, customer transactions, and risk assessments.*Designed and Automated efficient data pipelines that parsed and stored raw data into partitioned Hive tables, improving data retrieval for reporting and analysis by 15%.

India

*Employed automation processes using AWS tools like CloudFormation and Elastic Beanstalk, reducing infrastructure setup time and improving team productivity by 25%.*Spearheaded a benchmark using Spark and Scala APIs to compare Spark against Hive and SQL, achieving a 30% performance improvement for data processing tasks.*Utilized SQL queries for data transformation and enrichment, including aggregations, filtering, and integration of external datasets for enriching customer profiles.*Designed an efficient data model using SQL for storing processed and enriched data, optimizing indexes for fast querying and storage efficiency.*Designed and executed Hive tables to store website log data in a structured format, enabling efficient analysis with Apache Spark and reducing data processing time for marketing campaign performance analysis, leading to 35% faster identification of key insights.*Developed efficient ETL workflows using AWS Data Pipeline calculations for extraction, transformation, and loading, which reduced data processing time by 10%.*Utilized Spark SQL to pre-process, cleanse, and join terabytes of data, achieving an improvement in data quality metrics like minimized errors by 20%.*Led a cross-functional team to implement automated dashboards and reporting using Power BI, empowering stakeholders with data-driven insights, and a remarkable 25% improvement in workforce performance

Master'S Degree, Data Science, 3.4/4.0

Bachelor'S Degree