Data Modeler Resume Samples

Description :

1. Gathered, Analyzed and Participated in JAD sessions with business users to understand and document the business requirements from technical perspective.
2. Wrote functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
3. Implemented the standard naming conventions for the entities and attributes of logical and physical model.
4. Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements.
5. Designed conceptual and logical data models of databases and tables.
6. Identified entities and relationships and how those all fit together in logical model, these are then translated into physical model using ERWIN tool.
7. Created databases for OLAP Metadata catalog tables using forward engineering of models in Erwin.

Experience

7-10 Years

Level

Management

Education

Master Of Science

Description :

1. Involved in gathering user requirements along with business analysts.
2. Transformed project data requirements into project data models using Erwin.
3. Designed the data marts in dimensional data modeling using star and snowflake schemas.
4. Involved in logical and physical designs and transforms logical models into physical implementations.
5. Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
6. Participated in the requirements gathering process to create solid business and technical requirements focused on data and data transport use cases.
7. Designed of data transformation processes and tools that normalize, cleanse, augment, and attribute incoming and outgoing data from multiple sources.

Experience

5-7 Years

Level

Executive

Education

Bachelors Of Technology

Description :

1. Worked with star schema and OLAP modeling.
2. Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.
3. Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
4. Updated data model as per the requirement and generate DDL and deploy it using SQL developer.
5. Responsible for Dimensional Data Modeling and Modeling Diagrams using ERWIN.
6. Worked with reversed engineer Data Model from Database instance.

Experience

5-7 Years

Level

Executive

Education

Bachelor's

Description :

1. Participated in all phases including Analysis, Design, Coding, Testing and Documentation.
2. Gathered Requirements and performed Business Analysis.
3. Extensively used SQL for Data Analysis.
4. Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
5. Created Schema objects like Indexes, Views, and Sequences Conducted team meetings and proposed ETL strategy.
6. Worked on Gap Analysis.
7. Selected to work on a team with 4 other consultants, reporting to a Project Manager.

Experience

2-5 Years

Level

Executive

Education

M.S. In Resource Engineering

Description :

1. Designed Physical data model from scratch based on Business requirement and review with LOB.
2. Worked as a BI liaison between business users/sponsor and technical IT resources.
3. Created data mapping Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, and Power Designer Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
4. Normalized the database to put them into the 3NF of the data warehouse.
5. Provided technical support during delivery of MDM (Master Data Management) components.
6. Created and changed Data Models using PowerDesigners Update system design documentation including high level design, low level design, source to target .
7. Responsible for Asset Management of Computer Hardware and Asset Fixed Products and SAP CRM- POS Management.

Experience

5-7 Years

Level

Executive

Education

Bachelors In Computer Science

Description :

1. Provided insurance coverage in four specialty areas: property and casualty; life, accident and health; international; credit and surety; and related agency and reinsurancebrokerage services to commercial customers and individuals.
2. Identified the key facts and dimensions necessary to support the business requirements.
3. Developed the logical and dimensional models.
4. Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
5. Conducted team meetings and JAD sessions.
6. Performed source data quality assessments.
7. Identified the appropriate data sources with the assistance of the business analyst.

Experience

2-5 Years

Level

Executive

Education

Bachelor In Computer Science

Description :

1. Identified common entities & attributes across disparate enterprise source systems, which consisted of two relational .
2. Created common data dictionary for target model Created high level source to target mappings from each source system to common target logical model .
3. Automated Client Reporting using VBA programming Used Sumifs, Countifs, vlookup, and pivot tables Reported on weekly events and changes to the .
4. Converted Crystal Reports based reporting into MicroStrategy Reports that involves over 70+ reports.
5. Created a new architecture using Oracle views and ensure all the output will match the existing production reports.
6. Evaluated the suitability option to create full reporting schema based all the available Oracle views.
7. Created ODBC connections and customize data-warehouse default read settings Add required views from the data-warehouse catalog Create sample reports. 

Experience

2-5 Years

Level

Executive

Education

Bachelors In Computer Science

Description :

1. Consolidated data environment for Auto Finance will provide improved stability and data consistency.
2. Provides improved operational efficiency by removing redundancies in data management activities.
3. Identified different SOR's and the related entities and attributes.
4. Worked closely with business users, dealers and third party vendors to understand the process and the requirements.
5. Created different subject areas and created different entities as per the business needs Identified suitable classification words for the data coming from different sources.
6. Identified the attributes to maintain in Semantic layer and provided instructions to Semantic team on how to populate data into those attributes.
7. Participated in DRB review meetings and updated model as per their review comments Analyzed source system copybooks and identified necessary attributes and their data types.

Experience

7-10 Years

Level

Senior

Education

Master's In Computer Science

Description :

1. Chase Auto Finance - BI strategy is part of a multi-year initiative to provide a cross-LOB reporting and analytics data warehouse.
2. Provided the required data model to receive and aggregate data from identified source systems.
3. Consolidated data environment for Auto Finance will provide improved stability and data consistency.
4. Provides improved operational efficiency by removing redundancies in data management activities.
5. Identified different SOR's and the related entities and attributes.
6. Worked closely with business users, dealers and third party vendors to understand the process and the requirements.
7. Created different subject areas and created different entities as per the business needs Identified suitable classification words for the data coming from different sources.
8. Identified the attributes to maintain in Semantic layer and provided instructions to Semantic team on how to populate data into those attributes.

Experience

5-7 Years

Level

Executive

Education

Master's In Computer Science

Description :

1. Involved in multiple projects which are driven by the business requirements.
2. Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
3. Developed logical and physical data models for central model consolidation.
4. Worked with DBAs to create a best fit physical data model from the logical data model.
5. Conducted data modeling JAD sessions and communicated data-related standards.
6. Used Erwin r7.0 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Experience

2-5 Years

Level

Management

Education

Bachelor Of Technology