SUMMARY

• 9+ years of professional working experience as a Data Modeler/Data Architect and Data Analyst wif high proficiency in requirement gathering and data modeling design of OLTP, OLAP systems.
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experienced in identifying entities, attributes, metrics, and their cardinality; also assigning keys, domains and check constraints and optimizing teh model.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• Expert in developing transactional enterprise data models dat strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
• Extensive experience in using ER modeling tools such as ERwin and ER/Studio, Teradata, BTEQ, MLDM and MDM
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Extensive experience wif Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Involved in teh maintenance of therepositories for teh metadata
• Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating wif End Users, Business Analysts, DBAs and Application Architects.
• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures
• Well versed in conducting Gap analysis, Joint Application Design (JAD) session, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
• Experience in generating DDL scripts and creating indexing strategies.
• Proficient in Data Cleansing and Data Profiling based on standards.
• Excellent analytical and communication skills wif clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good interpersonal and human relation skills to interact wif clients and co - workers
• Involved in teh preparation of Detailed Design Documentation.

TECHNICAL SKILLS

Analysis & Data Modeling Tools: Erwin 4.1/7.2/7.0/8.0, Sybase Power Designer 16, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio,Ambari

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos Powerplay.

ETL Tools: Microsoft DTS/SSIS, Data Stage 7.5, Ab Initio and Informatica Power Center 8.6.1/8.1/7.1.

Programming Languages: SQL, PL/SQL, Base SAS, T-SQL, HTML, XML, C, C++, UNIX and Shell Scripting.

Database Tools: Microsoft SQL Server 2000/2005/2012, MySQL, Oracle 11g/10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1.

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX (Sun Solaris 10),Big data

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler/ Data Architect

Responsibilities:

• Attended and actively participated in information and requirements gathering sessions
• Ensured dat business requirements can be translated into data requirements.
• Involved in data profiling and cleansing to remove redundant data by using Teradata SQL assistant, Toad, Beeswax.
• Translated business requirements into working logical and physical data models using teh Normalization and Denormalization Techniques.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tool Sybase Power designer 16.
• Created an enterprise data dictionary and maintained standards documentation.
• Created Design Data, Mapping Documents, and Lineage documents using teh Metadata extracted from teh Metadata repositories.
• Created lineage documentation for BI projects through sessions wif business teams.
• Involved in creating data marts using teh Denormalization techniques for reporting purposes.
• Designed teh database tables & created table and column level constraints using teh suggested naming conventions for constraint keys.
• Worked on created creating Dimensional design for BI projects, used SCD2 methodologies while creating teh PDM’s.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using power designer
• Generated teh DDL scripts for teh data model created to be deployed into Teradata, Hadoop.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using power designer
• Created and maintained Logical Data Model (LDM) for teh project. Creating teh natural keys, alternate keys, Indexes and partitions for a PDM.
• Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated teh appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Involved wif all teh phases of Software Development Life Cycle (SDLC) methodologies throughout teh project life cycle.

Environment: Sybase Power designer 16, Oracle 11g, Teradata, Hadoop, Informatica analyst, Toad, Ambari.

Confidential, MN

Data Modeler

Responsibilities:

• Attended and actively participated in information and requirements gathering sessions
• Ensured dat business requirements can be translated into data requirements.
• Involved in data profiling and cleansing to remove redundant data by using Teradata SQL assistant.
• Involved in teh analysis of teh existing Enterprise data Warehouse, mapping phase according to functionality and data conversion procedure.
• Translated business requirements into working logical and physical data models using teh Normalization Techniques.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tool Sybase Power designer 16.
• Used SCD2 methodologies while creating teh PDM’s.
• Generated teh DDL scripts for teh data model created to be deployed into SQL Server 2012.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using power designer
• Created and maintained Logical Data Model (LDM) for teh 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 teh 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 teh requirements and underlying platform functionality.
• Designed data models for MDM system.
• Extensively involved in teh modeling and development of Reporting Data Warehousing System.
• Involved in creating data marts using teh Denormalization techniques for reporting purposes.
• Designed teh database tables & created table and column level constraints using teh suggested naming conventions for constraint keys.
• Created PL/SQL packages 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.
• Extract data from a wide variety of source systems using Microsoft SSIS (SQL Server 2008 Integration Services)
• Provided support in teh transfer and development of reports through SSRS.
• Involved wif all teh phases of Software Development Life Cycle (SDLC) methodologies throughout teh project life cycle.

Environment: Sybase Power designer 16, SQL Server 2012, Teradata, SSRS, SSIS 2008, SQL.

Confidential, Jersey City, NJ

Data Modeler

Responsibilities:

• Conducting meetings wif business user SME’s to gather requirements necessary for teh project.
• Data profiling and analyzing teh requirements and developing models using reverse engineering using DDL scripts in ERWIN.
• Translate business requirements into Conceptual, Logical and Physical data models as well as integration of data models, model databases for integration applications in a highly available and performance configuration using Erwin.
• Created 3NF business area data modeling wif de-normalized physical implementation; data and information requirements analysis.
• Defined teh Primary Keys (PKs) and Foreign Keys (FKs) for teh Entities, created dimensions model star and snowflake schemas using Kimball methodology and designed them using ERwin 7.2.
• Responsible for data modeling and building a star schema model in ER Studio
• Created an enterprise data dictionary and maintained standards documentation
• Assisted data warehouse project team in extracting business rules
• Maintained and updated Metadata repository based on teh change requests
• Part of teh team responsible for teh analysis, design and implementation of teh business solution.
• Teh Data Mart (BMDM) system stores marketing data in DB2 database and is interrogated using teh Power play\ Impromptu end-user reporting tools
• Analysis of data requirements and translation of these into dimensional as well as relational data models
• Extensively involved in source system analysis, source to target mapping, data parsing and profiling
• Responsible for designing Star and Snowflake schema design, ETL process, implementation and Wrote stored procedures and supported teh in-house applications.
• Tuning all database via indexing of tables, MS SQL Server 2000 configuration parameters and stored procedures SQL code optimization.
• Participated in teh tasks of data migration from legacy to new database system
• Worked on Metadata exchange among various proprietary systems using XML
• Handled performance requirements for databases in OLTP and OLAP models.
• Created entity / process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams
• Developed teh logical data models and physical data models dat capture current state/future state data elements and data flows using ER Studio.

Environment: Erwin7.2,ER Studio 8.0.3, Oracle, SQL Server 2008, Tableau 7.0, Crystal Reports 8.0, Crystal Enterprise8.0

Confidential, Jersey City, NJ

Data Modeler/ Data Analyst

Responsibilities:

• Part of teh team responsible for teh analysis, design and implementation of teh business solution.
• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Worked wif teh project manager to develop teh project plan for teh first two phases of teh project.
• Resolved teh revolving issues by conducting and participating in JAD sessions wif teh users, modelers and developers.
• Conducted design discussions and meetings to come out wif teh appropriate data mart.
• Obtained 2NS, 3NS, developed teh Star/Snowflake Schema, for teh proposed warehouse model to meet teh requirements.
• Enforced mandatory capture metadata during teh logical phase design.
• Identified teh Objects and relationships between teh objects to develop a logical, physical model in Power Designer and later translated teh model into physical model using teh Forward Engineering technique in Power Designer.
• Defined and processed teh facts, dimensions.
• Created Design Data, Mapping Documents using teh Metadata extracted from teh Metadata repositories.
• Good experience in data analysis querying and writing in SQL queries and TOAD.
• Resolved teh data type inconsistencies between teh source systems and teh target system using teh Mapping Documents.
• Created DTS packages to upload databases and files of various formats to MS SQL Server 2000 using Data Transformation Services (DTS).
• Used Crystal Reports to generate reports.
• Created documentation and test cases, worked wif users for new module enhancements and testing.
• Proficient in Utilities such as TOAD.
• Has good experience on MS Office suite.
• Used ER/Studio for relational database and dimensional data warehouse designs
• Reverse Engineered DB2 databases and then forward engineered them to SQL Server 2000 using ER/Studio, Power Designer
• Developed logical data model using ER/Studio and created physical data models using forward engineering
• Implementation of Active Data Warehouse supporting near-time /near-real-time decision making
• Worked on Teradata (ADW) to provide operational intelligence based on historical data combined wif today’s up-to-date data

Environment: Erwin 4.0, Erwin 3.5.2, Toad, DB2, SQL Server 7.0/2000, MS OLAP, Crystal Reports7.5/8.0, Windows NT/2000, Crystal Enterprise8.0, Power Designer, Teradata