KATIE TREFZ
Summary
Experienced Lead Business Systems Analyst with 6+ years in CRM database marketing solutions. Skilled in integrating new technology initiatives, delivering omni-channel campaigns, and managing client relationships. Expertise in translating ambiguous business needs into actionable project enhancements using advanced SQL, IBM Unica, and ETL tools.
Overview
6
6
years of professional experience
Work History
Lead Business Systems Analyst
Epsilon
03.2024 - Current
- Lead & coordinate integration of new technology initiatives in Oracle DB by planning, testing & driving product feature implementations, enhancements, & development
- Leverage & manage partnership with client(s) to ensure seamless project execution specific to CRM enhancements and maintaining SLAs
- Assist HR in recruiting by conducting interviews for potential New Grad BSAs every season
- Selected as 1 of 28 winners of the 2022 Q4 Magnitude Award, amongst 299 nominations
- People Manager, conducting bi-annual performance reviews and help drive individual career goals
Senior Business Systems Analyst
Epsilon
03.2022 - 03.2024
- Lead & coordinate integration of new technology initiatives in Oracle DB by planning, testing & driving product feature implementations, enhancements, & development
- Leverage & manage partnership with client(s) to ensure seamless project execution specific to CRM enhancements and maintaining SLAs
- Assist HR in recruiting by conducting interviews for potential New Grad BSAs every season
- Selected as 1 of 28 winners of the 2022 Q4 Magnitude Award, amongst 299 nominations
- People Manager, conducting bi-annual performance reviews and help drive individual career goals
Business Systems Analyst II
Epsilon
07.2019 - 03.2022
- Built, validated & delivered omni-channel marketing campaigns using IBM Unica & advanced SQL, managing a daily/weekly/monthly & ad-hoc cadence for retail vertical
- Identified & researched data discrepancies using advanced SQL, escalating issues to other team members when applicable
- Improved file processing efficiency by 10% using automation & scheduling tools
Business Systems Analyst I
Epsilon
06.2018 - 07.2019
- Analytical data mart build: created, built, & documented ETL flows, data model & all functional specs/ interface agreements for pharmaceutical vertical
- Performed all quality control checks for file processing, data cleansing & weekly data mart refresh for retail vertical
- Served as the liaison between developers & client, translating the client marketing business needs into advanced technical terms for the development team through technical requirement documents
Education
Bachelor of Business Administration - Marketing
Texas Christian University
Fort Worth, TX05.2018
Bachelor of Science - Sports Broadcasting
Texas Christian University
Fort Worth, TX05.2018
Skills
- Microsoft Expert Certification
- Requirements Gathering
- Project Management (SDLC)
- Advanced SQL Skills
- Linux/Unix
- IBM Unica Campaign
- Data Warehousing
- User Acceptance Testing
- Functional Specifications
- API Integration
- Gap Analysis
- Technology Implementation
Timeline
Lead Business Systems Analyst
Epsilon
03.2024 - Current
Senior Business Systems Analyst
Epsilon
03.2022 - 03.2024
Business Systems Analyst II
Epsilon
07.2019 - 03.2022
Business Systems Analyst I
Epsilon
06.2018 - 07.2019
Bachelor of Business Administration - Marketing
Texas Christian University
Bachelor of Science - Sports Broadcasting
Texas Christian University