*Itesh Arora**: **Data Modeler/Architect/Analyst* * *
*Current Location: IL * *Availability: Immediate** * *Relocation: Open *** PROFESSIONAL SUMMARY · *8+ years* of experience in IT industry, with expertise in *Data Modeling, Data Analysis and Design.* · Dimensional Data Modeling experience using *ER/Studio, Erwin*, *Multidimensional Data Modeling Schema**- *Star Join Schema, Snowflake modeling, Fact & Dimension tables, Conceptual, Physical & Logical Data modeling. - Complete knowledge of Data Warehouse Methodologies Ralph Kimball & Bill Inmon Methodologies. Experienced in building *ODS, EDW*, Staging and maintaining metadata repository. · Expert in data analysis, design, development, implementation and design and code reviews for Extraction, Transformation and Loading (ETL). · Experience in conducting *Joint Application Development* (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis. Have also chaired many Rapid Application Development (RAD) sessions during the project period. · Strongly capable of handling VLRDB (*Very Large Relational Data Bases*) of about 15TB with expert level working knowledge of the architecture involved. · Expertise in Normalization/De normalization 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). - Expert at Full SDLC processes involving Requirements Gathering, Source Data Analysis, Creating Data Models, and *Source to target data mapping*, DDL generation, *performance tuning* for data models. · Strong working knowledge and background in multiple databases such as Oracle, SQL Server, DB2, and Sybase. · Strong experience in writing SQL and PL/SQL, Transact SQL programs for Stored Procedures, Triggers and Functions. - Responsible for interacting with business users to identify information needs and business requirements for reports. - A very good understanding of different working domains like* Financial, Banking, Insurance, Health Care* and capable of blending in any environment. - Excellent team member with interpersonal and communication skills, highly motivated, result oriented with strong analytical, organizational, presentation and problem solving skills. - Expert in developing effective working relationships with client team to understand support requirements, developed tactical and strategic plans to implement technology solutions, and effectively manage client expectation. Thanks and Regards, Mamatha 630 364 1917 [email protected] -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
