Data Modeler/Analyst role to review business requirement and compose source to target data mapping documents. Extensively experience on Excel Pivot tables to run and analyze the result data set and perform UNIX scripting.Ĭonfidential - Research Triangle Park, NC.Perform extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.Excellent experience in writing and executing unit, system, integration and UAT scripts.Excellency in MS Excel with proficiency in Vlookups, Pivot Tables and understanding of VBA Macros.Experience in SQL and PL/SQL including all database objects: Stored procedures, stored functions.Excellent knowledge on creating reports on SAP Business Objects, Web reports for multiple data providers.Having good working experience in Data Vault which is used in maintain Historical Data in the Enterprise Data Warehouse.Experience in design and develop Reporting Data Models to support OLAP Business Intelligence reporting system.Proficient in writing DDL, DML commands using SQL developer and Toad.Design data marts using Ralph Kimball and Bill-Inmon dimensional data modeling techniques.Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.Strong experience working with conceptual, logical and physical data modeling considering Metadata standards.Hands on experience in SQL queries and optimizing the queries in Oracle, SQL Server, DB2, and Netezza.
Solid Excellent experience in creating cloud - based solutions and architecture using Amazon Web services, Amazon RDS, and Microsoft Azure.
Extensive experience of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile and RUP.Over 8+ years of working experience as a Data Modeler and Data Analyst with high proficiency in data modeling, data analysis, requirement gathering, design and support of various applications in OLTP and Data Warehouses.The Logical and Physical Data Model s from ERwin are converted to UML Class Models, Entity Relationship Models, or Data Models for Enterprise Architect, which are inserted into a new Package in an Enterprise Architect Project (EAP file or server database) using the API functions, o r via a XMI import file. In order to migrate Logical or Physical Dat a Models from CA ERwin Data Modeler to Enterprise Architect the TOOLBUS I nterface reads 1, or.erx files, or models from CA ERwin Model Manager (Model Mart).
The UML Class Models, Entity Relationship Models, or Data Models from Enterprise Architect are converted to Logical and Physical Data Models for CA Erwin Data Modeler, and an ERwin XML import file is generated. In order to migrate UML Class Models, Entity Relationship Models or Data Models from Enterprise Architect to CA ERwin Data Modeler, the TOOLBUS I nterface reads Packages from an Enterprise Architect Project (EAP file or server database) using the API functions, or it parses a XMI export file from Enterprise Architect alternatively.