SUMMARY

• Diverse experience in IT industry with emphasis on Data Modeling/Data Analysis and SQL Development, working on multiple domains like Banking, Mortgage, Healthcare, Property and CasualtyInsurance industries across various clients.
• Over 7+ years of extensive experience in Data Analysis, Modeling, Design and Development of Databases in OLTP and Data Warehouse environments.
• Proficient in Data Warehousing concepts including Dimension Modeling (Star Schema, Snow - Flake schema Design) and Relational Modeling.
• Acted as a strong liaison between business users and IT personnel, following the best practices in the field.
• 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.
• Strong Experience in Relational Data Modeling& Dimensional Data Modeling to deliver Normalized 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/11iand Teradata, IBM DB2.
• Good understanding in reportingusing Business Objects, Crystal Reports.
• Expert in Designing, Developing and generating complex adhoc reports using SQL Stored procedures.
• 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 & OS: SQL Server 2005/2000, Teradata V2R6, Oracle 10g/9i, DB2 UDB 8.0, Sybase, MS Access, UNIX, Windows XP/NT.

Tools: ERWIN 4.0/7.0, ER/STUDIO 9/8/7.x, PL/SQL, INFORMATICA Power Center 8.x/7.x, Power Designer, Toad, SQL*Loader, SSIS, T-SQL,SQL*Plus, ER Studio, Oracle Designer, ERWIN,Sharepoint 2003, Visio

System Aspects: 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, Java, Perl, PHP, HTML, Java Script, JSP.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Data Modeler

Responsibilities:

• Worked closely with various Financial, Mortgage and Credit Consumer Group business teams in gathering the business requirements.
• Involved in the requirement gatherings and analysis in support of Data Warehousing efforts.
• Developed and validated data models against the business and data requirements and also ensured the quality, accuracy, integrity, and conformity to standards of all models.
• Extensively used Star Schema methodologies in building and designing Dimensional Data Models.
• Coordinated with DBA’s in creating and managing Tables, Indexes, Table spaces, Sequences, Views and Materialized Views.
• Used Sybase Power designer tool for relational and dimensional data warehouse designs.
• Generated DDL scripts using Forward Engineering technique to create objects and deploy them into the databases.
• Reverse engineered existing database schemas in order to implement changes and updates for existing tables and views.
• Worked with project management teams in the creation of project estimates.
• Used normalization techniques to organize data efficiently in a database.
• Involved in building and maintaining Data marts, Fact Tables, Dimensions and joined them to extract meaningful data.
• Created Source to Target Mapping documents and High Level Design Documents.
• Created data dictionaries for various data models to help other teams understand the actual purpose of each and every table and its columns.
• Provided support to development and testing team and made sure that the output of reports is valid and accurate.

Environment: MS Excel, MS Access, MS Visio, MS Power Point, MS Word, SQL Plus, PL/SQL Developer, Oracle 10g/11i, Sybase Power designer 15

Confidential, St. Louis, MO

Data Modeler/Data Analyst

Responsibilities:

• Conductedmajor stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design
• Developed the required data warehouse model usingStar schemafor the generalized model
• Used forward engineering approach for designing and creating databases for OLAP model
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business
• DevelopedData Mapping, Data Governance, TransformationandCleansingrules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project
• Prepared analytical and status reports and updated the project plan as required

Environment: UNIX, Sybase, Brio 6.2, Oracle 9i/10g, DB2, SQL server, PL/SQL, ERWIN 4, Power Designer, Teradata v 7.0, Business Objects, AIX.

Confidential, Chicago, IL

Data Modeler/Data Analyst

Responsibilities:

• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• 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.
• Normalization techniques to arrive at effective Relational Schemas.
• 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, etc for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• ETL Design & Implementation - Data Extraction, Transformation & Loading (using Informatica, SQL & PL/SQL).
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning)
• Create and alter SQL statements before sending database change request to DBA team.
• Maintained and documented all create and alter SQL statements for all release.

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

Confidential, Chicago, IL

Senior Data Analyst

Responsibilities:

• Gathered and translated Business requirements into detailed production-level technical specifications.
• Resolved the revolving issues by conducting and participating in JAD sessions with the Business and developers.
• Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.
• Responsible for understanding design and structure of different databases. Also involved in writing ad-hoc queries for data mining.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Collaborated with Business teams in the creation of the Functional Design document and Source to Target Mapping document.
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Collected the information about different Entities and attributes.
• Used Forward Engineering technique to generate DDL scripts from the physical data models.
• Reported and monitored the status using Clear Quest defect tracking tool.
• Used the Data Stage Director and its run-time engine to schedule and monitor the running jobs.

Environment: SQL Server 2008/ 2005, Teradata V2R6, UNIX, Toad, SSRS, ERWIN, XML, XSD, AIX