SUMMARY

• Over 8 years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering anddatamodeling including design and support of various applications in OLTP,Data Warehousing, OLAP and ETL Environment.
• Excellence in delivering Quality Conceptual, Logical and PhysicalDataModels for Multiple projects involving various Enterprise New and Existing Applications andDataWarehouse.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional anddatawarehouse environments.
• Proficient indatamart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• Expertise in developing transactional enterprisedatamodels that strictly meet normalization rules, as well as EnterpriseDataWarehouses using Kimball and InmonDataWarehouse methodologies.
• Extensively experienced in using ER modeling tools such as ERwin and ER/Studio.
• Excellent experience writing advanced SQL queries for data profiling / Data Analysis on databases such as Teradata, DB2, Oracle and Netezza
• Experienced in logical/physical database design and review sessions to determine and describedataflow anddatamapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Used Oracle administration on 10g, 9i versions. Backup and Recovery strategies using RMAN, Cold\Hot backups, Replication and otherdatamigration strategies.
• Excellent knowledge with Talend MDM, Informatica MDM for creating matching and merge rules for MDM hub.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good experienced indatatransformation,datamapping from source to target database schemas and alsodatacleansing.
• Used Teradata Fast Load utility to load large volumes ofdatainto empty Teradata tables in the Data mart for the Initial load.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Experienced in using Excel and MS Access to dump thedataand analyze based on business needs.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

DataModeling Tools: Erwin 9.x/8.x/7.x, ER Studio and Oracle Designer, Sybase Power Designer, Oracle Designer, Rational Rose

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9

ETL Tools: Talend, Pentaho & Informatica 8.x/9.x.

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, VB.NET

Database Tools: Microsoft SQL Server, Teradata, Oracle 10g/9i, Netezza, DB2

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Share point Portal Server

Operating Systems: Microsoft Windows 9x / NT / 2000/XP / Vista/7 and UNIX.

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C++, AWK

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Data Analyst /Modeler

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization
• Did extensive analysis ondata, profiled it before moving forward with building marts
• Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
• Created and maintained Metadata, including table, column definitions
• Generated a separate MRM document with each assignment and shared it on SharePoint along with the PDF of updateddatamodels
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• 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
• Developed mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and the expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Developed the logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Facilitated JAR/JAD sessions to determinedatadefinitions and business rules governing thedata, and facilitated review sessions with subject matter experts (SMEs) on the logical and physicaldata models.
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata.
• Useddataprofiling tools and techniques to ensuredataquality fordatarequirements.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Worked on analyzing and writing business mappings using Informatica mapping rules.
• Used Star Schema and Snow flake schema methodologies in building and designing the logicaldata model in the dimensional Models.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
• Transformed requirements intodatastructures which can be used efficiently to store manipulate and retrieve information.

Environment: Oracle 11g, Teradata 13.10, Microsoft 2008, SQL Developer, SQL Manager, ER Studio, SQL Developer DataModeler, OracleDataIntegrator(ODI), SAP Business Objects, Informatica, Crystal Reports, ER Studio 9.1.0, Erwin, Informatica.

Confidential, Chicago, IL

Sr. Analyst /Data Modeler

Responsibilities:

• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in thedatamodel.
• Involved withDataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData, Data Definitions andDataFormats.
• Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign Key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index Considerations.
• Implemented Data Archiving strategies to handle the problems with large volumes of data by moving inactive data to another storage location that can be accessed easily.
• Worked closely hand in hand with the Business Analytics manager, who was also a part of the design/data modeling team.
• Implemented performance tuning of SQL queries and Micro Strategy reports.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Wrote ad-hoc SQL queries and worked with SQL and Netezza databases
• Developed Star and Snowflake schemas based dimensional model to develop thedatawarehouse.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin
• Wrote and executed SQL queries to verify thatdatahas been moved from transactional system to DSS,Datawarehouse,datamart reporting system in accordance with requirements.
• Created the test environment for Staging area, loading the Staging area withdatafrom multiple sources.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for the MasterData Management Architecture involving OLTP, ODS.

Environment: Erwin R8.2.5, Oracle 10g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, Crystal Reports 9, Teradata, SQL 2008, SQL Server

Confidential, Phoenix, AZ

Sr. Analyst / Modeler

Responsibilities:

• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and PhysicaldataModels.
• Created a high-level and generalizeddatamodel to convert it into logical and physical model at later stages of the project using Erwin.
• Involved with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin tool.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for the MasterData Management Architecture involving OLTP, ODS.
• Exploreddatato identify its model role and measurement level. Verifieddatafor missing values and incorrectdata. And then cleaned and structured thedatabased on the format required.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables
• Used Star schema methodology in building and designing the logicaldatamodel in the dimensional Models.

Environment: Erwin, Rational Requisite Pro,DataStage, DB2 UDB, SQL Server, Sybase, Windows NT, Linux, Sun Solaris, T-SQL, ER Studio, SQL, SQL Server 2000/2005, Rational Rose, Crystal Reports 9, Windows XP, Oracle 8i, Windows XP/NT/2000, SQL, PL/SQL Developer 5.1,Sun Solaris8.0, Erwin 4.0, ER- Studio

Confidential, SFO, CA

Data Modeler/Analyst

Responsibilities:

• Actively involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, and Stored Procedures) in thedatamodel.
• Presented thedatascenarios via, Erwin logical models and excel mockups to visualize thedata better.
• Worked on building thedatamodel using ER Studio as per the requirements, discussion and approval of the model
• Involved withDataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData, Data Definitions andDataFormats
• Designed and Developed logical & physicaldatamodels and MetaDatato support the requirements using Erwin
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin.
• Involved withDataProfiling activities for new sources before creating new subject areas in warehouse
• Tested the ETL process for both beforedatavalidation and afterdatavalidation process. Tested the messages published by ETL tool anddataloaded into various databases
• Experienced in creating UNIX scripts for file transfer and file manipulation.
• Developed ER and Dimensional Models using Power Designer advanced features. Created physical and logicaldatamodels using Power Designer.
• Successfully created and managed a conversion testing effort which included adataquality review, two system test cycles, and user acceptance testing.
• Ensured onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: DB2, CA Erwin 7.0, Oracle 11g, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, ERwin r8.0 and Erwin r9.0, MS-Office, SQL Server 2008/2012.