*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. Thank you, *Mamatha Paladugu* *Libsys Inc **'IT Sharps'* Direct 630-364-1917 | Office 630-799-1556 | Fax 630-566-8689 [email protected] <[email protected]> | www.LibsysInc.com [image: View my profile on LinkedIn]<http://www.linkedin.com/in/mamathalibsys> *Award Winners * *#"Inc500: Fastest Growing Companies in America" #"Chicago's 101 Best & Brightest Companies To Work For" #"Deloitte: Technology Fast 500 in America" #"VII-100: Top 10 Fastest Growing in America" #"CRN: Fast Growth 100" #"Diversity Business: Top Small Business"* ************************************************************************************* The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at 630-799-1556 in Illinois ************************************************************************************* Any comments on my service, please reach out HR manager [email protected]<blocked::mailto:[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.
