Yadi R

Datawarehouse Designer - 9 Years of Experience


Datawarehouse Designer

Education Level:


Will Relocate:



PROFESSIONAL SUMMARY: * 9+ years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in Online Transactional processing (OLTP) and Online Analytical Processing (OLAP), Data Warehousing and ETL Environment. * Experienced in developing Conceptual, logical models and physical database design for OLTP and OLAPsystems using ERstudio, ERwin and Sybase Power Designer. * Expertise in ERwin, Star schema and Snowflake schema, FACT & Dimensions tables, Physical & logical data modeling and Oracle Designer, Power Designer and ER Studio. * Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse. * Experienced in identifying entities, attributes, metrics and relationships also assigning keys and optimizing the model. * Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and ORACLE, SQL Server, Greenplum and other relational and non-relational databases. * Experienced in conducting JAD sessions for understanding and gathering the business requirements to create Data mapping documents, use cases, work flows and Power Point presentations, write functional specifications and queries. * Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies. * Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL, PG Admin. * Performance tuning and query optimization techniques in transactional and data warehouse environments. * Strongly capable of handling VLRDB (Very Large Relational Data Bases) of about 5TB with expert level working knowledge of the architecture involved. * Expertise in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments. * Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions). * Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository. * Managed full SDLC processes involving requirements management, workflow analysis, source data analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model. * Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository. * Strong experience in development and design of ETL methodology designing various sources to target mappings for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Mart/Power Center and SSIS. * Expert level understanding of using different databases in combinations for Data extraction and loading, joining data extracted from different databases and loading to a specific database. * Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments. * Created/ modified reports and dashboards using BI Analytics. * Well versed in system analysis, Relational and Dimensional Modeling, Database design and implementing RDBMS specific features. * Extensive experience analyzing and documenting business requirements and system functional specifications including use cases facilitated and participated in Joint Application Development (JAD) * Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle.