Devi R

* [Link]@[Link] ) 610-
755-3446

EXPERIENCE SUMMARY

• Six plus years of professional experience in data analysis, data

modeling, design, development and implementation of OLTP,
Data Warehouse/Data Marts.
• Can effectively use CASE tools like Erwin, Power Designer and ER
Studio.
• Worked and extracted data from various database sources like
Oracle, MS SQL, PL/SQL, DB2 and Flat files.
• Strong Knowledge of SDLC methodology and project life cycle.
• Extensive experience to analyze and document business
requirements and system functional specifications including use
cases.
• Designed the data marts using the Ralph Kimball’s and Inmon
dimensional data mart modeling techniques.
• Well versed in system analysis, ER/Dimensional Modeling,
Database design and implementing RDBMS specific features.
• Created logical data model from the conceptual model and its
conversion into the physical database design using Erwin.
• Good in Normalization (1NF, 2NF, 3NF and
BCNF)/Denormalization techniques for effective and optimum
performance in OLTP and OLAP environments
• Efficient in data mart design and creation of cubes using
dimensional data modeling – identifying Facts and Dimensions,
Star Schema and Snowflake Schema.
• Responsible for designing Entity Relationship Diagrams (ERDs).
• Efficient in modeling using Erwin in both forward and reverse
engineering cases.
• Strong knowledge in Reporting tools like Cognos, Microsoft
Reporting Services and Crystal Reports.
• Having good knowledge about Informatica.
• Experience in data transformation, data mapping from source to
target database schemas and also data cleansing.
• Extensive experience in PL/SQL programming – Stored
Procedures, Functions, Packages and Triggers.
• Experience in providing technical support and preparing
technical documents for the end user.
• Experience in backend programming including schema and table
design, stored procedures, Triggers, Views, and Indexes.
 • Excellent communication, interpersonal, analytical skills and
strong ability to perform as part of a team.
• Excellent analytical, Inter-personal and communication skills with
a strong technical background.

TECHNICAL SKILLS

Languages : SQL, PL/SQL, PASCAL, COBOL, C, C++, Visual

Basic, .NET,

HTML, CSS, XML, Oracle 11g/10g/9i/8i,

MS Office

Operating Systems : Windows 95/98/NT/2000/XP, UNIX, MS-

DOS

ETL Tools : Informatica 8.1

Modeling Tools : ERWin r7.3, Power Designer, ER Studio,

Microsoft Visio

Reporting Tools : Crystal Reports 11, OBIEE [Link], Microsoft

Reporting

Services, Cognos, BO XIR3.1

PROFESSIONAL EXPERIENCE

First American Bank

Chicago, IL
Role: Data Modeler/Analyst
October 09 – July 10

First American is an Illinois-chartered, privately held, full-service bank

with nearly 50 Chicago area locations and more than $2.5 billion in
assets. It has the strength and stability that come from a consistent,
diversified earnings stream, strong internal equity generation, sound
asset quality, and a liquid and conservative balance sheet. The goal of
this project was to maintain the data warehouse that could support the
banks various reporting and information needs. Data was spread out in
multiple and diverse sources in databases located in different regions.
Dimensional modeling using the star schema architecture was
implemented to achieve the task.

Responsibilities:
 • Worked with the Business analyst and DBA for requirements
gathering, business analysis, testing and project coordination.
• Gathered and translated business requirements into detailed,
technical specifications, new features, and enhancements to
existing technical business functionality.
• Worked with the project manager to develop the project plan for
the first two phases of the project.
• Resolved the revolving issues by conducting and participating in
JAD sessions with the users, modelers, and developers.
• Conducted design discussions and meetings to come out with the
appropriate data mart.
• Developed the Star Schema for the proposed warehouse model
to meet the requirements.
• Enforced mandatory capture metadata during the logical phase
design.
• Identified the objects and relationships between the objects to
develop a logical model in ERWin tool and later translated the
model into physical model using Forward Engineering technique
in ERWin tool.
• Defined and processed the facts and dimensions.
• Created mapping documents using the Metadata extracted from
the Metadata repositories.
• Resolved the data type inconsistencies between the source
systems and the target system using the Mapping Documents.
• Used crystal Reports to generate reports.
• Created documentation and test cases, worked with users for
new module enhancements and testing.

Environment: SQL, SQL Server 2000/2005, Oracle 10g, Erwin r7.3,

Windows XP.

Roche Pharmaceuticals
Florence, SC
Role: Data Modeler/Analyst
February 09 – September 09

Roche discovers, develops and provides innovative diagnostic and

therapeutic products and services that deliver significant benefits to
patients and healthcare professionals – from early detection and
prevention of diseases to diagnosis, treatment and treatment
monitoring. Operations include research and development centers that
conduct leading-edge work in advancing disease detection and
treatment. The task of the project was to maintain historic data
warehouse that could support the company’s various reporting and
information needs. Data was spread out in multiple and diverse
sources in databases located in different regions.

Responsibilities:

• Key participant in gathering user requirements along with

business analysts.
• Transformed project data requirements into project data models
using ERWin.
• Designed the data marts in dimensional data modeling using star
and snowflake schemas.
• Conducted Design reviews with the business analysts, content
developers and DBA’s.
• Interacted with end users to identify relevant key dimensions
and measures.
• Redefined many attributes and relationships in the Reverse
Engineering Model and cleansed unwanted tables/columns as
part of data analysis responsibilities.
• Created templates from Report Builder of Erwin to generate Data
Dictionary from the models in HTML format.
• Provisions were made for ad-hoc querying and reporting using
Crystal Reports.
• Lead and integrated the work of the team members and resolved
the issues that are related to the project and other teams.
• Worked with the implementation team to ensure a smooth
transition from the Design to the Implementation Phase.
• Validated the model with response to questionnaire from the
analysts.
• Created documentation and set cases, worked with users for new
module enhancements and testing.

Environment: Windows XP/2000, Oracle 10g, PL/SQL, ERWin r7.3,

Triggers, Stored Procedures, Packages, Functions, Crystal Reports, MS
Access, MS Excel.

National City Bank

Erie, PA
Role: Data Modeler/Analyst
May 08 – January 09

National City Bank provides customary retail and commercial banking

and trust services to its customers, including checking and savings
accounts, commercial loans, personal loans, real estate mortgage
loans, installment loans, individual retirement accounts, and employee
benefits. The project included upgrading an existing data warehouse
pertaining to Equity and Mortgage related data. The main objective of
the project was to enhance reporting abilities to effectively forecast
and manage risks involved in the business.

Responsibilities:

• Gathered and translated business requirements into detailed,

technical specifications, new features, and enhancements to
existing technical business functionality.
• Worked with the project manager to develop the project plan for
the first two phases of the project.
• Resolved the revolving issues by conducting and participating in
JAD sessions with the users, modelers, and developers.
• Conducted design discussions and meetings to come out with the
appropriate data mart.
• Developed the Star Schema for the proposed warehouse model
to meet the requirements.
• Enforced mandatory capture metadata during the logical phase
design.
• Identified the objects and relationships between the objects to
develop a logical model in ERWin tool and later translated the
model into physical model using Forward Engineering technique
in ERWin tool.
• Defined and processed the facts and dimensions.
• Created mapping documents using the Metadata extracted from
the Metadata repositories.
• Resolved the data type inconsistencies between the source
systems and the target system using the Mapping Documents.
• Used crystal Reports to generate reports.
• Created documentation and test cases, worked with users for
new module enhancements and testing.

Environment: Windows NT/2000, SQL Server 2000/2005, Oracle 9i,

Crystal Reports, DB2, ERWin, ER Studio.

Wesley Medical Center

Hattiesburg, MS
Role: Data Modeler/Analyst
September 07 – April 08

A full-service hospital, Wesley is prepared to meet your health care

needs. Our quality care is rated high by outside organizations, as well
as the leading hospital accreditation organization. Developed data
warehouse to assist claim professionals to analyze and administrate
the claims in an efficient manner. The operational data came from
multiple sources and was then loaded into data warehouse.

Responsibilities:

• Gathered the business requirements by conducting a series of

meetings with business users.
• Involved in business process modeling using ERWin.
• Created logical data model from the conceptual model and it’s
conversion into the physical database design.
• Extensively used Star Schema methodologies in building and
designing the logical data model into Dimensional Models.
• Used Sybase Power Designer tool for relational database and
dimensional data warehouse designs.
• Created Entity-Relationship diagrams, functional decomposition
diagrams and data flow diagrams.
• Used Sybase Power Designer for creating tables.
• Created documentation and test cases, worked with users for
new module enhancements and testing.
• Normalized the database up to 3NF to put them into the Star
Schema of the data warehouse.
• Worked with business analyst to design weekly reports using
Cognos Report Net.
• Understood existing data model and documented the
performance of the system.
• Validated the model with response to questionnaire from analyst.

Environment: Windows NT, SQL, Oracle, Sybase Power Designer 12.5,

ERWin, Cognos.

Cotton States Insurance

Atlanta, GA
Role: Data Modeler/Data Analyst
November 06 – August 07

Cotton States Insurance is an insurance firm serving individuals with a

wide range of insurance products and insurance related services. It has
a wide range of Insurance Products that include Auto Insurance, Home
owners Insurance and Life Insurance. Clients Management Systems
provides the technology that assists claim professionals in
administrating claim practices in a timely and effective manner. The
application involved in the design and development of the data
warehouse.

Responsibilities:
 • Involved in the creation of naming standards file.
• Involved in the creation of data mapping documents.
• Conducted data mapping document reviews with ETL team.
• Created change requests for the changes to be made to the data
models.
• Interacted with the business requirements team to gather
requirements.
• Involved in the analysis of requirements.
• Generated DDL Scripts to be implemented in the database.
• Reverse Engineered databases to created data models.
• Involved in the synchronization of the databases with the data
models.
• Involved in migrating the project related tables from one
environment to the other.
• Created conceptual data models.
• Involved in logical and physical data modeling.
• Assisted the DBA in creating tables and indexes.
• Used Reverse Engineering in ERWin to make models from pre-
existing databases to refine and fine tune them according to new
specifications.
• Maintained a repository for storing the models.
• Maintained subject areas of the models.

Environment: Oracle, MS Visio, SQL, SQL Server 2000, DTS, ERWin,

Crystal Reports, MS Excel.

B & C Technologies
Chennai, India
Role: Oracle Developer March 04
– October 06

B & C Technologies is globally competitive manufacturer of technology

driven products like Automotive Accessories, Transmission Line
Accessories, Isolated Phase Bus for Power Plant, Generator Cubicles,
and Electrical Machinery. A system was developed to monitor the
inventory of the organization. The system recorded all stores
transactions like material receipt against purchase order, material
issues, and stock adjustment vouchers.

Responsibilities:

• Involved in the entire system study, analysis and design.

 • Creating procedure for updating the data from factory systems,
through Oracle PL/SQL.
• Used Stored Procedures, Packages and Database Triggers
extensively.
• PL/SQL was extensively utilized for coding and writing complex
database triggers, stored procedures and packages.
• Provide ER diagrams via Erwin and Visio.
• Involved in testing the database for queries that were generated
and handled the performance issues efficiently.
• Involved in documenting the entire technical process.
• Supported technical teams involved with ORACLE issues and
operations.
• Involved in the maintenance of the database.

Environment: Oracle 8i, SQL, PL/SQL, Erwin, Windows 2000/NT, UNIX.

EDUCATIONAL QUALIFICATIONS

Masters in Computer Science, Andhra University, India

Bachelors in Computer Science, C E S College, India