We provide IT Staff Augmentation Services!

Data Modeler / Data Analyst Resume

Farmington, CT


  • Data Modeling professional with around 10 years of total IT experience and expertise in data modeling for data warehouse/data mart development, SQL and analysis of Online transactional Processing(OLTP), data warehouse (OLAP) and business Intelligence (BI) applications.
  • Excellent ability to understand business needs and data to generate end to end business solutions.
  • Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin r7.3, Power Designer 12.0, Visio and ER Studio Data modeling tools.
  • Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
  • Experience in modeling with both OLTP/OLAP systems.
  • Having good experience with Normalization (1NF, 2NF and 3NF) and De - normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
  • Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema and Galaxy schema for Data Warehouse, ODS architecture by using tools like Erwin 9.6/8.2/7.0, Power Designer 15, Embarcadero E-R Studio and Microsoft Visio.
  • Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server and Teradata.
  • Delivered MDM (Master Data Management) components.
  • Experience in Teradata Enterprise Data Warehouse (EDW) and Data Mart.
  • Expert in user interface designing and creating screen-shots using wire frames and comps, and expert in using tools like MS Project and MS Visio.
  • A good familiarity and experience in the work environment consisting of Business analysts, Production/ Support teams, Subject Matter Experts, Database Administrators and Database developers.
  • Excellent analytical skills with exceptional ability to master new technologies efficiently.
  • Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling a Data warehouse in Relational, Dimensional and multidimensional modeling.


Data Modeling Tools: Erwin, Visio, IBM InfoSphere, Data Architect, IBM Rational Rose, Power Designer and ER Studio

Database: Teradata, Oracle, MS SQL Server, MS Access, DB2, Netezza,NoSQL

Business Applications: MS Word, MS Excel, MS PowerPoint, Visio

Operating Systems: Windows, Unix, Linux

Data Warehouse: OLTP Tools Microsoft Analysis Services, Business Objects, Crystal Reports, Informatica, SSIS, DataStage, SAS ETL, BODI, Ab Initio


Confidential - Farmington, CT

Data Modeler / Data Analyst


  • Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
  • Created OLTP, ODS and OLAP architectures
  • Responsible for the analysis of business requirements and design implementation of the business solution.
  • Developed Conceptual, Logical and Physical data models for central model consolidation.
  • Worked with DBAs to create a best fit physical data model from the logical data model.
  • Conducted data modeling JAD sessions and communicated data-related standards.
  • Used Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
  • Developed process methodology for the Reverse Engineering phase of the project.
  • Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
  • Involved in MDM (Master Data Management)
  • Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
  • Involved in the critical design review of the finalized database model.
  • Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
  • Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin, Informatica, Teradata, Oracle, SQL Server, MS Excel, MS Visio

Confidential, Sunnyvale, CA

Data Modeler/ Data Analyst


  • Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
  • Prepared the questioners to users and created various templates for dimensions and facts.
  • Conducting user interviews, gathering requirements, analyzing the requirements using Rational Rose, Requisite pro RUP
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio
  • Created logical data model from the conceptual model and it's conversion into the physical database design using ERwin
  • Created dimensional model based on star schemas and designed them using ERwin.
  • Used ERwin for creating tables using Forward Engineering
  • Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
  • Responsible for identifying and documenting business rules and creating detailed Use Cases
  • Defined the naming standards for data warehouse
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
  • Maintained warehouse metadata, naming standards and warehouse standards.
  • Develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
  • Collected the information about the existing ODS by reverse engineering the ODS.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Assisted in designing the overall ETL strategy
  • Generated DDL statements for the creation of new Sybase objects like table, views, indexes, packages and stored procedures.
  • Created DataStage Server jobs to load data from sequential files, flat files and MS Access
  • Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
  • Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.

Environment: Erwin, Oracle, SQL server, MS Excel, MS Visio

Confidential, Lisle, IL

Data Modeler / Data Analyst


  • Involved with the Business Analysts' team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
  • Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data
  • Management Architecture involving OLTP, ODS and OLAP.
  • Created Logical and Physical Data Models by using Erwin r7.3 based on requirements analysis.
  • Developed normalized Logical and Physical database models to design OLTP system for banking applications.
  • Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
  • Performed the data source mapping.
  • Utilized Power Designer's forward/reverse engineering tools and target database schema conversion process.
  • Documented logical, physical, relational and dimensional data models.
  • Designed the data marts in dimensional data modeling using star and snowflake schemas.
  • Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
  • Review the data model with functional and technical team.
  • Worked on the reporting requirements and involved in generating the reports for the Data Model.
  • Assist developers, ETL, BI team and end users to understand the data model.

Environment: s: ERWIN, DB2, Teradata, Oracle, Microsoft Visio.

Confidential, LA

Data Modeler/Data Analyst


  • Involved in gathering user requirements along with business analysts.
  • Expanded Physical Data Model (PDM) for the OLTP application using Power Designer.
  • Transformed project data requirements into project data models.
  • Responsible as a member of development team to provide business data requirements analysis services, producing Logical and Physical data models using Power Designer 12.0.
  • Conducted data modeling JAD sessions and communicated data-related standards.
  • Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
  • Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward Engineering.
  • Involved in designing Data marts by using Star Schema and Snowflake schema.
  • Closely worked with ETL process development team.
  • Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
  • Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW)
  • Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin, Teradata, Oracle, SSIS, Informatica Power Center


Data Modeler / Data Analyst


  • The Data Mart (BMDM) system stores marketing data in an Oracle relational database and is interrogated using the end-user reporting tools.
  • Responsible for data modeling and building a star schema model in Erwin.
  • Identified the fact tables, dimensions and the key measures.
  • Installed and configured MS SQL Server
  • Created and Scheduled jobs on MS SQL Server to transfer data.
  • Used star schema methodology for the modeling of the data.
  • Performed Data Profiling to identify data issues upfront, provided SQL prototypes to confirm the business logic provided prior to the development.
  • In creation of the data mart new functionality had to be added like Trend data Inclusion, Product Profitability Calculation \ Reporting, Concept Reporting, Size Of Line Reporting, Global Brand Grouping \ Reporting etc.
  • Assisted data warehouse project team in extracting business rules.
  • Created an enterprise data dictionary and maintained standards documentation.
  • Analysis of data requirements and translation of these into dimensional data models.
  • Interacted with the end users and found out the performance of the database and also involved in developing test cases.

Environment: Erwin, Teradata, SQL Server


Business Analyst / Data Analyst


  • Designed Physical data model from scratch based on Business requirement and review with LOB.
  • Translating business requirements into reporting/analytical requirements in Functional Specifications Document (FSD). Working as a BI liaison between business users/sponsor and technical IT resources.
  • 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.
  • Normalized the database to put them into the 3NF of the data warehouse.
  • Provided technical support during delivery of MDM (Master Data Management) components.
  • An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.
  • Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
  • Documents to guide Informatica developers on ETL development. Designed and unit tested Informatica mapping as part of lead certifications.
  • Wrote requirements for designing data marts that were used as a source for the various reporting systems in the company.
  • Performed Data Analysis, Data profiling and Data validation by writing SQL queries using TOAD.
  • Involved in defect management, including root cause analysis, solution recommendations (s), and next step coordination. Conducted UAT for data integrity. Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
  • Responsible for supporting the Operations support team with releases deployed to Production.
  • Helped Business in ad-hoc reporting request and data pulls.
  • Built DDL’s from physical database structures using forward engineering technique from Data model and worked with DTG group to get it executed on Database.
  • Provided production support and performed enhancement on existing projects.

Environment: Windows XP, Erwin8.5,Power Designer 11.0.0, Oracle 11, Informatica 8.6.1, OBIEE, SQL server 2008, TOAD for Oracle 11.0.0,SQL Developer, MS Visio 2007, MS Access and MS Excel.

Hire Now