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 Oracle: 1g/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

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Sr. Data Analyst/ Data Modeler

Roles & Responsibilities

• Involved in extensiveDatavalidation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Involved with Design and Development team to implement the requirements.
• DataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions andDataFormats.
• Defined and implemented Enterprise Data Management services from a technology perspective while understanding the 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 the requirements Analyzed requirements to develop design concept and technical approaches to find the 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 the creation and implementation fordataarchitecture anddatamodeling.
• Defined corporate metadata definitions for the 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 the normal forms on the OLTP database.
• Tuning and optimization of Teradata Queries Created the ETLdatamapping documents between source systems and the targetdatawarehouse.
• Consolidated and generated database standards and naming conventions to enhance Enterprise DataArchitecture processes.
• This involved coordination with DBA's and developers to determine the correct requirements for the application changes, preparation of the logical and physical models in accordance with the Enterprise Architecture, generation of thedatadefinition language (DDL) to create the 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

Roles & 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 this model from the scratch
• Worked with DBA to create the 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 the 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.
• This 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 the model and dictionary with subject matter experts and generation ofdatadefinition language.
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel,dataflow and the 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 the 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 the 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

Roles & Responsibilities

• Developed working documents to support findings and assign specific tasks.
• Excellent exposure inDataProfiling in reference 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 the static tables in the Data warehouse.
• Developed strategies and loading techniques for better loading and faster query performance.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The 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 the deadlines.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling jobs.
• Establishing governance to support the Data Reference 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 the enterprise architecture while balancing the 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 the Data Models at enterprise level and followed company standard for Project Documentation.
• Assisted in the oversight for compliance to the 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, MN

Data Analyst/Data Modeler

Roles & 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 the client's future state business model for data, applications and technology.
• Designed the Data Warehouse and MDM hub conceptual, logical and physical data models in support of the 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 the data behavior.
• Done Reverse engineering on existing data model to understand the data flow and business flows of existing systems and to integrate the 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 the business and technical team to gather necessary analytical data requirements in JAD sessions.
• Partitioned tables based on the 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

Confidential, Union Bank, CA

DataAnalyst / Data Modeler

Roles & Responsibilities

• Involved in extensiveDATAvalidation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Created the conceptual, Logical and Physical Model for the data warehouse With Erwin Data modeling tool
• Worked with 1st,2nd,3rd normal forms for designing the 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 the attributes of similarity, across the database.
• Created the Logical data Model with entity's and attributes and their definitions in Erwin
• Created physical data model and generated the DDL and deployed it on databases.
• Developed Data Migration and Cleansing rules for the 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 that incorporated the process flow Visio, S-T Mapping document and all the specifications for proper ETL implementation.
• Conducted internal and final DFD reviews with the ETL team (EIS) and also FSD reviews.
• Participated in ETL Functional Specifications Document (FSD) reviews and responded to questions related to the mappings, modeling and processing logic flows. Supported ETL with the development process.
• Worked with the Business and the ETL developers in the 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