SUMMARY

• Over 10+ year of Data Architect/Modeler/Analyst with IT professional experienced in Data Analysis, Data Modeling, Data Architecture, designing, developing, and implementing data models for enterprise - level applications and systems.
• Experienced in integration of various relational and non-relational sources such as DB2, Teradata, Oracle,Netezza, SQL Server, NoSQL, XML and Flat Files, to Netezzadatabase.
• Experienced in designing Star Schema, Snowflake schema for Data Warehouse, by using tools like Erwin datamodeler, Power Designer and Embarcadero E-R Studio.
• Extensive experience as a solutionarchitectfor business information systems, focusing onDataArchitecture,DataStores andDataMart/DataWarehouse concepts.
• Experienced in Data modeling for Data Mart/DataWarehouse development including conceptual,logicaland physicalmodeldesign, developing Entity Relationship Diagram (ERD), reverse/forward engineer (ERD) with CA ERwindatamodeler.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multipledatamodeling tools like Erwin.
• Excellent Knowledge of RalphKimball and BillInmon's approaches toDataWarehousing and experienced in development and support knowledge on SQL Server 2005/2008/2014/2016 , T-SQL queries
• Experienced in LogicalDataModel(LDM) and PhysicalDataModels(PDM) using Erwindatamodeling tool.
• Experienced in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server SSIS.
• Experienced in process improvement,Normalization/De-normalization, data extraction, data cleansing, and data manipulation.
• Experienced in Designed and developed Data models for Database (OLTP), the Operational Data Store (ODS), Data warehouse (OLAP), and federated databases to support client enterprise Information Management Strategy.
• Experienced in data from various sources like Oracle Database, Flat Files, and CSV files and loaded to target warehouse.
• Experienced in Transform, and Load data from heterogeneous data sources to SQL Server using SQL ServerIntegration Services (SSIS) Packages.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), AGILE Methodologies.
• Experienced in Business Intelligence (SSIS, SSRS, POWER BI),DataWarehousing and Dashboards.
• Expertise in Data Profiling, Data mapping documents, in Enterprise and Corporate Data Warehouse environments.
• Experienced in MDM (Master Data management) in removing duplicates, standardizing data, and to eliminate incorrect data.

TECHNICAL SKILLS

RDBMS: SQL SERVER 7.0 / 6.x / / R /2016, MS-Access 2000/2007, MySQL, ORACLE, NDWTERADATA, NETEZZA

RDBMS Languages: T-SQL, Dynamic SQL, PL/SQL

RDBMS Tools: Enterprise Manager, SQL Server Management Studio (SSMS), SQL Profiler Tuning Advisor, Surface Area Configuration, SQL DEVELOPER, NDW TERADATA SQL ASSISTANT, MYSQL Workbench, Minionware, Aginity workbench

Reporting Tools: SQL Server Reporting Services (SSRS) 2005/2008, Report Builder 2.0, POWER BI

ETL Tools: SQL Server Integration Services (SSIS), Business Intelligence development studio (BIDS), Import Export / Data, Bulk Insert, BCP, SQL Server Data Tools 2015

ETL Data Components: Oracle / Teradata ATTUNITY Components

Data Modeling Tools: ERwin 7.1 / 9.5, Erwin Model Mart

Data Analysis: Microsoft Excel 2003/20, PowerPivot

Ticketing System: JIRA 6.4

Project Tracking Tools: HPQuality Centre, Microsoft Project 2007

File Transfer Tools: NDM - Sterling Commerce Connect Direct, WINSCP (SFTP)

File Formats: XML, Text, CSV, XLS

Version Control Tools: Visual Source Safe (VSS),Visual Studio Team Foundation 2010 (TFS)SVN, PVCS

PROFESSIONAL EXPERIENCE

Data Architect/Data modeler

Confidential, Lowell, Ar

Responsibilities:

• Provided a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical, and physical data models based on those needs.
• Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
• Specifies overall Data Architecture for all areas and domains of the enterprise, including Data Acquisition, ODS, MDM, Data Warehouse, Data Provisioning, ETL, and BI.
• Responsible for leading the architectural development of project/metadata and reporting framework.
• Worked on designing Canonical,Conceptual,Logicaland Physical data modeling using Erwin r9.6 and ER Studio in several projects in both OLAP and OLTP applications.
• Responsible for data profiling, data analysis, data specification, data flow mappings, and business logic documentation associated with new or modified product data capture requirements.
• Create conceptual, logical and physical models for OLTP, Data Warehouse Data Mart Star/Snowflake schema implementations
• 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.
• Worked on the development of Data Warehouse, Business Intelligencearchitecture that involves data integration and the conversion of data from multiple sources and platforms.
• Created Source to Target mappings and Transformations. Mapped data between Source and Targets and performdataprofiling anddataanalysis to enable identifydatagaps and familiarize with new source systemdata
• Worked with DB2 group to create Best-Fit PhysicalDataModelfrom theLogicalDataModelusing Forward engineering using Erwin and involved inNormalizationandDe-Normalizationof existing tables for faster query retrieval.
• Developed DataMapping, DataGovernance, and transformation and cleansing rules for the MasterDataManagement Architecture involving OLTP, ODS.
• Created Dashboards onPowerBIfrom different sources using data blending from Oracle, SQL Server, MS Access and CSV at single instance.
• Extensively using Agile methodology as the Organization Standard to implement thedataModels.

Environment: ERWIN r9.6, T-SQL, SQL Server 2016, DB2, SSIS, SSMS

Data Architect/Data modeler

Confidential, Reston VA

Responsibilities:

• Designed and build relational database models and defines data requirements to meet the business requirements.
• Delivered complex and ambiguous business requirements while elevating data architecture to the next level and developed strategies for data acquisitions, archive recovery, and implementation of databases.
• Responsible for developing and supporting a data model and architecture that supports and enables the overall strategy of expanded data deliverables, services, process optimization and advanced business intelligence.
• Drove requirement sessions with the client to the degree Erwin analytical logical and physical star schemadatamodels could be designed from three source systems and developedLogicaland PhysicalDatamodelsby using Erwin and its converted into physical database design.
• Worked on the development ofDataWarehouse, Business Intelligence architecture that involvesdataintegration and the conversion ofdatafrom multiple sources and platforms.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Strong knowledge in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, StarSchema,SnowFlakeSchema, Fact Table and Dimension Table.
• Implemented the policy for allocation of costs for insurance, self-insurance, and other risk management expenses to appropriate divisions, departments or programs, or other cost centers.
• Developed, implemented and administered comprehensive risk management programs with appropriate policies and procedures that protect the assets and client’s interests.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• CreatedDataQuality Scripts using SQL to validate successfuldataload and quality of thedata. Created various types ofdatavisualizations using PowerBI.
• Involved in Normalizationandde-normalizationOLAP and OLTP systems, process including relational database, table, constraints (Primary key, foreign key, Unique and check) and Indexes.
• Performed data profiling of data vault hubs, links and satellites using Erwin generated SQL scripts and designed Physical Data Model (PDM) using Erwin data modeling tool and SQL and T-SQL Managed Meta-data for data models.

Environment: Erwin, Metadata, T-SQL, SQL Server 2012, DB2, SSIS, SQL, SSMS, MDM, PL/SQL, SPSS, ETL, Data stage etc.

Data modeler/Data Analyst

Confidential, NYC, NY

Responsibilities:

• Provided a consultative approach with business users, asking questions to understand the business need and deriving thedataflow, logical, and physicaldatamodels based on those needs.
• Designed and developed architecture fordataservices ecosystem spanning Relational, NoSQL.
• Specifies overallDataArchitecture for all areas (Healthcare payer domain) and domains of the enterprise, includingData Acquisition, ODS, MDM,DataWarehouse,DataProvisioning, ETL, and BI.
• Created Physical & logicaldatamodel from the conceptual model and it's conversion into the physical database with the DDL's using forward engineering options in Erwin.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for the MasterDataManagement Architecture.
• Worked with the Risk Management and the finance team to prepare a self-insured retention marine reserve worksheet at each actuarial report
• Completed enhancement for MDM (Masterdatamanagement) and suggested the implementation for hybrid MDM (MasterDataManagement).
• Worked on designing, implementing and deploying into production an Enterprisedatawarehouse
• Developed SQl process using SSIS with Various Control Flow,DataFlow tasks and Store Procedures for Validation process.
• Used forward engineering to create a PhysicalDataModel with DDL that best suits the requirements from the LogicalDataModel.
• Involved in capturingdatalineage, table and columndatadefinitions, valid values and others necessary information in thedatamodel.
• Responsible fordataprofiling anddataquality checks to suffice the report requirements gathered above and provide an ETL Mapping.
• Generated periodic reports based on the statistical analysis of thedatausing SQL Server Reporting Services (SSRS).
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using Star and Snow Flake Schemas.
• Worked on the metadata management and part ofdatagovernance team which created theData
• Creating or modifying the T-SQL queries as per the business requirements.

Environment: Erwin 9.1, ODS, MDM, OLAP, OLTP, NoSQL, PL/SQL, MS-Visio, T-SQL, SSIS, SSRS, SQL, PL/SQL.

Data modeler/Data Analyst

Confidential - El Monte, CA

Responsibilities:

• Worked on designingConceptual,Logicaland Physicaldatamodelsand performed datadesign reviews with the Project team members Erwin r9.1.
• Worked in complex SQLs needed for ETL and analyzing data and is proficient and worked with databases like SQL Server2008, Teradata 13.1, DB2, MS SQL,Excel sheets.
• Extensively used Erwin for developingdatamodelusing star schema and Snowflake Schema methodologies.
• Involved in data analysis and creating data mapping documents to capture source to target transformation rules.
• Involved in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Involved in PL/SQL programming and developed Stored Procedures and Triggers and Data Stage, DB2,
• Utilized SDLC and Agile methodologies such as SCRUM.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Worked in data from Flat files, SQL Server, Oracle, DB2, and Sybase and load the data into flat files, Oracle and SQLServer using Data stage.

Environment: Agile, T-SQL, SQL Server, DB2, SSIS, ERWIN, SSRS, MDM, PL/SQL, ETL, Data stage etc.

Data Analyst

Confidential - Naples, FL

Responsibilities:

• Designed different type of STAR schemas and Snowflake Schema using ERWIN 8.x with various Dimensions like time, services, customers and FACT tables.
• DesignedStarschema(identification of facts, measures and dimensions) andSnowflake schema.
• Extensively used reverse engineering feature of Erwin to save the data model with production.
• Attended and participated in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Analysis of functional and non-functional categorized data elements for dataprofiling and mapping from source to target data environment.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• 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, glossary terms, etc.
• Designed and Developed Shell Scripts,DataImport/Export,Data Conversions andDataCleansing.
• Wrote PL/SQL statement, stored procedures and Triggers in DB2 for extracting as well as writing data.
• Involved in Integration of various data sources like DB2, SQL Server, XML Files.
• Worked with requirements management, workflow analysis, source data analysis, data mapping, Metadata management, data quality, testing strategy and maintenance of the model.
• Involved in data from various sources like XML, Flat Files, CSV files and loaded to target warehouse.
• Experience in developing dashboards and client specific tools in Microsoft Excel and Power Point.
• Excellent knowledge and experience in Technical Design and Documentation.
• 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.
• Performed logical data modeling, physical data modeling (including reverse engineering) using the Erwin Data Modeling tool.
• Extensively worked in SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences.

Environment: ERWIN8.x, Data Modeler, SQL, PL/SQL, T-SQL, SQL Server, DB2, SSIS, SSRS,, PL/SQL, ETL, etc.