SUMMARY

• 8 Years of experience in Data Modeling, Data Designing and Data Analysis.
• Experience in Logical/Physical Data Modeling, Relational for Online Transaction Processing (OLTP) and OLAP.
• Proficiency in Data Modeling tools like Erwin, ER Studio and Power Designer, developing and Modeling Entity Relationship diagrams, Transactional and Data Warehouse Databases.
• Generated DDL Scripts from Physical Data Model by using Forward Engineering technique.
• Proficiency in Normalization to 3NF and De - normalization techniques for optimum performance of database environments like OLTP and OLAP systems.
• Experience in developing transactional Enterprise Data Models which meet the normalization rules strictly and understanding of enterprise data warehouses by using Ralph Kimball Data warehouse methodologies.
• Involved in implementing the Referential Integrity by using Primary and Foreign key relationships.
• Practical understanding and hands on experience of the Data modelling (Dimensional & Relational) concepts like Star-Schema, Snowflake Schema, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Experience in performing Reverse Engineering from existing Systems and developing Logical/Physical Data models from ERwin and ER studio.
• Developed gap documents on the Gap Analysis performed on the existing systems.
• Experience in developing database schemas like Star Schema and Snowflake Schema for Dimensional Modeling and identifying Facts and Dimensions.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.
• Proven knowledge in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Proficient in Data Cleansing and Data Profiling based on standards.
• Experience working in Agile and Waterfall Data Modeling Methodologies.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good interpersonal and human relation skills to interact with clients and co-workers

TECHNICAL SKILLS

Databases: MS SQL Server 20014/12/08/, Oracle11g/10g/9i/8i, DB2 V9.5, MS Access 2000

Programming Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX shell Scripting, VBScript, PERL, AWK

Tools: MS-Office suite (Word, Excel, MS Project and Outlook)

Operating Systems: Windows 10/8/7/XP, UNIX (Sun Solaris 10), LINUX

ETL Tools: Informatica Power Center 8.6.1/8.1/7.1 , Data Stage 7.5, Ab Initio, SSIS,SSRS

Data Modelling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Tools: & Software’s: MS Office, BTEQ, Teradata SQL Assistant

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos Power play

Analysis and Modeling Tools: ERwin 4.1/7.2/7.0/8.0/9.1/9.6 , Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr.Data Modeler

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Gathered requirements document and analysed the process.
• Translate business requirements into conceptual, logical data models and physical data models.
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using Erwin.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in Erwin to identify GAPs and worked with the naming standards utility.
• Analysed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
• Extensively used Normalization techniques (up to 3NF).
• Responsible for data modeling and building a star schema model in Erwin.
• Participated in the tasks of data migration from legacy to new database system.
• Good knowledge of SQL and querying of DB2 database.
• Created Data Definitions and help maintain Metadata repository.
• Developed and maintained data dictionary to create Metadata reports for technical and business purpose in MDR.
• Involved in dimensional modeling, identifying the Facts and Dimensions and different hierarchies.
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Worked with the ETL team to document the transformation rules for data migration from source to target systems.
• Developed source to target mapping documents to support ETL design.
• Resolved the data type inconsistencies between the source systems and the target system using the Source-to-Target Mapping Documents.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Defined the data definitions, and create the target tables in the database.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• Provided data modeling support for numerous strategic application development projects.
• Developed mapping document to facilitate the ETL to understand the process and in corporate the changes.
• Created an enterprise data dictionary and maintained standards documentation.

Environment: Erwin 9.5, DB2 Erwin, ER Studio, SQL, PL/SQL, Oracle, SQL Server 2014, MS Visio, MS Excel, Windows 10/8.1, Unix.

Confidential, El Segundo,CA

Sr.Data Modeler/Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Created logical data model from the conceptual model and it’s conversion into the physical database design using Erwin.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Involved with data analysis using Teradata SQL assist from data source.
• Reviewed models with DBA have to best fit physical Model Indexes for better DB performance.
• Reviewed and identified unused tables/columns as part of data analysis.
• Developed the data warehouse dimensional models & schema for the proposed central model for the project.
• Developed many subject models from scrap.
• Created Logical/Physical Data models in 3NF in the Warehouse area of Enterprise Data Warehouse.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Worked on the Snow-flaking the Dimensions to remove redundancy whenever required.
• In order of better understanding the requirement documents, carried out couple of JAD sessions with Management, SME (Subject Matter Expertise), vendors, users and other stakeholders.
• Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Maintained the integrity of data and data quality.
• Conducted data profiling for better understanding of joins in ER models
• Involved in high level ETL design review sessions and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Worked with project release meeting manager for UAT tables going to production.
• Handled metadata publish tasks to our internal data dictionary from internal DB MS Access
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
• Assisted Reporting developers in building Reports using Crystal Reports.

Environment: Erwin9x/8x,Informatica, Teradata SQL Assistant, SQL Server Management Studio 2012/08, Informatica,Unix, MS Visio, MS Office 2013, Windows 8/7.

Confidential, Philadelphia, PA

Data Modeler

Responsibilities:

• Involved in requirement gathering along with the Project manager and Users.
• Gathered all the customer services report prototypes from the Project manager including the dispatch and employee vehicle information.
• Participated in JAD sessions
• Conducted Design discussions and meetings to come out with the appropriate Data Mart
• Understood existing OLTP data model and developed the OLAP data marts in a satisfactory way of the user requirements affecting the performance of the system
• Designed the data marts (logical and physical data models) by identifying facts and dimensions from the requirements using Erwin tool especially the Star schemas.
• Prepared the metadata documentation (in Microsoft Excel) for these data marts.
• Conducted Design reviews with the business analysts, content developers.
• Created tables in database using DDL scripts, provided grants on the table based on the user requests and performed analysing the tables periodically.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Oracle warehouse Builder tool is used for the ETL process and worked on oracle aggregations.
• Extracted the required data from the source database (Flat Files/MS Access/Oracle/SQL server) and transformed it with the required transformations and then loaded the transformed data into the target database.
• Developed Packages, Procedures and functions in PL/SQL, wrote triggers for implementing data integrity
• Scheduled the daily transactions using UNIX shell scripting and tested the data for frontend VB 6.0.
• Extracted data from the databases (Oracle and SQL Server) using Informatica to load it into a single data
• Created data mapping documents from source to target systems.
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
• Created logical and physical design of the centralized Relational Data base
• Normalization to 3NF/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Provided Database Normalization upto 3NF for the database schemas.
• Updated the database as a daily transactional in order to meet user requirements.

Environment: Erwin 8x,Oracle 11g/10g,Informatica, SQL Server Management Studio 2008/12, Oracle 10g, MS Access, MS Office 2010, Windows 7.

Confidential, Hartford, CT

Data Modeler

Responsibilities:

• Interacted with the business users on regular basis to consolidate and analyse the requirements.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis, Involved in multiple projects with different business units. .
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
• Had a strong working experience in Extract/Transform/Load (ETL) design and implementation in areas related to Teradata utilities such as Fast Export and MLOAD for handling numerous tasks?
• Developed in Star and Snow flake schema dimensional data models.
• Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables
• Extracted data from databases Oracle, SQL server and DB2 using Informatics to load it into a single repository for Data analysis.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models
• Compare data with original source documents and validate Data accuracy.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Worked on ER STUDIO to create data models.
• Used SQL Server Reporting Services (SSRS) to create reports.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Experienced in development of ETL mapping and scripts.
• Worked on multiple Data Marts in Enterprise Data Warehouse Project (EDW)
• Involved in designing OLAP data models extensively used slowly changing dimensions (SCD).
• Involved in Generating ad-hoc reports using crystal reports 9.

Environment: Erwin 7x,ER Studio, SQL, Unix, Informatica, Oracle 11g, SQL Server 2008, Crystal Reports, Windows 7, MS Office, Business Objects.

Confidential, St. Louis, MO

Data Modeler

Responsibilities:

• Performed 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.
• 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 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.
• Rapid Audit of the requirements and existing systems; Requirements & Business Process Analysis.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using ERwin Data Modeler/7.x, Forward/Reverse Engineered Databases.
• Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Convert models from CA ERwin to ER/Studio 7.5 (ERStudio); developed numerous macros.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Compiles and maintains the Enterprise Schema across all applications. Enforces principles of good canonical data design.
• 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: Erwin 7x/ ER Studio 7.5, Oracle 11g/ 10g, Toad, Informatica, Ab Initio, Business Objects, MS Access, MS Office 2010.

Confidential

Data Modeler/Analyst

Responsibilities:

• Identified entities and attributes and built conceptual, logical and physical models using Erwin.
• Data Modeler performing business area analysis and logical and physical data modeling using Erwin for data warehouse/data mart applications as well as operational applications enhancements and new development. Data warehouse/data marts design was implemented using Ralph Kimball methodology.
• Reverse engineered the reports and identified the data elements, dimensions, facts and measures required for new enhancements of the reports.
• Design discussions and meetings to come out with the appropriate data mart at the lowest level of grain for each of the dimensions involved.
• Worked on data profiling, data quality, assessing the risk involved in integrating data for new applications.
• Involved in discussions with team which deals with six sigma to understand the customer need data and data analysis.
• Assess whether metadata accurately describes the actual values in the source database.
• Worked on data governance for improving data quality.
• Designed a star schema for the detailed data marts and plan data marts involving confirmed dimensions
• Created and maintained the data model repository as per company standards.
• Creating and ensuring the feasibility of the logical and physical design models using Erwin.
• Generated ready to implement DDL for oracle DBMS implementation by the DBA group.
• Created reports using SQL Server reporting services (SSRS), business objectsand crystal reports.
• Interacted with DBA for improving performance of queries.
• Involved in indexing, partitioning of the database.
• Worked extensively on oracle analytical functions like ROW NUMBER, LEAD, LAG, RANK, DENSE RANK
• Understanding of the Teradata SQL assistant and used SAS/Interface to Teradata to extract data from Teradata.
• Populated SharePoint site with Metadata for Various Data Structures, tables, Columns and their Constraints using Structured Query Language.
• Generated ad-hoc queries using SQL joins, etc.
• Worked on PL/SQL collections, index by table, arrays, bulk collect, FOR ALL, etc.
• Performed updates and enhancements to the already existing data models as required by using ERWIN/CA
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.

Environment: Erwin, ER Studio, SQL, Unix,Oracle 10g, Toad, Windows OS, DB2,SQL, Informatica.

Data Analyst

Responsibilities:

• Responsible for accuracy of the data collected and stored in the corporate support system.
• Performed data review, evaluate, design, implement and maintain company database.
• Involved in construction of data flow diagrams and documentation of the processes.
• Interacted with end users for requirements study and analysis by JAD (Joint Application Development).
• Performed gap analysis between the present data warehouse to the future data warehouse being developed and identified data gaps and data quality issues and suggested potential solutions.
• Participated in system and use case modeling like activity and use case diagrams.
• Analyzed user requirements and worked with the data modelers to identify entities and relationship for data modeling.
• Actively participated in the design of data model like conceptual, logical models using Erwin.

Environment: Erwin 7x, Oracle 9i, MS Access, MS Office 03,Windows XP, Oracle, SQL, Unix.