Business Analyst

Jeremiah O’Connor

Senior Business Systems Analyst Strategic Data Solutions Quality & Governance Expert

Volo, IL 224-***-**** ******.**********@*****.*** linkedin.com/in/jdo Professional Summary

Strategic and resilient data leader with over a decade of experience transforming complex data environments into clean, compliant, and high-value ecosystems. Adept at leading governance initiatives, defining quality frameworks, and bridging business and technical domains. Trusted partner to stakeholders and an advocate for scalable, sustainable data solutions that drive real impact.

Core Competencies

Data Governance Data Quality Strategy Metadata Management Data Modeling Stakeholder Engagement Process Optimization SQL Collibra Power BI Enterprise Data Architecture Professional Experience

Northern Trust – Sr Data Quality Control / Business Systems Analyst (BSA) May 2023 – May 2025

• Met with stakeholders on banking fees data quality rules, capturing exceptions highlighting issues in improper fee generation.

• Translated business requirements into effective, accurate data quality rules.

• Generated weekly, monthly, and quarterly reports on rule performance; guided resolution of anomalies.

• Migrated and re-engineered hundreds of rules from Oracle EDQ to Collibra Data Quality during tool adoption.

• Triaged data abnormalities, prioritizing based on business impact and potential savings.

• Maintained KPI dashboards showing month-over-month performance changes and refinements.

• Led team stand-ups and Scrum ceremonies to guide user stories from inception through release.

• Consolidated disparate data sources into unified datasets for analysis. Northern Trust – Business Systems Analyst

Feb 2021 – May 2023

• Bridged the gap between business needs and IT solutions by gathering requirements, analyzing data, and designing systems to improve organizational efficiency.

• Collaborated with developers and stakeholders, focusing on data flow, process design, and problem-solving to implement technology solutions.

• Partnered cross-functionally to resolve data quality issues in the Asset Class Utility repository.

• Presented solutions after analyzing problems and documenting requirements.

• Defined business definitions for Wealth Management Data Store tables (WDS) by gaining consensus across LOBs.

• Gathered and documented metadata for Collibra Data Catalog to provide context to NT partners.

• Worked with payments stakeholders to align system designs with ISO 20022 standards and payment rails, ensuring compliance and interoperability across platforms. Northern Trust (via TekSystems) – Data Modeler/Analyst (Contractor) Nov 2020 – Feb 2021

• Consulted on digital transformation projects, providing database design recommendations.

• Designed conceptual and logical models in ER/Studio Data Architect with iterative revisions.

• Documented complex relationships and attributes for reuse across initiatives.

• Facilitated model reviews with architects and developers for alignment.

• Collaborated across teams to map integrations between Salesforce and IBM BPM. Discover – Enterprise Logical Data Modeler

Apr 2020 – Nov 2020

• Produced logical and physical models in ER/Studio for approval and UAT testing.

• Generated DDL and SQL scripts for DBA execution.

• Partnered with developers to design back-end database solutions for mobile and self- service banking apps.

• Conducted gap analysis across L1–L3 layers to align with taxonomy and compliance standards.

• Integrated business glossary terms into ELDM to promote enterprise-wide consistency.

• Designed star and snowflake schemas to align ELDM with analytics and reporting.

• Collaborated with stakeholders to create consensus-driven enterprise data designs. Discover – Associate Data Modeler

Mar 2014 – Apr 2020

• Led development of dimensional model to support new Student Loans reporting database.

• Defined and enforced standards across Dev, UAT, and Prod environments.

• Applied governance controls to protect sensitive data and maintain compliance.

• Partnered with developers and BAs to deliver scalable database solutions.

• Reverse-engineered physical models into standardized logical structures.

• Supported Agile sprints to iteratively deliver model components.

• Managed version control and updates in ER/Studio.

• Validated models against profiling outputs and business rules with QA teams. Additional Experience

Supply Chain Specialist – Nosco

Inventory Manager – Essendant

Operations Manager – Sherwin-Williams

Corporate Buyer – Builders Plumbing Supply Co

Education

Bachelor of Arts, Western Illinois University – Business Administration (3.0 gpa) Technical Skills

SQL Linux CLI Power BI Oracle Teradata MySQL ER/Studio Snowflake Collibra IBM Infosphere Cloud Technologies SharePoint GitHub Azure DevOps Miro Visio Draw.IO Terraform AS/400 DB2 AWS Azure

Contact this candidate