SUMMARY

• 8+ years of total IT experience in teh field of Business Requirement, Data Architecture, Data analysis, Data Modeling, Developing, Implementation and Testing of Data Warehousing, Data Conversion, Data Cleansing in healthcare, and finance industry.
• Expertise in developing conceptual, logical and physical model for OLAP and OLTP systems using Erwin Data Modeling Tool.
• Experience in developing Star and Snow Flake Schemas for Data Warehousing Model.
• Strong Data Modeling experience using ER diagrams, Dimensional/Hierarchical data modeling, Star Schema modeling, Snow flake modeling using tools like Erwin, ER Studio.
• Working knowledge of entities, attributes, logical relationships, and validation of a model using Normalization techniques.
• Four years of experience as Data Analyst, gathering data from different sources, data definition, and data cleaning and loading teh data in different business warehouses.
• Experience in gathering requirements and develop detailed documentation related to systems requirements and conceptual solutions.
• Technical expertise in BI methodologies including Tableau, QlikView, MSBI and Cognos.
• Expertise in Data Warehousing development life cycle (SLDC).
• Expertise in configuring and manipulating Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling. Extensive knowledge wif Dimensional Data modeling, Star Schema / Snowflakes Schema, Fact and Dimension tables.
• Experience in writing teh SQL queries. Performed backend testing and data validation by writing SQL queries.
• Extensive database experience and highly skilled in Oracle, SQL Server, DB2 and Teradata, Hadoop.
• Working knowledge of ETL, Data Warehousing wif OLAP Technology.
• Formulated and defined systems scope and objectives through research combined wif an understanding of applicable business systems and industry requirements.
• Worked on Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing teh full history of accounts and transaction information.
• Support master data management by removing duplicates, standardizing data (mass maintaining), and incorporating rules to eliminate incorrect data from entering teh system in order to create an authoritative source of master data.
• Experienced in Providing analysis and solutions of current production maintenance issues.
• Proven experience in complete life cycle of Design, Maintenance and Documentation of Data Marts.
• Strong business understanding Health care, automobile and Finance industries.
• Experience in Keyword Driven, Data driven frame works, function libraries, and enhancements in teh scripting.
• Train data analysis beginners to improve overall efficiency of department.
• Multitasking and prioritizing projects, as well as teh ability to appropriately set & manage expectations.
• Team player and self-starter wif good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILLS

Database: Oracle 11g, 12c, DB2, SQL Server 7.0, Teradata, Query Utility (BTEQ), Hadoop BigInsights.

Tools: Toad 12.9, AQT v10, IDA, IDQ, Erwin, ER Studio, PL/SQL Developer.

BI Tools: Tableau, QlikView, Cognos, MSBI, SSRS.

Operating Systems: Windows 2000/NT 4.0 Server, AIX, HP-UX 11i v2, Redhat Linux

ETL Tools: Informatica Power center 7.x/8.x,9.x, SQL procedures, DataStage

Web/App servers: Internet Information Server, HP Application Lifecycle Management 12.01 .

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

Data Architect

Responsibilities:

• Meet wif Actuaries and business stakeholders to gather technical requirements and assist Business Analyst in creating Business Requirement Document.
• Involved in creating Technical Specification Documents and Data Requirement Documents.
• Perform data profiling of mainframe data source using Informatica Data Quality Tool(IDQ).
• Work along wif Data Architects in determining most suitable solution approach for creating teh data warehouse.
• Create conceptual and logical data model and present it to Actuaries for approval.
• Create Physical Data Model in IBM Data Architect tool (IDA).
• Make sure that teh PDM matches NW standard guidelines.
• Create Source to Target Mapping documents (STM) to deliver to teh development line.
• Query data repositories to determine level of data quality and completeness.
• Analyze new sources of data to determine fitness, form and transformation rules necessary for merging into target repositories.
• Adhere data models as per enterprise standards and appropriate as per business requirements.
• Prepare data lineage documents.
• Work wif SQL DBAs to improve database performance using indexes and partitions.
• Learn and understand Hadoop framework to create database objects in Hadoop.
• Analyze teh source data to determine natural keys and parent-child relationship.
• Understand and explain complex data integration and ETL processes using Datastage.
• Work in Agile environment to meet scrum deadlines and complete user stories.
• Perform data visualization and generate reports for business partners using Tableau, SSRS.
• Present data reports, conclusion and recommendation to stakeholders.
• Worked wif Data Governance team to get teh attribute definitions and data quality standards.
• Balance business need for changes wif current system constraints.
• Maintain knowledge base on existing application functionality and data structures and relationships.
• Lead junior data analysts and data modelers, hence promoting environment of leadership, understanding and collaboration.

Environment: IBM Data Architect, Erwin, DBeaver, Netezza, SQL Server 2016, Hadoop BigInsights, Informatica Data Quality, RTC for Agile, HP ALM, Tableau, SSRS.

Confidential, Rochester NY

Data Architect me

Responsibilities:

• Analyzed business requirements, functional specifications and source to target mapping as a guide to data modeling.
• Understood, defined and structured how data is related to business operation and prepare a conceptual model.
• Assessed suitability of existing data model by choosing a suitable data modeling approach.
• Built flexible physical and logical data model to in corporate changes as per business requirements.
• Reconciled multiple source models into single logical/physical consistent model.
• Ensured teh Data Model is per Data Architect guidelines and follows business standards and best practices.
• Rationalized teh relationship expressed in Logical Data Model to teh schema of physical data store.
• Designed tables by analyzing requirements from XML schema.
• Created summary reports using SSRS and Report Builder.
• Created DDL for teh Physical Data Model and run in appropriate schema for table creation.
• Successfully completed a POC on Hadoop.
• Worked on partitioning and indexes for better query performance and purge strategy.
• Performed complete compare to analyze teh difference between database objects in model and database.
• Understood teh requirements for Views, Lookup tables and Crosswalk Tables and create a data model as per requirement.
• Developed SQL Loader scripts to load data into tables from flat files.
• Estimated tablespace requirement by using ERWin and Oracle database.
• Prepared Table Instance Chart for tables that are created in teh database.
• Made sure that grants on tables and views are in accordance wif teh database use.
• Developed data modeling best practices, guidelines and standards.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Used Oracle Enterprise Manager to analyze SQL queries to track performance issues.
• Met wif DBAs to resolve performance improvement issues.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Obtained Change Request from HP Application Lifecycle Management and implement modifications in data model and database.
• Done data mapping and data analysis to identify teh data sources and data fields to be selected.
• Involved in masterdata and metadata management.
• Involved in a POC of Big Data Dental claims conversion process.

Environment: Erwin 9.64, Embarcadero ERStudio 2016, XML, Toad 12.9 for Oracle 11g/12c, Hadoop, AQT v10, HP ALM, Report Builder, Analytix DS 7.1,HP Agile Manager, Eclipse CVS, SSRS, Windows7.

Confidential, Boston MA

Data Modeler/Data Analyst

Responsibilities:

• Involved in understanding teh business requirements and defining scope of teh project.
• Generated use cases for teh application.
• Identified teh issues wif RDS Extract system and done an impact analysis for using teh same system for Reconciliation.
• Developed and maintained Enterprise Data Model to server as strategic planning model for enterprise data warehouse.
• Developed Logical and Physical Data model for central data consolidation and performed reverse engineering using Erwin.
• Resolved issues and mitigated risks by working wif business users, and other stakeholders.
• Gatheird requirements from business user, helped business PM to complete teh BRD.
• Researched teh CMS website and helped business team in formulating business rules.
• Developed teh logical data model wif teh help of data architect.
• Worked wif EDI team, developers and production support team at various stages of teh project.
• Created new database objects like Tables, Stored Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Wrote conceptual design document based on teh Business requirement document.
• Done extensive data analysis and converted teh full logic to plain SQL codes and put it in data selection strategy document.
• Wrote SQL queries to extract claims and eligible member level information from databases.
• Worked wif external entities to figure out teh mechanism of receiving files and to update it in teh database.
• Worked wif external entities along wif teh business users to receive files and teh content of teh file that is necessary.
• Worked wif teh architects and developers to design an efficient system.

Environment: Informatica9.x, ER Studio, XML, MS SQL Server, T-SQL, SSIS, SSRS, XQuery, Report Builder, Windows7.

Confidential, Louisville KA

Data Modeler

Responsibilities:

• Gatheird and translated business requirements into production level technical specifications and made enhancements to existing business functionalities.
• Worked wif DBAs to develop conceptual, physical and logical data models for central model consolidation.
• Used ERWIN for effective model management of dividing, reusing and sharing model information and design for productivity improvement.
• Used Erwin to create data tables using forward engineering.
• Developed normalized logical and physical data model to design OLTP operation for banking sector.
• Involved in creation and development of data warehousing and repositories for Metadata.
• Used ETL tool Informatica for data transformation and populating teh data tables.
• Involved in creation and maintenance of repositories containing Metadata.
• Created and scheduled jobs using SQL Server to transfer data from one table to other.
• Involved in creation of data reports for business needs using Cognos.
• Worked on IBM Infosphere platform for data integration and governance of Big Data, MDM.
• Handled teh entire testing process including test data creation, developing test cases, execution, and data validation.
• Prepared test data and compared teh expected results wif teh actual results.
• Documented teh test requirements and set teh traceability between different requirements.
• Reviewed and communicated teh inconsistencies between requirements and application.
• Performed GUI Testing, System testing, and Database testing.
• Executed teh test cases in different QA environments and for this enhanced teh test cases using data scenarios and data driven approach.
• Developed SQL Queries to query teh database to test teh back end process of teh application.
• Validated and consolidated reporting of financial statements from multiple ERP Systems.

Environment: Informatica9.x, ER Studio, UNIX, Shell Scripting, Oracle 11gR2, PL/SQL.

Confidential

Data Modeler

Responsibilities:

• Conducted meetings wif end users and gatheird requirements by taking interviews.
• Analyzed business requirements for better understanding of test requirements to develop test cases.
• Developed Conceptual and Logical database model using Erwin.
• Worked wif developers to better understand Entity Relationship Diagram (ERD), create test plans, gather data for data driven test cases.
• Extensively worked on SSIS to extract data from OLAP, transform teh data and load it into OLAP.
• Provided sequence and flow diagrams for different modules.
• Documented teh test metrics and defects. Closed bug reports after closing.
• Involved in Data mapping specification for system planning.
• Used SQL for Data Profiling, Data Analysis and Report generation.
• Worked wif business people and data stewards for creating target-mapping document.

Environment: ERWIN, MSBI (SSRS, SSIS), SQL Server, Microsoft Excel.