ĭata Modeler/Business Data Analyst, 03/2016 to 10/2019 SKILLS: Erwin Data Modeler 9.64, SQL Server Management Studio 17, Snowflake 3.52.2, AWS Cloud Platform, Talend Solution Environment 7.1, Jira 8.2, Oracle Database, Oracle SQL Developer. Assist developers, ETL team, BI team and end users to understand the data model. Check to see data models and database are in sync.Generate DDL for data model and co-ordinate with DBAs to create database.Review the data model with functional and technical team. Create tables, indexes, views, snap shots, database links extracted from SQL.Work with Erwin to do reverse engineering of database for reporting purpose.Give Sprint Demo during Product team meetings.Sound RDBMS concepts and worked with Snowflake, Oracle, SQL Server Management Studio.Created and altered tables in target Snowflake dev environment and made sure they are deployed in prod environment after getting approval from UAT.Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.Assist ETL developers while data loading to understand the STTM, handle UAT bugs by coordinating with business team.Involve in defining source to target data mappings (STTM).
Work as a Data Modeler in Agile Environment and update the existing system files and data models.Provide quality documentation, status updates. Analyze Business requirements, procedures, and problems to come up with solution by interacting with Solution Designer.Projects: Target: Snowflake DB running on AWS, Sources: AKC, OSI, Eloqua and Google360. Data Modeler/ Data Analyst, 11/2019 to Current