SUSAN HAFFEY

Led data profiling and root-cause analysis for fallout and triangulation reporting using SQL, and created a cross-functional business glossary with Informatica CDGC. Managed provider roster templates and validated credentialing data using external tools.

Configured and onboarded Informatica Axon and EDC platforms, and queried EPIC's Caboodle database to support data cataloging and governance initiatives. Established data domains using RegEx and managed production environments.

Defined data domains and PII types for the enterprise data warehouse using Informatica CDGC and SQL profiling. Collaborated with engineering and business teams to trace data lineage and implement data curation practices.

Deployed Informatica Axon to govern business terms, KPIs, and enterprise reports, and executed initial data loads. Maintained linkages between EDC terms and the Axon Business Glossary, and associated IDQ rules with attributes.

Analyzed and managed issues and change requests for an internal trading reconciliation system using root cause analysis, Excel, and Agile methods. Defined and developed Business Object updates aligned with business requirements.

Architected and developed PL/SQL stored procedures and SQL queries using Oracle and Unix tools, translating technical specifications into data-mart solutions. Authored a standards document for the development team.

Led and mentored a team of four in the Informatica ETL environment, delivering full-lifecycle ETL designs for the Emerging Markets Fixed Income team. Engineered Python scripts for ETL pipelines and provided Level 3 support.

Bachelor's degree in Psychology from Otterbein College.

Associate degree in Information Technology from Penn-Ohio College.