SUMMARY

• Over 8+ years SeniorDataModeler/Data Analyst of experienced inDataAnalysis and modeling, wif excellent understanding of DataWarehouse and DataMart designing.
• Excellent noledge in Database Creation and maintenance of physicaldatamodels wif Oracle, Teradata, Netezza, DB2 and SQL Serverdatabases.
• Experienced in Data Analysis on Oracle12c, MS SQL Server &MS Access wif sound noledge in extraction of data from various database sources like Oracle, MS SQL Server, DB2 and Flat files into teh Data Stage.
• Experienced in Dimensional and RelationalDataModeler using Star Schema/Snowflake Modeling, Fact and Dimension Tables, and Physical and LogicalDataModeling.
• Experienced indatafrom various Database sources like Oracle, SQLServer, Netezza, DB2, and Teradata.
• Experienced in working wif Database tool TOAD, SQL Loader,Netezza, Fast Load, Multi Load,NetezzaManager, CLI, ODBC etc.
• Very good noledge wif Teradata15/14, Oracle 12c, Netezza databases wif strong SQL scripting and extensive experience in using Database tools such as SQL Workbench, OracleSQLDeveloperand Teradata SQL assistant.
• Experienced in integration of various data sources like Oracle IBM DB2, MS SQL Server2014/2012, My SQL, Teradata,Netezza, XML files, Mainframe sources into staging area and different target databases.
• Experienced in integration of various relational and non - relational sources such as DB2, Teradata, Oracle, SFDC, Netezza, SQL Server, COBOL, XML and Flat Files, to Netezza database.
• Experienced in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Experienced in Extracting, Transforming and Loading (ETL) data using SSIS creating.
• Experienced in Designing Star Schema (identification of facts, measures and dimensions), Snowflake Schema for Data Warehouse,ODS architecture by using tools like Data Model, E-R Studio.
• Experienced in SQL and good noledge in PL/SQL programming and developed Stored Procedures and Triggers and Data Stage, DB2, UNIX, Cognos, MDM, UNIX, Hadoop, Pig.
• Experienced in Data Modeling including Data ValidationScrubbingand Operational assumptions.
• Good noledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.
• Experienced on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and Fast Export.

TECHNICAL SKILLS

DataModeling Tools: Erwin r9.6/r9.5/r9.1/8.X, ER Studio and Oracle Designer.

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

Oracle: Oracle 12c/11g/10g/9i, R2 database servers wif RAC, ASM, Data Guard, Grid Control and Oracle Gloden Gate(Oracle Enterprise Manager),Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, AWR,ASH, ADDM, Explain Plan.

ETL Tools: SSIS, Informatica Power Center 9.6/9.5/9.1.

Programming Languages: Java, Base SAS and SAS/SQL, SQL, T-SQL, HTML, Java Script, CSS, UNIX shells scripting, PL/SQL.

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

Web technologies: HTML, DHTML, XML, JavaScript

Reporting Tools: Business Objects, Crystal Reports

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

Tools: & Software: TOAD7.1/6.2, MS Office, BTEQ, Teradata SQL Assistant

Other tools: TOAD, SQL *PLUS, SQL*LOADER, MS Project, MS Visio and MS Office, Has worked on C++, UNIX, PL/SQL etc.

PROFESSIONAL EXPERIENCE

Sr. Data Modeler/Data Analyst

Confidential, Malvern PA

Responsibilities:

• Collaborates wif cross-functional team in support of business case development and identifying modeling method(s) to provide business solutions. Determines teh appropriate statistical and analyticalmethodologies to solve business problems wifin specific areas of expertise.
• Builds models and solves complex business problems where analyses of situations and/or data require in-depth evaluation of variable factors.
• GeneratingDataModels using Erwin9.6 and developed relational database system and involved in Logical modeling using teh Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Participate in documenting teh data governance framework including processes for governing teh identification, collection, and use of data to assure accuracy and validity.
• Involved in creating informatica mapping to populate staging tables and data warehouse tables from various sources like flat files DB2,Netezzaand oracle sources.
• Involved in loading thedatafrom teh flat files submitted by vendors into teh Oracle12c External tables, extensively used ETL to loaddatafrom Oracle database, XML files, and Flat filesdataand also used importdatafrom IBM Mainframes.
• Created MDM,dataarchitecture, analyticaldatamarts, and cubes optimized for reporting.
• Coordinated wif Data Architects and Data Modelers to create new schemas and view in Netezza for to improve reports execution time, worked on creating optimized Data-Mart reports.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Worked in NoSQLdatabase on simple queries and writing Stored Procedures fornormalizationand de-normalization.
• Designed Physical Data Model (PDM) using Erwin data modeling tool and ORACLE PL/SQL.
• Developed LINUXShell scripts by using NZSQL/NZLOAD utilities to load data from flat files to Netezzadatabase.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extensively used SQL Server2014 tools to develop Oracle stored packages, functions and procedures for Oracle database back-end validations and Web application development.
• Perform analyses such as regression analysis, logistic regression, discriminant analysis, cluster analysis usingSAS programming.
• Worked wif various Teradata15 tools and utilities like Teradata Viewpoint, Multi Load, ARC,Teradata Administrator,BTEQ and other Teradata Utilities.

Environment: Erwinr9.6, Oracle 12c, Teradata15, SQL Assistance, Netezza, PL/SQL, T-SQL, MDM, Data Stage, DB2 UDB, SQL Sever2014,BTEQ, Normalization/De-normalization, Physical & Logical data modeling, StarSchema/SnowFlakeschema etc.

Sr. Data Modeler/Data Analyst

Confidential, Teaneck, NJ

Responsibilities:

• Gathered Functional Requirements from Data ModelingAnalysts andDesigned and developed ETL mappings to Extract and LoadDatafrom variousDataSources (Flat files, relational tables).
• Worked wif IT and teh business to ensure consistency in data definitions and data usage across systems and tools.
• Supported in-solution development by leveraging infrastructure architecture standards, practices, assets and frameworks
• Implemented dimension model (logical and physical data modeling) in teh existing architecture using Erwin9.5.
• Designed Source to Target mapping from primarily Flat files, SQL Server, Oracle,Netezzausing Informatica Power Center9.5.
• Performed Data Analysis tasks on warehouses from several sources like Oracle11g, DB2, and XML etc and generated various reports and documents.
• Worked onNormalizationandDe-Normalizationtechniques for both OLTP and OLAP systems.
• Worked on Data Modeling using Dimensional Data Modeling, Star Schema/Snow Flake schema, and Fact & Dimensional, Physical & Logical data modeling.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database, Involved in analysis, development, testing, implementation and deployment.
• Organize & co-manage research projects in research related activities, including literature review, database creation & maintenance, data collection & cleaning, multivariate analysis using SAS, Tableau and MS Excel
• Worked in teh capacity of ETL Developer (Oracle Data Integrator (ODI) / PL/SQL) to migrate data from different sources in to target Oracle Data Warehouse.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata14.1Database.
• Built and maintained SQL scripts, indexes and complex queries for data analysis and extraction.
• Involved in Troubleshooting and quality control of data transformations and loading during migration from Oracle systems intoNetezzaEDW.
• Developed, managed and validated existingDataModels including Logical and Physical Models of theDataWarehouse and source systems utilizing a 3NFmodel.
• Involved in working wif Terabyte Size Source Target Databases likeNetezza& Teradata.
• Worked in ETLdeveloperwif design and development of Extract, Transform and Load processes for data integration projects to build data marts.

Environment: Erwin9.5, Normalization and De-Normalization, UNIX, Taradata, MDM (Master Data Management), Star and Snow Flake DDL, PL/SQL, ETL, DB2, Associated Data Marts, Data Stores, DB2, Oracle11g and Teradata14.1, Informatica Power Center9.7etc.

Sr. Data Modeler/Data Analyst

Confidential, Guilford, CT

Responsibilities:

• Createdconceptual,logicaland physical relationalmodelsfor integration and base layer; created logicaland physical dimensionalmodelsfor presentation layer and dim layer for a dimensionaldata warehouse in ERwin9.1.
• Analyzing, designing, developing, implementing and maintaining ETL jobs using IBM Info sphere Data stage andNetezza.
• Worked in development and maintenance using OracleSQL,PL/SQL,SQLLoader, Informatica Power Center.
• Worked wif BTEQ to submit SQL statements, import and exportdata, and generate reports in Teradata.
• Reviewed teh conceptual EDW (EnterpriseDataWarehouse)DataModel wif business users, App Dev and Information architects to make sure all teh requirements are fully covered.
• Worked wif teh UNIX team and installed TIDAL job scheduler on QA and ProductionNetezza environment.
• Coordinated wif DB2 on database build and table normalizations and de-normalizations.
• Conducted brain storming sessions wif application developers and DBAs to discuss about various demoralization, partitioning and indexing schemes for Physical Model.
• Responsible for designed Conceptual, Logical and Physical Data Models for Data Warehouse (ELDM Project), Data Mart (LSDM Project), Operational Data Store (Delivery ODS Project), 3NF Model (ADS Project).
• Identified & suggested potential business directives to upper management and sales team by creating monthlyfeedback reports and conducting customer-satisfaction surveys
• Efficiently used Microsoft Excel and database tools to analyze, summarize and manipulate large data sets.
• Performed data analysis, statistical analysis, generated reports, listings and graphs usingSAStools, SASIntegration Studio,SAS/Graph,SAS/SQL,SAS/Connect andSAS/Access.
• Involved in several facets ofMDMimplementations including Data Profiling, metadata acquisition and data migration.
• Extensively used SQL Loader to load data from teh Legacy systems into Oracledatabases using control files and used Oracle External Tables feature to read teh data from flat files into Oracle staging tables.

Environment: ERwin9.1, Taradata14, Oracle11g, PL/SQL, UNIX, TIDAL, Normalization and De-normalization, Informatica Power Center9.6, MDM, SQL Server, Netezza, DB2, Star schema and Snow Flake schema, Architecture, SAS/Graph,SAS/SQL,SAS/Connect andSAS/Access, EDW (EnterpriseDataWarehouse) etc.

Sr. Data Modeler/Data Analyst

Confidential, Raleigh, NC

Responsibilities:

• Performed Reverse Engineering of teh current application using ERwin8.x, and developed Logical and PhysicalDataModels for CentralModel consolidation.
• Involved in integration of various relational and non-relational sources such as DB2, Teradata13, Oracle, SFDC, Netezza, SQL Server, COBOL, XML and Flat Files.
• Involved inNormalization/De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
• Worked on Key performance Indicators (KPIs), design ofstar schema and snowflakeschemain Analysis Services (SSAS).
• Responsibled for determining teh bottlenecks and fixing teh bottlenecks wif performance tuning usingNetezzaDatabase.
• Utilized Data Modeling tools, including ERWIN, to Conduct Conceptual/Logical Database Design, Conducted Database Design and Implementation of a number of web-based Standard Management.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Worked wif teh UNIX team and installed TIDAL job scheduler on QA and Production Netezza environment.
• Developed teh code as per teh client's requirements usingSQL,PL/SQLand Data Ware housing concepts.
• Involved in several facets ofMDMimplementations including Data Profiling, metadata acquisition and data migration.
• Documented ER Diagrams, Logical and Physical models, business process diagrams and process flow diagrams.
• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracledatabase environments.

Environment: ERwin8.x, Taradata13, Oracle9i, PL/SQL, UNIX, TIDAL, Normalization and De-normalization, Informatica Power Center9.6, MDM, SQL Server, Netezza, DB2, Star schema and Snow Flake schema, Architecture, SAS/Graph,SAS/SQL,SAS/Connect andSAS/Access, SQL Server2012 etc.

Data Analyst

Confidential 

Responsibilities:

• Involved in creating logical and physicaldatamodeling wif STAR and SNOWFLAKE schema techniques using ErwininDatawarehouse as well as inDataMart.
• Worked in database objects like tables, views, materialized views, procedures and packages using Oracletools like Toad,PL/SQLDeveloperand SQL plus.
• Involved in physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema,Snow-Flake, FACT, and Dimensions), Entities, Attributes, OLAP, OLTP, Cardinality, and ER Diagrams.
• Developed control files forSQL Loader andPL/SQLprograms for loading and validating teh data into teh Database.
• Created Stored Procedures in both SQL Server andDB2and involved in several DTS.
• Created Mappings for Initial load from MS SQL server toNetezzawhile performing data cleansing.
• Created various transformation procedures by usingSAS,ETL andSASEnterprise guide.
• Involved in Data Modeling of both Logical Design and Physical Design of Data Warehouse and data marts inStarSchemaandSnowFlakeSchemamethodology.
• Converted SQL Server2008, DTS packages to Informatica Power Center mapping to be used wifNetezza.
• Involved in InformaticaMDMprocesses including batch based and real-time processing.
• Responsible for reviewingdatamodel, database physical design, ETL design, and Presentation layer design.

Environment: ERwin, Informatica Power Center, MDM, ETL, Taradata SQLs, PL/SQL, Netezza, DB2, Oracle, Normalization / De-normalization, Star Schema and Snow Flake Schema, TOAD, ETL, Meta Data, SQL Server2008 etc.