SUMMARY:

• 5 years of professional experience in Data Modeling and Data Analysis as a Proficient in gathering business requirements and handling requirements management.
• Experienced in designing the Conceptual, Logical and Physical data modeling using ER win and ER Studio Data modeling tools.
• Good in System analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experience in Developing Data Models For both OLTP/OLAP systems
• Exposure to Both Kimball and Bill Inmon Data Warehousing Approaches
• Experience in modeling OLTP and OLAP using tools like Erwin r9.6/9.1/r8/r7.1/7.2, Sybase Power designer 12.1 and E - R Studio.
• Having Good Experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experience In Working Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions Tables.
• Experience in building reports using SQL Server Reporting Services and Crystal Reports
• Experience in performing Reverse Engineering of Physical Data Models from data, SQL scripts.
• Worked extensively on Forward Engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF, PDF format depending upon the requirement
• Experience in Creating Partitions, Indexes, Indexed views to improve the performance, reduce contention and increase the availability of data.
• Expert in writing SQL queries and optimizing the queries in Oracle 9i/10g/11g, SQL Server 2005/2008/2012/2014 .
• Extensive experience in development of Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Experienced in designing the Data Mart and creation of Cubes.
• Experience in Data transformation, Data Mapping from source to target database schemas, Data Cleansing procedures
• Performed extensive data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Experience in Performance Tuning and query optimization techniques in transactional and Data Warehouse Environments.
• Experience in using SSIS in solving complex business problems.
• Significant Exposure to Talend Etl Tool.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r9.1/9.5, 9.6, Erwin r8.2, Erwin r7.1/7.2,Erwinr7, Embarcadero ER/Studio, Oracle Designer, Sybase Power Designer.

OLAP Tools: Microsoft Analysis Services, Business Objects and Crystal Reports 9.

Programming Languages: SQL, PL/SQL, Base SAS, HTML, CSS, XML,C,C++,UNIXandPython scripting(basic)

Database Tools: MicrosoftSQLServer2000/ 2005/2008/2012/2014 MySql, Oracle 11g/10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1.

Packages: Microsoft office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

ETL Tools: Informatica 7.1/6.2, Data Junction, Ab-Initio, Data Stage, SSIS.

PROFESSIONAL EXPERIENCE:

Data Modeler/Data Analyst

Confidential, Oak Brook, IL

Responsibilities:

• Attended and participated in information and Requirements Gathering sessions.
• Ensured that Business Requirements can be translated into Data Requirements.
• Created Business Requirement documents (BRD’s ), such as SRS & FRS and integrated the requirements and underlying platform functionality.
• Translated Business Requirements into working Logical and Physical Data Models .
• Developed the Logical and physical data model and designed the data flow from source systems to Teradata tables and then to the Target system.
• Developed several releases of the Enterprise Canonical XML Schema (ECXS), enabling timely implementation of Exchange-related projects for the Affordable Care Act.
• Strong experience using Web Services and API’s in python.
• Profiled python code for optimization and memory management.
• Designed the technical specifications document for Teradata ETL processing of data into master data ware house and strategized the integration test plan and implementation.
• Developed complex Multi load and Fast Load scripts for loading data into Teradata tables from legacy systems.
• Used advanced data modeling concepts such as Family of Stars, Confirmed Dimensions, and Bus Matrix in order to handle complex situations.
• Designed and Developed Use Cases, Activity Diagrams, and Sequence Diagrams using Unified Modeling Language (UML).
• Strong experience working with Cloudera distribution of Hadoop (5.8.5).
• Experience in Installation, Configuration, Testing, Backup, Recovery, Customizing and Maintenance of clusters using Apache Hadoop, Cloudera Hadoop .
• Involved in the analysis of the existing claims processing system, mapping phase according to functionality and data conversion procedure.
• Performed Normalization of the existing OLTP systems (3rd NF ), to speed up the DML statements execution time.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ER Studio.
• Data modeling in Erwin; design of target data models for enterprise data warehouse (Teradata ).
• Created and Maintained Logical Data Model (LDM) for the project. Includes documentation of all Entities, Attributes, Data Relationships, Primary and Foreign Key Structures, Allowed Values, Codes, Business Rules, Glossary Terms, etc .
• Worked extensively on Transactional- grain, Periodic snap shot grain and Accumulating snap shot grain while designing dimensional models.
• Validated and updated the appropriate LDM\'s to Process Mappings, Screen Designs, Use Cases, Business Object Model, and System Object Model as they evolve and change.
• Designed the Database Tables & Created Table and Column Level Constraints using the suggested naming conventions for constraint keys.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance batch and response time of data for users.
• Developed and designed automated solution using Teradata macros, stored procedures and excel macros for business users to load reference data directly to tables.
• Maintained Data Model and synchronized it with the changes to the database.
• Involved with all the phases of Software Development Life Cycle (SDLC ) methodologies throughout the project life cycle.
• Experience in NoSQL and bigdata technology
• Attendant architecture meeting and data governance meeting to understand the project.
• Identified and mapped various data sources and their targets successfully to create a fully functioning data repository.

Environment: SQL Server 2012/2014, Tera Data, Toad, Erwin 9.2, Microsoft Visual Studio.

Data Modeler/Data Analyst

Confidential, Dallas, TX

Responsibilities:

• Interacted with the Subject Matter Experts (SME's) and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Worked with Internal and External Users to define requirements and coordinated user management and developer expectations.
• Mapped the Source information to identify the target information.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Monitored Change Requests and documented requirements, integrating them with Use Cases.
• Developed and Implemented Test Strategies using the Test Director.
• Designing Logical Data Models and Physical Data Models using Erwin.
• Developing the Conceptual Data Models, Logical Data Models and transformed them to creating schema using Erwin.
• Developing the Data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Forward Engineering the Data Models, Reverse Engineering on the existing Data Models and updates the data models.
• Database cloning to synchronize test and Developing Database to production database.
• Created Database Tables, Views, Indexes, Triggers and Sequences and developing the Database Structure.
• Data cleansing process on staging tables.
• Wrote a complex SQL, Procedures, Functions, and Packages to validate data and testing process.
• Normalizing the Data and developing Star Schema.
• Reducing the CPU cost for the query by various hints and tuning SQL queries.
• Extensively generated both logical and physical reports from Erwin.
• Conducted ETL development in the Netezza environment using standard design methodologies.
• Assessed the Netezza environment for implementation of the ETL solutions.
• Involved in developing the data warehouse for the complete Actuarial Information System Application.
• Worked with DBA's after generating DDL to create tables in database.
• Plan, design and implement application database code objects, such as Stored Procedures and Views.
• Build and maintain SQL scripts, Indexes, and complex queries for data analysis and extraction.
• Created reports by dragging data from cube and wrote mdx scripts.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services from OLTP and OLAP data sources.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: Erwin, Oracle 10g/11g, TOAD, Microsoft Visual Source Safe, IBM Rational Clear Case and Clear Quest, Microsoft Office.

Data Modeler/ Data Analyst

Confidential, Dallas, Texas

Responsibilities:

• Interacted with business users to clarify on business logic required for the data models.
• Involved in gathering complete requirements by organizing and managing meetings with Business Analysts, Data Stewards and subject matter experts on a regular basis.
• Analyzed OLTP source systems and Operational Data Store and research the tables/entities required for the project. Designing the measures, dimensions and facts matrix document for the ease while designing.
• Analyzed the specifications and identified the source data from disparate data sources like Oracle, MS SQL Server and flat files that needs to be moved to data warehouse.
• Designed and maintained the Logical /Physical dimensional data models and generating the DDL statements and working with the database team in creating the tables, views, keys in the database.
• Performed Data profiling and identified the risks involved with data integration to avoid time delays in the project.
• Performed Data scrubbing for removing incomplete, irrelevant data and maintained consistency in the target data warehouse by cleaning the dirty data.
• Worked on specifications given by the Data governance team and Data quality team that required managing the master data from all the business units and ensuring data quality across the enterprise.
• Validate the models with the production data and developed the Source to Target mapping matrix, an expert solutions to design and develop the mappings for the loading of data, to the ETL developers.
• Conducted frequent meetings with my ETL coding and development team to co-ordinate the process and to efficiently organize and distribute the workflow among the team.

Environment: ER Studio 4.5, INFORMATICA Power Center 5.0, Oracle 10g, SQL Server 2008, Flat files, SQL/PL SQL, WIN 2000/NT

Data Modeler/ Data Analyst

Confidential

Responsibilities:

• Extensive knowledge in banking, insurance, pharmaceuticals, healthcare and retail domains with maintaining respective databases.
• Extensive IT experience in Data Modelling, Data warehouse Design, ER Modeling, Canonical Modeling, Dimensional Modeling (Star Schema. Snowflake Schema Modeling) and good understanding of Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Articulate with Data Conversion, Data Quality, Data Profiling, Performance Tuning and System Testing and implementing RDBMS features.
• Immense Experience in Customer Interaction, Collecting and Handling Customer Requirements.
• In a data warehouse environment, designed the staging area based on OLTP concepts, cleansed and profiled before loading into data marts.Expert in creating Canonical modeling repository that can be reused for generating schema for the current and future applications operations.
• Coherent with Normalization/DE Normalization techniques in relational/dimensional environments and have performed normalizations up to 3NF (Third Normal Form).
• Competent knowledge in Data Modeling tools like ERWIN, IBM Rational Software Architect (RSA) and Embarcadero ER/Studio.
• Experienced as both an onsite and offshore project member.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.
• Well versed in Forward and Reverse Engineering principles.
• Conversant in oracle tools and utilities like Toad, SQL PLUS, SQL Developer.
• Created data mappings to load data from target using different transformations and executed workflows for data loads to target systems.
• Good understanding of Ralph Kimball's and Bill Inmon's modelling techniques.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Informatica.
• Well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• An excellent experience in generating ad-hoc repots using Crystal Reports.
• 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.

Environment: SQL Server 2014,DB2, ORACLE, Toad for Oracle 9.1 Expert, Erwin Data Modeler 8.0, MS Visio .

Data Modeler

Confidential

Responsibilities:

• Interacted with business users to clarify on business logic required for the data models.
• Involved in gathering complete requirements by organizing and managing meetings with Business Analysts, Data Stewards and subject matter experts on a regular basis
• Analyzed OLTP source systems and Operational Data Store and research the tables/entities required for the project. Designing the measures, dimensions and facts matrix document for the ease while designing.
• Analyzed the specifications and identified the source data from disparate data sources like Oracle, MS SQL Server and flat files that needs to be moved to data warehouse.
• Designed and maintained the Logical /Physical dimensional data models and generating the DDL statements and working with the database team in creating the tables, views, keys in the database.
• Performed Data profiling and identified the risks involved with data integration to avoid time delays in the project.
• Performed Data scrubbing for removing incomplete, irrelevant data and maintained consistency in the target data warehouse by cleaning the dirty data.
• Worked on specifications given by the Data governance team and Data quality team that required managing the master data from all the business units and ensuring data quality across the enterpris.
• Validate the models with the production data and developed the Source to Target mapping matrix, an expert solutions to design and develop the mappings for the loading of data, to the ETL developers
• Conducted frequent meetings with my ETL coding and development team to co-ordinate the process and to efficiently organize and distribute the workflow among the team.

Environment: ER Studio 4.5, INFORMATICA Power Center 5.0, Oracle 10g, SQL Server 2008, Flat files, SQL/PL SQL, Win 2000/NT.