Kirtankumar Patel

. Over 7+ Years of working experience as Data Analyst including Data Development, Implementation and Maintenance of databases and software applications. Solid Excellent experience in creating Conceptual, Logical and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP) systems. Experienced working with Cloud Data warehouse Snowflake. Built and maintained data warehousing solutions Developed and optimized SQL queries and stored procedures Designed and implemented a data archiving strategy Built a data validation framework Implemented a data catalog using Snowflake metadata tables, resulting in improved data discovery and accessibility Designed, developed, and maintained high-performance Snowflake databases and data warehouses Optimized complex data processes Collaborated with a team of professionals across departments Excellent proficiency in Agile/Scrum and waterfall methodologies. Implemented business logic using store procedures, TSQL and Triggers (DML and DDL). Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features. Having good experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments. Expert in Data Warehousing techniques for Data Cleansing. Good experience in working with different reporting tool environments like SQL Server Reporting Services (SSRS), Cognos and Business Objects. Experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems. . Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Power Designer and MDM. Strong knowledge on data profiling, data standardization, transformation, cleansing and best practices to apply on high volume data. . Experience in data analysis to track data quality and for detecting/correcting inaccurate data from the databases.