Candidates About

Eshwar

Sr. Data Modeler /Data Architect

Summary

·         Over 10+ years of experience as Data Analyst and Data Modeler with excellent knowledge on BI, Data warehouse, ETL and Big data

·         Excellent experience on Enterprise Data Warehouse Architect experience, Business requirement analysis, Identify sources, Finalizing Data Granularity, Identifying Facts and Dimensions and confirmed Dimensions. Architecting the right Data Model using Modeling tool Erwin, ER/Studio, Power Designer, IBM info sphere and process using ETL tools Informatica Power Center, Data Stage and OWB. Overcome Challenges, Stands on Deliverables and Ensure Successful Production Deployment. 

·         Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star Schema, Snow-Flake Schema, Facts and dimensions).

·         Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes. 

·         Used complete knowledge of data warehouse methodologies (Ralph Kimball, Bill Inmon), ODS, EDW and Metadata repository.

·         Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQLServer, ORACLE and other relational and non-relational databases. 

·         Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository. 

·         Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams. 

·         Worked with various data sources such as Oracle, SQL Server, Teradata and Netezza 

·         Extensive experience with OLTP/OLAP System and E-R modeling, developing Database Schemas like STAR schema and Snowflake schema used in relational, dimensional and multidimensional modeling.

·         Solid experience in Data Modeling using design tool Erwin, Power Designer, ER Studio and Data Base tools such as Oracle SQL Developer, SQL Server Management studio, MySQL, SQLPlus and Toad. 

·         Expertise in writing SQLQueries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors. 

·         Deployed and scheduled Reports using various Business Intelligence reporting tools to generate all daily, weekly, monthly and quarterly Reports including current status. 

·         Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports. 

·         Experienced using MapReduce, and "Big Data" work on Hadoop and other NOSQL platforms 

·         Excellent Experience with Big Data technologies (e.g., Hadoop, BIgQuery, MongoDB, Hive, Hbase etc.) 

·         Experienced in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL. 

·         Extensive experience in advanced SQLQueries and PL/SQL stored procedures. 

·         Experienced in creating OLAP cubes, data mart design, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.

·         Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

Technical Skills

• Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL, AWK, SED
• Data Modeling: Erwin r9.7/9.6, ERStudio, SAP Power Designer v16.x
• Databases Oracle 12c/11g, Teradata 14.x/15.x, DB2 UDB, DB2 Z/OS, SQL Server 2008/2005/2000, MySQL, MS- Access, Flat Files, XML files, Netezza.
• Operating Systems: LINUX, Sun Solaris, IBM AIX, HP-UX, MS-DOS, Windows
• Scheduling Tools: Autosys, Maestro (Tivoli), Control M
• Other Tools: Teradata SQL Assistant, Toad, Toad Data Point, Oracle SQL Developer, DB Visualizer 6.0, Informatica Developer, Microsoft Office, Microsoft Visio, Microsoft Excel, Microsoft Project, Netezza Aginity, Putty, JIRA, GitHub.
• Big Data Ecosystem: HDFS, MapReduce, Yarn, Hive, HBase, Impala, Sqoop, Oozie, Flume, Spark, Splunk, Kafka, Avro.

Work Experience:

Comcast, West Chester, PA                                                                        Feb’17 –Present

Sr. Data Modeler/ Data Architect

Roles & Responsibilities

·         Involved in Gathering Business requirements by organizing and managing meetings with business stake holders, Subject Matter Experts, Application architects, Technical architects and IT analysts on a scheduled basis.

·         Designed and developed Entity-Relationship diagrams and modeled Transactional Databases and Data Warehouse using tool Power Designer v15.x/16.x.

·         Analyzed data using Hadoop components Hive and Pig and created tables in hive for the end users.

·         Identified Facts and Dimensions from the business requirements and developed the Data models. Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.

·         Experienced in Using Power Designer Repository Services for effective model management of sharing, dividing and reusing model information and design for productivity improvement. 

·         Highly generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis using tools such as Toad Data Point and Informatica Data Analyst.

·         Used Input and Output data as delimited files into HDFS using Talend Big data studio with different Hadoop Component like Hive, Pig, and Spark.

·         Responsible for the analysis of business requirements and design implementation of the business solution.

·         Analyzed large amounts of data sets to determine optimal way to aggregate and report on it.

·         Attended JAD sessions with Data Architects to build Subject Area specific data models.

·         Experienced in Using Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.

·         Involved in designing and architecting data warehouses and data lakes on high performance (Teradata) and big data (Hadoop - Hive and HBase) databases.

·         Gathered and analyzed existing physical data models for in scope applications and proposed the changes to the data models according to the requirements.

·         Designed & managed large enterprise wide data/information architectures, which maps to the enterprise architecture while balancing the need for access against security and performance requirements.

·         Installed, configured, and operated Zookeeper, Pig, Sqoop, Hive, HBase, Kafka, and Spark for business needs.

·         Developed target mapping spreadsheets for ETL team with Source to Target data mapping (STTM) with physical naming standards, data types, volumetric, domain definitions, Transformation Rules and corporate meta-data definitions.

·         Identified & record defects with required information for issue to be reproduced by development team.

·         Involved in loading and transforming large sets of structured, semi structured and unstructured data from relational databases into HDFS using Sqoop imports.

·         Created database objects like tables, indexes, synonyms, views, materialized views etc. and were involved in Data mapping activities for the Data Warehouse.

·         Documented ER Diagrams, Logical and Physical models, business process diagrams and process flow diagrams.

·         Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.

·         Expertise in working with Excel: v-Lookups, h-lookups, indexes, pivot tables, data sorting and filtering.

Environment: Teradata v14, Teradata SQL Assistant, SQL Workbench, Oracle 12C, Oracle SQL Developer, Microsoft SQL Server 2016, Informatica Developer 10.1, SVN tool, SAP Sybase Power Designer 16, Toad Data Point, Informatica Power Center, BTEQs, Mload, Fast Load, UNIX scripting, PLSQL Programming, Putty, Jira, GitHub, Windows 10, Zookeeper, Pig 0.17, Sqoop, Hive 2.3, HBase, Kafka, and Spark.

3M Health - Maplewood, MN                                                                       Jan’16 – Jan’17

Sr. Data Architect/ Data Modeler

Roles & Responsibilities

·         Supported agency data management programs and data governance activities to align with the enterprise architecture and incorporate data strategy and data governance principles into program, project, and IT portfolio management processes.  

·         Provided end to end data architecture for the project by identifying the sources of data, designing the target and generating data mapping between source and target 

·         Design SDLC processes that ensure the consistent and effective creation, storage, presentation and control of documents and metadata to support enterprise-wide data sharing and integration efforts.

·         Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model and modeled new tables and added them to the existing data model using Erwin as part of data modeling.

·         Develop business and technical data requirements; provide clear and coherent written solution recommendations for both technical and non-technical audiences.

·         Involved in implementation the design of logical data model for Pre-Stage, Staging, ODS and DW database and for Data Marts.

·         Finalize the naming Standards for Data Elements and ETL Jobs and create a Data Dictionary for Metadata Management.

·         Data Analysis of source systems and performed data cleansing and cleaning before ETL 
development and created Data Standardization logic using SQL to standardize master data across the source systems and Created Data Validation rules using SQL to validate the structure and integrity of the extracted data.

·         Developed complex mapping to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata. 

·         Defined and delivered the data strategy roadmap for the enterprise, including data modeling, implementation and data management for our enterprise data warehouse and advanced data analytics systems incorporating structured, semi-structured and unstructured components.

·         Maintained modeling and naming standards and data normalization, metadata management, source to target data mapping documentation using industry standard tools.

·         Development of medium and complex BTEQs and worked with Teradata utilities like MLOAD, FLOAD, FASTEXPORT, TPUMP. 

·         Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements. 

·         Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables and performed high volume maintenance on large Teradata tables using MultiLoad loader utility. 

·         Written Teradata SQL, BTEQ, Multiload, FastLoad, and Fast Export for Ad-hoc queries, and build UNIX shell script to perform ETL interfaces BTEQ, FastLoad or FastExport, via Hummingbird and Control-M software. 

Environment: Erwin r9.7, Teradata v14, SQL Developer, Oracle 12c, MS SQL Server, Teradata SQL Assistant, PL/SQL, Teradata Manager, XML, BTEQ, MLOAD, FLOAD, FASTEXPORT, UNIX, Unix Shell scripts, Informatica Power Centre, Cognos, FTP, Windows 10.

HBO, NYC, NY                                                                                              Jul’15 – Dec’16

Sr. Data Analyst/ Data Modeler/Architect

Roles & Responsibilities

·         Involved with multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing and Cognos.

·         Involved in design discussions and meetings with the data architects to come out with the appropriate design for the data warehouse.

·         Extensively involved in the Physical/logical modeling and development of Reporting Data Warehousing System.

·         Created Source to Target Mapping documents (S2T), documented business and transformation rules.

·         Worked on different data formats such as Flat files, SQL files, Databases, XML schema, CSV files.

·         Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications with also designed Star and Snowflake Data Models for Enterprise Data Warehouse using Erwin

·         Created and maintained Data Models (LDM and PDM) 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 Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements with also created Logical data model using Erwin tool and created normalized schemas by logical grouping of EDM attributes.

·         Generate big data Hadoop modeling for Hive database tables. Conceptual, logical and physical data models are designed with maintaining data governance and naming standards. .

·         Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.

·         Designed and developed the Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models and maintained them with also coordinated with DBA on data base build and table normalizations and de-normalizations.

·         Worked directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified by customers.

·         Performed match/merge and ran match rules to check the effectiveness of MDM process on data and prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during the project

·         Designed and developed Star and Snowflake Data Models for Enterprise Data Warehouse using industry leading Data Modeling tools like Erwin and translated Business Requirements into working Logical and Physical data models for OLTP, Data Warehouse and Data Mart applications.

·         Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.

Environment: Erwin9.5, Windows 7, Informatica Power Center, Oracle 10g, Netezza, UNIX AIX 5.2, PERL, Shell Scripting

Capital One, McLean, VA                                                                             May’13 – Jun’15

Sr. Data Analyst/ Data Modeler

Roles & Responsibilities

·         Involved in extensive Data validation using SQL queries and back-end testing 

·         Used SQL for Querying the database in UNIX environment.

·         Copied the data and visualized the streaming processed data in Tableau dashboard.

·         Involved with Design and Development team to implement the requirements. 

·         Data Analysis primarily Identifying Data Sets, Source <st