Yashwanth Amula

Yashwanth Amula Email and Phone Number

Experienced Data Engineer | Python, SQL & PySpark Expert | Big Data Solutions & Azure Specialist @ Caterpillar Inc.
deerfield, illinois, united states
Yashwanth Amula's Location
Dallas, Texas, United States, United States
About Yashwanth Amula

Data Engineer with 3+ years of experience in designing and managing data solutions. Proficient in Python, SQL, and PySpark, with extensive knowledge of MySQL, PostgreSQL, MongoDB, and other databases. Experienced in big data technologies including Hadoop, Spark, and Kafka, and skilled in using Azure services and BI tools like Tableau and Power BI. Adept in data cleaning, wrangling, and predictive analysis, with strong abilities in data modeling, visualization, and ETL processes. Effective communicator and problem-solver with a track record of enhancing data workflows and driving project success.

Yashwanth Amula's Current Company Details
Caterpillar Inc.

Caterpillar Inc.

View
Experienced Data Engineer | Python, SQL & PySpark Expert | Big Data Solutions & Azure Specialist
deerfield, illinois, united states
Website:
caterpillar.com
Employees:
50927
Yashwanth Amula Work Experience Details
  • Caterpillar Inc.
    Data Engineer
    Caterpillar Inc. Aug 2022 - Present
    United States
    • Successfully implemented data migration of multistate-level data from SQL Server to Snowflake using Python and SnowSQL, resulting in a 40% improvement in data retrieval times and streamlined access.• Designed and developed interactive data-driven reports and dashboards using Tableau, presenting insights to the leadership team and enhancing decision-making processes by 30%.• Orchestrated the migration of large datasets to Redshift from Teradata and AWS S3, resulting in a 30% reduction… Show more • Successfully implemented data migration of multistate-level data from SQL Server to Snowflake using Python and SnowSQL, resulting in a 40% improvement in data retrieval times and streamlined access.• Designed and developed interactive data-driven reports and dashboards using Tableau, presenting insights to the leadership team and enhancing decision-making processes by 30%.• Orchestrated the migration of large datasets to Redshift from Teradata and AWS S3, resulting in a 30% reduction in query response time, enhancing the overall performance of analytical reporting tools for end-users.• Developed and optimized Python scripts for ETL workflows, leveraging Apache Airflow for workflow management, leading to a 35% reduction in manual data processing tasks.• Conducted predictive analysis with Tableau on daily incoming data, enabling more accurate forecasting and decision-making, resulting in a 20% improvement in predictive accuracy.• Managed and modeled data using Python and various statistical analysis packages, ensuring accurate data representation and a 15% increase in data reliability.• Designed an automated process for code builds and deployments using Python, enhancing deployment speed and reducing errors by 40%.• Implemented end-to-end CI/CD pipeline by integrating Jenkins and AWS for VM provisioning, utilizing Agile and SDLC methodologies to ensure continuous integration and delivery, improving deployment frequency by 30%.• Leveraged Git and GitHub for version control and collaboration, ensuring code quality and facilitating team coordination. Show less
  • Doublene
    Data Engineer
    Doublene Aug 2019 - Jun 2021
    India
    • Led the planning and development of roadmaps for migrating existing SSIS on-premises systems to Azure Cloud within an Agile framework, improving migration efficiency by 30%.• Architected and executed ETL data movement solutions for 1 petabyte of data using Azure Data Factory, achieving a 40% increase in data processing throughput.• Managed Azure Data Lakes (ADLS) and Data Lake Analytics, integrating with other Azure Services to streamline data workflows and enhance data… Show more • Led the planning and development of roadmaps for migrating existing SSIS on-premises systems to Azure Cloud within an Agile framework, improving migration efficiency by 30%.• Architected and executed ETL data movement solutions for 1 petabyte of data using Azure Data Factory, achieving a 40% increase in data processing throughput.• Managed Azure Data Lakes (ADLS) and Data Lake Analytics, integrating with other Azure Services to streamline data workflows and enhance data accessibility.• Created Power BI visualizations and dashboards, presenting actionable insights to leadership and boosting profitability by 25% through enhanced data visibility and decision-making.• Utilized Azure Databricks for complex data manipulation and transformation using PySpark, reducing data processing times by 35%.• Employed complex SQL window functions to analyze and enhance data accuracy, improving the reliability of existing data pipelines by 20%.• Constructed and maintained ETL pipelines in and out of the data warehouse and created major regulatory and financial reports using advanced SQL queries in Snowflake, increasing reporting efficiency by 30%.• Prepared ETL workflows using Alteryx and Tableau Prep, reducing pre-processing time by approximately 80% and enhancing overall data handling efficiency.• Administered and optimized databases on Amazon RDS, ensuring high availability and performance tuning, and improving backup and recovery processes by 25%.• Created comprehensive documentation for data processes, architectures, and pipelines, enhancing team understanding and knowledge sharing.• Led data projects from conception to deployment, applying project management and risk management skills to ensure timely and successful project delivery.• Architected event-driven architectures to automatically trigger data processing tasks based on incoming data streams, increasing process automation and responsiveness by 30%. Show less

Yashwanth Amula Education Details

Frequently Asked Questions about Yashwanth Amula

What company does Yashwanth Amula work for?

Yashwanth Amula works for Caterpillar Inc.

What is Yashwanth Amula's role at the current company?

Yashwanth Amula's current role is Experienced Data Engineer | Python, SQL & PySpark Expert | Big Data Solutions & Azure Specialist.

What schools did Yashwanth Amula attend?

Yashwanth Amula attended Missouri State University, Jawaharlal Nehru Technological University.

Who are Yashwanth Amula's colleagues?

Yashwanth Amula's colleagues are Jothilakshmi Cscp, Pmp, Jesus Roberto Rodriguez, Evelyn Francisco, Liu Herry, Gwang Suparerk, Danny E., Todd Fortman.

Not the Yashwanth Amula you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.