Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL.Skilled in System Analysis, E-R/Dimensional Data Modeling, Database Design and implementing RDBMS specific features.Exposure to data analysis using MS Excel and SAS.Experience in gathering requirements and making BRD, FSD, and SRS documents.Worked in Data Warehouse Data &ETL Architecture, Oracle Database platform, Erwin Data Modeler, Informatica Power center and SSIS.A good understanding of Extract, Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.Implemented slowly changing dimension (SCD) type I and type II in dimensional modeling as per requirements.Experience in modeling Kimball and Inmon Data Warehousing environments.Well versed in Normalization (1NF, 2NF and 3NF) and De normalization techniques for optimum performance in relational and dimensional database environments.Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin data modeler, E - R Studio.
![ca erwin data modeler macros ca erwin data modeler macros](https://docs.oracle.com/cd/E92917_01/PDF/8.0.9.0.0/FSDF_HTML/UG/RH_FSDF_809_UG_files/image255.jpg)
Strong experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration management.Strong background in various Data Modeling tools using ERWIN, ER/Studio and Power Designer.
![ca erwin data modeler macros ca erwin data modeler macros](https://dbmstools.com/storage/screenshots/erwin-data-modeler-njhle7vwykawtlku.jpeg)
Expertise in Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Data Dictionary and Metadata.
![ca erwin data modeler macros ca erwin data modeler macros](https://www.storageware.co.cr/sites/default/files/styles/uc_product_full/public/field/product/erwin_overview01.png)