SUMMARY

• Over 10 years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering anddatamodeling including design and support of various applications in OLTP,DataWarehousing, OLAP and ETL Environment.
• Have a very good experience in data warehousing, data management, ETL processes and data modeling tools
• Have a very good experience in Teradata Marketing Resource Management (MRM)
• Worked on Managing and maintaining all production and non - production Teradata databases.
• Extensive experience in designing and developing jobs using IBM DataStage, DatastageDesigner, Data stageManager, and Data Stage Director on Server Engine.
• Have expertise indatabase and interface design, data integration, conversionprocesses and optimization, in designing, developing, testing and implementing ETLsolutions.
• Very good experience and product knowledge of the 11.5 InfoSphere Suite Quality Stage
• Excellence in delivering Quality Conceptual, Logical and PhysicalDataModels for Multiple projects involving various Enterprise New and Existing Applications andDataWarehouse.
• Have expertise with analyzing various reporting platforms & identify the right platform for the Data Integration
• Have experience in designing, modelling, performance tuning and analysis, implementing processes using ETL tool Pentaho data Integration (PDI) tool for Data Extraction, transformation and loading processes
• Have a very good experience in extracting data from Oracle EBS/ERP
• Excellent SQL programming skills and developed StoredProcedures, Triggers, Functions, Packages using SQL/PLSQL. Performance tuning and query optimization techniques in transactional anddatawarehouse environments.
• Proficient indatamart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• Expertise in developing transactional enterprisedatamodels that strictly meet normalization rules, as well as EnterpriseDataWarehouses using Kimball and InmonDataWarehouse methodologies.
• Experienced inMDMHub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager.
• Extensively experienced in using ERmodeling tools such as ERwin and ER/Studio.
• Experienced in logical/physical database design and review sessions to determine and describedataflow anddatamapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Fair knowledge in installing ODI, and to create Master and work repositories in different products like Oracle, Teradata.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Expertise in extracting, transforming and loading (ETL)datafrom spreadsheets, database tables and other sources using MicrosoftDataTransformation Service (DTS), and Informatica.
• Good experienced indatatransformation,datamapping from source to target database schemas and alsodatacleansing.
• Excellent knowledge in using TeradataFastLoad utility to load large volumes ofdatainto empty Teradata tables in the Datamart for the Initial load.
• Used Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Expertise in writing SQLQueries, Dynamic-queries, sub-queries and complex joins for generating Complex StoredProcedures, Triggers, UserdefinedFunctions, Views and Cursors.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

DataModeling Tools: Erwin 8x/9x/r9.x, Erwin R8, ER Studio and Oracle Designer, Sybase Power Designer, Oracle Designer, BPwin, Rational Rose

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9

ETL Tools: Microsoft DTS/SSIS and Informatica 9.5, ODI

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, VB.NET

Database Tools: Microsoft SQL Server 2005/2008R2/2012, Teradata, Oracle 12c/11g/10g/9i, and MS Access

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server

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

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C++, AWK

PROFESSIONAL EXPERIENCE

Confidential, Bellevue WA

Sr. Data Architect/Modeler

Responsibilities:

• Architect and design, solutions for complex business requirements, including data processing, analytics and ETL and reporting processes to improve performance of data loads and processes.
• Developed new rules to extend eclipse plug-in checkstyle for improvement of code quality in Curam data
• Worked on maintaining and providing 24x7 Teradata database administration support for very large Teradata enterprise data warehouse environment.
• Worked on creating custom responsibilities, menus, functions, Profile Options, and OAF personalizations in Oracle EBS
• Develop a high performance, scalable data architecture solution that incorporates a matrix of technology to relate architectural decision to business needs.
• Defineddata layers/ integration methodology, quality monitoring, auditing, reconciliation and exception handling, coordination of loads, indexing, and partition and modeling/management approach.
• Define and build technical and data architectures for data warehouse, data marts and big data solutions (including data and dimensional modeling).
• Performing Business Area Analysis and logical and physical data modeling for Data Warehouse / Data Mart applications as well as Operational applications enhancements and new development. Used the Ralph Kimball Methodology for Data Warehouse/Data Mart designs.
• Create SQL code from current datamodel and create staging databases for development, testing, and regression testing.
• Frequently usedTeradata Utilities such as BTEQ and Mloadfor loading small amounts of data andFastloadfor loading huge amounts of the data into the tables and involved in writing complex SQL code usingSQLAssistantand BTEQ to generateAd-hoc reportsfor the business team.
• Worked on Data Analysis, Data Profiling, Mapping, Identify Data Quality issues, Data Cleaning, Data validation and Loading.
• CreatedODIinterfaces for transforming source data into target format.
• Analyze the Business information requirements and research the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Worked on migrating of EDW toAWSusing EMR and various other technologies.
• Coordinated with the Business Analyst and prepared Logical and PhysicalData-models as per the requirementsand Involved in making screen designs, Use Cases and ER diagrams for the project using ERWIN.
• Done data migration from an RDBMS to a NoSQLdatabase, and gives the whole picture for data deployed in various data systems.
• Developed the performance tuning of the database by using EXPLAIN PLAN, TKPROF utilities and also debugging the SQL code and identified and streamlined complex queries which were causing iterations and effecting database and system performance.
• Designed and developed thedatadictionary and Metadataof the models and maintain them and Designed Metadata Repository to storedatadefinitions for entities, attributes & mappings between datawarehouse and source systemdataelements.
• Designed and Developed Oracle PL/SQL scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Reverse Engineered theDataModels and identified theDataElements in the source systems and adding newDataElements to the existingdatamodels
• Used Normalization/De-normalization techniques in relational/dimensional environments and have performed normalizations upto 3NF (Third Normal Form).
• Extensively using Agile methodology as the Organization Standard to implement thedataModels.
• Created and TestedODIpackages and scenarios for unit and integration testing process.
• Written shell scripts to export/import database backups from RDS& keep the same in S3 (AWS Storage)
• Modeled & designed Relational/dimensional Star-Schema Data Marts(Ralph Kimball methodology) using the centralized relational Enterprise Data Warehouse as the "source" for the deployment of customized Data Marts for -targeted- business units. Used the CA/ERWINdata modeling tool.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS

Environment: Erwinvr9.6/r9.5, Rational Requisite Pro,Oracle 12c, Python, Teradata SQL Assistance, Aginity, Netezza, PL/SQL, T-SQL, AWS, MDM, DataStage, Hive, Pig, Map Reduce, Hadoop, MDM, DB2 UDB, SQL Server, SSAS, ODI, Linux,VPD, ER Studio, SQL, SQL Server 2008/2012, Rational Rose, SSRS, SSIS, Informatica, Agile.

Confidential, Quincy, MA

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.
• Worked on analysis of common APIs for IBM Curam Agenda Player and dynamically load agenda pages based on admin configuration.
• Developed XML reports for the Oracle Financials module, Oracle EBS Applications
• Gathered Business requirements by organizing and managing meetings with business stakeholders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Developed and maintained the data inventory catalog describing the types of data collected by the organization, where data is located, and how to gain access to the data for reporting and analytics.
• Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization
• Did extensive analysis ondata, profiled it before moving forward with building marts
• Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
• Created and maintained Metadata, including table, column definitions
• Used ModelMart of Erwinr9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Implementing complex business rules by creatingODIinterfaces.
• Used the Agile Scrum methodology to build the different phases of Software development life cycle.
• Developed mapping spreadsheets for ETL team with source to targetdatamapping with physicalnaming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Helped the BI, ETLDevelopers, Project Manager and end users in understanding theDataModel,dataflow and the expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Was involved in fulfilling all the end users request which fell under the general maintenance work such as adding and removing columns and tables fromdatabase not without the prior approval from BA's andDataModeling Team
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle12c, Netezza, flat files, PL/SQL Server with high volumedata.
• Performed match/merge and ran match rules to check the effectiveness ofMDMprocess on data.
• Developed the logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Facilitated JAR/JAD sessions to determinedatadefinitions and business rules governing thedata, and facilitated review sessions with subject matter experts (SMEs) on the logical and physicaldatamodels.
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata
• Useddataprofiling tools and techniques to ensuredataquality fordatarequirements.
• Used StarSchema and Snowflakeschema methodologies in building and designing the logicaldatamodel in the dimensionalModels.
• Developed Cleansing anddatamigration rules for the Integration Architecture (OLTP, ODS, DW).
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
• Developed complex SQL code using complex Joins, Group By, Having, Sub Queries, Correlated Sub Queries, Functions, and User Defined Functions.
• Transformed requirements intodatastructures which can be used efficiently to store manipulate and retrieve information.

Environment: Oracle 11g, Teradata 13.10, Microsoft 2008, SQL Developer, ER Studio, SQL DeveloperDataModeler, Visio, MDM, HIPPA, Agile, SAP Business Objects, Informatica, Crystal Reports, ER Studio 9.1.0, Netezza, ODI, Erwin, SSAS, T-SQL, Excel, Python.

Confidential, Chicago, IL

Sr. Data Architect/ Modeler /Analyst

Responsibilities:

• Gathered Business requirements by organizing and managingmeetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization
• Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
• Created and maintained Metadata, including table, columndefinitions
• Created DDL scripts for implementingDataModeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, PublishedDatamodel in model mart, created naming convention files, co-coordinated with DBAs' to apply thedatamodel changes.
• MaintainMDMrepositories and applications to ensure data quality.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository
• Developed the logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata.
• Created landing tables, stage tables and base objects inMDMand ran batch jobs which load data into base objects.
• Developed and executed queries in SQL for reporting using SQL Manager
• Used StarSchema and Snowflake schema methodologies in building and designing the logicaldatamodel in the dimensional Models.
• Assisted developers, ETL, BI team and end users to understand thedatamodel.

Environment: Teradata 13.10, Microsoft SQL Server 2012, SSIS, SQL Manager, Erwin 8.0, Visio, Informatica, Netezza, Business Objects XI,ODI, VPD, T-SQL, Agile, MDM, Teradata SQL Assistant, SSAS, ER Studio 9.1.0, Linux, Excel.

Confidential, Richmond, CA

Sr. Data Analyst /Modeler

Responsibilities:

• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and PhysicaldataModels.
• 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
• Involved with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin tool.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Worked on complex mappings inODIto map the source xml data with Oracle Data Servers.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for the MasterDataManagement Architecture involving OLTP, ODS.
• Served as a member of a development team to provide businessdatarequirements analysis services, producing logical and Physicaldatamodels using Erwin.
• Exploreddatato identify its model role and measurement level. Verifieddatafor missing values and incorrectdata. And then cleaned and structured thedatabased on the format required.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables
• Enhanced the old Excel files and Crystal Reports to new SQL Server Reports to fit new business requirement and implemented into SQL Server.
• Used Star schema methodology in building and designing the logicaldatamodel in the dimensional Models.

Environment: Erwin, Rational Requisite Pro,SSAS, SSIS, T-SQL, DataStage, DB2 UDB, SQL Server, Linux, Excel, ER Studio, SQL, SQL Server 2000/2005, MDM, Netezza, Rational Rose, Oracle 10g

Confidential, San Jose, CA

Sr. Data Analyst /Modeler

Responsibilities:

• Actively involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Databasetriggers, StoredProcedures) in thedatamodel.
• Presented thedatascenarios via, Erwin logicalmodels and excel mockups to visualize thedatabetter.
• Worked on building thedatamodel using ERStudio as per the requirements, discussion and approval of the model from the BA.
• Involved withDataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData, DataDefinitions andDataFormats
• Designed and Developed logical&physicaldatamodels and MetaDatato support the requirements using Erwin
• Creating Variables, Sequences, User functions, Scenarios, Procedures, mappings, re-usable mappings and Packages inODI.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physicaldatabase (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin
• Design and develop thedataload process using XML Style sheets andACORD.
• Created complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.
• Involved withDataProfiling activities for new sources before creating new subject areas in warehouse
• Wrote Use Case forACORDDataModeling.
• Tested the ETL process for both beforedatavalidation and afterdatavalidation process. Tested the messages published by ETL tool anddataloaded into various databases
• Experienced in creating UNIX scripts for file transfer and file manipulation.
• Successfully created and managed a conversion testing effort which included adataquality review, two system test cycles, and user acceptance testing.
• Worked on operationaldatastore withdatamodeland a set of business objects that conform toACORDXML standards
• Involved with data cleansing operations using SSIS transformations and T-SQL scripts to normalize the data and remove and identify potential problem points when moving information into a data warehouse.
• Ensured onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: DB2,, Oracle 10g, VISIO, MS-Office, SQL Architect, T-SQL, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint,Netezza, ODI, MDM, SSAS, ERwin r8.0, MS-Office, SQL Server 2008/2012,, VISIO, ACORD.

Confidential

Sr. Data Analyst

Responsibilities:

• Worked with a variety of levels of Information Services personnel to independently analyze complex datarequirements, developed/managed and updateddatamodels, and develop database designs.
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Created DML code and statements for underlying & impacting databases.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Perform data reconciliation between integrated systems.
• Written complex SQL queries for validating the data against different kinds of reports
• Supported business areas and database platforms to ensure logical data model and database design, creation, and generation follows enterprise standards, processes, and procedures

Environment: ERwin, Oracle, SQL server, MS Excel, MS Visio, Rational Rose, Requisite Pro, SSAS, RationalRose.