PROFESSIONAL SUMMARY:

• Over8yearsof professional IT experience inData Modeling for Online Transactional processing (OLTP)and Online Analytical Processing (OLAP)systems.
• Experience in understanding the business needs and gathering user requirements by conducting and participating in JAD sessions, interacting with end - users and them on the applications developed for the organization.
• Expert knowledge inSDLC(Software Development Life Cycle) and was involved in all phases in projects.
• Experience inDesign, Development and implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data driven business applications.
• Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects
• Extensively worked on ERWIN tool with all features like REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.,
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.
• Experience withBusiness Process Modeling, Process Flow Modeling, Data flow modeling
• Experience in working with creating ETL specification documents, & creating flowcharts, process work flows and data flow diagrams.
• Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
• Performed extensive data cleansing, data manipulations and date transforms and data auditing.
• Experience in usingOracle, SQL*PLUS,and SQL*Loader
• Developed database objects like PL/SQL packages, Oracle tables, stored procedures, triggers that are used for meeting the business objectives.
• Developed Data dictionary and maintained Metadata for each model.
• Coordinated with other developers in tuning long running SQL queries to enhance system performance.
• Involved in debugging and developing exception-handling procedures whenever required
• Extensive knowledge in software testing methodology and developing Test Plans, Test Procedures, Test Case Design and Execution, Modification Requests.
• Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.
• Good documentation skills and was involved in making functional and technical documentation.
• A strong team member with good Communication and Analytical skills.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin, MS-Visio

Programming Languages: Oracle PL/SQL,MS-SQL,VB 6.0, VB, ASP.NET

Databases: Oracle, SQL Server, MS-SQL, MS-Access

Web technologies: HTML, DHTML, XML

Operating Systems: Windows-95-2007/XP/NT/Vista, 8

PROFESSIONAL EXPERIENCE:

Confidential, Westlake, OH

Sr. Data Modeler/Data Analyst

Responsibilities:

• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• 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.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated high-level data access documentation for processes
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Generated process data CRUD (Create/Read/Update/Delete) matrix
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintained data model and synchronized it with the changes to the database
• Provided input to resolve data limitation and issues
• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements

Environment: ERWIN, Oracle 11g, MS Visio, MS Office, Windows

Confidential, OH

Sr. Data Modeler/Data Analyst

Responsibilities:

• Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications.
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and Development to team gather, analyze and document the Business and reporting requirements.
• Analyze the Business information requirements and research the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Involved in making screen designs,Use Cases and ER diagrams for the project using ERWIN and Visio.
• Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements involving multiple subject areas, domains and naming standards.
• Designed and developed the DDL scripts, data mapping documents, data dictionary and Meta data of the models and maintained them.
• Coordinated withDBAon data base build and table normalizations and de-normalizations
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during the project
• Generated user and technical documentation for individual processes
• Identified and streamlined complex queries which were causing iterations and effecting database and system performance
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Coordinated in database changes needed for the front end development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Work directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified by customers.

Environment: ERWIN, Oracle, MS-SQL Server, MS-Visio, MS Office

Confidential

Responsibilities:

• Translated Business Requirements into working Logical and Physical data models for OLTP, Data Warehouse and Data Mart applications.
• Designed data model for OLTP applications using the ERWIN tool.
• Attended JAD sessions with the business analysts in order to understand the client and the end user reporting needs.
• Designed Conceptual, Logical and Physical data models using the ERWIN tool.
• Generated DDL scripts during the forward engineering process for the actual physical build of the database.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Maintained different Versions of the Data Model to make sure that it stayed synchronized to the changes in the database.
• Generated reports using the ERWIN tool in order to assist the ETL teams.
• Provided on data model to different application groups across the enterprise.
• Extensively used complex SQL queries for querying and analysis of data
• CreatedStored Procedures in order to implement the business logics.
• Created Triggers and Sequences in the Physical Data Model so as to meet the business logics as and when required.
• Provided other data analysis services as required.

Environment: Erwin 7.1, SQL, PL/SQL, Oracle 9i

Confidential

Data Modeler

Responsibilities:

• Analyzed the Business information requirements and research the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and Development to team gather, analyze and document the Business and reporting requirements.
• Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications for estate management projects
• Coordinated with the Business Analyst and designed Logical and Physical Data-models as per the requirements
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.
• Designed and developed the Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models and maintained them.
• Coordinated withDBAon data base build and table normalizations and de-normalizations
• Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements involving multiple subject areas, domains and naming standards.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during the project
• Identified and streamlined complex queries which were causing iterations and effecting database and system performance
• Coordinated in database changes needed for the front end development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Worked directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified by customers.
• Maintained change log and history tables for each data model and solved the production issues by debugging the code.
• Coordinated with Informatica ETL developers in providing data mapping and sql queries for bulk data load
• Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.

Environment: ERWIN 7.2 and 7.3, Oracle, MS-Visio, SQL Developer, MS Office

Confidential

Sr. Data Modeler

Responsibilities:

• Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications.
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and Development to team gather, analyze and document the Business and reporting requirements.
• Analyzed the Business information requirements and researched the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Coordinated with the Business Analyst and designed Logical and Physical Data-models as per the requirements
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.
• Designed and developed the Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models and maintained them.
• Coordinated withDBAon data base build and table normalizations and de-normalizations
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, usingindustry leadingData Modeling tools likeERWIN.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during the project
• Used various features of Oracle like Collections, Associative arrays, Bulk processing methods to write effective code.
• Identified and streamlined complex queries which were causing iterations and effecting database and system performance
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Coordinated in database changes needed for the front end development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Worked directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified by customers.
• Maintained change log and history tables for each data model and solved the production issues by debugging the code.
• Coordinated with Informatica ETL developers in providing data mapping and sql queries for bulk data load
• Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.

Environment: ERWIN 7.2 and 7.3, Oracle, MS-Visio, SQL Developer, MS Office