SUMMARY

• Having 8+ years of technical experience in Data analyses and DataModeling business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
• Experienced Data Modeler with strong conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Experienced in designing ODS architecture for modeling a Data Warehouse by using tools like ERwin, Power Designer and E - R Studio.
• Strong Design experienced in transforming requirements into a "logical" solution-upkeep of physical data model, detailed data flow between tables and/or views, and associated pseudo code.
• Excellent experience in data migration and replication techniques across different platforms & DB2 versions using export/ import, Load, transportable table spaces and materialized Query Tables
• Implemented Enterprise data warehouses with Bill Inmon's approach building 3rd normal form models at the base level to integrate data and on the top of it built reporting layer consisting of Dimensions and Facts.
• Good experience withMetadata management, Data Migration, Data Conversions, DataExtraction/Transformation/Loading (ETL) and validation for Data Consistencies.
• Experienced in implementing normalization/demoralization techniques for optimum performance in OLTP/OLAP database environments.
• Experienced in Technical consulting and end-to-end delivery with architecture, data modeling, data governance and design - development - implementation of solutions.
• Experienced in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML)
• Strong experienced in Teradata RDBMS … application performance tuning, Teradata SQL optimization, database design (conceptual & physical), application support, tuning and optimizing bad queries and handling database maintenance works.

TECHNICAL SKILLS

Data Modeling Tools: PowerDesigner 15.2, Erwin, ER Studio, Access, Visio, Erwin

Utilities/Tools: TOAD, SQL Navigator, Teradata SQL Assistant, IBM BMC Catalog Manager, Oracle SQL Developer, Aginity Workbench for Netezza

Data warehouse Tools: Informatica, Cognos, Oracle Warehouse Builder, SQL Developer

Database systems: ORACLE 9i/10g/11g/12c, DB2, Teradata, SQL Server 2005, Netezza

Operating systems: UNIX, WINDOWS, MS-DOS, Linux

Metadata: Adaptive Metadata Manager

Testing Tools: HP Quality Center, QTP, Win Runner, Load Runner

ETL Tools: DataStage, Informatica Power Center, OWB (Oracle WarehouseBuilder) 10g Release 2

Other Tools: MS Office, Clear Quest, Princeton Softech, Oracle APEX

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Data analyst / Data Modeler

Responsibilities:

• Interacted with users and business analysts to gather requirements.
• Worked on designing a star schema for the detailed data marts and plan data marts involving confirmed dimensions.
• Developed and maintained an Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage the enterprise data warehouse. This effort involves working closely with the business.
• Involved in Data Architecture, Data profiling, Data analysis, data mapping and Data architecture artifacts design.
• Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Created Semantic Layer for reporting tools.
• Performed Reverse Engineering of the current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Involved in capturing all business entities, Logical and Physical Data Model design to demonstrate business process flow, DDL Script creation for Database object using Erwin and its implementation and optimization. Collaborate with the data warehouse team and the business partners in designing Data Marts.
• Emphasize methodology, modeling, and governance: Define the IT design methodology, development process methodology and best practices.
• Establish and maintain data standards, policies and architectures.
• Identify opportunities for standardizing data descriptions, integration and archiving, and elimination of unnecessary redundancy.
• Capture and maintain metadata, creating business rules for the use of data.
• Creation of enterprise metadata that can be used across all line of business in Confidential Bank.
• Created technical documentation such as data architecture design documents, ETL mapping specs and Data Model design and changes artifacts.
• Involved in end-to-end design, development, implementation and post implementation support in resolving complex data and technical issues.
• Created stored procedures, functions, database triggers and packages as per the business needs for developing ad hoc and robust reports.
• Involved in logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Analyzed data results from use of business processing software and provides conceptual solutions to systems design work.
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created Data Mapping documents which capture the source of data, any business rule to be applied to meet the internal customer needs of data.
• Met with the data modeling team once every week and discuss the standards and other data modeling related issues.

Environment: Erwin 9.5, Teradata, Mercury Quality Center 9, Oracle12c, MS Excel, Mainframes, Unix

Confidential, Minneapolis, MN

Sr. Data analyst / Data Modeler

Responsibilities:

• Performed variousdataanalysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for an effectiveDataWarehouse andDataMart.
• Involved with impact assessment in terms of schedule changes, dependency impact,code changes for various change requests on the existingDataWarehouse applications that running in Production environment.
• Created logical and physicaldatamodels using Erwin and reviewed these models with business team anddataarchitecture team.
• DevelopedDataMapping,DataGovernance, Transformation and Cleansing rules for the Master DataManagement Architecture involving OLTP, ODS and OLAP.
• Worked onOptimization of the application and the designing of the database tables with the right partitioning keys using the DPF feature of hash partitioning and range partitioning.
• Performed cross-platform database migration for development & Production databases running on Sun OS to LINUX using utilities such as db2move and db2look.
• Transformed LogicalDataModel to PhysicalDataModel ensuring the Primary Key and Foreign Key relationships in PDM, Consistency of definitions ofDataAttributes and Primary Index Considerations.
• ImplementedDataArchiving strategies to handle the problems with large volumes ofdataby moving inactivedatato another storage location that can be accessed easily.
• Worked closely hand in hand with the Business Analytics manager, who was also a part of the design/datamodeling team
• Experience in Project development and coordination with onshore-offshore ETL/BI developers & Business Analysts.
• Coordinatedwith ETL team, DB administrators& BI teams to elevate thedatamodel changes in the system
• Prepared scripts for model anddatamigration from DB2 to the new Appliance environments.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve performance.

Environment: Erwin 8, DB2, Informatica, Quality centre, SQL Server 2008, Business Objects, Unix, Teradata, Netezza

Confidential, Columbus, OH

Sr. Data analyst / Data Modeler

Responsibilities:

• Experienced in Data modeler performing business area analysis and logical and physical data modeling using Erwin for data warehouse/data mart applications as well as operational applications enhancements and new development. Data warehouse/data marts design was implemented using Ralph Kimball methodology.
• Highly Maintained the stage and production conceptual, logical, and physical data models along with related documentation for a large data warehouse project. This included confirming migration of data models from Oracle Designer to Erwin and updating the data models to correspond to the existing database structures.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using Erwin.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Created the data flow and data path diagrams to show the interactions between the various applications.
• Contributed to develop the Data Model Release process flow to provide transparency & visibility to the Management/Consumers.
• Created/ Tuned PL/SQL Procedures, SQL queries for Data Validation for ETL Process.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in Erwin and worked with the naming standards utility.
• Involved with generating comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Utilized PL/SQL to write stored procedures, functions, triggers, views.
• Worked on various databases like Oracle, DB2 and Teradata.

Environment: ERWIN 7.3, TOAD for oracle, SQL Server Management studio, SQL Enterprise Manager, Informatica 8.6, Oracle 9i, SQL, PL/SQL, Business Objects, Teradata, SQL, SQL Server 2000/2005, Rational Rose, Crystal Reports 9, Windows XP, Oracle 8i, Windows 8/7/XP.

Confidential, Westchester, PA

Sr. Data analyst / Data Modeler

Responsibilities:

• Involved in creating Physical and Logical models using Erwin.
• Presented the data scenarios via, Erwin logical models and excel mockups to visualize the data better.
• Provided subject matter expertise as appropriate to ETL requirements, information analytics, modeling & design, development, and support activities.
• Designed and Developed logical & physical data models and Meta Data to support the requirements using Erwin
• 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
• Designed 3rd normal form Confidential data model and mapped to logical model.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Designed and developed cubes using SQL Server Analysis Services(SSAS) using Microsoft Visual Studio 2008
• Troubleshoot test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Responsible for different Data mapping activities from Source systems to Teradata.

Environment: Informatica 8.1, Data Flux, Oracle 9i, PL/SQL, Business Objects XIR2, ETL Tools Informatica 8.6/9.1 Oracle 11G, Teradata V2R12/R13.10, Teradata SQL Assistant 12.0, ERWIN data modeler, ODS

Confidential, Boston, MA

Data analyst / Data Modeler

Responsibilities:

• Worked on interviewing business users to gather requirements and documenting the requirements.
• Used Erwin and created Conceptual, Logical and Physical data models.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas
• Wrote ad-hoc SQL queries and worked with SQL and Netezza databases.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Created UNIX scripts for file transfer and file manipulation.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Defined the Scope for System and Integration Testing
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios)
• Participated in DRB review meetings and updated model as per their review comments.
• Worked closely with users, business analysts and team members to understand business requirements and the design of technical specification.
• Worked on Creating appropriate metadata& documentation.

Environment: Windows XP, Informatica Power Center, QTP, Test Director 7.x, Load Runner 7.0, Oracle, UNIX AIX 5.2, PERL, Shell Scripting, Netezza, Erwin