VIVEK PARIHAR

Designed and developed data vault models and implemented data warehousing solutions to support business requirements. Designed and optimized SQL queries and stored procedures for efficient data retrieval and manipulation. Leveraged Snowflake platform and utilized meta-data driven stored procedures to perform intricate data transformations and calculations, enabling real-time analytics and reporting capabilities. Reduced Snowflake computation cost by 50% by creating a stored procedure to replicate schema changes in the source database using the source information schema pulled through Azure Data Factory (ADF). Implemented end-to-end ETL pipelines using Azure Data Factory, extracting, transforming, and loading data from diverse sources, resulting in streamlined data integration and improved data availability. Engaged in extensive collaboration with stakeholders, fostering productive relationships with business users and data analysts to gain comprehensive understanding of their data requirements and deliver effective data solutions in alignment with their objectives. Developed and implemented SCD Type 2 methodology to track historical changes in dimension data, providing a comprehensive historical view for analysis and reporting. Honored with a certificate of appreciation in acknowledgment of substantial contributions and unwavering commitment.

Relevant Coursework: Data Structures and Algorithms (DSA), Database Management Systems (DBMS), Object-Oriented Programming (OOP).