PROFESSIONALSUMMARY

• A self-motivated Data Modeler/ DB Architect/SQL Server-Oracle Application DBAwith 8.5 years of IT Information Technology experience, an amicable team player with excellent communication skills prepared to use my technical abilities and problem solving skills to achieve the goals and commitments of the organization.
• Excellent work exposure in the fields of Database Solutions, MDM Solutions using IBM Initiate Tool for Enterprise having multiple data sources that includes Very large Database Architecture, Data Modeling, Performance tuning and Maintenance
• Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Worked extensively in forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Published Data model to acrobat PDF files, extensively created ER Studio reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-ordinate with DBAs to apply the data model changes
• Good Knowledge of the projects under the HealthCare Insurance and BFSI domains.
• Good understanding of State Health Exchanges that goes with the Affordable Care Act ACA
• Experienced in developing conceptual, logical and physical data models for OLTP and OLAP systems with the companies standard naming conventions using the Erwin Data Modeling tool.
• Good understandingof Star and Snow Flake Schemas for Data warehouse Modeling.
• ODS Operational Data Store Modeling and Operational Reporting
• Good understanding of Normal forms, 3NF Normalization and De-Normalization concepts
• Metadata Management and Data Dictionary Maintenance
• Excellent knowledge of Software Development Life Cycle SDLC , Adhered to standards/guidelines throughout the development life cycle and maintenance of the models.That includesAGILE Scrum and Waterfall methodologies.
• Architected an enterprise solution that provides Data Isolation capabilities around co-located data. This ensures that data is provided based on appropriate security context.
• Strong experience in ER Diagrams, Conceptual, Logical and PhysicalData modeling using EA Sparx Tool, Microsoft Visio, CA ErwinData Modelerthat involved requirement analysis with business team and translating them into Technical Specs
• Good experience in data analysis, data analysis,data profiling, data transformation, data mapping from source to target database schemas and also data cleansing, data quality.
• Very strong hold on Database designing and MS SQL Server Programming involving Database/Table creation, Triggers, Transact-SQL T-SQL , PL-SQL, Stored Procedures, Views, Security and Indexes. Performance tuning and Query Optimization using DBTA, SQL Profilers, Management Studio, Execution Plans etc.
• Was involved in detailed documentation of Release notes, Technical specification Document TSD and system design documents SAD .
• Database Administration and non-functional activities like backup and Restoration as well as Transaction log Backups, running Integrity checks, Reorg, Audit, Archival etc.,
• Primary Database of work includes working on Oracle 11g, Microsoft SQL Server 2008 R1, Microsoft SQL Server 2005, Microsoft SQL Server 2000 and Microsoft SQL Server 7.
• Have a good understanding of code builds and versioning using VSS, TFS, moving the code base across environments.
• Basic working understating of Oracle 11g from a querying perspective and DDL deployment to the same
• As a Technical Architect, worked extensively with Client's architecture team to design and architect ahighly demanding Database Environment for a Health Insurance client.
• Estimating work using Functional Point Analysis
• Worked on Database requirements for Operational Reporting, providing Data Quality Reports.
• Have extensive experience, coordinating with testing teams for Integration Testing, User Acceptance Testing UAT and also with Production Support Teams on critical and urgent Production Issues.
• Excellent verbal, presentation and written communication skills. Able to communicate with technical, non-technical and senior management audiences. Have played a significant role in requirements planning, client interaction and documenting.
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Data and Database Architecture

Responsibilities:

• Data Architecture, Conceptual, logical and physical Modeling for OLTP and OLAP systems.
• ER Modeling - Developing Entity Relationship Diagrams ERD .
• Developed, Implemented Maintained the Conceptual, Logical Physical Data modelsin accordance to the 3NF Model.
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts dimensions grain of fact, aggregate tables for Dimensional Models.
• Metadata Management Data Dictionary Management Data Profiling Data Mapping.
• Interacted with Business Analysts and Solution Architects to understand the system and its various needs by going through the JAD Joint Application Development packages
• Identified gaps between the current health connector system and the second generation health exchangefrom a data model perspective
• Oracle implementation of the OLTP Database on Oracle 11g
• Performance Tuning Database Tuning, Teradata SQL Tuning, Application/ETL Tuning
• Coordinating with DBA team to implement physical models to setup development, test, staging production environments for DDL DML Generation usage.
• Data warehouse modeling for the HIX System
• Data Modeling,Data Profiling, Data Transformation, Data Mapping from source to target database schemas and also Data Cleansing, Data Quality
• Creating Data Warehouse model that involves Start and Snow Flake Schemas
• DefiningData Governance for the system andData Stewardship rules
• DevelopCanonical Data Modeling and XML Modeling
• Normalization of the data model
• Develop a Data Dictionary and a meta data repository
• Versioning and maintenance of the data model and other data artifacts
• Educate DBA's and Developer's on the Data Model and work with them to identify technology related requirement and update and publish the new data model version accordingly
• Data conversion and migration from the first generation to the second generation systems.
• Was awarded the employee of the month with a superhero award for the month of Aug 2013

Environment: Oracle 11g, SQL Server 2008 R1, Windows Server 2003, Windows XP, TFS, DBTA, Erwin, Initiate IBM Tool for Person MDM, ISQLW, SQL Management Studio, DBTA, MS Visio 2010s

Confidential

Data and Database Architecture / Data Modeling/ Performance Tuning

Responsibilities:

• Interacted with Business Users to gather requirements and pain points with the current System
• Re-Architected the RAMS Database for betterperformanceand also from a model point ofview to accommodate operational reporting and transactional processing simultaneously
• Data Architecture, Conceptual, logical and physical Modelingin accordance to 3NFfor OLTP
• Metadata Management Data Dictionary Management Data Profiling Data Mapping
• Data Modeling,Data Profiling, Data Transformation, Data Mapping from source to target database schemas and also Data Cleansing, Data Quality
• Data Governance and Stewardship rules
• Canonical Data Modeling
• Performance Tuning of the database
• Designed and developed Data Quality Reports, Chain of Trust Mechanisms for File processing.
• Built the system for non-functional activities like backup, restore, recovery, auditing and archival processes for the OCH DB

Environment: SQL Server 2005, SQL Server 2008 R1, Windows Server 2003, Windows XP

Tools: SQL Profiler, VSS, TFS, DBTA, Erwin, Initiate IBM Tool for Person MDM, ISQLW, SQL Management Studio, DBTA, MS Visio 2010

Confidential

Responsibilities:

• Architected an enterprise solution and led a technical team of 6 to build the Person Master Data Management process and solution for Humana's insurance business.
• Person/Customer MDM Solutions
• Custom and Automated Maintenance Plans Optimization, Integrity Checks etc., for Very Large Databases. The first to be done in Humana.
• Architected an enterprise solution that provides data isolation capabilities around co-located data. This ensures that data is provided based on appropriate security context.
• Data Architecture, Conceptual, logical and physical Modeling for OLTP
• Metadata Data Dictionary Management Data Profiling Data Mapping.
• Performance Tuning of the SDR/OCH DB's
• To build new servers with an enhanced architecture solution to accommodate ETL, OLTP, Reporting requirements for SDR
• Has been working on Application Design for Data Isolation, Preferences.
• Designed and developed Data Quality Reports, Chain of Trust Mechanisms for File processing.
• Built the system for non-functional activities like backup, restore, recovery, auditing and archival processes for the OCH DB.
• Architected and Worked with a team of 8 people to build the Humana Enterprise Database, the SDR
• Data Modeling of SDR DB.
• Person/Customer MDM Solutions
• Handled all the non-functional activities of SDR DB that includes Backup, Restore, Recovery, Audit and Archival.
• Was responsible for Designing and Implementing a part of the Application that includes Person Data, Policy Data, Preferences Data of the Enterprise
• Was also involved in Production Support responsibilities until the New Support team took over.
• Architected Reporting solution that helps extracting data to downstream systems
• Performance tuning of the SDR DB.
• Enhancements to the Enterprise DB as new customers started consuming the solution

Environment: SQL Server 2005, SQL Server 2008 R1, Windows Server 2003, Windows XP

Tools: SQL Profiler, VSS, TFS, Erwin, Enterprise Architect Sparx 7.5, DBTA, Initiate IBM Tool for Person MDM, SQL Management Studio, DBTA, SSIS, Informatica

Confidential

Database Administrator/SQL Server Database Architecture

Responsibilities

• Study existing system
• Maintenance and Production Support for the existing SQL Server Database. This involves database backups and trouble shooting of the existing database and corresponding testing and release of new version, archival, job settings etc.,
• Data Modeling with respect to new and modified business requirements
• Performance and Process improvement in existing business process of the System
• Interacting with client to gather requirement
• Handled all the non-functional activities of SDR DB that includes Backup, Restore, Recovery, Audit and Archival.
• Data Modeling of new requirements

Environment: SQL Server 2005, Windows Server 2003, Windows XP, SQL Profiler, DBTA, VSS, Microsoft Visio

Confidential

DBA/Designer/Module Leader

Responsibilities:

• Design for new enhancements and logical and physical data modeling
• Database backups and restoration, trouble shooting and corresponding testing and release of new version, archival, job settings etc.,
• Resolve FTR Field Trouble Request , analyze and honor NFR New Requirement and CR Change Request .
• Support for Production Help desk and client acceptance testing.
• Performance tuning of the existing database.
• Change management system administration.
• Was module leader of DPM module
• Study existing system
• Process improvement in existing business process of the System
• Person MDM Solution
• Reviewed the Requirement document, Design document and Test-case document
• Provided Handover / training to the maintenance team.

Environment: SQL Server 2000, SQL Server 2005, Windows Server 2003, SQL Profiler, ODBC, VSS