SUMMARY:

• Over 9+ years of strong experience in Business and Data Analysis, Data architecture Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration, MDM, NoSQL and Metadata Management Services and Configuration Management.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non - relational databases.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Experienced in designing star schema (identification of facts, measures and dimensions), Snowflake schema forDataWarehouse,ODS Architecture by using tools like ErwinDataModeler, Power Designer, E-R Studio and Microsoft Visio.
• Experienced inDataModeling retaining concepts of RDBMS, Logical and PhysicalDataModeling until 3NormalForm (3NF) and MultidimensionalDataModeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).
• Experienced inDataAnalysis,DataMigration,DataCleansing,Transformation, Integration,DataImport, andDataExport through the use of multiple ETL tools such as AbInitio and InformaticaPower Center.
• Good exposure to architecting & solutioning the IT applications for business needs starting from creating logical/functionalarchitecturediagrams, physicalarchitecturediagrams & sequence diagrams.
• Focus on Organization, Client Relations and Process Improvements.
• Proficient in Gathering Requirements, Business Case Development to Rollout, Production and Maintenance with a solid understanding of Business Processes and analyzing them and documenting.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Expertise in documenting the Business Requirements Document (BRD), generating the UAT Test Plans, maintaining the Traceability Matrix and assisting in Post Implementation activities.
• Expertise in SQL queries, PL/SQL Packages, SQL Plus, Stored Procedures, Functions, Triggers and Performance Analysis, Creating Partitions, Indexes, Aggregating tables when required.
• Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/ SQL Server/DB2.
• Knowledge on Service Oriented Architecture (SOA), Rest web services using XML, JSON, SOAP, XSD and WSDL, XmlBeans.
• Designed data marts using Ralph Kimball and Bill Inmon dimensional data modeling techniques.
• Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing the model.
• Experience in RDBMS (Oracle) PL/SQL,SQL, Stored Procedures, Functions, Packages, Triggers.
• Worked with Terra bytes of Volume databases.
• Experience in Dimensional Modeling and Data Warehouse. ETL tools Informatica /Data Stage/BI tools such as Business Objects. Star& Snow Flake Schemas.
• Extensive experience in using ER modeling tools such as ERwin and ER/Sudio.
• Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin R6/R9, Rational System Architect, IBM Infosphere Data Architect, ER Studio and Oracle Designer

Database Tools: Microsoft SQL Server12.0, Teradata 15.0, Oracle 11g/9i, and MS Access

BI Tools: Tableau 7.0/8.2, Tableau server 8.2, Tableau Reader 8.1,SAP Business Objects, Crystal Reports Packages Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server

Version Tool: VSS, SVN, CVS.

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

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

Operating System: Windows, Unix, Sun Solaris

ETL/Datawarehouse Tools: Informatica 9.6/9.1/8.6.1/8.1, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau 8.2, Pentaho

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

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

RDBMS: Microsoft SQL Server14.0, Teradata 15.0, Oracle 12c/9i, and MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, MI

Sr. Data Architect/Modelerxr

Responsibilities:

• Actively involved in the Design and development of the Star schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes TEMPeffectively.
• Worked asarchitectfor Rapid Exposure Drill application, a highly mission critical and time sensitive app to determine
• Developed SQL, BTEQ (Teradata) queries for Extracting data from production database and built data structures, reports.
• Performed Data modeling using TOAD Data Modeler. Identified objects and relationships and how those all fit together as logical entities, these are tan translated into physical design using forward engineering TOAD Data Modeler tool.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Designed and documented Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Automating the tests usingVisualStudio2012 Ultimate tools.
• 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.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin.
• Created physical and logical models and used Erwin for Dimensional Data Modeling.
• Implemented the Slowly Changing Dimensions as per the requirement.
• Running Quality checks using SQL Queries and keep sync all databases with Erwin model and across all environments.
• Involved in requirement analysis of further enhancements in theSharePointapplication.
• 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.
• Implementation of full lifecycle inDatawarehouses and BusinessDatamarts with Star Schemas, Snowflake Schemas, SCD &DimensionalModeling.
• Created queries using BI- Reporting variables, navigational attributes and Filters. Developed workbooks, info set Queries. Defined reports as per reporting requirements.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes TEMPeffectively.
• Worked with reversed engineer Data Model from Database instance and Scripts.
• Responsible for Dimensional Data Modeling and Modeling Diagrams using ERWIN.
• Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.

Environment: PL/SQL, Tableau, ETL Tools Informatica 9.5/9.1 Oracle 11G, Teradata R14, Teradata SQL Assistant 14.0

Confidential, Bronx, NY

Sr. Data Analyst/Modeler

Responsibilities:

• PerformedDataAnalysis andDataProfiling and worked ondatatransformations anddataquality rules.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas
• Wrote ad-hoc SQL queries and worked with SQL and Netezza databases
• Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects.
• Performed in depth analysis indata& prepared weekly, biweekly, monthly reports by using SQL, Ms Excel, Ms Access, and UNIX.
• Developed the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Developed variousDataQuality mapping document, audit and security compliance adherence.
• Involved in the integration ofdatacoming from different sources.
• Involved in the creation, maintenance ofDataWarehouse and repositories containing Metadata.
• Designed different type of STAR schemas like detaileddatamarts and Plandatamarts, Monthly Summarydatamarts using ER studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Conducted Joint Application Design (JAD) sessions with business users to gather data warehouse requirements.
• Analyzing SAP Transactions from various modules to build a logical BI model for real time reporting needs.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQLServer2014 with high volume data
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Created SQL Prototypes to load sampledata, and also to test the business rules/logic prior to development.
• Worked on building thedatamodel using Erwin as per the requirements, discussion and approval of the model from business users.
• Involved with teradata utilities like Fastload, BTEQ, Multiload and Teradata SQL Assistant.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Worked with DBA's to create a best fit physicaldatamodel from the logicaldatamodel.

Environment: Oracle10g, SQL server, MS Excel, MS Visio, Rational Rose, Requisite Pro, Rational, Oracle 8i, Windows XP, PL/SQL,, Sql Server, MS Office, MS Access, MS Visio.

Confidential, Hartford, CT

Sr. Data Analyst/Modeler

Responsibilities:

• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• As part of Data Masking / Data Privacy performing the Reverse engineering on the Data Model to identifying the Schemas based on requirements.
• Performed Forward Engineering data models for Schema generation, Reverse Engineered on the Existing Data Models to accommodate new requirements.
• Creating Functional design document, developed detailed mapping document to provide reporting and Data Warehouse team with Source to Target mapping includes logical name, Physical name, data types, corporate Metadata definitions and translation rules.
• Design and develop the Data dictionary and Metadata of the models and maintain them.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas
• Wrote ad-hoc SQL queries and worked with SQL and Netezza databases
• Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects.
• Performed in depth analysis indata& prepared weekly, biweekly, monthly reports by using SQL, Ms Excel, Ms Access, and UNIX.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Toad, MSAccess, Excel, XLS and SQL.
• Document variousDataQuality mapping document, audit and security compliance adherence
• Excellent Data Analytical / User interaction and Presentation Skills.
• Good Understanding of advanced statistical modeling and logical modeling using SAS.
• Performeddatamanagement projects and fulfilling ad-hoc requests.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Worked on building up a SQL query for extraction ofdatafrom the warehouse for a reporting schedule.

Environment: Informatica,DataFlux, ERwin Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata, ataFlux, Oracle 9i, Quality Center 8.2, SQL

Confidential, Dayton, OH

Sr. Data Analyst/Modeler

Responsibilities:

• DataAnalysis primarily IdentifyingDataSets, SourceData, Source Meta Data, Data Definitions and Data Formats.
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Netezza
• Developed ER and Dimensional Models using Power Designer advanced features. Created physical and logicaldatamodels using Power Designer.
• Worked on building up a SQL query for extraction ofdatafrom the warehouse for a reporting schedule
• Developed and maintained data mapping documents to support ETL development.
• Developed and maintained metadata and metadata management strategies for the data model.
• Facilitated JAR/JAD sessions to determinedatadefinitions and business rules governing thedata, and facilitated review sessions with subject matter experts (SMEs) on the logical and physicaldata models.
• Created and configured SSAS cubes using SQL Server 2008 analysis services.
• DevelopedDataMapping,DataGovernance, Transformation and Cleansing rules for the Master DataManagement Architecture involving OLTP, ODS and OLAP.
• Worked on Optimization of the application and the designing of the database tables with the right partitioning keys using the DPF feature of hash partitioning and range partitioning.
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Used Model Mart of Erwin for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created tables, views, sequences, triggers, table spaces, constraints and generated DDL scripts for physical implementation.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Designed Logical & Physical Data Model /Meta data/ data dictionary usingErwin6.0 / ER Studio 6.5 for development teams both offshore and on site.
• Design and execute custom marketing research studies using optimal research methodologies in support of business needs
• Understand the patient base and requirement of a product in the market using thedatafrom KOL interviews
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/datatransformations to facilitate impact analysis.

Environment: Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, Erwin 8.0, Informatica, Business Objects XI, ER Studio 9.1.0, Informatica 7.1.3, Teradata v2R5/v2R6, Unix, Linux.

Confidential

Sr. Data Analyst/Modeler

Responsibilities:

• Experienced in Data modeler performing business area analysis and logical and physical data modeling using Erwin for data warehouse/data mart applications as well as operational applications enhancements and new development. Data warehouse/data marts design was implemented using Ralph Kimball methodology.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes TEMPeffectively.
• Worked with reversed engineer Data Model from Database instance and Scripts.
• Responsible for Dimensional Data Modeling and Modeling Diagrams using ERWIN.
• Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using ERwin.
• Created physical and logical models and used ERwin for Dimensional Data Modeling.
• Implemented the Slowly Changing Dimensions as per the requirement.
• Designed the ERdiagrams, logical model(relationship, cardinality, attributes, and, candidate keys) and physical database(capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin.
• Walked through the LogicalDataModels of all source systems fordataquality analysis.
• Handled performance requirements for databases in OLTP and OLAP models.
• Reverse engineered from Toad database to Erwin and generated SQL script through forward engineer in Erwin.
• Involved in the integration ofdatacoming from different sources.
• Involved in the creation, maintenance ofDataWarehouse and repositories containing Metadata.
• Designed different type of STAR schemas like detaileddatamarts and Plandatamarts, Monthly Summarydatamarts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables. e Data Model to identifying the Schemas based on requirements.
• Performed Forward Engineering data models for Schema generation, Reverse Engineered on the Existing Data Models to accommodate new requirements.
• Creating Functional design document, developed detailed mapping document to provide reporting and Data Warehouse team with Source to Target mapping includes logical name, Physical name, data types, corporate Metadata definitions and translation rules.
• Design and develop the Data dictionary and Metadata of the models and maintain them.
• Involved with the team to perform Data Profiling to ensure superior date quality.
• PerformedDataAnalysis andDataProfiling and worked ondatatransformations anddataquality rules.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas.

Environment: SQL, SQL Server 2000/2005, Rational Rose, Crystal Reports 9, Windows XP, Oracle 8i,, Erwin 8.0, Informatica, Business Objects XI, Teradata SQL Assistant, ER Studio 9.1.0, Linux.