QA Analyst at First Niagara Bank- Developed test scripts to ensure enhancements implemented to ACBS behaved as expected based on review of business requirement documentation- Executed test scripts and documented results- Managed test plan execution in ALM, including exported test scripts from Excel, tracked execution status & logged defects - Reviewed Quality Assurance test plans

Business Analyst in Equipment Finance Group- Analyzed current state processes & business rules with a goal of providing recommendations for future improvements to be implemented in a new leasing origination system- Team member of a project to implement a leasing origination system (Rapport) including requirements gathering, documentation, solution design, configuration, testing & defect resolutionBusiness Analyst in Treasury & Balance Sheet Management - Created data dictionary & use cases to document business rules & process for data staging database used to load current position and cash flow data into a model for stress testing & net interest income analysis- Interacted routinely with business partners in troubleshooting issues during stress testing run by analyzing data via SQL queries; tracked changes and updated documentation- Translated ALM related business requirements into design documentation for development- Created BRD for Treasury Data Mart reporting, including extracts to support populating securities related schedules in the call report and stress testingBusiness Analyst in Data Mart Support Unit - Defined & collaborated with developers on Business Objects Universe reporting requirements- Supported LOB during Universe testing; researched issues by querying data and communication resolution- Owned & maintained source to target mapping document including business logic for calculated fields

Business Analyst at Bank of AmericaProject team member of an automated conversion where both source & target system was ACBSCreated & presented conversion design documents to team members & business partnersAssisted with building & testing various inbound & outbound ACBS interfaces Played a key role in analyzing conversion data by querying data via Access and investigating discrepancies Wrote & executed test cases, documented defects, along with supported business users during UATGathered, documented & tested requirements related to expanding a GL interfacing field within ACBS

Business Analyst at TD Bank Assisted with data mapping 3 source systems (ACBS, CLSC & LeaseWorks) to a dimensional data mart model

Business Analyst at Bank of AmericaProject team member of an automated conversion from AFS to ACBSPlayed a key role in analyzing conversion data by querying data and investigating discrepancies Facilitated scrubbing data on source system to reduce conversion related defects

Project team member for both manual and automated conversions to ACBS over multiple lines of business Facilitated wing-to-wing UAT activities including user access, application support, writing & executing test case and documenting resultsTrained project team resources, Operations staff and Account Managers on ACBS & effectively provided production supportInstrumental in developing the ACBS procedures manual that served as the framework for Standard Operating Procedures for Operations

Developed an automated portfolio trends package for Senior Management by building an Access database and using Hyperion to capture data, which resulted in approximately 40 hours time savings per month in preparation and analysisPrepared monthly financial reporting packages and discretionary financial reports for individual business units, including analysis of financial, portfolio and new business trends