SUMMARY

• 8+ years of professional experience in data modeling, Analysis, design, and development of databases for business applications in Client/Server and Data Warehouse environments. Extensive knowledge in finance, pharmaceutical, healthcare, banking and retail domains.
• Created maintained and modified database design document with detailed level description of conceptual, logical entities and physical data models as per the business requirements.
• Effective use of features like model mart design layers, complete compare, split model sources and transforms (sub type, super type and hierarchical layers).
• Performed system design with entities, attributes, logical relationships (identifying non - identifying). Preliminary database design obligatory and non obligatory analysis and validation of a model using Normalization techniques.
• Expertise in Software Development Life Cycle (SDLC), Use Cases and Rational Unified Process (RUP).
• Experience with requirements gathering, conducting JAD session to discuss overall design patterns.
• Experienced in Designing, Developing, Documenting and Testing of ETL jobs and mappings in Informatica to populate tables in Data Warehouse and Data Marts.
• Excellent knowledge of waterfall spiral and Agile methodologies of Software Development Life Cycle (SDLC).
• Experience in Financial/Finance Mortgage, Supply-Chain, Material Management and Health Care.
• Extensive Experience working with business users/SMEs as well as senior management
• Possess a Strong Analytical, verbal, inter-personal skills that helps in communicating with developers, team members.
• Optim Proficent in using MS Office including MS Visio and MS Project
• Experience in working with ETL - Extract, Transform, Load transactions using Informatica, Datastage.
• Assisted developers, ETL, BI team and end users to understand and maintain change log for each data model, Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Experience in using HTML, ASP, Visual Basic and Java Script for developing web based database applications with Oracle 9i, MYSQL and MS Access databases.
• Designed the Partitioning for tables according to business logic. Creation of Local/Global indexes depending on the types of queries to be performed on the table.
• Good knowledge and experience with Normalization /De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Strong understanding of the principles of Enterprise Data warehousing, Experienced with Dimensional data modeling for Data Marts.
• Identifying the Facts and Dimensions from the Enterprise Architecture for designing the Star and Snowflake Schema model.
• Experience in creating schema and table design, stored procedures, Triggers, Views and Indexes.
• Experience in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like Erwin, ER/Studio and Power Designer.
• Hands on experience with modeling using Erwin in both forward and reverse engineering cases.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies, good in building various logics to handle Slowly Changing Dimensions, Change Data Capture and Deletes for incremental Loads in to the Data warehouse and determining the hierarchies in dimensions.
• Good understanding and exposure to SQL queries and PL/SQL stored procedures, triggers, functions and packages, Teradata SQL Assistant.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus and SQL Navigator.
• Good experience in data transformation, data mapping from source to target database schemas and also data cleansing.
• Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables in the Datamart for the Initial load.
• Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• Strong Database experience using Oracle 10g/9i, XML, DB2,Teradata, SQLserver
• Good verbal and written communication, organizational and analytical skills combined with the ability to work in a fast paced environment as an individual and/or as a team member.
• Good understanding and knowledge with Agile and waterfall environments.
• Energetic and self-motivated team player with excellent communication.

TECHNICAL SKILLS

Data analysis: Requirements Gathering, JAD sessions, Process/Production Model analysis, Data Normalization, Cleansing, Profiling, System Design, Data architecture development, Metadata, Source and Target system analysis, Project Management.

Data modeling tools: CA Erwin 3.5/ 4.1.4/ 7.5.3/ 8.2.3 , Power designer 12.1, v15.3.0, ER/Studio 9.0.1, Toad data modeler, Visio tool, IBM Data Architect, JCL. MS Visio

Database systems: Oracle (11g, 10g/9i/8i/7.x), Teradata, SQL server (2005/2008), Sybase, MySQL, Microsoft Access 2007, DB2.

Operating systems: Microsoft windows 2000/2003/NT/ 2007/2008 .0/98/ Millennium edition/vista. Linux

Programming languages: SQL, PL/SQL, C/C++.

Additional QA Skills: Business and Software Process and Procedure Definition, Quality Models and standards (ISO 9001 2000, CMM,CMMI,TQM Principles, Six Sigma concepts), Quality tools (Ishikawa diagram, Pareto analysis, histogram Process), Measures and Metrics, Project Reviews, Audits and Assessments.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr Data modeler/ Database Design Analyst

Responsibilities:

• Data Modeling, Data Analysis for OLTP and OLAP systems.
• Logical & Physical Data Modeling, which involved;
• ER Modeling - Developing Entity Relationship Diagrams (ERD).
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Requirements & Business Process Analysis; Rapid Audit of the requirements and existing systems.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Design & Implementation of Data Mart; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Normalization techniques to arrive at effective Relational Schemas.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Involved incapturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Documented all the information of application and saving them for future .
• Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models.
• ETL Design & Implementation - Data Extraction, Transformation & Loading (using Oracle Warehousing Builder, SQL & PL/SQL).
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning)
• Create and alter SQL statements before sending database change request to DBA team.
• Maintained and documented all create and alter SQL statements for all release.
• Designing Data Flows & System Interfaces.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Documenting using Interface Diagrams, Flow Charts & Specification Documents.
• Coordinating with DBA team to implement physical models & to setup development, test, staging & production environments for MGP; BPR Management; DDL & DML Generation & usage.

Environment: CA-ERWIN 8.2.3, Oracle 11g/ 10g, Teradata V2R6, Oracle Warehouse Builder, SQL, PL/ SQL, Sybase Power Designer 12.5/ 15, SQL Server 2000/ 2005, UNIX, Toad, Business Objects, Ab Initio, Ms office, MS Access.

Confidential, Charlotte, NC

Sr Data Modeler

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Created logical data model from the conceptual model and it’s conversion into the physical database design using Erwin.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Extensive experience in BI process using tools Cognos, Crystal Reports, BO, OBI, and SSRS.
• Involved with data analysis using Teradata SQL assist from data source.
• Extensive knowledge in Data loading using PL\SQL Scripts and SQL Server Integration Services (SSIS).
• Worked with DBA’s to create a best fit physical data model from the logical data model.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Developed the data warehouse model (star schema) for the proposed central model for the project.
• Created Logical/Physical Data models in 3NF in the Warehouse area of Enterprise Data Warehouse.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• In order of better understanding the requirement documents, carried out couple of JAD sessions with Management, SME (Subject Matter Expertise), vendors, users and other stakeholders.
• Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables in the Datamart for the Initial load.
• Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• Maintained the integrity of data to ensure the effective functioning and also monitored data quality.
• Created high level ETL design document and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
• Assisted Reporting developers in building Reports using Crystal Reports.

Environment: Windows 2000/XP, Erwin 7.1, SQL server 2005/2008, Teradata, Business Objects XI, MS Excel 2007, Informatica 7.1.

Confidential, Tampa, FL

Sr. Data modeler/Business System Analyst

Responsibilities:

• Involved in gathering business requirements and translated business requirements.
• Actively participated inJAD sessionswith the subject matter expert, stake holders and other management team in the finalization of User Requirement Documentation.
• Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.
• Experience in identifying entities required and the relation between the entities to create Conceptual logical model.
• Worked on JCL to instruct the system on run a batch job and to start a subsystem.
• Efficiently developed theData model and ERD diagrams using Power designer.
• Created and maintained Logical Data Model (LDM) for the project which 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.
• Creating of the XML data model for the Express PA project for the Rules engine and providing the model in .XSD format for the services team.
• Creating the mapping documents to the find out the gaps between the mockup screens, services and database.
• Identifying the gaps and fills those gaps in the database by communicating with DBA.
• Enhancing the existing data model by reverse engineering by adding new tables based on the business requirements which will enhance in web services.
• Identifying the required fields for the Drug and Coverage check web services in the database and understanding initial data loading Process.
• Creatinglogical and physical model databaseandschema in oracle.
• Reverse engineering existing database to conduct source data analysis to identify the relationship between data sources.
• Worked with DBA to finalize the DDL’s.
• Worked on rationalizing the requirements across multiple product lines.
• Had brain storming sessions with application developers and DBAs to discuss about various denormalization, partitioning and indexing schemes for physical model.
• Schema Replication for development purpose using Power designer.
• Creating of the database scripts using Power designer and submitting to the DBA.
• Normalizing the Data and Developing the Relational database for the different web services and database.

Environment: Erwin 7.2/7.3 Oracle 10g, Power designer, JCL, Oracle SQL developer, SQL plus, Visio, MS office, CVS, Putty, Soap UI.

Confidential, New York, NY

Sr. Data modeler

Responsibilities:

• Building Data Mart (Conceptual, Logical and Physical) for reporting environment.
• Creating Data Dictionary for user defined databases (Collateral, Securities and Reporting) in Oracle, SQL Server.
• Worked on Data Conversion for ACH Transactions.
• In the role of Data Analyst performed analysis and design of extensions to an existing data warehouse/mart business intelligence platform
• Define enterprise data architecture vision, strategy, principles and standards; get buy-in from stake-holders, management, business partners, and propagate throughout the company.
• Segregated data and organized the data for common subjects using ODS
• Generated operational reports from ODS as opposed to the transactional/ legacy system.
• Performed Data Architecture in Designing and implementing a Metadata Repository providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the merger with Wachovia
• Implemented Agile Methodology for building an internal application.
• Worked on Data Aggregation.
• Generating Discrepancy reports using Ascential Data Stage.
• Preparing Functional Specifications Document for the project.
• Universe designing, developing and generating complex, Adhoc, dashboard Reports.
• Analyzing data in both application and reporting databases and solving the discrepancies.
• Tracking Data Model Change Requests to closure.
• Reverse engineering old database and creating subject areas for each schema.
• Preparing High Level Data Flow for all the major Applications
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Developed robust and efficient oracle PL/SQL procedures, packages and functions that for data analysis.
• Fine-tuned existing PL/SQL code and worked on upgrade from 9i to 10g.
• Fine-tuned Oracle SQL to be more efficient.

Environment: Oracle, SQL Server 2000/ 2005, Erwin 7.3, Power Designer 12.1, BO 6.5/ XIR2, MS Visio

Confidential, Houston, TX

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes tomake it compatible with business logic.
• Created Physical Data Model (PDM) for the OLTP application using ER Studio.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application

Environment: Erwin 3.5.2, Toad, PL/SQL, Windows 2005,Oracle 9i,Informartica 7.1,BO 6.5/ XIR2.

Confidential

Data Modeler

Responsibilities:

• Attended and participated in information and requirements gathering sessions with business users and sponsors to understand and document the business requirements as well as the goals of the project. .
• Participated in the meetings with Sr. Business Analyst and managers and understood various plans, business process, and functionality in detail.
• Ensured that business requirements can be translated into data requirements
• Defined business needs and assisted in developing appropriate manufacturing data as well as the implications of the solutions.
• Analyzed user requirements and designed functional specifications for database applications.
• Planned and implemented capacity and resource expansion to ensure scalability of company databases.
• Identified new process, finding out gaps in existing process, arranging modules for new process development and implementation.
• Identified issues with current database and resolved them.
• Implemented the standard naming conventions for the fact and dimensions entities and attributes of logical and physical model.
• Involved in the analysis of the existing claims processing system, mapping phase according to functionality and data conversion procedure.
• Normalized the data from first normal form till the third & fourth form as required
• Translated business requirements into working logical and physical data models.
• 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.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Developed queries using PL/SQL and many stored procedures to do the validations.

Environment: Erwin 3.5.2, Toad, PL/SQL, Oracle 9i, SQL Server 2000, SQL*Loader, UNIX, Windows 2005