SUMMARY:

• Over 8 years of extensive experience in Data Analysis, DataModeling, SystemAnalysis, Architecture and Development, Testing and Deployment of business applications.
• Experience using ERdiagram, Dimensional data modeling, Logical/PhysicalDesign, StarSchemamodeling, Snow - flakemodeling using tools like Erwin.
• Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC).
• Exert in building EnterpriseDataWarehouse orDatawarehouse appliances from Scratch using both Kimball and Inmon Approach.
• Expertise in creating DDLscripts for implementingDataModeling changes.
• Good in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for effective and optimum performance in OLTP and OLAP
• Well versed in system analysis, ER/Dimensional Modeling, Databasedesign and implementingRDBMS specific features.
• Expertise in dealing with differentdatasources ranging from flat files, Excel, Oracle, SQLServer and Informix
• Strong understanding of the principles ofDatawarehousing, FactTables and DimensionTables.
• Experienced in writing SQL and PL/SQLscripts inDatawarehousing applications.
• Excellent experience working on Netezza and writing heavySQLqueries.
• Experienced in various Teradatautilities like Fastload, Multiload, BTEQ, and TeradataSQLAssistant.
• Expertise in writing SQLQueries, Dynamic-queries, sub-queries and complex joins for generating Complex StoredProcedures, Triggers, User-defined Functions, Views and Cursors.
• Experienced in Business Intelligence reports such as Tableua, TIBCO Spotfire, SAP Business Objects in generating various repotsand Dashboards.
• Experienced using MapReduce, and "Bigdata" work on Hadoop and other NOSQL platforms
• Excellent knowledge inDataValidation,DataCleansing,DataVerification and identifyingdatamismatch.

TECHNICAL SKILLS:

Database: NETEZZA, Teradata, Oracle, DB2

ETL Tools: Informatica Power Center 9x, 8x

DataModeling Tools: Erwin, Power Designer, ER Studio

Reporting Tools: Business Objects, Tableau, TIBCO Spotfire

Languages: PL/SQL, SQL, UNIX SHELL Scripting, C#.Net

Operating System: Windows XP/2000, UNIX

Version Control: PVCS, VSS,CVSSchedulers Dollar Universe, Cron Deployment Kintana

Others: MS Project, MS Office, Toad, SQL Developer, VI, Business Objects, SAS, Lotus Notes, WebEx

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr Data Analyst/Data Modeler

Responsibilities:

• Analysis of functional and non-functional categorized data elements for dataprofiling and mapping from source to target data environment.
• Presented thedatascenarios via, Erwin logical models and excelmockups to visualize thedata better.
• Used Erwinto create 3NF and dimensional data models and published to the business users and ETL / BI teams.
• 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.
• Wrote and executed unit, system, integration and UATscripts in a datawarehouse projects.
• Designed the ER diagrams, logical model (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 9.5
• Written complex SQLqueries for validating the data against different kinds of reports generated by BusinessObjects
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flatfiles, SQLServerwith high volume data
• Worked with ExcelPivottables.
• Delivered complex enterprise data solutions with comprehensive understandings in Architecture, Security, Performance, Scalability, and Reliability
• Profiled source data and meet regularly with IT partners to develop complete source to target data mappings and the database administration team to ensure data is mapped and handled correctly
• Written SQLscripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATAvalidation by writing several complexSQLqueries and Involved in back-end testing and worked with data quality issues.
• Resolveddataissues and updates for multiple applications using SQLqueries/scripts.
• Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business ObjectsXIR2, ETL Tools Informatica 9.5, Oracle 12c, Teradata V2R12, Teradata SQL Assistant 12.0

Confidential, Chicago, IL

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved inDatamapping specifications to capture source to target transformation rules.
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Performed Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
• Worked on identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Worked on developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Participate in weekly data analyst meting and submit weekly data governance status.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using tools like ERwin Data Modeler and also involved with Forward/Reverse Engineered Databases.
• Worked with designed & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Captured business requirements and rules, design the associated logical models, and created all required documentation to support, communicate, and validate the data model.

  Designed, built and maintained the logical and physical data models to support the business requirements in a dynamic, expanding business environment.

  Mapped data elements of data sources into the domain data models.

  Maintained documentation of data models, including relationships, constraints and metadata.

• Involved with metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Involved with performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning). Created, managed, and modified logical and physical data models using a variety of data modeling philosophies and techniques including Inmon and Kimball
• Logical and Physical design using both Ralph Kimball and Bill Inmon style data warehouse designs.

Environment: MS Excel, MS Access, Oracle 12c, UNIX, Windows7, SQL, PL/SQL, Power Designer, Informatica9.5, UNICA 6.4

Confidential, Boston, MA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snowflakeSchema.
• Reviewed ERDdimensionalmodel diagrams to understand the relationships and cardinalities to help in preparation of integrity test cases.
• Primary Data Analyst/Data Modeler performing Business Area Analysis and logical and physical data modeling for a Data Warehouse utilizing the Bill Inmon Methodology. Also designed Data Mart application utilizing the Star Schema Dimensional Ralph Kimball methodology.
• 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.
• Investigated data quality issues to determine root causes, resolve any data issues and recommended process change to prevent reoccurrence
• Proactively investigated database query log data to find opportunities to improve performance in OLAP and OLTP queries executing against the database
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Netezza
• Developed ER and Dimensional Models using PowerDesigner advanced features.
• Published and conducted model reviews with business and technical project teams.

  Reviewed database design changes with the team to determine the impact to the physical database and other systems.

  Coordinated with development/implementation team to improve model formats and approaches with regard to implementation issues.

• Created physical and logicaldatamodels using Power Designer.
• Used SQL on a wide scale for analysis, performancetuning and testing.

Environment: Erwin r9.0, SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Oracle 11g, Business Objects XI, Rational Rose,Datastage, MS Office, MS Visio, SQL, SQL Server 2008, Rational Rose, Crystal Reports 9

Confidential, Lincolnshire, IL

Sr. Data Analyst/Data Modeler

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and PhysicalDataModels.
• PerformedDatamodeling using Erwin. Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering ERWIN tool.
• Coordinateddataprofiling/datamapping with business subject matter experts,dataarchitects, ETLdevelopers, anddatamodelers.
• Used CAErwinDataModeler (Erwin) for data modeling of custom developed information systems, including databases of transactional systems and datamarts.
• Experience in creating UNIXscripts for file transfer and file manipulation.
• Used BETQto run and TeradataSQLscripts to create physicaldatamodel.
• Validated thedatain the 3NFdatamodel by manually executing the query through thedatamodels.
• Generated many datasets according to specifications by writing SQL queries for modeling purposes.
• Performed extensivedataanalysis to identify variousdataquality issues with thedatacoming from external systems
• Created PhysicalDataModel (PDM) and works closely with the application development team to implement required performance enhancement features (such as adding indexes, splitting tables) in PDM.

Environment: ER Studio, Informatica Power Center 7.1.2, Sybase, Windows, Toad, Oracle 9i, SQL Server 2000, SQL*Loader, AIX 5.0, Windows XP, Toad, SQL Server, Visio

Confidential, Alpharetta, GA

Data Analyst/Data Modeler

Responsibilities:

• Worked with project team representatives to ensure that logical and physical ER/Studiodatamodels were developed in line with corporate standards and guidelines.
• Enterprise MetadataLibrary with any changes or updates
• Worked on dataprofiling, cleansing, integration and extraction
• Implementation of Metadata Repository, Data Cleanup procedures, Transformations, DataStandards, DataGovernance program, Scripts, Stored Procedures, triggers and execution of test plans.
• Used Erwin to transformdatarequirements intodatamodels.
• Participated in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization
• Architect with an eye toward high performance, scalability, and high availability.
• Performed tuning of SQLQueries to improve the response time.
• Widely used Normalization methods and have done different normalizations (3NF)
• Involved in extensive Analysis on the Teradata and Oracle Systems.
• Acted as a StrongDataAnalyst analyzing thedatafrom low level.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Extensively used ER/Studio for developingdatamodel using star schemamethodologies.
• ConvertedDatastored in flat files into Oracle tables.
• Involved in extensive SQL Scripting.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects