Allie T Jivacate
Fort Mill
Summary
Results-oriented analytics leader with a strong track record in banking, driving significant business improvements through innovative data solutions. Developed a variance analysis framework reconciling millions of records and automated workflows, significantly enhancing operational efficiency and stakeholder communication.
Overview
28
28
years of professional experience
Work History
Senior Lead Analytics Consultant
Wells Fargo
Charlotte
07.2023 - 02.2026
- Designed and executed variance analysis framework for multiple lookback projects, reconciling 55.3M records across 181 fields to improve data integrity.
- Developed a standardized SAS macro for data variance analysis, enabling record-level discrepancy identification and actionable insights for developers and leadership.
- Validated outputs against business requirements for high-profile initiatives as independent tester, presenting findings to stakeholders to ensure alignment.
- Defined and tested SQL Server-based data solutions with technology teams, ensuring business logic accuracy and source table integrity.
Senior Risk Analytics Consultant
Wells Fargo
Charlotte
05.2020 - 06.2023
- Reengineered EPBO Reinstatement process by replacing legacy systems with automated workflows and controls, improving process efficiency.
- Led creation of an analytics inventory tracking system for 290+ monthly reports, automating follow-ups and freeing 9 developers from manual tracking.
- Built and maintained centralized SAS macros to streamline recurring processes, improving data consistency across reports.
- Collaborated with controller units to refine existing reporting for Home Mortgage and Home Equity product and ensured the report meet enterprise compliance standards.
Analytic Consultant
Wells Fargo
Charlotte
05.2017 - 04.2020
- Delivered a historical loss mitigation analytics database end-to-end for all portfolios.
- Partnered with teams to design a Robotic Automation Process reducing manual review time by 4 hours per record set.
- Conducted root-cause analyses to identify business gaps and improve workflows.
- Mentored junior analysts and led peer reviews on audit-driven projects.
Analytic Consultant
Wells Fargo
Charlotte
01.2007 - 01.2015
- Developed matching algorithms for Home Mortgage and Home Equity products, reconciling collateral addresses and linking accounts at the household level.
- Created clustering methodologies to assess property density and visualize risk via heat maps.
- Engineered algorithms to track contractual payments across 200M+ monthly cash transactions.
- Collaborated with cross-functional teams including WFHE, Acquisitions, Cash/Accounting, and Legal.
Finance Consultant
Bank of America
Charlotte
01.2006 - 01.2007
- Improved monthly P&L reports for premier and private households.
- Developed household migration reports to monitor financial inflows/outflows.
- Implemented test/control methodology to validate segmentation accuracy.
- Designed metrics to measure growth and new account averages for quarterly bonuses.
Strata Analyst
TEKsystems
Charlotte
05.2005 - 01.2006
- Maintained STRATA decision tree applications to route delinquent accounts.
- Presented Champion/Challenger model results to management for strategic decisions.
Marketing Database Analyst
TEKsystems
Charlotte
01.2005 - 05.2005
- Supported co-branded and private label campaigns through direct mail and telemarketing segmentation.
- Applied test/control cell methodology to optimize campaign volume within budget.
- Streamlined Welcome Package coding to improve efficiency and data capture.
Cash Flow Analyst
GMAC RFC
Minneapolis
01.2004 - 01.2005
- Executed weekly/monthly security pricing models.
- Delivered risk reports for distressed and securitized assets.
- Built models to evaluate servicer performance on cash flowing, default, cure, and REO.
Contractor
TEKsystems
Charlotte
01.2003 - 12.2003
- Supported new and monthly reporting operations for banking to produce accurate and timely data insights.
- Utilized SAS and SQL to extract, analyze and validate data for recurring and ad-hoc reporting needs.
Statistician with Bureau of Air Quality
Department of South Carolina
Columbia
01.1999 - 12.2003
- Supported South Carolina state agencies with EPA controls on air quality regulation.
Teller, Appraisal Reviewer
NBSC
Columbia
01.1998 - 12.1999
- Validated and analyzed commercial appraisal reports to ensure a fair market value is supported by comparable sales
- Assisted walk-in or drive-thru customers to help with deposit, withdrawals and account inquiries provided clear guidance and efficient service.
Education
Bachelor of Science - Mathematics
University of South Carolina
Columbia, SC01-1997
Skills
- SAS (Advanced)
- SQL (Intermediate)
- Business Intelligence Tools: Tableau, Power BI, Alteryx
- Data analytics
- Predictive modeling
- Excel (Advanced)
- PowerPoint (Advanced)
- Unix (Advanced)
- Windows DOS (Intermediate)
- Python (Beginner)
- Mainframe (Beginner)
- Data governance
- Stakeholder communication
- Agile management
Timeline
Senior Lead Analytics Consultant
Wells Fargo
07.2023 - 02.2026
Senior Risk Analytics Consultant
Wells Fargo
05.2020 - 06.2023
Analytic Consultant
Wells Fargo
05.2017 - 04.2020
Analytic Consultant
Wells Fargo
01.2007 - 01.2015
Finance Consultant
Bank of America
01.2006 - 01.2007
Strata Analyst
TEKsystems
05.2005 - 01.2006
Marketing Database Analyst
TEKsystems
01.2005 - 05.2005
Cash Flow Analyst
GMAC RFC
01.2004 - 01.2005
Contractor
TEKsystems
01.2003 - 12.2003
Statistician with Bureau of Air Quality
Department of South Carolina
01.1999 - 12.2003
Teller, Appraisal Reviewer
NBSC
01.1998 - 12.1999
Bachelor of Science - Mathematics
University of South Carolina