Data Sql Server

+1-774******* **********@*****.***

SUMMARY

Around 7+ years of extensive experience in Data Modeling, Data Analysis for Online Transactional Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications.

Experienced in developing Entity Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.

Adept in implementing Normalization (1NF, 2NF and 3NF), De-normalization, Ralph-Kimball and Bill Inmon’s data modelling techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart designs.

Worked in both Forward Engineering as well as Reverse Engineering using data modeling tools.

Efficient in data mart design, creation of cubes, dimensional data modeling, identifying Facts and Dimensions, Star Schema and Snowflake Schema.

Good knowledge of Data Vault Modeling.

Proven knowledge in data cleansing, data transformation, data mapping specifications from source to target database, Data warehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.

Experienced in working with BI Reporting tools such as Micro-Strategy, Business Objects and SSRS producing tables, reports, graphs and listings using various procedures performing complex data manipulations.

Experienced in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration by using SQL Server Integration Services (SSIS), PL/SQL Scripts and Informatica against heterogeneous data sources.

Experienced in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, SQL server, Teradata, DB2 and multi-dimensional database.

Experienced in designing, error handling and exception handling procedures to identify, record and report errors.

Professional in practicing Software Development Life Cycle (SDLC) and Agile development methodologies.

Participated in Joint Application Development (JAD) sessions, white board sessions to resolve issues and have coordination between the teams.

SKILL SETS

Databases

Oracle [10g/11g/12c] SQL Server [2008/2012], Teradata 13/14, IBM DB2, Sybase Power Designer

ETL Tools

Informatica Power Center, AbInitio, SSIS

Programming Languages

UML, SQL, PL/SQL, HTML, XML

Reporting Tools

Qlik View, Cognos 9/10/11, Tableau 8/9, Crystal Reports, SSRS 2008/2012

Data Modelling Tools

ERWIN r 7.x/8.x/9.x, MS Visio, ER Studio, Power Designer 12.x/15.x/16.x and Oracle Designer.

PROJECT DETAILS

Client: CVS Health, Woonsocket, RI

Role: Data Modeler/Analyst

Aug, 2016 - Till date

Responsibilities:

Analyzed business requirements, system requirements, data mapping specification requirements, and responsible for documenting functional and supplementary requirements.

Analyzed functional and non-functional data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.

Conducted data modeling JAD sessions and communicated data related standards.

Developed Conceptual, Logical and Physical data models for central model consolidation.

Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.

Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward Engineering.

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.

Created Source to Target mappings and Transformations.

Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.

Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.

Used ETL Informatica tool to populate the database, data transformation from the old database to the new database using SQL.

Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.

Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.

Skills Used: ERWin 9.x, ETL Informatica, Model Mart, MS Visio, MS Office XP, Teradata 12/13, SQL Server 2012, TOAD.

Client: Independence Blue Cross, Philadelphia, PA

Aug, 2015 – July, 2016

Role: Data Modeler/Analyst

Responsibilities:

Interacted with Business Analysts to gather the user requirements.

Translate business requirements into conceptual, logical data models and physical data models.

Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.

Worked with DBA's to create a best-fit physical data model from the logical data model.

Created Design Fact & Dimensions Tables using ERWIN tool.

Created a Normalized logical model for the business to understand the relationships and at the deeper level of granularity.

Exhaustively collected business and technical Metadata and maintained naming standards.

Forward Engineering the Physical Model to generate the DDL scripts to implement on Oracle 11g database.

Reverse engineering of the existing reports to identify the key data elements and data entities required to design the data warehouse.

Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.

Worked on slowly changing dimension tables and hierarchies in dimensions.

Good working knowledge in normalizing the tables up to 1NF, 2NF & 3NF.

Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.

Regularly conducted and participated in weekly status meetings.

Skills Used: Erwin 8.x, Teradata 10, Oracle11g, MS Excel, SQL Pus, Sybase Power Designer, MS Visio, Crystal Reports 2013.

Client: BJ’s Wholesale Club, Westborough, MA.

Oct, 2014 – May, 2015

Role: Data Modeler/Analyst

Responsibilities:

Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

Involved in developing data transformation and cleansing rules for migration using ETL tools.

Analyzed multiple source system to identify the data for migration.

Performed data mining on data using very complex SQL queries and discovered pattern.

Designed semantic layer data model. Conducted performance optimization for BI infrastructure.

Created DML code and statements for underlying & impacting databases.

Worked with ETL team whose ETL methodology for supporting data extraction, transformations and loading processing.

Worked at conceptual/logical/physical data model level using Erwin according to requirements.

Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.

Perform data reconciliation between integrated systems.

Involved with Data Extraction, Modification, Validation, Analysis, Management and Reporting.

Reporting tools, query tools, extraction and cleansing tools, transformation tools Using Metadata.

Extensively used MS Access to pull the data from various databases and integrate the data.

Involved in requirement gathering, analysis of the requirements from the business owners and users.

Interacted with users for verifying user requirements, managing change control process, updating existing documentation.

Analyzed business and end-user needs to ensure that project data requirements are identified and deliverables are met.

Used gap analysis to do the data mapping document which is most essential in determining the source table, source columns, destination table, destination columns, and gaps and define any business rule changes in order to fill up those gaps.

Skills Used: MS Visio, SQL Server 2008, Oracle 10g, Erwin 7.x/8.x, SQL Developer, Unix, IBM Infosphere Datastage 8x.

Client: Bank of America, Wilmington, DE

Apr, 2013 - Sep 2014

Role: Data Modeler/Analyst

Responsibilities:

Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.

Reverse Engineered existing Relational and Dimensional data base systems.

Applied Ralph Kimball data warehousing methodology in enhancing the existing data model.

Creation of Data Cubes for Analysis and report optimization.

Enhanced the warehouse model using ERwin tool.

Implemented Star Schema, snowflake methodologies in enhancing data warehouse.

Identified new facts, dimensions and reused existing conformed dimensions as per business requirements.

Enhanced existing facts and dimensions based on the business requirements.

Developed and maintained data dictionary to create meta data reports for technical and business purpose.

Identified and Defined Key Performance Indicators in SSAS.

Developed Data Mapping, Data Governance, Transformation and Cleansing rules for various processes

involving OLTP, ODS and OLAP.

Created/ Tuned PL/SQL Procedures, SQL queries for Data Validation and for various data profiling activities for current system.

Worked on the Snow-flaking the Dimensions to remove redundancy.

Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.

Worked on identifying facts, dimensions, grain of facts and various other concepts of dimensional modeling which are used for data warehousing projects.

Scheduled working sessions with ETL team to understand the need of work tables where needed.

Performed gap analysis where applicable to make sure there are no data anomalies.

Followed standards and best practices in indexing and partitioning where performance can be a concern.

Provided detailed data mapping documents for both OLTP and OLAP.

Supported ETL team in understanding the process and creating/enhancing the ETL maps.

Supported QA by providing assistance in writing the SQL prototypes as needed.

Skills Used: Win7, Erwin, UNIX, Oracle 7x, SQL Server 2005, Toad for data point, ETL Informatica.

Client: Lockton Companies Inc., Kansas City, MO.

May, 2011 – Mar, 2013

Role: 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.

Skills Used: Sybase, Erwin, Microsoft visual studio 2005, Microsoft Visio 2003, windows

server 2003.

Client: Synovus (Cigniti), Columbus, GA.

May, 2009 – Dec, 2010

Role: Data Modeler/Analyst

Responsibilities:

Analyzed Data sources and requirements and business rules to perform logical and physical Data Modeling.

Creating E-R Diagram, Function Hierarchy diagrams, Process diagrams and Data flow diagrams for designing database using Designer 2000.

Maintained data integrity of the database tables.

Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.

Identified and defined Entities, relationships and attributes in the data model as per new specifications on Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.

Development of forms, applications using a combination of database triggers, form triggers, and both local and stored procedures to maximize code efficiency and readability.

Prepared Test Scenarios based on understanding of business process flow.

Created conceptual, logical and physical data models using best practices and company standards to ensure high data quality and reduced redundancy.

Implemented the standard naming conventions.

Developed stored procedures to implement business logic.

Created database objects like Tables, Stored Procedures, Indexes, Sequences, Views, and Rules etc.

Skills Used: MS Visio, ER/Studio, Oracle, Erwin 5.x, Crystal Reports, SQL server 2003, Unix,

Shell Scripting, SQL Plus.

Contact this candidate