SUMMARY

• Over 8 years of experience in Data Analysis, Data modeling, Data Development, Implementation and Maintenance of databases and software applications with Fortune companies.
• Experienced in SQL queries and optimizing the queries in Oracle, SQL Server, DB2, and Netezza & Teradata.
• Experienced in Dimensional and Relational Data Modeling using Star and Snowflake Schemas, OLTP/OLAP system, Fact and Dimension tables, Conceptual, Logical and Physical data modeling using Erwin and ER/Studio.
• Good knowledge of Data Marts, Operational Data Store (ODS), Dimensional Data Modeling with Ralph Kimball Methodology (StarSchemaModeling,Snow - FlakeModeling for FACT and Dimensions Tables) using Analysis Services.
• Experienced in designing theConceptual,Logicaland Physicaldatamodeling using Erwin and ER Studio,Datamodeling tools.
• Experience with big data concepts such as Hadoop and views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Experienced in Database Creation and maintenance of physicaldatamodelswith Oracle, Teradata, Netezza, DB2 and SQL Server databases.
• Experienced in Normalization (1NF, 2NF, 3NF and BCNF) De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Experienced in working with Sybase Power Designer for creating conceptual data modelwith entities, attributes, and relationships.
• Experienced in Client-Server application development usingOraclePL/SQL, SQL PLUS, SQL Developer, TOAD, SQL LOADER.
• Experienced in dataextraction from flat files, Excel files, OLE database source todatawarehouse, packages were created using MS SQL Server Integration Services (SSIS).
• Experienced in Metadata design, real time BI Architecture includingDataGovernance for greater ROI.
• Experienced in Database using Oracle, XML, DB2, Teradata, Netezza, SQL server, BigDataand NoSQL.
• Experienced in working with Teradata Utilities like Fast load, Multi load, Tpump and Fast Export Teradata Query Submitting and processing tools like Teradata SQL Assistant (Query man).
• Experienced in SSIS programming module to code several SSIS packages by using many programming languages.
• Experienced in data from various sources like Oracle, Mainframes, and flat files and loaded into the target Netezzadatabase.

TECHNICAL SKILLS

Analysis and Modeling Tools: Erwin 8.0, r9.6, r9.5, 9.1, Sybase Power Designer, Oracle Designer, ER/Studio.

ETL Tools: Informatica Power Center, Data Stage, Ab Initio.

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, DB2 V9.5, Teradata, MS Access 2000

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

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

OLAP Tools: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9.

Database Tools: Microsoft SQL Server 2014/2012/2008/2005, Teradata, and MS Access, Poster SQL, Netezza, SQL Server, Oracle.

Reporting Tools: Business Objects, Crystal Reports

Operating Systems: Microsoft Windows 9x / NT / 2000/XP / Vista/7 and UNIX Windows 95, 98, Windows NT, Windows XP, 7.

Big Data: Hadoop, HDFS 2, Hive, Pig, HBase, Sqoop, Flume.

PROFESSIONAL EXPERIENCE

Sr. Data Modeler/Data Analyst

Confidential, Gardner, KS

Responsibilities:

• CreatedLogicalDataModelfrom theConceptualModeland its conversion into the Physical database design Erwin r9.6.
• Involved in integration of various relational and non-relational sources such as DB2, Teradata, Oracle 12c, Netezza, SQL Server 2014, XML and Flat Files.
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies.
• Performed the mapping effort for various development teams by mapping their application data requirements to the model and providing consistent standardized language for communication between the development teams.
• Gathered and analyzed existing physical data models for in scope applications and proposed the changes to the data models according to the requirements.
• Provided recommendations and improvements to the Data Model based on the analysis from the mapping effort.
• Performed the Data Modeling effort for the gaps identified while data mapping.
• Extensively used Star Schema and Snowflake Schema methodologies in building and designing theLogicalDataModelinto DimensionalModels.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata 15.
• Involved inDataloading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS).
• Coordinated with development team to convert SQL scripts (Source to target transformation logics) into Pig Script (Hadoop).
• Generated DDL Scripts in HIVE and TD using the Model design tool (Power Designer) for the core tables.
• Refined the existing model resulting from project teams mapping their data requirements for existing systems to the data models as a part of the SDLC project methodology.
• Perform Data Profiling and Data Quality Analysis to analyze and to support devising data quality controls using Data Flux. (Valid value ranges, relationships between data elements, business rules & reasonability checks)
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.
• Worked with data from various sources like flat files,Netezza, XML files, Oracle and loaded into Enterprise data ware house.
• Involved in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Involved in several facets of MDM implementations includingDataProfiling, Metadata acquisition anddatamigration.
• Worked with Oracle, DB2,Netezzaand SQL Server databases, SQL Loader, Tuning, import/export, T-SQL.
• Involved in DataModel, database physical design, ETL design, and Presentation layer design.

Environment: Erwin r9.6, Data Modeler, Hive, Hadoop, Pig, Netezza, Oracle12c, Taradata15, Ralph Kimball, T-SQL, SQL Server 2014, DB2, ETL, SSIS, ERWIN r9.6, MDM, PL/SQL, Microsoft Access, Microsoft Visio

Sr. Data Modeler/Data Analyst

Confidential, Omaha, NB

Responsibilities:

• Involved in documentation ofDataModeler/Data Analyst and ETL specifications forDatawarehouse using Erwin r9.5.
• Managed, designed, and created the star schema and Snowflake Schema for a financialdatamart using Erwin and DB2 using Ralph Kimball dimensional modeling techniques.
• Involved in integration of various data sources like Oracle 11g, IBM DB2, MS SQL Server 2012, My SQL, Teradata 14.1,Netezza, XML files, Mainframe sources into staging area and different target databases.
• Created ERD diagrams using Open Sphere Model and implemented concepts likeStar-Schema Modeling, SnowflakeSchemaModeling, Fact and Dimension tables.
• Worked closely with the ETL, SSIS Developers to explain the complexDataTransformation using Logic.
• Worked on MasterDataManagement (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Involved in building and maintaining Data marts, Fact Tables, Dimensions and joined them to extract meaningful data.
• Coordinated with DBA's in creating and managing Tables, Indexes, Table spaces, Sequences, Views and Materialized Views.
• Worked with different data sources like flat files, Netezza, XML, Teradata, DB2, and Oracle.
• Involved inNormalization/De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool
• Worked with high volume datasets from various sources like SQL Server 2012, Oracle, DB2, and Text Files T-SQL.
• Worked on Teradata SQL queries, Teradata Indexes, MDM Utilities such as Mload, Tpump, Fast load and Fast Export.
• Created data dictionaries for various data models to help other teams understand the actual purpose of each and every table and its columns.
• Involved in Troubleshooting and quality control of data transformations and loading during migration from Oracle systems intoNetezzaEDW.
• Implemented metadata standards, data governance, master data management, ETL, data warehouse, data marts, reporting, dashboard, analytics, segmentation and predictive modeling.
• Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL.

Environment: Data Modeler, Netezza, Oracle11g, Taradata14.1, T-SQL, SQL Server 2012, DB2, SSIS, ERWIN r9.5, MDM, PL/SQL

Sr. Data Modeler/Data Analyst

Confidential - Monterey, CA

Responsibilities:

• Designed in Conceptual Data Model, Logical Data Model and Physical Data Model using Erwin8.5
• Involved in database and highly skilled SQL, Oracle 10g, MS SQL Server 2008, DB2, Teradata 14, Netezza, Sybase, Mainframe Files, Flat Files, CSV files, MS Access.
• Involved in designing the data warehouse using Ralph Kimball's and Bill Inmon techniques.
• DevelopedLogicaland Physicaldatamodelsthat capture current state/future statedata elements anddataflows using ER Studio / Star Schema and Snowflake Schema.
• Involved in administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Created Logical and Physical Model and assigning Parent to Child identifying relationships and Transformation and reverse engineering using ETL tool and generate crystal reports.
• Used various transformations in Informatica mappings to reflect the logics involved inNetezza stored Procedures.
• Involved in relational and dimensionalDataModeling for creatingLogicaland Physical design of the database and ER diagrams usingdatamodeling tools like Erwin
• Used BTEQ script to create a sample tables. Redefine the partitioning of a populated table.
• 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
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in the integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, DB2,Netezza, Teradata, XML and Flat Files (fixed width, delimited).

Environment: Erwin9.1, Taradata14, Data Modeler, Netezza, Oracle10g, SSIS, T-SQL, SQL Server 2008, DB2, SSIS, MDM, PL/SQL, ETL, Informatica Power Center 9.6 etc.

Sr. Data Modeler/Data Analyst

Confidential, Chicago, IL

Responsibilities:

• Involved in developing Database Design Document includingDataModelConceptual, Logicaland PhysicalModelsusing Erwin r8.5.
• Involved in OLAP model based on Dimension and FACTS for efficient loads of data based onStarSchema structure on levels of reports using multi-dimensional models such asStarSchemasandSnow Flake Schema for developing Cubes using MDM.
• Used Data warehousing for Data Profiling to examine the data available in an existing database and also created Data Mart.
• Used SSIS and T-SQL stored procedures to transferdatafrom OLTP databases to staging area and finally transfer intodatamarts.
• Extensively used Erwin and Normalization and De-normalization Techniques to design Logical and Physical Data Models, relational database design.
• Designed configurations, MDM, logging/auditing, package error handling,dataerror logging and checkpoint in SSIS Packagemodel.
• Worked in RDBMS concepts Oracle 9i, PL/SQL, SQL plus, SQL Loader, Teradata 13.1, IBM DB2,Netezza, MS SQL Server 2005.
• Involved in data from various Source Systems like Oracle, SQL Server and Flat Files as per the requirements.
• Conducted the UAT using the approved test Scenarios for the finished units
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Worked with NZ Load to load flat file data intoNetezza, DB2 and Architect to identify proper distribution keys forNetezzatables.
• Loaded multi format data from various sources like flat-file, Excel, MS Access, and Oracle using Netezza and performing file system operation.
• Involved in creating database objects like Tables, Views, Materialized Views, Triggers, Functions and Indexes etc.
• Conducted Learning sessions for business users, analysts, QA team to provide insight into data model and providing documentations.
• Responsible for understanding the design and structure of different databases and writing ad-hoc queries for data mining using different data mining tools

Environment: Erwin8.5, Netezza, Oracle9i, Taradata13.1, Data Modeler, T-SQL, SQL Server, DB2, SSIS, MDM, PL/SQL, ETL, etc.

Data Modeler/Data Analyst

Confidential - Dallas, TX

Responsibilities:

• Extensively used SQL forDataAnalysis and to understand and documenting thedatabehavior within and between two companies Erwin r8.x.
• Involved in requirement Analysis, ETL design and development for extractingdatafrom the source systems like Teradata 13, DB2, Sybase, Oracle 8.x, flat files and loading into Netezza.
• Involved inDataAnalysis,DataMigration,DataCleansing, Transformation, Integration, Data Import, andDataExport through the use of multiple ETL tools such as Ab-Initio
• Worked onNormalizationandDe-Normalizationtechniques for both OLTP and OLAP systems.
• UsedNetezzaSQL to maintain MDM frameworks and methodologies in use for the company and also accessedNetezzaenvironment for implementation of ETL solutions.
• Involved in DataAnalysis,DataProfiling,DataMigration,Data Integration and validation of data across all the integration points.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Involved inNormalization/Demoralization techniques for effective and optimum performance in OLTP and OLAP environments.
• Designed both 3NFDatamodelsfor DB2 systems and dimensionalDatamodelsusing Star and Snowflake Schemas.
• Involved in updating metadata repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for sales Data mart.
• Provided maintenance support to customized reports developed in Crystal Reports

Environment: ERWIN8.x, Data Modeler, Netezza, Oracle8.x, SQL, PL/SQL, Taradata13, T-SQL, SQL Server, DB2, SSIS, MDM, PL/SQL