Vaishnavi Shahu

Experience

• 

  Cognizant

  Jul 2021 - Oct 2022

  Programmer Analyst

  • Collaborated with the Team Leaders, Business Analyst and Stakeholders for understanding the business and functional requirements.• Worked closely with team to analyze SQL server database relationships and helped to redesign the schema to develop Cassandra database.• Reviewed and analyzed data on database using SQL queries.• Participated in a highly collaborative team environment, contributed to all phases of the development lifecycle using Agile methodologies.• Prepared data reports using analytical tools and used different features like filters, vlook-ups, pivot, etc Show less

• 

  Futurense Technologies

  Mar 2023 - now

  Data Specialist

  • Executed an end-to-end Big Data project focused on Stock Market Analysis.• Constructed data pipelines employing Sqoop and MySQL JDBC connectors.• Utilized the powerful capabilities of Hive, PySpark, Spark SQL, and Spark Streaming for comprehensive data analysis.• Extracted valuable insights from the analysis.• Proficient in SQL as a powerful tool for managing and querying relational databases working with aggregate functions, subqueries, window functions, CTEs.• Optimizing SQL queries to reduce run time and increase performance using Indexing, Store procedure & functions.•Executed an end-to-end Big Data project focused on Stock Market Analysis. • Constructed data pipelines employing Sqoop and MySQL JDBC connectors. •Utilized the powerful capabilities of Hive, PySpark, Spark SQL, and Spark Streaming for comprehensive data analysis.• Extracted valuable insights from the analysis. •Proficient in SQL as a powerful tool for managing and querying relational databases working with aggregate functions, subqueries, window functions, CTEs.• Optimizing SQL queries to reduce run time and increase performance using Indexing, Store procedure & functions. Show less