SUMMARY:

• Over 12+ years Senior Data Architect/Data Modeler/Data Analyst of experienced in Data Analysis and modeling, architecture, with excellent understanding of Data Warehouse, Databases, Data Governance, and Data Mart designing.
• Experienced in Database Creation and maintenance of physical data models with Oracle, Teradata, Netezza, DB2 and SQL Server databases.
• Experienced in Teradata, SQL queries, Teradata, indexes, Utilities such as Mload, Tpump, Fast load and Fast Export.
• Experience in developing Data model in Hive using Avro format, partitioning, Sqoop, Hue, Datamart & Platform practices for analyzing & processing the BigData as per the requirement.
• Experienced in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions).
• Experienced using ER diagram, Dimensional data modeling, Logical/Physical Design, Star Schema modeling, Snow-flake modeling using tools like Erwin and ER/Stuido
• Experience in providing solutions within the Hadoop environment using technologies such as HDFS, MapReduce, Pig, Hive, HBase, ZooKeeper, Storm, and other Big Data technologies
• Extensive experience in Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Experienced in multiple data sources and targets including Oracle, Netezza, and DB2, SQL Server, XML and flat files.
• Experience in BI/DW solution (ETL, OLAP, Data mart), Informatica, BI Reporting tool like Tableau and Qlikview and also experienced leading the team of application, ETL, BI developers, Testing team
• Expertise in designing the data warehouse using Ralph Kimball's and Bill Inmon techniques.
• Experienced in Netezza Administration Activities like backup/restore, performance tuning, and Security configuration.
• Experienced in Data Analysis on Oracle, MS SQL Server & MS Access with extraction of data from various database sources like Oracle, MS SQL Server, DB2 and Flat files into the Data Stage.
• Data Warehousing: Full life-cycle project leadership, business-driven requirements, capacity planning, gathering, feasibility analysis, enterprise and solution architecture, design, construction, data quality, profiling and cleansing, source-target mapping, gap analysis, data integration/ETL, SOA, ODA, data marts, Inman/Kimball methodology, Data Modeling for OLTP, canonical modeling, Dimension Modeling for data ware house star/snowflake design.
• Experienced in metadata from diverse sources, including relational databases Oracle, Teradata, Netezza, XML and flat files.
• Experienced in working with Teradata Utilities like Fast load, Multi load, Tpump and Fast Export Teradata Query Submitting and processing tools like Bteq and Teradata SQL Assistant (Queryman).
• Experienced in SSIS programming module to code several SSIS packages by using many programming languages.
• Experienced with Data Conversion, Data Quality, and Data Profiling, Performance Tuning and System Testing and implementing RDBMS features.
• Experienced in data from various sources like Oracle, Mainframes, and flat files and loaded into the target Netezza database.
• Experienced in Client-Server application development using Oracle PL/SQL, SQL PLUS, SQL Developer, TOAD, SQL LOADER.
• Well Versed with advance concept in Excel. Worked with Vlookup, Index, Match, IF Statements, Pivots and creating complex formulas
• Expert in Migration of data from Oracle, Sybase and DB2 to SQL Server.
• Experienced in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Metadata Manger), Power Exchange, and Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Extensive experience in SSIS Packages, SSRS reports and SSAS cubes on production server.
• Experienced in using Excel and MS Access to dump the data and analyze based on business needs.
• Experienced working in Postgres database on simple queries and writing Stored Procedures for Normalization and De-normalization.
• Has good knowledge in UI Developer which includes HTML, CSS, JAVASCRIPT, JQUERY and ANGULARJS.
• Experienced in Data Analysis, Data Modeling, Development, Testing and Documentation of projects.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE and Waterfall Methodologies.
• Experienced in ETL process using PL/SQL to populate the tables in OLTP and OLAP Data Warehouse Environment.
• Expertise in SQL Server Analysis Services (SSAS) to deliver Online Analytical Processing (OLAP) and data mining functionality for business intelligence applications.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r9.6/r9.5/r9.1/8.X, ER Studio and Oracle Designer, Power Designer.

OLAP Tools:: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9.

Oracle:: Oracle 12c/11g/10g/9i, R2 database servers with RAC, ASM, Data Guard, Grid Control and Oracle Golden Gate(Oracle Enterprise Manager),Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, AWR,ASH, ADDM, Explain Plan.

ETL Tools:: SSIS, Datastage, Informatica Power Center 9.7/9.6 /9.5/ 9.1.

Programming Languages:: Java, Base SAS and SAS/SQL, SQL, T-SQL, HTML, Python, Java Script, CSS, UNIX shells scripting, PL/SQL.

Database Tools:: Microsoft SQL Server 2014/2012/2008/2005 , Teradata and MS Access, Postger SQL, Netezza, SQL Server, Oracle.

Web technologies:: HTML, DHTML, XML, JavaScript

Reporting Tools:: Business Objects, Crystal Reports

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

Tools: & Software: TOAD7.1/6.2, MS Office, BTEQ, Teradata SQL Assistant

Big Data: Hadoop, HDFS 2, Hive, Pig, H Base, Sqoop, Flume.

Other tools: TOAD, SQL *PLUS, SQL*LOADER, MS Project, MS Visio and MS Office, Have worked on C++, UNIX, PL/SQL etc.

WORK EXPERIENCE:

Sr. Data Architect/Data Modeler

Confidential, Charlotte, NC

Responsibilities:

• Provide data architecture support to enterprise data management efforts, such as the development of the enterprise data model and master and reference data, as well as support to projects, such as the development of physical data models, data warehouses and data marts.
• Solutions architect for transforming business problems into Big Data and Data Science solutions and define Big Data strategy and Roap map.
• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
• Lead the strategy, architecture and process improvements for data architecture and data management, balancing long and short-term needs of the business.
• Designed and developed architecture for data services ecosystem spanning Relational, NoSQL, and Big Data technologies.
• Building relationships and trust with key stakeholders to support program delivery and adoption of enterprise architecture.
• Providing technical leadership, mentoring throughout the project life-cycle, developing vision, strategy, architecture and overall design for assigned domain and for solutions.
• Implemented end-to-end systems for Data Analytics, Data Automation and integrated with custom visualization tools using R, Hadoop and MongoDB, Cassandra.
• Involved in creating Data Lake by extracting customer's Big Data from various data sources into Hadoop HDFS. This included data from Excel, Flat Files, Oracle, SQL Server, MongoDb, Cassandra, HBase, Teradata, Netezza and also log data from servers
• Designed and implemented system architecture for Amazon EC2 based cloud-hosted solution for client.
• Worked on Dimensional and Relational Data Modeling using Star and Snowflake Schemas, OLTP/OLAP system, Fact and Dimension tables, Conceptual, Logical and Physical data modeling using Erwin r9.6.
• Proficiency in SQL across a number of dialects (we commonly write MySQL, PostgreSQL, Redshift, SQL Server, and Oracle)
• Designed the schema, configured and deployed AWS Redshift for optimal storage and fast retrieval of data.
• Performed PoC for Big data solution using Cloudera Hadoop for data loading and data querying
• Involved in T-SQL queries and optimizing the queries in Oracle 12c, SQL Server 2014, DB2, and Netezza, Teradata.
• Created MDM, OLAP data architecture, analytical data marts, and cubes optimized for reporting.
• Involved in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Worked on Hadoop ecosystem, hive queries, MongoDB, Cassandra, Pig, and Apache Strom.
• Wrote Pig Scripts to generate MapReduce jobs and performed ETL procedures on the data in HDFS.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Developed LINUX Shell scripts by using NZSQL/NZLOAD utilities to load data from flat files to Netezza database.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools, SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Worked in importing and cleansing of data from various sources like Teradata 15, Oracle, flat files, SQL Server with high volume data.
• Involved in creating informatica mapping to populate staging tables and data warehouse tables from various sources like flat files DB2, Netezza and oracle sources.
• Full life cycle of Data Lake, Data Warehouse with Big data technologies like Spark, Python, Hadoop, Cassandra.
• Developed Data Mapping, Data profiling, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extensively Used Sqoop to import/export data between RDBMS and hive tables, incremental imports and created Sqoop jobs for last saved value
• Managed definition and execution of data mapping, conversion and reconciliation processes, for data originating from a plethora of enterprise and SAP, leading into to ongoing data governance organization design.
• Developed Tableau visualizations and dashboards using Tableau Desktop, Tableau workbooks from multiple data sources using Data Blending.
• Performed data analysis and data profiling using complex SQL queries on various sources systems including Oracle, Teradata and Netezza.
• Developed MapReduce/Spark Python modules for machine learning & predictive analytics in Hadoop on AWS. Implemented a Python-based distributed random forest via Python streaming.

Environment: Erwinr9.6, Oracle 12c, Teradata15, Netezza, PL/SQL, T-SQL, MDM, Data Stage, Python, DB2, SQL Sever2014, Informatica Power Center, SQL, Hadoop, Hive Queries, MongoDB, SAS, Spark, SSRS, SSIS, SSAS, Tableau Excel, MS Access, SAP etc, AWS, R, AWS Redshift, Sqoop, MongoDB, HBase.

Sr. Data Architect/Data Modeler

Confidential, Mentor, OH

Responsibilities:

• Participated in the design, development, and support of the corporate operation data store and enterprise data warehouse database environment.
• Documented a whole process of working with Tableau Desktop, installing Tableau Server and evaluating Business Requirements.
• Participated in big data architecture for both batch and real-time analytics and mapped data using scoring system over large data on HDFS
• Implemented dimension model (logical and physical data modeling) in the existing architecture using ER/Studio.
• Involved in Database using Oracle, XML, DB2, Teradata 14.1, Netezza, SQL server, Big Data and NoSQL based MongoDB and Cassandra.
• Developed, managed and validated existing Data Models including Logical and Physical Models of the Data Warehouse and source systems utilizing a 3NFmodel.
• Worked on predictive and what-if analysis using R from HDFS and successfully loaded files to HDFS from Teradata, and loaded from HDFS to HIVE.
• Gathering the business requirements from customers and creating data models for different branches using MS access and ER/Studio.
• Designed and deployed scalable, highly available, and fault tolerant systems on AWS.
• Developed various QlikView Data Models by extracting and using the data from various sources files, DB2, Excel, Flat Files and Big data
• Worked on NoSQL databases including HBase, Mongo DB, and Cassandra. Implemented multi-datacenter and multi-rack Cassandra cluster.
• Designed Source to Target mapping from primarily Flat files, SQL Server, Oracle 11g, Netezza using Informatica Power Center9.6.
• Executed ad-hoc data analysis for customer insights using SQL using Amazon AWS Hadoop Cluster. Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Designed Logical data model and Physical Conceptual data documents between source systems and the target data warehouse.
• Worked with Hadoop ecosystem covering HDFS, HBase, YARN and Map Reduce.
• Extensively used ER/Studio for developing data model using star schema methodologies.
• Worked on Data Modeling using Dimensional Data Modeling, Star Schema/Snow Flake schema, and Fact & Dimensional, Physical & Logical data modeling.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database analysis, development, testing, implementation and deployment.
• Developed requirements, perform data collection, cleansing, transformation, and loading to populate facts and dimensions for data warehouse
• Created mapreduce running over HDFS for data mining and analysis using R and Loading & Storage data to Pig Script and R for MapReduce operations.
• Designed the schema, configured and deployed AWS Redshift for optimal storage and fast retrieval of data.
• Created, managed, and modified logical and physical data models using a variety of data modeling philosophies and techniques including Inmon or Kimball
• Worked on analyzing Hadoop cluster and different big data analytic tools including Pig, Hbase database and Sqoop.
• Maintaining data mapping documents, business matrix and other data design artifacts that define technical data specifications and transformation rules
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues and coordinated multiple OLAP and ETL projects for various data lineage and reconciliation.
• Managed the Master Data Governance queue including assessment of downstream impacts to avoid failures
• Worked in the capacity of ETL Developer (Oracle Data Integrator (ODI) / PL/SQL) to migrate data from different sources in to target Oracle Data Warehouse.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Worked with high volume datasets from various sources like SQL Server 2012, Oracle, DB2, and Text Files.
• Created named sets, calculated member and designed scope in SSAS, SSIS, SSRS.
• Worked on Teradata SQL queries, Teradata Indexes, MDM Utilities such as Mload, Tpump, Fast load and Fast Export.
• Migrated SQL server 2008 to SQL Server 2014 in Microsoft Windows Server 2003 and troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• 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.
• Implemented Python scripts to import/export JSON file, which contains the customer survey information and/or asset information, to/from the database.
• Involved in Troubleshooting and quality control of data transformations and loading during migration from Oracle systems into Netezza EDW.
• Created SSIS packages to load data from different sources such as Excel, Flat file, DB2 to SQL server Data warehouse and SQL Server, PL/SQL Transactional database.

Environment: ER/Studio, SSIS, SSRS, SAS, Netezza, Excel, MDM, PL/SQL, ETL, Python, Tableau, Hadoop, Hive, Pig, Mongo DB, Aginity, Teradata SQL Assistant, Cassandra, PL/SQL, T-SQL, Cognos, DB2, Oracle11g, SQL, Teradata14.1, Informatica Power Center9.6, AWS Redshift, HBase, R.

Sr. Data Modeler/Data Analyst

Confidential, Columbus, GA

Responsibilities:

• Created conceptual, logical and physical relational models for integration and base layer; created logical and physical dimensional models for presentation layer and dim layer for a dimensional data warehouse in Power Desinger.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects.
• Analyzing, designing, developing, implementing and maintaining ETL jobs using IBM Info sphere Data stage and Netezza.
• Extensively worked in Client-Server application development using Oracle 10g, Teradata 14, SQL, PL/SQL, Oracle Import and Export Utilities.
• Coordinated with DB2 on database build and table normalizations and de-normalizations.
• Conducted brain storming sessions with application developers and DBAs to discuss about various de-normalization, partitioning and indexing schemes for Physical Model.
• Involved in several facets of MDM implementations including Data Profiling, metadata acquisition and data migration.
• Extensively used SQL Loader to load data from the Legacy systems into Oracle databases using control files and used Oracle External Tables feature to read the data from flat files into Oracle staging tables.
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques.
• Created ETL packages using OLTP data sources (SQL Server 2008, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Migrated SQL server 2008 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Developing reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by the team and satisfying the business rules.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Worked with NZ Load to load flat file data into Netezza, DB2 and Architect to identify proper distribution keys for Netezza tables.

Environment: Power Designer, Teradata14, Oracle10g, PL/SQL, MDM, SQL Server 2008, ETL, Netezza, DB2, SSIS, SSRS, SAS, SPSS, Datastage, Informatica, SQL, T-SQL, UNIX, Netezza, Aginity, SQL assistance etc.

Sr. Data Modeler/Data Analyst

Confidential, Bedminster, NJ

Responsibilities:

• Worked with Business users during requirements gathering and business analysis to prepare high level Logical Data Models and Physical Data Models.
• Performed Reverse Engineering of the current application using ER/Studio and developed Logical and Physical Data Models for Central Model consolidation.
• Involved in integration of various relational and non-relational sources such as DB2, Teradata 13.1, Oracle 9i, SFDC, Netezza, SQL Server, COBOL, XML and Flat Files.
• Involved in Normalization /De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and ER/Studio Tool for logical and physical design of databases.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Experienced working on DB2 database for ETL operations. Moved database objects from DB2 to SQL Server Database.
• Created mappings using pushdown optimization to achieve good performance in loading data into Netezza.
• Performed Data Modeling, Database Design, and Data Analysis with the extensive use of ER/Studio
• Documented ER Diagrams, Logical and Physical models, business process diagrams and process flow diagrams.
• Created reports in Oracle Discoverer by importing PL/SQL functions on the Admin Layer, in order to meet the sophisticated client requests.
• Extensively used SQL, Transact SQL and PL/SQL to write stored procedures, functions, packages and triggers.
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for implementing physical data model.
• Data mapping documents between Legacy, Production, and User Interface Systems were developed. \
• Star schema was developed for proposed central model and normalized star schema to snow flake schema.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica Power Center, MDM from various source systems
• Worked with mapping parameters, variables and parameter files and designed the ETL to create parameter files to make it dynamic.
• Migration of databases from DB2 to SQL Server 2005, 2008.
• Tuning and code optimization using different techniques like dynamic SQL, dynamic cursors, tuning SQL queries, writing generic procedures, functions and packages
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Work flow Manager.
• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle database environments.
• Extensively worked on Shell scripts for running SSIS programs in batch mode on UNIX.

Environment: ER/Studio, Teradata 13.1, SSIS, SAS, Excel, T-SQL, SSRS, Tableau, SQL Server, Cognos, Pivot tables, Graphs, MDM, PL/SQL, ETL, DB2, Oracle 9i, SQL, Teradata14.1, Informatica Power Center etc.

Data Analyst

Confidential

Responsibilities:

• Involved in creating logical and physical data analyst with STAR and SNOWFLAKE schema techniques using Erwin 8.x in Data warehouse as well as in Data Mart.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle 8.x, Netezza and Teradata.
• Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Writing and executing customized SQL code for ad hoc reporting duties and used other tools for routine.
• Extensively used SQL to develop reports from the existing relational data warehouse tables (Queries, Joins, Filters, etc).
• Created Mappings for Initial load from MS SQL server 2005 to Netezza while performing data cleansing.
• Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
• Converted SQL Server packages to Informatica Power Center mapping to be used with Netezza.
• Involved in Informatica MDM processes including batch based and real-time processing.
• Performed ad-hoc queries by using SQL, PL/SQL, MS Access, MS excel and UNIX to meet business Analyst’s needs.
• Responsible for reviewing data model, database physical design, ETL design, and Presentation layer design.
• Conducted meetings with business and development teams for data validation and end-to-end data mapping.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Involved in Oracle, SQL, PL/SQL, T-SQL queries programming and creating objects such as stored procedures, packages, functions, triggers, tables, and views.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Environment: ERwin, MDM, ETL, Taradata, MS SQL Server 2005, PL/SQL, Netezza, DB2, Oracle, SSIS, IBM etc.