SUMMARY

• Around 8 + years of experience indatamodeling, business anddataanalysis, production support, database management, strategic analysis, requirements gathering, data modeling, data mapping, data profiling.
• 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.
• Proficient indatamart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Well versed in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience in developing Entity-Relationship diagrams and modeling Transactional Databases and DataWarehouse using tools like ERWIN, ER/Studio and Power Designer.
• Solid experience with data governance, data steward, data quality concepts and implementations.
• Hands on experience with modeling using ERWIN in both forward and reverse engineering cases
• Experienced with both DDL and DML including Joins, Functions, Indexes, Views, Constraints, Primary Keys and Foreign Keys.
• Good inDatawarehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.
• Expertise in working with business users as part of requirements gathering and converting them into technical solution.
• Deployed naming standard to theDataModel and followed company standard for Project Documentation.
• Expertise in Normalization techniques fordataconsistency and Flexible Database design.
• Expertise database normalization method defined by E.F CODD (3NF-Third Normal Form).
• Experienced in writingdataquality rules to ensure quality, consistency and accuracy ofdata.
• Expertise indatadesign and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relationaldatamodeling.
• Designed the PL/SQL procedures for getting thedatafrom all systems toDataWarehousing system. Thedatawas standardized to store various Business Units in tables.
• Experience inDatatransformation andDatamapping from source to target database schemas and alsodatacleansing.
• Excellent understanding and exposure to SQL queries and PL/SQL stored procedures, triggers, functions and packages.
• Extensive knowledge of writing SQL queries, working with back end tools such as Toad fordata validation and verification.
• Strong experience in Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using Erwin tool.
• Experienced in writingDataTransformation andDataCleansing rules forDataMapping documents inDataWarehouse projects.
• Good understanding of Teradata SQL Assistant, Teradata Administrator anddataload/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME's to obtain domain level information of projects.
• Worked in many Software Development Life Cycle (SDLC) implementations, performing process planning, documentation, functional and system design, implementation, unit testing, integration testing, and regression testing and system maintenance.

TECHNICAL SKILLS

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

Languages: C, Java, HTML, SQL, PL/SQL, XML

Databases: Oracle, SQL Server, Teradata, Sybase, Netezza, DB2

Modeling Tools: ERWIN r 9.1, EmbarcaderoER/Studio, MSVisio, Sybase Power Designer.

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x / 6.x, Tableau, Tibco Spotfire

ETL Tools: Informatica Power Center 9x/8x, Talend, Pentaho, SSIS.

Others: MS Office, TOAD, BTEQ, Fast Load, Multi Load, Fast Export

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Sr. Data Modeler/Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Created logicaldatamodel 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.
• Worked with DBA's to create a best fit physicaldatamodel from the logicaldatamodel
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part ofdataanalysis responsibilities.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Developed thedatawarehouse model (star schema) for the proposed central model for the project.
• Created Logical/PhysicalDatamodels in 3NF in the Warehouse area of EnterpriseDataWarehouse.
• Created 3NF business areadatamodeling with de-normalized physical implementationdataand information requirements analysis using ERWIN tool.
• Part of team conducting logicaldataanalysis anddatamodeling JAD sessions, communicated data-related standards.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Worked on Metadata exchange among various proprietary systems using XML.
• Experience working on creating models for Teradata masterdatamanagement.
• Worked with Architecture team to get the metadata approved for the newdataelements that are added for this project.
• Responsible for creating the staging tables and source to target mapping documents for the ETL process.
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetchdatafrom legacy Oracle and SQL Server database systems
• Used ERWIN for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved inDataMapping.
• Responsible for development and testing of conversion programs for importingdatafrom text files into map Oracle database utilizing PERL shell scripts & SQL*Loader.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Windows 7, Teradata 14, ERWIN r9.1, SQL server 2005/2008, Business Objects XI, MS Excel 2010, Informatica, SQL, Oracle, TOAD forDataAnalysis, Teradata SQL Assistant 13.0.

Confidential, Charlotte, NC

Sr. Data Modeler/Analyst

Responsibilities:

• Requirement gathering and Business Analysis.
• Extensively analyzed Ralph-Kimball Methodology and implemented it successfully.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Created logical & physicaldatamodels and MetaDatato support the requirements
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin.
• Preparation ofDataDictionary/MetaDataof thedataelements.
• Walked through the LogicalDataModels of all source systems fordataquality analysis
• Developed Logical and Physicaldatamodels that capture current state/future statedataelements and dataflows using Erwin / Star Schema.
• Responsible for removing Insertion, update and deletion anomalies by converting the table to Third Normal From.
• Worked on enterprise logicaldatamodeling project (in third normal form) to gatherdatarequirements for OLTP enhancements. Converted third normal form ERDs into dimensional ERDs fordatawarehouse effort.
• Involved in mapping spreadsheets that will provide theDataWarehouse Development (ETL) team with source to targetdatamapping, inclusive of logical names, physical names,datatypes, domain definitions, and corporate meta-datadefinitions.
• Converted physical database models from logical models, to build/generate DDL scripts.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Maintained MetaDataRepository for storing table definitions, table spaces and entity definitions.
• Tuning the Informatica Mappings for optimum performance and scheduling ETL Sessions.
• Created various geographical and time dimension reports of Fiscal year, Quarterly, Monthly, weekly, Daily reports for all Domains and published through Web Intelligence.
• Deployed naming standard to theDataModel and followed company standard for Project Documentation.

Environment: Erwin, Informatica Power Center(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), SQL Server 2000(Query Analyzer, DTS, TSQL), Oracle, PL/SQL, SQL* Loader, TOAD, Business Objects

Confidential, Louisville, KY

Sr. Data Modeler/Analyst

Responsibilities:

• Performeddataanalysis and profiling of sourcedatato better understand the sources.
• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using Erwin.
• Worked with DBA's to create a best-fit PhysicalDataModel from the logicaldatamodel.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
• Interacted with the database administrators and business analysts for data type and class words.
• Conducted design sessions with business analysts and ETL developers to come up with a design that satisfies the organization's requirements.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created ER Diagrams,DataFlow Diagrams, grouped and created the tables, validated thedata, identified PK/ FK for lookup tables.
• Created 3NF business areadatamodeling with de-normalized physical implementationdataand information requirements analysis using Erwin tool.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Ensured the quality, consistency, and accuracy ofdatain a timely, effective and reliable manner.
• Involved in ETL mapping documents indatawarehouse projects.
• Created high level ETL design document.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Assisted the ETL team to document the transformation rules fordatamigration from OLTP to Warehouse environment for reporting purposes.
• Involved in extensivedataanalysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
• Assisted the ETL team to document the transformation rules fordatamigration from OLTP to Warehouse environment for reporting purposes.
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning.
• Conducted several PhysicalDataModel training sessions with the ETL Developers. Worked with them on day-to-day basis to resolve any questions on Physical Model.

Environment: Oracle 11g, Erwin, Windows XP, MS Excel, Business Objects XI, SSIS, MS Access, Teradata,Excel, Informatica.

Confidential, Lincolnshire, IL

Sr. Data Modeler/Analyst

Responsibilities:

• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Created data masking mappings to mask the sensitive data between production and test environment.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Created Webi reorts and modified existing Universes in SAP Business Objects
• Worked with Metrics reporting, data mining and trends in helpdesk environment using SAP Business Objects
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Developed statistics and visual analysis for warranty data using MS Excel, MS Access and Tableau Software.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Identify & record defects with required information for issue to be reproduced by development team.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate with offshore team.

Environment: - Oracle 10g, MS office, Business Objects, Clear Quest, Clear Case, Teradata R13

Confidential

Data Modeler/Analyst

Responsibilities:

• 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 PhysicalDataModel from the logicaldatamodel.
• Used forward engineering to generate DDL from the PhysicalDataModel and handed it to the DBA.
• Developed dimensional model forDataWarehouse/OLAP applications by identifying required facts and dimensions.
• Designed STAR schema for the detaileddatamarts and plandatamarts consisting of confirmed dimensions.
• Used ETL methodology fordataextraction, transformations and loading in a complex EnterpriseDataWarehouse (EDW).
• Identified and documenteddatasources and transformation rules required to populate and maintain datawarehouse content.
• Involved in extracting, cleansing, transforming, integrating, and loadingdatainto differentDataMarts usingDataStage Designer.
• Developed SQL Queries to fetch complexdatafrom different tables in remote databases using joins, database links and bulk collects.
• Used Erwin's reverse engineering to connect to existing database and ODS to graphically represent the Entity Relationships.
• Maintained metadata according to warehouse standards.
• Implemented Reverse Engineering technique to transferdatafrom database to ERWIN. Also cleaned unwanted tables/columns and redefined attributes and relationships.
• Involved in Performance tuning by leveraging oracle explain utility and SQL tuning.
• Involved in Performance Tuning of the database which included creating indexes, optimizing SQL statements & monitoring the server.

Environment: Oracle, SQL Server 2005/2008, DB2, Erwin, Teradata, Crystal Reports, Informatica, MS-SQL server manager, MS Excel, MS Visio, Rational Rose, Requisite Pro