Data Quality Business Analyst

JEREMIAH O’CONNOR

*** ****** **. ****, ** ***** · 224-***-****

******.**********@*****.*** · hƩps://www.linkedin.com/in/jdo/ ObjecƟve: To become a strong asset for a company within the financial services or banking industry where I can uƟlize and merge my knowledge of technology, business and data management to bring about the best soluƟons, foster posiƟve relaƟonships and affect meaningful change EXPERIENCE

MAY 2023 – PRESENT

SR DATA QUALITY CONTROL ANALYST, NORTHERN TRUST

● Met with senior/key stakeholders to document requirements and translate the business rules into sophisƟcated data quality rules

● Designed, tested and built out data quality rules while adhering to data policies and standards established by the Enterprise

● Profiled criƟcal data elements to help establish a baseline while consulƟng with the business on the proper cadence of running the DQ rules and reporƟng requirements

● Evaluated both business and technical lineage source-to-target documents and catalogued that informaƟon into Collibra for company-wide usage

Helped lead in the migraƟon of hundreds of data quality rules from Oracle Enterprise Data Quality to Collibra Data Quality

Worked with Data Owners and Stewards to establish best pracƟces on data handling and retenƟon policies

Distributed data quality excepƟons to the appropriate teams for remediaƟon while helping idenƟfy the root cause to bring permanent fixes to the problem

Visualized monthly trends in Power BI dashboard to monitor the success of exisƟng DQ rules and idenƟfied areas of further refinement of said rules FEB 2021 – MAY 2023

BUSINESS ANALYST, NORTHERN TRUST

● Partnered with the Head of Business Data Delivery and other data modelers to create a canonical data model of core Wealth Management business concepts

● Engaged regularly with business data stewards and senior business stakeholders to model data domains focusing on Loans (personal and commercial), Account Balances, Assets, and Investment Products

● Managed data definiƟons in IBM Infosphere to keep metadata repository in synch with logical/canonical data models

● Developed complex SQL queries to uncover issues in the data and performed root- cause analysis for remediaƟon

● Helped to establish KaŅa pipelines via APIs for data ingesƟon from disparate data sources to help feed downstream applicaƟons with real-Ɵme data feeds

● Created Data Flow Diagrams (DFDs) with Miro and Visio to visualize data connecƟons for broader audiences

NOV 2020 – FEB 2021

CONSULTANT (DATA MODELER/ANALYST), NORTHERN TRUST (via TekSystems)

● Designed and deployed database models for both the "I Move Money" and "I Join NT" digital transformaƟon journeys within ER/Studio modeling tool

● Facilitated the implementaƟon of the creaƟon of modeled tables, performing much of the DBA work during the IJNT journey and making changes as needed to structures within DEV and SYS environments

● Set up grants for read/write access for the developers to add test data to the table and code as necessary

● Worked alongside the business analyst to help with mapping the data fields from Salesforce on to Middleware-Shared Services layer to IBM BPM tool

● Provided metadata extracts of the data model to the BA for use within their mapping document

● Performed ad hoc queries within Oracle SQL Developer for the purpose of data analysis, data mapping and profiling

● Created & updated user stories in Jira for tracking journey work and transparency

● Lead daily “stand ups” in the absence of a team lead/project owner and coordinated efforts to bring project tasks to compleƟon

MAR 2014 – NOV 2020

DATA MODELER, DISCOVER

● Worked closely with developers and business analysts to translate business requirements into tangible work efforts

● IdenƟfied and tagged PII and/or highly sensiƟve data while applying proper data governance and risk protocols

● Analyzed mulƟple database plaƞorms to query and profile data sets that were perƟnent to the requirements of said project

● Traversed the various environments (Test, Dev, UAT, PROD) to ensure tables, indexes, constraints, etc. were in sync

● Met with key stakeholders from the business and technology (BT) to discuss business requirements and come up with alternate database designs/soluƟons to meet the business need

OCT 2013 – DEC 2013

SUPPLY CHAIN SPECIALIST, NOSCO

● Purchased corrugated paper goods for prinƟng schedule in a job shop environment

● Planned for sufficient inventory levels and executed purchase orders to our vendors

● Discussed needs with Scheduling to prioriƟze print shop jobs and allocated stock accordingly

MAR 2008 – OCT 2013

INVENTORY MANAGER, ESSENDANT (formerly UNITED STATIONERS)

● Managed and maintained $35 million in inventory across a 28-facility naƟonal distribuƟon network

● Oversaw a buying secƟon of around 20 key vendors that comprised over 25,000 office

& technology SKUs the company stocked

● Ensured Ɵmeliness of domesƟcally sourced products as well as a conƟnuous flow of private-label import goods from our Chinese factories/subsidiaries

● TransiƟoned items through their product life cycle and coordinated the sell down of end-of-life inventory supplies

● Forecasted for various promos run through Costco and other big box retailers like Sam’s Club whom we drop shipped for while maintaining a high level of service FEB 2005 – FEB 2008

OPERATIONS MANAGER, SHERWIN-WILLIAMS

● Ordered paints and colorants for store needs and made sure appropriate levels of other key products (e.g. brushes, rollers, tape) were fully in stock and available 24/7

● Matched paint colors to the contractor’s specificaƟons and fulfilled orders for both commercial and residenƟal repaint jobs

● Managed the opening and closing aspects of a retail store, from balancing the cash drawer, accounƟng for the day’s cash and receivables and dropping the nightly deposit at the bank

● Set up plan-o-grams, markeƟng and promoƟonal materials within the store to upsell clients and drive sales growth

DEC 2001 – DEC 2003

CORPORATE BUYER, BUILDERS PLUMBING SUPPLY CO.

● Started in the office working in Inside Sales dept servicing the naƟonal chain of Lowe’s stores and supporƟng their plumbing departments as a supplier of specialty plumbing products they didn’t carry in stores

● Entered orders from Lowe’s employees while handling phone call inquiries on stock checks, lead Ɵme/tracking quesƟons, and making product recommendaƟons

● Promoted to CorporaƟon Buyer aŌer a year of demonstrated experƟse in the service department and started buying and managing several key products lines that the company sold

EDUCATION

2004 BACHELOR OF ARTS, WESTERN ILLINOIS UNIVERSITY PROFESSIONAL SKILLS

● ExcepƟonal communicaƟon

● Strong business acumen

● Highly organized

● AnalyƟcal and PragmaƟc

● Process Improvement

● Leadership Excellence

TECHNICAL SKILLS SQL, Linux CLI, MicrosoŌ Office Suite, IBM Infosphere, Collibra, Miro, Visio, Draw.IO, Power BI, GitHub, Azure DevOps, SharePoint, AWS Cloud Services, Snowflake, Terraform, AS/400, DB2, Oracle, Teradata, MySQL, SQL Server

Contact this candidate