Harsha D

Email: ac2ifw@r.postjobfree.com

Phone: 469-***-****

Summary

Senior Data Modeler / Analyst with 8+ Years of IT professional experience in Data Modeling, designing, developing, and implementing data models for enterprise-level applications and systems. These models are architected at the following layers: conceptual, logical, business area, and application.

Experience in analysis, design, and development of enterprise data warehouse models for business intelligence / reporting.

Deep Understanding in development of Conceptual, Logical and Physical Models for Online Transaction Processing and Online Analytical Processing (OLTP&OLAP).

Experience in Data Warehouse modeling for large/complex business intelligence process including development of dimensional modeling.

Implemented metadata standards, data governance ( data cleaning, data profiling and data analysis)

Followed different concepts in data modeling like Kimball and Inmon methodologies in designing the data models

Strong background in developing high performance queries, view, procedures, Informatica ETL, etc.

Extensive experience in working with tools like Erwin, Oracle Designer, Power Designer and MS Visio for creating data models.

Extensive experience in reverse engineering databases, Complete compare using ERwin.

Experience with various methodologies for creation of data models for data warehouses and data marts.

Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies).

Worked closely with ETL teams such as Informatica to extract data from Source system to target systems and created mappings, Data Reports.

Extensive experience in working closely with End-Users, Business Users, Clients for gathering User and Business Requirements and authoring business processes with project teams.

Designed and developed Data models for Database (OLTP), the operational data store (ODS), Data warehouse (OLAP), and federated databases to support client enterprise Information Management Strategy.

Experienced in master data management (MDM), Metadata management, data quality.

Strong Knowledge in Data Transformation and Data Mapping from source to target database Schema’s and also data cleansing.

Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system.

The data was standardized to store various Business Units in tables.

Expertise in creating Schema objects like Indexes, Views, and Sequences.

Designed Data flow Diagrams, and Activity Diagrams, to support the development team and business groups.

Extensive experience in Database Creation and maintenance of physical data models with Oracle and SQL Server data bases.

Extensive experience in Performance tuning databases for optimum performance.

Coordinated and prioritized outstanding defects and system requests based on business requirements.

Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.

Capable of managing project while leading cross-functional teams to meet and exceed overall IT initiatives.

Self-motivated diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

Data Modeling Tools:

Erwin r7.1/7.2, Erwin R8.2.5, R9.5

Project Design & Architecture:

MS Visio 2000/2007/2010

Business Intelligent Tools:

OBIEE, SAS, COGNOS, QLIKE View

OLAP Tools:

Microsoft Analysis Services, and Crystal Reports 9

ETL Tools:

Microsoft DTS/SSIS, SSRS and Informatica 7.1.3

Programming Languages:

SQL, T-SQL, HTML, CSS, XML, ASP.NET, C++. C #

Debugging/Defect tracking Tool:

Bugzilla, Rational Clear Quest, JIRA

Testing Tool:

Quick Test Professional (QTP), Quality Center (QC), Load Runner & WinRunner

RDBMS:

Oracle, MS-Access, SQL Server

Other Tools:

VM ware, Toad, Putty

PROFESSIONAL EXPERIENCE

BlueCross BlueShield Association BCBSA, IL Feb 2017 – Present

Senior Data Analyst

Technologies: Oracle 11g, DB2, Unica Campaign, Python

The Blue Cross Blue Shield Association (BCBSA) is the trade association for the independent, locally operated Blue Cross and Blue Shield member companies. The Blue Cross and Blue Shield Service Benefit Plan, also known as the Federal Employee Program (FEP) covers roughly 5.3 million federal employees, retirees and their families out of the nearly 8 million people who receive their benefits through the Federal government.

CCTI: Care Coordination is a process of planning, arranging and coordinating of care of members to bring together health care resources from across the continuum of care to enhance member’s health and optimize health care. Care Coordination Technical Infrastructure CCTI environment including the Integrated data source IDS, the Federal Employee Program Data Warehouse FEPDW, the interactive Database repository IDBR, and the CCTI Analytics environment CAE support care coordination portal application as well as other business units within BCBSA such as business informatics, Actuarial, Special investigations unit and Market research.

CCTI Production Support: Support CCTI member, claims, inpatient stays, readmission and diagnosis related group DRG, Medical episode groupers MEGS, Diagnostic cost control group DCG, HEDIS, Care management/ Disease management extracts, ETL daily weekly and monthly schedules, ICD 10 and ICD 9 codes.

Data Analyst Responsibilities:

Support and maintain the Federal Employee Program - Care Coordination Technology Infrastructure.

Involvement in SDLC which includes gathering of business requirements, architecture, design document, planning, development, deployment and maintenance of Care Coordination Technology Infrastructure.

Gathering and analysing the business and technical requirements. Create Functional Specification Document

Attend program design, coding and test walk-through meetings to provide input regarding adherence to technical standards and customer requirements.

Conducting Functional Requirement Specification Artefacts meetings with the Project Teams and analysing the risks involved.

Responsible for data mapping, metadata maintenance and enhancing existing Logical and Physical data models.

Conducted sessions with architects, business SME and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.

Determined data rules and conducted Logical and Physical design reviews with business analysts, development team and DBAs.

Maintained and updated Metadata repository based on the change requests

Analysed existing Logical and Physical data models and altered them using Erwin to support enhancements.

Conducted walkthroughs with the DBA to convey the changes made to the data models.

Implemented SQL Scripts to modify the data to resolve assigned defects.

Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.

Developed source to target mapping documents to support ETL design.

Created tables, views, sequences, indexes, constraints and generated sql scripts for physical implementation.

Reverse Engineered databases schema into ERwin Physical Data Model for reusability and then forward engineered them to Teradata using Erwin.

Resolved the data inconsistencies between the source systems and the target system using the Mapping Documents.

Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Testing Responsibilities:

Reviewed user test cases, defects and validated test results during user acceptance testing (UAT).

Prepared/Reviewed weekly testing status and reports. Presented program-level testing information at meetings as requested.

Client: Aetna Insurance, CT Nov 2015- Jan 2017

Role: Senior Data Modeler / Analyst

Description: Aetna Insurance is an American Managed health care company, which sells traditional and consumer directed health care insurance plans and related services, such as medical, pharmaceutical, dental, behavioral health, long-term care, and disability plans. Development of Database on oracle based on data from multiple sources like DB2, Sybase and legacy system.

Responsibilities:

Responsible for data mapping, metadata maintenance and enhancing existing Conceptual and Physical data models.

Conducted sessions with architects, business and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.

Maintained and updated Metadata repository based on the change requests

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

Conducted walkthroughs with the DBA to convey the changes made to the data models.

Utilized Rational Clear Quest to track change requests throughout the process.

Implemented SQL Scripts to modify the data to resolve assigned defects.

Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.

Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, Analysis and Design.

Created Entity relationships diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.

Developed the data warehouse model (star schema) for the proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfill requirement.

Worked on data cleansing techniques to make sure no duplicates are present in the data.

Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.

Developed source to target mapping documents to support ETL design.

Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated SQL scripts for physical implementation.

Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.

Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.

Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.

Responsible for data validation and writing validation scripts once the data is loaded from source to target.

Developed data mapping documents between Legacy, Production, and User Interface Systems.

Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.

Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Environment: ERWIN r8.0, Data Modeler, Informatica Power Centre 9.5/9.1, Oracle Designer, SQL Developer, Oracle 11g, ER Studio, HP ALM, Flat files, Toad, Business Objects, OBIEE.

Client: RSA Insurance Group, Pune, India Aug 2014 - Aug 2015

Role: Data Modeler / Analyst

Description: RSA Insurance group provider of Health Insurance like critical illness, dental illness, disability; Long term care and Medicare supplement insurances. Analysed the requirements of the project and was involved in Designing the proposed Data warehouse and Data mart. System built had a greater control, user functionality, Robustness, scalability and security.

Responsibilities:

Conducting the meetings with business users to gather data warehouse requirements.

Conducted team meetings and Joint Application Design (JAD) session.

Gathered requirements and created use case diagrams as part of requirements analysis.

Created data governance and privacy policies specifying contract implementation

Developed a Conceptual model using Erwin based on requirements analysis.

Developed normalized Logical and Physical database models to design OLTP system for education finance applications.

Created dimensional model for the reporting system by identifying required dimensions and facts using ERwin r8.0.

Modeled a database to store customer demographic and other data, produced functional decomposition diagrams and defined logical data model.

Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.

Perform data profiling in Production environment to analyze and collect the statistical information.

Implemented Referential Integrity using primary key and foreign key relationships.

Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.

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

Performed data profiling in Production environment to analyze and collect the statistical information.

Translated business concepts into XML vocabularies by designing XML Schemas with UML.

Exhaustively collected business and technical Metadata and maintained naming standards.

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.

Created physical data models using forward engineering, Identified the Facts and Dimensions.

Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.

Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.

Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement and also Involved in Data Mapping.

Participated in performance management and tuning for stored procedures, tables and database servers

Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).

Environment: Erwin r8.0, SQL, SQL Server 2000/2005, Toad for Data point, SQL Developer, Teradata for SQL Assistance, Unix, Windows XP, Oracle 8i, Windows/NT/2000

Client: Aircel Limited, New Delhi, India April 2012 - July 2014

Role: Senior Data Modeler/Analyst

Description: Aircel is a Network provider company based on New Delhi. As of 2014 Aircel has had over 13 million customers in the India, reported a 2013 revenue of US$41.3 billion, and has had over 52,000 employees. In 2013, the company ranked 73 on the Fortune 500 list, which made it the highest ranked (by revenues) company based in Gurgoan. It has been the third largest health insurance in the nation.

Responsibilities:

Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.

Interacted with users (students, teachers, and medical Staff) using the existing system and Participated in sessions to gather and interpret business requirement and prepare DTD by attending Data Requirements sessions.

Performed Reverse Engineering of the legacy application using DDL scripts in ERwin, and developed Logical and Physical data models for Central Model consolidation.

Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the reverse engineering Erwin tool.

Conducted LDM walkthroughs and validation for EDW, EDW Staging & Data mart models.

Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the departments.

Developed data mapping documents for integration into a central model and depicting data flow across systems & maintain all files into electronic filing system.

Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.

Worked and extracted data from various database sources like DB2, CSV, XML and Flat files into the Data Stage.

Worked on DB2 UDB that provides graphical administration, Java and JDBC support & provided performance tuning and capacity planning on Oracle in order to help scale the system and optimize performance techniques for parallel processing.

Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to the Data warehouse.

Developed number of AB Initio Graphs based on School requirements using various ABInitio Components like Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Replicate etc.

Used Cobol-To-DML utility to generate AB Initio DMLs using mainframe copy books.

Metadata mapping from source system to target database fields and involved in creating ABInitio DML’s using input Table components.

Involved in designing fact, dimension and aggregate tables for Data warehouse Star Schema.

Involved in updating metadata repository with details on the nature and use of applications/data transformations to facilitate impact analysis.

Used Ab Initio to create Summary tables using Rollup and Aggregate components.

Created Multi File Systems, Multifiles (MFS) to run graphs in parallel for better performance.

Environment: ERWIN r5, IBM DB2, AB INITIO GDE 1.12.6.1, PL/SQL, MVS, TERADATA 12.0, ORACLE 9I, DB2 7.1, HP UNIX, CRYSTAL REPORTS 10.

Client: RationalHeads Technology Pvt Ltd., Noida, India June 2010 -Mar 2012

Role: Data Modeler/Analysis

Description: RationalHeads Technology company providing financial products and services to over 7 million Customers across the India. The application involved in the design and development of the Data Warehouse. The company’s data came from different operational sources and was then loaded into the Claims.

Responsibilites:

Built Conceptual, Logical and Physical model and implemented them on Care Synergy.

Understanding the application and building the database accordingly.

Participated in meeting with different teams of CMIS, MDM and CAREVIEW and took the requirements and implemented them on Care Synergy.

Interacted with the business Analyst and getting the functional requirements.

Gathering accurate data by data analysis and functional analysis.

Provided 24/7 support on Database perspective in case of any issue raises.

As this project follows Agile Methodology, I will be working with the QA people closely and load the data for Unit Testing and Manual Testing.

Check to see data model and database are in sync.

Data modeling, design & implementation based on established standards.

Done Data Loading using ETL for QA for testing and also worked closely with the developers and getting the requirement for the database side.

Forward engineer logical models into physical tables with CCNC naming standard class words.

Data Quality, Data Migration while loading the data from one database to another.

Has built a good knowledge on the application and gone through the each and every requirement clearly and implemented those on Database.

Review the data model with functional team and technical team.

Followed Data Standard Documents while building the database and participated in Database sessions for finalizing the database structure.

Created a Data Structure document for each table and column that is implemented on database .

Designed and developed Data Quality Reports, Chain of Trust Mechanisms for File processing.

Environment: SQL Server 2012, Windows Server 2003, Teradata, Windows XP, SQL Profiler, VSS, TFS, Erwin r7, DBTA, Initiate - IBM Tool for Person MDM, SQL Management Studio, DBTA, SSIS, Informatica

Client: Wipro Pvt Ltd., Banglore, India Sep 2008 -May 2010

Role: Data Modeler / Data Analyst

Description: Worked in different levels of Incident management and handling as Data Analyst. Coordination with different teams to come up with best possible insights for better Business Performance in terms of all predefined KPIs.

Responsibilities:

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

Performed in team responsible for the analysis of business requirements and design implementation of the business solution.

Developed logical and physical data models for central model consolidation.

Worked with DBAs to create a best fit physical data model from the logical data model.

Conducted data modeling JAD sessions and communicated data-related standards.

Used Erwin r7.0 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.

Developed process methodology for the Reverse Engineering phase of the project.

Used reverse engineering to connect to existing database and create graphical representation vb(E-R diagram)

Utilized Erwin’s reverse engineering and target database schema conversion process.

Involved in logical and physical designs and transforms logical models into physical implementations.

Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server.

Involved in different team review meetings.

Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.

Worked with report developers for building OLAP Cubes for ad hoc reporting.

Performed unit testing and tuned for better performance.

Involved in the critical design review of the finalized database model.

Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies. Involved in the study of the business logic and understanding the physical system and the terms and condition for database.

Created documentation and test cases, worked with users for new module enhancements and testing.

Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.

Environment: Erwin r7.0, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000 servers,

Oracle8i, SQL Server 2000/2005, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal

Reports, MS-SQL server analysis manager.

EDUCATION

Bachelor of Technology, GITAMS, India.

Contact this candidate