SUMMARY

• Over 8 years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Excellence in delivering Quality Conceptual, Logical and PhysicalDataModels for Multiple projects involving various Enterprise New and Existing Applications andData Warehouse.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional andData Warehouse environments.
• 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 EnterpriseData Warehouses using Kimball and InmonData Warehouse methodologies.
• Extensive experienced in using ER modeling tools such as Powerdesigner, 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.
• Experienced indatatransformation,datamapping from source to target database schemas and alsodatacleansing.
• Used Teradata Fast Load utility to load large volumes ofdatainto empty Teradata tables in the Datamart for the Initial load.
• Used Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Experienced 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

Data Modeling Tools: Erwin 9x/8x/7x, ER Studio, Power Designer

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

ETL Tools: Talend, Pentaho, Informatica 9x,8x,7x

Programming Languages: SQL, T-SQL, Unix script

Database Tools: Microsoft SQL Server, Teradata, Netezza, Oracle 12c/11g/10g/9i, and MS Access

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

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

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

PROFESSIONAL EXPERIENCE

Confidential, Iowa City, IA

Sr. Data Analyst /Modeler

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization
• Worked on analysis ondata, profiled it before moving forward with building marts
• Worked on the Payment business mart which basically generated report of payments done by customers in various facilities
• Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
• 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
• Developed mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Coordinated with BI, ETL Developers, Project Manager and end users in understanding theDataModel,dataflow and the expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Involved in fulfilling all the end users request which fell under the general maintenance work such as adding and removing columns and tables fromdatabase not without the prior approval from BA's andDataModeling Team
• Developed the logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Facilitated JAR/JAD sessions to determinedatadefinitions and business rules governing thedata, and facilitated review sessions with subject matter experts (SMEs) on the logical and physicaldatamodels.
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata.
• Useddataprofiling tools and techniques to ensuredataquality fordatarequirements.
• Extracteddatafrom the databases (Oracle and SQL Server) using Informatica to load it into a singleData Warehouse repository of Teradata
• Developed Cleansing anddatamigration rules for the Integration Architecture (OLTP, ODS, DW).
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
• Transformed requirements intodatastructures which can be used efficiently to store manipulate and retrieve information.

Environment: Oracle 11g, Teradata 13.10, Microsoft 2008, SQL Developer, SQL Manager, ER Studio, Visio, SAP Business Objects, Informatica, Crystal Reports, ER Studio 9.1.0

Confidential, Chicago, IL

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Indulge in Power designer tool, Informatica (Repository Manager, Designer and Workflow Manager.
• Involved with dataprofiling 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.
• Expertise and worked on Physical, logical and conceptual data model
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas
• Wrote and executed unit, system, integration and UAT scripts in a Data Warehouse projects.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Used DDL and DML to writing triggers, stored procedures to check the data entry and payment verification
• Experienced in source to target data mapping using Data lineage technique and also calculating the impact on the data flow using Impact Analysis.
• Worked and experienced on Star Schema, DB2 and IMS DB.
• Perform data reconciliation between integrated systems.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Assisted in the oversight for compliance to the Enterprise Data Standards, data governance and data quality
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files,SQL Server 2005 with high volume data.
• Starting and stopping DB2 subsystems.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts 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 data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Analysis on Mainframe data to generate reports for business users.
• Identify & record defects with required information for issue to be reproduced by development team.

Environment: PL/SQL, Business Objects XIR3, ETL Tools Informatica9.5/8.6/9.1 Oracle 11G, Teradata V2R12/R13, Teradata SQL Assistant 12.0,DB2

Confidential, Iselin, NJ

Sr. Analyst /Data Modeler

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization
• Did extensive analysis ondata, profiled it before moving forward with building marts
• Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
• Created and maintained Metadata, including table, column definitions
• Generated a separate MRM document with each assignment and shared it on SharePoint along with the PDF of updateddatamodels
• Created DDL scripts for implementingDataModeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, PublishedDatamodel in model mart, created naming convention files, co-coordinated with DBAs' to apply thedatamodel changes.
• Used Model Mart of Erwin r9 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
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel,dataflow and the expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository
• Extensively used Erwin as the main tool for modeling along with Visio
• Developed the logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata.
• Extensively used SQL for performance tuning.
• Developed and executed queries in SQL for reporting using SQL Manager
• Used Star Schema and Snow flake schema methodologies in building and designing the logicaldatamodel in the dimensional Models.
• Assisted developers, ETL, BI team and end users to understand thedatamodel.

Environment: Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, Erwin 8.0, Visio, Informatica, Business Objects XI, Teradata SQL Assistant, Informatica8.6.1, UNIX

Confidential, Minneapolis, MN

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.
• Designed an Industry standarddataModel and Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
• Created a high-level industry standard, generalizeddatamodel to convert it into logical and physical model at later stages of the project using Erwin and Visio
• Involved with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin tool.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• DevelopedDataMapping,DataGovernance, transformations and cleansing rules for the MasterDataManagement Architecture involving OLTP, ODS.
• CreatedDataDefinitions and the MetaDataRepository
• Worked with third partydatabase to store the requireddatafor the client (Remedy A R Systems)
• Exploreddatato identify its model role and measurement level. Verifieddatafor missing values and incorrectdata. And then cleaned and structured thedatabased on the format required.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• 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
• Used Star schema methodology in building and designing the logicaldatamodel in the dimensional Models.
• Created use cases, class diagrams, sequence diagrams anddataflow diagrams using Rational Rose and Visio for new procedures that would help improve existing processes.

Environment: Erwin, Rational Requisite Pro,DB2 UDB, SQL Server, Oracle, PL/SQL Developer, Sun Solaris8.0

Confidential

Data Modeler/Analyst

Responsibilities:

• Actively involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Databasetriggers, StoredProcedures) in thedatamodel.
• Involved withDataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData, DataDefinitions andDataFormats
• Designed and Developed logical & physicaldatamodels and MetaDatato support the requirements using Power Designer
• 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 Power Designer
• 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.
• Successfully created and managed a conversion testing effort which included adataquality review, two system test cycles, and user acceptance testing.
• Used Expert level understanding of different databases in combinations forDataextraction and loading, joiningdataextracted from different databases and loading to a specific database.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: DB2, CA Erwin 7.0, Oracle 11g, VISIO, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, MS-Office, SQL Server, VISIO