PROFESSIONAL SUMMARY:

• 7+ years of experience in data modeling, data analysis, design of OLAP and OLTP systems, data warehousing implementations for financial, healthcare, insurance and banking industries.
• Experience in developing conceptual, logical and physical data models as per enterprise standards using ERWIN, Sybase Power designer and Embarcadero E - R Studio.
• Well versed in system analysis, Relational and Dimensional Modeling, Database design and implementing RDBMS specific features.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and strong understanding of principles of data warehousing and Slowly Changing Dimensions (SCD) Type I and Type II.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin data modeler, E-R Studio.
• Excellent knowledge of Bill Inmon and Ralph Kimball methodologies to design database architecture.
• Extensive experience of 4+ years in Tableau Desktop/ Tableau Server, creating highly interactive DataVisualization Dashboards using features such as DataBlending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• Articulate with Data Conversion, Data Quality, Data Profiling, Performance Tuning and System Testing and implementing RDBMS features.
• Good working knowledge of Metadata management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Knowledge on developing, implementing and administering extract, transform and load(ETL) processes from raw file, flat file, excel and OLE DB sources using Informatica.
• Well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• Expertise in the DataAnalysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non-relational databases.
• Experience working with Agile and Waterfall data modeling methodologies.

TECHNICAL SKILLS:

Languages: PL/SQL, T-SQL, Java scripting and Python Programming.

Databases: SQL Server 2012/2008/2005, MS Access, NoSQL, Hadoop, Hive, Pig, Oracle 11g/10g/9i, Teradata 14.0

Data Modelling Tools: ERWIN, ER Studio, UML 2.x, MS Visio, Rational Rose

ETL Tools: Informatica Power Center 8.6/7.1/6.2

Dash boarding & Reporting Tools: Qlickview, Tableau, SAP Business Objects, Crystal Report, Xcelsius, SSIS.

Bug Tracking: IBM ClearQuest, Jira

Operating Systems: Microsoft Windows 8.1/7/ Vista/ 7, UNIX, DOS

Methodologies: Agile/Scrum & Waterfall

PROFESSIONAL EXPERIENCE

Confidential, seatle,WA

Senior Data Modeler / Analyst

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 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.

Confidential - Indianapolis, IN

Data Analyst/ Sr. Data Modeler

Responsibilities:

• Gathered requirements and created ER (entity-relationship) diagrams as part of requirements analysis using ERWIN.
• Used Forward engineering to develop sound Physical Data Model by implementing referential integrity, database rules, super types and sub types.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Maintained warehouse metadata, naming standards and warehouse standards.
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.
• Involved in the mapping of data sources and analytics, with the goal of ensuring data quality.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modelling techniques.
• Identified the Facts and Dimensions.
• Assisted in designing, development, and architecture of Hadoop clusters and HBase systems.
• Involved in clustering of Hadoop.
• Used PIG Latin scripts to extract the data from the web server output files to load data onto HDFS.
• Worked with Database Administrators (DBA's) to finalize the physical properties of the tables such as Partition key.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.

Environment: SQL Server 2008, Hadoop, Hive, Pig, MapReduce, Crystal Reports7.5/8.0, Windows 2000, Micro strategy 9.3, Crystal Enterprise8.0, Erwin, power designer, CSV files, XML files, Business Objects, Oracle10g.

Confidential - Fishers, IN

Data Analyst/Data Modeler

Responsibilities:

• Interacted with business users to identify and understand business requirements and identified the scope of the projects.
• Identified and designed business Entities and attributes and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Developed normalized Logical and Physical database models for designing an OLTP application.
• Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
• Created XSD's for applications to connect the interface and the database.
• Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing database.
• 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.
• Used Forward engineering to develop physical model with DDL based on the requirements gathered from a logical model in ERWIN.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Involved in Data Mapping activities for the data warehouse.
• Extensively worked on Performance Tuning and understanding Joins and Data distribution.
• Executed DDL to create databases, tables and views.
• Experienced in generating and documenting Metadata while designing application.
• Generate reports for better communication between business teams.

Environment: ERWIN, Oracle 11g, Teradata, Crystal Reports, Toad, Windows OS, DB2, SSRS, Business objects, SQL Server 2008.

Confidential

Data Modeler / Data Analyst

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.
• 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 r, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000 serversOracle8i, SQL Server 2000/2005, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal

Confidential

Data Analyst

Responsibilities:

• Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications.
• Used Erwin and Visio to create 3NF and dimensional Datamodels and published to the business users and ETL / BI teams.
• Involved in Datamapping specifications to create and execute detailed system test plans. The data mapping specifies what datawill be extracted from an internal datawarehouse, transformed and sent to an external entity.
• Managed full SDLC processes involving requirements management, workflow analysis, source dataanalysis, datamapping, metadata management, dataquality, testing strategy and maintenance of the model.
• Created and maintained Logical and Physical models for the datamart. Created partitions and indexes for the tables in the datamart.
• Multiple phased projects to develop EDW (Enterprise DataWarehouse) and DataMarts to support Business Intelligence needs as per the requirements of the client.
• Performed Dataprofiling and analysis applied various Datacleansing rules designed datastandards and architecture/ designed the relational models.
• Wrote complex SQL queries for validating the dataagainst different kinds of reports generated by Business Objects.
• Involved in extensive Datavalidation by writing several complex SQL queries and Involved in back-end testing and worked with dataquality issues.

Environment: Informatica Power Center 6.0, Informatica PowerMart, MS Access Reports, Unix Shell Scripting, SQL*Plus, Erwin, SQL*Loader, MS SQL Server 2008, Sun Solaris 2.7, DB2.