Terrence Carter Email & Phone Number

Murrells Inlet, South Carolina, United States

I have re-opened Carter Consulting

Designed a Atomic Data Vault ( I hybrid model that combines an Atomic data model and a Data Vault data model) and created the mappings for different policy administration system into the ADV model for a major insurance company. Used the Infosphere Data Architect toolset. Created DDL from the physical model after the transformation from the logical model. Lead Data Architect designed a Operational data store using IIW data warehouse model and created the mappings of the Guidewire’s… Show more Designed a Atomic Data Vault ( I hybrid model that combines an Atomic data model and a Data Vault data model) and created the mappings for different policy administration system into the ADV model for a major insurance company. Used the Infosphere Data Architect toolset. Created DDL from the physical model after the transformation from the logical model. Lead Data Architect designed a Operational data store using IIW data warehouse model and created the mappings of the Guidewire’s Policy Center policy administration system into the ODS model for a major insurance company. Used the Infosphere Data Architect toolset. Create ETL specification from these mapping. Created DDL from the physical model after the transformation from the logical model. Conducted training class for using the IAA/IIW models and the IDA toolset. This included BOM modeling, IIW Modeling and contextual modeling.Created policies and procedures on how to do the data modeling and from the business requirements to the BOM modeling to the logical modeling, to the physical modeling and then producing the DBA hand-off documentation.Conducted data assessment of a current state Enterprise Data Store and made recommendations for a new startup insurance company. Develop I requirements template to be used to capture data requirements for an Enterprise Data Store.Conducted a data assessment to determine the business data usage of a Product Master domain for a large asset management company. Show less

Designed a Operational data store using IIW data warehouse model and created the mappings of the Guidewire’s Policy Center policy administration system into the ODS model. Used the Infosphere Data Architect toolset. Create ETL specification from these mapping. Created DDL from the physical model after the transformation from the logical model. Conducted training class for using the IAA/IIW models and the IDA toolset. This included BOM modeling, IIW Modeling and contextual… Show more Designed a Operational data store using IIW data warehouse model and created the mappings of the Guidewire’s Policy Center policy administration system into the ODS model. Used the Infosphere Data Architect toolset. Create ETL specification from these mapping. Created DDL from the physical model after the transformation from the logical model. Conducted training class for using the IAA/IIW models and the IDA toolset. This included BOM modeling, IIW Modeling and contextual modeling.Created policies and procedures on how to do the data modeling and from the business requirements to the BOM modeling to the logical modeling, to Show less

Design a Data Warehouse using IIW data warehouse modeling created mappings the Exigen policy administration system into the data warehouse model for a property casualty insurance company.Designed the data marts from the data warehouse. I was using the Erwin toolset to complete my work. Trained staff on how to read the IIW model and how to map data attributes into the model. Created the ETL specifications for the mappings. Created the DDL from the Physical data model after it was transformed… Show more Design a Data Warehouse using IIW data warehouse modeling created mappings the Exigen policy administration system into the data warehouse model for a property casualty insurance company.Designed the data marts from the data warehouse. I was using the Erwin toolset to complete my work. Trained staff on how to read the IIW model and how to map data attributes into the model. Created the ETL specifications for the mappings. Created the DDL from the Physical data model after it was transformed from the logical model. Created the ETL specifications for moving the data from the data warehouse into the data marts. Show less

designed a data warehouse using IIW data warehouse model and created the mappings of the Silvermoon policy administration system into the data warehouse model for a property casualty insurance company. Designed the data marts from the data warehouse. Used the Infosphere Data Architect toolset. Trained the staff on how to read the IIW model and how to map data attributes into the model. Create ETL specification from these mapping. Created DDL from the physical model after the transformation… Show more designed a data warehouse using IIW data warehouse model and created the mappings of the Silvermoon policy administration system into the data warehouse model for a property casualty insurance company. Designed the data marts from the data warehouse. Used the Infosphere Data Architect toolset. Trained the staff on how to read the IIW model and how to map data attributes into the model. Create ETL specification from these mapping. Created DDL from the physical model after the transformation from the logical model. Created ETL specs for moving data from the data warehouse into the data marts. Show less

Created a data warehouse using IIW data warehouse model and create the mappings of the Insure J application data into the IIW Data Warehouse for a major financial institution in South Africa. Trained the Staff on how to read the IIW model and how to map data attributes into the model. Create ETL specification from these mapping. Created DDL from the physical model after the transformation from the logical model. Lead Data Architect in charge of creating a data warehouse for a… Show more Created a data warehouse using IIW data warehouse model and create the mappings of the Insure J application data into the IIW Data Warehouse for a major financial institution in South Africa. Trained the Staff on how to read the IIW model and how to map data attributes into the model. Create ETL specification from these mapping. Created DDL from the physical model after the transformation from the logical model. Lead Data Architect in charge of creating a data warehouse for a governmental social services agency. This warehouse is to be used to combine 6 different operational data store and also used in creating the data mart to be used for the analytics and reporting of the agency. Worked with other data architects in creating the data marts while creating the data warehouse. Used the IBM’s IDA modeling tool to document and create these model and to document the mappings. Show less

Was the Lead Data Architect on the Data Exchange / Claim Acceptance and Routing Project. Developed the logical model for the claims data that come into the Company. This included mapping the claim data from different source into this model so it could be maintained in an “as received” state. The different forms of the claim that were mapped included HIPAA 4010 837, HIPAA 5010 837, claims direct data entry, and various other formats. This also included mapping the current claims repository to… Show more Was the Lead Data Architect on the Data Exchange / Claim Acceptance and Routing Project. Developed the logical model for the claims data that come into the Company. This included mapping the claim data from different source into this model so it could be maintained in an “as received” state. The different forms of the claim that were mapped included HIPAA 4010 837, HIPAA 5010 837, claims direct data entry, and various other formats. This also included mapping the current claims repository to the new data model. Created a new trading partner logical data model from the current data entry forms and the use cases. This included mapping the form to the data fields in the data model.Documented all of the mapping in Erwin and on spreadsheets to enable the population of a metadata repository. These documents help to enable the user validation of the model and training for the HIPAA 5010 training.Trained in the HIPAA 5010. Show less

Lead the effort to map the legacy policy data to the data dictionary. Also made recommendations to help further definition the data dictionary / meta data repository. Lead the Data modeling effort for Erie’s Business Enablement Project. This was using IBM IAA insurance model and road map to develop a new policy management system in a SOA environment. I created and conducted training on how to derive business terms in a use case and where to obtain the definitions for the… Show more Lead the effort to map the legacy policy data to the data dictionary. Also made recommendations to help further definition the data dictionary / meta data repository. Lead the Data modeling effort for Erie’s Business Enablement Project. This was using IBM IAA insurance model and road map to develop a new policy management system in a SOA environment. I created and conducted training on how to derive business terms in a use case and where to obtain the definitions for the identified terms. I conducted training on how to use and modify the BOM (business object model) in IAA. Also modified the Data Modeling project steps for using IAA/IIW.Redesign the customer data marts based on the requirements and data available in the IIW data warehouse. Show less

Conducted requirements gathering session to gather the data requirement. Updated the IBM’s IAA (Insurance Application Architecture) Business object with the information that was gathered. Created collaboration diagrams as well as state transition diagrams from these updates. This was using the rational rose tool set.Created Atomic data warehouse models by subject area using the IIW as a model. Also documented the transformation rules from the OLTP data model to the Data warehouse… Show more Conducted requirements gathering session to gather the data requirement. Updated the IBM’s IAA (Insurance Application Architecture) Business object with the information that was gathered. Created collaboration diagrams as well as state transition diagrams from these updates. This was using the rational rose tool set.Created Atomic data warehouse models by subject area using the IIW as a model. Also documented the transformation rules from the OLTP data model to the Data warehouse model. These were documented using Excel spreadsheets that were later put into the SDA repository as the ETL process was completed.Created the Data Marts for the transactions and the agent compensation.Helped with the evaluation and selection of WCC model to interact with the IAA models. This was going to be used for the Party subject area.I developed the direct and the procedures for a tactical solution for collecting Meta data for a project to provide traceability. This involved manually integrating 5 tools (Requisite Pro, DB2, Erwin, Access, SDA repository). This tactical solution was to capture the meta data that was available at the time the object were being created. An example is when the a use case for a process was being written then the data item were capture and information about that data item was recorded in Requisite Pro and tied to the use case. If the data item had already had a definition then the data item was tied to the data dictionary in Access (this was done through an indicator). As the data item was modeled the mappings for the data item was capture. We used the 5 different tools because they were already being used and could be further developed or the data exported and then imported into a meta data solution in the future. Show less

Conducted data requirement sessions for developing an enterprise data model for the Back Office products. This included collaboration on business terms and definitions as well as enumerations. Developed the conceptual models (defining all the entities), logical models (defining all the attributes and getting the model in 3NF) and physical models (denormalize and modify to make use of DB2’s DBMS. The modeling tool used for the conceptual and logical models was PowerDesigner. Also used… Show more Conducted data requirement sessions for developing an enterprise data model for the Back Office products. This included collaboration on business terms and definitions as well as enumerations. Developed the conceptual models (defining all the entities), logical models (defining all the attributes and getting the model in 3NF) and physical models (denormalize and modify to make use of DB2’s DBMS. The modeling tool used for the conceptual and logical models was PowerDesigner. Also used PowerDesigner to capture the definitions, edits, and enumerations for all the data elements in the models. This was used to produce the user’s documentation.Developed a 1 week SQL class and taught the class to the developer in Nebraska and Texas.Participated in the performance tuning of the databases at the IBM test facility in New York. This included evaluating the SQL as well as the database variable (bufferpools, indexes, page sizes, etc).Led installation of the databases at client locations and assisted in the customization of the databases to fit into the client’s environment. Show less

Led the successful completion of 10 legs of testing for the Y2K project. Developed the project plan and the tasks to be accomplished, Tracked deviations from the plan, created plans to get the project back on schedule, and also gave regular status report to management.

Recruited and hired consultants which involved interviewing, qualifying and salary negotiations. Marketed consultants to clients which included submitting resumes, setting up client interview, rate negotiations and assignment length. Managed the consultants which included setting expectation of both the client and Regency and performance evaluations.

Coordinated the efforts of the Latin American clients, Client Services, Bonus Rewards Programming team, Latin American Programming team and senior management to resolve the problems with Bonus Rewards system.

Coordinated the training for the consultants, performed the performance review and salary reviews for the consultants. Conducted assessments of the clients needs to identify additional requirements at existing clients. Resolved issues between the client and the consultants.Brooklyn UnionConducted fact finding session with the Brooklyn Union staff to establish a Y2K project plan. Developed the project plan using MS Project Workbench tools.

Created conceptual and logical models for a re-architected enterprise address system. Conducted requirement sessions with a diverse group of users of the addresses to gain an understanding of how the addresses were used. Conducted research with Post Office and foreign governmental agencies to determine how addresses were used. Documented the finding in the conceptual and logical models as well as data flow diagram.; Conducted data analysis for the underwriting system. Met with the business… Show more Created conceptual and logical models for a re-architected enterprise address system. Conducted requirement sessions with a diverse group of users of the addresses to gain an understanding of how the addresses were used. Conducted research with Post Office and foreign governmental agencies to determine how addresses were used. Documented the finding in the conceptual and logical models as well as data flow diagram.; Conducted data analysis for the underwriting system. Met with the business users to conduct processes analysis of their underwriting process. Produced conceptual and logical data models using the IEF modeling tools. Also developed functional dependency diagrams. Show less