SUMMARY:

• Over 8 years of IT experience in teh field ofDataanalysis, ETL Development andDataModeling.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services
• Good experience inDataModeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and LogicalDataModeling using Erwin.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per teh Software Development Life Cycle.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experienced in designing teh Conceptual, Logical and Physicaldatamodeling using Erwin, Power Designer 12.0 and ER StudioDatamodeling tools.
• Experience in Teradata EnterpriseDataWarehouse (EDW) andDataMart.
• 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.
• Expert in developing transactional enterprisedatamodels that strictly meet normalization rules, as well as EnterpriseDataWarehouses using Ralph Kimball and InmonDataWarehouse methodologies.
• Solid experience indatatransformation,datamapping from source to target database schemas and alsodatacleansing.
• Extensive experience in Unix Shell scripting in Bourne Shell, Korn Shell and C-shell.
• 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.
• Extensively experienced in using tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
• Experienced inDataModeling using designed tool Erwin, Oracle SQL Developer, SQL Server Management studio, My SQL, SQL Plus and Toad.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Experienced in Business Intelligence (SSIS, SSRS),DataWarehousing and Dashboards.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Experienced in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant.
• Extensive ETL testing experience using Informatica 9x/8x, Talend, PentahoAn excellent team player& technically strong person who TEMPhas capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in teh project.

TECHNICAL SKILLS:

DataModeling Tools: Erwin r9, Erwin r8, Erwin r7.1/7.2, Rational Rose 2000, ER Studio and Oracle Designer

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

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

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

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

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal ServerOperating 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

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Data Analyst/Modeler

Responsibilities

• Discovered entities, attributes, relationships and business rules from functional experts and functional requirements
• Used Erwin and utilized it for creating Conceptual, Logical and Physical data models
• Translated logicaldatamodels into physical database designs, generated DDLs for DBAs
• Worked onDatamapping,Datarationalization and documenting ETL transformations
• PerformedDataAnalysis,DataProfiling,Datamapping and documenting ETL transformations.
• Designed theDataModel/Dataexchange Metadata Model for All Interfaces andDataExchanges
• Worked on Naming standards for Table/Column/Index/Constraints names thru Erwin Macros and Master Abbreviations file.
• Used Teradata Fast Load utility to load large volumes ofdatainto empty Teradata tables in teh Datamart for teh Initial load.
• Used Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Created Model Change/Augmentation Scripts to implement Database changes.
• PerformedDataReconciliation between integrated systems, Involved in extensiveDataValidation with SQL queries, Involved in
• Worked with System Admins to develop, test, and maintain teh accurate tracking, capturing and reporting of key product usage
• Extensively used Agile methodology as teh Organization Standard to implement thedataModels.
• Experience inDataTransformation andDataMapping from source to target database schemas and alsodatacleansing.
• Identified teh objects and relationships between teh objects to develop a logical model using ERWIN and later translated teh model into physical model.
• Created tables, views, sequences, triggers, table spaces, constraints and generated DDL scripts for physical implementation.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application
• Reviewed and implemented teh naming standards for teh entities, attributes, alternate keys, and primary keys for teh logical model.
• Worked with DBA to create teh physical model and tables.
• Reverse engineering old database and creating subject areas for each schema.

Environment: DB2, CA Erwin, Oracle 11g, VISIO, MS-Office, PL/SQL, SharePoint, INFORMATICA, VISIO, Oracle, MS-Excel, Teradata

Confidential, Herndon, VA

Sr. Data Analyst/Modeler

Responsibilities

• Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Snowflake model used data is organized inside teh database in order to eliminateredundancyand thus helps to reduce teh amount of data.
• Worked withDataStewards and subject matter experts to research reporteddataanomalies, identified root causes, and determined appropriate solutions.
• Worked withdatasource systems and Client systems to identifydataissues,datagaps, identified and recommended solutions.
• Worked in defining conceptualdatamodels and logicaldatamodels
• Involved in development and maintenance work ondatamodels,datadictionaries, event models, CRUD matrix, and other artifacts to maintain currency with corporate standards
• Conducted and performeddatamodeling exercises in support of subject areas and/or specific client needs fordata, reports, or analyses, with a concern towards reuse of existingdataelements
• Developed, managed and validated existingdatamodels including logical and physical models of thedatawarehouse and source systems utilizing a 3NF model
• Developed and programmed test scripts to identify and manageddatainconsistencies and testing of ETL processes
• Createddatamasking mappings to mask teh sensitivedatabetween production and test environment.
• Created, defined, and maintaineddatalife-cycle documentation representingdataelements across multiple upstream and downstream systems.
• Implementing logical and physicaldatamodeling with STAR schema using Erwin inDataMart.
• Involved withdataprofiling 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.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data from various heterogeneous data sources
• Responsible for creating test cases to make sure thedataoriginating from source is making into target properly in teh right format.
• Createddatamasking mappings to mask teh sensitivedatabetween production and test environment.
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddata validation issues
• Involved in extensiveDatavalidation by writing several complex SQL queries and involved in back-end testing and worked withdataquality issues
• Datamapping, logicaldatamodeling, created class diagrams and ER diagrams and used SQL queries to filterdatawithin teh Oracle database.
• Performeddatamining and integration activities primarily using SQL databases,
• Created E/R Diagrams,DataFlow Diagrams, grouped and created teh tables, validated thedata, identified lookup tables.
• Using 3rd NF created metadata collection and validation; standards compliance verification; ODS schema maintenance; database-to-databasedatatype.
• Performed legacy applicationdatacleansing,dataanomaly resolution and developed cleansing rule sets for ongoing cleansing anddatasynchronization.

Environment: Informatica,DataFlux, Oracle 11G, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, XML, Netezza, Aginity, ERWINdatamodeler, UNIX, Tableau, Cassandra, IDE, IDQ,Data Cleansing,dataprofiling, Shell Scripting

Confidential, Portland, OR

Sr. Data Analyst/Modeler

Responsibilities

• Gatheird and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Responsible for teh analysis of business requirements and design implementation of teh business solution.
• Developed Conceptual, Logical and Physicaldatamodels for central model consolidation.
• Worked with DBAs to create a best fit physicaldatamodel from teh logicaldatamodel.
• Used Erwin r7.3 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Facilitated transition of logicaldatamodels into teh physical database design and recommended technical approaches for gooddatamanagement practices.
• Worked with DBA group to create Best-Fit PhysicalDataModel from teh LogicalDataModel using Forward Engineering.
• Involved in designingDatamarts by using Star Schema and Snowflake schema.
• Actively involved in creating Physical and Logical models using Erwin.
• Worked on building thedatamodel using ER Studio as per teh requirements, discussion and approval of teh models
• Extensive system study, design, development and testing were carried out in teh Oracle environment to meet teh customer requirements.
• Documented logical, physical, relational and dimensionaldatamodels. Designed thedatamarts in dimensionaldatamodeling using star and snowflake schemas.
• Redefined attributes and relationships in teh model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
• Worked on teh reporting requirements and involved in generating teh reports for theDataModel.
• Identified/documenteddatasources and transformation rules required to populate and maintaindatawarehouse content.
• Generated DDL statements for teh creation of new Sybase objects like table, views, indexes, packages and stored procedures.
• Created DataStage Server jobs to loaddatafrom sequential files, flat files and MS Access
• Used DataStage Manager for importing metadata from repository, new job categories and creating newdataelements
• Used teh DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loadingdatainto differentDataMarts.
• Tuning and code optimization using different techniques like dynamic SQL, dynamic cursors, tuning SQL queries, writing generic procedures, functions and packages
• Developing reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by teh team and satisfying teh business rules
• Assisted in designing implementation plan and monitored teh same by actively participating in user training, livedataentry and obtained sign-off from teh concerned departmental head

Environment: Erwin, Datastage, Oracle11g, Teradata, DB2 Version 9.0, Rational Rose.Er Studio

Confidential, Allen, TX

Sr. Data Analyst/Modeler

Responsibilities

• Conducted JAD sessions, wrote meeting minutes, collected requirements from business users and analyzed based on teh requirements.
• Identified teh facts and dimensions based on teh requirements.
• Designed teh conceptualdatamodel and worked with teh Business analysts and technical teams to design and update teh logicaldatamodel in various iterations.
• Converted teh logicaldatamodel into physicaldatamodel and communicated with DBA to implement teh Physical Database.
• Responsible fordatamapping, metadata maintenance and enhancing Conceptual, Logical and Physicaldatamodels.
• Used ErwinDataModelerand Erwin Model Manager to create Conceptual, Logical and Physical datamodels and maintain teh model versions in Model Manager for further enhancements.
• Database Schema (Star Snowflake) design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Created SQL Prototypes to load sampledata, and also to test teh business rules/logic prior to development.
• Involved in conducting walkthroughs with business and development teams to validate end-to-enddatamapping.
• Developed thedatawarehouse model (star schema) for teh proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfill requirement.
• Reverse Engineered source system databases wheredatamodels are not available in order to understand how teh source systems are structured.
• Performeddataanalysis and profiling using TOAD forDataAnalyst.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch datafrom legacy Oracle and MS SQL Server systems.
• Experience in creating UNIX scripts for file transfer and file manipulation
• Designed thedatamarts in dimensionaldatamodeling using star and snowflake schemas.
• Supported ETL team in building teh ETL maps to loaddatainto thedatamarts.
• Worked as part of a team ofDataManagement professionals supporting a Portfolio of development projects both regional and global in scope.
• Designeddataflows that extract, transform, and loaddataby optimizing ETL performance.
• Created an enterprisedatadictionary and maintained standards documentation.
• Interacted with teh end users and found out teh performance of teh database and also involved in developing test cases.
• Conducted peer reviews of completeddatamodels and plans to ensure quality and integrity from datacapture through usage and archiving.

Environment: Oracle 11g, Microsoft 2008, SQL Developer, SQL Manager, ER Studio, visio, OracleDataIntegrator (ODI), Informatica, Crystal Reports, Teradata SQL Assistant

Confidential, Cupertino, CA

Data Analyst

Responsibilities

• Involved in Data mapping specifications to create and execute detailed system test plans. Teh data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Worked with RDBMSin Power Designing
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Setting up of environments to be used for testing and teh range of functionalities to be tested as per technical specifications.
• Worked on building thedatamodel using ER Studio as per teh requirements, discussion and approval of teh model from teh BA.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing teh essential business elements, detailed definitions, and descriptions of teh relationships between teh data elements .
• Wrote and executed SQL queries to verify that data TEMPhas been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Troubleshoot test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Responsible for different Data mapping activities from Source systems to Teradata
• Created teh test environment for Staging area, loading teh Staging area with data from multiple sources.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Followed company code standardization rule
• Performed ad hoc analyses, as needed, with teh ability to comprehend analysis as needed
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on teh basis of using defect reports.
• Tested teh ETL process for both before data validation and after data validation process. Tested teh messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing.

Environment: Oracle, Microsoft 2008, SQL Developer, power designer, ER Studio, Visio, Informatica, Crystal Reports, Teradata SQL Assistant