![ca erwin data modeler pdf without watermarks ca erwin data modeler pdf without watermarks](https://toolbox.easeus.com/images/toolbox/pdf-editor/resource/icecream-pdf-editor-no-watermark.png)
Expertise in writing SQL queries and optimizing the queries in Oracle, SQL Server,Netezza, Hive& Teradata.Expertise in incorporating business requirements in quality conceptual, logicaldatamodels using ERStudio and created physicaldatamodels using forward engineering techniques to generate DDL scripts.
![ca erwin data modeler pdf without watermarks ca erwin data modeler pdf without watermarks](https://cdn.vdocument.in/img/1200x630/reader019/reader/2020041215/5b63e7a57f8b9a687e8c9ba9/r-1.jpg)
Extensive experience usingdatamodeling tools Erwin, ER/Studio, IBM info sphere, Power designer and Microsoft Visio.Experienced in data warehouse design, data modeling and database administration activities.Excellent experience in creating cloud based solutions and architecture using Amazon Web services and MicrosoftAzure.Expertise in database normalization method defined by E.F CODD (3NF-Third Normal Form).Experienced in Data loading using PL/SQL,SQL Server Integration Services packages (SSIS), OracleDataIntegrator (ODI) and developed dashboard reports usingSQLServerreporting services (SSRS).In-depth noledge of,SSAS, SSRS, SSIS, T-SQL, Reporting and Analytics.Created custom calculations Data Analysis Expressions (DAX) in Microsoft Power Pivot and in SSAS.Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/ SQL Server/DB2.Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, Tpump, Visual Explain, and Query man), Teradata parallel support and Unix Shell scripting.Excellent experience in designing transactional, dimensional, and multi - dimensional (cubes) data structures using data modeling tools such as Erwin, IBM Infosphere Data Architect and ErStudio.Experienced in data analysis anddataprofiling using complex SQL on various sources systems including Oracle, Teradata, Hive platforms.Over 11+Years of IT experience in Data Analysis, Data architecture, Application Design, Dimensional Data Modeling, Implementation and Testing of Enterprise Data Warehousing and Enterprise Database, Data Mining.