SUMMARY:

• 9+ years of Industry experienced in IT with solid understanding of Data Modeling, Data Analysis, Data Architecture, Evaluating Data Sources and strong understanding of Data Warehouse/Data MartDesign, ETL, BI, OLAP,OLTP, Client/Server applications.
• Experienced in writing SQLqueries and optimizing the queries in Oracle, SQL Server, and Netezza, Teradata.
• Experienced in Dimensional Data Modeling using Data Modeling, Relational Data modeling, ER/Studio, ERwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical Data Modeling.
• Experienced in Management and implementation of database models, data flow diagrams, database schemas, db scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.
• Experienced in Data Analysis and Data Profiling using complexSQL on various sources systems including Oracle and Teradata.
• Very good knowledge and experience on AWS, Redshift, S3 and EMR.
• Extensive experience in Normalization (1NF, 2NF, 3NF and BCNF) and De - normalization techniques for improved database performance in OLTP, OLAP and Data Warehouse/Data Mart environments.
• Experienced on Metadata definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation program library maintenance, XML file generation and data quality.
• Experienced using MapReduce and Big data work on Hadoop and other NO SQL platforms
• Experienced in designing standards for using normalized data structures, de-normalized structures and dimensional structures. Defines common design patterns for modeling various types of relationships.
• Experienced in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experienced in big data analysis and developing data models using Hive, PIG, and Map reduce, SQL with strong data architecting skills designing data-centric solutions.
• Experienced in Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and Fast Export.
• Experienced in using the databases like DB2, Teradata and its utilities, Netezza, Oracle, SQL ServerIntegration Services (SSIS).
• Experienced in data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS using various features like data conversion etc.
• Experienced in Oracle, Netezza, and Teradata, SQL Server, and DB2 database architecture.
• Expertise in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Extensive experience in development of T-SQL, DTS, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
• Excellent in performing data transfer activities between SAS and various databases and data file formats like XLS,CSV,DBF,MDB etc.
• Experienced in ER Studio and Dimensional Models using ERwin advanced features, Conceptual, logical and physicaldata models using ERwin.
• Experienced in development and support knowledge on Oracle, SQL, PL/SQL, T-SQL queries.
• Experienced in testing integration solutions for Data import, export and Migration using EIM (Enterprise Integration Manager).
• Experienced in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL
• Excellent Knowledge of RalphKimball and BillInmon's approaches to Data Warehousing.
• Excellent knowledge in developing InformaticaMappings, Mapplets, Sessionss, Workflows and Worklets for data loads from various sources such as Oracle, Flat Files, DB2, SQL Server etc.
• Experienced in writing UNIXshell scripting and hands on experienced with scheduling of shell scripts using Control-M.
• 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, ER Studio.

TECHNICAL SKILLS:

Analysis and Modeling Tools:: Erwin r9.6/r9.5/9.1, Sybase Power Designer, Oracle Designer, BP win ER/Studio, MS Access 2000, Star-Schema, Snowflake-Schema Modeling, and FACT and dimension tables, Pivot Tables.

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

Oracle:: Oracle12c/11g/10g/9i/8.x, 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, Pentaho, Informatica Power Center 9.7/9.6/9.5/9.1 etc.

Programming Languages:: Java, Base SAS, SSIS and SAS/SQL, SQL, T-SQL, HTML/ XHTML/ HTML4.0.1/ HTML3.2, Java Script, CSS3/CSS2/CSS1, UNIX shells scripting, PL/SQL.

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

Reporting Tools:: Business Objects, Crystal Reports, and SSRS.

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

Tools & Software: TOAD, MS Office, BTEQ, Teradata 15/14.1/14/13.1/13, SQL Assistant

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

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

WORK EXPERIENCE:

Sr. Data Architect/Data Modeler

Confidential, Chicago, IL

Responsibility:

• Involved in architecting, designing, modeling, developing, maintaining and deploying complex data models, and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical data models (capacity planning, object creation and aggregation strategies) as per business requirements.
• Involved in documentation of Data Modeler/Data Analyst and ETL specifications for Data warehouse Erwin r9.6.
• Coordinated new data development ensuring consistency and integration with existing data warehouse structure.
• Worked on setting up AWS DMS and SNS for data transfer and replication
• Created and maintained LogicalDataModel (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.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Worked on updating the Designer Workflows and InfoPath forms in SharePoint 2010.
• Used SQL on the new AWS Databases like RedShift and Relation Data Services.
• Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDM.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Migrating existing on-premise applications and services to AWS.
• Executed Hivequeries on Parquet tables stored in Hive to perform data analysis to meet the business requirements and worked on importing and exporting data from Oracle and DB2 into HDFS and HIVE using Sqoop.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata14.1, Oracle, and Database, analysis, development, testing, implementation and deployment.
• Created Mappings for Initial load from MS SQL server 2012 to Netezza while performing data cleansing.
• Migrated Oracle Database of size 100TB over to AWS cloud from Data centers.
• Used Informatica mapping parameters, variables and different tasks such as command task, decision task and timer.
• Loaded multi format data from various sources like flat-file, Excel, MS Access, and Oracle using Netezza and performing file system operation.
• Developed ETL processes extracted data daily from Mainframe DB2 and ORACLE Databases, and loaded data into a SSIS based Decision Support Warehouse.
• Performed Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services
• Involved in extensive DATA validation by writing several complex SQLqueries and Involved in back-end testing and worked with data quality issues.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Designed the schema, configured and deployed AWS Redshift for optimal storage and fast retrieval of data and used Spark Data frames, Spark-SQL, Spark MLLib extensively and developing and designing POC's using Scala, Spark SQL and MLlib libraries.
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Involved in several facets of MDM implementations including Data Profiling, Metadata acquisition and data migration.
• Created PL/SQL Tables, Collections, and Records, Partitions and Used Dynamic SQL and triggers for faster data access and to in corporate business logic.
• Responsible for creating Hive tables, loading data and writing hive queries.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL Trace, TKPROF, Oracle hints, DBMS PROFILER, DBMS STATS.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning using NetezzaDatabase.
• Using SQL to extract data from different databases such as Oracle and Amazon Redshift.

Environment: Erwin r9.6, Netezza, Oracle11g, Taradata14.1, T-SQL, SQL Server 2012, SSRS, SSIS, LINUX, MDM, PL/SQL,SPSS, ETL, Informatica MDM, OLTP and OLAP, EIM, Redshift, Aginity, Sharepoint, Power view, SQL Assistance, Metadata, Hadoop, DB2, AWS, UNIX, Microsoft Team Foundation Server, Test Manager, Excel, SAS, Hive, Spark, Scala, Pig, Mapreduce, Mongodb, HBase etc.

Sr. Data Architect/Data Modeler ‘ ’

Confidential, Mentor, OH

Responsibility:

• Analyzed across multiple data domains and define strategies to reduce data redundancy , improve data availability, and accessibility by partnering with the technical teams and deliver a maintainable and reusable data architecture
• Maintained the end-to-end vision of the data flow diagram and develop logical data models into one or more physical data repositories.
• Documented logical data integration (ETL) strategies for data flows between disparate source/target systems for structured and unstructured data into common data lake and the enterprise information repositories
• Involved in designing the data warehouses and data lakes on regular (Oracle, SQL Server) high performance (Netezza and Teradata) and big data (Hadoop - MongoDB, Hive, Cassandra and HBase) databases.
• Worked with cloud based technology like Redshift, S3, AWS, EC2 Machine, etc.
• Implemented dimension model (logical and physical data modeling) in the existing architecture using ER Studio.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata14 Database.
• Involved in Data modeling using ER Studio identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using forward engineering ER Studio tool.
• Created ERD diagrams using ER Studio and implemented concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Provided technical guidance for re-engineering functions of Teradata warehouse operations into Netezza.
• Designed and Developed Oracle PL/SQL Procedures LINUX and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Involved in SQL Server and T-SQL in constructing Tables, Normalization and De-normalization techniques on database Tables.
• Worked with cloud based technology like Redshift, S3, AWS, EC2 Machine, etc. and extracting the data from the Oracle financials and the Redshift database.
• Worked on Cube structure optimization for MDM query performance in Analysis Services (SSAS) and worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Handled data loading operations from flat files to tables using NZLOAD utility and extensively used NZSQL and NZLOAD utilities.
• Performed Data Analysis, Data Validation and Data verification using Informatica DVO (Data Validation Option) from raw data to user acceptance.
• Developed complex TeradataSQL code in BTEQ script using OLAP and Aggregate functions to name few and reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Responsible for managing and reviewing Hadoop log files. Designed and developed data management system using MySQL.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Worked on SQL Server concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Used the Agile Scrum methodology to build the different phases of Software development life cycle.
• Manipulating, cleansing & processing data using Excel, and SQL. Responsible for loading, extracting and validation of client data.
• Performed Forward Engineering data models for Schema generation, Reverse Engineered on the Existing Data Models to accommodate new requirements.
• Designed and developed star schema model for target database using ER Studio Data modeling.

Environment: ER Studio, Netezza, Oracle11g, Taradata14.1, T-SQL, SQL Server 2012, SSAS, SSRS, SSIS, LINUX, MDM, PL/SQL,SPSS, ETL, OLTP and OLAP, Informatica MDM, Pivot, EHR, EMR, Sharepoint, Aginity, SQL Assistance, Metadata, DB2, UNIX, Excel, SAS, Hive, Pig, Power view, DVO, Microsoft Team Foundation Server, Test Manager, Mapreduce, Mongodb, HBase etc.

Sr. Data Modeler/ Data Analyst

Confidential, Greensboro, NC

Responsibility:

• Extensively used Erwin r9.5 to design Logical/Physical Data Models, relational database design, forward/reverse engineering, publishing Data Model to acrobat files, created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data Model in model mart, created naming convention files, co-coordinated with DBAs to apply the Data Model changes.
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Taradata13.1, DB2, Sybase, Oracle 9i, flat files and loading into Netezza.
• Involved in Designing Star Schema (identification of facts, measures and dimensions), Snowflake Schema for Data Warehouse, ODS architecture by using tools like Data Model, Erwin.
• Verify the data quality or data validation through Informatica data validation option tool (DVO).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Involved in Ralph Kimball and Bill Inman Methodologies(Star Schema, Snow Flake Schema).
• Coded using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on LINUX environment.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, Netezza flat files, SQL Server with high volume data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Creating various type of reports such as drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS).
• Implemented naming Standards and Warehouse Metadata for fact and dimension of Logical and Physical Data Model.
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (Loan Position, Commitment Schedule, Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan, Account, Portfolio, Property, Business Unit, Borrower, Journal Entry Demographic, Journal Entry Line Item etc.) to address the business needs using SSAS.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
• Created complex Stored Procedures and PL/SQL blocks with optimum performance using Bulk Binds (BULK COLLECT & FORALL), Inline views, Reference cursors, cursor variables, dynamic SQL, v-arrays, external tables, nested tables, etc.
• Designed Informatica mapping for Error handling and involved in preparation of the low level design (LLD) documents for Informatica Mappings.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheets to SQL Server.
• Designing and developing SQL Server Database, Tables, and Indexes, Stored procedures, Views, User Defined Functions and other T- SQL statements.

Environment: Netezza, Oracle9i, Taradata13.1, T-SQL, SQL Server, DB2, SSIS, LINUX, ERWIN r9.5, MDM, PL/SQL, ETL, SSRS, SSIS, Cognos, SAS, SSAS, SPSS, Sharepoint, Excel, Pivot tables, Shell scripting, Pivot, Power view, UNIX etc.

Data Modeler/Data Analyst

Confidential, Tampa, FL

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).
• Worked 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.
• Involved in performance tuning and unit testing for SQL and PL/SQL code and used several Oracle provided packages such as UTL FILE, DBMS JOB.
• Developed scripts for loading data from various systems using UNIX Shell, Oracle, PLSQL, SQL*Loader.
• 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.
• Built fully functional dashboards prototypes without going through ETL process and entire schema modeling lifecycle using MicroStrategy Visual Insights.
• 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 and 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 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 11g/10g, SQL, UNIX Shell scripting, MicroStrategy, XML, SQL*Loader, SQL*Plus, Informatica Power Center etc.

Data Analyst

Confidential, New York, NY

Responsibility:

• Involved in designing/developing Logical Data Analyst & Physical Data Analyst using Erwin DM.
• Worked with DB2 Enterprise, Oracle Enterprise, Teradata13, Mainframe sources, Netezza Flat files, and datasets operational sources.
• Worked with various process improvements, normalization, de-normalization, data extraction, data cleansing, and data manipulation.
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like TOAD, MS Access, Excel, XLS and SQL Server.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• Designed, Build the Dimensions, cubes with star schema and Snow Flake Schema using SQL ServerAnalysis Services (SSAS).
• Involved in Integration of various data sources like DB2, Oracle, Netezza, SQL Server, SAP BW, XML Files.
• Worked with requirements management, workflow analysis, source data analysis, data mapping, Metadata management, data quality, testing strategy and maintenance of the model.
• Used DVO to validate the data moving from Source to Target.
• Creating the requests in answers and see the results in various views like title view, table view, compound layout, chart, pivot table, ticker and static view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS) Editing, upgrading and maintaining ASP.NET website and IIS Server.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Involved in data from various sources like Oracle Database, XML, Flat Files, CSV files and loaded to target warehouse.
• Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence
• 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.
• Designed Power View and Power Pivot reports and designed and developed the Reports using SSRS.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheets to SQL Server.
• Extensively worked in SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences.
• Developed and supported the extraction, transformation and load process (ETL) for a Data.

Environment: ERWIN9.1, Netezza, Oracle8.x, SQL, PL/SQL, SQL Plus, SQL Loader, Informatica, CSV, Taradata13, T-SQL, SQL Server, Sharepoint, Pivot tables, Power view, DB2, SSIS, DVO, LINUX, MDM, PL/SQL, ETL, Excel, Pivot tables, SAS, SSAS, SPSS, SSRS.