Initiate and maintain client relationships, anticipate and identify client issues/concerns and propose appropriate solutions.Created domains to ensure teh data elements can be assigned to domains across teh enterprise models.
Used teh complete compare option in Erwin to make sure teh data model is synchronized wif teh database.Reverse engineered teh data model into Erwin by using database script file.
Implemented partitions for tables in database and testing teh partition elimination in execution plans.Looked at teh execution plan to analyze teh optimizer execution path for a query and recommended additional indexes if needed for improving performance and query tuning.Run teh table scripts generated using Forward Engineering in Erwin wifin SQL Server Management Studio to create teh tables and corresponding views.Detailed study and data profiling of all underlying source systems of teh subject areas to deliver a data model that adheres to enterprise standards.Conceptualize teh business requirements and tan design teh logical and physical models for target database.Part of Confidential Enterprise Market Risk Technology group on Market Risk and Risk Insight projects using skill set required that includes SQL Server 2008, SQL Server 2012, Data Modeling using Erwin.Other Tools: TOAD, Visual Studio, Aginity Netezza, DB Artisan, SQL Developer management studio 2012, Alation, SVN,Jira,MS Excel Programming Languages: C, SQL, PL/SQL, Python 2.7.12ĭatabases: ORACLE, MYSQL, SQL Server, DB2Host, DB2 LUW, Teradata 15.x and Netezza, NoSQLĭata Analysis Tools and packages: Hive, Anaconda, Tableau Desktop, Python’s Pandas, Numpy, Matplotlib Accompanying skills include data analysis and data profiling using SQL, ETL mapping, data analysis using Python.ĭata Modeling Tools: Erwin9.64, E/R Studio, MS Visio, Oracle Designer, IDA 7.6, RTC Client.Data Modeling experience of more TEMPthan 8 years wif expertise in modeling for OLTP, data warehouse and data mart applications using data modeling tools like Erwin, E/R Studio, IBM Data Architect.