SUMMARY

• 8+ years of total IT experience in the 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 the 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 with Dimensional Data modeling, Star Schema / Snowflakes Schema, Fact and Dimension tables.
• Experience in writing the 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 with OLAP Technology.
• Formulated and defined systems scope and objectives through research combined with an understanding of applicable business systems and industry requirements.
• Worked on Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the 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 the 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 the scripting.
• Train data analysis beginners to improve overall efficiency of department.
• Multitasking and prioritizing projects, as well as the ability to appropriately set & manage expectations.
• Team player and self-starter with 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 with 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 with Data Architects in determining most suitable solution approach for creating the 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 the PDM matches NW standard guidelines.
• Create Source to Target Mapping documents (STM) to deliver to the 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 with SQL DBAs to improve database performance using indexes and partitions.
• Learn and understand Hadoop framework to create database objects in Hadoop.
• Analyze the 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 with Data Governance team to get the attribute definitions and data quality standards.
• Balance business need for changes with 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 I

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 the Data Model is per Data Architect guidelines and follows business standards and best practices.
• Rationalized the relationship expressed in Logical Data Model to the schema of physical data store.
• Designed tables by analyzing requirements from XML schema.
• Created summary reports using SSRS and Report Builder.
• Created DDL for the 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 the difference between database objects in model and database.
• Understood the 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 the database.
• Made sure that grants on tables and views are in accordance with the database use.
• Developed data modeling best practices, guidelines and standards.
• Involved with 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 with 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 the 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 the business requirements and defining scope of the project.
• Generated use cases for the application.
• Identified the issues with RDS Extract system and done an impact analysis for using the 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 with business users, and other stakeholders.
• Gathered requirements from business user, helped business PM to complete the BRD.
• Researched the CMS website and helped business team in formulating business rules.
• Developed the logical data model with the help of data architect.
• Worked with EDI team, developers and production support team at various stages of the 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 with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Wrote conceptual design document based on the Business requirement document.
• Done extensive data analysis and converted the 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 with external entities to figure out the mechanism of receiving files and to update it in the database.
• Worked with external entities along with the business users to receive files and the content of the file that is necessary.
• Worked with the 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:

• Gathered and translated business requirements into production level technical specifications and made enhancements to existing business functionalities.
• Worked with 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 the 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 the entire testing process including test data creation, developing test cases, execution, and data validation.
• Prepared test data and compared the expected results with the actual results.
• Documented the test requirements and set the traceability between different requirements.
• Reviewed and communicated the inconsistencies between requirements and application.
• Performed GUI Testing, System testing, and Database testing.
• Executed the test cases in different QA environments and for this enhanced the test cases using data scenarios and data driven approach.
• Developed SQL Queries to query the database to test the back end process of the 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 with end users and gathered 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 with 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 the data and load it into OLAP.
• Provided sequence and flow diagrams for different modules.
• Documented the 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 with business people and data stewards for creating target-mapping document.

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