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.
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle. Quick starter with ability to master and apply new concepts. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Proficient leadership qualities, interpersonal skills, and the ability to effectively manage stress and engage in continuous learning.
• 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, CT

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 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, AnalysisandDesign.
• CreatedEntity relationships diagrams, data flowdiagrams and enforced allreferential 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.

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.
• Created documents for logical, physical and dimensional data models.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Created physical data models using forward engineering principles.
• Co-ordinated with QA team to test and validate the reporting system and its data.
• 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.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Used various kinds of Data sets with SSRS.
• Implemented Slowly Changing Dimensions Type2 and Type3 for accessing history of reference data changes.
• 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.
• Checked for all the modelling standards including naming standards, entity relationships on model and for comments in the model.
• 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.
• Used reverse engineering to connect to existing database and create graphical representation (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 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 Reports, MS-SQL server analysis manager.

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.
• Gathering, reviewing business requirements and Analyzing datasources from Excel/SQL for design. Development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Wrote complex SQL queries for validating the dataagainst different kinds of reports generated by Business Objects.
• Interacting with the Business Users for gathering design requirements and taking feedback on improvements.
• Developed SQL queries in SQL Server management studio, Toad and generated complex reports forth end users.
• 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.