OLAP Tools: Microsoft Analysis Services, Business Objects.Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer.Exceptional communication and presentation skills and established track record of client interactions.Developed mapping spreadsheets for (ETL) team with source to target datamapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta- datadefinitions.Established and maintained comprehensive datamodel documentation including detailed descriptions of business entities, attributes, and datarelationships.Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise datastores within a metadata repository.Experience in extracting, transforming and loading ( ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.Facilitated datarequirement 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.Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
0 kommentar(er)
