Professional experience:

Confidential

SR DATA MODELER

• Consultant responsible for leading team and designed the full life cycle MDM data model for new worldwide application Vision.
• Interacted with technical and non-technical business user's to id business requirements and to translate into data requirements to build conceptual/ logical design.
• Experience ,used ERWIN 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
• used ERWIN report editor to generate reports for entity, attribute, relationship constraint values data governance
• Generated DDL
• Experience used ERWIN forward engineering to generate physical schema in a ORACLE environment
• Project still ongoing

Confidential

SR DATA MODELER

• Consultant responsible for leading team and designed the full life cycle MDM 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 conceptual/ logical design.
• Experience ,used ERWIN 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
• used ERWIN report editor to generate reports for entity, attribute, relationship and constraint values
• Generated DDL Experience used ERWIN forward engineering to generate physical schema in an ORACLE environment
• Project will end on Dec.30 2011

Confidential

LEAD CONSULTANT SR DATA MODELER

• Consultant, responsible for leading team and designing existing worldwide application subrogation for insurance company Aviva Zurich Insurance.
• Experience used Teradata for data profiling intergation, data profiling Microstrategy Rolap Molap for data analysis data profiling 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 DB2 environment, stored data model in a DB2 data warehouse.
• This Project ended March 14 2011 due to lack of sufficient funds to continue on to new projects.

Confidential

SR DATA MODELER

• Consultant, lead team an were responsible for designing the full life cycle MDM 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 conceptual/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 constraint values. Data governence
• Experience , used ERWIN forward engineer to generate schema in Asql/server environment, stored this data model information in a sql/server data warehouse.
• Project ended, assignment completed.

Confidential

DATA MODELER

• 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 used Teradata for data integration data profiling, Microstrategy Rolap Molap 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 engineer to generate schema in a SQL/SERVER environment, stored insite data model in a SQL/SERVER
• data warehouse.
• Project ended, assignment completed.

Confidential

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 MDM 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 conceptual/ logical design.
• Experience ,used ERWIN 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
• Used ERWIN report editor to generate reports for entity, attributes, relationships constraint values.
• Experience used ERWIN forward engineer to generate schema in a DB2 environment stored dividend information data models in a DB2 data warehouse.
• Company Closed down.

Confidential

SR .DATA MODELER

• Consultant, lead team and were responsible for designing for existing application worldwide financial data design mutual funds hedge funds, equities, derivatives,
• credit derivatives, 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 intergation and data profiling Used Microstrategy Molap,Rolap for data profiling 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

PRPJECT MANAGER/ SR.DATAMODELER

• Employee, responsible for managing team and designing new and existing worldwide applications for full life cycle MDM logical/physical design data models to provide technical services for data management financial applications Asset mgmt. ,fixed income, equities, derivative /credit derivative, mutual funds/hedge funds, financial structured prod. .,..stocks insurance applications property, casualty, auto, life, home pharmaceuticals applications 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 conceptual/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 instances for the entity
• Used ERWIN report editor to generate daily reports for relationships, entities, attributes constraint values data governence
• Experience used Teradata for data analysis data audit and data profiling. Microstrategy Rolap,Molap for reporting data profiling 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 down Companies that were provided technical services for data management: