SUMMARY

• Data Modeling professional with around 8 years of total IT experience and expertise in data modeling for data warehouse/data mart development, SQL and analysis of Online Transactional Processing(OLTP), data warehouse (OLAP) and business Intelligence (BI) applications.
• Proficient in all phases of the Software Development Lifecycle (SDLC).
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 9.6/8.2/7.0, Power Designer 15, Embarcadero E - R Studio and Microsoft Visio.
• Well versed in Normalization and De-normalization techniques for optimum performance in relational and dimensional database environments and have performed normalization up to 3NF.
• Experience working with Agile and Waterfall data modeling methodologies.
• Generated DDL Scripts from Physical Data Model by using Forward Engineering technique
• 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.
• Documented the source to target mappings for both data integration as well as web services
• Experienced as both an onsite and offshore project member.
• Experience working with Zachman framework.
• Experience in designing a canonical model.
• 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.
• Experienced with various RDBMS like Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 UDB, Teradata.
• Experienced inTeradata RDBMSusingFast load, Fast Export, Multi load, T pump, and Teradata SQL; Designed WebI /CR reports
• Experience in writing Stored Procedures, Functions, Materialized Views & Triggers; Good at using TOAD, SQL*Plus, SQL Navigator and PL/SQL Developer.
• Experienced in Financial / Finance, Mortgage, Supply-Chain, Material Management and Health Care.
• Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.

TECHNICAL SKILLS

Data Modeling Tools: Erwin 9.5/8.2/7.3/7.0 , Power Designer 15/12/11, Embarcadero ER Studio 6.6, IBM Rational Software Architect 7.1, MS Visio 2000/2007/2010 , ER Studio.

Reporting Tools: SAS, SAS BI, WEB REPORT STUDIO,ENTERPRISE GUIDE, Business Objects, Crystal reports 9, Business Intelligence, SSRS, Qlikview 9/10/11.X series, Tableau, Cognos 8, MicroStratergy, MATLAB, Business Objects XI, Crystal Reports 2008.

ETL Tools: Informatica 8x, 9x, SSIS.

Languages: SQL, SAS CLINICA, SAS BI, VISUAL ANALYTICS, OLAP CUBE, Java 7, .NET 2.0/3.0/4.0 based C# and VB, C,C++, HTML,PHP, JavaScript, JQuery, Python, R.

Databases and Tools: Oracle11g/10g MS SQL Server2005/2008, MS Access, Teradata, DB2, Sybase 12, NoSQL, Aqua Data Studio, SQL Server Management Studio.

Operating Systems: Microsoft Windows10/2000/XP/Vista/7, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, Medford, MA

Sr. Data Modeler / Data Analyst

Responsibilities:

• Working closely with Business Users in gathering the related business requirements.
• Documented the performance of the system by understanding the existing data model.
• Mapping the business requirements and new databases to the Logical data model which defines the project delivery needs.
• Working closely with DBA to deliver the Data Definition Language (DDL)
• Identified the measures and dimensions and organizing these into facts in creating the Dimensional Model within the business requirements.
• Performing Complete Compare on existing Data Model with the production DDL and push the changes to the model.
• Coordinating with Business System Consultants for any changes suggested by the business users.
• Designed Fact tables, Dimension and aggregate tables for Data warehouse.
• Implemented naming standards, and warehouse metadata for fact and dimension of Logical and Physical Data Model.
• Worked on the conversion process of data which is stored in flat files into Oracle tables.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Used Reverse Engineering and Forward Engineering techniques on databases from DDL scripts and created tables and models in data mart, data warehouse and staging.
• Worked on slowly changing dimension tables and hierarchies in dimensions.
• Worked on data mapping process from source system to target system.
• Worked with business analyst in generating weekly reports using Cognos.
• Reverse Engineered Oracle databases and forward engineered them to Teradata using Erwin.
• Analyze and resolve production issues.
• De-normalized the database to put them into the star schema of the data warehouse
• Created documentation and test cases, worked with users for new module enhancements and testing
• Understood existing data model and documented suspected design affecting the performance of the system
• Identify the potential customers from the given data base and counsel the organization on ways of converting them to loyal customers as a part of CRM.
• Team Lead with end-to-end grasp of the entire software development life cycle (SDLC) including analysis, design, development and testing of software applications.
• Exposure to Ab Initio tool to understand the lineage of the tables and databases.

Environment: Erwin 9.5, 7.2, PL/SQL Developer, Teradata, TOAD Data Analyst - 2.1, Oracle 9i,Quality Center- 9.2, Informatica Power center 9.1,Microsoft Access, TD SQL Assistant, Microsoft Visio, MS PowerPoint, MS Access, Microsoft Excel.

Confidential, Milwaukee, WI

Sr. Data Modeler / Data Analyst

Responsibilities:

• Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Rapid Audit of the requirements and existing systems; Requirements & Business Process Analysis.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using tools like ERwin Data Modeler 4.x, ER/Studio 7.x (ER Studio)- Forward/Reverse Engineered Databases.
• Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Compiles and maintains the Enterprise Schema across all applications. Enforces principles of good canonical data design.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Worked with data compliance teams, Data governance team to maintain the data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Participate in biweekly technical huddle meeting with development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Designing Data Flows & System Interfaces - Service Oriented Architecture (SOA) & Web Services.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Design EDW / CDW components.
• Metadata Repository, Data Dictionary; Documentation using Interface Diagrams, Flow Charts.
• Assist developers in Performance Tuning & discussing Design Patterns/high level application design.

Environment: DB2 UDB 8.x, Oracle 11g/ 10g, SQL Server 2005/ 2000, Sybase data server 12.5, UNIX, Toad, Business Objects, Ab Initio, Teradata V2R6, Embarcadero ER/Studio 7.5 (ER Studio), Business Objects, XML, XSD, AIX, Java / J2EE

Confidential -Scottsdale, AZ

Data Modeler / Data Architect

Responsibilities:

• Data Analysis, logical and physical Data Modeling for OLAP systems.
• ER Modeling - Developing Entity Relationship Diagrams (ERD).
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Requirements & Business Process Analysis; Rapid Audit of the requirements and existing systems.
• Deep Understanding of Data Integration using Salesforce SQL
• Design & Implementation of Data Mart and OLAP; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping and data cleansing procedures using Informatica Power Center and SSIS
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Working Knowledge of Data Lake where Vast amount of Data is Stored in its native Format.
• Hands on Experience on Hadoop where data is processed in parallel and localized.
• Involved incapturing data lineage, table and column data definitions, valid values and others necessary information in the enterprise data models.
• ETL Design & Implementation - Data Extraction, Transformation & Loading (using Oracle Warehousing Builder, SQL & PL/SQL).
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Maintained and documented all create and alter SQL statements for all release.
• Designing Data Flows & System Interfaces and Created reports and visualizations.
• Understanding of High Quality Data Management Discipline through the Corporation.
• Data Architecture on Work Flows, Activity Hierarchy & Process Flows; Documenting using Interface Diagrams, Flow Charts & Specification Documents.

Environment: Teradata V2R6, ERWIN 9.2, SQL, Business Objects, Ab Initio, MS Office, MS Access, Oracle 11g.

Confidential, Pleasanton, CA

Data Modeler/Data Analyst

Responsibilities:

• Data Modeler/Analyst in HDH team and responsible for conceptual, Logical and physical modeling.
• Responsible for maintaining all the physical model across all the applications in different environment: (Oracle, Teradata, Db2).
• Studied in - house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Developed a Conceptual model and got it run through business and IT folks.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct
• Design reviews and validate the developed models.
• Maintained warehouse metadata, naming standards for future application development.
• Designed Data models to typically implement Attribution, Members, Group/Subgroup and claims and PI Finance.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Generated DDL's and created the tables and views in the corresponding architectural layers.
• Extensively made use of Compressor, Table Spaces, Indexes, Sequences, Materialized Views, Procedures and Packages in Data Models.
• Developed Source to Target Matrix with ETL transformation logic for ETL team
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Worked On Multiple Key Projects for supporting HDH, IDS and semantic layer.
• Managed the meta-data for the Subject Area models for the Data Warehouse environment. Highly involved in maintaining the Data Dictionaries for all the models across enterprise.
• Worked Extensively with DBA and Reporting team for Improving the Report Performance with the Use of appropriate indexes and Partitioning.
• Worked on Data Modeling Standardization Process across enterprise and created multiple documents related to the Data Modeling. Extensively worked for cleaning up the repository and come up with the cleaner versions of the repository models.
• Primarily responsible for ER Studio tool upgrade to all the higher versions in past 2 years, involved in end to end process to upgrade and handling all the administrative work and facilitating users to all the problems and features to the tools, educating them about repository, Team server and other features and make them use appropriately.
• Maintaining the naming standard files across the enterprise and defining all the new abbreviations as industry standard.
• Highly involved in creating the documents (Mapping Documents, Any New process guidelines, Installation documents etc.)
• Extensively used the SVN and help Developers creating Tags as per the releases in all the layers, DEV, SIT, UAT, PROD and keeping consistency across the environments.

Environment: SQL Server 2008, SQL Server 2012, Teradata 14.0, ERStudio 16.0.3,11, 9.0,9.0.1 Oracle 11, XML, Flat Files, SSIS, SSRS, SSAS, Cognos

Confidential

Data Modeler

Responsibilities:

• Creating & delivering data structures via logical & physical designs for IT Project teams based on a thorough understanding of application requirements, business requirements and database constraints.
• Completely studied the in-house requirements for the data model and data warehouse.
• Involved in identification of Facts, Measures and Dimensions.
• Created conceptual and logical (using IE methodology) data models using Erwin.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin.
• Created dimensional data model based on star schema using Kimball's methodology.
• Supported in building and maintaining Data marts, Fact Tables, Dimension tables.
• Worked on relational data modeling and OLTP application using Erwin Data Modeler.
• Working directly with System Analysts, Application Analysts and Database administrators to ensure data efficiency and integrity.
• Generated Surrogate IDs for the dimensions in the fact table for faster access of data.
• Created database tables using data definition language scripts.
• Capture and document detailed data requirements for the strategic Initiatives and Projects.
• Involved in analysis, design and development and testing phases of the application development using Scrum Agile methodology.
• Facilitating the model walk thru sessions for the business and application users.
• Involved in creating, modifying and updating database tables in Oracle Server.
• Participated in daily scrum meetings to discuss about the work done the before day, current days' work and to let the team mates know if there are any road blocks.

Environment: SQL Server 2008, All Fusion Erwin 7, Visual Studio 2008, PL/SQL, .csv Files, MS Query.