SUMMARY

• 7 years of experience as a DataModeler/ Analyst with solid understanding of Dimensional Modelling, Relational Modelling and Data Warehousing Concepts
• 7 years in Information Technology with Expertise in Data modelling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing(OLTP) and Data Warehousing (OLAP)
• Exposure in overall SDLC including requirement gathering,design,modelling, development, testing, debugging, deployment, documentation, production support and extensive experience in Project Management methodologies
• Involved in various projects related to Data Modelling, System/Data Analysis, Design and development for both OLTP and Data warehousing environments
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications
• Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star - Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of Views, Synonyms, Indexes, Joins and Partitioning
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Informatica
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships
• Exceptional communication and presentation skills and established track record of client interactions
• Self-motivated quick learner with exceptional analytical and problem solving skills

TECHNICAL SKILLS

Methodologies: Software Development Life Cycle (SDLC), Agile,Waterfall

Languages: SQL,Unified Modeling Language (UML), HTML

Operating Systems: Windows 95/98/2000/NT/XP, Win 7/8

Data Modelling Tools: ER Studio Data Architect 9.5, Erwin 9.0, Erwin 7.1/7.2, SQL Developer, Toad for Oracle

Other Tools: MS Office (Word, PowerPoint, Outlook, Access, Excel), MS SharePoint, MS Visio, MS Project, MS FrontPage, Microsoft Front Page

Testing Tools: HP Test Director, HP QuickTest Pro, HP WinRunner

Data Base: Oracle, Green Plum, DB2

PROFESSIONAL EXPERIENCE

Senior Data Modeler

Confidential, New Hampshire

Responsibilities:

• Facilitated and managed Data Review Board meeting sessions with committee of Product Owner/ Sponsor, Developers, Modelers and Data Review Board/ Data Governance
• Responsible for conducting peer data model review as well as final review with the offsite Data Governance Team
• Responsible for creating Logical and Physical Model for all Final tables going to Production
• Maintaining Metadata Repository at both Entity and Attribute Level and adding additional comments where necessary
• Constant Interaction with Development Lead to understand table structures and data elements
• Check the naming standards, data integrity and referential integrity
• Checked the reports for any naming inconsistencies and to improve user readability
• Responsible for providing DBA/ Modelling advice on multiple Software Change Requests to the developers
• Responsible for reviewing Data Models with offsite Data Review Board according to JPMC standards
• Utilizing UDP, Domain and CDE Functionality for all Data Models using Erwin 9.5
• Used Reverse Engineering as well as Forward Engineering Functionality in Erwin 9.5
• Checked in Codes using Serena Version Manager and maintained Logs
• Responsible for Install in Dev Environment and also creating triggers, partition, grants and public synonyms
• Test the Scripts for any errors or discrepancies using SQL Plus and fix any issues
• Responsible for Handling New Software Change Requests for multiple projects
• Responsible for Updating Data Lineage/Mapping Document according to the business requirements

Environment: Iterative, Toad, Erwin 9.5, SQL Plus, Oracle 11g, People Soft, Serena Version Manager, Exadata, MKS PTC Integrity Client, MS Word, MS Excel, MS Share point, Microsoft Outlook

Senior Data Modeler

Confidential, Wisconsin

Responsibilities:

• Worked closely with the Data Architects, Tech Lead, Business Analyst, SME’s to get a very good understanding of the Design, Data flow and the Business requirements
• Identified the data requirements, source and target databases. Created the ETL mapping document by mapping data from source to target databases
• Designed Conceptual, Logical and Physical Data Models
• Responsible for creating physical data models using ER Studio Data Architect 9.5
• Checked for all the modelling standards including naming standards, class words, entity relationships on model, validation, comments and history in the model
• Created Dimensions, Fact andStar Schemas
• Reviewed Data Models with other Data modellers in a data modelling review session before generating the DDL and checking it in the repository
• Worked with the DBA to get the Oracledatabases created using the DDL from ER Studio Data Architect 9.5
• Reverse Engineered an existing database to make sure that the data model is in sync with the data base and also to provide JPG Image of the model to the end business users
• Created Views on top of the underlying tables for end business users for SAS purposes
• Created Data Ware house and Data mart models
• Checked if data model is in sync with the business requirements
• Actively participated in the sprint planning sessions and gave time estimates to the Project manager
• Performed Data Analysis by understanding the Data and Business requirements better. Used Data Dictionary to fully understand the data elements and also through constant communication with Data Architects

Environment: Oracle,DB2, Green Plum, ER Studio Data Architect 9.5, SQL Developer, Agile, Scrum, MS-Project, Visio, MSOffice Suite (Word, Excel, Access, PowerPoint, and Outlook), Rally,Jira, TOAD

Senior Data Modeler

Confidential, New Jersey

Responsibilities:

• Closely worked with Business Analyst on requirement gathering sessions and validation process in the requirements walkthrough meeting
• Actively participated in the project planning sessions and gave estimates to the project manager
• Ensured that all the Business Entity Definitions are obtained based on which the physical table and column names will be defined
• Created logical&physical data models using Erwin data modelling tool
• Identified the data requirements, source and target databases
• Participated in the tasks of data migration from legacy to new database system
• Applied Met Life Naming Standard Utility and used appropriate class words for physical models
• Responsible for creatingData Mapping/ Data Lineage Document
• Worked with Slowly Changing Dimensions
• Coordinated with the DBA for physical implementation of database tables through generation ofDDL from Erwin 9.0
• Profiled the data quality using Toad for Oracle
• Created star schemas that best suits for report development
• Worked with the Implementation Team to ensure a smooth transition from design to the implementation phase

Environment: Oracle, DB2, Erwin 9.0, SQL Developer, TOAD MS-Project, Visio, MSOffice Suite (Word, Excel, Access, PowerPoint, and Outlook), Jira, Agile, Scrum

Data Modeler

Confidential, Dublin, Ohio

Responsibilities:

• Identified high-level requirements for developing and documenting detailed business requirements
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution
• Developed logical and physical data models for model consolidation
• Worked with DBAs to create a best-fit physical data model from the logical data model
• Conducted data modelling JAD sessions and communicated data-related standards
• Used Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Utilized Erwin’s reverse engineering and target database schema conversion process
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Used ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server
• Active Participant in different team review meetings
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata
• Involved in the critical design review of the finalized database model
• Created documentation and test cases, worked with users for new module enhancements and testing
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database

Environment: Erwin 7.2,Informatica Power Center 8.1,Windows XP/NT/2000 servers, Oracle 10g, SQL Server, MS Excel, MS Visio, DB2, Crystal Reports, MS-SQL

Data Analyst / Modeler

Confidential

Responsibilities:

• Performed business and application analysis, identified enhancement opportunities, managed bugs, performed issue resolution & assisted with tracking of the project plan
• Involved in managing all phases of the project life cycle from initiation through implementation
• Interacted with users and business analysts to gather requirements
• Understood existing data model and documented suspected design affecting performance of the system
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
• Created logical data model from the conceptual model and its conversion into the physical database design using Erwin
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Applied second and third normalization to normalize existing ER data model of OLTP system
• Used De-normalization technique to create summary tables and improved complex Join operation
• Created integrity rules and defaults
• Done analysis of resource intensive query and applied changes in existing back-end code (stored procedures, triggers) to speed up report execution
• Maintained security and data integrity of the database
• Done analysis of live site issues related to database and resolved them

Environment: Erwin, Oracle,Water Fall, Microsoft Excel, Microsoft Outlook, Visio