asfenea.blogg.se - Erwin data modeler conceptual

#Erwin data modeler conceptual software#
#Erwin data modeler conceptual windows#

Operating Systems: Microsoft Windows 9x / NT / 2000/XP / Vista/7 and UNIX.Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.Database Tools: Microsoft SQL Server 2000/2008, Teradata, Oracle 10g/9i, and MS Access.Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, VB.NET.ETL Tools: Microsoft DTS/SSIS, SSRS and Informatica 7.1.3.OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9.Data Modeling Tools: Erwin r9, Erwin r8, Erwin r7.1/7.2, Rational Rose 2000, ER Studio and Oracle Designer.A good expertise in Extract Transform and Load ETL data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service DTS and Informatica.Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.

Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.Good experience in data transformation, data mapping from source to target database schemas and also data cleansing.Hands on experience in migrating database application from legacy to newer technology, data movement, data mapping.Experience in RDBMS Oracle PL/SQL, SQL, Stored Procedures, Functions, Packages, Triggers worked with Terra bytes of Volume databases.

#Erwin data modeler conceptual software#

Experience on various Software Development Life Cycles including Analysis, Design, Development and Testing to solidify client requirements in conjunction with Software Developers.Experience in integration of various data sources with multiple Relational Databases like SQL Server, Teradata, Oracle and DB2.Experience in implementing Data warehousing solutions involving Dimension modeling and Snow flake schema implementation 3 NF.

Experience in Informatica Power Center 9x/8.x/7x with Oracle 11g/9i/10g, SSIS and SQL Server Data Warehouse in Microsoft DW/BI environments.

Expertise in Gathering and Analyzing Information Requirements, Data Analysis, Data Architecture, Business E-R modeling, Dimensional Modeling, ETL Design.

Experience with Mainframe systems COBOL, JCL, CICS, VSAM, DB2, IMS, IDMS and also conversion of Mainframe data to ETL Staging tables.

Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.

Over 8 years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Dimensional Modeling, implementation and Support of various applications in OLTP and Data Warehousing.