Anil Kumar Mandapaka

• Developed and optimized ETL workflows in Alteryx to process and transform large datasets efficiently.
• Designed Quick Sight dashboards for Operational Excellence, enabling self-service analytics and real-time insights.
• Automated Alteryx workflows with Python scripts, reducing manual intervention and improving efficiency.
• Implemented data governance and security best practices to ensure compliance with organizational standards.
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
• Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.

Client : Amazon - PXT- WSTT DNA (2023 June – 2024 Feb)

• Implemented cost optimization strategies for Glue jobs, resulting in a reduction in expenses related to data loading from Amazon S3 to Redshift
• Developed a data transfer utility using AWS Glue to efficiently copy data from S3 to Redshift, improving data ingestion processes and reducing latency
• Created a monitoring tool to detect Redshift table skewness and automatically notify stakeholders via email, ensuring optimal data distribution and query performance
• Established a system to deliver Glue job run history to the team, promoting transparency and collaboration, with data stored in Amazon S3 for future analysis and reference
• Collaborated with cross-functional teams to gather requirements, design solutions, and implement data engineering best practices

Client : Expedia Group- HR Data Mart (2018 Aug – 2023 June)

• · Managed multiple high-impact projects, transforming raw data into actionable insights for strategic decision-making. Developed 25+ Tableau dashboards, automating reporting workflows, and improving data availability for business teams.
• · Designed efficient data models using dimensional modeling and optimized dashboard performance by integrating data from multiple sources. Built insights on recruiting, attrition, promotions, salary analysis, and employee status using Tableau and Power BI.
• · Worked with cross-functional teams, stakeholders, and offshore teams to gather requirements, document processes, and establish coding best practices. Led Tableau to Power BI migration, enabling a seamless transition from on-prem to cloud-based analytics.

Client : AccuWeather-Global Weather Data Migration(2017 Dec – 2018 Aug)

• Developed Python scripts to extract live and historical data from APIs (Google BigQuery, Ooyala, New Relic, AccuWeather Live) and processed the data in Data bricks (Hadoop) for correlation and analysis.
• Built Azure Data Factory pipelines, integrated batch processing, and utilized Azure Data Lake & Blob Storage for data storage and automation. Created SQL queries to retrieve data from Google BigQuery.
• Designed and analyzed visualizations in Tableau and Amazon Quick Sight, implementing row-level security to restrict data visibility for enhanced reporting and insights.