PROFESSIONAL SUMMARY

• Qualified professional with 7+ years of experience in relational database, data warehouse and data modeling concepts.
• Experienced in designing Conceptual, Logical and Physical data modeling using Erwin, Power Designer and ER Studio Data modeling tools.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies
• Experienced in forward and reverse engineering, model manager, complete compare and report generation.
• Excellent ability to understand business needs and data to generate end - to-end business solutions.
• Experienced in Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experienced in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experience in relation data warehouses built on MS SQL, Access, Oracle, Teradata, and Netezza
• Experience in modeling with both OLTP/OLAP systems.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema.
• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Extensive knowledge of reporting tools such as SQL and ACCESS for underlying database tables and resolve data issues.
• Good experience in giving join conditions to business analysts, developing data mapping from source to stage and stage to target database schemas.
• Excellent skills in Data Analysis with exposure to different SDLC Methodologies such as Waterfall, AGILE and Hybrid methodology.
• Highly motivated team player with excellent communication, presentation, and interpersonal skills and always willing to work in challenging and cross-platform environment.

TECHNICAL SKILLS

Data analysis: Requirements Gathering, JAD sessions, Process/Production Model analysis, Data Normalization, Cleansing, System Design, Data architecture internal Standards development, Metadata, Bulk Editor and Reports, Source and Target system Analysis, Project Management.

Data modeling tools: CA Erwin, Netezza Power designer, ER/Studio, MS Visio

Database systems: Oracle, Teradata, SQL server, Sybase, MySQL

ETL Tools: Informatica, Microsoft SSIS, SSRS

Operating systems: Microsoft windows 2000/2003/NT/2007/2008.

Languages: T-SQL, PL/SQL, .Net, HTML

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Data Modeler / Data Analyst

Responsibilities:

• Analyzed, compared and recommended blue print for consolidating the various Data warehouses, Data Marts, Operational Data Stores and associated front-end technologies.
• Identified several attributes and the relationships between the tables.
• Created logical data model from the conceptual model and it’s conversion into the physical database design using Erwin.
• Provided Data models in Teradata environment.
• Defined the data types and definitions for the fields to best explain its usage in the business.
• Conducted several meetings with Business Analyst, SME’s and ETL developers to come up with best-fit models.
• Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Involved in high level ETL design review sessions and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Translated business requirements into logical and Physical data models with business rules.
• Maintained Metadata in a data dictionary.
• Research and documented data quality issues and potential resolutions.
• Created and maintained documentation of data models, referential integrity, and ETL mappings.
• Conducted meetings to walk through data model and explained business rules and mappings
• Maintained naming standard file and data modeling templates for consistency
• Involved in analyzing data quality issues and performance tuning
• Worked closely with stakeholders, SMEs throughout the course of the project

Environment: Erwin 9.x, SQL server 2012, Teradata 13.10, MS office, MS Access, Visio, Informatica

Confidential, Mount Laurel, NJ

Data Modeler / Data Analyst

Responsibilities:

• Responsible for the analysis of business requirements and design implementation of the business solution.
• Developed Conceptual, Logical and Physical data models for central model consolidation.
• Worked with DBAs to create a best-fit physical data model from the logical data model.
• Conducted data modeling 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.
• Developed process methodology for the Reverse Engineering phase of the project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database-using Oracle.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin 8.x, Informatica, Oracle 10g, SQL Server 2012, MS Excel, MS Visio

Confidential, High Point, NC

Data Modeler/ Data Analyst

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.
• Reviewed models with DBA to have best-fit physical Model Indexes for better DB performance.
• Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Developed the data warehouse dimensional models & schema for the proposed central model for the project.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Worked on Snow-flaking the Dimensions to remove redundancy whenever required.
• 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 were added for this project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Maintained the integrity of data and data quality.
• Conducted data profiling for better understanding of joins in ER models
• Involved in high level ETL design review sessions and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Worked with project release meeting manager for UAT tables going to production.
• Handled metadata publish tasks to our internal data dictionary from internal DB MS Access
• 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: SQL Server 2012, Oracle 10g, Erwin 7.x, Windows, MS office, MS Access, Visio, Informatica.

Confidential, Cleveland, OH

Data modeler/Data Analyst

Responsibilities:

• Involved in gathering business requirements and translated business requirements.
• Actively participated inJAD sessionswith the subject matter expert, stakeholders 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 to 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: Oracle 10g, Power designer 12, JCL, SQL plus, Visio, MS office, Soap UI.

Confidential, Iselin, NJ

Data Analyst

Responsibilities:

• Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints
• Developed physical data model and created DDL scripts to create database schema and database objects.
• Created user requirement documents based on functional specifications.
• Created new tables, written stored procedures, triggers, views, functions.
• Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split, Merge Join, Union and Execute SQL Task to load into database.
• Created SQL scripts for tuning.
• Data Extracted from Flat files, Excel and Transformed as per the logic and loaded into Data warehouse.
• Created packages to schedule the jobs for batch processing.
• Involved in performance tuning to optimize SQL queries.
• Created and Maintained Indexes for various fast and efficient reporting processes
• Understanding the DLD specifications document and working with design to develop the mappings using SQL Server Integration Services (SSIS).
• Identified the fact tables, dimensions and the key measures.
• Assisted data warehouse project team in extracting business rules.
• Created an enterprise data dictionary and maintained standards documentation.
• Interacted with the end users and found out the performance of the database and also involved in developing test cases.

Environment: SQL Server 2008, Erwin, T-SQL, Enterprise Manager, Query Analyzer, Windows, and MS Office.

Confidential, Denver, CO

Business Analyst / Data Analyst

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to be compatible with business logic.
• 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: ER Studio, Informatica Power Center, PL/SQL, Oracle 9I, SQL Server 2008, SQL*Loader, AIX, Windows.