SUMMARY

• 71/2 years of IT experience indata modeling, designing anddata analysis with conceptual, logical and physical modeling for Online Transaction Processing (OLTP), Online Analytical Processing (OLAP) andData Warehousing.
• Experience in requirements gathering, strategic analysis application and decision support, which plays a crucial role in software development life cycle (SDLC).
• Professional experience in Data Modeling and Data Analysis. Proficient in gathering business requirements and handling requirements management.
• Proficient knowledge in Data Profiling and developing conceptual, logical and physical data models.
• Worked extensively on CA Erwin in several projects in both OLAP and OLTP applications.
• Well versed in Normalization/De - normalization techniques for optimum performance in relational and dimensional database environments.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Developed mapping documents for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Experienced in system Analysis, ER Dimensional Modeling, Data Design and implementing RDBMS specific features.
• Strong database integration experience and have worked on analyzing data needs, identifying relational databases.
• Experienced in designing the datamart and cubes.
• Well experienced in Extract transport and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS).
• Experienced in writing data quality rules to ensure quality, consistency and accuracy of data.
• Extensive knowledge of writing SQL queries, working with back end tools such as Toad for data validation and verification.
• Worked Extensively across various DBMS like SQL Server (SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005), Oracle 10g/11g, Teradata and IBM DB2.
• Excellent Analytical, Inter-personal and communication skills with ability to interact with individuals at all the levels in the software development life cycle.
• Excellent problem solving skills with exceptional ability to learn and master new technologies e ciently.

TECHNICAL SKILLS

Databases: SQL Server 2008, Oracle 11g, Teradata V2R12

Data Modeling Tools: Erwin Data Modeler, IBM InfoSphere Data Architect 7.6.0 (IDA), IBM Rational Team Concert 3.0.1 (RTC) and ER/Studio

ETL Tools: Microsoft DTS/SSIS, Informatica Power Center 9x/8x.

Skillset: Data Modeling (ER Dimensional), Database Design, Requirement Analysis, Object Oriented Design, Data mapping, Master Data Management, Documentation, Project Management

Languages: C, C++, HTML, SQL, PL/SQL, XML

Reporting Tools: SSRS, Oracle Business Intelligence, Objects 5.x /6.x,Crystal reports XI

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Senior Data Modeler/Analyst

Confidential, Somerset, NJ

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Lead multiple project teams through all phases of the SDLC using technologies including Erwin, SQL and Data Warehousing.
• Experienced in developing reports in Visual Studio and deploying them to Report Manager.
• Used Agile Methodology by Scrum method. Attended day/weekly meetings.
• Experienced in migratingCognosreports and SSRS reports to MicroStrategy reports.
• Acted as a liaison between business and technical teams to articulate needs, issues and concerns. Performed data modeling to di erentiate between OLTP and Data Warehouse data models.
• Experienced in gathering requirements with end users, understanding business requirements, product demonstration and product support using MicroStrategy as a BI tool.
• Reverse Engineered the existing ODS into Erwin.
• Developed logical and physical data models that capture current state/future state data elements and data flow using Erwin.
• Worked with Master Data Management.
• Defined functional test cases, documented test scripts.
• Designed data stage ETL jobs for extracting data from heterogeneous source system, transform, and finally load into the Data Marts.
• Designed and developed use cases, activity diagrams, and sequence diagrams using XML. Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Lead the team in designing and developing rules and processes for data exchange and file transfers. Ensured that project requirements are properly tracked and documented.
• Successfully conducted JAD sessions, which helped synchronize di erent stakeholders on their objectives and helped the developers to have better understanding about the project.
• Created UML diagrams including context, Business Rules Flow, and Class Diagrams.
• Implemented RUP recommended visual models to draft requirements using business use cases.

Environment: ERWIN 3.5, ER/ Studio, SQL Server 2008, Oracle 10g, MS Excel, MS Visio, MS Access, UML, RUP, SharePoint 2003, Master Data management, Data Cleansing.

Senior Data Modeler/Analyst

Confidential, Cleveland, OH

Responsibilities:

• Conducted team meetings and Joint Application Design (JAD) session.
• Developed a Conceptual model using Erwin based on business requirements.
• Analyzed and created business intelligence reports in both SSRS and MicroStrategy according to business requirements.
• Created grid reports, graph reports, drill down and drill through reports.
• Developed normalized Logical and Physical database models to design OLTP system for finance applications. Created dimensional model for reporting system by identifying required dimensions and facts using Erwin r8.0.
• Produced functional decomposition diagrams and defined logical data model.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems
• 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.
• Created physical data models using forward engineering
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of Erwin for e ective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Consulted with client management and sta to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Worked with ad-hoc reporting using Crystal Reports 9 and T-SQL.

Environment: Erwin r8.0, SQL, SQL Server 2000/2005, Rational Rose, Master Data, Data Cleansing, Windows XP, Oracle 8i, Windows XP/NT/2000.

Data Modeler/Analyst

Confidential, Houston, TX

Responsibilities:

• Developed logical and physical data models for central model consolidation.
• Attending meetings to finalize strategies for handling various concepts like error handling and slowly changing dimensions.
• Preparing test cases documents to provide testing logic used for validating the ETL.
• Created / tuned existing stored procedures and macros to increase the performance of the database server. Implemented reusability by creating Mapplets, Reusable transformation.
• Creating sessions, work lets and workflows for carrying out test loads.
• Creating new relational connections and modifying existing relational connections for facilitating migration to new development boxes.
• Worked with Waterfall model in Agile methodology.
• Data validation using tools like TOAD 6.3.11.1 and SQL NAVIGATOR.
• Resolved issues by conducting and participating in JAD sessions with the Business users, development team and Infrastructure team.
• Consolidated existing SSRS reports to MicroStrategy reports without losing the functionality.
• Created command tasks for various like merging flat flies after loading and for creating event raise file.
• Created stored procedures for extracting XML Message, simulating data for carrying out Post session loads. Using SQL Servers Enterprise manager for writing Queries and exploring data.
• Proven ability to interface and co-ordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.
• Creating stored procedures to populate sample data and carrying out test load with multi- terabyte databases.
• Implementing the Data management strategies across the various database domains and products with respect to each business unit.

Environment: ERWIN 3.5, ER/ Studio, Informatica Power Mart 6.2, TOAD 6.3.11.1/SQL NAVIGATOR, SQL and PL SQL, Oracle 9i, DB2, SQL Server 2000, Teradata V2R5.

Data Modeler/Analyst

Confidential, Hudson, MI

Responsibilities:

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Developed Logical and Physical data models for central model consolidation.
• Worked with DBAs to create a best-fit physical data model from the logical data model.
• Used Erwin r7.0 for e ective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed process methodology for the Reverse Engineering phase of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram) Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata. Worked with report developers for building OLAP Cubes for ad hoc reporting.
• Involved in the critical design review of the finalize database model. Generating ad-hoc repots using Crystal Reports.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin r7.0, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000 servers, Oracle, SQL Server 2000/2005, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal Reports, MS-SQL server analysis manager.

Data Modeler

Confidential

Responsibilities:

• Gathered complete business and technical requirements by organizing with Business Analysts and Subject Matter Experts on a regular basis.
• Analyzed various Source Systems and Operational Data Store and research the tables/entities required for the project.
• Designed and Implemented Operational Data Store for dispute management using power designer.
• Participated in design review meeting with business and SME’s to verify the conceptual models.
• Designed and maintained the Logical /Physical Dimensional Data models followed by generating the DDL statements and physically running them in both test and dev environments for physical creation of tables.
• Worked with DBA to perform intensive data profiling and reverse engineered various already existing databases in order to discern the necessary data relationships underlying general and specific information needs.
• Developed Source to Target mappings for ETL support.
• Participated in meetings with the ETL coding and development team to co-ordinate the process of workflow among the team.
• Created one on one views and involved in the critical Design review of the finalized database model.

Environment: Erwin r7.0, SQL Server 2005/2008 Enterprise Edition, MS PowerPoint, MS Access 2000,Windows 2003/2000 platform, DTS, SSIS, SSRS.

Data Modeler/Analyst

Confidential

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements.
• Worked on profiling source data to determine the key consistency, data type, size, etc. Worked on logical and physical model using Erwin based on requirements.
• Worked with DBA to create the physical model and database objects. Worked closely with ETL team in loading and mapping the data.
• Created Source-to-target (S2T) mapping document as part of Data Analysis. Designed tables for staging and integration layers.
• Involved in data migration from staging to integration.
• Worked with DBA in designing to cater initial and incremental load.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Database triggers etc.). Dealt with di erent data sources ranging from flat files, Excel, Oracle, and SQL Server.
• Communicating with the project team throughout all stages of design, managing time e ectively, and work on project timelines simultaneously in demanding deadline driven environment.

Environment: CA Erwin 7.2, Oracle10g, UNIX, MS Excel 2007, Oracle ware house builder 10g, SAS 9.2, SQL server10.