Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Rachana Malhotra | Elance
 
176985602337900
Last Sign-in: Jan 11, 2012

Rachana Malhotra

Data Modeler, Data Warehousing, ETL, Reports DBA
   India
  |   Hyderabad, Andhra Pradesh

Overview

- Database & BI Solution Architect


AREAS OF STRENGTH
- Enterprise Data Warehouse Models using ERwin(Inmon & Kimball approaches)
- Logical Data Model (LDM) and Physical Data Models for OLTP (Entity & Attributes, using Normalization)
- Star & Snowflake Schemas Data Models for Data Warehousing using Dimensional techniques.(Ralph Kimball Methodology)
- Customized Data Extraction, Transformation and Loading ETL Tools, Loading Strategies, Designing Metadata Repositories, Data Quality Analysis
- Ad-hoc Reporting & On-line...

Read More »

Skills (2)

Tested
Data Modeling
Data Warehousing

Service Description

• Translated business requirements into working logical & physical data models for OLTP, Data Warehouse, Data Marts & OLAP applications.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN and ER Studio. Used Dimensional modeling technique using Ralph Kimball Methodology
• Lead development of Logical and Physical Data Models (LDM & PDM) in Third normal form for Telecom Enterprise Data Warehouse using Bill Inmon approach..
• Designed Data Models for OLTP Systems using Erwin & ER Studio. Identified Entity Attributes and Relationships (ER Diagrams) using Erwin and ER Studio. Used Normalization Rules to achieve Second and Third Normal form
• Defined Conformed Dimensions, Facts and Aggregates. Transformed Logical Data Models to Physical Database design. Generated DDL scripts to create database objects.
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conducted following phases Data Warehouse Life Cycle
Business Requirements and Analysis
Source System Study
Data Modeling - Star & Snowflake Schemas
Designing Metadata Repository
Data Quality Analysis and Extraction, Transformation and Loading (ETL)
Ad-hoc Reporting and OLAP
Exposure to Data Mining
• Designed Data Marts for Customer Win Back & Retention, Click Stream Analysis, Sales Order and Risk Containment Analysis.
• Designed Multi-Dimensional cubes for OLAP...

Read More »

Keywords

database
report
ETL
datawarehousing
Business Intelligence
My Snapshot
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
rachanam
Type
Individual
Member Since
March 2008
Elance URL
Verifications
0
Rachana Malhotra | Elance

Rachana Malhotra