Played crucial role in designing, developing, and maintaining data models that drove organization's data management and analytics initiatives. Collaborated with stakeholders, including business analysts, data architects, and developers, to gather requirements and understand data needs while adhering to standards, generating data definition language (DDL) scripts, and maintaining data dictionaries.• Translated business requirements into effective and efficient models while adhering to standards and best practices by developing and implementing conceptual, logical, and physical models using Erwin case tool to capture metadata and data dictionaries.• Created and maintained relational / dimensional model to capture corporate-wide enterprise technology data related to all aspects of data technology (inventory, procedures / processes, personnel usage, management, build / change processes, etc.). Analyzed and reported to management-level teams for possible revisions in company’s best practices.

Designed and maintained large data warehouses and data marts to store analytical data for reporting. Provided database administrators (DBAs) with DDL required to build databases.• Developed and maintained integrated data warehouse for property and casualty and investments divisions, allowing for analysis of analytical and statistical data.• Created compliance and complaint database permitting tracking of issues and facilitating adherence to new regulations required by government.• Streamlined operations by providing expertise on standard naming and design practices and maintaining all lineage, mapping, and data dictionary documentation.