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 & Retail domains.
• Strong background in various Data Modeling tools using ERWIN, IBM Data Architect, Power Designer,MS Visio.
• Expert knowledge inSDLC(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 inRelationalData 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, usingindustry leadingData Modeling tools likeERWin.
• 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 inSQLand codingPL/SQLPackages, 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 withErwin model manager.
• A dedicated team player with excellent communication, organizational and interpersonal skills.

TECHNICAL SKILLS

DBMS: Oracle 11/12, Hadoop, Hive, MS SQL SERVER 2005/2008, Sybase, Teradata

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, Source Systems Analysis, Data Relationships.

Data Modeling: Erwin 7.x/4.x, MS Visio, Toad, Power Designer

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

Reporting Tools: Tableau

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

Scripting languages: Java script, PHP

Web technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Data Architect/Modeler

Responsibilities:

• 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
• Set up multi-user environment through distributed versioning control system, GIT HUB
• Integrated Data modeling tool, IDA with business glossary
• 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
• Integrated physical data model with business glossary.
• Implemented data lineage of Metadata workbench tool
• Developed data marts to feed Actuary statistical models
• Experience using IBM BigInsights hadoop distribution framework -BigIntegrate, Big SQL, HDFS, Hive, Sqoop,Spark

Environment: IBM Infosphere Data Architect, Hive, HDFS, Netezza, Oracle 11g, Big Integrate, Toad, SQL Server, GIT HUB

Confidential, Chicago, IL

Data Architect/Modeler

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.
• Customized IBM UDMH Model to satisfy multiple use cases.
• 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 e.t.c

Environment: IBM Infosphere Data Architect, DB2, Netezza, Oracle 11g, Informatica, Toad, SQL Server, GIT HUB

Confidential, Bridgewater, NJ

Sr. Data Analyst/Modeler

Responsibilities:

• Attended and participates in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for OLTP & OLAP systems.
• Performed gap analysis and dependency analysis for current & future systems.
• Worked with Informatica Data quality tool to do data profiling.
• 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.
• Performance tuning

Environment: Sap Power Designer 14, Oracle 11g, Informatica, Toad, CVS

Confidential, Gaithersburg, MD

Data Architect/ Modeler

Responsibilities:

• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements
• Translated business requirements into working logical and physical data models for OLTP and OLAP applications.
• 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
• Experience in MPP architectures.
• Designed the database tables & created table and column level constraints using the suggested naming conventions for constraint keys.
• Used ETL tool SAP DS to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developedstored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• Reviewed the database programming for triggers, exceptions, functions, packages, procedures.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Erwin 4, 7, MS Visio, Teradata, SAP Data Services, Toad

Confidential, ST. CLOUD, MN

Data Analyst/ ETL Developer

Responsibilities:

• Reviewed functional requirements and use cases to determine the relevant data requirements.
• Assisted 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.
• 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.
• Created and maintained FSDM logical and physical data models for the financial platform and other in-house applications running on Oracle databases.
• Designed data movement strategies for data collection as well as the population of existing, new data stores and replicated environments.
• Worked closely with the Enterprise Data Architecture team, Database Services team and the project team on the creation of data models which can seamlessly integrate with existing data structures on multiple Oracle databases integrated by database links.
• Database design improvement documents.
• Database standards documents: Naming standards document, Data dictionary

Environment: Erwin, MS Visio, Toad, Oracle 11, PL/SQL, SQL*Plus, Toad, Data Stage

Confidential, HERDON, VA

Data Modeler/ ETL Developer

Responsibilities:

• FacilitatedJAD sessionsto determinedatarulesandconductedLogical Data Modeling (LDM)andPhysical Data Modeling (PDM)reviews withDataSMEs.
• Participatedin data analysis and data dictionaryandmetadata management - Collaborating with business analysts, SMEs, ETL developers, data quality analysts and database administrators.
• Participated in design of Data Asset Management(DAM), Marketing, Customer Contact Channel, Order provisioning business processes, target applications architecture and target data model.
• Developedrelational model design, dimensional modeling, and ETL processes inDatawarehouse(DWH)andDecision support system(DSS) environment.
• Validated and maintained the enterprise-wide logicaldatamodel forDataStaging Area, DWH and DSS.
• Developed the logicaldatamodel (LDM) & PDM andassisted theDBA to create thephysicaldatabasebyproviding the DDLscriptsincluding Indexes, Data Quality checks scripts and Base View scripts.
• Aided and verified DDL implementation by DBAs, corresponded andcommunicated data and system specifications to DBA, development teams, managers and users.
• Ensureddelivery of LDM, PDM, Staging PDM and data lineage mapping documents.
• Managedthe data model changes in all enterprise applications. Performedimpact analysis to ensure all systems leads are informed and coordinate efforts to implement changes.
• Developed, integrated, managed and promotedenterprise level logical and physicaldatamodelsanddatamodel standards thatsourcedatafrom multiple origins(internaldatasources, externaldatasources, third partydata.
• Developeddetailed mapping documentsthat will provide the reporting anddatawarehouse team with source to targetdatamappingincludeslogical names, physical names,datatypes, corporate meta-data definitions, and translation rules.
• Conducted qualities control/auditing to ensure accurate and appropriate use ofdata.
• Performeddataanalysisonproductiondataissues.
• Used BO DS to extract data from relational databases, various file formats. Cleansed and transformed the data before loading it to target database.
• Createddatabase triggers,functions,procedures,cursorsandpackages.
• DevelopedPL/SQL scriptsto validate and load data into interface tables.
• Extensively usedStored Proceduresfor handling the database operations.

Environment: ERWIN 7, MS SQL Server, SAP Business ObjectsData Services3.X, PL/SQL, SQL*Plus, Toad, HTML, XML.

Confidential, HERDON, VA

Data Modeler/Analyst

Responsibilities:

• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• 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.
• Used ETL tool BO DS to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developedstored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• Reviewed the database programming for triggers, exceptions, functions, packages, procedures.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Erwin 4, MS Visio, Oracle 10g, SQL Server 2000, Business ObjectData IntegratorR2

Confidential, WASHINGTON, DC

Data Analyst/Data Modeler

Responsibilities:

• Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions to gathering the new requirements.
• Involved in all phases ofSDLCfrom requirement, design, development, testing and rollout to the field user and support for production environment.
• Translated business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• Developed Business and Subject Area LogicalDataModels,Physical Data Models, Physical Staging area Data Models andDataFlow Diagrams.
• Extensively used ERWIN to design Logical/Physical Data Models,forward/reverse engineering, publishing data model, applying DDLs to database, Data Modeling and restructuring the existing data Model.
• Applied Discover FinancialDataNaming Standards,created new naming standards,checked models in and out ofERWINModel Repository, and documenteddatamodel translation decisions.
• Generated database objectssuch asTable, Views, Synonyms, Database Linkby executing the script generated from ERWINwith appropriate privileges
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model.
• Used various levels oftriggers and proceduresto validate the data at each level.
• Extensively involved in writingPL/SQL stored procedures, functions and packages.
• Createddatabase tableswithcomplex constraintsapplicable to the business rules.
• Involved in Optimizing SQL queries involving large tables.
• Created Indexes and Materialized Views to improve the overall system performance.
• Tested the application to ensure proper functionality, data accuracy, and modifications had no adverse impact on integrated system environment.
• Involved in the maintenance and support of existing applicationswith the users.
• Involved in training and production support at various client locations

Environment: ERWin 7.2, Microsoft Office Suite, Microsoft Visio, Unix, Documentum, ETL, MS Word, MS Access, MS Excel, MS Visio, Windows NT/XP, SAS, Oracle, SQL, SQL Server, Sybase, VBScript, C#. DOORS, C++, Business Objects, TestDirector, LoadRunner