Responsible for setting enterprise level data strategy for a holistic approach to address regulatory reporting needs across all lines of business. Transform the enterprise approach to fulfill regulatory obligations from a reactive, federated model to a centralized model. Scale this strategy to identify economies of scale for approximately 2000+ reports, resulting in approximately 3,500 regulatory submissions on an annual basis. Reduce risks of inconsistency associated with distributed processes and data sourcing. Improve efficiency by reducing duplicative operations, technology, and data management processes.Lead an international team of data analysts and consultants responsible for identifying data commonalities between regulatory reports across multiple, worldwide jurisdictions and regulatory agencies. Document these commonalities as a regulatory data dictionary which builds a common LOB and technology agnostic taxonomy.Partner with operations to identify and deliver technological capabilities supporting the creation, review, and analysis of regulatory reports as part of day to day regulatory submission. Improve the efficiency of the operational process by presenting the information necessary for operations to make objective, data-driven decisions on the quality and sufficiency of the reports to be submitted. Provide lineage, traceability, data quality, and operational metrics in a single interface to the user. Persist all metadata associated with each submission in a systematically auditable manner enabling low human-touch responses to compliance and regulatory inquiries.

Lead a 45-person multi-national team for implementation tools to support the wholesale credit data domain executive in managing governance, audit, and operational activities. Provide functional support for metadata, lineage, and controls management via the Collibra product. Create a data quality rules authoring environment to empower the business to develop and execute data quality rules. Consolidate data management reporting into a multi-tenant, centralized platform as a horizontal to serve the management of the full domain.

Lead a 30-person multi-national team for implementation of relational and dimensional data warehouse using a combination of technologies including Hadoop, Sqoop, HDFS, Spark (Java and Scala), Oracle ExaData, and Informatica. This system consolidates 30+ disparate systems of record into a single business focused data model to support system to system data provisioning, regulatory reporting, LOB reporting, and business analysis. Create and execute a multi-generational plan to migrate for legacy systems to strategic data platform.

Responsible for managing the development and deployment of the data accuracy rules and integration with external data quality control measurements. Provide end to end visibility of the Data Quality Controls environment through MicroStrategy dashboards and reports. Reconcile business metadata related to controls to specific technical implementations.Responsible for technical implementation of data validity rules based on business rules defined in metadata. Created the process and standards for the documentation and creation of rules.Responsible for the creation of the data provisioning hub using Informatica Data Integration Hub. This hub serves as the data management control point for data moving between the Credit data domain and other domains.

Manager for a technical team supporting Commercial Credit Analytics and Regulatory Reporting.Manager of a team of FTE and contract employees. This team is composed of Business Analysts, Database Developers, and .NET developers.Responsible for support of existing production processes.Manage SDLC process for delivery on business requirements.

Technical Lead for regulatory reporting to the Office of the Controller of the Currency (OCC) for the Commercial Real Estate Line of Business.Responsible for supporting quarterly data collection and standardization effort that brings in data form multiple systems of record. Data brought into the system is analyzed for valid and reasonable values. Exceptions are presented to users for the purpose of justifying or correcting these exceptions. After the standardization and cleansing process, all data is transformed into the OCC required format.My role includes responsibility for release management and all UAT activities.The application has a SQL Server 2005 database with a C# .NET user interface. All ETL activities are completed using SSIS.

Owner of Operational Data Store (ODS) database in SQL Server 2005. This ODS is used by 7 other applications in the suite. I manage all ETL processes coming into the ODS. All ETL work is completed using SQL Server Integration Services (SSIS) on a SQL Server 2008 dedicated agent server. ETL process migrates 6+ GB of data every night.I reduced the nightly maintenance down-time from 1 hour 45 mins to 17 mins through agent and database optimization.All database and agent code is maintained in Team Foundation Server.Responsible for establishing SSIS and database best practices for the Line of Business.

Owner of Operational Data Store (ODS) database in SQL Server 2005. This ODS is used by 7 other applications in the suite. I manage all ETL processes coming into the ODS. All ETL work is completed using SQL Server Integration Services (SSIS) on a SQL Server 2008 dedicated agent server. ETL process migrates 6+ GB of data every night.I reduced the nightly maintenance down-time from 1 hour 45 mins to 17 mins through agent and database optimization.

SQL Server 2005 developer working with a data migration and validation system using SSIS.