RDBMS DB2 9.1 ORACLE 11g SQL/SERVER SYBASE

SOFTWARE ERWIN WINDOWS XP NT 7 MICROSFT WORD MICROSOFT OFFICE TERADATA UTILITIES: - FSLDM, QUERYMAN, FASTLOAD,MULTILOAD, FASTEXPORT, PPI, JOIN INDEX, SECONDARY INDEX POWER-DESIGNER INFORMATICA MICROSTRATEGY COGNOS

LANGUAGES SQL PL/SQL ISQL UNIX SHELL SCRIPTING ON DB2 SML UML XML DML DDL DCL

EXPERIENCE

07/11 to12/11Confidential

SR DATA MODELER

• Consultant responsible for leading team and designed the full life cycle data model for new worldwide application RRO Rating Request asset mgmt .mutual funds hedge funds, equities,derivatives,credit derivatives,fixed income,stocks, financial structured products ABS,MBS,CMO,CDO .
• Interacted with technical and non-technical business user\'s to id business requirements and to translate into data requirements to build logical design.
• Experience, usedERWIN entity-attribute editor to build primary keys, foreign keys, alternate keys and inversion entries, and ERWIN relationship definition editor and subtype relationship editor to assist me in designing identifying, non-identifying, recursive and subtype relationships for logical design.
• Experience used ERWIN column property editor to create, name physical properties, ERWIN index editor to create, name,sort and cluster for performance tuning and ERWIN physical object editor and table property editor to create, name physical objects for physical design.
• Used ERWIN trigger template editor and stored procedure editor to write SQL code for any specified event or procedure.
• Used ERWIN synchronization dialog to sync physical object information with the target environment.
• Used ERWIN entity note/query/sample editor to input general notes about the entity, sample queries involving the entity, sample data instances for the entity usedERWIN report editor to generate reports for entity, attribute,relationship and constraint values
• Generated DDLExperience used ERWIN forward engineering to generate physical schema in a ORACLE environment Project will end on

.. Confidential

LEAD CONSULTANT/SR DATA MODELER

• Consultant, responsible for leading team and designing existing worldwide application subrogation for insurance company Aviva& ZurichInsurance.
• Experience used Teradata for data profiling intergation,MicrostrategyRolapMolapfor data analysis and reporting.
• Experience, used ERWIN reverse engineer to modify, update existing data models that resided in SYBASE.
• Used ERWIN index editor to rebind indexes to modify, update existing indexes, ERWIN physical object editor to update, enlarge existing database\'s,tablespace\'s, table\'s .
• Experience, used ERWIN forward engineer to generate schema in a ORACLE environment, stored data model in a ORACLE data warehouse.
• This Project ended due to lack of sufficient funds to continue on to new projects.

.Confidential

SR DATAMODELER

• Consultant, lead team an were responsible for designing the full life cycle(logical/physical design) data model of new worldwide application customer purchase information.
• Interacted with technical and non-technical business user\'s to id business requirements and to translate into data requirements to build logical design.
• Experience, designed Star Schema(dimensional modeling), used ERWIN entity-attribute editor to build primary key, foreign key, alternate key and inversion entry,
• ERWIN relationship definition editor and subtype relationship editor to assist me in designing identifying, non-identifying, recursive and subtype relationship for logical design.Experience, used ERWIN column property editor to create and named physical properties, ERWIN index editor to create, named, sort and cluster for performance tuning for physical design, ERWIN physical object editor and table property editor to create named physical objects for physical design and ERWIN synchronization dialog to sync physical objects with the target environment.
• Experience, used ERWIN trigger template editor and stored procedure editor to write SQL code for any specified event or procedure.
• Experience, used ERWIN entity note/query/sample editor to input general notes about the entity, sample queries involving the entity, sample data instances for the entity, used ERWIN report editor to generate reports for entity, attribute,relationship and constraint values.
• Experience, used ERWIN forward engineer to generate schema in a ORACLE environment,stored this data model information in a ORACLE data warehouse.
• Project ended, assignment completed.

Confidential

SR DATAMODELER

• Consultant, responsible for leading team and designed full life cycle of existing worldwide application insite.
• Experience, used ERWIN reverse engineer to modify, update existing data models that resided in SYBASE.
• Experience usedTeradata for data integration data profiling,MicrostrategyRolapMolap techniques for reporting and analysis of data
• Used ERWIN index editor to rebind indexes to modify, update existing indexes, ERWIN physical object editor to update, enlarge existing database\'s,tablespace\'s, table\'s Experience, used ERWIN forward engineerto generate schema in a SQL/SERVER environment, stored insite data model in a SQL/SERVER data warehouse.
• Project ended, assignment completed.

.Confidential

..SR.DATA MODELER

• Was offered to worked permanently on AUG.2007, accepted and was employed as a permanent employee until APR.1 2008 when Bear Stearns closed down.
• Employee, responsible for designing the full life cycle(logical/physical) data models and lead team in designing new application worldwide dividend information.
• Experience, designed Star Schema(dimensional modeling).
• Interacted with technical and non-technical business user\'s to id business requirements and to translate into data requirements to build logical design.
• Experience, usedERWIN entity-attribute editor to build primary keys, foreign keys, alternate keys and inversion entries, and ERWIN relationship definition editor and subtype relationship editor to assist me in designing identifying, non-identifying, recursive and subtype relationships for logical design.
• Experience used ERWIN column property editor to create, name physical properties, ERWIN index editor to create, name,sort and cluster for performance tuning and ERWIN physical object editor and table property editor to create, name physical objects for physical design.
• Used ERWIN trigger template editor and stored procedure editor to write SQL code for any specified event or procedure.
• Used ERWIN synchronization dialog to sync physical object information with the target environment.
• Used ERWIN entity note/query/sample editor to input general notes about the entity, sample queries involving the entity, sample data instancesfor the entity
• Used ERWIN report editor to generate reports for entity, attributes, relationships constraint values.
• Experience usedERWIN forward engineer to generate schema in a DB2 environment stored dividend information data models in a DB2 data warehouse.
• CompanyClosed down.

Confidential

.SR.DATAMODELER

• Consultant, lead team and were responsible for designing for existing application worldwide financial data design mutual fundshedge funds,equities,derivatives, creditderivatives,fixed income,stocks, financial structured products ABS,MBS,CMO,CDO
• Experience using, used ERWIN reverse engineer to modify, update existing data models that resided in DB2,
• Experience used Teradata for data analysis, data intergationand data profiling. Used MicrostrategyMolap,Rolapfor reporting and analysis of data.
• Used ERWIN index editor to modify, rebind, update existing indexes, ERWIN physical object editor to update enlarge existing database\'s tablespace’s table\'s.
• Experience, used ERWIN synchronization dialog to sync physical object information with the target environment.
• Experience, used ERWIN forward engineer to generate schema in a DB2 environment, stored financial data, data models in a DB2 data warehouse.
• Project ended, assignment completed.

..Confidential

.PROJECT MANAGER SR.DATAMODELER

• Employee, responsible for managing team and designing new and existing worldwide applications for full life cycle logical/physical design data models to provide technical services for data management (financial applications; Asset mgmt., fixedincome, equities, derivative /credit derivative,mutual funds/hedge funds,financial structured prod. .,..stocks(insurance applications; property, casualty, auto, life, home(pharmaceuticalsapplications)prescription coverage,medical history, medical cost, medical coverage).
• Experience designed Star Schema(dimensional modeling).
• Promoted to project manager in 1994, managed team of 10 in all application development procedures.
• Interacted with technical and non-technical business user\'s,scheduled meetings to id the business requirements to translate into data requirements to build logical design.Used ERWIN entity-attribute editor to build/update primary keys,foreign keys,alternate keys and inversion entries.
• Experience, used ERWIN relationship definition editor for creating/modifying identifying, non-identifying, recursive and subtype relationships for logical design.
• Used ERWIN index editor, ERWIN column property editor, ERWIN physical object editor and table property editor to create/modify physical properties, create/modify/rebind/sort/cluster for performance tuning indexes, create /modify/enlarge physical objects for physical design.
• Experience, used ERWIN trigger template editor and stored procedure editor to write SQL code for any specified event or procedure.
• Used ERWIN entity note/query/sample editor to input general note about the entity, sample queries involving the entity, sample data instancesfor the entity
• Used ERWIN report editor to generate daily reports for relationships,entities,attributes and constraint values.
• Experience used Teradatafor data analysis data audit and data profiling. MicrostrategyRolap,Molapfor reporting and data analyzation.
• Experience used ERWIN forward engineer to generate schema in DB2 ORACLE SQL/SERVER environments .Data Models were stored in DB2 data warehouse
• Experience used ERWIN reverse engineer to modify existing data models that resided in SYBASE ORACLE DB2.
• Employed from 1990 and also was a "hands on"project manager from 1994 until Comdisco-ccsc closed down in April 2003 due to the WTC attacks on 9/11.
• Company closed downCompanies that were provided technical services for data management:
• Perform all daily, weekly and monthly archive processing and production support.
• Responsible for backup and recovery of all DB2 physical objects.