PROFESSIONAL SUMMARY:

• Goal - oriented professional with experience in designingrelational and dimensional data models.
• Experience in Fi telecommunication, financial, Retail & Health Care domains.
• Strong background in various Data Modeling tools using ERWIN.
• Expert knowledge in SDLC (Software Development Life Cycle)
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical data model/Physical data models Designs, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources and creating interface documents.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWIN.
• Participated in JAD sessions, created Use Cases, work flows and Power Point presentations.
• Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design.
• Gathered and documented Functional and Technical Design documents.
• Have experience in extensive data profiling & Analysis.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Experience in SQL Performance Tuning and Optimization
• Experience in creating Materialized views, Views, Lookups for the Oracle warehouse.
• Experience with Erwin model manager.

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i, MS SQL Server 2003/2005/2008

SQL Interpreters: Erwin 8/7.x/4.x, Toad

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data extraction, Integration, transformation and Migration, ETL Architecture and Design Data Warehouse, OLTP, OLAP, Report Design and Development.

Data Analysis: User Requirement Gathering, JAD Sessions, Gap Analysis, Data Cleansing, Data Transformations, Source Systems Analysis, Data Relationships.

ETL Tools: SAP Business Objects, Informatica

Reporting Tools: Tableau, Crystal Reports

MS Office Tools: Excel, Access, Word, PowerPoint, Project, Visio

Languages: VB, PL/SQL, Java Script, Java, Python

Operating Systems: Windows 8/7/ XP/00, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Annapolis, MD

Sr. Data Modeler

Responsibilities:

• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements
• 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.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Maintained data model and synchronized it with the changes to the database.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Experience in MPP architectures.
• Designed the database tables & created table and column level constraints using the suggested naming conventions for constraint keys.
• Used ETL tool SAP DS to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developed stored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• Reviewed the database programming for triggers, exceptions, functions, packages, procedures.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Tools: Erwin 8, Oracle 11, Teradata 12, SAP Data Services, Toad

Confidential, Wilmington, DE

Data Modeler

Responsibilities:

• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• 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, and glossary terms in accordance with the Corporate Data Dictionary 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.
• Conducted all data model reviews as appropriate during project lifecycle
• Maintained data model and synchronized it with the changes to the database
• Master data management.
• Provided input to resolve data limitation and issues.
• Performance tuning.
• Attended and participated in information and requirements gathering sessions (JAD).
• Ensured that business requirements can be translated into data requirements.

Tools: ER Studio, Oracle 11g R2, SQL SERVER 2008 R2, TOAD, MS Office, Linux, Windows

Confidential, Parsippany, NJ

Data Modeler

Responsibilities:

• Attended and participates in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for Staging, Operational Data Store and Data marts applications.
• Performed gap analysis and dependency analysis for current & future systems.
• Designed Star Schema Data Models for Enterprise Data Warehouse using Power Designer.
• Created Mapping documents for Staging, ODS & Data Mart Layers.
• Created and maintained Logical & Physical Data Models for the project. Included 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 Models to process mappings, screen designs, use cases, business object model, and system object model as they evolved and changed.
• Created Model reports including Data Dictionary, Business reports.
• Generated SQL scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.
• Performance tuning

Tools: Erwin 7, Oracle 10g, Informatica, Toad

Confidential, Philadelphia, PA

Data Modeler/Analyst

Responsibilities:

• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Translated business requirements into working logical and physical datamodels 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.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Maintained data model and synchronized it with the changes to the database.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Designed the database tables & created table and column level constraints using the suggested naming conventions for constraint keys.
• Used ETL tool BO DS to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developedstored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• Reviewed the database programming for triggers, exceptions, functions, packages, procedures.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.

Tools: Erwin 4, MS Visio, Oracle 10g, Business ObjectData IntegratorR2

Confidential

Data Modeler

Responsibilities:

• Responsible for gathering and translating business requirements into detailed, production-level technical specifications,
• Creating robust data models, data analysis features and enhancements
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end userCollaborate with BI teams to create reporting data structures.

Tools: ERWIN 4, Oracle 10g, SAP Business ObjectsData Services3.x

Confidential

Oracle Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in Logical & Physical Database Layout Design using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus and PL/SQL scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.Improved the performance of the application by rewriting the SQL queries.

Tools: Oracle 10, PL/SQL, Erwin 4.1, Windows

Confidential

SQL Developer

Responsibilities:

• Developing and maintaining Stored Procedures for the Credible platform
• Developing and delivering custom reports for customers
• Troubleshooting and performance tuning existing queries
• Supporting various data imports and issues in off-hours as needed
• Monitoring and optimizing the performance of the databases
• Worked with technology teams who are supporting source systems to understand source data constraints to meet the business requirements.
• Designed Logical and Physical data models based on the business reporting and analytical requirements.
• Produced Physical Data models and suggested proper indexing that promotes fast data retrieval based on BI usage.
• Produced DDL and DML for implementing physical data structures on the database.
• Maintained, followed and enhanced enterprise data model development standards.
• Attend weekly status meetings to discuss the s and milestones of the project.

Tools: Erwin 4, SQL Server 2000, Visio MS-Office, Excel s will be furnished upon request