SUMMARY:

• More than 8 years of experience in Information Technology industry.
• Data Modeling: Dimensional Data modeling, Relational Data modeling, Star Join Schema modeling, Snow - Flake modeling, FACT and Dimensions tables, XML Schema, Physical and logical data modeling, Erwin 4.5/4.0/3.5/3.0 , Oracle Designer, MS Vision.
• Databases: Oracle 10g/9i/8i/7.x, SQL, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, UDB DB2 8.0, Sybase SQL Server, MS SQL Server 6.5/7.0.2000 (DTS, SQL Server Analytics), SQL Navigator, Teradata V2R5/V2R4/V2R3 (Fastload, Multiload, BTEQ, Query Man, T-PUMP), MS Access 2000, Developer 2000, Windows 95/98/2000/XP, Win NT 4.0 and Sun Solaris.

TECHNICAL SKILLS:

Data Modeling: Erwin 7.3/ 4.5/4.0/3.5/3.0 , Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling(Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables), XML Schema, Entities, Attributes, Cardinality, Oracle Designer 2000, MS Visio

Data Cleansing: Trillium 7.6/6.x (Converter, Parser, Matcher & Geocoder), Firstlogic 4.2/3.6

Scheduling Tools: CA Autosys, Control M, Crontab

Databases: Oracle 10g/9i/8i/7.x, MS SQL Server 2000/7.0/6.5 , SQL Navigator, IBM DB2 UDB 8.0/7.0/6.0/5.0 , DB2/400, SQL*Loader, MS Access 7.0/97/2000.

Others: C, XML, Unix Shell Scripting, SQL, PL/SQL, ISQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, ODBC, Quest TOAD.

Environment: UNIX (Sun Solaris 2.6/2.7, HP-UX, IBM AIX 4.2/4.3), Windows 2003/2000/XP/98, Sun-Ultra, SCO Unix, HP9000, Compaq OS/390.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr. Data Modeler

Responsibilities:

• Developing Data Asset documentation.
• Assessing performance of various business applications related to Product, Participant, Provider and Plan.
• Data asset rationalization for major identified assets.

Environment: Oracle 11g/10g/9i, .Net, Shell Scripting, JAVA, Windows 2003, SQL, PL/SQL, ERwin 7.x, TOAD, SQL*Loader, SQL Navigator

Confidential, Atlanta, GA

Sr. Data Modeler

Responsibilities:

• Developed data mappings for CIS customer information System.
• Researched and documented the data standards for logical and conceptual data modeling.
• Built data dictionary for CIS.
• Created data flow diagrams and design patterns.
• Assessed 360 Control web application for its performance.
• Recommended solutions to boost performance of 360 Control web application

Environment: Dimensional Data Modeling, SSAS, ERWIN 4.5, Data Analysis, BO 6.5,, Windows 2000, Oracle 9i, DTS, VSAM, DB2, Sybase, MS SQL Server 2000.

Confidential, Pittsburgh, PA

Data Architect

Responsibilities:

• Interacted with Business end users and Business Analysts to understand project requirements and translated them into technical specifications.
• Developed conceptual, logical and physical dimensional data models for MDM (master data management hub)
• Developed use cases with actual data samples to help developers in the development process.
• Researched and documented the source to target data mappings.
• Generated schema DDL to create tables and views using Erwin.
• Developed glossary of domains for the enterprise model.
• Created physical dictionaries, diagram PDF reports from Erwin.
• Created data flow diagrams and design patterns.

Environment: ERwin 9.2, Oracle 10g/9i, SQL, PL/SQL, XML Files, XML Schema, UML, UNIX Shell Scripting, MS SQL Server 2008 R2

Confidential, Cincinnati, OH

Data/System Analyst

Responsibilities:

• Interacted with Business end users and Business Analysts to understand project requirements and translated them into technical specifications.
• Developed conceptual, logical and physical dimensional data model for EDW 2.0 Semantic layer.
• Researched and documented the source to target data mappings.
• Generated schema DDL to create tables and views using Erwin.
• Created Model definition reports from Erwin to Excel spreadsheets.

Environment: Oracle8i, Oracle9i, Oracle 10g, Oracle Forms6i, Oracle Forms9i and Reports 6i, HP-True 64, Sun Solaris, Windows 2003, SQL, PL/SQL, ERwin 4.1x, TOAD.

Confidential, Durham, NC

Data Modeler

Responsibilities:

• Interacted with Business end users and Business Analysts to understand project requirements and translated them into technical specifications.
• Developed conceptual, logical and physical dimensional data model for EDW 2.0 Semantic layer.
• Researched and documented the source to target data mappings.
• Translated CDM to LDM and to PDM.
• Developed conceptual, logical and physical dimensional data models for MDM (master data management hub)
• Generated schema DDL to create tables and views using Erwin.
• Created Model definition reports from Erwin to Excel spreadsheets.
• Implemented star schemas using type 1 and type 2 dimensions.

Environment: ERwin 7.0, Informatica Power Center 8.1.2/7.1, Business Objects 6.5, Oracle 10g/9i, SQL, PL/SQL, XML Files, XML Schema, UNIX Shell Scripting, Sql*Loader, HP-Unix, MS SQL Server 2000 (DTS & SQL Server Analytics), TOAD, DB2.

Confidential, Brooklyn, NY

Data Architect

Responsibilities:

• Responsible for the Analysis, Design and Modeling. Worked on Erwin / Star Schema, Data Modeling, Data Elements.
• Worked on all kinds of development DBA activities and major developer activities.
• Created physical and logical data models using ERWIN.
• Developed Mappings, PL/SQL Procedures.
• Developed ER and Dimensional Models.
• Developed conceptual, logical and physical dimensional data models for MDM (master data management hub)
• Worked on ER/Studio XE2 to engineer, analyze, optimize data warehouse structures and to publish data models and metadata to different teams.
• Designed star schema by using ERWIN.
• Gathered user requirements and prepared required Design documents.
• Designed semantic data models for tagging securities and mortgage loans information to benefit system risk analysis project.
• Prepared Data Dictionary/Meta Data of the data elements.
• Developed the Dimensional Model Diagram (Star Schema Design), Logical Table Design, Transform Specifications from Credit Profile.
• Created database objects using the scripts generated from ERWIN.
• Involved in creating delta mappings and loading various dimensions as required to load the fact including the time dimension.
• Loaded fact tables by the dimension ids and qualified interactions.
• Debugged the mappings extensively hard coding the test data ids to test the logics going instance by instance.
• Tested the data by writing SQL queries in command center for DB2.
• Created reusable transformations in the shared folder and used the shortcuts in mappings.
• Tested data extracts in test, quality and prod environments.
• Involved in the code reviews and Bug fixing of the mappings in production to increase the efficiency.
• Used Cognos Transformer to built Multidimensional Cubes.
• Created Models based on the Dimensions, Levels and Measures required for the analysis.
• Created User interface for accessing standard impromptu reports using Cognos script editor.
• Created Cubes using Cognos Power Play Transformer.
• Generated reports using Cognos Power Play.

Environment: ERwin 8.0, Informatica PowerCenter 8.1.2/7.1, Business Objects 6.5,, Oracle 10g/9i, SQL, PL/SQL, Autosys, Web Tool Kit, XML Files, XML Schema, UNIX Shell Scripting, Trillium 8.2 (Converter, Parser, Geocoder & Matcher), Sql*Loader, HP-Unix, MS SQL Server 2000 (DTS & SQL Server Analytics), TOAD, DB2, UML.