SUMMARY

• Over 10+ year of Data Engineer/Data 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 data modeler, Power Designer and Embarcadero E-R Studio.
• Extensive experience as a solution architect for business information systems, focusing on Data Architecture, Data Stores and Data Mart/Data Warehouse concepts.
• Experienced in Data modelingfor Data Mart/Data Warehouse development including conceptual, logical and physical model design, developing Entity Relationship Diagram (ERD), reverse/forward engineer (ERD) with CA ERwin data modeler.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Erwin.
• Excellent Knowledge of RalphKimball and BillInmon's approaches to Data Warehousing and experienced in development and support knowledge on SQL Server 2005/2008/2014/2016 , T-SQL queries
• Experienced in Logical Data Model (LDM) and Physical Data Models (PDM) using Erwin data modeling 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), Data Warehousing 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 / 2000 / 2005/2008 / 2008 R 2 /2012 /2014/2016 , MS-Access 2000/2007, MySQL, ORACLE, NDWTERADATA, NETEZZA, MS AZZURE

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: SSAS, Python

Ticketing System: JIRA, ITSM, ServiceNow, Remedy

Project Tracking Tools: GIT Hub, Team Foundation Server, Bit Bucket

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 Engineer

Confidential

Responsibilities:

• Provided estimation on Data Migration project from On Prem data warehouses to Cloud.
• Provided Consultative approach on the use of tools.
• Provided consultative approach on resources, and time for the overall project.
• Assisted Scrum Master on providing technical support in preparation of BRD for the project.
• Coordinate with business on the approach, resources and tools to achieve the maximum during the project tenure.
• Provided the alternative approach on carrying out the project in both Waterfall and Agile methodology.

Environment: Ab Initiao, Hadoop, Teradata, Aster, Bravo, MS SQL, Oracle, Snowflake

Data Architect/Data modeler

Confidential

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, Logical and 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 perform data profiling and data analysis to enable identify data gaps and familiarize with new source system data
• Worked with DB2 group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin and involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Developed DataMapping, DataGovernance, and transformation and cleansing rules for the MasterDataManagement Architecture involving OLTP, ODS.
• Created Dashboards on PowerBI from 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 the data Models.

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

Data modeler

Confidential

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 schema data models could be designed from three source systems and developed Logical and Physical Data models by using Erwin and its converted into physical database design.
• Worked on the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2016 and Flat files.
• Strong knowledge in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snowflake Schema, 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.
• Created Data Quality Scripts using SQL to validate successful data load and quality of the data. Created various types of data visualizations using PowerBI.
• Involved in Normalization and de-normalization OLAP 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 2016, DB2, SSIS, SQL, SSMS, MDM, SPSS, ETL, MS AZZURE etc.

Data modeler

Confidential, Reston, VA

Responsibilities:

• Designed and developed architecture for data services ecosystem spanning Relational, NoSQL.
• Specifies overall Data Architecture for all areas and domains of the enterprise, including Data Acquisition, ODS, MDM, Data Warehouse, Data Provisioning, ETL, and BI.
• Created Physical & logical data model from the conceptual model and its conversion into the physical database with the DDL's using forward engineering options in Erwin.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management 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 (Master data management) and suggested the implementation for hybrid MDM (Master Data Management).
• Worked on designing, implementing and deploying into production an Enterprise data warehouse
• Developed SQl process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Validation process .
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Involved in capturing data lineage, table and column data definitions, valid values and others necessary information in the data model.
• Responsible for data profiling and data quality checks to suffice the report requirements gathered above and provide an ETL Mapping.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snowflake Schemas.
• Worked on the metadata management and part of data governance team which created the Data
• 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 Analyst/Data modeler

Confidential, NY

Responsibilities:

• Worked on designing Conceptual, Logical and Physical data models and performed data design 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 developing data model using 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.