Resume: Cathryn Mitchell, Systems Analyst - Data Modeler Cathryn Mitchell PROFESSIONAL SUMMARY * 20+ years experience in data management, administration, and analysis * 15+ years relational data modeling and database design * Enterprise, ODS, dimensional, and Corporate modeling * Application and Development DBA (proprietary Oracle), Oracle development and consulting support functions. ![]() PROFESSIONAL SUMMARY • 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. • 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. • Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments. • Facilitated datarequirement meetings with business and technical stakeholders and resolved conflicts to drive decisions. Data Modeler / Data Analyst Resume,Sr. Data Modeler / Data Analyst CV. TMS Data Modeler The ultimate tool for modeling databases with an easy and. A Sentiment Treebank. ![]() • 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 datastores within a metadata repository. • Established and maintained comprehensive datamodel documentation including detailed descriptions of business entities, attributes, and datarelationships. • Developed mapping spreadsheets for (ETL) team with source to target datamapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta- datadefinitions. • Exceptional communication and presentation skills and established track record of client interactions Technical Skills • Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer • OLAP Tools: Microsoft Analysis Services, Business Objects • ETL Tools: Microsoft SSIS and Informatica 7.1.3 • Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML • Database Tools: Microsoft SQL Server 2000/2005/2008, DB2, Oracle 10g/9i, MS Access, Teradata.
0 Comments
Leave a Reply. |
Details
АвторНапишите что-нибудь о себе. Не надо ничего особенного, просто общие данные. АрхивыКатегории |