SUMMARY:

• Over 8 + years of experience as data Analyst and data modeler with excellent knowledge on BI,Datawarehouse, ETL and Big data
• Highly proficient inDataModeling retaining concepts of RDBMS, Logical and PhysicalDataModeling until 3NormalForm (3NF) and MultidimensionalDataModeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions).
• Used complete knowledge ofdataware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Expert in theDataAnalysis, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non-relational databases.
• Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository.
• Expertise indatacleansing for analysis, performdataquality testing for gaps, and liaising withdata origination teams.
• Worked with variousdatasources such as Oracle, SQL Server, Teradata & Netezza
• Extensive experience with OLTP/OLAP System and E-R modeling, developing Database Schemas like STAR schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Solid experience inDataModeling using designed tool Erwin, Oracle SQL Developer, SQL Server Management studio, My SQL, SQL Plus and Toad.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Deployed and scheduled Reports using various Business Intelligence reporting tools to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Experienced using MapReduce, and "BIgdata" work on Hadoop and other NO SQL platforms
• Excellent Experience with BIgdatatechnologies (e.g., Hadoop, BIgQuery, MongoDB, Hive, Hbase etc.)
• Experienced in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Extensive experience in advanced SQL Queries and PL/SQL stored procedures.
• ExcellentDataWarehousing concepts including MetadataandDataMarts.
• Experienced in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

DataModeling: Erwin r9.5/8x/7x, ER/Studio 9.7/9.0/8.0/7. x, Power Designer

Databases Oracle11g/10g/9i, Teradata, DB2 UDB 8.x/7.x, DB2 Z/OS 9.x/8.2, SQL Server 2008/2005/2000, MySQL, MS- Access, Flat Files, XML files, Netezza.

Programming Skills: SQL, PL/SQL, Shell Scripting

Operating Systems: LINUX, Sun Solaris 2.X/5/7/8, IBM AIX 5.3/4.2, HP-UX, MS-DOS

Scheduling Tools: Autosys, Maestro (Tivoli), Control M

Other Tools: Teradata SQL Assistant, Toad 9.7.2/7.4/7.3, DB Visualizer 6.0, Microsoft Office, Microsoft Visio, Microsoft Excel, Microsoft Project

WORK EXPERIENCE:

Confidential, McLean, VA

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Involved in extensiveDatavalidation using SQL queries and back-end testing
• Used SQL for Querying teh database in UNIX environment
• Involved with Design and Development team to implement teh requirements.
• DataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions andDataFormats.
• Defined and implemented Enterprise Data Management services from a technology perspective while understanding teh business drivers
• Developed and delivered long-term strategic goals for application architecture, data architecture, data analytics, reporting, and data governance in conjunction with key stakeholders
• Created logical physicaldatamodels and MetaDatato support teh requirements Analyzed requirements to develop design concept and technical approaches to find teh business requirements by verifying Manual Reports.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Netezza
• Developed strategies fordatawarehouse implementations,dataacquisitions, provided technical and strategic advice and guidance toseniormanagers and technical resources in teh creation and implementation fordataarchitecture anddatamodeling.
• Defined corporate metadata definitions for teh enterprisedatasupported databases including operational source systems,datastores anddatamarts developed logical and physicaldatamodels and documented sourcedatafrom multiple sources, internal systems, external source systems, and third partydata.
• Involved in Migrating thedatamodel from one database to Teradata database and prepared a Teradata staging model.
• Designed star schemas and bridge tables to control slowly changing dimensions. Applied teh normal forms on teh OLTP database.
• Tuning and optimization of Teradata Queries Created teh ETLdatamapping documents between source systems and teh targetdatawarehouse.
• Consolidated and generated database standards and naming conventions to enhance Enterprise DataArchitecture processes.
• dis involved coordination with DBA's and developers to determine teh correct requirements for teh application changes, preparation of teh logical and physical models in accordance with teh Enterprise Architecture, generation of thedatadefinition language (DDL) to create teh database.

  Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting

Confidential, Jacksonville, FL

Sr.Data Analyst/ Sr.Data Modeler

Responsibilities:

• Worked ondataanalysis,dataprofiling,datamodeling,datamapping and testing for a given task
• Worked on Teradata Environment based on thedatafrom PDM. Conceived, designed, developed and implemented dis model from teh scratch
• Worked with DBA to create teh physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for teh facts and dimensions.
• Established and maintained comprehensivedatamodel documentation including detailed descriptions of business entities, attributes, anddatarelationships.
• Developed mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• dis involved analysis of a variety of source systemdata, coordination with subject matter experts, development of standardized business names and definitions, construction of a non-relationaldatamodel using ErWin v9.2 modeling tool, publishing of adatadictionary, review of teh model and dictionary with subject matter experts and generation ofdatadefinition language.
• Helped teh BI, ETL Developers, Project Manager and end users in understanding theDataModel,dataflow and teh expected output for each model created
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository
• Managed full SDLC processes involving requirements management, workflow analysis, sourcedata analysis,datamapping, metadata management,dataquality, testing strategy and maintenance of teh model.
• Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository.
• Expert level understanding of using different databases in combinations forDataextraction and loading, joiningdataextracted from different databases and loading to a specific database.
• Extensively used Erwin as teh main tool for modeling along with Visio
• Used SQL on a wide scale for analysis, performance tuning and testing

  Environment: PDM, SAP, JD Edwards, Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, SAP Logon, Erwin 8.0, Visio, Informatica, Business Objects XI, Teradata SQL Assistant

Confidential, Stamford, CT

Data Analyst

Responsibilities:

• Developed working documents to support findings and assign specific tasks.
• Excellent exposure inDataProfiling in toDataWarehouse and BI development.
• Involved with data profiling for multiple sources and answered complex business questions by providingdatato business users.
• Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Designed and Developed strategies for Data Conversions and Data Cleansing
• Creating Mappings, Tech Design, loading strategies for ETL to load newly created or existing tables.
• Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
• Pre populate teh static tables in teh Data warehouse.
• Developed strategies and loading techniques for better loading and faster query performance.
• Designed teh procedures for getting teh data from all systems to Data Warehousing system. Teh data was standardized to store various Business Units in tables.
• Extensively used ETL to load data from flat files (excel/access) to Oracle database from different Vendors and external source systems.
• Worked on defining deadlines and helped team to meet teh deadlines.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling jobs.
• Establishing governance to support teh Data Architecture implementation
• Used application architecture skills to assist in strategic planning and technical data design activities while driving business priorities.
• Designed & managed large enterprise wide data/information architectures, which maps to teh enterprise architecture while balancing teh need for access against security and performance requirements.
• Knowledgeable in most aspects of designing and constructing data architectures, operational data stores, and data marts.
• Deployed naming standard to teh Data Models at enterprise level and followed company standard for Project Documentation.
• Assisted in teh oversight for compliance to teh EnterpriseDataStandards
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volumedata
• Worked with Excel Pivot tables.
• Identify & record defects with required information for issue to be reproduced by development team.

  Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6/9.1/9.5, SSIS, Oracle 11G, Teradata R13, Teradata SQL Assistant

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Champion an enterprise architecture planning effort to outline teh client's future state business model for data, applications and technology.
• Designed teh Data Warehouse and MDM hub conceptual, logical and physical data models in support of teh AMBU Data Foundation Strategy.
• Participated in all phases of project including Requirement gathering, Analysis, Design, Coding, Testing, Documentation and warranty period.
• Extensively used SQL for Data Analysis and to understand teh data behavior.
• Done Reverse engineering on existing data model to understand teh data flow and business flows of existing systems and to integrate teh new requirements to current system.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert them to physical data model including capacity planning, object creation and aggregation strategies, partition strategies, Purging strategies as per business requirements.
• Conducted team meetings and proposed ETL strategy.
• Conducted meetings with teh business and technical team to gather necessary analytical data requirements in JAD sessions.
• Partitioned tables based on teh requirement and developed purging and archival rules.

Environnent: Windows XP, Informatica Power Center, QTP, Test Director, Load Runner, Oracle, UNIX AIX 5.2, PERL, Shell Scripting iGate Technologies, Bangalore, India

Confidential, CA

DataAnalyst / Data Modeler

Responsibilities:

• Involved in extensiveDATAvalidation using SQL queries and back-end testing
• Used SQL for Querying teh database in UNIX environment
• Created teh conceptual, Logical and Physical Model for teh data warehouse With Erwin Data modeling tool
• Worked with 1st,2nd,3rd normal forms for designing teh OLTP database.
• Created a naming standards list and class words list.
• Performed complete compare with Erwin to find differences between versions of models
• Created domains and assigned them to teh attributes of similarity, across teh database.
• Created teh Logical data Model with entity's and attributes and their definitions in Erwin
• Created physical data model and generated teh DDL and deployed it on databases.
• Developed Data Migration and Cleansing rules for teh Integration Architecture (OLTP, ODS, DW).
• Used SQL assistant tool extensively to profile data and check mapping accuracy.
• Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Created DFD (Data Flow diagram) artifacts dat incorporated teh process flow Visio, S-T Mapping document and all teh specifications for proper ETL implementation.
• Conducted internal and final DFD reviews with teh ETL team (EIS) and also FSD reviews.
• Participated in ETL Functional Specifications Document (FSD) reviews and responded to questions related to teh mappings, modeling and processing logic flows. Supported ETL with teh development process.
• Worked with teh Business and teh ETL developers in teh analysis and resolution of data related problem tickets and other defects.

  Environment: Windows XP, Informatica Power Center, QTP, Test Director 7.x, Load Runner 7.0, Oracle, UNIX AIX 5.2, PERL, Shell Scripting