SUMMARY:

• 11 years of professional experience in data modeling and data analysis.
• Proficient in gathering business requirements and handling requirements management.
• Excellent command over Logical and Physical entity relationship data modeling using Modeling tools
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Well versed with Data Migration, Data Profiling, Data Extraction/ Transformation/ Loading (ETL)
• Participated in all phases of Software Development Life Cycle (SDLC).
• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures using.
• Knowledge of Big Data concepts, Hadoop Architecture and Hive query language.
• Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Excellent analytical, inter - personal and communication skills with clear understanding of business process flow

TECHNICAL SKILLS:

Data Modeling Tools: Power Designer 15.2, Erwin 9.6, ER Studio, Access, Visio

Programming Languages: SQL, PL/SQL

Databases: ORACLE 11g, Netezza, DB2, MS SQL Server 2000, MS-Access Rational Suite Rational Rose, Rational RequisitePro, Rational ClearCase, Rational Clear Quest

Project Management Tools: Object Oriented Analysis and Design(OOAD) Using Unified Modeling language(UML), Rational Unified Process (RUP), MS Project, MS Visio, HP Quality Center, SVN

Data warehouse Tools: Informatica, Cognos, Oracle Warehouse Builder, SQL Developer

BI Tools: COGNOS 7.0, Business Objects 4.0/5.0/6.0 and Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Dallas TX / Warren, NJ

Data Architect/ Modeler, Team Lead

Responsibilities:

• Understand the transaction data provided by various product processors.
• Primary modeler for design of Journal record, Metadata and Reference data, Entitlements modules related to the project.
• Perform data analysis/Investigation on the source systems for better understanding of the data and assist in data related issues.
• Conduct knowledge sharing sessions with the Architect and SMEs and design the Data Flow Diagram.
• Designed logical and physical data models for the different components of Finance Backbone system in Erwin Tool.
• Ensure that the logical model follows the normalization rules and have the best possible traceability pattern.
• Create logical and physical data models using Erwin and reviewed these models with business team and data architecture team.
• Ensure that the data models are updated and follow the enterprise naming standards.
• Created business data constraints, Bitmap and B-Tree indexes, sequences, partitioning etc as needed in the Physical data model.
• Created ddls in Parquet format for deployment in Hadoop.
• Deploy Database objects to various environments across multiple regions.
• Create custom views in Data Access layer for consumption by downstream applications.
• Created Source to Target mapping documents for any new source data.

Environment: Erwin r8, Oracle, Netezza, SQL Developer, Informatica, EBX5, Microsoft Visio, HPQC, SVN

Confidential, Dover, NH

Data Modeler

Responsibilities:

• Understand the application and Business requirements for the enhancements of ARMMS Application.
• Conduct knowledge sharing sessions with the Architect and SMEs and design the Data Flow Diagram.
• Identify all the data architecture tasks involved and provide detailed estimates accordingly.
• Updated logical and physical data models using Erwin and reviewed these models with application team and data architecture team.
• Supported the DBA in the physical implementation of the tables in DB2 environment.
• Ensure that the data models are updated and follow the enterprise naming standards.
• Created business data constraints, indexes, sequences etc as needed in the Physical data model.
• Created Source to Target mapping for the new fields as user defined properties in Erwin data model.
• Converted SilverRun data models into Erwin data models.

Environment: Erwin r7, DB2, Teradata, DbVisualizer, Informatica, Microsoft Visio, windows 7, SilverRun, Notepad++.

Confidential, St. Louis, MO

Data Modeler

Responsibilities:

• Part of the Confidential Data Management team and responsible for design and implementation of Brokerage ODS and Warehouse environments.
• Understanding the business requirements from various brokerage application teams and updating the ODS for capturing any new transactional data elements and DW for any new reporting needs.
• Reviewed the application business requirements and created the Functional Data Requirements document highlighting the changes needed within the Data Management team for the successful completion of the project.
• Created new conceptual, logical and physical data models using Erwin and reviewed these models with application team and modeling team.
• Conducted impact analysis for the proposed changes with various application teams.
• Created SSA Documents for each new or updated table and reviewed the document with ETL Tech Lead. The document includes Source to Target mapping, Data selection criteria and transformation logic
• Performed analysis to identify if there are any data gaps and issues within ODS and BDW which might be of concern to the project and resolve it.
• Created the DDL and DML scripts and supported the DBA in the physical implementation of the tables in both Oracle and DB2 databases.
• Created business data constraints, indexes, sequences etc as needed in the Physical data model.
• Supported the ETL and Testing teams with any issues identified during the lifecycle of the project.
• Created the file layouts for any new data being received or extracted from ODS and BDW. Reviewed these file layouts and handed over to the Central File Distribution team

Environment: Erwin r7, Oracle, DB2, Toad, Teradata, Informatica, Documentum, Microsoft Visio, windows XP.

Confidential, St. Louis, MO

Data Modeler / Architect

Responsibilities:

• Involved in the projects from requirement analysis to better understand the requirements and support the development team with a better understanding of the data.
• Did the impact analysis for multiple projects from a data modeling prospective.
• Designed logical and physical data models for multiple OLTP and Analytic applications.
• To Design the logical Model and ensure that it follows the normalization rules and have the best possible traceability pattern
• Developed the Star Schema/Snowflake Schema for proposed warehouse models to meet the requirements.
• Supported the DBA in the physical implementation of the tables in both Oracle and DB2 databases.
• Performed Reverse Engineering of the current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Created business data constraints, indexes, sequences etc as needed in the Physical data model.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries.
• Resolved the revolving issues by conducting and participating in JAD sessions with the users, modelers and developers.
• Designed class and activity diagrams using Power Designer and UML tools like Visio
• Resolved multiple Data Governance issues to support data consistency at the enterprise level.
• Created Party model for Enterprise Data Repository(EDR) designed to support the enterprise data needs for multiple applications across the organizations.
• Involved in physical transformation and Load of data for multiple Projects.
• Simultaneously handled multiple projects from various groups across Mastercard.
• Responsible for ensuring and providing consistent metadata across all the models in MasterCard.

Environment: PowerDesigner 10/12/15,Erwin r7, Oracle (9i,10g,11g), DB2, SQL Server 2000, Toad, DataStage, Microsoft Visio 2003, windows XP, Notes.

Confidential, Burbank, CA

Data Modeler / Analyst

Responsibilities:

• Responsible for understanding the use cases and business rules and make the appropriate changes to the data model.
• Redesigned some of the subject areas and introduced new entities and attributes as per the requirements.
• Interacting with business analyst to understand the ITDS process and updating the use cases as discussed with the users.
• Was responsible for the design of report mockups and the data mapping related to those reports.
• Used Erwin to transform data requirements into data models.
• To design the transactional database up to the fourth normalization.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.

Environment: Sybase, Erwin, Microsoft visual studio 2005, Microsoft Visio 2003, windows server 2003.