PROFESSIONAL SUMMARY:

• Result-oriented IT professional experience with a 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 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.
• A dedicated team player with excellent communication, organizational and interpersonal skills.

TECHNICAL SKILLS:

• DBMS: Oracle 11/12, AWS, Hadoop Hive, HDFS, VERTICA, 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, Power BI, Cognos
• Programming: PL/SQL, JAVA, C/C++, VB 6.0, Python, C++, Scala, Python
• Scripting languages: Java script, PHP
• Web technologies: HTML, XML
• Project Management: Jira, Trello

WORK EXPERIENCE:

Confidential

Data Modeler/Architect

Responsibilities:

• Responsible to design, develop and enhance Plan Member, Claims, Patient, Practitioner, Point of Care Locations, Organization, Contact Points, Encounters, ICD Codes, Diagnosis, Procedures, CPTs, HCPCS, DRGs, Allergies, Insurances, Patient Financial Transaction processes to load data into EDW atomic tables. Performed various data quality checks and data integration including ETL architecture design.
• Responsible for Architecture and Design for EDW project, which using IBM UDMH (Unified Data Model for Healthcare) for Enterprise Atomic Data Warehouse (EDW) to meet Regulatory Demands and enterprise operational and reporting needs.
• Responsible to design, develop and enhance EDW data integration processes for source systems Facets, HRP, Lab Vendors, PBM (Pharmacy benefit manager), MDM, MEDISPAN, FDB, EPIC, Press Ganey, HL7 and EDI Data from payers
• Responsible to facilitate architectural needs for PQRS (Physician Quality Reporting System) & HEDIS reporting needs.
• Worked on populating IGC (Information Governance Catalog) with using EIM member data model. Worked with Business to define the terms and integrate them with the Data Model
• Designed MDM data model for Plan Member & Patient with Merge and Unmerge capabilities of Master Data
• Designed customized solutions to maintain history from legacy systems & Type 1 data sources for regulatory purposes
• Designed solutions for Multi-tenant architecture to ensure different layers of security for our tenant as well as other Tenant data. Solutions provided privacy of data from one tenant to another as well as different layers of access of tenant consumers of data from all PHI (Personal Private information) to Partial PHI to meet HIPPA Regulations.
• Enhanced reporting layer to meet security requirements of sensitive codes of ICD Codes, Diagnosis, Procedures, CPTs. Sensitive codes included codes relating to Substance abuse, STDS and so forth
• Utilized Oracle GoldenGate and Oracle Data guard to perform CDC for different source of data.
• Worked with Reporting team to generate XML framework for Cognos form IBM Data Architect
• Maintained SVN for Data models and Mapping documents

Environment: IBM InfoSphere DataStage, Netezza Appliance Server, Aginity Workbench, MS-SQL Server, Oracle, Oracle Sql Seveloper, Data guard, Oracle GoldenGate, PL/SQL , Flat files, UNIX, HL7, Shell Scripts, IBM UDMH Tortoise SVN Subversion, Axon/EDC, Cognos, Jira

Confidential, Columbus, OH

Data Modeler/ Architect

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, Power BI

Environment: IBM Infosphere Data Architect, Hive, HDFS, Vertica 8, Oracle 11g, Oracle Sql Developer, Python, AWS, Big Integrate, Toad, SQL Server, GIT HUB, Informatica Data Quality, Python

Confidential, Chicago, IL

Senior Data 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.
• Reversed engineered code & models for business rules.
• Created MDM infrastructure.
• Designed Star Schema Data Models for Enterprise Data Warehouse using InfoSphere IDA.
• 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.
• Created source to target mapping for ETL CDC using InfoSphere Fast Track tool
• Created the ETL architecture, data modeling, data mapping, data definitions, view definitions, master data management, MDM, and data profiling for analytical Automated Condition Monitoring for claims and work orders metrics and KPIs for an Oracle database and SSPS user interface.
• Utilized Electronic data capture (EDC) systems to extract Lab orders, HL7 files and other Payer EDI
• Evaluated MDM, PL/SQL code and performed code reviews.
• Enterprise Data Warehouse support/design expertise in change management, change data capture, master data management (MDM), data conversion, data federation, data integration, data mart design, metadata creation, processes and best practices.
• 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, Axon/EDC, Python, HL7

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, Vertica 7, AWS, Informatica, Toad, CVS, Python

Confidential, Gaithersburg, MD

Data 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 (CDC) data into data warehouses from various sources like relational databases, application systems, temp tables, flat files, EDI sources
• Developed stored 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, Scala, Python