Project Test Cases

Patti Rice

**** ************ ***

Charlotte, N. C. 28205

Home: 980-***-****

Cell : 704-***-****

**********@*******.***

*******@*****.***

Professional Profile

Excellent Analytical Skills combined with proven business and technical expertise in the Financial Services

Industry. Experience working in the main-frame, midrange, internet and intranet environments with

commercial and consumer banking applications. Self Starter, Excellent Researcher, Flexible.

Expertise

Business Requirements Definition

Business Process Analysis

Project Management/SDLC -Agile

Technical Specifications

Data Mapping source/target

Test Case Development and Reporting

Test strategy – Unit, System and UAT

Education/Certifications

B. S. Finance University of South Carolina

Certified Cash Manager (CCM)

Automated Clearinghouse Professional (AAP)

OCPDBA 8i, 9i

Life Insurance License N. C.

Passed CISA exam 2004

Passed CAPM exam 2009

Software

Access, Excel, Outlook, Power Point, Word

MQ, AIX, Sybase, OAG messaging, Oracle, Html, SQL, Tacl, Enform,

TSO, DB2, CICS, XML, Endeavor

Test Director, Bugzilla,

Pep Plus, Swift Alliance, Metavante, Sungard, Tsys, Actimize, Smart Stream, SBO

EXPERIENCE

W ells Fargo 10/14 – Jan/15

Process Analyst for Smartstream Installation

W ork with Broadridge data elements (Collateral) assist in mapping of standard

Cash message

Coordinate with System Architecture on final Architecture design/requirements for FSD Document

Assist will Installation of Software on test servers, coordinate MQ setup/connectivity

Attend Project Team meetings and work sessions as required

Prepare BRD, FSD documentation

Bank of America – 2/12 – 7/13, 11/13 –10/14

Lead Analyst working on the Countrywide Financial Settlement and Streamlined Servicer

Technology Initiative projects (5 sub initiatives

Lead Analyst Reserves Project

Lead Analyst on Default file consolidation project Updated BRD as appropriate/Obtain signoff from

Sr. Management

Lead Analyst on Liquidation Rules project for Investor Asset Management

Lead Analyst for ACH/Wire interface Project for Investor Asset Management

Create BRD’s for Default File consolidation

Created HLD/LLD design document’s/Obtain Signoff from Sr. Management

Led detailed Data mapping sessions for multiple applications for New Loan Boarding and

Data Consistency, and Mortgage Servicer Remittance, Payment and Rate History Files / Default

File Consolidation/Assisted in Table Definition.

Researched Data issues between applications/Derive common definitions for Data elements

Provided Business/Technical expertise to Enterprise Test teams in test planning, data

requirements and execution

Facilitated Resolution of Testing Data Issues

Provided weekly status reporting

Assisted PM/TDM with resource utilization estimation

Maintained Project Sharepoint Site

W orked with Vendor on system specifications for SBO

Coordinated Vendor software delivery/installations and migrations where required.

GE Capital –. 12/11 – 2/12 Norwalk, Conn.

Business Analyst- Demand Note conversion to BNYMellon (Iflex)

W orked with BNY Mellon and GE technical staff on Middleware message mapping between

GE Capital’s On Line system and BNY Mellon for Interest Plus products

W ork with BNY Mellon staff on AML conversion requirements(Actimize)

Reviewed AML Database structure/ compared US and European

Business Processes. Discussed initial interface between Hotscan and Actimize

Participated in Online screen design reviews for New Account Opening and Custom er Service

W orkflows

W rote Business Payments process document explaining the clearing timing differences based on

payment receipt and GE/BNY distribution windows

TIAA CREF 6/11-8/11 Charlotte NC

Business Analyst

Participate in Requirements Review for Signoff

Participate in Project scope review

Develop functional design for the following areas:

Receipt of ACH insurance premiums from the insurance adjudicator

Establishment of ACH functionality for Voluntary VEBA EE account contributions

Transfers and Allocations from VEBA accounts to Plan defined Mutual Funds

Participant support services using Service Center Phone and ATS functionality

Other related items based on the requirements traceability matrix, (Insurance Qualified medical

expenses, equity wash rules)

Capital One 01/11- 04/11 Richmond VA

Business Analyst – Sweeps, Escrow, integrated payables

Participate in RFP for Escrow and Sweeps Improvement projects

Facilitate review of Functional/ Non Functional Requirements

Coordinated with Project Management, Procurement and Architecture to draft the RFP

W rite Business Requirements

W rite System Requirements

Load Requirements Documents to Quality Center

Provide Traceability for Requirements in Quality Center

Bank of America – 09/09 – 12/10 Charlotte NC

Business Analyst- Payments Rewrite

Review Payments Model with Business Process Team/Identify Order of Process flow

Review Services Definition/Align with BPM terminology

Participate In Vendor Requirements Reviews

Review Use Cases and Identified Services

Attend regularly scheduled Project Team Meetings

Uploaded documents to Sharepoint sites

W rote Lead page for Payments Rewrite group for Sharepoint Site

Migrated pertinent documents to our internal sharepoint site to provide Internal Reference’s for the

project

Lead Bank Directory Project

Schedule Team meetings

Manage Project Plan/Task List

Resolve Project Issues

Provide Business/Technical assistance to team members

Coordinate with Test Teams

Manage Vendor Defect process

Provide Weekly Reports to Vendor

TDBankNorth – 11/08 – 05/09 Lewiston Maine

Project Manager - International ACH Transactions (EFT)

Coordinate Software Delivery Installs with Vendor

Manage Project Plan

Provide Project Status to Technical Management

Facilitate Project Team Meetings/Document Me eting Minutes

Maintain Project Action Items Log/Watch items

Map New Product Data to Interface Requirements/Create Technical Specifications

(This involved the new IAT entry detail and addenda information)

Review Monthly Resource Utilization

Present Operational Readiness Overview to Senior Management

Plan Implementation Activities

Coordinate with Downstream applications and conversion teams as required

Coordinate change control approvals

Bank of America 03/03/08 to 10/31/08 Charlotte N. C.

Technical Delivery Manager/Lead

Corporate Deposits Conversion (TDM)

Managed Monthly TPST expenses/coordinate quarterly updates

Provided Weekly status reports

Updated Corporate Status Websites as required(Dependency/Detar/Clarity)

Coordinated with Systems Engineering to Design/Build IMS Databases for Authorization functions

for ARP/Teller Positive Pay

Coordinated Cit Testing for Deposits conversion

Provided Requirements for Decommission process

Attended other project team meetings as required (Autoborrow, Receivables, Sweep, Image

Statements)

W orked with CRM group on IDS Data Mapping issues for TM/Branch Assignment

Nationwide Returns and Adjustments (TDL)

Mapped Business Requirements to High/Low level design documents

Maintained Tar Listings

Facilitated Team Meetings

Participated in Sit planning

Attend Meetings as requested as Business/Technical consultant

W TX Conversion (TDL)

Participate in W ire Transfer conversion meetings

Research Project Dependencies(Cash Pro, Global Plus, Swift, BFT,AFS, EDI, Vector 8,ACBS)

Facilitate Issue Resolution(Wire Investigations, Nice Installation)

Map CTQ’s/Business Requirements in Caliber

Monitor Vendor Payments

Annual Swift Upgrade (TDM)

Managed Monthly TPST expenses/coordinate quarterly updates

Provided Weekly status reports

Participate in US and EMEA team meetings as required.

Coordinate implementation of New MQ test environment

Manage Sit Testing/Defect tracking

W achovia 12/07 – 02/008 Charlotte N. C.

Consultant/Business Analyst

Analyzed Business Requirements for Basel Initiatives(Legal Entity Identifier, Credit Initiatives)

Assessed Business Requirements against Risk Data Policy

Reviewed Tools for implementation of Master Data Management

Reviewed Unique Customer ID Governance Process(basel)

General Dynamics 08/07 – 11/07 Greensboro N. C.

Business Analyst

Assisted in Peoplesoft to Unanet conversion activities

Maintained Peoplesoft to Unanet Interface Requirements Documentation

Created and Updated Change Control activities using Bugzilla

Reviewed Other Interace documents as required(oracle project, Peoplesoft Interface, Deltak

financials)

Royal Bank Canada- Centura 05/07 – 07/07 Rocky Mt. N. C.

Business Systems Analyst

Analyze Visio workflows, test cases in Test director for Fidelity Sales and Service, Empower

Expand Test cases to be inclusive of all conditions

W rite Automated Test scripts for Test Director/Compuware Automated Testing Tool

Research and document defects/Retest in Subsequent Releases

Analyze CRM Business Requirements for Current and Prospect Customers

W achovia Corporation 02/06 – 12/06 Charlotte, N. C.

Risk Consultant/Business Analysis –Securities Lending

Contribute to Statement of Work/Business Requirements Documents

Analyzed Transactions on Sungard’s ALDOP and Loanet applications.

Schedule and/or Participate in W eekly Status Meetings/Document Minutes/Tasks.

Participate in Agent Lending Industry Meetings concerning Business and Testing issues led by

Capco Consulting.

Reviewed and Analyzed Transactions in the Alvin Application to develop/test/ and implement

system changes addressing Principal Lender Relationship information

Configure Loanet, Alvin, and Aldop Applications

Coordinate UAT Testing/Production Implementation with Agent Lenders/Internal applications.

Provided Weekly Status of Test Results/Issues

Research Exceptions in Loanet, Alvin, and Aldop as required. Coordinate Changes with Agent

Lenders or Brokers.

Extracted Data from the Alvin Database (Relational) using Access. Developed Spreadsheet

formats (Vlookup) which facilitated the reconciliation of the Alvin Principal Lender Database Status

to Aldop Application Principal Lender Status.

Document Workflow using Visio

W orked with AML staff to Reduce processing inefficiencies

W rote Procedural Manual for Agent Lending Alvin Application and Interfaces(AML.OFAC)

Coordinated Vendor Security Assessment and On Site Visit(Sarbanes-Oxley sas70)

Participated in Risk Assessment Process(ARS) for Securities Lending activities

Participated in Basel Credit Risks meeting(initial assessment)

Lowes Corporation- 09/05 – 02/06 Mooresville, N. C.

Business Analyst

Define Requirements/Business Rules for product components

W orked with the DIY Design Tool to identify core and extended Attributes

Maintain/Report Issues in Excel format

Define/Coordinate Test System Issues

Test/Verify XML formatted message and other delivery API’s

Evergreen Investments- 09/04 – 12/04 Charlotte, N. C.

Project Coordinator

Participated as a Business Analyst in the conversion of Custodial Assets from Kaplan to Evergreen

Investments. This involved the Coordination with external Custodians to:

Identify Conversion Requirements.

Define/Document Custodial Relationships, Confirm Accounts, On-line Access

Define Data Map/Reformat Message Data from third party vendor

Verify Processing of Swift Messages – MT535,536,537,541,543,950,

Verification of the Account Reconciliation process

Fannie Mae- 05/04- 07/04 Herndon, VA

Business Analyst

Reviewed Requirements and Analyzed Business Processes for the DMS application.

Developed Screen Specifications. Updated Existing Use Cases and verified screen element to

existing Oracle Table structures. Stored Documents in Clearcase

Maintained and Developed Test Condition Matrices Using Test Director/Documents were Exported

to Excel, Updated and Imported to Access. Analyzed Component Test Cases in Test Director for Use

in Integrated and User Acceptance Testing

Reviewed existing Clearquest exceptions/updated status

Capital One- 9/2003- 1/31/2004 Richmond VA.

Consultant/Testing Manager

Analyze Visio Workflow Documentation to determine Test Cases required for Deposit System

Conversion with an External Vendor. This included Configuration, Business Processes, and

W eb/Desktop Interfaces.

Develop Testing Status Metrics Reports using Test Director Analysis functions.

Imported Excel or Word Test Cases into Test Director. Organize Test cases by Function or

Application.

Scheduled Testing over the Testing Cycle

Executed Test Cases. Updated Mainframe Control File Parameters as required.

Investor's Bank and Trust 9/2002-12/2002 Boston MA

Consultant/Traded Products Support – Mutual Funds

Functional/Technical Business Consultant - Traded Products Support Area.

Supported Delivery of Financial Messages for Capital Markets Middleware Applications from

External/Internal Sources to Oracle Databases (relational) and subsequently exported to the

appropriate Financial Management Workstations to calculate the daily NAV.

W orked with Financial Managers to Analyze Swift Message content (MT535, 540-

543,200,210,900,910,950,548,564), for Compliance, Posting Errors and timeliness of trade data.

Provided additional research support to Asset Management/Trust Backoffice Operations as

requested.

NationsBank/Bank of America - 1/94-8/01 Charlotte, N. C.

Senior Business Analyst for Middleware Solutions Group

Determined Web client requirements, researched Legacy applications to identify data elements

requested by clients. (Cobol copybooks, vendor Xml docs) Documented Message Specifications

for interfaces between the Corporate Web Sites and Legacy applications using excel or word,

(Customer, Account systems on the mainframe)

for Commercial Loans, ATM, Credit Cards(TSYS) and Fidelity.

Presented Message Specifications to Technical staff in the form of a Data mapping document,

coordinated updates to Middleware Message database and creation of C++ or Java objects.

Created test cases in an access database. Performed message certification through the Unit and

System testing phases prior to turnover for user acceptance testing.

W orked with Internal Settlements Team to determine process for Card Based Transactions

received through external networks(EFT).

Supported User Acceptance testing through various technical platforms. (Web, MQ connections,

Legacy application Systems) by providing a central point for Escalation and the subsequent error

resolution.

Senior Business Analyst for Bass Project Team (LRM Chargeoffs and Fraud)

W orked with Liability Risk Management Users to determine Business Requirements.

Provided Requirements Documentation to Senior Managers for Review and Signoff.

Assisted in technical research efforts to identify the required Data from Legacy Applications for

incorporation into the LRM Sybase relational databases. Presented requirements /Data Mapping to

Middleware and Component Broker representatives (word).

Performed End to End Liability Risk Management unit and system testing (Web client through the

Sybase table updates and posting to the mainframe applications. Utilized ODBC connection to

Sybase tables, executed Sql updates to se t test conditions as required).

Coordinated User Acceptance testing which involved identifying and reserving test accounts,

setting test conditions on accounts, and coordinating MQ routing to the proper test region with the

proper test groups. Assisted in User acceptance error resolution end to end.

Scheduled production integration. Certified Production Implementation

Business Analyst-Foreign Exchange

Project Leader for Memo Post, Transaction Exchange (Financial delivery) and Oasis (FX Options)

interface projects. Authored Business Requirements and Test plans.

Lead Analyst for the Boatman’s merger for IAS/IAE DDA Conversion

Lead Analyst for the NCC Corporate Customer conversion (involved identifying/classifying

customer product lines by matching Mainframe Customer DB Extracts to Tandem FX database

extracts / use of access databases for sorting and categorizing data. Data was exported to excel

and provided to Treasury Management.

Provided Analysis Support to FX Operations Projects to Clean up conv ersion database.

This involved writing specific Tandem Enform extracts for specific customer address and

settlement data (array), importing, analyzing and sorting the data in access, and subsequently

exporting the data in Excel format.) The information ass isted in the development of operational

standards as well as eliminating unnecessary accounts

W orked with All transaction interfaces for Trading floor, Deposits, Fedwire, and Swift. Swift

Message types MT 300, 304, 100,110,200,210,950.

Supported Operations and Processing of Euro Loans and Deposits Taken and Placed

Participated in Automation of FX Draft processing (Nationsbank and Bank of America)

Lead Analyst for All Merger and Conversion activity related to Bank Mergers which involved

conversion of Spot and Forward Trade portfolios, integration of Corporate and Retail processing

Lead Analyst for Year end close out of FX positions for Financial Reporting

Provided support to Correspondent banking, Investments, Foreign collections groups as required.

Facilitated the resolution of complex customer issues related to Foreign Exchange Trading. (e. g.

settlement, confirmation, reporting, file delivery).

First Union National Bank - 01/84-12/93 Charlotte, N. C.

Business Systems Analyst

Provided Business and Technical Requirements Definition to the ACH/Invision Interface Project.

The ACH project involved accessing the Pep Plus warehouse and the development of the

appropriate CICS, DB2 programs to extract Origination and Return detail transaction data for

Customer reports.

Performed technical programming, testing and Implementation for the ZBA/Controlled

Disbursement Project. This assignment involved the coding and testing of CICS, DB2 programs

and the End to End System/Integration testing of the Invision Customer interfaces.

Led the ACH merger efforts through the Northwestern and South Carolina Mergers. Coordinated all

technical upgrades to the vendor software.

W orked closely with Product Managers to coordinate Operational /Software changes

to support corporate customer requests and required regulatory changes. Scheduled Monthly

meetings/documented minutes and planned monthly releases.

Planned and Participated in Disaster Recovery process for ACH at Comdisco Remote

DR Site. Procedures were verified to Test execution and amended as required.

Contact this candidate