We provide IT Staff Augmentation Services!

Sr.data Modeler Resume

0/5 (Submit Your Rating)

Richmond, VA


  • 8 Years of experience in Data Modeling, Data Designing and Data Analysis.
  • Experience in Logical/Physical Data Modeling, Relational for Online Transaction Processing (OLTP) and OLAP.
  • Proficiency in Data Modeling tools like Erwin, ER Studio and Power Designer, developing and Modeling Entity Relationship diagrams, Transactional and Data Warehouse Databases.
  • Generated DDL Scripts from Physical Data Model by using Forward Engineering technique.
  • Proficiency in Normalization to 3NF and De - normalization techniques for optimum performance of database environments like OLTP and OLAP systems.
  • Experience in developing transactional Enterprise Data Models which meet the normalization rules strictly and understanding of enterprise data warehouses by using Ralph Kimball Data warehouse methodologies.
  • Involved in implementing the Referential Integrity by using Primary and Foreign key relationships.
  • Practical understanding and hands on experience of the Data modelling (Dimensional & Relational) concepts like Star-Schema, Snowflake Schema, Fact and Dimension tables.
  • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • Experience in performing Reverse Engineering from existing Systems and developing Logical/Physical Data models from ERwin and ER studio.
  • Developed gap documents on the Gap Analysis performed on the existing systems.
  • Experience in developing database schemas like Star Schema and Snowflake Schema for Dimensional Modeling and identifying Facts and Dimensions.
  • Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
  • Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.
  • Proven knowledge in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
  • Proficient in Data Cleansing and Data Profiling based on standards.
  • Experience working in Agile and Waterfall Data Modeling Methodologies.
  • Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
  • Good interpersonal and human relation skills to interact with clients and co-workers


Databases: MS SQL Server 20014/12/08/, Oracle11g/10g/9i/8i, DB2 V9.5, MS Access 2000

Programming Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX shell Scripting, VBScript, PERL, AWK

Tools: MS-Office suite (Word, Excel, MS Project and Outlook)

Operating Systems: Windows 10/8/7/XP, UNIX (Sun Solaris 10), LINUX

ETL Tools: Informatica Power Center 8.6.1/8.1/7.1 , Data Stage 7.5, Ab Initio, SSIS,SSRS

Data Modelling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Tools: & Software’s: MS Office, BTEQ, Teradata SQL Assistant

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos Power play

Analysis and Modeling Tools: ERwin 4.1/7.2/7.0/8.0/9.1/9.6 , Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio.


Confidential, Richmond, VA

Sr.Data Modeler


  • Part of the team responsible for the analysis, design and implementation of the business solution.
  • Gathered requirements document and analysed the process.
  • Translate business requirements into conceptual, logical data models and physical data models.
  • Developed the logical data models and physical data models that capture current state/future state data elements and data flows using Erwin.
  • Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in Erwin to identify GAPs and worked with the naming standards utility.
  • Analysed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
  • Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
  • Extensively used Normalization techniques (up to 3NF).
  • Responsible for data modeling and building a star schema model in Erwin.
  • Participated in the tasks of data migration from legacy to new database system.
  • Good knowledge of SQL and querying of DB2 database.
  • Created Data Definitions and help maintain Metadata repository.
  • Developed and maintained data dictionary to create Metadata reports for technical and business purpose in MDR.
  • Involved in dimensional modeling, identifying the Facts and Dimensions and different hierarchies.
  • Conducted walkthroughs with the DBA to convey the changes made to the data models.
  • Worked with the ETL team to document the transformation rules for data migration from source to target systems.
  • Developed source to target mapping documents to support ETL design.
  • Resolved the data type inconsistencies between the source systems and the target system using the Source-to-Target Mapping Documents.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Defined the data definitions, and create the target tables in the database.
  • Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
  • Provided data modeling support for numerous strategic application development projects.
  • Developed mapping document to facilitate the ETL to understand the process and in corporate the changes.
  • Created an enterprise data dictionary and maintained standards documentation.

Environment: Erwin 9.5, DB2 Erwin, ER Studio, SQL, PL/SQL, Oracle, SQL Server 2014, MS Visio, MS Excel, Windows 10/8.1, Unix.

Confidential, El Segundo,CA

Sr.Data Modeler/Analyst


  • Gathered the business requirements by conducting a series of meetings with business users.
  • Created logical data model from the conceptual model and it’s conversion into the physical database design using Erwin.
  • Map business needs/requirements to subject area model and to logical enterprise model.
  • Involved with data analysis using Teradata SQL assist from data source.
  • Reviewed models with DBA have to best fit physical Model Indexes for better DB performance.
  • Reviewed and identified unused tables/columns as part of data analysis.
  • Developed the data warehouse dimensional models & schema for the proposed central model for the project.
  • Developed many subject models from scrap.
  • Created Logical/Physical Data models in 3NF in the Warehouse area of Enterprise Data Warehouse.
  • Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
  • Worked on the Snow-flaking the Dimensions to remove redundancy whenever required.
  • In order of better understanding the requirement documents, carried out couple of JAD sessions with Management, SME (Subject Matter Expertise), vendors, users and other stakeholders.
  • Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
  • Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
  • Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
  • Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
  • Maintained the integrity of data and data quality.
  • Conducted data profiling for better understanding of joins in ER models
  • Involved in high level ETL design review sessions and assisted ETL developers in the detail design and development of ETL maps using Informatica.
  • Worked with project release meeting manager for UAT tables going to production.
  • Handled metadata publish tasks to our internal data dictionary from internal DB MS Access
  • Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
  • Assisted Reporting developers in building Reports using Crystal Reports.

Environment: Erwin9x/8x,Informatica, Teradata SQL Assistant, SQL Server Management Studio 2012/08, Informatica,Unix, MS Visio, MS Office 2013, Windows 8/7.

Confidential, Philadelphia, PA

Data Modeler


  • Involved in requirement gathering along with the Project manager and Users.
  • Gathered all the customer services report prototypes from the Project manager including the dispatch and employee vehicle information.
  • Participated in JAD sessions
  • Conducted Design discussions and meetings to come out with the appropriate Data Mart
  • Understood existing OLTP data model and developed the OLAP data marts in a satisfactory way of the user requirements affecting the performance of the system
  • Designed the data marts (logical and physical data models) by identifying facts and dimensions from the requirements using Erwin tool especially the Star schemas.
  • Prepared the metadata documentation (in Microsoft Excel) for these data marts.
  • Conducted Design reviews with the business analysts, content developers.
  • Created tables in database using DDL scripts, provided grants on the table based on the user requests and performed analysing the tables periodically.
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
  • Oracle warehouse Builder tool is used for the ETL process and worked on oracle aggregations.
  • Extracted the required data from the source database (Flat Files/MS Access/Oracle/SQL server) and transformed it with the required transformations and then loaded the transformed data into the target database.
  • Developed Packages, Procedures and functions in PL/SQL, wrote triggers for implementing data integrity
  • Scheduled the daily transactions using UNIX shell scripting and tested the data for frontend VB 6.0.
  • Extracted data from the databases (Oracle and SQL Server) using Informatica to load it into a single data
  • Created data mapping documents from source to target systems.
  • Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
  • Created logical and physical design of the centralized Relational Data base
  • Normalization to 3NF/Denormalization techniques for optimum performance in relational and dimensional database environments.
  • Provided Database Normalization upto 3NF for the database schemas.
  • Updated the database as a daily transactional in order to meet user requirements.

Environment: Erwin 8x,Oracle 11g/10g,Informatica, SQL Server Management Studio 2008/12, Oracle 10g, MS Access, MS Office 2010, Windows 7.

Confidential, Hartford, CT

Data Modeler


  • Interacted with the business users on regular basis to consolidate and analyse the requirements.
  • Identified, formulated and documented detailed business rules and use cases based on requirements analysis, Involved in multiple projects with different business units. .
  • Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
  • Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
  • Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
  • Had a strong working experience in Extract/Transform/Load (ETL) design and implementation in areas related to Teradata utilities such as Fast Export and MLOAD for handling numerous tasks?
  • Developed in Star and Snow flake schema dimensional data models.
  • Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables
  • Extracted data from databases Oracle, SQL server and DB2 using Informatics to load it into a single repository for Data analysis.
  • Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models
  • Compare data with original source documents and validate Data accuracy.
  • Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
  • Worked on ER STUDIO to create data models.
  • Used SQL Server Reporting Services (SSRS) to create reports.
  • Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
  • Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
  • Experienced in development of ETL mapping and scripts.
  • Worked on multiple Data Marts in Enterprise Data Warehouse Project (EDW)
  • Involved in designing OLAP data models extensively used slowly changing dimensions (SCD).
  • Involved in Generating ad-hoc reports using crystal reports 9.

Environment: Erwin 7x,ER Studio, SQL, Unix, Informatica, Oracle 11g, SQL Server 2008, Crystal Reports, Windows 7, MS Office, Business Objects.

Confidential, St. Louis, MO

Data Modeler


  • Performed Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
  • Normalizing the tables/relationships to arrive at effective Relational Schemas.
  • Identifying the facts & dimensions, grain of fact, aggregate tables for Dimensional Models.
  • Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
  • Implementation of Business Rules in the Database using Constraints & Triggers.
  • Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
  • Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions.
  • Participate in biweekly technical huddle meeting with development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
  • Rapid Audit of the requirements and existing systems; Requirements & Business Process Analysis.
  • Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using ERwin Data Modeler/7.x, Forward/Reverse Engineered Databases.
  • Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
  • Convert models from CA ERwin to ER/Studio 7.5 (ERStudio); developed numerous macros.
  • Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
  • Compiles and maintains the Enterprise Schema across all applications. Enforces principles of good canonical data design.
  • Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
  • Designing Data Flows & System Interfaces - Service Oriented Architecture (SOA) & Web Services.
  • Architecting Work Flows, Activity Hierarchy & Process Flows; Design EDW / CDW components.
  • Metadata Repository, Data Dictionary; Documentation using Interface Diagrams, Flow Charts.
  • Assist developers in Performance Tuning & discussing Design Patterns/high level application design.

Environment: Erwin 7x/ ER Studio 7.5, Oracle 11g/ 10g, Toad, Informatica, Ab Initio, Business Objects, MS Access, MS Office 2010.


Data Modeler/Analyst


  • Identified entities and attributes and built conceptual, logical and physical models using Erwin.
  • Data Modeler performing business area analysis and logical and physical data modeling using Erwin for data warehouse/data mart applications as well as operational applications enhancements and new development. Data warehouse/data marts design was implemented using Ralph Kimball methodology.
  • Reverse engineered the reports and identified the data elements, dimensions, facts and measures required for new enhancements of the reports.
  • Design discussions and meetings to come out with the appropriate data mart at the lowest level of grain for each of the dimensions involved.
  • Worked on data profiling, data quality, assessing the risk involved in integrating data for new applications.
  • Involved in discussions with team which deals with six sigma to understand the customer need data and data analysis.
  • Assess whether metadata accurately describes the actual values in the source database.
  • Worked on data governance for improving data quality.
  • Designed a star schema for the detailed data marts and plan data marts involving confirmed dimensions
  • Created and maintained the data model repository as per company standards.
  • Creating and ensuring the feasibility of the logical and physical design models using Erwin.
  • Generated ready to implement DDL for oracle DBMS implementation by the DBA group.
  • Created reports using SQL Server reporting services (SSRS), business objectsand crystal reports.
  • Interacted with DBA for improving performance of queries.
  • Involved in indexing, partitioning of the database.
  • Worked extensively on oracle analytical functions like ROW NUMBER, LEAD, LAG, RANK, DENSE RANK
  • Understanding of the Teradata SQL assistant and used SAS/Interface to Teradata to extract data from Teradata.
  • Populated SharePoint site with Metadata for Various Data Structures, tables, Columns and their Constraints using Structured Query Language.
  • Generated ad-hoc queries using SQL joins, etc.
  • Worked on PL/SQL collections, index by table, arrays, bulk collect, FOR ALL, etc.
  • Performed updates and enhancements to the already existing data models as required by using ERWIN/CA
  • PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.

Environment: Erwin, ER Studio, SQL, Unix,Oracle 10g, Toad, Windows OS, DB2,SQL, Informatica.


Data Analyst


  • Responsible for accuracy of the data collected and stored in the corporate support system.
  • Performed data review, evaluate, design, implement and maintain company database.
  • Involved in construction of data flow diagrams and documentation of the processes.
  • Interacted with end users for requirements study and analysis by JAD (Joint Application Development).
  • Performed gap analysis between the present data warehouse to the future data warehouse being developed and identified data gaps and data quality issues and suggested potential solutions.
  • Participated in system and use case modeling like activity and use case diagrams.
  • Analyzed user requirements and worked with the data modelers to identify entities and relationship for data modeling.
  • Actively participated in the design of data model like conceptual, logical models using Erwin.

Environment: Erwin 7x, Oracle 9i, MS Access, MS Office 03,Windows XP, Oracle, SQL, Unix.

We'd love your feedback!