SUMMARY

• 7 years of extensive experience in Business Analysis, Data Analysis, Modeling, Design and Development of Databases in OLTP and Data Warehouse environments working on multiple domains like Banking, Mortgage, Healthcare, Property and Casualty Insurance industries across various clients.
• Strong Experience in Relational Data Modeling & Dimensional Data Modeling to deliver Relational and Dimensional Data Models (Star and Snowflake) schemas using Erwin 7.2, ER Studio 7.1, Sybase Power Designer 12.1/12.5/15/16.5.
• Worked extensively across various DBMS’s like SQL server (SQL Server 2008 R2, SQL Server 2005 and SQL server 2000), Oracle 10g/11i and Teradata, IBM DB2.
• Strong SQL scripting work experience, complicated query designs query optimization.
• Acted as a strong liaison between business users and IT personnel, following the best practices in the field.
• Proficient in using UML for Business Process Modeling, Use Cases, Sequence Diagrams, Data flow Diagrams, Collaboration Diagrams, Documenting them in Microsoft Visio.
• Experience in Database Modelling.
• Extensive in Data Mart/ Data Warehousing experience.
• Knowledge and experience with Data migration, Data mapping, ETL, and reporting process.
• Strong understanding of all phases of Software Development Life Cycle (SDLC) such as Development, Testing, Migration and Production support.
• Strong RDBMS concepts and working experience using various database objects across various industry standard databases.
• Good understanding in reporting using Business Objects, Crystal Reports.
• Excellent Analytical, Inter - personal and Communication skills with ability to interact with individuals at all levels in Software Development Life Cycle.
• Strong experience in translating business needs into technical design and solutions.

TECHNICAL SKILLS

Databases: SQL Server 2005/ 2000, Oracle 10g/9i, DB2 UDB 8.0, Teradata V2R5, Teradata V2R12.

Modeling Tools: ERWIN 7.x/9.6, PL/SQL, INFORMATICA, Power Designer, Toad, SQL *Loader, SSIS, T-SQL, SQL*Plus, Oracle Designer, ERWIN, SharePoint 2003, Teradata.

Methodologies: Joint Application Development (JAD), Rational Unified Process (RUP), Unified Modeling Language (UML), System Development Life Cycle (SDLC)

Skillset: Data Modeling (ER & Dimensional), Database Design, Requirement Analysis, Object Oriented Design, Development, Testing, Data Mapping, Metadata Management, Master Data Management, Data profiling, Documentation, Project Management.

Languages: PL/SQL, HTML, JSP.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Data Modeler/Data Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Lead multiple projects terms of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Warehousing, and Cognos.
• Acted as a liaison between business and technical staff to articulate needs, issues, and concerns.
• Performed data modeling to differentiate between OLTP and Data Warehouse, data models.
• 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.
• Defined functional test cases, documented, executed test scripts in Facets system.
• 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.
• Converted various SQL statements into stored procedures there by reducing the number of database access.
• 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.
• Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
• Successfully conducted JAD sessions, which helped synchronize different stakeholders on their objectives and helped the developers to have better understanding about the project.
• Develop and maintain sales reporting using MS Excel queries, SQL in Teradata, and MS Access.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created UML diagrams including context, Business Rules Flow, and Class Diagrams.
• Implemented RUP recommended visual models to draft business requirements by using use cases.

Environment: ERWIN 3.5, ER/ Studio, SQL and PL/SQL, Oracle 9i, DB2, SQL Server 2000, Teradata V2R5. MS Excel, MS Visio, MS Access, UML, RUP, SharePoint 2003.

Confidential, Hartford, CT

Data Modeler

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.
• 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.
• 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.

Confidential, Richmond, VA

Data Analyst/Data Modeler

Responsibilities:

• Gathering Business and Specification Requirements from the Business users and also with the Technical team.
• Providing a high level Conceptual Data Model to the Business Users once the Business Requirements are evaluated and finalized.
• Create source to target mapping documents involving the Business rules and transformation rules.
• Create Logical Data Model (LDM), Implementation Logical Data Model (ILDM) and Physical Data Models (PDM) using Erwin data modeling tool.
• Reviewing the High Level Design (HLD) Document and Design Specification Documents provided to the ETL technical team once the Logical Data Model is reviewed and approved by the business users.
• Further Implementation Logical Data Model and Physical Data Models are also reviewed with the Application/Platform DBA was the models are created in the assigned environment.
• Implementing the Data management strategies across the various database domains and products with respect to each business units.
• Providing data sets to the user queries on day to day bases to determine the performance and quality of the test data.
• Design and direct the implementation of security requirements for the data warehouse and direct the information access and delivery effort for the data warehouse.
• Direct the data warehouse Meta data capture and access effort and also define Meta data standards for the data warehouse.
• Working closely with the Data Stewards to ensure correct and related data is captured in the data warehouse.
• Providing Project and Architectural Assessment before the projects are deployed into production.

Environment: CA Erwin Data Modeler 7.3.9, CA Erwin Modeler Navigator 7.3, Oracle 10g/11g, Teradata V2R12, Teradata SQL Assistant 12.0, Business Objects.

Confidential, Chicago, IL

Business Analyst/Data Analyst

Responsibilities:

• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Requirements & Business Process Analysis; Rapid Audit of the requirements and existing systems.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Design & Implementation of Data Mart; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Involved incapturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Identifying the facts & dimensions; grain of the fact; aggregate tables, for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning)
• Create and alter SQL statements before sending database change request to DBA team.

Environment: UNIX, Sybase, Business objects, DB2, SQL server, PL/SQL, ERWIN 4, Power Designer, Teradata v 7.0, AIX.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Performed data review, evaluate, design, implement and maintain company database.
• Involved in construction of data flow diagrams and documentation of the processes.
• Interacted with end users for requirements study and analysis by JAD sessions.
• Performed gap analysis between the present data warehouse to the future data warehouse being developed and identified data gaps and data quality issues and suggested potential solutions.
• Participated in system and use case modeling like activity and use case diagrams.
• Analyzed user requirements and worked with data modelers to identify entities and relationship for data modeling.
• Participated in the design of the data model like conceptual, logical models using Erwin.
• Responsible for accuracy of the data collected and stored in the corporate support systems.
• Performed reverse engineering of physical data models from databases and SQL scripts.

Environment: Oracle 9.X, and MS Excel, Erwin 3.x, and MS Access, SQL Server, MS Visio, MS Excel, ER studio.