SUMMARY

• Over 11+Years of IT experience in Data Analysis, Data architecture, Application Design, Dimensional Data Modeling, Implementation and Testing of Enterprise Data Warehousing and Enterprise Database, Data Mining.
• Experienced in data analysis anddataprofiling using complex SQL on various sources systems including Oracle, Teradata, Hive platforms
• Excellent experience in designing transactional, dimensional, and multi - dimensional (cubes) data structures using data modeling tools such as Erwin, IBM Infosphere Data Architect and ErStudio
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, Tpump, Visual Explain, and Query man), Teradata parallel support and Unix Shell scripting.
• Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/ SQL Server/DB2.
• Created custom calculations Data Analysis Expressions (DAX) in Microsoft Power Pivot and in SSAS.
• In-depth noledge of,SSAS, SSRS, SSIS, T-SQL, Reporting and Analytics.
• Experienced in Data loading using PL/SQL,SQL Server Integration Services packages (SSIS), OracleDataIntegrator (ODI) and developed dashboard reports usingSQLServerreporting services (SSRS).
• Expertise in database normalization method defined by E.F CODD (3NF-Third Normal Form).
• Excellent experience in creating cloud based solutions and architecture using Amazon Web services and MicrosoftAzure.
• Experienced in data warehouse design, data modeling and database administration activities.
• Extensive experience usingdatamodeling tools Erwin, ER/Studio, IBM info sphere, Power designer and Microsoft Visio.
• Expertise in incorporating business requirements in quality conceptual, logicaldatamodels using ERStudio and created physicaldatamodels using forward engineering techniques to generate DDL scripts.
• Expertise in writing SQL queries and optimizing the queries in Oracle, SQL Server,Netezza, Hive& Teradata.
• 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.
• 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.
• Strong experience in Creating Database Objects such asTables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Experienced in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in adata warehouse projects.
• 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

Databases: Oracle 12c,10/11g, Teradata R15 R14, R13 MS SQL Server, MS Access, Netezza

Tools: SSAS,SSIS,SSRS,MS-Office suite (Word, Excel, MS Project and Outlook), VSS

Operating System: Windows, Unix, Sun Solaris

ETL/Datawarehouse Tools: Informatica, Talend, Tableau, Pentaho

Data Modeling: Erwin, ER/Studio, Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Power Designer.

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos Powerplay

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant, Netezza Aginity.

Project Execution Methodologies: Ralph Kimball and BillInmondatawarehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NB

Sr. Data Architect/Data Modeler

Responsibilities:

• Worked in Data Analysis, data profiling and data governance identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using DataWarehouse, ETL, OLAP, Client/Server applications.
• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Build an inventory of data needed to implement the architecture.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Designed the Logical Data Model using ERWIN 9.64 with the entities and attributes for each subject areas.
• Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
• Designed and developed architecture fordataservices ecosystem spanning Relational, NoSQL, and BigDatatechnologies.
• Specifies overall Data Architecture for all areas and domains of the enterprise, including Data Acquisition, ODS, MDM, Data Warehouse, Data Provisioning, ETL, and BI.
• Advises/leads projects involving the ETL related activities and the migration or conversion of data between enterprise data systems. Coordinates interactions between central IT, business units, and data stewards to achieve desired organizational outcomes.
• Gatheird and analyzed existing physical data models for in scope applications and proposed the changes to the data models according to the requirements.
• Advises on and enforces data governance to improve the quality/integrity of data and oversight on the collection and management of operational data.
• Able to guide / partner with VP / Directors for architecting solutions for the Big data Organization.
• Responsible for planning, installing, and supporting AWS infrastructure.
• Proficiency in SQL across a number of dialects (we commonly write MySQL, PostgreSQL, Redshift, SQL Server, and Oracle).
• Experience with AWS ecosystem (EC2, S3, RDS, Redshift).
• Integrated crystal reports using Erwin Data Modeler.
• Us Erwin to support for Teradata 13.0 and SSL.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Involved in designing Logical and Physical data models for different database applications using the Erwin.
• Designed and developed a Data Lake using Hadoop for processing raw and processed claims via Hive and Informatica.
• Worked with Netezza and Oracle databases and implemented various logical and physical data models for them.
• Data modeling, Design, implement, and deploy high-performance, custom applications at scale on Hadoop /Spark.
• Developed and implemented data cleansing, data security, data profiling and data monitoring processes.
• Applied data analysis, data mining and data engineering to present data clearly.
• Ensured high-quality data and understand how data is generated out experimental design and how these experiments can produce actionable, trustworthy conclusions.

Environment: DB2, CA Erwin 9.6, Oracle 12c, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, ERwin r 9.64, MS-Office, Redshift, SQL Server 2008/2012, Hadoop, Spark, AWS.

Confidential, Houston, TX

Sr. Data Architect/Data Modeler

Responsibilities:

• Working with business partners and team members, gather and analyze requirements translating these into solutions for database designs supporting transactional system data integration, reports, spreadsheets, and dashboards.
• Responsible for technical data governance, enterprise wide data modeling and database design.
• Developed multi-dimension data models to support BI solutions developed as well as other common industry data from external systems.
• Involved in Planning, Defining and Designingdatabase usingErwinon business requirement and provided documentation.
• Worked with map/reduce frameworks such as hadoop and associated tools (hive, pig, sqoop, etc)
• Created ComplexSSAScubes with multiple Fact and Measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• CreatedSSAStabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirements.
• Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema inSSAS.
• Worked with project management, business teams and departments to assess and refine requirements to design/develop BI solutions using MSAzure.
• Researched and developed hosting solutions usingAzureand other 3rd party hosting and software as a service solution.
• CreatedSQLtables with referential integrity and developedSQLqueries usingSQLServerand Toad.
• Worked with Azure Machine Learning, Azure Event Hubs, Azure Stream Analytics, PivotTables working with up to 140 million-record, multi-table, data sets in SQL (MS SQL Server, SAS Proc SQL, etc.).
• Created Tabular Data Models and implemented POWER BI for POC in Share Point Environment
• Partnered directly with the Data Architect, clients, ETL developers, other technical data warehouse team members and database administrators to design and develop high performing databases and maintain consistent data element definitions
• Involved withdataprofiling for multiple sources and answered complex business questions by providingdatato business users.
• Created logical and physical data models using Erwin and reviewed these models with business team and data architecture team.
• TransformedLogical Data ModeltoPhysical Data Modelensuring thePrimary KeyandForeign key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddata validation issues.
• Designed different type of STARschemas for detaileddatamarts and plandatamarts in the OLAP environment.

Environment: Erwin 9.6, Informatica 9.5, Power Pivot, SQL, Microsoft Azure, MS Excel, MS Visio, Rational Rose, SSAS,, CSV files, XML files, Linux, AWK, Aginity, Teradata SQL Assistant, Oracle12c.

Confidential, Bellevue, WA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Profiled and analyzed data for quality and completeness based on business requirements and expectations provide suggestions of additional attributes that may improve data utility.
• Worked on AWS technologies such as Redshift, RDS, EMR
• Developed OLTP system by designing Logical and eventually Physical Data Model from the ConceptualDataModel and used Erwin tool to develop a Conceptual Model based on business requirements analysis.
• Responsible for designing and implementing efficient Stored Procedures and SSIS Packages.
• Creating Data Models using Power Pivot(Power BI).
• Developed tabular queries for efficient analysis of report using Power BI, Power Pivot/Unpivot in T-SQL
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the halp of SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Troubleshoot SSIS Packages and convert to SSRS Reports.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Determined the best approach for designing data structures that support easy data consumption, trends identification, and ability to highlight exceptions through reporting and dashboard tools.
• Used reverse engineering for a wide variety of RDBMS, including MS Access, Oracle and Teradata to connect to existing database and create graphical representation using Erwin.
• Migrated data from Oracle to Teradata data warehouse using Integration services (SSIS) and Informatica to generate the reports using SSRS for differentSSASCubes.
• Created and Designed Data Source and Data Source Views and also configured OLAP Cubes (Star and Snow flake Schema) usingSSAS.
• Involved in creation of Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Used Open Query from SQL Server to theSSASServer to combine data fromSSAScube and DW database.
• Implemented ETL techniques forDataConversion,DataExtraction andDataMapping for different processes as well as applications.
• Extensively worked with Teradata database to implement data cleanup, performance tuning techniques.
• Maintained Data Consistency by evaluating and updating logical and physicaldatamodels to support new and existing projects.
• Developed understand and timing of source system data, and work within these constraints to deliver insights and information in a timely manner.
• Worked with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwintool.
• Resolved thedatatype inconsistencies between the source systems and the target system using the mapping documents and analyzing the database using SQL queries.
• Developed Logical and the Physical Model from the Conceptual Model with the use of Erwin.
• Generated the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Prepared Data modeling and Data Mapping document for data elements and data cleansing that were used for Current and New system in MS-Excel.
• Developed the SQL codes as well as use ETL tools toDataCleansing,DataMapping and conversion rules and applications.
• Reviewed existing data repositories and repositories for data availability and identify gaps for new needs.
• IdentifyDataQuality Controls review Business Requirements Document and attend project release meetings.
• DatamanagementDataintegrity,Datastandard,Dataenhancement,Datapublishing,Dataauditing,DataQuality,DataException handling process, Data Rejection Analysis.

Environment: SQL, ERWIN r9.5, Informatica9.1, VISIO, Oracle, MS-Excel, PowerPoint, MS-Word, SSAS, SSIS, SSRS, SAP, Teradata 14, Microsoft SQL Server 2012, SQL Manager, Aginity, SAP Logon, Visio, Business Objects XI, Teradata SQL Assistant, Power Pivot

Confidential, Wilmington, DE

Sr. Data Analyst/Data Modeler

Responsibilities:

• Obtained, analyzed and translated business requirements into conceptual, logical and physical data models.
• Expertise in creating and configuring SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Created a high-level industry standard, generalizeddatamodel to convert it into logical and physical model at later stages of the project using Erwin and Visio
• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using Erwin.
• Tuned and optimization of Teradata Queries Created the ETLdatamapping documents between source systems and the targetdatawarehouse.
• Involved in implementing Key Performance Indicator (KPI) Objects inSSAS2012. Create Calculate member in MOLAP cube using MDX inSSAS2012.
• Created different measure groups and calculations usingSSAS.
• Expert in creating Star schema cubes usingSSAS.
• Extensively developedSSASCubes, Partitions, Aggregations, KPI's and Browser perspectives.
• Validated data designs through peer reviews with a focus on maintainability, sustainability, and appropriateness for use within the constraints of data integration and reporting tools.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Worked on building up a SQL query for extraction ofdatafrom the warehouse for a reporting schedule
• Developed and maintained data mapping documents to support ETL development.
• Developed and maintained metadata and metadata management strategies for the data model.
• Facilitated JAR/JAD sessions to determinedatadefinitions and business rules governing thedata, and facilitated review sessions with subject matter experts (SMEs) on the logical and physicaldata models.
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata.
• Performed analysis, develop specifications, design, and develop reports and dashboards using Report Builder, Excel, and other standardized reporting tools
• Worked on enterprise logicaldatamodeling project (in third normal form) to gatherdatarequirements for OLTP enhancements.
• Involved in extensiveDatavalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Defined rules for calculations and ensure consistency with similar calculations and profiled data to understand patterns, deficiencies, and quality
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server with high volumedata.

Environment: Erwin 9.3, MS Visio, Oracle 11g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 11g, Quality Center 8.2.x, SQL, Power Pivot TOAD, PL/SQL, Flat Files, Teradata, MS Excel 2007, PL/SQL, Java, Netezza, ETL Tools Informatica 9.1, SSAS, SSIS, SSRS

Confidential

Sr. Data Analyst/Data Modeler

Responsibilities:

• Developed the logical and physical model from the conceptual model developed using a tool Erwin by understanding and analyzing business requirements.
• Developed, maintained and TEMPeffectively communicate Source to Target Mappings and data models design concepts for use as data integration (ETL) specifications.
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts forDataImport/Export andDataConversions.
• Skilled in developing Entity-Relationship diagrams, modeling Transactional Databases andData Warehouse.
• Created 3NF business areadatamodeling with de-normalized physical implementationdataand information requirements analysis using Erwin tool.
• Expertise indatabase programming (SQL, PLSQL, TSQL) MS Access, Oracle, DB2,Database tuning and Query optimization.
• Used ODS to generate results in Excel, PDF, and HTML formats.
• Developed and updated Logical Data Models to support complex, data-centric envisioning and application release decisions
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for implementing physicaldatamodel.
• Worked in the conversion ofSQL serverfunctions into theTeradata Store procedurefor confirming the data.
• Worked withBTEQinUNIXenvironment and execute the TPTscript from UNIX platform.
• Conducted complex ad-hoc programming and analysis including statistical programming and analysis.

Environment: Erwin, Informatica, Teradata SQL Assistant, Netezza Aginity, DB2, Oracle 10g (SQL, PL/SQL), UNIX, UNIX Korn Shell, MS-Windows XP, MS-Office.

Confidential

Data Analyst

Responsibilities:

• Worked with project team representatives to ensure that logical and physical Erwindatamodels were developed in line with corporate standards and guidelines.
• Involved in defining the source to targetdatamappings, business rules, and business anddata definitions.
• Designed complex mappings Involving target load order and constraint based loading.
• Turned SQL queries to make use ofdatabase indexes, and analyzed thedatabase objects and created Logical and Physical EDW models anddatamarts
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates.
• Documentdataquality and traceability documents for each source interface

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, Erwin, XML, Business Objects