SUMMARY

• 11+ yearsin Information Technology with Expertise in Data architecture and Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Excellent experience in delivering Quality Conceptual, Logical and PhysicalDataModels for Multiple projects involving various Enterprise New and Existing Applications andDataWarehouse.
• Experienced designing, implementing and transforming enterprise application databases and schemas.
• Experienced in database management, strategicanalysis, requirements gathering, application and decision support, which plays a key role in software development life cycle (SDLC).
• Experienced Data modeling(Dimensional & Relational)concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Strong experience in customer communication, requirement analysis,dataprofiling,understanding technical architecture, ETLarchitecture
• Excellent development experience SQL, Procedural Language(PL) of databases like Oracle, Teradata, Netezza and DB2
• Excellent knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Experienced in Master Data management to improve data quality, share it broadly, manage change, and comply with regulations and standards.
• Experienced in logical/physicaldatabase design and review sessions to determine and describedataflow anddatamapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Expertise in gathering systems requirements, creating and performing test scenarios/test cases supporting new business requirements and planning to test runs providing executable status.
• Excellent experience working on Netezza/Teradata and writing heavy SQLqueries.
• Excellent SQLprogramming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL. Performance tuning and query optimization techniques in transactional anddatawarehouse environments.
• Experienced in analyze data requirements which support the business processes and convert them into conceptual(Subject Level), logical data model (LDM), Physical Data Model (PDM).
• Experienced in Teradata EnterpriseDataWarehouse (EDW) andDataMart.
• Experienced in Business Intelligence (SSIS, SSRS),Data Warehousing and Dashboards.
• Experienced in understanding the ETLframework metadata to understand the current state ETL implementation.
• Experienced in implementing Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Extensive success in translating business requirements and user expectations into detailed specifications employing UnifiedModelingLanguage (UML)
• Experienced in Code review, design review process review ofTeradatadata warehouse system.
• Extensive ETLtesting experience using Informatica9x/8x.
• Excellent documentation skills for creating artifacts around business, architectural, and design solution.

TECHNICAL SKILLS

Analysis and Modeling Tools: Erwin r9.6/9.x/r8.x, Sybase Power Designer, Oracle Designer, BPwin, ER/Studio.

ETL Tools: Informatica Power Center 9.5/9.x, SSIS

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, CognosPowerplay

Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting.

Databases: Teradata 15/14/14.1/13/13.1 , MS Access 2000, Oracle, Netezza

Operating Systems: Windows 8/7, UNIX (Sun Solaris 10)

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

PROFESSIONAL EXPERIENCE

Confidential, Lexington, KY

Sr. Data Architect/Data Modeler

Responsibilities:

• Developed strategic oversight and planning of data models and database design within the CRM platform. Works with key stakeholders to understand the data requirements and translates strategic requirements into usable enterprise information architecture. Ensures existing data/information assets are identified, documented, stewarded, and leveraged across the organization.
• Used Erwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Working with variousTeradatatools and utilities likeTeradataViewpoint, MultiLoad, ARC, TeradataAdministrator, BTEQ and otherTeradataUtilities.
• Conducting complex Notes ETLdata migrations to include assessing, planning, implementation, software development and data validation.
• Analyze change requests for mapping of multiple source systems for understanding of Enterprise wide information architecture to devise Technical Solutions.
• Developing data and metadata policies and procedures to build maintain and leverage data models, ensuring compliance with corporate data standards.
• Identified the Facts and Dimensions from the business requirements and developed the logical and physicalmodels using Erwin.
• Used TeradataFastLoad utility to load large volumes ofdatainto empty Teradata tables in the Datamart for the Initial load and Used TeradataFastExport utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Generated comprehensive analytical reports by running SQLqueries against current databases to conductdataanalysis.
• Handled performance requirements for databases in OLTP and OLAP models.
• Understand and analyze business data requirements and architect an accurate, extensible, flexible and logical data model.
• Prepared complex SQL/Rscripts for ODBC and Teradataservers for analysis and modeling.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flatfiles, SQLServer with high volume data
• Developed complex Stored Procedures for SSRS(SQL Server Reporting Services) and created database objects like tables, indexes, synonyms, views, materialized views etc.
• Documented ERDiagrams, Logical and Physicalmodels, business process diagrams and process flowdiagrams.
• Created complex SQLserver12 and Oracle stored procedures and triggers in support of the applications with Error handling.
• Created mappings, mapplets and reusable transformations in Informatica. Also used several transformations like expression, Aggregator, Lookups, Joiner, Normalizer, Router, updatestrategy, Filter, Union, Sequence Generator, Stored Procedure, Source qualifier, XMLtransformation, etc.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Used SQL for Querying the database in UNIX environment
• Fine-tuned the mappings using push down optimization, session partitioning, bulk load, fast load, etc.

Environment: Erwin r9.6, Informatica Power Center, Teradata, Oracle 12c, Microsoft SQL Server 20012, SVN tool, BTEQs, Mload, Fast Load, UNIX scripting, PLSQL Programming

Confidential, Chicago, IL

Sr. Data Architect/Modeler

Responsibilities:

• Defineddata/information architecture standards, policies, and procedures for the organization.
• Applies data content standards, promoting consistency and best practices and integration and application development, by establishing and operationalizing data architecture practices that focus on organizing.
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Gathered and analyzed existing physicaldatamodels for in scope applications and proposed the changes to thedatamodels according to the requirements.
• Generated and DDL(DataDefinition Language) scripts using ERWIN and assisted DBA in Physical Implementation ofdataModels and Worked withdatain the tables to analyze and modify by writing DML scripts.
• Responsible for the gathering, preparation, analysis/interpretation, and reporting of large amounts of data to decision-makers.
• Used reverseengineering to connect to existing database and create graphical representation (E-Rdiagram) using Erwin
• Involved in extensive data validation by writing several complexSQL queries and Involved in back-end testing and worked with data quality issues.
• Developed and kept current, a high-level data strategy that fits with the Data Warehouse Standards and the overall strategy of the organization.
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Generated data extractions, summary tables and graphical representations in SAS, Excel, and R, PowerPoint.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Made strategic recommendations based on data analysis and insights incorporating business requirements.
• Streamline reporting, improve office processes, and adapt existing systems to new requirements.
• Created Source- Target SQLscripts for all the transformation rules mentioned in the mapping document.
• Analyzeddatafrom different perspectives and summarized it into useful information byDataMining Techniques.
• Performed data analysis and dataprofiling using complex SQL on various sources systems including Oracle, SQLserver and DB2
• Used TeradataSQLAssistant, TeradataAdministrator, PMON and data load/export utilities like BTEQ, FastLoad, MultiLoad, FastExportand Tpump on UNIX/Windows environments and running the batch process for Teradata.

Environment: ERWIN, PL/SQL, Oracle 11g, SQL/PL, SQL Navigator, UNIX, Microsoft Access, Teradata 14.1, Netezza, Teradata SQL assistant, Microsoft Visio, SQL Server 2008, MS PowerPoint, MS Access, Microsoft Excel.

Confidential, New York, NY

Sr. Data Analyst/Modeler

Responsibilities:

• Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization.
• Created, developed and reviewed the physical model created from the logical model ensuring the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of data modeling, database design and maintenance.
• Created a list of domains in Erwin and worked on building up thedatadictionary for the company.
• Created Entity Relationships diagrams, dataflowdiagrams and implemented referential integrity using ERWIN.
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and the expected output for each model created.
• Designed the ERdiagrams, logicalmodel (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
• Producedentity relationship diagrams, logical model diagrams, physical model diagrams and logical to physical database mapping.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Designing and customizingdatamodels forDatawarehouse supportingdatafrom multiple sources on real time.
• Created Physical Data Model (PDM), generate DDLs and work with DBA to implement physical data model.
• Defined the PrimaryKeys (PKs) and ForeignKeys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flatfiles, SQLServer with high volume data
• Resolved data issues 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.
• Extracteddatafrom the databases (Oracle and SQL Server) using Informatica to load it into a single datawarehouse repository of Teradata
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of dataanalysis responsibilities.
• Designed different type of STARschemas for detaileddatamarts and plandatamarts in the OLAP environment.
• Supported the DBA in the physical implementation of the tables in Netezza, Oracle and DB2 databases.
• Created Inbound Interfaces to pull the data from source toTeradata.
• Involved in modeling business processes through UMLdiagrams.
• Created entity process association matrices, functional decomposition diagrams anddataflow diagrams from business requirements documents.

Environment: Erwin, Business Objects XI R2, Windows Server 2003, DB2, Oracle 10 g, SQL Server 2005, Oracle DBMS, SQL, PL/SQL, Shell scripts, Loader, MS Access, MS PowerPoint, MS Excel.

Confidential, Wilmington, DE

Sr. Data Analyst/Modeler

Responsibilities:

• Analyzes and develops conceptual, logical and physical data models, and corresponding metadata definitions for the enterprise environment and all associated data marts, data stores, etc.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracleand Teradata.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• Extensively used ETLmethodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Created map attributes from one system to another helping in normalization of data Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Responsible for analyzing variousdatasources such as flat files, ASCIIData, EBCDICData, RelationalData(Oracle, DB2 UDB and MS SQL Server) from various heterogeneousdatasources.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Created new informatica interfaces to pull data fromTeradataEDW to Oracle.
• Involved in Uploading Master and Transactionaldatafrom flat files and preparation of Test cases, Sub System Testing.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Responsible for differentDatamapping activities from Source systems to Teradata.
• Involved in the Working of BTEQ, TPT, and Fastload to load the data.
• Created the test environment for Staging area, loading the Staging area withdatafrom multiple sources.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs,datawarehouse/datamart/datastore models.
• Excellent in creating various artifacts for projects which include specification documents,datamapping anddataanalysis documents.

Environment: Teradata SQL assistant, Erwin, MS Visio, MS Access, Microsoft Excel, Micro Strategy, SQL, Teradata, Netezza.

Confidential, Alpharetta, GA

Data Analyst

Responsibilities:

• Collection of requirements from business users and analyzed based on the requirements.
• Identified new sources of data and methods to improve data collection, analysis, and reporting.
• Designed and builtDatamarts by using Star Schema.
• Involved in designing ContextFlow Diagrams, StructureChart and ER- diagrams.
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Identify, analyze, and interpret trends or patterns in complex data sets Locate and define new process improvement opportunities
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Developed businessdatarequirements analysis services, producing logical and Physicaldatamodels using Erwin.
• Created tables, views, procedures and SQL scripts.
• Used MSVISIO for Creating of Process flow diagrams.
• Utilized organizational standards fordatanaming, structuring and documentation.
• Designed Data Marts using dimensional modeling and wrote PL/SQL ETL packages with Oracle PL/SQL to extract data from relational data store transform and load into the data mart.
• Used Erwintool for relational database and dimensionaldatawarehouse designs.
• Responsible for defining database schemas to support businessdataentities and transaction processing
• Writing and executing customized SQLcode for ad hoc reporting duties and used other tools for routine
• Worked as part of a team of DataManagement professionals supporting a Portfolio of development projects both regional and global in scope.
• Understood existing data model and documented suspected design affecting the performance of the system.

Environment: Oracle 9i, Erwin, Rational Requisite Pro, Crystal Reports, Cognos, Rational Rose, Windows XP, MS visio, Teradata, Informatica.