SUMMARY

• Confidential is an accomplished Data Modeler/Analyst wif 7+ years of professional experience in data modeling, Analysis, design, and development of databases for business applications in Client/Server and Data Warehouse environments.
• Created maintained and modified database design document wif detailed level description of conceptual, logical entities and physical data models as per teh business requirements. sub type, super type
• Performed system design wif entities, attributes, logical relationships (identifying non - identifying). -Preliminary database design obligatory and non-obligatory analysis and validation of a model using Normalization techniques.
• Experience wif requirements gathering, conducting JAD session to discuss overall design patterns.
• Experience in Financial/Finance Mortgage, Supply-Chain, Material Management and Retails.
• Proficient in using MS Office including MS Visio and MS Project.
• Assisted developers, ETL, BI team and end users to understand and maintain change log for each data model, Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Designed teh Partitioning for tables according to business logic. Creation of Local/Global indexes depending on teh types of queries to be performed on teh table.
• Good knowledge and experience wif Normalization /De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Strong understanding of teh principles of Enterprise Data warehousing, Infosphere Data Architect, Experienced wif Dimensional data modeling for Data Marts.
• Identifying teh Facts and Dimensions from teh Enterprise Architecture for designing teh Star and Snowflake Schema model.
• Experience in creating schema and table design, stored procedures, Triggers, Views and Indexes.
• Experience in developing Entity-Relationship diagrams and modeling Transactional Databases.
• Data Warehouse using tools like Erwin, ER/Studio and Power Designer.
• Hands on experience wif modeling using Erwin in both forward and reverse engineering cases.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies, good in building various logics to handle Slowly Changing Dimensions, Change Data Capture and Deletes for incremental Loads in to teh Data warehouse and determining teh hierarchies in dimensions.
• Good understanding and exposure to SQL queries and PL/SQL stored procedures, triggers, functions and packages, Teradata SQL Assistant.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus and SQL Navigator.
• Good experience in data transformation, data mapping from source to target database schemas and also data cleansing.
• Strong Database experience using Oracle 11g, 10g, 9i, XML, DB2, Teradata, SQL server
• Good understanding and knowledge wif Agile and waterfall environments.
• Energetic and self-motivated team player wif excellent communication.
• Extensive Experience working wif business users/SMEs as well as senior management
• Possess a Strong Analytical, verbal, inter-personal skills dat halp in communicating wif developers, team members.

TECHNICAL SKILLS

• Erwin Data modeler
• Infosphere Data Architect
• ER Studio
• Rational Rose
• MS VisioTeradata
• Oracle9i/10g/11g
• MS SQL Server 2009/05/00
• MS Access
• DB2
• SybasePL/SQL
• C
• C++Cognos 8
• Microsoft Analysis ServicesBusiness Objects
• OBIEECrystal Reports 9
• SQL assistantToad
• SSMS
• Microsoft DTS/SSIS
• MS Office
• MS Project
• Windows
• Unix and Linux.

PROFESSIONAL EXPERIENCE

Sr Data Modeler/Analyst

Confidential, Tulsa, OK

Responsibilities:

• Documented all of teh Requirements Identified in teh sessions wif various users and Technical teams in a Statement of Work (SOW).
• Conducted sessions wif teh client, providing them an overview of teh SOW.
• Review teh Requirements and come up wif a High Level Design.
• Entered estimates into a Confidential defined template called teh “Estimates by Phase”, including numbers from teh various Phases.
• Reviewed teh SOW wif teh clients and tech teams to make sure dat teh Requirements are gatheird as stated by teh Client.
• Data Analysis and Modeling.
• Studied teh Software Requirements Specifications.
• Analyzed teh reporting needs of teh Business users.
• Created dimensions model star schemas using Kimball methodology.
• Arrived at teh dimension model of teh OLAP data marts in ERwin.
• Identified teh sources.
• Reverse Engineered teh Existing ODS in ERwin.
• Worked on teh initial stages of creating a Data Model for Confidential ’s OLTP system.
• Documented dis information into BRD’s and wrote Use Cases about building reports (Behavior of teh Report when teh user chooses certain options) and websites(behavior of teh Website when a user chooses/clicks an Option) for dis project.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Involved in Data Mapping activities for teh data warehouse.
• Prepared teh Functional Specifications Documents for teh Data Modelers and teh ETL Teams.
• Worked wif teh developers to identify teh entities and attributes required to build teh data model and teh logical/physical modeling and design.
• Developed Star and Snowflake schemas based dimensional model to develop teh data warehouse.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Handled performance requirements for databases in OLTP and OLAP models.
• Incorporated feedback and maintained change control.

Environment: Oracle 11g, Erwin 9.5, Windows 2007, UNIX, Infosphere Data Architect,TOAD, MS Access, MS Visio, PL/ SQL, MS Project

Senior Data Modeler

Confidential, Memphis, TN

Responsibilities:

• Responsible for teh Analysis, Design and Modeling.
• Worked wif teh Microsoft office tools for mapping and multiple other purposes.
• Designed architecture plan to customize teh HPDM data model brought from IBM.
• Monitored teh CA calls using nice calls to schedule teh work and find scheduled hours for teh resources to work on it.
• Created events and tasks in teh work flows using workflow manager.
• Created schema objects like Indexes, Views and Sequences Involved in dimensional modeling of teh data warehouse to design teh business process.
• Designed Logical data model and Physical Conceptual data model using Erwin
• Created teh ETL data mapping documents between source systems and teh target data warehouse.
• Worked wif teh OLTP database to generate teh DDL.
• Data mapping using Business Rules and data transformation logic for ETL purposes.
• Involved in Migrating teh data model from one database to oracle database and prepared oracle staging model.
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Involved in teh process design documentation of teh Data Warehouse Dimensional Upgrades.
• Assisted in teh design of report layouts to maximize usability and business relevance.
• Involved in Migrating teh data model from one database to oracle database and prepared oracle staging model.
• Worked in analyzing teh Subscriber alert.

Environment: Erwin 7.3, Data stage, Teradata 13.10, Oracle 10g, DB2 8.0, PL/SQL, MS SQL Server 2008, Siebel, SQL Developer, toad 10.1, IBM Rational clear quest, MS Excel, MS Project

Data Modeler / Data Analyst

Confidential, Chicago, IL

Responsibilities:

• Provided consulting in teh areas of Data Warehousing and repository implementation.
• Facilitated JAD sessions to determine data rules and conducted Logical Data Modeling (LDM) and Physical Data Modeling (PDM) reviews wif Data SMEs.
• Developed and maintained conceptual, logical and physical models, as well as metadata repository.
• Developed entity and attribute descriptions and definitions for teh models, ensuring dat conflicts in descriptions and definitions are resolved.
• Performed teh activities necessary to support teh standardization of facts and dimensions.
• Identified teh appropriate data sources wif teh assistance teh business analysts and conduct thorough data quality assessments on source data. Prepared prototype models to support development efforts.
• Created source to target mapping as needed and perform re-engineering of source models when necessary.
• Did reverse engineering from Database to ER Studio as necessary. Maintained teh views in teh Physical model.
• Gatheird, validated and document data requirements down to teh column level, indirect support of business requirements and priorities for specific data - driven and Data related projects.
• Developed and maintained data models, data dictionaries, data maps and other artifacts across teh organization.
• Along wif these carried out other duties and responsibilities as assigned.
• Evaluate potential expansion projects, provided at a requirements and design for new releases, as necessary.

Environment: SQL Server 2008, Oracle 10g, OLAP, OLTP, Teradata, SAS, DB2, VB Script, Multi-dimensional modelling, Data Warehousing, Erwin, ER STUDIO 8.5/9.0 (Data Architect), SQL, Teradata, Microsoft Project/Office.

Data Modeler / Data Analyst

Confidential, York, PA

Responsibilities:

• Gatheird, analyzed and translated teh business requirements into detailed reporting requirements for Data warehousing.
• Participated in JAD sessions involving teh discussions of various reporting needs using AGILE methodology.
• Conducted Design discussions and meetings to come out wif teh appropriate Data warehouse at teh lowest level of grain for each of teh Dimensions involved.
• Designed STAR schemas by identifying teh facts, dimensions, measures and involving shared dimensions (Conformed) in ERWIN.
• Involved in designing teh star schema by reverse engineering teh existing database.
• Implemented teh Snow-flake schema by normalizing teh existing star schema.
• Involved in preparing Logical Data Models/Physical Data Models.
• Generated teh DDL scripts by forward engineering teh physical model and interacted wif DBA to implement teh physical database.
• Conducted logical data model walkthroughs and validation.
• Identified source systems, their connectivity, related tables and fields and ensure data suitable for mapping.
• Developed data mapping documents between Legacy and User Interface Systems.
• Involved in mapping slowly changing dimensions (Type 2) to keep track of historical data.

Environment: ERWIN r8, Data Stage, DB2 UDB, SQL Server2008, Sun Solaris, Windows NT, MS Excel, MS Visio.

Data Modeler/ Data Analyst

Confidential

Responsibilities:

• Provided on-call support. Responded to halp desk tickets quickly and efficiently
• Work wif developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Creating Change tickets for teh Version Changes
• Involved in version queue meeting to discuss wif SA and BA
• Worked in Building teh OLTP Database for teh claims department.
• Expertise in data design and modeling, system study, design, and development by applying ralph Kimball methodology of dimensional modeling.
• Extensively used Erwin for designing teh data models.
• Applied teh up to 3rd Normal forms on teh OLTP database.
• Designed teh models on both relational and dimensional areas.
• Generate teh DDL using forward engineering
• Worked in merging and complete compare of Physical models.
• Analyzed teh data for teh projects and performed teh data profiling, data mapping for different sources.
• Generated Logical data Models for old databases using Reverse engineering and documented.
• Designed teh ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Teradata as per business requirements
• Studied teh existing OLAP system(s) and created facts, dimensions and star schema representation for teh Data mart.
• Created teh data dictionary for teh models and also performed teh GAP analysis for teh missing fields.

Environment: Windows XP Professional, Erwin 7.2/7.3, ER STUDIO, Cognos SQL Assistant, SQL Server 2008/2005, Teradata 12.1.13, LINUX(Ubuntu), SQL Loader, DB2, PL/SQL

Data Modeler

Confidential

Responsibilities:

• Worked wif teh Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Gatheird requirements and created use case diagrams as part of requirements analysis.
• Analyzed and evaluated existing system for assessing how it supported functions.
• Designed teh data marts using teh Ralph Kimball’s Dimensional Data Mart modeling techniques. Identified teh Facts and Dimensions.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Consulted wif client management and staff to identify and document business needs and objectives, current operational procedures for creating teh logical data model.
• Created physical data models using forward engineering.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements.

Environment: RUP, UML, Erwin r7, Model manager, Model navigator, Oracle 9i, Content db, SQL, PL/SQL, Toad, Business Objects