● Defined data architecture framework and standards for data modeling (using Erwin), data analysts, and data quality scoring. ● Created a master data management (MDM) customer solution consolidating data from four sources by standardizing formats and validating entries, achieving 80% reduction in discrepancies. ● Created automated processes for identification and evaluation of PII data in the databases reducing the effort needed by 70%. ● Aided DBA staff in Oracle to Postgres conversion.
● Augmented a team of data modelers in the Brokerage Data Management group. ● Transformed functional data requirements into Extract, Transform and Load (ETL) specifications, data model updates and Data Description Language (DDL) for database object structure changes consistently completing work within the budgeted time. ● Collaborated with team members to conduct peer reviews of data model updates and produce DDL.
● Held Public Trust Security Clearance. ● Converted Functional Business Requirements into Database Requirements while executing data model updates and generating DDL for database object structure changes. ● Established database script standards to enable a single script to execute across all environments, accommodating multiple schemas in the development and test settings and a unified schema in certification and production reducing script errors by 90%. ● Constructed SQL queries and Excel workbooks to streamline the analysis of system reference data, achieving a reduction in analysis and deployment time by approximately 75%.
● Held Public Trust Security Clearance. ● Converted Functional Business Requirements into Database Requirements while executing data model updates and generating DDL for database object structure changes. ● Constructed SQL queries and Excel workbooks to streamline the analysis of system reference data, achieving a reduction in analysis and deployment time by approximately 75%.
● Augmented a team of data modelers in the Brokerage Data Management group. ● Transformed functional data requirements into Extract, Transform and Load (ETL) specifications, data model updates and Data Description Language (DDL) for database object structure changes consistently completing work within the budgeted time. ● Collaborated with team members to conduct peer reviews of data model updates and produce DDL.
● Collaborated with leadership team and business units leading technology teams to architect, design, and implement enterprise data warehouse and business intelligence solutions while managing up to 5 direct reports. ● Oversaw over 20 releases of the Enterprise Data Warehouse, integrating data from 12 disparate sources into a unified reporting structure, achieving up to a 75% reduction in reporting turnaround times. ● Designed database architecture and data mapping for new secured websites, merging data from three sources into a web portal that provided individual customer reports 24/7, previously available only through customer service personnel during web conferences.