Data Modeler - Short term contract

Role

Data Modeler Location

New York City, NY Duration

3--4 Months to start Domain Knowledge

• P&C Insurance Mandatory Experience
• 10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Warehousing (OLAP)/Business Intelligence (BI) applications and Data Analysis for Online Transaction Processing (OLTP).
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Exceptional communication and presentation skills and established track record of client interactions Technical Skills

Data Modeling Tools

Erwin and ER studio

OLAP Tools

SAP Business Objects

ETL Tools

Microsoft SSIS and Informatica 7.1.3

Database Tools

Microsoft SQL Server 2000/2005/2008,2012

Packages

Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects

Operating Systems

Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Technical Skills

Data Modeling Tools

Erwin and ER studio

OLAP Tools

SAP Business Objects

ETL Tools

Microsoft SSIS and Informatica 7.1.3

Database Tools

Microsoft SQL Server 2000/2005/2008,2012

Packages

Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects

Operating Systems

Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Warm Regards

Ravi Jaiswal

Pyramid Consulting, Inc.

Associate Manager Resourcing

________________________________________

O

770-255-3104 M

404-891-0420