SUMMARY:

• Over 8 years of working experience as DataModelerandDataAnalyst with high proficiency in requirement gathering anddatamodeling including design and support of various applications in OLTP,DataWarehousing, OLAP and ETL Environment.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL.
• Proficient indatamart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• Expertise in developing transactional enterprisedatamodels that strictly meet normalization rules, as well as EnterpriseDataWarehouses using Kimball and InmonDataWarehouse methodologies.
• Extensively experienced in using ER modeling tools such as ERwin and ER/Studio.
• Experienced in logical/physical database design and review sessions to determine and describedataflow anddatamapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good experienced indatatransformation,datamapping from source to target database schemas and alsodatacleansing.
• Expertise in Teradata utilities and administration work.
• Excellent experience working on Netezza, MongoDb, Cassandra and NoSQL databases for data modeling needs and administration
• Excellent experience with Hadoop ecosystems, data modeling with MDM based environments.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Provided support in Architecting and building Semantic reporting layer.
• Proficient in using Excel and MS Access to dump thedataand analyze based on business needs.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

DataModeling Tools: Erwin 9.5, 9.1,8.2, r7.1/7.2, Erwin R8, ER Studio and Oracle Designer, Sybase Power Designer, Oracle Designer, Rational Rose

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

ETL Tools: Informatica Power Center 9.6.1/9.5/8.6.1/8.1/7.1, Talend, Pantaho.

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

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

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Share point Portal Server

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

Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C++, AWK

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Data Analyst /Modeler

Responsibilities:

• Involved in logical and physical designs and transforming logical models into physical implementations.
• Developed in Star and Snow flake schema dimensionaldatamodels.
• Did extensive analysis ondata, profiled it before moving forward with building marts
• Worked on NoSQL databases.
• Worked on data modeling for MDM
• Created and maintained Metadata, including table, column definition.
• Document requirements for Semanticviews based on business needs.
• Develop, Maintain and update variousfor services Unixbased and Bash shell.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• 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 Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
• Designed flow diagrams which explain the process flow ofSemanticdevelopment.
• Developed mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel,dataflow and the expected output for each model created
• Developed the logicaldatamodels and physicaldatamodels that confined existing condition/potential statusdatafundamentals anddataflows using Erwin
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Useddataprofiling tools and techniques to ensuredataquality fordatarequirements.
• Used Star Schema and Snow flake schema methodologies in building and designing the logicaldatamodel in the dimensional Models.
• Developed Cleansing anddatamigration rules for the Integration Architecture (OLTP, ODS, DW).
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part ofDataAnalysis responsibilities.

Environment: Oracle 12c/11g, Teradata 14.10, Microsoft 2008, SQL Developer, SQL Manager, ER Studio, SQL DeveloperDataModeler, OracleDataIntegrator(ODI), SAP Business Objects, Informatica, Crystal Reports, ER Studio 9.1.0, Erwin r7.1, bash, Informatica 7.1.3

Confidential, Dublin, OH

Sr. Analyst /Data Modeler

Responsibilities:

• Developed, managed and validated existing data models including logical and physicalmodels of the data warehouse and source systems utilizing a 3NFmodel and dimensional data model.
• Integrateddatafrom variousDatasources like MS SQL Server, DB2, Teradata using Informatica to perform Extraction, Transformation, loading (ETL processes)
• Assist in semantic layer design and development of Semantic layer data model.
• Created datamasking mappings to mask the sensitive data between production and test environment.
• Used Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, Tpump on UNIX/Windows environments and running the batch process for Teradata.
• Performed data analysis and data profiling using complex SQL on various databases such as Oracle and Teradata.
• Written several shell scripts using UNIXKorn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Utilized Erwin's forward/reverse engineering tools and target database schema conversion process.
• Worked on data modeling and produced data mapping and data definition specification documentation.
• Extensively completed data quality management using information steward and did extensive data profiling.
• Wrote simple and advanced SQL queries and scripts to create standard and ad hoc reports for senior managers.

Environment: Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, SAP Logon, Erwin 8.0, Informatica, Business Objects XI, Teradata SQL Assistant, ER Studio 9.1.0, Unix, Linux

Confidential, Seattle, WA

Sr. Data Analyst / Data Modeler

Responsibilities:

• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and PhysicaldataModels
• Worked on creating data dictionary and metadata in Erwin and generated various reports.
• Responsible for understanding the use cases and business rules and make the appropriate changes to thedatamodel.
• Involved with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin tool.
• Reduce data duplication by eliminating Oracle ODS layer by combining staging,3NF-Core & Semantic Layer, multiple uses of data loaded one time for reporting, ad-hoc queries and visual analysis
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Used Erwin to transformdatarequirements intodatamodels.
• Extensively used both Star Schema and Snow flake schema methodologies in building and designing the logicaldatamodel in both Type1 and Type2 Dimensional Models.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for the MasterDataManagement Architecture involving OLTP, ODS.
• Served as a member of a development team to provide businessdatarequirements analysis services, producing logical and Physicaldatamodels using Erwin
• CreatedDataDefinitions and the MetaDataRepository
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Designed STAR schemas by identifying the facts, dimensions, measures and involving shared dimensions (Conformed) in ERWIN.
• Extensively used the Erwin design tool &Erwin model manager to create and maintain the DataMart.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables

Environment: Erwin 9/8/r7.0,DataStage, DB2 UDB, SQL Server, Sybase, Windows NT, Linux, Sun Solaris, T-SQL, SQL, SQL SQL, PL/SQL Developer 5.1,Sun Solaris8.0, Erwin

Confidential, Durham, NC

Data Modeler/Analyst

Responsibilities:

• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Databasetriggers, StoredProcedures) in thedatamodel.
• Actively involved in creating Physical and Logical models using Erwin.
• Presented thedatascenarios via, Erwin logical models and excel mockups to visualize thedatabase.
• Worked on building thedatamodel using ER Studio as per the requirements, discussion and approval of the model from the BA.
• Involved withDataAnalysisPrimarily IdentifyingDataSets, SourceData, Source MetaData, DataDefinitions andDataFormats
• Designed and Developed logical & physicaldatamodels and MetaDatato support the requirements using Erwin
• 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
• Involved withDataProfiling activities for new sources before creating new subject areas in warehouse
• Tested the ETL process for both beforedatavalidation and afterdatavalidation process. Tested the messages published by ETL tool anddataloaded into various databases
• Experienced in creating UNIX scripts for file transfer and file manipulation.
• Developed ER and Dimensional Models using Power Designer advanced features. Created physical and logicaldatamodels using Power Designer.
• Used Expert level understanding of different databases in combinations forDataextraction and loading, joiningdataextracted from different databases and loading to a specific database.

Environment: DB2, CA Erwin 7.0, Oracle 11g, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, ERwin r8.0 and Erwin r9.0, MS-Office, SQL Server 2008/2012.