John Germuga Email & Phone Number

Baltimore, Maryland, Us

Washington, District Of Columbia, Us

Data Unification For Regulatory OperationsResponsible for delivery and budget of multimillion dollar initiative spanning several cross functional teams and applications. Partnered with Product Management teams to develop executive level road maps, program delivery status reporting and build new business cases.Collaborated with Systems Architecture team to extend an asynchronous event source workflow solution merging data from composable micro services leveraging AWS DMS, SQS/SNS, Flink, Kinesis, Lambda, Dynamo DB and RDS Aurora services and a custom Java transformation framework.Served as primary interface to the Enterprise Reference Data and Enterprise Reporting Platform teams to deliver a Data Mesh reference data management strategy.Managed day-to-day operational support, communications, deployments and disaster recovery response plans of 4 application systems spanning both cloud and on-premise infrastructure.

Washington, District Of Columbia, Us

Member Data Repository Cloud, Data Access Service LayerLead conversion of hybrid Inman/Kimball style data warehouse from Oracle and IBM Data Stage On-Premise to AWS CloudCoordinated upstream and downstream system dependencies on the data warehouse pipeline across 20+ stakeholder teams and drove adoption to the cloud migration program management goalsPhased solution utilized the AWS Data Migration Service to provide a temporary bridge platform while implementing a complete redesign of the ETL processes.Highlights of delivered solution include custom PL/pgSQL ETL functions utilizing complex analytic/windowing queries, table triggers for inbound CDC capture, a columnar metadata driven Star Schema history tracking function and lineage metadata driven workflow to manage foreign key, mview refresh and parallel processing dependencies across 13 inbound source applications and 300+ published data objects.Led effort to adapt FINRA’s MegaSparkDiff utility (https://github.com/FINRAOS/MegaSparkDiff) to provide CDC processing, and subsequent DMS publishing at scale over mviews recomputed on a daily basis.Designed cross platform workflow to control daily, monthly and quarterly data pipelines. Using FINRA’s open sourced Herd data catalog UI (https://github.com/FINRAOS/herd-ui) and API, pioneered integrated process to capture, maintain and synchronize all business metadata for published objects within every SDLC deployment.Redefined and refactored cross domain row and column privileges for PII and other FINRA privileged data sets. Responsible for all data related impact assessments, communications, deployments, day-to-day operational support, and disaster recovery response plans.Provided executive level status reporting on project progress and business critical milestones.

Washington, District Of Columbia, Us

Enterprise Reference DataCollaborated with the delivery team to modernize the Enterprise Reference Data architecture and workflow using the FINRA open source Herd catalog and RDS PostgreSQL under the AWS CloudServed as coach and Scrum Master to transform the SDLC from traditional water fall to an Agile Data processProvided consulting support on Master Data modeling and ER Studio model management best practicesAssisted with test data strategy and coding on Java based framework to accelerate agile CI/CD principles

Washington, District Of Columbia, Us

Depth of Market TrendingDesigned workflow to automate data loads at scale of 3+ billion records per dayRefactored Greenplum data model into a Star structure suitable for Redshift optimizationDeveloped proofs of concept to analyze performance characteristics of various distribution key, sort key and node configurations to properly size and provision the Redshift clusterAssisted coding Java data load and test data suitsMonitored ongoing performance metrics and storage optimization of the Redshift cluster

Washington, District Of Columbia, Us

Member Data Repository, Data Staging Hub, Enterprise Business Intelligence ToolsTechnical liaison between the Member Regulation business unit and the Data Services IT team in support of the complete enterprise membership data warehouse pipeline from operational data replication through end user visualization. Roles include significant exposure and in-depth understanding of many core data architecture components covering replication, Change Data Capture CDC, materialized views and OLAP models, ETL processes, metadata management and the end user facing analysis, analytics and reporting tools.

Toronto, On, Ca

Designed metadata driven Product Catalog data model and conversion scripts to integate and extend the Wealth Management Group's core product around searching and selecting financial instruments into customized investment proposals.

Washington, District Of Columbia, Us

-Developed high level POC for integrating Cognos 8 into a Service Oriented Architecture as the risk surveillance and alerting center point in an ESB based messaging environment. -Created metadata framework to support end user driven risk analysis and profiling within the Cognos 8 end user tools - Query, Report, Analysis and Event Studios. -Analyzed and scoped Cognos 8 SDK to determine required method calls and SOA integration points.-Authored and presented training classes to project managers and development staff to accelerate adoption of Cognos 8 end user tools.-Managed team of query developers in migrating over 450 risk assessment queries from NYSE applications and databases into the new NYSE/FINRA Integrated SOA architecture.-Provided data profiling of 6 core source system databases to determine suitability for integration into the Member Data Repository (MDR).

Rockville, Md, Us

Program Manager, 3/2005- 12/2006Sales Force Automation (SFA)Managed ongoing Tier 2 operational support of SFA related applications including the Data Quality Tools, CRM Front End, ETL Process Workflow and the Enterprise Reporting Portal. Also led two major revisions focused on the CRM user interface and the introduction of a handheld micro-browser interface. Project Manager, Data Warehouse Architect, 1/2004 – 2/2005Sales Force Automation – CRM, Reporting and Data Management ApplicationsLed implementation of high visibility BI initiative in conjunction with an upgrade of the existing CRM system which facilitates in-depth trend analysis and management reporting on Net Sales, Asset Retention, Sales Activity Effectiveness, Marketing Campaign Effectiveness, Opportunity Pipeline Fulfillment and Investment Behavior Attribution. Senior Database Architect and Project Lead, 12/2002-12/2003Sales Compensation Reporting System

Us

Norwalk, Connecticut, Us

Bs With Honors, Management Information Systems, Economics

Accounting And Finance