PROFESSIONAL SUMMARY

• 7+ years of experience in Data Architecture, Design & Modeling across various industries, clients and geographies
• Experienced with all major databases: Oracle, SQL Server 2000/2005, Teradata in large data warehouse (OLAP) environments
• Strong Experience in ER & Dimensional Data Modeling to deliver Normalized ER & STAR/SNOWFLAKE schemas using Erwin r7.2, ER Studio 7.1, EA Studio 1.5.1, Sybase power designer 12.1 and Oracle designer.
• ETL Design - INFORMATICA PowerCenter 8.x/7.x for Extraction, Transformation & Loading; ETL Analysis - Source to Target Mappings; Development.
• Proven Requirement Gathering & Analysis skills - talking to users & analyzing data.
• Reporting - Business Objects, Crystal reports; Designed WebI /CR reports
• Developed numerous PL/SQL Packages, Stored Procedures, Functions, Materialized Views & Triggers; Good at using TOAD, SQL*Plus, SQL Navigator and PL/SQL Developer.
• Extensively participated/supported Java, J2EE, VB, .Net & Web based application design.
• Experienced in Financial / Finance, Mortgage, Supply-Chain, Material Management and Health Care.
• Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.
• Experienced in working with Data Resource Management team (DRM), Enterprise Metadata Repository team (EMR), Corporate Data Dictionary team (CDD), Integrated Governance Board (IGB) for data quality, data Integration of enterprise data assets.
• Excellent knowledge of Bill Inmon and Ralph Kimball methodologies to design database architecture. Excellent knowledge on logical application design and physical implementation for database application.
• Excellent knowledge of complete data warehouse life cycle, testing methodologies, OLAP and OLTP. Excellent knowledge of SDLC phases (Inception, Elaboration, Construction and Transition).
• Experienced with most of software deployments methodologies like Water Fall, Iteration, Agile and Rapid Application Development (RAD).
• Proven skills in designed and maintained the Detail design Document (DDD), Business requirement documents (BRD), Data Requirement Document (DRD), Data Flow Diagram (DFD), Data Management Plan Document, Data Dictionary, Meta Data Model, Logical and Physical Data Models, Full DDL, Alter DDL, Insert statement for all the applications.
• Experienced in Business requirements conformation, data analysis, data modeling, logical and physical database design and implementation.
• Experienced in Normalization and Demoralization processes, Logical and Physical data modeling techniques.
• Proven knowledge in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Experienced in database performance tuning and data access optimization, writing complex SQL quires and PL/SQL blocks like stored procedures, Functions, Triggers, Cursors and ETL packages.
• Experienced in Working with product managers, project managers, Business users, Applications development team members, CM Team, DBA teams and Data Governance team on a daily basis to analyze requirements, and design and development technical solutions.
• Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.

TECHNICAL SKILLS

Databases & OS: Oracle 10g/9i, SQL Server 2012/2008/2005, Teradata V2R6, DB2 UDB 8.0, Sybase, MS Access, UNIX, Windows XP/NT.

Business Areas: Financial/Finance, HealthCare, Mortgage, Sales & Marketing.

Tools: ERWIN 4.0/7.0, ER/STUDIO 7.x, PL/SQL, INFORMATICA Power Center 8.x/7.x, Ab Initio, Power Designer, BUSINESS OBJECTS XI, Toad, SQL*Loader, MS DTS, T-SQL,SQL*Plus, ER Studio, Oracle Designer, Sharepoint 2003, Teradata FastLoad, MultiLoad, Tpump.

System Aspects: Data Modeling (ER & Dimensional), Database Design, Requirement Analysis, ETL Design, Object Oriented Design, Development, Testing, Data Mapping, Metadata Management, Master Data Management, Data Profiling, Deployment, Documentation, Project Management.

Languages: PL/SQL, Pro*C/C++, Perl, PHP, HTML, Java Script, JSP, VB.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IOWA

Data Architect/Modeler

Responsibilities

• Data Architecture, logical and physical Modeling for OLAP systems.
• ER Modeling - Developing Entity Relationship Diagrams (ERD).
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• 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 Oracle Warehousing Builder, SQL & PL/SQL).
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Maintained and documented all create and alter SQL statements for all release.
• Designing Data Flows & System Interfaces.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Documenting using Interface Diagrams, Flow Charts & Specification Documents.
• Coordinating with DBA team to implement physical models & to setup development, test, staging & production environments for MGP; BPR Management; DDL & DML Generation & usage.

Environment: Teradata V2R6, Oracle Warehouse Builder, SQL, PL/ SQL, Sybase Power Designer 12.5/ 15, SQL Server 2000/ 2005, UNIX, Toad, Business Objects, Ab Initio, MS office, MS Access.

Confidential, Kansas City, KS

Data Architect/Modeler

Responsibilities

• Performed Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• 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.
• Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Participate in biweekly technical huddle meeting with development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
• Rapid Audit of the requirements and existing systems; Requirements & Business Process Analysis.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using tools like ERwin Data Modeler 4.x, ER/Studio 7.x (ER Studio)- Forward/Reverse Engineered Databases.
• Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Convert models from CA ERwin to ER/Studio 7.5 (ERStudio); Developed numerous macros.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Compiles and maintains the Enterprise Schema across all applications. Enforces principles of good canonical data design.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Designing Data Flows & System Interfaces - Service Oriented Architecture (SOA) & Web Services.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Design EDW / CDW components.
• Metadata Repository, Data Dictionary; Documentation using Interface Diagrams, Flow Charts.
• Assist developers in Performance Tuning & discussing Design Patterns/high level application design.

Environment: DB2 UDB 8.x, Oracle 11g/ 10g, SQL Server 2005/ 2000, Sybase data server 12.5, UNIX, Toad, Business Objects, Ab Initio, Teradata V2R6, Embarcadero ER/Studio 7.5 (ER Studio), Business Objects, XML, XSD, AIX, Java / J2EE.

Confidential, New York, NY

Data Architect/Modeler

Responsibilities

• Involved in design & implementation of 2 Data Marts; Integration with EDW & ODS.
• Performed Logical & Physical Data Modeling and delivering Normalized, De-Normalized & Dimensional schemas
• Delivered Source-to-target mappings and developed Informatica mappings/mapplets.
• Reporting (MS Analysis Services / Reporting Services) - Design & implement Analysis adhoc reports & scheduled reports - for ad hoc & canned requirements.
• Gathered Business Requirements & Analyzed Business Process (User & Source Driven); Performed the roles of Data Analyst & Business Analyst; Developed Used Cases.
• Develop, Implement & Maintain the Conceptual, Logical & Physical Data models using ER/Studio – Forward/Reverse Engineer Databases (for the Staging, Normalized & presentation layers).
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping; Apply SOA (Service Oriented Architecture) to share master data; Use of CASE tools; Data Analyst/Analysis duties.
• Designing the SSAS (SQL Server Analysis Services) Cubes; SSRS (SQL Server Reporting Services) Reports & Adhoc Querying facilities.
• Designing Data Flows & System Interfaces – Implementing the same.
• Design & Implementation of Data Extraction, Transformation & Loading (using SQL*Loader, Informatica & other ETL tools); Analyze Oracle & SQL Server Data & Migration of the same.

Environment: ERstudio 7.6, SQL Server 2000/ 2005, Sybase data server 12.5, Toad, Ab Initio, MS office, InformaticaPowerCenter 7.1, SSIS, SSRS, SSIS, BIDS, SharePoint 2003, Crystal Reports, UNIX, SQL*Loader, Visio.

Confidential, Los Angles, CA

Data Modeler

• Participated in Business Requirements gathering with business and user groups.
• Designed Conceptual, logical and Physical Data Models using Erwin.
• Maintained data model by implementing change request by developers.
• Worked with DBA to create table, add columns by providing them SQL scripts.
• Implemented those DDL in oracle database.
• Worked with development team to get change request and implement in data model and then database.
• Performed Normalization, Indexes Tuned and Optimized the existing database design.
• Maintained data mapping information and documented properly.
• Performed various tasks that included data massaging, data extraction from flat files, data transformations into various file formats, validations, loading data and checking for any data integrity errors.
• Successfully designed Aggregation tables in the dimensional model data warehouse that were used for running of special Marketing campaigns.
• Documented data dictionary for all version of data models.
• Verified business definitions for table and column and maintained standard physical naming with primary qualifier and class words.
• Worked very closely with end user to implement their need in data model designed.
• Conceptual, logical and physical data models are designed with maintaining data governance and naming standards.

Environment: Erwin, Embarcadero ER/Studio 7.5, Micro Strategy, Java / J2EE, SSRS, SQL Server 2000/ 2005, Sybase data server 12.5, UNIX, Toad, MS Office.

Confidential

Data Analyst

Responsibilities:

• Responsible for accuracy of the data collected and stored in the corporate support system.
• 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 (Joint Application Development).
• 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 the data modelers to identify entities and relationship for data modeling.
• Actively participated in the design of data model like conceptual, logical models using Erwin.

Environment: Erwin 3.x, Oracle 9.x, and MS Excel and Access.