SUMMARY

• 5+ years of extensive experience in Data Analysis, Data Modeling, System Analysis, Architecture and DBA, Development, Testing and Deployment of business applications.
• Experience using ERdiagram, Dimensional data modeling, Logical/Physical Design, Star Schema modeling, Snow - flakemodeling using tools like Erwin.
• Excellent noledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC).
• Exert in building Enterprise Data Warehouse or Datawarehouse appliances from Scratch using both Kimball and Inmon Approach.
• Expertise in creating DDLscripts for implementingDataModeling changes.
• Expertise in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for TEMPeffective and optimum performance in OLTP and OLAP
• Expertise in creating database objects and structures including databases, tables, indexes, views, snapshots, stored procedures, triggers, functions and cursors.
• Experienced in developing TSQL scripts and stored procedures to perform various tasks and multiple DDL, DML, and DCL activities to carry out business requirements.
• Well versed in system analysis, ER/Dimensional Modeling, Databasedesign and implementing RDBMS specific features.
• Strong understanding of the principles ofDatawarehousing, FactTables and DimensionTables.
• Good experience wif data model and designs on BigData, MongoDB, Hive, AWS.
• Experienced in writing SQL and PL/SQLscripts inDatawarehousing applications.
• Excellent experience working on Netezza/Teradata and writing heavySQLqueries.
• Experienced in various Teradatautilities like Fastload, Multiload, BTEQ, and TeradataSQLAssistant.
• Experience in designing big data tables, column families, Hive and Hbase database design wifin HDFS a plus Practical understanding of HDFS data partitioning, sharding, bucketing and Apache Hadoop.
• Excellent experience wif Confidential Infosphere and used tools such as Confidential data architect, Confidential Information Analyzer, Confidential MDM, Confidential Quality Stage etc.
• Experienced in creating, managing and delivering various dashboards and reports in Tableau by running them against Teradata or Netezza semantic layers and also against BigData Data.
• Coached and supported multiple Agile delivery teams on the TEMPeffective application of Agile values, principles and practices
• Expertise in writing SQLQueries, Dynamic-queries, sub-queries and complex joins for generating ComplexStoredProcedures, Triggers, User-defined Functions, Views and Cursors.
• Experienced using MapReduce, and "Bigdata" work on Hadoop and other NOSQL platforms
• Excellent noledge inDataValidation,DataCleansing,DataVerification and identifyingdatamismatch.

TECHNICAL SKILLS

Database: NETEZZA, Teradata,Oracle 12c/11g/10g/9i, MS Access, MS SQL Server 2016, 2014,2012, 2008,2008 R2,2005, MySQL, MongoDB, Hbase

ETL Tools: Informatica Power Center 10x, 9x, 8x, Talend, Pentaho, COGNOS 10.2.

DataModeling Tools: Erwin, Microsoft Visio 2003, ER Studio, Confidential Data Architect

Reporting Tools: Business Objects, Crystal Reports

Languages: PL/SQL, SQL, UNIX SHELL Scripting, Visual Basic 6, C#, C++, HTML, TSQL, OOP, Data Structure, Algorithms

Operating System: Windows 2003/2008/2008 R2/2012/2012R2 Server, NT & Windows9x, UNIX

Version Control: PVCS, VSS,CVSSchedulers Dollar Universe.

Others: MS Project, MS Office, Toad, SQL Developer, VI, Business Objects, SAS, Lotus Notes, WebEx Unix, Ubuntu & redhot.

PROFESSIONAL EXPERIENCE

Confidential, El-Segundo, L.A,CA

Sr. Data Architect/Data Modeler

Responsibilities:

• Experience in designing big data tables, column families, Hive and Hbase database design wifin HDFS a plus Practical understanding of HDFS data partitioning, sharding, bucketing and Apache Hadoop
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Created Conceptual, logical and physicaldatamodeling for OLTP and OLAP.
• Widely used Normalization methods and has done different normalizations (3NF)
• Performeddataprofiling anddataanalysis of source and target systems in Teradata and SQL Server environments.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management(MDM) Architecture involving OLTP, ODS and OLAP(ROLAP,MOLAP).
• Analyzed and developed detailed logical and physicaldatabase designs, logical and physical data models and relational database definitions for the enterprise data environment
• Generate DDLscripts for database modification, Teradata, Macros, Views and set tables.
• Developed SQL Queries to fetch complexdatafrom different tables in remote databases using joins, database links and Bulk collects.
• Jointly responsible wif application development teams to drive implementation of data management roadmap
• Created and maintained Logical Data Model (LDM) for the project which included documentation of all entities, attributes, data relationships, referential integrity, domains, codes, business rules, glossary terms, etc.
• Lead architecture governance activities related to BI and Analytics including participation in data governance board (as required) and Architecture Council (as required)
• Running Quality checks using SQL Queries and keeps sync all databases wif Erwinmodel and across all environments.
• Modeled new tables and added them to the existing data model using Erwin as part of data modeling.
• Participated in developing and ensuring compliance wif architecture principles and standards for the various systems and components based on design patterns
• Logical and Physical design using both Ralph Kimball and Bill Inmon style data warehouse designs.

Environment: Erwin, MS Excel, MS Access, Oracle 11g, UNIX, Windows7, SQL, PL/SQL, Power Designer, Informatica9.5, UNICA 6.4, UNIX, Teradata, Metadata, Netezza, SSRS

Confidential, Boston, MA

Sr. Data Architect/Data Modeler

Responsibilities:

• Analysis of functional and non-functional categorized data elements for dataprofiling and mapping from source to target data environment.
• Presented thedatascenarios via, Erwin logical models and excelmockups to visualize thedata better.
• Implemented Data Governance in Hadoop clusters
• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Developed WPF screens for managing lender and client haircuts using C# and WPF.
• Experience in designing big data tables, column families, Hive and Hbase database design wifin HDFS a plus Practical understanding of HDFS data partitioning, sharding, bucketing and Apache Hadoop
• Created and maintained the Enterprise Data Model at the Conceptual, Logical and Physical Level
• Steward of Enterprise Metadata Architecture & Standards
• Steward of Enterprise Data Lifecycle Management including data quality, data conversion, and data security technologies
• Lead strategy & architecture for Data Management
• Very strong Experience in WPF and WCF and Win form application
• Participated and lead the creation and maintenance of Canonical Models for Integration
• Lead proof of concepts certification, vendor and product selection for data management technologies
• Used Erwin and Visio to create 3NF and dimensional data models and published to the business users and ETL / BI teams.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked wif data investigation, discovery and mapping tools to scan every single data record from many sources.
• 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
• Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flatfiles, SQLServerwif high volume data
• Resolveddataissues and updates for multiple applications using SQLqueries/scripts.
• Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports.
• Developed advanced WPF client navigation controls using Infragistics control
• Work wif ASR for replace Exadata Hard drive and DRAM. Troubleshoot and diagnose faulty Hardware on Exadata. Extensively hands-on ipmitool command line.

Environment: ERWIN, Quality Center 9.2, MS Excel 2007, PL/SQL, 2, ETL Tools Informatica 9.5, Oracle 12c, Teradata, Teradata SQL Assistant,WPF

Confidential, Stamford, CT

Sr. Data Analyst/Data Modeler

Responsibilities:

• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snowflakeSchema.
• Provided in-depth identification and resolution of information flow and content issues.
• Participated in the development and maintenance of overall data architecture, data management standards and conventions, data dictionaries and data element naming standards and conventions for multiple computing environments to support data warehousing
• Responsible for testing all new and existing ETLdatawarehouse components.
• Written test cases for data extraction, data transformation, and reporting.
• Primary Data Analyst/Data Modeler performing Business Area Analysis and logical and physical data modeling for a Data Warehouse utilizing the Bill Inmon Methodology. Also designed Data Mart application utilizing the Star Schema Dimensional Ralph Kimball methodology.
• Created logical physicaldatamodels and MetaDatato support the requirements Analyzed requirements to develop design concept and technical approaches to find the business requirements by verifying Manual Reports.
• Upgrading the SQL Server Databases, Monitoring and Performances tuning.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Netezza
• Developed ER and Dimensional Models using Erwin advanced features.
• Created physical and logicaldatamodels using Erwin.
• Used SQL on a wide scale for analysis, performancetuning and testing.
• Extensively used Erwin as the main tool for modeling along wif Visio.
• Wrote complex SQLqueries for validating thedataagainst different kinds of reports generated by BusinessObjectsXIR2.

Environment: Erwin, SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Oracle 10g, Business Objects XI, Rational Rose,Datastage, MS Office, MS Visio, SQL, SQL Server 2008, Rational Rose, Crystal Reports 9

Confidential, Philadelphia, PA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Interacting wif business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and PhysicalDataModels.
• PerformedDatamodeling using Erwin. Identified objects and relationships and how those all fit together as logical entities, these are tan translated into physical design using the forward engineering ERWIN tool.
• Coordinateddataprofiling/datamapping wif business subject matter experts,dataarchitects, ETLdevelopers, anddatamodelers.
• Used CAErwinDataModeler (Erwin) for data modeling of custom developed information systems, including databases of transactional systems and datamarts.
• Validated thedatain the 3NFdatamodel by manually executing the query through thedatamodels.
• Generated many datasets according to specifications by writing SQL queries for modeling purposes.
• Proficient inDataModeling tool Erwin / SAPPowerDesigner/SQLDataModeler.
• Assisting development teams wif data cleansing, migration and loading in addition to assisting and supporting development teams wif reviewing, building, testing and maintaining database structures and SQL scripts.
• Performed extensivedataanalysis to identify variousdataquality issues wif thedatacoming from external systems
• Created PhysicalDataModel (PDM) and works closely wif the application development team to implement required performance enhancement features (such as adding indexes, splitting tables) in PDM.

Environment: Erwin, Informatica Power Center 7.1.2, Sybase, Windows, Teradata, Netezza, Toad, Oracle 9i, SQL Server 2000, SQL*Loader, AIX 5.0, PL/SQL, Windows XP, Toad, SQL Server, Visio