Implement & expand data management framework across new consumer-centric channel w/IoT facets. Modelled, lead organized retrieval and active harness of GCP and JSON-based consumer registration & product usage data. Worked with a range of software engineering, IT, marketing, product owner/manager and production support teams in expanding data awareness linked to value drivers, risk aspects.Tools included Goggle Cloud Platform/Big Query, Dynatrace, Prometheus, Firebase, SPLUNK

• Designed, built & implemented a plan to automate lineage harvesting across macro data load processes, for an investment team within a large US insurance concern. Coached investment & data governance teams, stakeholders in lineage harvesting (processing) intended for IHS Markit EDM macro processes.• Helped re-organize base data model, lineage processing for a Bloomberg SMF/Security Master File upload, also linked with Collibra processing. Differentiated data types (Transactional, ETL administrative, Data Quality used for value toggling within lineage) within validation logic for lineage harvesting process.• Tools include Collibra, MS SQL Server 2019

• Re-modelled data flow, depletion element/metric calculation within (on premise) Sales Incentive scoring project. Parameterized time periods across channel, KPI scoring calculations (brand variability/range, versus volume). Assisted BI team in dashboard optimization for client/sales account teams. Tabulated MVP automation, simplification steps, leading to MDM (store, product, channel) data quality framework starting point. Liaised with a range of internal, third party/vendor teams across sprints.• Tool environments include GCP/BQ, Greenplum, Salesforce, Anaplan, Informatica.

• Drive enterprise-wide data recourse, modelling, modernization framework expansion, for group/member/provider operations, US military veteran claims processing. Work with architecture, data governance, resolver and client teams, data facets across projects. Tools include ERWIN (workgroup), Alation, DB2, MS SQL Server 2019• Contributed towards data element, data process discovery, tasking & validation, linked to ASO (Administrative Services Only) merger planning & execution steps• Obtained T3 (Secret) DoD clearance

• Re-architect enterprise customer records, pursuant to FATCA (Foreign Account Tax Compliance Act) and CRS (Common Reporting Standard) requirements, in addition to inter-group customer onboarding needs. Modelled and ensured capture of FATCA indicia.• Coordinate with IT and data governance teams to re-model enterprise customer data within an Azure-based, MS Dynamics CRM instance, as well as across other MS SQL Server instances. Created and validated customer data element matrix, to include mapping/lineage across enterprise system hubs.• Created & implemented element-specific validation, linked to a vendor-based curation engine, which was also coordinated to a CRM backfeed.• Coached industry-standard model basics (ARTS Operational Data Model 7.3, FIBO) to junior modeler/BI staff, to better convey and implement customer data relationships, ER/Studio.

• Re-architected 5.2 petabytes of data across Line-of-Business subject areas within a private equity concern. Coordinated with client, analytics and data engineering teams to re-model, re-transform enterprise data into a GCP (Google Cloud Platform) replacement for a legacy Teradata analytics hub. • Using ARTS Operational Data Model 7.3 as base, we implemented primitive data element (PDE) catalog framework to inventory business terms, clarify lineage/source system analysis, develop cube-based metrics, source system architecture/load priorities. Re-modelling subject matter areas (customer, employee, retail event, shipping, point-of-sale) led to a published, single version of enterprise truth, coordinated data standards/usage, data monetization. • Tools included GCP Big Query, ER/Studio modelling.

• Successfully implemented & expanded machine learning, for Customer Data Initiative within Global Banking & Markets division. Used TAMR Unify across over fifty source datasets, to curate target clusters in unified dataset, golden records. Target populations include both US/Non-US transacted clients. Iterative model feedback (positive and negative) linked to name, identifier matching algorithms critical for RTB/BAU model operation. TAMR Unify is third node within a three-node architecture (Attunity, Global IDs), to gather, model, curate & publish a single version of customer data truth. • Coordinate closely with KYC (Know Your Customer) on-boarding teams, regarding existing reference sources. Coordinated with vendor & internal teams to implement & validate technical performance & operations; mastering project backup, failover/failback aspects; validate data mastering use cases, linked to application patching & upgrades.• Assist project teams to configure KIBANA-based data quality measurement framework for customer legal entity records, to include coordination with existing Data Governance client teams.

• Data Analytics/Governance consultancy, Fortune 100 clients; closely coordinate with client teams to implement, expand quality measurement framework, related workflow. IBM Infosphere Information Analyzer 11.5.0.2; Information Governance Catalog; Collibra 5.03• Establishing customer element measurements across 125 million row source (Oracle), North American automobile manufacturer, enable period-over-period review cycles. Framework w/dash-boarding accelerates value awareness, recourse and risk mitigation across client, stakeholder and source system teams.• Assisting a global agricultural manufacturer with COLLIBRA-based processing, to validate and implement workflow closely coordinating data chunk creation, usage and authentication, within an AWS Data Lake.• Created & implemented 205 data measurements regarding automobile sensor/performance metric measurement (varying dimension type); rule exception detail help clients to better understand and quantify operating tolerances (IoT).• Crafted a measurement “proof-of-concept” for a rail transportation client; rail car sensor data gathered, recourse and awareness of operation/safety metrics (IoT); 14-column sample used across 20 measurements (of varying dimension type)

• Responsible for data rule process creation, development, measurement exception provisioning, across several bank silos. Closely coordinated with cross-border HUB (architecture) team, to manage rule SDLC environments, testing/rollout cycles, dashboard environments, to improve enterprise-wide framework. Worked with IBM (Netezza, DB2) databases and toolsets (Infosphere Information Analyzer, v. 9.1.2), Aginity querying tools, SPOTFIRE 6.0, 7.0 dashboards.• Designed, validated and implemented data rules of varying dimension (completeness, validity, integrity) across several system/data repository types (XRM Customer, a US Customer reference system; across RDARR-specific capital markets systems (Calypso, ICI, Global One, WSS, XIM, XST, Intrader) Coordinated across LENDING client and RISK stakeholder teams, for exception remediation cycles.• Achieved enterprise adoption of the ruleset object (IBM Information Analyzer) across data workflow. Multiple data rule requirements can be efficiently bundled within a single engine-side event, reducing mechanical and administrative drag, improving rule engine performance with more granular, co-located exception output.

• Founded and owned application (MS SQL Server 2008 R2 database, IIS/web servers) linked to high-volume loan modification/servicing-loss mitigation operations. Server-based environments supported 2k internal clients and stakeholders; facilitated successful processing of nearly 1 million trial and permanent loan modifications, across 80 different programs, monthly reporting via IR2 (Dept. of Treasury) system. • Configured ETL/data marshaling (iSeries, TeraData, Oracle) with other architecture and provider teams, closely coordinated to client processing and reporting requirements. AIT (application) creation, server-based operations mitigated high-risk, desktop-only processing, improving performance and efficiency. Reduced operational, regulatory risk for Legacy Asset Servicing.• Project-managed four major MS SQL Server/IIS production server builds, integrated cutovers, to include SQL upgrades, hardware, LoB processing enhancements. Designed and implemented lower-level MS SQL Server and web/IIS environments, to enhance development/testing lifecycles; TFS set-up and adoption. • Coordinated periodic BASE, initiative testing/release cycles, SLA support across an array of technology, LoB/stakeholder teams. Set up performance, configuration management data-gathering within each SQL environment, to improve planning and traffic control. • Designed, implemented and managed a windows group-based authentication model, production, lower-level SQL, IIS environments. Windows group framework provided efficiency for access history recourse within audits; basis for subsequent integration into enhanced access management platforms. • Hired and managed two consultants to conduct SQL database object sizing reviews/maintenance strategies; access management system on-boarding project. • Coordinated server-level, process hub failover/failback testing, integrated and standalone Disaster Recovery/DR validations, a key risk mitigation step.

• Responsible for successful development, implementation and administration of real-time, HL7 interface environments, loading to revenue cycle enterprise database/web applications. Technology included Corepoint/NeoIntegrate, MS SQL Server 2005. Real-time data drove efficiency across revenue cycle operations. • Built, requirement-gathered, implemented and supported tailored, HL7 ADT (Admit/Discharge/Transfer) interfaces for sixty hospital client sites across thirty-eight physical connections. Former business process consisted of dual entry of patient registration data to hospital host system, along with revenue cycle applications. • Served as HL7 IT owner; coached internal staff on HL7 messaging methodology re interface aspects, support steps. Optimized load performance architecture, performance tracking, in concert with increasing, year-over-year message volume (CY 2010 volume on track for 70 million). • Hired and directly supervised an external, technical consultant during peak rollouts. Liaised with external client teams, to include hospital, client IT staff, for connectivity (tcp/ip), HIPAA compliance, client data validation.• Crafted numerous enhancements around messaging ETL, linked to messaging-dependent applications or business processes ( ‘HILO’ message path forking, linking to audit exception priority)• Built and implemented an outbound, HL7 MDM (Medical Document Management) leg, integrated from a transcription application. New leg enabled integrated, electronic transfer to client host system (McKesson-HPF). Former business process consisted of physical print-outs at client hospital.

• Responsible for systems development and production support for mission-critical forecasting and real estate development enterprise applications. Forecasting systems served as a basis for generating FFO (Funds From Operations), a key, REIT-specific performance metric for reporting to Wall Street. • Served as liaison and technical analyst for systems activities regarding DYNA, the enterprise-wide platform for G/L, sales forecasting/budgeting. Performed DBA duties across DYNA (MS SQL Server) databases.

• Managed application, reporting, database development and administration for an agency-only broker/dealer, a subsidiary of a trading technology concern. Managed SQL Server 2000 database activity for intra-day order/fill, end-of-day operations; trading, clearing and exchange reporting. • Responsible for timely clearing, reporting and automated file submittal to clients and regulatory entities, e.g., NASD-OATS (administrator), Options Clearing Corp. (post-trade allocations), NYSE - Daily Program Trading Report, ad hoc NYSE-OTS and SEC - Blue Sheet reports. • Managed end-of-period financial reporting for equities and options, for internal and CBOE staff; specialist fees, volume-weighted average price reporting, complex option & sweep summaries.

• Designed and developed brokerage data warehouse reports & processes (DB2 UDB - AIX) within a top five U.S. securities firm (Wachovia).

• Managed SQL Server 2000 database optimization and administration within an accounting/treasury group for a FTSE 100 FCM (MAN Financial). • Optimized SQL Server database administration and support for a logistics subsidiary of a Fortune 500 company (RR Donnelley Logistics). • Served as a database developer, analyst, administrator and modeler for a growing distribution/supply chain client (Aquascape Designs). Provided MS SQL Server oversight training for client.

• Served as systems owner, database systems analyst, administrator and developer within tax/audit consultancy. Systems scope included time & billing (CMS), ORACLE-based Lawson HR applications.• Founded, project-managed the successful design, analysis, development, implementation and management of a web-based, firm wide IT Asset Management database system. New system brought efficiency (savings of over $400k) to a formerly manual process. • Built and managed numerous MS SQL Server interfaces across enterprise application & database servers.