Rebecca is available for hire
Hire RebeccaRebecca Doherty
Verified Expert in Engineering
Fiserv Developer
Concord, CA, United States
Toptal member since February 5, 2025
Bio
Rebecca is a developer with over 20 years of experience in information systems and compliance within the banking and finance industries. She has performed functional analysis for various data mapping and analysis projects—Hogan, Fiserv, FIS—ranging from upgrades of existing systems and conversions of newly acquired banks to new installations. With a proven track record in data mapping and extraction for conversions, Rebecca has documented functional specifications for conversions and upgrades.
Portfolio
Silicon Valley Bank
Analysis, SQL, Microsoft, Jira, SharePoint, Confluence, Fiserv
First Republic Bank
Analysis, SQL, Microsoft, Fiserv, FIS Deposits, FIS Time Deposits...
Bank of the West
Analysis, SQL, Windows, FIS Deposits, FIS Time Deposits...
Experience
- Analysis - 20 years
- SQL - 15 years
- User Acceptance Testing (UAT) - 15 years
- SharePoint - 10 years
- FX Wire Data - 10 years
- FDIC reporting - 10 years
- Disaster Recovery Plans (DRP) - 10 years
- Fiserv - 8 years
Availability
Part-time
Preferred Environment
Windows, SQL, Microsoft
The most amazing...
...thing I've done is relate technical information to end users, earning praise from colleagues for clear and understandable explanations.
Work Experience
Senior Data Analyst
2023 - 2024
Silicon Valley Bank
- Mapped data from Fiserv lending to the new in-house application for FDIC shared loss agreement (SLA) reporting.
- Employed SQL to mine and analyze lending data in the data warehouse, developing moderately complex SQL queries spanning various databases.
- Documented data mapping from Fiserv and translated it into usable end-user information.
- Collaborated with developers, business subject matter experts, Fiserv vendors, and data analysts to create detailed mapping documents.
Technologies: Analysis, SQL, Microsoft, Jira, SharePoint, Confluence, Fiserv
Senior Business System Analyst
2014 - 2023
First Republic Bank
- Performed BSA/AML data mapping for the Actimize system upgrade and maintenance, utilizing SQL and Excel.
- Engaged various teams in data mapping Fiserv data for transaction ingestion into the Actimize system using Agile methodology.
- Developed documentation for the complete transaction set used by the bank for all Fiserv Digital Document Advantage (DDA), lending, CD, IRA, FX wires (using Spectrum), domestic wires, and Treasury transactions.
- Utilized SQL to mine and analyze deposit and lending data in the data warehouse for in-house reporting, trend analysis, KDE reporting, and government compliance reporting, i.e., Regulation C, Regulation DD, Regulation E, etc.
- Managed all aspects of the enterprise Fiserv Teller system, including user support, troubleshooting, upgrades, modifications, improvements to user functionality, and conversion to the new system.
- Performed FDIC call report data collection and reconfigured reporting system to function with Fiserv deposit system data.
- Facilitated data coordination between old and new deposit system teams throughout the conversion process, ensuring the documentation of data mapping to uphold data relevance.
- Served as a business analyst overseeing automated processes, focusing on report generation and review to streamline pertinent items, minimize unnecessary system interactions, and enhance the end-user experience.
Technologies: Analysis, SQL, Microsoft, Fiserv, FIS Deposits, FIS Time Deposits, FDIC reporting, FX Wire Data, Disaster Recovery Plans (DRP)
Senior Business System Analyst
2009 - 2012
Bank of the West
- Managed, evaluated, and coordinated all environments for the web-based applications on the .NET platform for FIS sales, service, and teller activities, encompassing testing, training, disaster recovery, and production.
- Coordinated user acceptance tests for field users and back office testers during FIS TouchPoint sales and service development and implementation phases.
- Coordinated daily support for the FIS cross-enterprise customer relationship management (CRM), account maintenance, and teller systems.
Technologies: Analysis, SQL, Windows, FIS Deposits, FIS Time Deposits, User Acceptance Testing (UAT), Customer Relationship Management (CRM), Disaster Recovery Plans (DRP)
Senior Business Analyst
2007 - 2009
Charles Schwab
- Led the cross-enterprise, cross-affiliate project as the lead business analyst, overseeing the analysis, Vision document creation, and development of use case materials, wireframes, and requirements matrix.
- Coordinated and drafted use cases for cashiering platform migration and enhancements, including internal transfers, FX and domestic wires, and incoming check cashiering while serving as a senior business analyst.
- Facilitated the Program Business Analyst Forum to ensure documentation uniformity across projects, assisting other business analysts and evaluating each project's impact.
- Coordinated user acceptance testing (UAT) for outgoing check cashiering application, including test script writing, distribution, and collecting and reporting results.
- Led flow analysis, devised UAT strategy and plans, analyzed tests, and oversaw the parallel implementation of the stale price securities data project across multiple systems as a senior business analyst.
Technologies: Analysis, Microsoft, Disaster Recovery Plans (DRP), FDIC reporting
Experience
Research on Forex Wires
Discovered that many foreign exchange wires were not being monitored properly in the AML process. I thoroughly reviewed each transaction code and its transmission origin with the associated data, reported the problem discovered to management, and proposed a remapping resolution to remediate the issue in the future. I also proposed review parameters for a "look back" period.
RESULT
The business self-disclosed to federal regulators the issue before the audit, granting the business a more favorable review.
RESULT
The business self-disclosed to federal regulators the issue before the audit, granting the business a more favorable review.
No More Access Database
Having been given the responsibility of federal reporting, I challenged the status quo mindset by:
• Transforming reporting into SQL queries.
• Redesigning the reporting form to source data dynamically.
• Shortening the sign-off process to four days from the previous 14-day cycle.
RESULT
After a couple of cycles, the end user and form signer began noticing a distinct change. Subsequently, other departments responsible for providing reporting information were assigned the same streamlined process.
• Transforming reporting into SQL queries.
• Redesigning the reporting form to source data dynamically.
• Shortening the sign-off process to four days from the previous 14-day cycle.
RESULT
After a couple of cycles, the end user and form signer began noticing a distinct change. Subsequently, other departments responsible for providing reporting information were assigned the same streamlined process.
Education
1982 - 1984
Bachelor's Degree in Physics
Rochester Institute of Technology - Rochester, NY, USA
1979 - 1981
Associate's Degree in Mathematics and Computer Science
Jamestown Community College - Jamestown, NY, USA
Skills
Tools
Jira, Confluence
Languages
SQL, Fortran
Paradigms
User Acceptance Testing (UAT)
Platforms
SharePoint, Windows, Microsoft
Other
Analysis, Fiserv, FDIC reporting, Disaster Recovery Plans (DRP), Scientific Data Analysis, FIS Deposits, FIS Time Deposits, FX Wire Data, Customer Relationship Management (CRM), Physics, COBOL Batch
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring