SUMMARY

• Over 8 years of IT professional experience with strong background in Databasedevelopment and designing ofdatamodels for different domains.
• Strong Knowledge of SDLC methodology including analysis, design, development, testing and maintenance.
• Experience in the field ofData/ Business analysis, ETL Development,and Project Management.
• Experience as a DataAnalystand Data Modeler with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating DataSources, DataMapping, Translating Requirements into Specifications, Application Design.
• Senior level SQL query skills in analyzing and validating databasedata warehouse processes.
• Expertise in broad range of technologies, including business process tools such as MicrosoftProject, MSExcel, MSAccess, MSVisio, technical assessment tools, Micro StrategyDataWarehouseDataModeling and Design.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Participated in JADsessions, created UseCases, workflows and PowerPoint presentations.
• Extensive experience in RelationalDataModeling, DimensionalDataModeling, Logical/PhysicalDesign, ERDiagrams, Forward and ReverseEngineering, Publishing Erwindiagrams, analyzing data sources and creating interface documents.
• Created, documented and maintained logical and physicaldatabase models in compliance with enterprise standards.
• Experience in SQL Performance Tuning and Optimization (Design, Memory, Application, IO) and using Explain plan, Tracing and TKPROF.
• Managed performance and tuning of SQLqueries and fixed the slow running queries using utilities like Explain, Trace, and TKPROF.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Worked extensively on forward and reverse engineering processes using tools like Erwin.
• Created DDLscripts for implementingDataModeling changes.
• Experienced in generating and documenting Metadata, while designing OLTP, ODS and OLAP systems environment.
• Worked on different platforms such as Windows7/XP and UNIX, SunSolaris, AIX, HP
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Created reports from SAPmodules using BusinessObjects / CrystalReports based upon business requirements.
• Competent in Creating Unified Modeling Language (UML) diagrams such as UseCaseDiagrams, ActivityDiagrams, ClassDiagrams and Sequence Diagrams.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, Tableau and BusinessObjects

TECHNICAL SKILLS

Operating System: UNIX, Linux, Windows, Windows XP pro

Data Analysis: Requirement Analysis, Business Analysis,DataFlow Diagrams, Business Rules,DataModeling.

Database: Oracle 8i/9i/10g/11g/12c, MS Access, SQL Server, Teradata, Netezza and DB2.

DataModeling Tools: Erwin, Rational Rose and MS Visio Star and Snowflake Schemas Modeling, Facts & Dimensions.

Languages: SQL, PL/SQL, XML

Applications: Toad for Oracle, Oracle SQL Developer, MS Word, MS Excel,MS Power Point, Teradata

ETL Tools: Informatica Power Center 7.x/8.x/9.x, SQL * Loader

Reporting Tools: Oracle Business Intelligence

PROFESSIONAL EXPERIENCE

Confidential, Livonia, MI

Sr. Data Analyst / Data Modeler

Responsibilities:

• Involved in requirements gathering, Analysis, Design and Develop and maintenance Phases.
• Execute SQL queries to extract, manipulate, and/or calculate information to fulfilldataand reporting requirements including identifying the tables and columns from whichdatais extracted.
• Analyzed and documented the changes in the compliance rules for adverse action redesign.
• Extensive experience in ETL processes in extractingdatafrom Operational and Legacy Systems toDataWarehouse using Informatics.
• Used TeradataSQL assistant for managing repository (view and edit), define custom routines & transforms, Import and export items between different DB2 systems or exchange metadata with otherdatawarehousing tools.
• Worked closely with the EnterpriseDataWarehouse team and Business Intelligence
• Createddatafor dashboard, reports, analysis datasets, and graphs using Tableau.
• Performed extensive task which include DataQualityAnalysis, Data lineage and Data Standardization datastructures, data base design, datawarehouses, business intelligence/analytic tools, SQL, ETLtools, and data integration methods
• Created requirements analysis and design phase artifacts using Requisite Pro and MSVisio.
• Datamapping, logicaldatamodeling, used SQLqueries to filterdatawithin the Oracle and Teradata.
• Used the AgileScrum methodology to build the different phases of Software development life cycle.
• Successfully Integrateddataacross multiple and high volumes ofdatasources and target applications.
• Used extensive SQL fordataprofiling/analysis to provide guidance in building thedatamodel

Environment: Teradata SQL Assistant, Mainframe DB2, SQL *Loader, SQL Server 2008, Oracle 10g, Sequential files, Flat files, SQL, PL/SQL, Shell scripts, Windows 7, Crystal Reports Requisite Pro, BIRT designer studio, SAS, Micro strategy UML

Confidential, McLean, VA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing and Documentation. Gathered Requirements and performed Business Analysis.
• Extensively used SQL forDataAnalysis.
• Done Reverse engineering on existingdatamodel to understand thedataflow and business flows.
• Designed ERdiagrams, logicalmodel (relationship, cardinality, attributes, and, candidate keys) and physicaldatabase (capacity planning, object creation and aggregation strategies) as per business requirements.
• Created Schema objects like Indexes, Views, and Sequences
• Developed a Conceptual model using Erwin based on requirements analysis
• Developed normalized Logical and Physicaldatabase models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin
• Used forward engineering to create a PhysicalDataModel with DDL that best suits the requirements from the LogicalDataModel
• Developed a Conceptual model using Erwin based on requirements analysis
• Worked with DatabaseAdministrators, BusinessAnalysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards fordatawarehouse
• Generated ad - hoc SQL queries using joins, database connections and transformation rules to fetchdatafrom legacy DB2 and SQLServer database systems
• Exhaustively collected business and technical metadata and maintained naming standards
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation

Environment: Erwin r8.2, Informatica, Windows XP/NT/2000, SQL Server, SQL, Oracle10g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential, Iselin, NJ

Sr. Data Analyst/Data Modeler

Responsibilities:

• DataArchitecture, logical and physicalModeling for OLAP systems.
• ERModeling - Developing Entity Relationship Diagrams (ERD).
• Normalizing the tables/relationships to arrive at effective RelationalSchemas.
• Identifying the facts&dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing SnowflakeSchemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• DimensionalDataModeling to deliver Multi-DimensionalSTAR schemas.
• Requirements &Business Process Analysis; Rapid Audit of the requirements and existing systems.
• Developed, Implemented & Maintained the Conceptual, Logical&PhysicalDatamodels.
• Design & Implementation ofDataMart; DBAcoordination; DDL&DML Generation & usage.
• Metadata &DataDictionary Management; DataProfiling; DataMapping
• Supporting and managing RDBMS and designing SQLServer RDBMS architecture concepts, Usage of System catalogs on QueryAnalyzer, Space management including File groups.
• Normalization techniques to arrive at effective Relational Schemas.
• Applied DataGovernancerules (Classword, Abbreviations, DataDomains, DataDefinitions, and MetadataInformation).
• Involved in capturingdatalineage, table and columndatadefinitions, valid values, and others necessary information in thedatamodels.
• Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models.
• Performance Tuning (DatabaseTuning, SQLTuning, Application/ETLTuning).
• Maintained and documented all create and alter SQL statements for all release.
• DesigningDataFlows& System Interfaces.
• Architecting Work Flows, Activity Hierarchy &ProcessFlows; Documenting using InterfaceDiagrams, FlowCharts& Specification Documents.
• Created Teradata specific physicaldatamodels which included primary indexes, secondary indexes and joined indexes.
• Implemented Hybrid Architecture comprising Inmon and Kimball approaches implementing Inmon at integrated layer and Kimball at the Semantic layer which is the best suited for Teradata.
• Created specific indexes to speed up thedataload and thedataretrieval.

Environment: Teradata V2R6, SQL, Sybase Power Designer 12.5/ 15, Business Objects, Ab Initio, MS office, MS Access.

Confidential, Minneapolis, MN

Sr. Data Modeler/Data Analyst

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document)
• Involved in extensiveDatavalidation using SQLqueries and back-end testing
• Performeddataanalysis anddataprofiling using complexSQL on various sources systems including Oracle and Teradata
• Tested the ETLprocess for both before datavalidation and after data validation process.
• Tested the messages published by ETLtool and data loaded into various databases
• Tuning and optimization of TeradataQueries Created the ETLdatamapping documents between source systems and the targetdata warehouse.
• Wrote complex SQLqueries for validating thedataagainst different kinds of reports generated by BusinessObjectsXIR2.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas
• Utilized T-SQL features in SQLServer such asDatapartitioning, Error handling through TRY-CATCH statement and Common Table Expression (CTE).
• Assisted in the oversight for compliance to the EnterpriseDataStandards,datagovernance anddataquality
• Used CAErwinDataModeler (Erwin) for data modeling (data requirements analysis, database design etc.) of custom developed information systems, including databases of transactional systems and datamarts.
• Worked with the project management team to ensure the quality and schedule of the applications. Addressed and resolved internal and production issues.

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, RTP, NC

Data Analyst / Data Modeler

Responsibilities:

• Performeddataprofiling in the source systems that are required forDataMarts
• Documented the complete processflow to describe program development, logic, testing, and implementation, application integration, coding
• Worked with internal architects and assisted in the development of current and target state enterprisedataarchitectures
• Worked with project team representatives to ensure that logical and physicaldatamodels were developed in line with corporate standards and guidelines
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddatavalidation issues
• Involved in defining the source to targetdatamappings, businessrules, anddatadefinitions
• Responsible for defining the key identifiers for each mapping/interface
• Responsible for defining the functional requirement documents for each source to target interface
• Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testingteam
• Reverse engineered all the Source Databases using Erwin
• Documenteddataquality and traceability documents for each source interface
• Involved indatawarehouse designand implementation
• Documented the complete process flow to describe program development, logic, testing, and implementation, applicationintegration, coding
• Worked with internal architects in the development of current and target statedataarchitectures
• Useddataanalysis techniques to validate business rules and identified low quality missingdatain the existing enterprisedatawarehouse (EDW)

Environment: Oracle 9i, MS Access 2003, MS Excel 2003, MS Word 2003, MS Outlook 2003, CA Erwin, Crystal Reports, PowerPoint 2003, SharePoint