We provide IT Staff Augmentation Services!

Sr. Data Modeler/ Data Analyst Resume

Erie, PA

SUMMARY

  • Four years of professional experience in Data Modeling, Business Data Analysis, and design of OLTP and OLAP systems.
  • Strong experience in Data Profiling, Data Migration, Data Integration and Metadata Management Services
  • Experience in gathering, analyzing the business requirements and creating Business Requirement Document (BRD), Technical Specification Document.
  • Experience with gathering business requirements, use cases and requirements analysis.
  • Strong experience in Data modeling - Conceptual, Logical/Physical, Relational and Multi-dimensional modeling, Data analysis for Decision Support Systems (DSS), Data Transformation (ETL) and Reporting.
  • Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin and ER Studio Data modeling tools.
  • Strong knowledge of SQL in database design and stored procedure development, with knowledge of tools like Informatica (ETL)
  • Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert 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 Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.
  • Proficient in Software Development Life Cycle (SDLC), Project management methodologies and Microsoft SQL server database management.
  • Strong Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
  • Strong working experience in Extract/Transform/Load (ETL) design and implementation. Experience with Teradata utilities for handling various tasks.
  • Continuously update the XML schemas to match client requirement.
  • Experienced in designing the data mart and creation of cubes.
  • Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
  • Good working experience with Autosys Job Scheduler to automate/schedule ETL jobs, testing methodology, build and deployment.
  • Facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
  • Worked extensively onforward and reverse engineeringprocesses. CreatedDDL scriptsfor implementing Data Modeling changes. CreatedERWIN reportsin HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
  • Exhaustively collected business and technical metadata and maintainednaming standardsand responsible for defining the naming standards for data warehouse.
  • Performed extensiveData profilingand analysis for detecting and correcting inaccurate data from the databases and to trackdata quality.
  • Excellent communication, presentation, team support, database, and interfacing skills.
  • Worked in many Software Development Life Cycle (SDLC) implementations, performing process-planning, documentation, functional and system design, implementation, unit, integration, regression testing, and system maintenance

TECHNICAL SKILLS

Data Modeling Tools: Erwin 6/7/8/9.5, Rational Rose 2000, MS Visio 2000/2007/2010 , E/R Studio

Databases & Database Tools: MS & SQL servers 2005/2008/2012 , Oracle 10g/11g/12c, MS Access 2007/2010,PL/SQL, Teradata, DB2, TOAD 9, Data Stage XE 390, Informatica 8

Reporting Tools: Cognos 8, Business Objects XI, Crystal Reports 2008.

ETL Tools: EME, Data Stage SQL Server, DTS/Integration Services, SQL*Loader, Informatica Power Center /Power Mart, Power designer

Operating Systems: UNIX AIX/Solaris, MVS, Windows XP/NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Erie, PA

Sr. Data Modeler/ Data Analyst

Responsibilities:

  • Participated in requirement gathering session, JAD sessions with users, Subject Matter experts, Architects and BAs.
  • Created Normalized OLTP Logical and Physical models based on the requirements.
  • Extensively used Normalization techniques (up to 3NF).
  • Conducted and participated in Database design review meetings.
  • Prepared Enterprise Naming Standard files and also project specific naming standard files in some exception cases.
  • Worked with Enterprise Architect team in developing Enterprise Party Contact data models, which is used by most of the applications.
  • Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks.
  • Worked with MDM team in capturing demographic information in the applications by providing Data dictionaries and communicating with Application and MDM team.
  • Involved in the redesign of the existing OLTP systems, modifications and designing new requirements in the existing systems.
  • Worked on Forward and Reverse Engineering using Erwin, reverse engineered XSD structures, excel spread sheets and copybooks.
  • Worked on upgrading Erwin Data modeler from v7.3 to v9.5, served as Erwin Repository administrator
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Worked with DBA’s in implementing the database changes in all environments, by providing DDL and DML statements
  • Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
  • Created UML Diagrams including Use Cases, Activity Charts and Data Flow Diagrams using MS-Visio thus defining the Business Process Model and Data Process Model.
  • Worked with BI team in providing complex SQL queries, Data Dictionaries and mapping documents (Report attributes to Database columns).
  • Acted as a Strong Data Analyst analyzing the data from low level in conversion projects, provided mapping documents between Legacy, Production and User Interface systems.
  • Extensively performed Data Profiling and has a good knowledge on best practices.
  • Worked with Architects in designing conceptual model for the Data warehouse and Identified Facts and Dimensions, designed Logical and Physical data models
  • Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
  • Worked on Converting Physical only models to Logical and Physical models.

Environment: Oracle 10g/11g/11c/12c, SQL Server 2005/2008/2012 , Erwin 7.3/9.5, IBM DB2, Case Complete, Blue Zone, Toad SQL Developer, Informatica Analyst 9.6.1 Sybase Power Designer 15, MS OFFICE 2015, Crystal Reports, ALTOVA XML Spy, MS Visio.

Confidential, New York, NY

Data Modeler /Analyst

Responsibilities:

  • Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Erwin 8.0.
  • Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships.
  • Involved in the study of the business logic and understanding the physical system and the terms and condition for sales Data mart.
  • Used Erwin for logical and physical data modeling, database design, star schema design, data analysis, documentation, implementation and support.
  • Created package to transfer data between OLTP and OLAP databases.
  • Create the architectural artifacts for the Enterprise Data Warehouse and the Operational Dashboard, such as Entity Relationship Diagrams (ERD), the DDL scripts, the Conceptual Data Model, and technical as well as business documents.
  • Implemented the standard naming conventions for the entities and attributes of logical and physical model.
  • Performed data profiling and analysis to halp integrating multiple source systems data into one centralized model.
  • Create various Data Mapping Repository documents as part of Metadata services
  • Design and implementation of a Metadata Repository.
  • Design and development of customizable interface for consumers of information within the Metadata Repository
  • Extracted data from XML to SQL server.
  • Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
  • Struck a balance between scope of the project and user requirements by ensuring that it covered minimum user requirements without making it too complex to handle.
  • Requirement gathering from the users. A series of meetings were conducted with the business system users to gather the requirements for reporting.
  • Involved in mapping the load data to the target based on primary, and foreign key relationship considering the constrained based load order
  • Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
  • Created the detailed Source to Logical to Physical mapping document. Worked with Business SME’s and documented the Business rules for ETL Development.
  • Designed the mapping with a slowly changing dimension Type2 to keep track of historical data
  • Designed a mapping to process the incremental changes that exits in the source table.
  • Designed, developed the changes and enhancements for the existing submission, and refining programs were enhanced to in corporate the new calculations.
  • Interacted with end users to identify key dimensions and measures that were relevant quantitative.
  • Involved in logical and physical designs and transform logical models into physical implementations.
  • Used Erwin7.0 tool for reverse engineering and target database schema conversion process.
  • Involved in overall testing and different team review meetings.
  • Worked with DBA in facilitating performance tuning. Helped identifying columns for collecting statistics. Assisted in Query tuning by suggesting Optimal Join Conditions.

Environment: Teradata SQL Assistant 12.0/13.11, Data stage 8.1, Sybase Power Designer 15, MS OFFICE, DB2, ERwin 7/8,Crystam reports.

Confidential, Roschelle Park, NJ

Data Modeler / Data Analyst

Responsibilities:

  • Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements.
  • Designed of the Conceptual, Logical and Physical data models to meet the business requirements and reporting requirements using Erwin 7.0.
  • Strong understanding in the principals of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
  • Good understanding ofviews, Synonyms, Indexes, Joins and Partitioning.
  • Enforced mandatory capture metadata during the logical phase design.
  • Forward Engineering the Physical Model to generate the DDL scripts to implement on Oracle 11g database.
  • Reverse engineering of the existing reports to identify the key data elements and data entities required to design the data warehouse.
  • Generated ready to implement DDL for oracle DBMS implementation by the DBA group.
  • Identified the data requirements, source and target databases. Created the mapping data from source to target databases.
  • Involved in mapping data elements from User Interface to the Database and halp identify gaps.
  • Created and maintained the Data Model repository as per company standards.
  • Used Model Mart ofErwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and Teradata.
  • Extensively worked with DTS for Data Migration from source systems
  • Developed the UML class diagrams for the proposed system using ER/Studio Software Architect ETL mapping document by.
  • Involved in different team review meetings.

Environment: Oracle 11g,Teradata, SQL server 2012, Linux, Windows 7, Erwin, MS Visio, TOAD.

Hire Now