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 the 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 the Partitioning for tables according to business logic. Creation of Local/Global indexes depending on the types of queries to be performed on the table.
• Good knowledge and experience wif Normalization /De-normalization techniques for TEMPeffective and optimum performance in OLTP and OLAP environments.
• Strong understanding of the principles of Enterprise Data warehousing, Infosphere Data Architect, Experienced wif Dimensional data modeling for Data Marts.
• Identifying the Facts and Dimensions from the Enterprise Architecture for designing the 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 the Data warehouse and determining the 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 that 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 the Requirements Identified in the sessions wif various users and Technical teams in a Statement of Work (SOW).
• Conducted sessions wif the client, providing them an overview of the SOW.
• Review the Requirements and come up wif a High Level Design.
• Entered estimates into a Confidential defined template called the “Estimates by Phase”, including numbers from the various Phases.
• Reviewed the SOW wif the clients and tech teams to make sure that the Requirements are gatheird as stated by the Client.
• Data Analysis and Modeling.
• Studied the Software Requirements Specifications.
• Analyzed the reporting needs of the Business users.
• Created dimensions model star schemas using Kimball methodology.
• Arrived at the dimension model of the OLAP data marts in ERwin.
• Identified the sources.
• Reverse Engineered the Existing ODS in ERwin.
• Worked on the initial stages of creating a Data Model for Confidential ’s OLTP system.
• Documented this information into BRD’s and wrote Use Cases about building reports (Behavior of the Report when the user chooses certain options) and websites(behavior of the Website when a user chooses/clicks an Option) for this project.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Involved in Data Mapping activities for the data warehouse.
• Prepared the Functional Specifications Documents for the Data Modelers and the ETL Teams.
• Worked wif the developers to identify the entities and attributes required to build the data model and the logical/physical modeling and design.
• Developed Star and Snowflake schemas based dimensional model to develop the 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 the Analysis, Design and Modeling.
• Worked wif the Microsoft office tools for mapping and multiple other purposes.
• Designed architecture plan to customize the HPDM data model brought from IBM.
• Monitored the CA calls using nice calls to schedule the work and find scheduled hours for the resources to work on it.
• Created events and tasks in the work flows using workflow manager.
• Created schema objects like Indexes, Views and Sequences Involved in dimensional modeling of the data warehouse to design the business process.
• Designed Logical data model and Physical Conceptual data model using Erwin
• Created the ETL data mapping documents between source systems and the target data warehouse.
• Worked wif the OLTP database to generate the DDL.
• Data mapping using Business Rules and data transformation logic for ETL purposes.
• Involved in Migrating the 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 the process design documentation of the Data Warehouse Dimensional Upgrades.
• Assisted in the design of report layouts to maximize usability and business relevance.
• Involved in Migrating the data model from one database to oracle database and prepared oracle staging model.
• Worked in analyzing the 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 the 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 the models, ensuring that conflicts in descriptions and definitions are resolved.
• Performed the activities necessary to support the standardization of facts and dimensions.
• Identified the appropriate data sources wif the assistance the 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 the views in the Physical model.
• Gatheird, validated and document data requirements down to the 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 the 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 the business requirements into detailed reporting requirements for Data warehousing.
• Participated in JAD sessions involving the discussions of various reporting needs using AGILE methodology.
• Conducted Design discussions and meetings to come out wif the appropriate Data warehouse at the lowest level of grain for each of the Dimensions involved.
• Designed STAR schemas by identifying the facts, dimensions, measures and involving shared dimensions (Conformed) in ERWIN.
• Involved in designing the star schema by reverse engineering the existing database.
• Implemented the Snow-flake schema by normalizing the existing star schema.
• Involved in preparing Logical Data Models/Physical Data Models.
• Generated the DDL scripts by forward engineering the physical model and interacted wif DBA to implement the 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 the Version Changes
• Involved in version queue meeting to discuss wif SA and BA
• Worked in Building the OLTP Database for the 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 the data models.
• Applied the up to 3rd Normal forms on the OLTP database.
• Designed the models on both relational and dimensional areas.
• Generate the DDL using forward engineering
• Worked in merging and complete compare of Physical models.
• Analyzed the data for the projects and performed the data profiling, data mapping for different sources.
• Generated Logical data Models for old databases using Reverse engineering and documented.
• Designed the 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 the existing OLAP system(s) and created facts, dimensions and star schema representation for the Data mart.
• Created the data dictionary for the models and also performed the GAP analysis for the 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 the 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 the data marts using the Ralph Kimball’s Dimensional Data Mart modeling techniques. Identified the 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 the 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