Sr.data Modeler Resume
Richmond, VA
SUMMARY
- 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
TECHNICAL SKILLS
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.
PROFESSIONAL EXPERIENCE
Confidential, Richmond, VA
Sr.Data Modeler
Responsibilities:
- 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
Responsibilities:
- 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
Responsibilities:
- 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
Responsibilities:
- 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
Responsibilities:
- 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.
Confidential
Data Modeler/Analyst
Responsibilities:
- 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.
ConfidentialData Analyst
Responsibilities:
- 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.