SUMMARY:

• Over 10 years of Experience working as a DataArchitect/DataAnalyst/DataModeling with emphasis on DataMapping, DataValidation in DataWarehousing Environment.
• 9+ years demonstrated experience working with varies filesystems including RDBMS (Sybase ASE, MS SQL server, Oracle, Netezza, IBM DB2), Mainframe datasets (VSAM, $IAM, SEQ, etc.), UNIX datasets, XML files and Hadoop Distributed file systems.
• Good knowledge in Data management techniques, including DML and DDL.
• Solid in - depth understanding of Information security concepts, Data modeling and RDBMS concepts.
• Proficient in Analyzing source system by examining the content, structure and internal relationships of legacydatasources like flatfiles, Excel, Oracle, Sybase, SQLServer, XML and DB2 databases.
• Experienced working in all phases of SDLC from analysis, design, coding, unittesting, systemtesting and user acceptance testing.
• Experienced withDatawarehouse applications using Oracle, MSSQL Server on windows and UNIX platforms.
• Experienced indatatransformation,datamapping from source to target database schemas anddatacleansing procedures using InformaticaPowerCenter, Talend and Pentaho.
• Experienced in Teradata RDBMS using FastLoad, FastExport, MultiLoad, Tpump, TeradataSQLAssistance and BTEQTeradata utilities.
• Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Extensive experience in development of T-SQL, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Familiarity with CrystalReports, Cognos and SSRS - Query, Reporting, Analysis and Enterprise Information Management.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Worked with SAS Procedures such as PROC SQL, PROC REPORT, PROC ACCESS, PROC SORT, PROC TRANSPOSE, PROC MERGE, PROC PRINT, PROC TABULATE etc.
• Proficient in SystemAnalysis, ER/DimensionalDataModeling, Databasedesign and implementing RDBMS specific features.
• Experienced inDataScrubbing/Cleansing,DataQuality,DataMappingDataProfiling,DataValidation in ETL.
• Well versed in Normalization / Denormalization techniques for optimum performance in relational and dimensionaldatabase environments.
• Experienced in developing Entity-Relationshipdiagrams and modeling Transactional Databases andDataWarehouse using tools like ERWIN, ER/Studio and PowerDesigner.
• Hands on experience with modeling using ERWIN in both forward and reverse engineering cases.
• Proficient in OracleTools and Utilities such as TOAD, SQL*Plus and SQL Navigator.
• Strong hands on experience usingTeradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man),Teradata parallel support and Unix Shell scripting.
• Experience working with large database to perform completedataretrieval, manipulation using multiple input files using SASdatasteps
• Excellent knowledge on creating reports on Pentaho Business Intelligence.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies.
• Experienced with both DDL and DML including Joins, Functions, Indexes, Views, Constraints, PrimaryKeys and ForeignKeys.
• Good understanding and exposure to SQLqueries and PL/SQL stored procedures, triggers, functions and packages.
• Experienced inDatatransformation andDatamapping from source to target database schemas and alsodatacleansing.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

Databases: Oracle10/11g/12c, Teradata R12 R13 R14.10, MS SQL Server 2005,2008,2012 DB2, Netezza

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

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

Operating System: Windows, UNIX, Sun Solaris

ETL/Datawarehouse Tools: Informatica 9.6.1, 9.1,9.5,8.6 SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

DataModeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

PROFESSIONAL EXPERIENCE

Tools & Software: TOAD, MS Office, BTEQ, Teradata SQL

Confidential, New York, NY

Sr. Data Architect/Data Modeler

Responsibilities:

• Leads in the selection, deployment and maintenance of data management and reporting systems including operational data stores, data marts, enterprise data warehouses, and enterprise reporting/analytics tools. Builds BI dashboards, data models, structures, and database views, etc. to serve as a foundation for reporting and systems integration goals/strategies.
• 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.
• Gathered 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.
• Involved in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Abilities and Informatica Power Center and testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages
• Gather and analyze business data requirements and model these needs. In doing so, work closely with the users of the information, the application developers and architects, to ensure the information models are capable of meeting their needs.
• Extensively used Erwin r9.6 forDatamodeling. Created Staging and Target Models for the Enterprise DataWarehouse.
• Designed Star and SnowflakeDataModels for EnterpriseDataWarehouse using ERWIN.
• Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, and SAS/MACROS for descriptive and inferential statistical analysis and data displays.
• Creation ofBTEQ, Fast export, MultiLoad, TPump, Fast loadscripts for extracting data from various production systems
• TransformedLogical Data ModeltoPhysical Data Modelensuring thePrimary KeyandForeign key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor and Statements for Applications by using T-SQL.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects and identified the Facts and Dimensions from the business requirements and developed the logical and physical models using Erwin.
• Worked on building UNIX Shell Scripts to check and update the Teradata/Oracletables.
• Usedinformatica power center to Extract, Transform and Load data into Netezza Data Warehouse from various sources likeOracle, Teradata, DB2 and flat files.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Performancetuned SQL queriesusing Hints,AUTOTRACE, TKPROF, ADDM, AWR, Explain Planand SQL advisor.

Environment: Erwin r9.6/9.x/r8.x, Oracle 12c, SQL Server, PL/SQL, TERADATA, MDM, UNIX, ER diagrams, SAS/BASE, SAS/SQL, SAS/STAT, and SAS/MACROS, SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database, Netezza, DB2, Informatica.

Confidential, Iowa City, IA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Worked on the integration of existing systems atDatawarehouse and Application systems level.
• Extensively used SQL forDataAnalysis and to understand and documenting thedatabehavior.
• Reversed engineered existingdatabases to understand thedataflow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.
• Designed the procedures for getting thedatafrom all systems toDataWarehousing system.
• Worked with ETLArchitects and developer to design performance centric ETL mappings.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
• Extensively worked on documentation ofDataModel, Mapping, Transformations and Scheduling jobs.
• Worked extensively with Business Objects Report developers in creatingdatamarts and develop reports to cater the existing business needs.
• Designed Mapping Documents and Mapping Templates for InformaticaETL developers.
• Extensively used and created SAS/Macros for the efficiency and accuracy.
• Deployed naming standard to theDataModels at enterprise level and followed company standard for Project Documentation.
• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Designing ERdiagrams, logicalmodel (relationship, cardinality, attributes, and, candidate keys) and convert them to physicaldatamodel including capacity planning, object creation and aggregation strategies, partition strategies, Purging strategies as per new architecture.
• Designed and developed strategies forDataConversions andDataCleansing
• CreatedDatamappings, Tech Design, loading strategies for ETL to load newly created or existing tables.
• Extensively used Agile methodology as the Organization Standard to implement thedataModels.
• Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Developed statistics and visual analysis for warranty data using MS Excel, MS Access and Tableau Software.
• Developed strategies and loading techniques for better loading and faster query performance.

Environment: Erwin 8.2, InformaticaPowerCenter 9.1, Pentaho, IBM Cognos 8.4 ReportNet (Framework Manager, Tableau, Report Studio, SAS, Query Studio), Oracle 11g, DB2, MS SSRS/SSAS PL/SQL, T-SQL, Flat Files, MS Visio

Confidential, Charlotte, NC

Sr. Data Analyst / Data Modeler

Responsibilities

• Used and supported database applications and tools for extraction, transformation and analysis of rawdata
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in QualityCenter.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NFmodel and dimensional data model.
• Assist in semantic layer design and development of Semantic layer data model.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Created datamasking mappings to mask the sensitive data between production and test environment.
• Used Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, FastLoad, Multi Load, Fast Export, Tpump on UNIX/Windows environments and running the batch process for Teradata.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and dataprofiling using complex SQL on various databases such as Oracle and Teradata.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for an effective Data Warehouse and Data Mart.
• Written several shell scripts using UNIXKorn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Worked on data modeling and produced data mapping and data definition specification documentation.
• Used existing UNIX shell scripts and modified them as needed to process SAS jobs, search strings, execute permissions over directories etc.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies.
• Extensively completed data quality management using information steward and did extensive data profiling.
• Extensively worked on Talend Designer Components-Data Quality (DQ), Data Integration (DI) and Master Data Management (MDM)
• Wrote simple and advanced SQL queries and scripts to create standard and ad hoc reports for senior managers.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping

Environment: Erwin, SQL Server 2008, Oracle 11g, 3NF, Rational Rose, Informatica 9.6.1, Data Flux, WSDL, Data mining, Pentaho,Quality Center 8.2, SQL, Talend,TOAD, PL/SQL, Flat Files, Trillium, SAS, SOAP, Teradata R14

Confidential, SFO, CA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved in extensiveDatavalidation using SQLqueries and back-end testing
• Used Erwin, CreatedConceptual, Logical and Physicaldatamodels.
• Involved in analysis of a variety of source systemdata, coordination with subject matter experts, development of standardized business names and definitions, construction of a non-relationaldatamodel using Erwin modeling tool, publishing of adatadictionary, review of the model and dictionary with subject matter experts and generation ofdatadefinition language.
• Involved incompleteSDLC processes involving requirements management, workflow analysis, source dataanalysis, datamapping, metadata management, dataquality, testing strategy and maintenance of the model.
• Created ETL framework and provided strategy fordatacleansing,dataquality anddataconsolidation.
• Worked extensively in Teradata data modeling for both logical and physical data models.
• Developed ETL process using Pentaho PDI to extract the data from legacy System.
• Designed various InformaticaETL load patterns which include SCDTypeI, TypeII, fullload, etc.
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flatfiles, SQLServer with high volumedata
• Performeddatamanagement projects and fulfilling ad-hoc requests according to user specifications by utilizingdatamanagement software programs and tools like Perl, Toad, MSAccess, Excel and SQL
• Worked on Naming standards for Table/Column/Index/Constraints names thru Erwin Macros and Master Abbreviations file.
• WroteSQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to TestScripts to ensure any Change Control in requirements leads to test case update.
• Experienced in testing Business Intelligence reports generated by various BI Tools like Tableau, Microstrategy and Business Objects.
• Involved in extensiveDataValidation with SQLqueries.
• Worked on Physical design for both SMP and MPPRDBMS, with understanding of RDMBS scaling features

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica8.6.1, Teradata R13, Pentaho,Teradata SQL Assistant, CA ERWIN7.3, Subversion, MS-Office, Tableau, Oracle 10g, SQL Server 2005,, SQLPLUS, PL/SQL

Confidential, Plymouth, PA

Sr. Data Analyst

Responsibilities:

• Worked with data source systems and Client systems to identify data issues, datagaps, identified and recommended solutions.
• Performeddataanalysis as required to create ad-hoc reports.
• Created, defined, and maintained data life-cycle documentation representing data elements across multiple upstream and downstream systems.
• Proactively communicated and collaborated with external and internal customers to analyze information needs.
• Acted as liaison between the businessunits, technology teams and support teams.
• Responsible for researchingdataquality issues (inaccuracies indata), worked with business owners/stakeholders to assess business and risk impact, provided solution to business owners.
• Designed Starschema for Risk Retail reporting for credit card portfolio subject area.
• Analyzed functional and non-functional categorizeddataelements fordataprofiling and mapping from source to targetdataenvironment.
• Involved withdataprofiling for multiple sources and answered complex business questions by providingdatato business users.
• Extracteddatafrom various sources like Oracle, Mainframes, flatfiles and loaded into the target Netezzadatabase using NzSQL and NzLoad
• Created and executed automated tests for functional, and regression testing using QuickTest Professional using VBscripts.
• Executed SQLqueries for validation ofdataand used TOAD for SQLServer to write SQLqueries for validating constraints, indexes.
• Experienced indataanalysis using SQL, PL/SQL and many other queries based applications.
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Performed dicing and slicing ondatausing Pivottables to acquire the churn rate pattern and prepared reports as required.

Environment: PL/SQL, Informatica8.6, Oracle 10g, Netezza, Aginity, Excel, Business Objects, Access, ERWINdatamodeler, SAS, Agile, UNIX, OBIEE, Tableau, UNIX, XML SPY, soap UI, DTS, MS Office

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Developed logicaldatamodel from the conceptualmodel using ERWIN.
• Developed physicaldatabase model using ERWIN.
• Used ERWIN'sForwardEngineering tool to create tables and columns.
• Generated DDL statements for the newly generated objects (tables, views, indexes and packages)
• Developed star schemas for dimensional modeling using ERWIN.
• Used ETL methodology fordataextraction, transformations and loading in a complex EnterpriseDataWarehouse (EDW)
• Identified and documenteddatasources and transformation rules required to populate and maintaindatawarehouse content.
• Involved in extracting, cleansing, transforming, integrating, and loadingdatainto differentDataMarts usingDataStageDesigner.
• Used Erwin'sreverse engineering to connect to existing database and ODS to graphically represent the EntityRelationships.
• Implemented Reverse Engineering technique to transferdatafrom database to ERWIN. Also cleaned unwanted tables/columns and redefined attributes and relationships.
• Involved in Performance tuning by leveraging oracle explain utility and SQL tuning.

Environment:ERWIN 7.2, Oracle 9i, SQL server, MS Excel, MS Visio, Rational Rose, Requisite Pro