SUMMARY:

• Result - oriented IT professional experience with strong background in Database development and designing data models for online transactional processing (OLTP) and online Analytical Processing (OLAP) systems for Health Care, Financial, Insurance & Telecom domains.
• Strong background in various Data Modeling tools using ERWIN, IBM Data Architect, Power Designer, MS Visio.
• Expert knowledge in SDLC (Software Development Life Cycle) and good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical data model/Physical data models Designs, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources and creating interface documents.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like Erwin.
• Participated in JAD sessions, created Use Cases, work flows and Power Point presentations.
• Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design.
• Gathered and documented Functional and Technical Design documents.
• Have experience in extensive data profiling & Analysis.
• Worked extensively on Data Governance. Implemented metadata management to achieve regulatory compliance and quality in business intelligence.
• Have worked with ETL tools to extract, transform and load data from relational databases and various file formats and loaded to target database.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Experience in SQL Performance Tuning and Optimization (Design, Memory, Application, IO) and using Explain plan, Tracing and TKPROF.
• Experience in creating Materialized views, Views, Lookups for the Oracle warehouse.
• Experience with Erwin model manager.
• Experience working with Master Data Management
• A dedicated team player with excellent communication, organizational and interpersonal skills.

TECHNICAL SKILLS:

DBMS: Oracle 11/12, Hadoop Big Data, Hive, MS SQL SERVER 2016/2017, Sybase, Teradata, Netezza

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data extraction, Integration, transformation and Migration, ETL Architecture and Design Data Warehouse, OLTP, OLAP, Report Design and Development.

Data Analysis: User Requirement Gathering, JAD Sessions, Gap Analysis, Data Cleansing, Data Transformations, Data Profiling, Source Systems Analysis, Data Relationships

Data Modeling: Erwin, Info sphere Data Architect (IDA), MS Visio, Toad, Power Designer, ER Studio

ETL Tools: BO DS 3.X, BO DI XI R2/6.5, Informatica, Data Stage

Reporting Tools: Tableau

Programming: PL/SQL, T-SQL, JAVA, C/C++, VB 6.0

Scripting languages: Java script, PHP

Web technologies: HTML, XMLMicrosoft Office Word, MS Excel, Access

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Data Modeler/Analyst

• Responsible for delivering and coordinating data-profiling, data-analysis, data-governance, data-models (conceptual, logical, physical), data-mapping, data-lineage and reference data management.
• Participated in meetings & JAD sessions to gather and collect requirements from the business end users as well as reporting requirements. Worked with Business Analysts, SQL Developers, end users and stakeholders to understand the requirements and signoff on the various deliverables
• Create team strategies and establish project scopes of work; communicate project deliverable time frames and benchmarks to project sponsors.
• Created process flows and data flow diagrams of the current and future systems.
• Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize database development.
• Performed Data profiling and exploration using Informatica IDQ
• Performed gap analysis for different data sources
• Created Source to Target mapping to include transformations and data quality rules needed for EDW Integration
• Created Data Marts to support enterprise reporting.
• Maintained metadata, version controlling of the data model.
• Utilized hybrid data model architecture to deliver project goals with limited budget.
• Developed Data Exploration zone stores to manage raw data for exploratory analytics
• Created Materialized views & Summary tables for Reporting
• Integrated physical data model with business glossary.
• Implemented data lineage of Metadata workbench tool

Environment: IBM Info sphere Data Architect (IDA), Hive, HDFS, Netezza, Teradata, Oracle 11g, Big Integrate, Toad, SQL Server

Confidential, Columbus, OH

Data Modeler/Analyst

Responsibilities:

• Attended and participates in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for Staging, Operational Data Store and Data marts applications.
• Performed gap analysis and dependency analysis for current & future systems.
• Designed Star Schema Data Models for Enterprise Data Warehouse using InfoSphere IDA.
• Created Mapping documents for ETL using InfoSphere Fast Track tool
• Created and maintained Logical & Physical Data Models for the project. Included documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Implemented metadata management as one part of data governance. Worked with the business users to populate business glossary.
• Imported model to business glossary and performed integration of the technical and business terms.
• Implemented data lineage of Metadata workbench tool
• Worked with Cognos reporting team to export xml framework manager model from IDA
• Validated and updated the appropriate Models to process mappings, screen designs, use cases, business object model, and system object model as they evolved and changed.
• Regular work reviews & supporting test units
• Created Model reports including Data Dictionary, Business reports.
• Generated SQL scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.
• Netezzza Performance tuning: grooming, distribution keys etc.

Environment: IBM Infosphere Data Architect, DB2, Teradata, Oracle 11g, IBM Data Stage, Toad, SQL Server

Confidential, Philadelphia, PA

Sr. Data Analyst

Responsibilities:

• Conducted JAD sessions, gathered information from Business Analysts, SQL Developers, end users and stakeholders to determine the requirements or various systems.
• Created and documented the models, data Workflow Diagrams, Sequence Diagrams, Activity Diagrams and field mappings of all existing system.
• Proficient in using ERwin Reverse engineering, Forward engineering and Complete Compare functions to create, updated and resolve issues with existing data models.
• Created and implemented ERwin Naming Standards and Domain in the design of creation of logical and physical data models in accordance with the company’s standards.
• Worked with other Data Modeler, DBAs and Developers in my projects using Microsoft Team Foundation Server to ensure that every accept of the project is effectively considered and completed and on a timely manner.
• Prepared and presented graphical representation forms of Entity Relationship Diagrams with elicit more information.
• Created and maintained, conceptual, logical and physical data models that defines the information required for management and business intelligence purposes using Erwin Data Modeler.
• Worked with the DBAs and SQL Developers to deploy and maintain the developed physical data models.
• Used Erwin data modeler to design and implement the company’s health care domains
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from the source and SQL Server database systems.

Environment: ER Studio Data Architect, MS SQL Server 2012, 2014, ServiceNow, Sales Force, MS Visio, Microsoft Visual Studio 2012, 2013, Microsoft Team Foundation Server

Confidential, Bridgewater, NJ

Data Modeler/Analyst

Responsibilities:

• Attended and participates in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for Staging, Operational Data Store and Data marts applications.
• Performed gap analysis and dependency analysis for current & future systems.
• Designed Star Schema Data Models for Enterprise Data Warehouse using Power Designer.
• Created Mapping documents for Staging, ODS & Data Mart Layers.
• Created and maintained Logical & Physical Data Models for the project. Included 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 Models to process mappings, screen designs, use cases, business object model, and system object model as they evolved and changed.
• Created Model reports including Data Dictionary, Business reports.
• Generated sql scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.

Environment: Power Designer 11, Oracle 11g, Informatica, Toad

Fiserv Bridgewater, NJ

Data Analyst

Responsibilities:

• Reviewed functional requirements and use cases to determine the necessary data requirements.
• Participated in creating realistic project plans with detailed tasks and ensuring their timely execution.
• Reversed engineered current system data model and subdivided it into work streams for analysis and generated data source to target mapping documents.
• Created process flows and data flow diagrams of the current and future systems.
• Performed dependency and gap analysis for data structure changes on other downstream applications and impact of new data elements on existing downstream processes.
• Designed and produced logical and physical data models for the financial platform and other in-house applications running on Oracle databases.
• Developed ETL procedures for moving data from source to target systems.
• Worked closely with both functional and technical team on the creation of data models which can seamlessly integrate with existing data structures on multiple Oracle databases integrated by database links.
• Generated Surrogate Key for the dimensions in the fact table for indexed and faster access of data.
• Maintain database standards documents example Naming standards document, Data dictionary to ensure consistency.

Environment: ERWIN 4, 7, MS Visio, Toad, Oracle 10g, PL/SQL, SQL*Plus, Toad, Data Stage