SUMMARY

• Around 11 years of Experience working as a DataAnalyst/DataModeler and Data Architect with emphasis on DataMapping, DataValidation, Requirement Gathering in OLTP and OLAP environments.
• Proficient in Analyzing source system by examining the content, structure and internal relationships of legacydatasources like flatfiles, Excel, Oracle, Sybase, SQLServer, XML and DB2 databases.
• Involved in all phases of the software development life cycle (SDLC), from requirements definition through implementation and supported my models in transformation and analysis phase.
• Experienced in DataMigration, DataConversions using DTS, DataJunction and SQLLoader.
• Expert in creating Canonical modeling repository that can be reused for generating schema for the current and future applications operations.
• Articulate with DataConversion, DataQuality, DataProfiling, Performance Tuning and System Testing and implementing RDBMS features.
• Createddatamappings to loaddatafrom target using different transformations and executed workflows fordataloads to target systems.
• Well - versed in writing SQLqueries to perform end-to-end ETLvalidations and support Ad-hoc business requests.
• A good expertise in Extract Transform and Load (ETL)datafrom spreadsheets, database tables and other sources using Informatica, Talend, Pentaho and DataStage.
• Solid understanding of RalphKimball's and BillInmon'smodeling techniques.
• Excellent experience on databases such as Oracle, Netezza, Teradata and MongoDB
• Good knowledge and experience on Big Data technologies such as Hive, Hbase, Hadoop etc.
• Competent knowledge inDataModeling tools like ERWIN, Power Designer and Embarcadero ER/Studio.
• Worked extensively on XMLdataand XSD schema designing.
• Experienced in generating and documenting Metadata, while designing OLTP, ODS and OLAP systems environment.
• Experience withDataAnalysis, mapping source and target systems fordatamigration efforts and resolving issues relating todatamigration
• Good Knowledge in designing thedatamarts using RalphKimball's and Bill Inmon DimensionalDataMart Modeling techniques
• Good Knowledge on SQLqueries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing the business techniques.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD/JAR sessions
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using Erwintool
• Proficient in System Analysis, ER/DimensionalDataModeling, Database design and implementing RDBMS specific features.
• Well versed withDataprofiling,DataMigration andDataConversions.

TECHNICAL SKILLS

Analysis and Modeling Tools: Erwin 7.2/7.0, 8.0, r9, Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio

ETL Tools: Informatica Power Center 9.5/8.6.1/8.1/7.1 , DataStage 7.5, Ab Initio, Talend

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, CognosPowerplay

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

Databases: MS SQL Server 2008/2005/2000 , Oracle11g/10g/9i/8i, DB2 V9.5, Teradata V2R6.1, MS Access 2000

Operating Systems: Windows XP/2000/98, UNIX (Sun Solaris 10)

Project Execution Methodologies: Ralph Kimball and Bill Inmondatawarehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

Tools: & Software TOAD, MS Office, BTEQ, Teradata SQL Assistant

Tools: MS-Office suite (Word, Excel, MS Project and Outlook), VSS

ETL Tools: Microsoft DTS/SSIS, SSRS and Informatica 7.1.3

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

Operating Systems: Microsoft Windows XP / Vista/7 and UNIX

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

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

Sr. Data Modeler/Data Analyst/Data Architect

Responsibilities:

• Involved in designing logical, physical and dimensional database designs using reverse and forward engineering of ERWIN.
• Used ERWIN's Database Generation for generating DDL, stored procedure and trigger code for your target database
• Involved inDataWarehouse Support - StarSchema and Dimensional modeling to help designDataMart anddatawarehouse.
• Extensively used Normalization techniques (up to 3NF).
• Writing complex queries using Teradata SQL.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Netezza.
• Designed Mapping Specifications for Source to Target along with the businessrules.
• Identified source validation rules, process calculations, equations and validations.
• Importing, cleaning, transforming, validating using SAS.
• Planning the SAP PowerDesigner Environment, defining the Repository Structure and managing Releases in the Repository
• Developed strategies for data warehouse implementations, data acquisitions, provided technical and strategic advice and guidance to senior managers and technical resources in the creation and implementation for data architecture and data modeling.
• Experience in extract, transform and loading data from RDBS toHadoop& Netezza using Informatica.
• Defined corporate metadata definitions for the enterprise data supported databases including operational source systems, data stores and data marts developed logical and physical data models and documented source data from multiple sources, internal systems, external source systems, and third party data.
• Worked with the ETL team to document the transformation rules fordatamigration from source to target systems.DevelopedDataMapping, Data profiling,DataGovernance, and Transformation and cleansing rules for the MasterData Management Architecture involving OLTP, ODS.
• Developed source to target mapping documents to support ETL design.
• Migrated the critical reports using PL/SQL&UNIX packages.
• Experience in proving, weekly, monthly & yearly aggregated data to SAS to do the analysis and reporting.
• Developed the logicaldatamodels and physicaldatamodels that capture current state/future state dataelements anddataflows using ER Studio.
• Worked closely with the ETLDevelopers to explain the complexDataTransformation using Logic.
• Worked closely with the Index Modeling Team, SOA team, and Service Integration team and assisted in incorporating physical information in the BOM and generated XML
• Involved in designing the procedures for getting thedatafrom all systems toDataWarehousing system.
• Managed definition and execution of data mapping, conversion and reconciliation processes, fordata originating from a plethora of enterprise and SAP, leading into to ongoing data governance organization design
• Possess extensive knowledge on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Written stored procedures and triggers and optimized for maximum performance.

Environment: ERWIN 8.2, SAS, SPSS, InformaticaPowerMart (Source Analyzer, Data warehousing designer, Mapping Designer,Hadoop,Mapplet, MongoDB, Transformations), MS SQL Server 2008, Oracle, SQL, PL/SQL,SSIS, Sun Solaris, Windows 7, IBM Compatibles.

Confidential, Iowa City, IA

Sr. Data Modeler/Data Architect

Responsibilities:

• Involved in the projects from requirement analysis to better understand the requirements and support the development team with the better understanding of thedata.
• Designed logical and physicaldatamodels for multiple OLTP applications.
• Redesigned some of the subject areas and introduced some new entities and attributes as per the requirements.
• Experts' to identify source & target elements and transformationrulesfor EDW.
• Wrote and executed SQLqueries to verify that data has been moved from transactional system to DSS, Datawarehouse, datamart reporting system in accordance with requirements.
• Involved in Migrating the data model 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.
• Generatehadoop modeling for Hive database tables Conceptual, logical and physicaldata models are designed with maintaining data governance and naming standards.
• Tuning and optimization of Teradata Queries Created the ETL data mapping documents between source systems and the target data warehouse.
• Consolidated and generated database standards and naming conventions to enhance Enterprise Data Architecture processes.
• Designed the ERdiagrams, logicalmodel(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 SQLqueries to verify that data has been moved from transactional system to DSS, Datawarehouse, datamart reporting system in accordance with requirements.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flatfiles, SQLServer2005 with high volume data
• Working with thearchitect to define and implementSOA roadmap strategy.
• To Design the logicalModel and ensure that if follows the normalization rules and have the best possible traceability pattern
• Designing, troubleshooting and implementing solutions for validation, transformation, security, exception handling and monitoring ofSOA composites and services developed using Oracle Service Bus 11g.
• Documented the design conventions used for performing database modeling.
• Responsible for ensuring and providing consistent metadata across all the models in FPA.

Environment: Quality Center 9.2, PL/SQL,Business Objects XIR2, ETL Tools Informatica 8.6, Oracle 11G, Teradata R13, Teradata SQL Assistant, MongoDB, Load Runner 7.0, Oracle 11g, UNIX AIX 5.2, PERL, Shell Scripting

Confidential, Hartford, CT

Sr. Data Modeler/Data Analyst

Responsibilities:

• Interacting with business users to understand the business requirements.
• Coordinating with Business analysts to understand the business challenges anddatafor reporting.
• 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.
• DefiningSOA architecture for the project, preparing project plan and get client's agreement on it.
• Pre populate the static tables in the Data warehouse
• Excellent exposure in Data Profiling in reference to Data Warehouse and BI development.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Created partitions and indexes for the tables in thedatamart.
• Maintained metadata (datadefinitions of table structures) and version controlling for thedatamodel.
• Conducted design reviews with business analysts, Enterprisedataarchitect and solution lead to create proof of concept for the reports.
• Created source to target mapping documents ofdatamart for all sources.
• Developed SQL scripts for creating tables, Sequences, Triggers, views and materialized views.
• Developed SQL scripts for loadingdatafrom staging area to target tables.
• Created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities and Transaction DataSets for Automatic Position Reporting.
• Conducted performance analysis and created partitions, indexes and Aggregate tables.
• Developed SQL scripts for loading the aggregate tables and rollup dimensions.
• Performeddataanalysis on the target tables to make sure thedataas per the business expectations.
• Studied the existing BI architecture and analyzed the existing systems to propose the alternate solutions.
• Proposed the EDWdatadesign to centralize thedatascattered across multiple datasets. The proposal also address thedataduplications,datain consistencies,dataquality management etc.
• Performed theDataMapping,Datadesign (DataModeling) to integrate thedataacross the multiple databases in to EDW.
• Planning the PowerDesigner Lifecycle Management and creating Model Templates.
• Migrated the critical reports using PL/SQL&UNIX packages.
• Involved in the creation of reporting universes in BusinessObjects.

Environment: Oracle, Toad for Oracle 10, ToadDataModeler3.4, SAS, SPSS, SQL Plus, ErwinDataModeler8.2, Erwin Model Manager 8.2,, SSRS, SSIS, MS Visio, Source Offsite (SOS), Windows 7, Business Objects, Hadoop, Oracle SQL Developer

Confidential, Columbus, OH

Sr. Data Modeler/Data Analyst

Responsibilities:

• Worked with Business analysts and sales management team on day to day activities.
• Organized JAD sessions and captured the technical requirements core and edge.
• Have donedataanalysis (GapAnalysis), to map logical to physical elements.
• Work with subject matter experts, Finance & HRdataanalysts & otherdatamodelersto createdata modeling deliverables.
• Create logical and physicaldatamodels using best practices to ensure highdataquality and reduced redundancy. Define, document, and articulate design goals and standards.
• Take ownership ofdatamodels, both logical and physical, inclusive of version control.
• Optimize and update logical and physicaldatamodels to support new and existing projects.
• Perform reverse engineering of physicaldatamodels from databases and SQL scripts.
• Provide the technical documentation to the ETL developers for developing thedataloading techniques & the design details to the Reporting team.
• Involved in writing PL/SQLprocedures, Pre-session and Post- Session Scripts.
• Responsible for code migration & database changes through the various stages of the Projectdevelopmentlifecycle.
• Employ best practices indataprofiling and designing solutions for handlingdataquality issues.
• Validate businessdataobjects for accuracy and completeness.
• Analyzedata-related system integration challenges and propose appropriate solutions.
• Managed the Database security by providing the customized and configured product user authentications and authorizations.

Environment: Oracle, Teradata V2R6 & SQL server 2005, Datastage 8.1 & 9, Erwindatamodeler, SQL developer & PLSQL developer

Confidential

Data modeler/Data Analyst

Responsibilities:

• Participated in Business Requirements gathering with business and user groups.
• Designed Conceptual, logical and PhysicalDataModels using Erwin.
• Maintained data model by implementing change request by developers.
• Worked with DBA to create table, add columns by providing them SQL scripts.
• Implemented DDL in oracle database.
• Worked with development team to get change request and implement in data model and then database.
• Performed Normalization, Indexes Tuned and Optimized the existing database design.
• Maintained data mapping information and documented properly.
• Performed various tasks that included data massaging, data extraction from flat files, data transformations into various file formats, validations, loading data and checking for any data integrity errors.
• Successfully designed Aggregation tables in the dimensionalmodel data warehouse.
• Documented data dictionary for all version of data models.
• Verified business definitions for table and column and maintained standard physical naming with primary qualifier and class words.
• Worked very closely with end user to implement their need in data model designed.
• Conceptual, logical and physicaldata models are designed with maintaining data governance and naming standards.

Environment: Power Designer, Erwin, Oracle 9i, SQL Server 2005, MS Office.