Analyzed and worked on raw analytical data in various formats such as CSV, JSON, XML, and EXCEL flat files.• Extracted and processed data from a excel to SQL Server database using Python.• Developed best practices for database design and development activities. Fixed any issues related to database performance and provided corrective measures.• Collaborated with cross-functional teams to extract, consolidate, and transform raw data from various sources into Microsoft Power BI. By creating interactive data visuals and reports.• Conducted meticulous cleaning and preprocessing, integrating current and historical data.• Built and maintained SQL scripts stored procedures• Built an app using streamlit library to collect data from opensource using API and visualize using matplotlib library.• Effectively utilized python utilities and webscraping for implementing customer requirements.• Hands on experience in snowflake environment and Generative AI for data analysis