Engaged in a contract role to lead and deliver data modernization efforts for a Financial Services Crown Corporation. The project focuses on adopting a Data Mesh framework, transitioning to Databricks, and implementing federated data governance. The key objectives are:► DBT Infrastructure & Data Mesh: Lead the initial setup of DBT on a Databricks platform, integrating it within a Data Mesh framework. Aim to distribute data ownership across multiple teams, allowing them to be responsible for their own data products.► Core Data Products: Develop and roll out twenty core data products that will serve as the foundational building blocks within the Data Mesh framework. These products will enable teams to create their own analytics products.► DRY Macros & Packages: Create reusable DBT macros and packages focused on enabling easy application of federated data governance. These tools will handle aspects like permissions, Data Quality Rules, and potentially, data contract enforcement.► Educational & Strategic Leadership: Act as an educational pivot for the internal teams, providing knowledge-sharing sessions and best practices documentation to smooth the transition to modern data platforms like Databricks and DBT.► Data Quality & Governance: Implement a set of universally applicable Data Quality Rules and mechanisms for data contract enforcement to ensure schema integrity and governance across federated teams.

Analyzed and organized vast amounts of raw data and built efficient data systems and pipelines. The role placed emphasis on improving data quality, interpreting intricate data trends, and conducting thorough analyses. The derived insights provided actionable insights to opportunities for operational efficiency and revenue growth. Additionally, significant investment was made into algorithm design and prototype development, enhanced by integrating data from various sources to refine analytical tools. Utilized dbt and Snowflake daily to create both transformational data models and conformed dimensions. ► Engaged daily with dbt and Snowflake to create both transformational data models and conformed dimensions. ► Integrated multiple systems of record when such dimensions are pivotal, ensuring organization-wide data cohesion. ► Processed MixPanel event data to offer in-depth SLA metrics for intricate operational processes essential for user utilization of the Shiftkey platform. ► Crafted introspective queries for dynamic modeling of Merkle marketing data, enhancing marketing insights. ► Established the CI pipeline for QA test automation, enabling automated QA builds so that data processes adhere to top-tier quality and reliability standards. ► Extracted data from Kafka streams, focusing on JSON data flattening. These event-driven updates incrementally modified the organization's facility dimension model.

Develop, test and implement cloud computing data pipelines to process semi structured data in support of descriptive and predictive analytics. Wrangle and transform disparate subscription acquisition, churn and pricing data using Fivetran, Fishtown Analytics dbt, SQL and Snowflake. Individual contributor among team of four engineers facilitating the planning and delivery of automated model testing, peer reviews and scheduled Git releases.► Utilize Fivetran ETL to source primarily API or delimited data for ingestion within Fishtown Analytics dbt transformation processes.► Develop and apply dbt best practices for sourcing video streaming subscription data and building transformations toward a unified data model► Constructed custom automated data quality dbt tests supporting daily data quality validations.► Prepare and deliver finalized Snowflake data sources for Tableau Online, applying enhancements from upstream data transformations and Tableau visualizations

Led an evolving Business Intelligence (BI) program for the UDP to drive data-guided philanthropic activity. Developed, evolved, and advanced the BI program with a focus on formulating strategies and laying the groundwork for key tactical program areas, some of which include reporting, business performance management, benchmarking, descriptive and predictive analytics.► Engaged executive and operational leadership to build and manage an evolving inventory of more than 100 information needs that defined and established their purpose and priority.► Directed, managed and contributed to the delivery of up to 25% of the evolving BI backlog since the implementation of the Foundation’s new Blackbaud CRM system.► Performed design, data analysis, and development of Tableau workbooks and Reporting Services reports.► Conducted candidate interviews, assessments, and recommendations.► Coached and mentored team members via formal performance appraisals and informal ad-hoc assistance facilitating their development to become independent contributors, some of whom have achieved rewarding promotions.

Accountable for data compliance and governance for the U.S. business lines of the nation’s 10th-largest bank, I establish and implement methodologies, technologies, and best practices, as well as and planning and managing data testing and controls.► I contributed to the fulfillment of the new US Dodd Frank mandate for providing the Federal Reserve with accurate, complete financial statements through data quality testing. As part of an internal team of 6 using Tableau, SQL Server, Excel and SAS, my independent testing enabled the company to save millions annually on outsourcing costs.► I developed a SAS software program and Tableau dashboard to consolidate and compare aggregation data points to pinpoint Balance Sheet discrepancies before submission to the Federal Reserve.► Finding missing forecasts, I designed and managed a framework to identify data quality issues prior to submitting stress test results to the Federal Reserve.

Leading Agile data stewardship and the metadata and validation/refinement lifecycle, I directed 12 teams of 100+ staff. I also served as the SME on data sets for Apple Pay, MasterCard Digital Enablement Service, and Proactive Risk Manager. ► I achieved the adoption of data stewardship and UAT best practices within Capital One’s Data Warehouse and Analytics departments after the merger, leading change management, data community education, and employee training.► Coaching and managing Data Stewardship resources, I oversaw UAT validations for 130+ retail banking production releases, including Teradata, Oracle, and Hadoop for key risk management and digital enablement projects.► To maintain consistent data quality and stewardship against a 100%+ growth of the Agile data engineering teams, I led the transfer of specific stewardship duties to Agile teams.

I ensured compliance for the legacy ING Direct Oracle data warehouse, managed defects, and handled reporting and communications for planned data warehouse changes.► I produced an inventory of critical data elements for the Oracle data warehouse and authored the data retention policy for information used to determine short, medium and long-term migration plans.► Establishing full data guardianship coverage for the Oracle Data Warehouse and 30+ BI entitlements, I ensured FACTA and FCRA privacy compliance. I reviewed columnar level Oracle and Cognos security, marshalled business support for guardianship, and delegated BI access authorization responsibilities to ensure ongoing ownership.

Steering application management and migration for the data warehouse, I managed a 3-phase acquired loan replacement project, acting as the SME for mortgage data delivery to Primatics Evolv and for the Evolv data model. ► To add a $40B acquired mortgage portfolio from ING Direct, I commandeered a team of 14 consisting of data modelers and data engineers delivering and subsequently optimizing monthly feeds to the 3rd party Primatics Evolv application, yielding single application management of credit accounting regulatory reporting and disclosures.► Garnering accolades for my customer service skills from Capital One Credit Accounting customers, I transitioned core development and support for finance extracts to Capital One.

Data Services Tech Lead - Bank Acquisition Preparedness & Delivery (July 2011 - June 2012)I headed data warehouse quality, overseeing a team of 14. I mapped the data model for transformations of loan data, contributing on a team delivering data requests for parties interested in acquiring ING Direct. I also trained 100+ Capital One analysts and managers on the ING Direct Oracle data warehouse and Cognos Business Intelligence assets.► Directed team in analyzing, identifying and addressing data warehouse and BI reporting data quality issues ensuring conformance to master data. ► Assembled and organized analysts in evaluating 3rd party BI version control software vendors. Presented resulting recommendation to data services head and drafted charter leading to subsequent funding approval.► I delivered ING Direct loan data to valuate $40B originated mortgage portfolio for acquisition by Capital One on legal day one (Feb. 17, 2012). Data Services Tech Lead (Dec. 2009 - June 2011)As the SME for BI development for Lending Services and Credit Risk, I coached 2 agile teams and led the architectural design for data warehouse development.► I reached 94% performance efficiency for monthly BI credit reporting reports and delivered technical and design assessments for the delivery of the “Turn Time Dashboard” on operational efficiency for non-technical managers.► I also developed a Loan Origination Pipeline Dashboard with a consolidated view of KPIs.