Summary:

• Over Seven years of diverse experience and demonstrated success in IT industry with specialization in Data Modeling, Data Analysis and Database Design.
• Well implementation knowledge of various SDLC Software Development Life Cycle methodologies.
• Organized High Level Design HLD meetings and Detailed Design Definition DDD meetings with the Business Analysts to understand the data elements required for the project.
• Experience in Analysis and E-R modeling and Data Mart design using dimensional data modeling identifying Facts and Dimensions, Star Schema and Snowflake Schema and ODS architecture for modeling a Data Warehouse used in relational, dimensional and multidimensional modeling.
• Well versed with Normalization /De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Good experience in designing and implementing OLTP and OLAP data models.
• Experience in Data Transformation and Data Mapping from source to target database schemas and also data cleansing.
• Excellent command over Logical and Physical entity relationship data modeling using Erwin.
• Exposure to Master Data Management concepts and importance.
• Extensive experience in working with tools like Erwin, Oracle Designer, ER/Studio, Power Designer and MS Visio for creating data models.
• Well versed in data modeling tool concepts like forward and reverse engineering, model manager, complete compare and report generation.
• Exposure to data mining and also data like Clinical, Biological, Pharmaceutical and Bureau etc
• Very familiar with staging, creating data cube using ROLAP and MOLAP.
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, SQL Server and DB2 databases.
• Expertise in extracting, transforming and loading ETL data from flat files, spreadsheets, database tables and other sources using Informatica.
• Experience in building reports using Crystal Reports and Cognos.
• Extensive experience in development of T-SQL, DML, DDL, DTS, Stored Procedures, Triggers, Sequences, Functions and Packages.
• Experience in performance tuning and optimization of the database for business logic implementation.
• Facilitated and participated in Joint Application Development JAD sessions for requirements gathering and analysis.
• Quick learner and Quick starter with ability to master and apply new concepts and a highly motivated team player.
• Excellent communication, interpersonal, intuitive, analysis and leadership skills.

Technical Skills:

• Languages : SQL, PL/SQL, PASCAL, COBOL, C, C , Visual Basic, .NET,
• HTML, CSS, Oracle 11g/10g/9i, TeraData
• Operating Systems : Windows 95/98/NT/2000/XP/7, UNIX, MS-DOS
• Modeling Tools : Erwin r7.3, Power Designer, ER/Studio, Microsoft Visio
• Reporting Tools : Crystal Reports, OBIEE 10.3.4.1, Microsoft Reporting Services, Cognos
• ETL Tools : Informatica 8.1/9.1
• Other Tool : MS Office Word, Excel, PowerPoint , MS Project 2003

Professional Work Experience

Confidential

Role: Data Architect Data Modeler/ Analyst

Responsibilities:

• Participated in the requirement gathering sessions to understand the expectations and worked with system analysts to understand the format and patterns of the upstream source data.
• Developed multiple logical models per the requirements and validate it's alignment with the enterprise logical data model ELDM .
• Participated and conducted many design sessions with the ELDM team if there are any potential violations with respect to the ELDM data model and come out with a solution to resolve it.
• Validated the entity/attribute names as per Fannie Mae's data model naming standards and check for appropriate primary qualifier and class word in the names.
• Developed many physical models from the logical model using Fannie Mae's standard abbreviation wizard and implement indexes, partitions and apply normalization and denormalization techniques per requirements.
• Tag data model attributes with Core, Critical and NPI attachments which helps Security Architecture team identify and restrict NPI Data.
• Implemented naming standards when creating indexes, partitions, primary keys and relationships.
• Created reference values, lookup tables, history and staging tables per requests from development teams and worked with them in developing the mappings.
• Created data model PDFs, data dictionaries for logical and physical models as per code drops and post to SharePoint project site
• Participated in bi-weekly status calls to update the team on development status, work closely with system and business analysts to finalize the model and review the final model with the whole team for both educational and approval purposes.
• Worked extensively on legacy models that were reverse engineered from database to implement object naming standards in the logical model and completing definitions by working with respective application teams.
• Assisted other teams in integrating multiple data models when the respective systems were migrated from multiple databases into a single oracle schema.
• Created DDL Scripts using ER/Studio for the ODS and Mart model and executed them in respective DEV environments so as to make sure the ETL can start the build/code drop development.

Environment: Windows XP, PL/SQL Developer 8.0.4, Oracle 11i, 12c, ER/Studio Data Architect 8.5 9.1.3, Microsoft SQL Server 2008 R2, Informatica 9.1.

Confidential

Role: DW Data Modeler Data Modeler/ Analyst

Responsibilities:

• Involved in meetings with business users and business analysts to define and document the reporting requirements for various projects and validate the user stories and story cards created based on reporting requirements.
• Identify the source systems and tables which contain the data required for reporting. Examples of sources systems are Oracle Financial Apps, PeopleSoft and Salesforce.
• Reverse Engineer using ER Studio to understand source systems' structure and report the anomalies in data structure to source system data owner.
• Profile and analyze the source data using Informatica Analyst and Informatica Data
• Quality tools to do upfront analysis of source system and to measure the effort required to clean, conform and transform the data and whether the project can be delivered within the timeline given the quality of data in source system.
• Involved with the architect team to develop the architecture which can address the current reporting requirements as well as being able to scale to future reporting needs.
• In the data staging area referred as IDR in Apollo , we further normalize source system data using normalization techniques. The data staging area is in 3rd Normal Form.
• In data staging area, data is cleaned, conformed and transformed to be available for integration in Data Mart using ETL tool Informatica.
• Designed Data Marts using Dimensional modeling technique star schema snowflake schema to integrate the data from various sources and to enable management to make more fact based decisions.
• Designed Data Marts using Conformed Dimension and Kimball Enterprise Bus Matrix to ensure drill across various Data Marts and avoid stovepipe Data Mart.
• Involved in meetings with Infrastructure team to install Golden Gate on source system for CDC Change Data Capture which would capture all Insert, Update and Deletes.
• Involved in meetings with ETL team to decide best possible strategies to load the data from Source System to Data Staging area to Data Mart using initial load as well as incremental load.
• Review Data Staging Model Relational Model and Data Mart Model Dimensional Model with ETL and Business Reporting Microstrategy Team to confirm that the model satisfies the reporting needs.
• Involved in meetings with Data Governance team to ensure proper exercise of authority and control over the management of data assets. As part of data Governance team, we dealt with various areas of enterprise data management such as Data quality, Metadata Management, Data Security SOX .
• Design and develop the Data Dictionary, Business Glossary to ensure the consistency of Business term across organization and Meta data of the models and maintain them.
• Created DDL Scripts using ER/Studio for the IDR and Mart model and executed them in respective DEV environments so as to make sure the ETL can start the build.
• Analyze and anticipate data warehouse performance issues and address performance issues through various techniques such as indexing, partitioning and subpartitioning.
• Ensure Data Warehouse security by restricting access at object level and row level in Microstrategy.
• Constant effort to see how dimensional modeling and architecture can be improved to enhance the performance and better address business problems.

Environment: Windows 7, PL/SQL Developer 8.0.4, Oracle 11i, ER/Studio Data Architect 8.5 9.1.3, Microsoft SQL Server 2008 R2, Informatica 9.1.

Confidential

Role: Software Application Developer Data Modeler/Analyst

Responsibilities:

• Involved in several meetings with Business Analysts to gather data requirements from business and technical users for a data warehouse environment.
• Responsible for translating the business requirements into Conceptual/Logical/Physical Models for various work streams.
• Responsible for database design, integration and Data Modeling for various work streams.
• Involved in Design, Development and Standardization of Databases/Data warehouse for various work streams.
• Performed Source-to-Target Data Mapping and Created Data Flow Diagrams to depict the source-to-Target Mapping.
• Responsible for creating Source to Target data mapping documentation for various work streams.
• Gathered Source data information to design and build source staging tables.
• Responsible for Performing Requirement Analysis and Data Analysis for various work streams.
• Created Logical and Physical Models for Commissions data in the Enterprise Operational Data Store and then designed a Commission data mart in Data Ware House based on the Reporting Requirements.
• Creating various forms of documentation like Data Design Documents/Conceptual Design Documents/DDL for various work streams.
• Responsible for maintaining and updating Data Mapping and Design documents and documenting the end-to-end process and the direct linkage of the processes to systems configuration.
• Utilized Erwin extensively to create Logical/Physical models and also the Forward/Reverse engineer techniques.
• Utilized several PL/SQL queries to load and analyze the data.

Environment: Windows XP, Erwin r7.3, SQL Server 2005, DB2, Toad for DB2.

Confidential

Role: Software Application Developer Data Modeler

Responsibilities:

• Worked with the Business analyst and DBA for requirements gathering, business analysis and project coordination.
• Gathered and translated business requirements into detailed, technical specifications, new features, and enhancements to existing technical business functionality.
• Responsible for designing an active warehouse model as required for the Business.
• Responsible for Identifying and grouping the attributes to the respective entities.
• Organized and participated in several meetings with DBA's, Business Analyst and ETL developers to come up with a best fit model.
• Responsible in translating the business requirements into logical data requirements and designing the logical model.
• Involved in designing and validating the Physical model maintaining the Physical naming standards.
• Maintained well organized support documentation for the warehouse model so that developers can easily have access to the database.
• Worked closely with DBA in the deployment of the database.
• Followed both Normalization and Denormalization techniques to design Bureau and Warehouse models.
• Utilized several PL/SQL queries to load and analyze the data.

Environment: Windows XP, Erwin r7.3,PL/SQL Developer 7.0.2, SQL Server 2008, Oracle 10g.

Confidential

Role: App Development Sr Specialist Data Modeler

Responsibilities:

• Analyzed, compared and recommended blue print for consolidating the various Data warehouses, Data Marts, Operational Data Stores and associated front-end technologies.
• Responsible for all activities related to the logical architecture of data and metadata.
• Identified several attributes and the relationships between the tables. And defined the data types and definitions for the fields to best explain its usage in the business.
• Organized and participated in several meetings with Business Analyst, SME's and ETL developers to come up with best fit model.
• Translated business requirements into logical data requirements and developed Logical and Physical data models.
• Studied the business logic, understood and identified the key fields to come up with a design for Data marts.
• Contribute to the metadata management strategy.
• Performed business analysis and technical data modeling services.
• Research and documented data quality issues and potential resolutions.
• Created and maintained documentation of data models, including relationships, constraints, metadata, data dictionary, and ETL mappings.
• Involved in meetings for the walk through and validation of the model.
• Maintained a naming standard file in the physical design so developers can follow it.
• Dealt and solved data modeling issues with ease.
• Worked closely with the project sponsor, project manager and business SMEs throughout the course of the project.
• Performed and utilized necessary PL/SQL queries to analyze and validate the data.

Environment: Windows XP, Oracle 11g, Erwin r4.3, Toad, SQL Server 2005, Cognos 8.0.

Confidential

Role: Data Modeler/Analyst

Responsibilities:

• Responsible for logical and physical data modeling, database design, star schema, snow flake schema design, data analysis, documentation, implementation and support.
• Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Erwin.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for sales data mart.
• Striking a balance between scope of the project and user requirements by ensuring that it covered minimum user requirements without making it too complex to handle.
• Requirement gathering from the users. A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Requirement analysis was done to determine how the proposed enhancements would affect the current system.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to incorporate the new calculations.
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Involved in logical and physical designs and transform logical models into physical implementations.
• Utilized Erwin's reverse engineering and target database schema conversion process.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted table/columns as part of data analysis responsibility.
• Involved in different team review meetings.
• Excellent Experience with data modeling tools like Erwin and developing both OLTP and Data Warehousing data models.
• Designed Informatica mappings, enabling the extract, transport and loading of the data into a single data warehouse repository Teradata .
• Utilized necessary PL/SQL scripting to perform various tasks such as validating and analyzing product data, to ensure no data anomalies pertaining to validity, content, format, presentation, etc. existed.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Has excellent problem solving skills, proven teamwork, and communication skills.

Environment: Windows XP, SQL, SQL Server 2005, Oracle 10g, DB2, Erwin r7.3, ER Studio, Informatica 8.0.

Confidential

Role: Data Analyst

Responsibilities:

• Responsibilities included gathering and preparation of requirements, functional specifications, technical specifications and the design of the database.
• Designed, implemented, tested and maintained a data warehouse front end system Insight to capture the Sales and Marketing.
• Defined Conceptual Data model and derived Logical and Physical data model from it.
• Data modeling E-R modeling and physical Data modeling using Erwin.
• Data dictionary development for technical and non-technical audiences.
• Optimization of existing Data models.
• Work with the architect team to arrive with the optimal design of the Database to meet user requirements.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.
• Work with the DBA and Business analysts to determine the approx. size of the Database using database design tool.
• Developing data mapping and data requirements documents.
• Documentation of Data validation Findings.
• Create and maintain CMM standards Documentation using MS Office.
• Work with Data Modelers of other projects to plan sharing of data across applications.
• Developing customized reports using SQL PL/SQL coding.

Environment: SQL server 2000, MS Office, Erwin 3.5, Windows 2000/NT, Oracle 8i