SUMMARY

• Over 8+ years of working experience as a Data Modeler and DataAnalyst wif high proficiency in requirement gathering anddatamodeling including design and support of various applications in OLTP,DataWarehousing, OLAP and ETL Environment.
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• 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 in data mart 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.
• Experienced in logical/physical database design and review sessions to determine and describedataflow anddatamapping from source to Confidential databases coordinating wif End Users, Business Analysts, DBAs and Application Architects.
• Used Oracle administration on 12c, 10g, 9i versions. Backup and Recovery strategies using RMAN, Cold\Hot backups, Replication and otherdatamigration strategies.
• Excellent analytical and communication skills wif clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good experienced indatatransformation,datamapping from source to Confidential database schemas and alsodatacleansing.
• Used Teradata Fast Load utility to load large volumes ofdatainto empty Teradata tables in teh Data mart for teh Initial load.
• Experienced working wif 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

Data Modeling Tools: Erwin R9, Erwin R8, 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: Informatica Power Center 9.6.1/9.5/8.6.1/8.1/7.1 , Talend, Pantaho.

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

Database Tools: Microsoft SQL Server 2008/2005, Teradata, Oracle 10g/9i, and MS Access

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, Minneapolis, MN

Sr. Data Analyst /Data Modeler

Responsibilities:

• Analyzed teh business requirements by dividing them into subject areas and understood thedataflow wifin teh organization
• Did extensive analysis ondata, profiled it before moving forward wif building marts.
• Created aDataMapping document after each assignment and wrote teh transformation rules for each field as applicable
• Created and maintained Metadata, including table, column definitions
• Generated a separate MRM document wif each assignment and shared it on SharePoint along wif teh PDF of updateddatamodels
• Used Model Mart of Erwin 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 teh form of Entity Relationships and elicit more information.
• Developed mapping spreadsheets for ETL team wif source to targetdatamapping wif physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Helped teh BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and teh expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Developed teh logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio
• Defined teh Primary Keys (PKs) and Foreign Keys (FKs) for teh 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 wif subject matter experts (SMEs) on teh 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
• Extracteddatafrom teh databases (Oracle and SQL Server) using Informatica to load it into a single datawarehouse repository of Teradata
• Used Star Schema and Snow flake schema methodologies in building and designing teh logicaldata model in teh dimensional Models.
• Developed Cleansing anddatamigration rules for teh Integration Architecture (OLTP, ODS, DW).
• Redefined many attributes and relationships in teh 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 12c/11g, Teradata 13.10, Microsoft 2008, SQL Developer, SQL Manager, ER Studio, SQL DeveloperDataModeler, OracleDataIntegrator(ODI), SAP Business Objects, Informatica, Crystal Reports, ER Studio 9.1.0, Erwin r7.1, Informatica 7.1.3

Confidential, San Jose, CA

Sr. Analyst /Data Modeler

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Developed, managed and validated existing data models including logical and physical models of teh data warehouse and source systems utilizing a 3NFmodel and dimensional data model.
• Assist in semantic layer design and development of Semantic layer data model.
• Created data masking mappings to mask teh sensitive data between production and test environment.
• Used Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, Tpump on UNIX/Windows environments and running teh batch process for Teradata.
• Worked wif 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 databases such as Oracle and Teradata.
• Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking teh log files and cleanup process.
• Worked wif end users to gain an understanding of information and core data concepts behind their business.
• Responsible for creating test cases to make sure teh data originating from source is making into Confidential properly in teh right format.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Worked on data modeling and produced data mapping and data definition specification documentation.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies.
• Extensively completed data quality management using information steward and did extensive data profiling.
• Extensively worked on Talend Designer Components-Data Quality (DQ), Data Integration (DI) and Master Data Management (MDM)
• Wrote simple and advanced SQL queries and scripts to create standard and ad hoc reports for senior managers.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping

Environment: Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, SAP Logon, Erwin 8.0, Informatica, Business Objects XI, Teradata SQL Assistant, ER Studio 9.1.0, Informatica 7.1.3, Teradata v2R5/v2R6, Sun Solaris, Unix, Linux

Confidential, Buffalo, NY

Sr. Data Analyst / Data Modeler

Responsibilities:

• Worked wif SME's and other stakeholders to determine teh requirements to identify Entities and Attributes to build Conceptual, Logical and PhysicaldataModels.
• Designed an Industry standarddataModel specific to teh company wif group insurance offerings, Translated teh business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
• Created a high-level industry standard, generalizeddatamodel to convert it into
• Involved wif DBA group to create Best-Fit PhysicalDataModel from teh LogicalDataModel using Forward engineering using Erwin tool.
• Enforced referential integrity in teh OLTPdatamodel for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions wif Business Intelligence team to ensure that reporting requirements are met for teh business.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for teh MasterData Management Architecture involving OLTP, ODS.
• Served as a member of a development team to provide businessdatarequirements analysis services, producing logical and Physicaldatamodels using Erwin 7.3.11
• CreatedDataDefinitions and teh MetaDataRepository
• Exploreddatato identify its model role and measurement level. Verifieddatafor missing values and incorrectdata. And tan cleaned and structured thedatabased on teh format required.
• Created stored procedures using PL/SQL and tuned teh databases and backend process.
• Performance tuning of teh database, which includes indexes, and optimizing SQL statements, monitoring teh server.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables

Environment: Erwin 9/8/r7.0, 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, ER- Studio

Confidential

Data Analyst / Data Modeler

Responsibilities:

• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in thedatamodel.
• Actively involved in creating Physical and Logical models using Erwin.
• Presented thedatascenarios via, Erwin logical models and excel mockups to visualize thedatabase.
• Worked on building thedatamodel using ER Studio as per teh requirements, discussion and approval of teh model from teh BA.
• Involved wifDataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData, Data Definitions andDataFormats
• Designed and Developed logical & physicaldatamodels and MetaDatato support teh requirements using Erwin
• Designed teh 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 9.5
• Involved wifDataProfiling activities for new sources before creating new subject areas in warehouse
• Tested teh ETL process for both beforedatavalidation and afterdatavalidation process. Tested teh 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.
• Used Expert level understanding of different databases in combinations forDataextraction and loading, joiningdataextracted from different databases and loading to a specific database.
• Ensured onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested teh database to check field size validation, check constraints, stored procedures and cross verifying teh field size defined wifin teh application wif 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.