SUMMARY:

• Senior Data Modeler/Analyst with 8+ years of experience in data analysis and modeling, with excellent understanding of Data Warehouse and Data Mart designing.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling using 3NormalForm (3NF) and Multidimensional Data Modeling Schema for various environments and business processes.
• Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects.
• Good command in modeling using case tools like Erwin, Oracle Designer, Power Designer.
• Extensively worked on ERWIN tool with all features like REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Experienced with DDL and DML including Joins, Functions, Indexes, Views, Constraints, Primary Keys and foreign keys
• Experience in carrying out the entire Software Development Life Cycle (SDLC).
• Good understanding of Teradata SQL Assistant, Teradata Administrator and data load/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments.
• Generate DDL scripts for database modification, Macros, Views and set tables.
• Authorized to work in the US for any employer.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Developed Data dictionary and maintained Metadata for each model.
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.
• Experienced in using SSRS and Congas to create and manage reports.
• Created high level ETL design document and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Developed database objects like PL/SQL packages, Oracle tables, stored procedures, triggers that are used for meeting the business objectives.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
• Participated in performance management and tuning for stored procedures, tables and database servers.

TECHNICAL SKILLS:

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data Integration and Migration, ETL Architecture and Design, Data Warehouse, OLTP, OLAP

Modeling Tools: Erwin 9.x, Rational Rose, ER/Studio, MS Visio, Power designer, Embarcadero.

Databases: My SQL Server 2012/2008R2/2005, Oracle 12c/11g/10g/9i/8i, Teradata R14/R13/R12, MS Access

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL

Operating Systems: Windows, UNIX, MS DOS, Sun Solaris.

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x / 6.x, Cognos7.0/6.0., Tableau, Business Objects, Crystal Reports.

ETL Tools: Informatica Power Center 7.1/6.2, Data junction, Ab - Initio, Data Stage

Web technologies: HTML, DHTML, XML, CSS.

Scripting Languages: VBScript, JavaScript, UNIX Shell Script.

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD).

Tools: MS-Office suite (Word, Excel, MS Project and Outlook), TOAD, BTEQ, Fast Load, Multi Load, Fast Export.

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Senior Data Modeler

Responsibilities:

• Understand and translate business needs into data models supporting underwriting workstation services.
• Work with the Application Development team to implement data strategies, build data flows and develop data models
• Create conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Involved in preparing modeling estimates, DFD, Volumetric, defining enterprise standards for best practices.
• Follow best practices for standard naming conventions and coding practices to ensure consistency of data models according to CI Information Architecture Standards.
• Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
• Conduct model reviews with Business Stakeholders, Development Engineers, Information Architects and Quality Assurance team to ensure the accuracy of the data model.
• Implemented PWI conceptual data model describing the entire PWI organization which combines PI and WI.
• Designed and implemented multiple phases of Data warehouse with data extracted from various OLTP systems like Defined Contributions on DB2 and Defined Benefits on Sybase etc for a centralized pool of data to report from using OBIEE. Designed cubes and rollups for all reporting efforts.
• Interacted with Enterprise Architects, Business users and BSA's to gather and interpret business requirements.
• Architected and maintained power designer logical and physical data models of the data warehouse and data marts. Worked closely with the DBA team to complete and generate the physical Database in development and test environments.
• Extensive data analysis and modeling on all Workplace products from OLTP to Warehouses to Data Marts
• Prepared and maintained database architecture and modeling policies, procedures and standards.
• Applied data naming standards, checked models in and out from power designer repository.
• Documented many existing data models to enable sharing and publishing of data.
• Worked closely with DBA's in generating DDL's in order to implement the physical models.
• Lead the design and preparation of various standard documents for modeling and naming conventions including internal data modeling Do's and Dont's.
• Developed definitions of data objects, including attributes and unique identifiers.
• Good understanding of data modeling for Big Data and Data Vault.

Environment: Power Designer, Oracle Exadata, DB2, Sybase, SQL Server, Oracle 11g, OBIEE, SQL, Meta data Manager, Data Warehouse

Confidential, Columbus, IN

Senior Data Modeler

Responsibilities:

• Worked as a Data Modeler/Analyst to generate Data Models using Erwinand subsequent deployment to Enterprise Data Warehouse.
• Part of JAD sessions for defining business requirements and translating them into technical specifications
• Developed logical data models and physical database design and generated database schemas using Erwin 8
• Worked with DBA to create Best-Fit Physical Data Model from the logical Data Model using Forward Engineering in Erwin
• Generated and DDL (Data Definition Language) scripts using ERWIN 7.2 and assisted DBA in Physical Implementation of data Models.
• Performed Data analysis of existing data base to understand the data flow and business rules applied to Different data bases using SQL
• Reverse Engineered the existing Stored Procedures and wrote Mapping Documents for them.
• Used Erwin entity-attribute editor and Erwin relationship definition editor to modify, update existing primary, foreign, alternate keys and identifying, non-identifying, recursive and subtype relationships.
• Designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NFmodel
• Performed data analysis and dataprofiling using complex SQL on various sources systems including Oracle, SQL Server and DB2.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Defined ETL framework which includes load pattern for staging and ODS layer using ETL tool, file archival process, data purging process, batch execution process
• Designed Mapping Documents and Mapping Templates for the ETL team.

Environment: MS Visio, SQL Server 2008, Oracle 11g, Erwin 8

Confidential, West Des Moines, IA

Data Modeler

Responsibilities:

• Facilitated JAD sessions for project scoping, requirements gathering & identification of business subjectareas.
• Identified and documented detailed business rules and use cases based on requirements analysis.
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Developed Logical Model from the conceptual model.
• Worked with DBA's to create a best-fit Physical Data Model from the logical data model.
• Used Forward Engineering to generate DDL from the Physical Data Model and handed it to the DBA.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts anddimensions.
• Designed STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions.
• Used ETL methodology for data extraction, transformations and loading in a complex Enterprise DataWarehouse (EDW)
• Identified and documented data sources and transformation rules required to populate and maintain data Warehouse content.
• Assisted in Informatica Server jobs to load data from sequential files and flat files.
• Involved in extracting, cleansing, transforming, integrating and loading data into different Data Marts usingData Stage Designer.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, databaselinks and bulk collects.
• Used Erwin's reverse engineering to connect to existing database and ODS to graphically represent theEntity Relationships.
• Involved in Performance tuning by leveraging oracle explain utility and SQL tuning.

Environment: Oracle 10g, SQL Server … DB2, Microsoft Transaction Server, Erwin, Teradata 14, Crystal Reports, Informatica.

Confidential, Collierville, TN

Data Analyst/Data Modeler

Responsibilities:

• Involved in dimensional modeling of the data warehouse to design the business process.
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Developed ER and Dimensional Models using Erwin advanced features.
• Created physical and logical data models using Erwin.Done extensive bulk loading in to target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in writing UNIX shell scripts for Informatica ETL tool to automate sessions.
• Involved in M-LOAD, Fast-load and T-pump loading to migrate data from Oracle to Teradata.
• Created BT queries and stored procedures in Teradata.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.

Environment: Erwin 4.0/7.0, Oracle 9i, DB2 8.0, PL/SQL, Teradata V2R3, MS SQL Server 2000,Business Objects 5.1, MS Access, UNIX Shell scripting, Windows XP.

Confidential, Troy, MI

Data Modeler

Responsibilities:

• Performed requirement gathering and detailed them into high-level technical specifications - new features and enhancements.
• Designed Audit Balance Control data model for ETL developers' source-to-target tracking.
• Used ERWIN for creating, sharing and re-using data models for productivity effectiveness.
• Performed Reverse Engineering of DB2 databases and forward engineered them to SQL Server 2012 using Erwin and Power Designer
• Performed Reverse Engineering on existing data models to lessen database fetching time, to create Entity Relationship on existing database and schema conversions.
• Used Informatica Analyst Tool for tables column profiling.
• Worked to redefine relationships and attributes on existing database as a part of data cleansing/analysis deliverable.
• Involved in MDM - Data mapping activities.
• Performed Central Model Consolidation by developing logical and physical data models.
• Used Crystal reports 9.x to develop ad-hoc reports.
• Worked with DBA to understand Database's health and conditions on improvement.
• Conducted Weekly meeting to ensure Data Modeling and data standards.
• Extensively used Star Schema to convert logical data models, dimensional models.

Environment: ERWIN 9.X, IBM DB2, IBM MDM, MS SQL 2012, Informatica, SQL/T-SQL, Crystal Reports 9.X