Open to opportunities

PAMELA SPENCE

@pamelaspence

Message

I build financial reporting, data workflows, and regulatory analytics for enterprise organizations.

United States

Message

What I'm looking for

I'm looking to apply my experience in financial reporting, regulatory processes, data analysis, and automated workflows to help an organization strengthen data quality, reporting accuracy, and operational resilience.

I've delivered financial reporting and IFRS 17 workflows at Transamerica Life Insurance Company, using Alteryx to assign centers, accounts, portfolios, groupings, cohorts, profitability, and cash journal entries. I also created KC4 and disposition reports, reconciled duplicate balances between IFRS 4 and IFRS 17 ledgers, and documented reclassification and reversal processes.

At SunTrust Banks, I supported Edge$ell Online incentive-plan programming and produced liquidity, economic capital, hedging, and Call Report analysis using SAS and SQL. My work supported Treasury, risk management, financial advisors, and regulatory reporting needs.

I've also built automated reporting, ETL processes, data warehouse queries, Oracle database objects, and Banner Student Information System solutions for Georgia Institute of Technology and Fiserv.

Experience

Work history, roles, and key accomplishments

Senior Accounting Business Analyst

Transamerica Life Insurance Company

Dec 2021 - Feb 2025 (3 years 2 months)

Created IFRS 17 workflows in Alteryx, assigned centers and accounts, and generated reports. Documented business requirements and coordinated business continuity planning.

Alteryx IFRS Business Requirements Documentation Business Continuity Planning

Incentive Tracking Programmer

SunTrust Banks, Inc.

Jan 2017 - Jan 2018 (1 year)

Supported programming for the Edge$ell Online incentive tracking system, developing logic based on incentive plans. Documented, coded, tested, and debugged programs to meet timelines.

Programming Testing Debugging Documentation

Sr. Business Systems Analyst

SunTrust Banks, Inc.

Apr 2015 - Jan 2017 (1 year 9 months)

Executed SAS codes for daily liquidity reports and monthly economic capital reports. Used SQL queries for hedging program analysis and created quarterly call reports.

SAS SQL Data Analysis Reporting Risk Management

Business Data Analyst

Fiserv

Nov 2012 - Apr 2015 (2 years 5 months)

Updated and maintained reporting on key performance indicators for business units. Performed daily and monthly reporting and conducted data analysis for internal clients.

Data Analysis Reporting Remedy Data Extraction Transformation Loading

Senior Systems Analyst

Georgia Institute of Technology

May 2007 - Mar 2012 (4 years 10 months)

Gathered business needs and developed reports using Crystal Reports and Business Objects. Designed SQL scripts and ETL processes, and implemented security systems.

Crystal Reports Business Objects SQL ETL Oracle