 Leveraged Tableau to create insightful data visualizations, including bar graphs, line graphs, and heat maps, to effectively communicate data quality metrics for Snowflake and AWS S3 datasets. Participated in the SDLC process to ensure data considerations are integrated throughout the development cycle. Utilized Git for version control of data analysis scripts, ensuring reproducibility and collaboration with teammates. Collaborated with developers and data engineers using Jira for issue tracking and resolution related to data analysis. Partnered with business stakeholders to understand their data needs and designed a scalable data model to support the company's rapid growth and resulting in a 30% increase in data processing efficiency. Improved data quality of supplier delivery schedules by 15% through data cleaning techniques, leading to more accurate forecasts and reduced delays in product deliveries. Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy MySQL and SQL Server database systems.

 Utilized Informatica to build ETL pipelines, defining source/target mappings and sessions to efficiently extract, transform, and load data from diverse sources into staging tables. Monitored the performance of the Snowflake platform and implemented performance tuning strategies, optimizing SQL queries and troubleshooting performance issues, resulting in a 30% improvement in query performance and enhanced user experience. Used Power Query for data acquisition and transformation, DAX functions for advanced calculations and data manipulation, and various Power BI visuals (charts, graphs, KPIs, maps, etc.) to create clear and actionable dashboards. Developed and automated data pipelines to ingest data from diverse external sources (web pages, APIs) into the internal data warehouse (SQL Server, AWS). Accelerated data exploration by 33% using Python data visualization libraries like Matplotlib and Seaborn, enabling insights into data distributions and patterns. Implemented SSIS packages to automate the efficient movement and transformation of data, strictly adhering to best practices and performance optimization guidelines. Built and optimized Redshift dashboards to provide real-time insights to stakeholders, leading to a 15% increase in data-drivendecision-making.